sql数据库操作

1.批量insert， update操作注意使用批量操作，学会使用事务。sql写在配置文件中，容易修改。如：

String sql = new Properties().getProperty("properties中的name(mysql.***)");
Connection con = null;
try {
con = getconnection();
con.setAutocommit(false);
PreparedStatement pre = con.prepareStatement(sql);

for(Model model : list) {
   pre.setObject(1,model.get***().toString());
   pre.setObject(2,model.get***().toString());
   pre.setObject(3,model.get***().toString());
   pre.addBatch();
}
pre.excuteBatch();
con.commit();
} catch(Exception ex) {
   try {
      con.rollback();
   } catch(Exception e) {

   }
}

properties:
mysql.***=SELECT * FROM *** WHERE ID=? AND NAME=? AND JOB=?

Model:
String ID;
String NAME;
String JOB;

Set to String:
String.replaceAll("^\\[","").replaceAll("\\]$","");