mysql 批处理addBatch用法_mysqlcppconn addbatch

批处理demo

Connection conn = C3P0Util.getConnection();
PreparedStatement ps = null;
String sql = "insert into t_user values(null,?)";//定义sql的格式
ps = conn.prepareStatement(sql);
for (int i = 0; i < 10000; i++) {
    ps.setString(1, "user" + i);
    ps.addBatch();  //将sql语句保存起来，先不执行
}
ps.executeBatch();//执行批处理中所有的sql语句
ps.clearBatch();//清空批处理

查看mysql连接数与客户端ip

SELECT substring_index(host, ':',1) AS host_name,state,count(*) FROM information_schema.processlist GROUP BY state,host_name;