@Override
public BaseVo loadFromRS(ResultSet rs) {
CmdCfgFile vo = new CmdCfgFile();
try {
vo.setId(rs.getInt("id"));
vo.setTimingId(rs.getInt("timingId"));
vo.setIpaddress(rs.getString("ipaddress"));
vo.setFileName(rs.getString("fileName"));
vo.setContent(rs.getString("content"));
vo.setFileSize(rs.getInt("file_size"));
vo.setBackupTime(rs.getTimestamp("backup_time"));
vo.setBkpType(rs.getString("bkp_type"));
vo.setBaseline(rs.getInt("baseline"));
} catch (Exception e) {
SysLogger.error("VPNFileConfigDao.loadFromRS()", e);
vo = null;
}
return vo;
}
/** 查询所有巡检命令的Model */
public List<CmdCfgFile> loadAll() {
String sql = "select * from nms_vpncfg";
List<CmdCfgFile> ccfList = new ArrayList<CmdCfgFile>();
ResultSet rs = null;
try {
rs = conn.executeQuery(sql);
while (rs.next()) {
CmdCfgFile ccf = new CmdCfgFile();
ccf.setId(rs.getInt("id"));
ccf.setIpaddress(rs.getString("ipaddress"));
ccf.setBackupTime(rs.getTimestamp("backup_time"));
ccf.setBkpType(rs.getString("bkp_type"));
ccfList.add(ccf);
}
return ccfList;
} catch (Exception e) {
e.printStackTrace();
System.out.println("List<CmdCfgFile> loadAll------------查询所有巡检命令Model失败");
}
return null;
}