Beispiel #1
0
 @Override
 public List<Smsuser> lsgetMobileByAtmId(
     Connection conn, String atmId, String type, String level) {
   List<Smsuser> SmsList = null;
   Smsuser sms = null;
   try {
     String sql =
         "select moblie,status,name from Smsuser where bugtype="
             + type
             + " and solvetime="
             + level
             + " and atmids like '%"
             + atmId
             + "%'";
     logger.info(sql);
     ResultSet rs = conn.createStatement().executeQuery(sql);
     SmsList = new ArrayList<Smsuser>();
     while (rs.next()) {
       sms = new Smsuser();
       sms.setMoblie(rs.getString("moblie"));
       sms.setStatus(String.valueOf(rs.getInt("status")));
       sms.setName(rs.getString("name"));
       SmsList.add(sms);
     }
   } catch (Exception e) {
     sms = null;
     logger.error(e.getLocalizedMessage(), e);
   }
   return SmsList;
 }
Beispiel #2
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);
   }
 }
Beispiel #3
0
 @Override
 public void deleteMoblie(Connection conn, Smsuser user) {
   String sql =
       "delete from Smsuser  where moblie='"
           + user.getMoblie()
           + "' and bugtype="
           + user.getBugtype()
           + " and solvetime="
           + user.getSolvetime();
   logger.info(sql);
   try {
     conn.createStatement().executeUpdate(sql);
   } catch (Exception e) {
     logger.error(e.getLocalizedMessage(), e);
   }
 }
Beispiel #4
0
 @Override
 public List<Smsuser> getSmsUser(Connection conn) {
   List<Smsuser> list = null;
   Smsuser smsuser = null;
   try {
     ResultSet rs = conn.createStatement().executeQuery("select * from smsuser order by bugtype");
     list = new ArrayList<Smsuser>();
     while (rs.next()) {
       smsuser = new Smsuser();
       smsuser.setMoblie(rs.getString("moblie").trim());
       smsuser.setName(rs.getString("name").trim());
       String atmids = "";
       String[] atmid = rs.getString("atmids").trim().split(",");
       for (int i = 1; i <= atmid.length; i++) {
         atmids += atmid[i - 1];
         atmids += "<br>";
       }
       // logger.info(atmids);
       smsuser.setAtmids(atmids);
       smsuser.setBugtype(String.valueOf(rs.getInt("bugtype")));
       smsuser.setStatus(String.valueOf(rs.getInt("status")));
       smsuser.setSolvetime(String.valueOf(rs.getInt("solvetime")));
       list.add(smsuser);
     }
   } catch (Exception e) {
     logger.error(e.getLocalizedMessage(), e);
     list = null;
   }
   return list;
 }
Beispiel #5
0
  @Override
  public Smsuser getMobileByAtmId(Connection conn, String atmId) {
    Smsuser sms = null;
    try {
      String sql =
          "select moblie,status,name from Smsuser where status = 1 and atmids like '%"
              + atmId
              + "%'";
      logger.info(sql);
      ResultSet rs = conn.createStatement().executeQuery(sql);

      while (rs.next()) {
        sms = new Smsuser();
        sms.setMoblie(rs.getString("moblie"));
        sms.setStatus(String.valueOf(rs.getInt("status")));
        sms.setName(rs.getString("name"));
      }
    } catch (Exception e) {
      sms = null;
      logger.error(e.getLocalizedMessage(), e);
    }
    return sms;
  }
Beispiel #6
0
 @Override
 public List<Smsuser> getSmsListByType(Connection conn, String type) {
   List<Smsuser> SmsList = null;
   Smsuser sms = null;
   try {
     ResultSet rs =
         conn.createStatement().executeQuery("select * from Smsuser where bugtype=" + type);
     SmsList = new ArrayList<Smsuser>();
     while (rs.next()) {
       sms = new Smsuser();
       sms.setAtmids(rs.getString("atmids"));
       sms.setBugtype(String.valueOf(rs.getInt("bugtype")));
       sms.setMoblie(rs.getString("moblie"));
       sms.setName(rs.getString("name"));
       sms.setStatus(String.valueOf(rs.getInt("status")));
       sms.setSolvetime(String.valueOf(rs.getInt("solvetime")));
       SmsList.add(sms);
     }
   } catch (Exception e) {
     SmsList = null;
     logger.error(e.getLocalizedMessage(), e);
   }
   return SmsList;
 }
Beispiel #7
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);
   }
 }
Beispiel #8
0
 @Override
 public Smsuser getUserByMoblie(Connection conn, Smsuser smsuser) {
   Smsuser user = null;
   String sql =
       "select * from Smsuser where moblie='"
           + smsuser.getMoblie()
           + "' and bugtype="
           + smsuser.getBugtype()
           + " and solvetime="
           + smsuser.getSolvetime();
   logger.info(sql);
   try {
     ResultSet rs = conn.createStatement().executeQuery(sql);
     while (rs.next()) {
       user = new Smsuser();
       user.setMoblie(rs.getString("moblie"));
       user.setMoblie_old(rs.getString("moblie"));
       user.setName(rs.getString("name"));
       user.setAtmids(rs.getString("atmids"));
       user.setBugtype(String.valueOf(rs.getInt("bugtype")));
       user.setStatus(String.valueOf(rs.getInt("status")));
       user.setSolvetime(String.valueOf(rs.getInt("solvetime")));
     }
   } catch (Exception e) {
     logger.error(e.getLocalizedMessage(), e);
     user = null;
   }
   return user;
 }