jdbc批处理进行多条数据插入

package cn.linjun.demo;

import java.sql.Connection;
import java.sql.DriverManager;
import java.sql.SQLException;
import java.sql.Statement; public class DemoBrach { private static Connection connection;
private static Statement statement; public static void main(String[] args) {
try {
Class.forName("com.mysql.jdbc.Driver");
connection = DriverManager.getConnection("jdbc:mysql://localhost:3306/user", "root", "root");
connection.setAutoCommit(false);
statement = connection.createStatement();
for (int i=1;i<100;i++){ //同时插入100条数据
statement.addBatch("insert into user1 values (null,'lideng"+i+"',20000)"); }
statement.executeBatch();
connection.commit();
} catch (Exception e) {
e.printStackTrace();
}finally {
if(statement!=null){
try {
statement.close();
} catch (SQLException e) {
e.printStackTrace();
}
}
if (connection!=null){
try {
connection.close();
} catch (SQLException e) {
e.printStackTrace();
}
}
} }
}
上一篇:thinkPHP入门 一


下一篇:POJ2299Ultra-QuickSort(归并排序 + 树状数组求逆序对)