JDBC: Use batch to process multiple SQL statements (sxt)

JDBC: Use batch to process multiple SQL statements (sxt)

 

Demo

 

1. Import java. SQL .*;
3. Public class testbatch
4. {
6. /**
7. * @ Use batch to process multiple SQL statements
8. */
9. Public static void main (string [] ARGs)
10. {
11. // 1. Do not use preparedstatement
12. /*
13. * Connection conn = NULL; statement stmt = NULL; string url =
14. * "JDBC: mysql: // localhost: 3306/College"; string user = "root"; string
15. * Password = "123456 ";
16. *
17. * Try {class. forname ("com. MySQL. JDBC. Driver"); Conn =
18. * Drivermanager. getconnection (URL, user, password); stmt =
19. * Conn. createstatement (); stmt. addbatch ("insert into user
20. * Values (301, 'go1', '20170', '0') "); stmt. addbatch (" insert into user
21. * Values (302, 'go2 ', '000000', '00') "); stmt. addbatch (" insert into user
22. * Values (303, 'go3', '000000', '000 ')");
23. *
24. * Stmt.exe cutebatch ();
25. *} Catch (classnotfoundexception e) {// todo auto-generated catch
26. * Block E. printstacktrace ();} catch (sqlexception e) {// todo
27. * Auto-generated Catch Block E. printstacktrace ();} finally {try {
28. * If (stmt! = NULL) {stmt. Close (); stmt = NULL;} If (Conn! = NULL ){
29. * Conn. Close (); Conn = NULL;
30. *}
31. *} Catch (sqlexception e) {// todo auto-generated Catch Block
32. * E. printstacktrace ();}}
33. *}
34. */
36. // 2. Use preparedstatement for processing
37. Connection conn = NULL;
38. Preparedstatement pstmt = NULL;
39. String url = "JDBC: mysql: // localhost: 3306/College ";
40. String user = "root ";
41. String Password = "123456 ";
43. Try
44. {
45. Class. forname ("com. MySQL. JDBC. Driver ");
47. Conn = drivermanager. getconnection (URL, user, password );
49. Pstmt = conn. preparestatement ("insert into user values (?,?,?,?) ");
51. Pstmt. setint (1,401 );
52. Pstmt. setstring (2, "goo1 ");
53. Pstmt. setstring (3, "A1 ");
54. Pstmt. setstring (4, "K1 ");
55. Pstmt. addbatch ();
57. Pstmt. setint (1,402 );
58. Pstmt. setstring (2, "goo2 ");
59. Pstmt. setstring (3, "A2 ");
60. Pstmt. setstring (4, "K2 ");
61. Pstmt. addbatch ();
63. Pstmt. setint (1,403 );
64. Pstmt. setstring (2, "goo3 ");
65. Pstmt. setstring (3, "A3 ");
66. Pstmt. setstring (4, "K3 ");
67. Pstmt. addbatch ();
69. Pstmt.exe cutebatch ();
71. } Catch (classnotfoundexception E)
72. {
73. // Todo auto-generated Catch Block
74. E. printstacktrace ();
75. } Catch (sqlexception E)
76. {
77. // Todo auto-generated Catch Block
78. E. printstacktrace ();
79. } Finally
80. {
81. Try
82. {
83. If (pstmt! = NULL)
84. {
85. Pstmt. Close ();
86. Pstmt = NULL;
87. }
88. If (Conn! = NULL)
89. {
90. Conn. Close ();
91. Conn = NULL;
93. }
95. } Catch (sqlexception E)
96. {
97. // Todo auto-generated Catch Block
98. E. printstacktrace ();
99. }
101. }
103. }
105. }