@Override
public void modifyUser(Connection conn, Smsuser user) {
String sql =
"update Smsuser set moblie='"
+ user.getMoblie()
+ "',name='"
+ user.getName()
+ "',atmids='"
+ user.getAtmids()
+ "',bugtype="
+ user.getBugtype()
+ ",status="
+ user.getStatus()
+ ",solvetime="
+ user.getSolvetime()
+ " where moblie='"
+ user.getMoblie_old()
+ "' and bugtype="
+ user.getBugtype()
+ " and solvetime="
+ user.getSolvetime_old();
// logger.info(sql);
try {
conn.createStatement().executeUpdate(sql);
} catch (Exception e) {
logger.error(e.getLocalizedMessage(), e);
}
}
@Override
public void createSms(Connection conn, Smsuser smsuser) {
String sql =
"insert into smsuser values('"
+ smsuser.getMoblie()
+ "','"
+ smsuser.getName()
+ "','"
+ smsuser.getAtmids()
+ "',"
+ smsuser.getBugtype()
+ ","
+ smsuser.getStatus()
+ ","
+ smsuser.getSolvetime()
+ ")";
// logger.info(sql);
try {
conn.createStatement().executeUpdate(sql);
} catch (Exception e) {
logger.error(e.getLocalizedMessage(), e);
}
}