jdbc 两种方式 批量插入 addBatch

import java.sql.*; public class BatchExecute { public static void main(String[] args) {    String SQLUrl = "jdbc:microsoft:sqlserver://localhost:1433;DatabaseName=Test";    String LoginName = "sa";    String LoginPasswd = "sa";    Connection con = null;    Statement stmt = null;    PreparedStatement pstmt = null;    try {     Class.forName("com.microsoft.jdbc.sqlserver.SQLServerDriver");     con = DriverManager.getConnection(SQLUrl, LoginName, LoginPasswd);     //批量操作数据库: 方法一     stmt = con.createStatement();     stmt.addBatch("insert into UserLogin values('haha7','haha1')");     stmt.addBatch("insert into UserLogin values('haha8','haha2')");     stmt.addBatch("insert into UserLogin values('haha9','haha3')");     stmt.executeBatch();//BatchExecute     stmt.close();     //批量操作数据库:方法二     pstmt = con.prepareStatement("insert into UserLogin values(?,?)");     pstmt.setString(1, "haha4");     pstmt.setString(2, "haha4");     pstmt.addBatch();     pstmt.setString(1, "haha5");     pstmt.setString(2, "haha5");     pstmt.addBatch();     pstmt.setString(1, "haha6");     pstmt.setString(2, "haha6");     pstmt.addBatch();     pstmt.executeBatch();     pstmt.close();     con.close();    } catch (ClassNotFoundException e) {     e.printStackTrace();    } catch (SQLException e) {     e.printStackTrace();    } } }

来自 “ ITPUB博客 ” ，链接：http://blog.itpub.net/10239785/viewspace-664663/，如需转载，请注明出处，否则将追究法律责任。

转载于:http://blog.itpub.net/10239785/viewspace-664663/