Brief discussion of stmt and rs in database operations

One stmt can only bind one result set at the same time. If you want to create multiple result sets, you need to create multiple STMT at the same time. If you define stmt in bean, it will involve a technical issue of development, you can use the following methods to enhance program portability.
Define Connection as a member variable.
But stmt is defined as the local variable in the method, so that this method is called every time.
A new stmt will be generated.
Class DBBean {Connection conn; DBBean () throws SQLException {conn = .............} public ResultSet query (String SQL) throws SQLException {Statement stmt = ............... resultSet rs = stmt.exe cuteQuery (SQL); return rs ;}}