jdbc容器（JDBC container）.docVIP

jdbc容器（JDBC container） The object used to execute the static SQL statement and return the result it generated. By default, each Statement object can open only one ResultSet object at the same time. because This way, if you read a ResultSet Object and read another cross, then the two objects must be generated by different Statement objects. If there is an open current of a statement ResultSet object, and all execution methods in the Statement interface implicitly close it. The Statement object is used to send the SQL statement to the database. In fact, there are three Statement objects that are used as package containers for executing SQL statements on a given connection: Statement, PreparedStatement (inherited from Statement) and CallableStatement (inherited from PreparedStatement). They are all dedicated to sending specific types of SQL statements: The Statement object is used to execute simple SQL statements without arguments; The PreparedStatement object is used to execute pre compiled SQL statements with or without IN parameters; The CallableStatement object is used to execute calls to stored procedures that are already present on the database. The Statement interface provides the basic means of executing statements and obtaining results. The PreparedStatement interface adds methods to handle IN parameters; CallableStatement adds methods to handle OUT parameters. Some DBMS view each statement in stored procedures as separate statements, while others treat the whole process as a composite statement. This difference becomes important when enabling automatic commit, as it affects when to call the commit method. In the former case, each statement is submitted separately; in the latter case, all statements are submitted at once. Static int CLOSE_ALL_RESULTS This constant indicates that all ResultSet objects that have been open before should be closed when calling getMoreResults. Static int CLOSE_CURRENT_RESULT This constant indicates that the current ResultSet object