Content deleted Content added
→See also: Adding link to orphaned article, Wikiproject Orphanage: You can help! |
m linking |
||
Line 43:
JDBC ('Java Database Connectivity') allows multiple implementations to exist and be used by the same application. The API provides a mechanism for dynamically loading the correct Java packages and registering them with the JDBC Driver Manager. The Driver Manager is used as a connection factory for creating JDBC connections.
JDBC connections support creating and executing statements. These may be update statements such as SQL's [[Create (SQL)|CREATE]], [[Insert (SQL)|INSERT]], [[Update (SQL)|UPDATE]] and [[Delete (SQL)|DELETE]], or they may be query statements such as [[Select (SQL)|SELECT]]. Additionally, stored procedures may be invoked through a JDBC connection. JDBC represents statements using one of the following classes:
* {{Javadoc:SE|java/sql|Statement}} – the statement is sent to the database server each and every time.
* {{Javadoc:SE|java/sql|PreparedStatement}} – the statement is cached and then the [[Query plan|execution path]] is pre-determined on the database server allowing it to be executed multiple times in an efficient manner.
|