java JDBC-批处理Batch-事务

public class Demo5 {
    public static void main(String[] args) {
        Statement stmt=null;
        Connection conn=null;
        try {
            Class.forName("com.mysql.jdbc.Driver");
            conn=DriverManager.getConnection("jdbc:mysql://localhost:3306/test","root","dyl123");

            //设为手动提交
            conn.setAutoCommit(false);

            stmt=conn.createStatement();
            for(int i=0;i<20000;i++)
        {
            stmt.addBatch("insert into t_user(username,pwd,regTime) values('米"+i+"',555,now())");
        }
        stmt.executeBatch();
        conn.commit(); //提交事务

    } catch (ClassNotFoundException e) {
        e.printStackTrace();
    } catch (SQLException e) {
        e.printStackTrace();
    }finally {
            try {
                stmt.close();
            } catch (SQLException e) {
                e.printStackTrace();
            }
            try {
                conn.close();
            } catch (SQLException e) {
                e.printStackTrace();
            }

    }

}
}
上一篇:Java_JDBC mysql数据库连接


下一篇:java JDBC-statement接口实现简单的sql语句调用