PreparedStatement 批处理

 

// 同条Sql语句  可以使用绑定变量
public static void main(String[] args) {
        //声明Connection对象
        Connection con;
        //驱动程序名
        String driver = "com.mysql.cj.jdbc.Driver";
        //URL指向要访问的数据库名mydata
        String url = "jdbc:mysql://localhost:3306/test?characterEncoding=UTF-8&serverTimezone=GMT&useSSL=false";
        //MySQL配置时的用户名
        String user = "root";
        //MySQL配置时的密码
        String password = "123456";
        //遍历查询结果集
        try {
            //加载驱动程序
            Class.forName(driver);
            //1.getConnection()方法，连接MySQL数据库！！
            con = DriverManager.getConnection(url, user, password);
            if (!con.isClosed())
                System.out.println("Succeeded connecting to the Database!");
            //2.创建statement类对象，用来执行SQL语句！！

            String sql = "insert into account(username,name,age) values(?,?,?)";

//            PreparedStatement preparedStatement = con.prepareStatement(sql, Statement.RETURN_GENERATED_KEYS);
            PreparedStatement preparedStatement = con.prepareStatement(sql);

            for(int i=1;i<=10;i++) {
                preparedStatement.setString(1,String.valueOf(i));
                preparedStatement.setString(2,String.valueOf(i));
                preparedStatement.setString(3,String.valueOf(i));

                preparedStatement.addBatch();

            }

            int[] updateResults = preparedStatement.executeBatch();

            System.out.println("updateResults="+ Arrays.toString(updateResults));

            preparedStatement.clearBatch();
        } catch (Exception e) {
            e.printStackTrace();
        }
    }

// 多条sql  不能使用绑定变量
public static void main(String[] args) {
        //声明Connection对象
        Connection con;
        //驱动程序名
        String driver = "com.mysql.cj.jdbc.Driver";
        //URL指向要访问的数据库名mydata
        String url = "jdbc:mysql://localhost:3306/test?characterEncoding=UTF-8&serverTimezone=GMT&useSSL=false";
        //MySQL配置时的用户名
        String user = "root";
        //MySQL配置时的密码
        String password = "123456";
        //遍历查询结果集
        try {
            //加载驱动程序
            Class.forName(driver);
            //1.getConnection()方法，连接MySQL数据库！！
            con = DriverManager.getConnection(url, user, password);
            if (!con.isClosed())
                System.out.println("Succeeded connecting to the Database!");
            //2.创建statement类对象，用来执行SQL语句！！

            String sql = "insert into account(username,name,age) values(?,?,?)";

//            PreparedStatement preparedStatement = con.prepareStatement(sql, Statement.RETURN_GENERATED_KEYS);
            PreparedStatement preparedStatement = con.prepareStatement(sql);

            preparedStatement.addBatch("insert into account(username,name,age) values(\"11\",\"11\",\"11\")");
            preparedStatement.addBatch("insert into account(username,name,age) values(\"21\",\"21\",\"21\")");

            int[] updateResults = preparedStatement.executeBatch();

            System.out.println("updateResults="+ Arrays.toString(updateResults));

            preparedStatement.clearBatch();
        } catch (Exception e) {
            e.printStackTrace();
        }
    }