JDBC的不常见的知识

addBatch()  //把一个sql语句加到批处理中

executeBatch() //执行批处理

Connection    connection =getConnection();

PreparedStatement statement = connection.prepareStatement("insert into persin(name,height)values(?,?)");   

statement.setString(1, "a"); 
statement.setInt(2,174); 
statement.addBatch();   

//记录2
statement.setString(1, "b"); 
statement.setInt(2,175 ); 
statement.addBatch();   

//记录3
statement.setString(1, "c");
statement.setInt(2, 160);  
statement.addBatch(); 

int [] counts = statement.executeBatch();   //执行批处理

ResultSet rs;

ResultSetMetaData rsmd = rs.getMetaData();
int cols = rsmd.getColumnCount();
for (int col = 1; col <= cols; col++) {

String columnName = rsmd.getColumnLabel(col);  //通过别名获得字段名
if (null == columnName || 0 == columnName.length()) {
  columnName = rsmd.getColumnName(col); //通过真实名字获得自动
}

}