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();

   }

}

}