Brief discussion on stmt and RS in database operation

Data | Database A stmt can bind only one result set at a time, if you want to set up multiple result sets, you have to build multiple stmt. If you define stmt in a bean, it involves a technical issue of development, and you can use the following methods to enhance the portability of the program.
Define the connection as a member variable.
But define the stmt as a local variable in the method so that each time this method is invoked
will produce a new stmt.

Class dbbean{Connection Conn; Dbbean () throws SQLException {conn= ...} public ResultSet query (String sql) throws SQLException {Statement St Mt = ......... ResultSet rs = stmt.executequery (SQL); Return RS; }}