JDBC Advanced PreparedStatement Execute SQL statement (MySQL)

first, what is PreparedStatementIn the Java API documentation, we can see that PreparedStatement is the statement sub-interface () object that represents the precompiled SQL statement, and the SQL statement is precompiled and stored in the PreparedStatementObject. You can then use this object to execute the statement efficiently several times. second, by PreparedStatement get parameters executed on the Run command line, insert parameters into a datasheetThe relevant experimental process, including the pre-creation of the database required by the program, the creation of the required data tables, load driver packages in the development environment, etc., can refer to the previous article "JDBC Connection MySQL Database and example" (go to the article) the specific code is as follows: [Java]View Plaincopy

2. Package COM.SEREIN.JDBC;
6. Import java.sql.*;
10. Public class Preparedstatemettest {
14. public static void Main (string[] args) {
18. //Check if the command line has enough 7 parameters
20. if (args.length! = 7) {
22. System.out.println ("Parameter error! Please Input again! ");
24. System.exit (-1);
26. }
30. //program gets 7 parameter values in the run stack
32. String name = args[0];
34. int age = 0;
36. try {
38. Age = Integer.parseint (args[1]);
40. } catch (NumberFormatException e) {
42. System.out.println ("Parameter error! Age should is number format! ");
44. System.exit (-1);
46. }
50. String sex = args[2];
52. String address = args[3];
54. String depart = args[4];
58. int worklen = 0;
60. try {
62. Worklen = Integer.parseint (args[5]);
64. } catch (NumberFormatException e) {
66. System.out.println ("Parameter error! Worklen should be number format! ");
68. System.exit (-1);
70. }
74. int wage = 0;
76. try {
78. Wage = Integer.parseint (args[6]);
80. } catch (NumberFormatException e) {
82. System.out.println ("Parameter error! Wage should be number format! ");
84. System.exit (-1);
86. }
90. //Create PreparedStatement object
92. PreparedStatement pstmt = null;
94. //Create Connection object
96. Connection conn = null;
100. //Connect to the database and insert data
102. try {
104. //Load MySQL Driver instance, provides two methods, is equivalent
106. Class.forName ("Com.mysql.jdbc.Driver");
108. //new oracle.jdbc.driver.OracleDriver ();
112. //Establish connection
114. conn = Drivermanager.getconnection ("Jdbc:mysql://localhost:3306/myuser", "root", " root");
118. //Use the PreparedStatement object to build and execute the SQL statement, 7 question marks represent the values that are pre-reserved for 7 fields
120. pstmt = Conn.preparestatement ("INSERT into the staff (name, age, Sex,address, Depart, Worklen,wage) VALUES (?,?,?,?,?, ?, ?)");  
124. //Use the Set method in the PreparedStatement object to set the specific value of the insertion
126. Pstmt.setstring (1, name);
128. Pstmt.setint (2, age);
130. Pstmt.setstring (3, sex);
132. Pstmt.setstring (4,address);
134. Pstmt.setstring (5, Depart);
136. Pstmt.setint (6, Worklen);
138. Pstmt.setint (7, wage);
140. Pstmt.executeupdate ();
144. //Insert Success Prompt
146. System.out.print ("successfully insert a data record!  ");
150. //Capture driver Load Failure exception
152. } catch (ClassNotFoundException e) {
154. E.printstacktrace ();
158. //Capture SQL statement execution failure exception
160. } catch (SQLException e) {
162. E.printstacktrace ();
164. //restore variable initial value
166. } finally {
168. try {
170. if (pstmt! = null) {
172. Pstmt.close ();
174. PSTMT = null;
176. }
178. if (conn! = null) {
180. Conn.close ();
182. conn = null;
184. }
186. //Catch SQL exception
188. } catch (SQLException e) {
190. E.printstacktrace ();
192. }
194. }
196. }
198. }

after writing the code, run the program with parameters as follows:
the input parameters are (can be referenced for modification):Sereinchan
25
M
Guangzhou
Engine
3
5000

View the console console, "Insert a data record successfully!" "：

Check the MySQL database for confirmation:

Completed successfully!

Transferred from: http://blog.csdn.net/cxwen78/article/details/6868941

JDBC Advanced PreparedStatement Execute SQL statement (MySQL)