JDBC 批量处理

import java.sql.Connection;
import java.sql.DriverManager;
import java.sql.ResultSet;
import java.sql.SQLException;

import com.mysql.jdbc.Statement;

public class JDbc {

	public static void main(String[] args) {
		Connection connection = null;
		Statement statement = null;
		
		
		try {
			Class.forName("com.mysql.jdbc.Driver");//加载Driver类
			connection = DriverManager.getConnection("jdbc:mysql://127.0.0.1:3306/test02?characterEncoding=utf8","root","root");
//链接数据库 在test02库后添加?characterEncoding=utf8 让导入中文不会变成? 单次有效
			statement = (Statement) connection.createStatement();//新建Statement接口
			
			statement.addBatch("insert into tb_peo(id, name, birthday) values('5','郭珂','1999-8-10')");
			statement.addBatch("insert into tb_peo(id, name, birthday) values('6','狗蛋','1999-8-13')");
			statement.addBatch("insert into tb_peo(id, name, birthday) values('7','翠花','1979-4-10')");
		
			int a[] = statement.executeBatch();
			for(int res : a){
				System.out.println("影响的行数为:"+res);
			}
			
		} catch (SQLException e) {
			// TODO Auto-generated catch block
			e.printStackTrace();
		} catch (ClassNotFoundException e) {
			// TODO Auto-generated catch block
			e.printStackTrace();
		}finally{
			try {
				statement.close();
			} catch (SQLException e) {
				// TODO Auto-generated catch block
				e.printStackTrace();
			}
			try {
				connection.close();
			} catch (SQLException e) {
				// TODO Auto-generated catch block
				e.printStackTrace();
			}
			
		}
		
		}
}