Java_sql_batch_ Batch Processing

Java JDBC is a two-way sample code for batch processing of SQL statements. The table is the Dept table in the Oracle database, and the exception is throws out in order to see the logical relationship.

1  PackageCom.ayang.jdbc;2 3 ImportJava.sql.*;4 5 6  Public classTestbatch {7 8     //to see the logical relationship, throws out.9      Public Static voidMain (string[] args)throwsException {TenClass.forName ("Oracle.jdbc.driver.OracleDriver"); OneConnection conn = drivermanager.getconnection ("Jdbc:oracle:thin:@127.0.0.1:1521:orcl", "Scott", "Root"); A          -         /** - * Batch processing method one: the          */ -         /*Statement stmt = Conn.createstatement (); - Stmt.addbatch ("INSERT INTO DEPT2 values" (N, ' JAVA ', ' XC ') "); - Stmt.addbatch ("INSERT into DEPT2 values (*, ' PHP ', ' ZZ ')"); + Stmt.addbatch ("INSERT into DEPT2 values (+, ' C + + ', ' Xinyang ')"); -          + Stmt.executebatch (); A stmt.close ();*/ at          -         /** - * Batch processing method two: -          */ -PreparedStatement PS = conn.preparestatement ("INSERT into DEPT2 values (?,?,?)"); -Ps.setint (1, 54); inPs.setstring (2, "haha"); -Ps.setstring (3, "Hangzhou"); to Ps.addbatch (); +           -Ps.setint (1, 55); thePs.setstring (2, "haha"); *Ps.setstring (3, "Hangzhou"); $ Ps.addbatch ();Panax Notoginseng           -Ps.setint (1, 56); thePs.setstring (2, "haha"); +Ps.setstring (3, "Hangzhou"); A Ps.addbatch (); the Ps.executebatch (); + ps.close (); -           $ conn.close (); $  -     } -  the}

Java_sql_batch_ Batch Processing