SQL语句批处理情况(Statement和PreparedStatement)

 

import java.sql.*;

public class TestBatch {

	/**
	 * @param args
	 */
	public static void main(String[] args) {
		// TODO Auto-generated method stub
		Connection con = null;
		Statement stmt = null;
		PreparedStatement ps = null;
		try {
			Class.forName("com.mysql.jdbc.Driver");
			con = DriverManager.getConnection(
					"jdbc:mysql://localhost:3306/mydb", "root", "root");
			System.out.println("连接数据库成功!");

			stmt = con.createStatement();
			// 批处理开始
			stmt.addBatch("insert into people values(9,'ding','duo')");
			stmt.addBatch("insert into people values(10,'nokia','ddd')");
			// 执行批处理
			stmt.executeBatch();

			ps = con.prepareStatement("insert into people values(?,?,?)");
			ps.setInt(1, 17);
			ps.setString(2, "21212");
			ps.setString(3, "fafebioy");
			// 批处理开始
			ps.addBatch();
			ps.setInt(1, 18);
			ps.setString(2, "dddd");
			ps.setString(3, "xuegangwang");
			// 批处理开始
			ps.addBatch();
			// 执行批处理
			ps.executeBatch();
		} catch (ClassNotFoundException e) {
			e.printStackTrace();
		} catch (SQLException se) {
			se.printStackTrace();
		} finally {
			try {
				if (stmt != null) {
					stmt.close();
					stmt = null;
				}
				if (con != null) {
					con.close();
					con = null;
				}
				if (ps != null) {
					ps.close();
					ps = null;
				}
			} catch (SQLException se) {
				se.printStackTrace();
			}
		}
	}

}