java jdbc 批处理详解,Java的JDBC批处理

代码示例：

import java.sql.*;

public class preparedAdd {

public static void main(String[] args)throws Exception {

//第一个例子：

Connection con=null;

PreparedStatement pst=null;

new com.mysql.jdbc.Driver();

con=DriverManager.getConnection("jdbc:mysql://127.0.0.1:3306/myfirstdb","root","2490248");

pst=con.prepareStatement("insert into dept values(?,?,?)");

pst.setInt(1, 17);

pst.setString(2, "马子");

pst.setString(3, "巡检");

pst.executeUpdate();

pst.setInt(1, 18);

pst.setString(2,"网吧");

pst.setString(3,"驴子");

pst.executeUpdate();

pst.setInt(1, 19);

pst.setString(2, "骡子");

pst.setString(3, "骡子");

pst.executeUpdate();

pst.close();

con.close();

//第二个例子：

Connection con=null;

Statement st=null;

new com.mysql.jdbc.Driver();

con=DriverManager.getConnection("jdbc:mysql://127.0.0.1:3306/myfirstdb","root","2490248");

st=con.createStatement();

st.addBatch("insert into dept values(14,'在','的')");

st.addBatch("insert into dept values('15','A','AA')");

st.addBatch("insert into dept values(16,'B','BB')");

st.executeBatch();

st.close();

con.close();

}

}