insert_batch.java

public void insertBatch(List<AcmAuthor2paper> objList) {
		String sql = String.format("INSERT INTO %s.author2paper(id,aid,pid,position) VALUES (?,?,?,?)", dbName);

		DBConnection conn = pool.getConnection();
		PreparedStatement ps = null;
		try {
			conn.setAutoCommit(false);
			ps = conn.prepareStatement(sql);
			for (AcmAuthor2paper obj : objList) {
				_constructPS(ps, obj);
				ps.addBatch();
			}
			ps.executeBatch();
			conn.setAutoCommit(true);
		} catch (SQLException e) {
			e.printStackTrace();
		} finally {
			ConnectionPool.close(conn, ps);
		}
	}