Example #1
0
 @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);
   }
 }
Example #2
0
 @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);
   }
 }