JDBC Connection database code and procedures in full Java development

2. JDBC Connection Database
4. ? Create a program that connects to the database in JDBC with 7 steps:
6. 1. Load the JDBC driver:
8. Before connecting to the database, first load the driver of the database you want to connect to the JVM (Java Virtual machine),
10. This is achieved through the static method forname (String className) of the Java.lang.Class class.
12. For example:
14. Try {
16. //Load the MySQL driver class
18. Class.forName ("Com.mysql.jdbc.Driver");
20. }catch(ClassNotFoundException e) {
22. System.out.println ("Driver class not found, load driver failed!")   ");
24. E.printstacktrace ();
26. }
28. After a successful load, an instance of the driver class is registered in the DriverManager class.
30. 2. Provide the URL of the JDBC connection
32. ? The connection URL defines the protocol, sub-protocol, and data source identity when the database is connected.
34. Writing form: Protocol: Sub-Protocol: Data source identification
36. Protocol: Always start with JDBC in JDBC
38. Sub-Protocol: A bridge-connected driver or database management system name.
40. Data source identification: The tag locates the address of the database source and the connection port.
42. For example: (MySQL connection URL)
44. Jdbc:mysql:
46. //LOCALHOST:3306/TEST?USEUNICODE=TRUE&CHARACTERENCODING=GBK;    
48. Useunicode=true: Indicates the use of the Unicode character set. If Characterencoding is set to
50. gb2312 or GBK, this parameter must be set to true . CHARACTERENCODING=GBK: The character encoding method.
52. 3. Create a connection to the database
54. To connect to a database, you need to request and obtain a connection object from Java.sql.DriverManager.
56. The object represents a connection to a database.
58. ? Using the DriverManager getconnectin (string URL, string username,
60. String password) method to pass in the path to the specified database to be connected, the user name of the database, and
62. Password to get it.
64. For example:
66. //Connect MySQL database, username and password are root
68. String url = "Jdbc:mysql://localhost:3306/test";
70. String username = "root";
72. String Password = "root";
74. Try {
76. Connection con =
78. Drivermanager.getconnection (URL, username, password);
80. }catch(SQLException se) {
82. SYSTEM.OUT.PRINTLN ("Database connection failed!   ");
84. Se.printstacktrace ();
86. }
88. 4. Create a statement
90. To execute an SQL statement, you must obtain an java.sql.Statement instance that is divided into the following 3 statement instances
92. Type of:
94. 1. Execute static SQL statements.   Typically implemented through statement instances.
96. 2. Execute dynamic SQL statements.   Typically implemented through PreparedStatement instances.
98. 3. Execute the database stored procedure.   Typically implemented through CallableStatement instances.
100. The specific implementation method:
102. Statement stmt = Con.createstatement ();
104. PreparedStatement pstmt = con.preparestatement (sql);
106. CallableStatement cstmt =
108. Con.preparecall ("{Call Demosp (?,?)}");
110. 5. Execute SQL statements
112. The statement interface provides three ways to execute SQL statements: ExecuteQuery, executeupdate
114. and execute
116. 1, ResultSet executeQuery (String sqlString): Execute SQL statement that queries the database
118. A result set (ResultSet) object is returned.
120. 2,int executeupdate (String sqlString): Used to perform INSERT, update, or
122. Delete statements and SQL DDL statements, such as CREATE table and drop table
124. 3. Execute (sqlString): Used to perform a return of multiple result sets, multiple update counts, or a combination of the two
126. Statement.
128. Specific implementation code:
130. ResultSet rs = stmt.executequery ("SELECT * from ...");
132. int rows = stmt.executeupdate ("INSERT into ...");
134. boolean flag = Stmt.execute (String sql);
136. 6. Processing Results
138. Two cases:
140. 1. The number of records affected by this operation is returned by performing the update.
142. 2. The result of executing the query returned is a ResultSet object.
144. ? ResultSet contains all rows that conform to the conditions in the SQL statement, and it provides a set of get methods for these
146. Access to the data in the row.
148. ? Get data using the access method of the result set (ResultSet) object:
150. while (Rs.next ()) {
152. String name = rs.getstring ("name");
154. String pass = rs.getstring (1); //This method is more efficient
156. }
158. (columns are numbered from left to right and start with column 1)
160. 7. Close the JDBC object
162. All JDBC objects used are closed after the operation is complete to release the JDBC resource, turn off order harmony
164. The opposite of the Ming Order:
166. 1. Close record set
168. 2. Closing the statement
170. 3. Close the Connection object
172. if (rs! = null) { //close recordset
174. Try {
176. Rs.close ();
178. }catch(SQLException e) {
180. E.printstacktrace ();
182. }
184. }
186. if (stmt! = null) { //close declaration
188. Try {
190. Stmt.close ();
192. }catch(SQLException e) {
194. E.printstacktrace ();
196. }
198. }
200. if (conn! = null) { //Close Connection object
202. Try {
204. Conn.close ();
206. }catch(SQLException e) {
208. E.printstacktrace ();
210. }
212. }

JDBC Connection database code and procedures in full Java development