@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;
 }
 public boolean save(BaseVo vo) {
   CmdCfgFile h3 = (CmdCfgFile) vo;
   StringBuffer sql =
       new StringBuffer(
           "insert into nms_vpncfg(id,timingId,ipaddress,fileName,content,backup_time,file_size,bkp_type) values(");
   sql.append(this.getNextID());
   sql.append(",");
   sql.append(h3.getTimingId());
   sql.append(",'");
   sql.append(h3.getIpaddress());
   sql.append("','");
   sql.append(h3.getFileName());
   sql.append("','");
   sql.append(h3.getContent());
   sql.append("','");
   sql.append(h3.getBackupTime());
   sql.append("',");
   sql.append(h3.getFileSize());
   sql.append(",'");
   sql.append(h3.getBkpType());
   sql.append("')");
   return this.saveOrUpdate(sql.toString());
 }