@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; }
@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; }
@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; }