实例:10w条数据的插入(批量插入)
import java.sql.Connection;
import java.sql.DriverManager;
import java.sql.PreparedStatement;
public class HomeWork02
{
//预处理--注入数据
public static void main(String[]args) throws Exception
{
//加载数据库
Class.forName("com.mysql.jdbc.Driver");
//获取连接对象
String url = "jdbc:mysql://localhost:3306/db1?rewriteBatchedStatements=true&useUnicode=true&characterEncoding=UTF-8";
Connection conn = DriverManager.getConnection(url, "username", "password");
//连接操作数据库
String sql = "insert into homework VALUES (?,?,?) ";
PreparedStatement pst = conn.prepareStatement(sql);
for (int i = 1; i <= 100000 ; i++)
{
pst.setObject(1,i);
pst.setObject(2,i+"号");
pst.setObject(3,i*10+"¥");
pst.addBatch();
}
//操作完成,提交
pst.executeBatch();
//释放资源
pst.close();
conn.close();
}
}