关于JAVA持久化的技术-JDBC

1、关于批量插入

Connection conn = null;
		java.sql.PreparedStatement prepStmt = null;
		try {
			Class.forName("com.mysql.jdbc.Driver");
	        String url = "jdbc:mysql://localhost/app";
	        String username = "root";
	        String password = "root";
        	conn = DriverManager.getConnection(url, username, password);
		} catch (Exception e) {
			// TODO: handle exception
		}
		try {
			String sql = "insert into room values (?, ?)";
			conn.setAutoCommit(false);
			prepStmt = conn.prepareStatement(sql);
			for (int i = 0; i< 100; i++){
				prepStmt.setInt(1, i+10);
				prepStmt.setString(2, "我很蛋疼");
				prepStmt.addBatch();
			}
			int[] numInsert = prepStmt.executeBatch();
			for (int j = 0; j < numInsert.length; j++){
				if(numInsert[j] == -2){
					System.out.println("Exception" + j);
				}
				else{
					System.out.println(j + " " +numInsert[j]);
				}
			}
			conn.commit();
			prepStmt.close();
		} catch (Exception e) {
			System.out.println(e.toString());
		} finally{
			try {
				conn.close();
			} catch (SQLException e) {
				// TODO Auto-generated catch block
				e.printStackTrace();
			}
		}