如何建立Praparedstatement批处理对象？

[Girl_my_lover]

Statement stmt = con.getStatement();
stmt.addBatch(sql);
stmt.addBatch(sql);
stmt.addBatch(sql);
可以建立批处理的statement对象

现在要问的是：preparedstatement如何建立批处理对象？
preparedstatement的addBatch()方法没有String sql参数，如何添加sql语句？

[Girl_my_lover]

自己顶下

[Girl_my_lover]

在顶起

[中智软件科技]

PreparedStatement pstmt 有一个executeBatch 方法

[careers1111]

public boolean saveOrUpdateCommit(String sql1,String sql2)
{
boolean temp = true;
try
{
conn.setAutoCommit(false);
stmt = conn.createStatement();
stmt.addBatch(sql1);
stmt.addBatch(sql2);
stmt.executeBatch();
conn.commit();
}catch(SQLException e)
{
e.printStackTrace();
temp = false;
try
{
conn.rollback();
}catch(SQLException e1){
e1.printStackTrace();
}

}
return temp;
}

[careers1111]

详细介绍

http://blog.sina.com.cn/s/blog_5f17b8e40100cfn1.html

[angelsimle]

PerparedStatement本身就是批处理的因此在创建PreparedStatment对象时就已经将要处理的 sql 预处理了
PreparedStatement pstmt = conn.prepareStatement(sql);

[muyu652]

	/**
	 * 执行批量插入操作
	 * 
	 */
	public static void executeInsertBath() {
		Connection con = null;
		try {
			con = MysqlConnection.mySqlCon();
			Statement st = con.createStatement();

			for (int i = 0; i < 10; i++) {
				long id = System.currentTimeMillis();
				String name = "OEC" + id;
				String sql = "insert into OEC_STUDENT (STUID,STUNAME,DESCRIPTION,CREATED) "
						+ "values(#ID$,'#name$','','2006-10-10')";
				String sqlIdAdd = StringUtils.replaceOnce(sql, "#ID$", String
						.valueOf(id));
				String sqlNameAdd = StringUtils.replaceOnce(sqlIdAdd, "#name$",
						name);
				st.addBatch(sqlNameAdd);
			}
			st.executeBatch();
		} catch (Exception e) {
			e.printStackTrace();
		} finally {
			if (con != null) {
				try {
					con.close();
				} catch (SQLException e) {
					// TODO Auto-generated catch block
					e.printStackTrace();
				}
			}
		}
	}

[muyu652]

/**
	 * PS执行批量插入操作
	 * 
	 */
	public static void executePreparedInsertBath() {
		Connection con = null;
		try {
			con = MysqlConnection.mySqlCon();
			String sql = "insert into OEC_STUDENT (STUID,STUNAME,DESCRIPTION,CREATED) "
					+ "values(?,?,'','2006-10-10')";
			PreparedStatement ps = con.prepareStatement(sql);

			for (int i = 0; i < 10; i++) {
				long id = System.currentTimeMillis();
				String name = "OEC" + id;
				ps.setObject(1, new Long(id));
				ps.setObject(2, name);
				ps.addBatch();
			}
			ps.executeBatch();
		} catch (Exception e) {
			e.printStackTrace();
		} finally {
			if (con != null) {
				try {
					con.close();
				} catch (SQLException e) {
					// TODO Auto-generated catch block
					e.printStackTrace();
				}
			}
		}
	}

	/**
	 * PS执行批量插入操作
	 * 
	 */
	public static void executePreparedDeleteBath() {
		Connection con = null;
		try {
			con = MysqlConnection.mySqlCon();
			String sql = "select STUID,STUNAME,DESCRIPTION,CREATED from OEC_STUDENT where STUNAME like ?";
			PreparedStatement ps = con.prepareStatement(sql);
			ps.setObject(1, "OEC%");
			ResultSet rs = ps.executeQuery();
			int i = 0;
			while (rs.next()) {
				i++;
			}
			System.out.println("total:" + i);
		} catch (Exception e) {
			e.printStackTrace();
		} finally {
			if (con != null) {
				try {
					con.close();
				} catch (SQLException e) {
					// TODO Auto-generated catch block
					e.printStackTrace();
				}
			}
		}
	}