Ejemplo n.º 1
0
 /** 修改 */
 public boolean update(BaseVo baseVo) {
   Knowledgebase vo = (Knowledgebase) baseVo;
   StringBuffer sql = new StringBuffer();
   sql.append("update system_knowledgebase set category='");
   sql.append(vo.getCategory());
   sql.append("',entity='");
   sql.append(vo.getEntity());
   sql.append("',subentity='");
   sql.append(vo.getSubentity());
   sql.append("',titles='");
   sql.append(vo.getTitles());
   sql.append("',contents='");
   sql.append(vo.getContents());
   sql.append("',bak='");
   sql.append(vo.getBak());
   sql.append("',attachfiles='");
   sql.append(vo.getAttachfiles());
   sql.append("' where id=");
   sql.append(vo.getId());
   return saveOrUpdate(sql.toString());
 }
Ejemplo n.º 2
0
 /** 保存 */
 public boolean save(BaseVo baseVo) {
   Knowledgebase vo = (Knowledgebase) baseVo;
   StringBuffer sql = new StringBuffer();
   sql.append(
       "insert into system_knowledgebase(category,entity,subentity,titles,contents,bak,attachfiles,userid)values(");
   sql.append("'");
   sql.append(vo.getCategory());
   sql.append("','");
   sql.append(vo.getEntity());
   sql.append("','");
   sql.append(vo.getSubentity());
   sql.append("','");
   sql.append(vo.getTitles());
   sql.append("','");
   sql.append(vo.getContents());
   sql.append("','");
   sql.append(vo.getBak());
   sql.append("','");
   sql.append(vo.getAttachfiles());
   sql.append("','");
   sql.append(vo.getUserid());
   sql.append("');");
   return saveOrUpdate(sql.toString());
 }
Ejemplo n.º 3
0
  public BaseVo loadFromRS(ResultSet rs) {
    Knowledgebase vo = new Knowledgebase();

    try {
      vo.setId(rs.getInt("id"));
      vo.setCategory(rs.getString("category"));
      vo.setEntity(rs.getString("entity"));
      vo.setSubentity(rs.getString("subentity"));
      vo.setTitles(rs.getString("titles"));
      vo.setContents(rs.getString("contents"));
      vo.setBak(rs.getString("bak"));
      vo.setAttachfiles(rs.getString("attachfiles"));
      vo.setUserid(rs.getString("userid"));
      vo.setKtime(rs.getString("ktime"));
    } catch (Exception e) {
      e.printStackTrace();
      vo = null;
    }
    return vo;
  }