数据库增删改

一.增加数据

    try {
con=MysqlConnPool.getConnection();
String sql="insert into cost(cost_id,name,base_duration,base_cost,unit_cost,status,descr,creatime ,startime,cost_type)values(?,?,?,?,?,?,?,?,?,?)";
try{
PreparedStatement ps=(PreparedStatement) con.prepareStatement(sql);
ps.setString(1, id);
ps.setString(2, name);
ps.setString(3,duration);
ps.setString(4, descr);
ps.setString(5, creatime);
ps.setString(6, startime);
ps.setString(7, type);
ps.executeUpdate();  }
catch(Exception e) {
e.printStackTrace();
System.out.println("con error");

}

二.修改数据

    try {
con=MysqlConnPool.getConnection();
String sql="update cost set name=?,base_duration=?,descr=?,creatime=?,startime=?,cost_type where cost_id=?";
PreparedStatement ps=con.prepareStatement(sql);
ps.setString(1, a);
ps.setString(2, b);
ps.setString(3, c);
ps.setString(4, d);
ps.setString(5, n);
ps.setString(6, f);
ps.executeUpdate();
}catch(Exception e) {
e.printStackTrace();
}

}

三.删除数据

   try {
con=MysqlConnPool.getConnection();
String sql="delete from user2 where id=?";
PreparedStatement ps=con.prepareStatement(sql);
ps.setInt(1, id);
ps.executeUpdate();
}catch(Exception e) {
e.printStackTrace();
}