Examples of BizResult

org.yfsoft.comm.util.BizResult

Examples of org.yfsoft.comm.util.BizResult

   * @param max 分页
   * @param page
   * @return
   */
  public BizResult list(String table,String[] fields,String where,String order,int max,int page){
    BizResult rst = new BizResult();
    if(StringUtil.isNullOrEmpty(table)){
      return rst.setCode("-1").setMsg("Table Is Empty!");
    }
    String sql = "select {0} from {1} where {2} {3} limit {4},{5}";
    String cols = "*";
    if(fields!=null && fields.length>0){
      cols = StringUtil.trim(Arrays.toString(fields), 5);
    }
    if(StringUtil.isNullOrEmpty(where)){
      where = "1 = 1";
    }
    if(!StringUtil.isNullOrEmpty(order)){
      order = " order by "+ order;
    }else{
      order = "";
    }
    int l = page * max;
    int r = l + max;
    sql = StringUtil.formatSql(sql, cols,table,where,order,l,r);
//    System.out.println("LIST:"+sql);
    rst.setCode("0").setData(mapper.list(sql));
    return rst;
  }

View Full Code Here

Examples of org.yfsoft.comm.util.BizResult

    rst.setCode("0").setData(mapper.list(sql));
    return rst;
  }
  
  public BizResult injoin(String[] tables,String[] fields,String on,String where,String order,int max,int page){
    BizResult rst = new BizResult();
    if(tables==null || tables.length<1){
      return rst.setCode("-1").setMsg("Tables Can't Be Empty!");
    }
    String sql = "select {0} from {1} where {2} and {3} {4} limit {5},{6}";
    String cols = "*",table = "";
    table = StringUtil.trim(Arrays.toString(tables), 5);
    if(fields!=null && fields.length>0){
      cols = StringUtil.trim(Arrays.toString(fields), 5);
    }
    if(StringUtil.isNullOrEmpty(on)){
      return rst.setCode("-1").setMsg("ON Condition Can't Be Empty!");
    }
    if(StringUtil.isNullOrEmpty(where)){
      where = "1 = 1";
    }
    if(!StringUtil.isNullOrEmpty(order)){
      order = " order by "+ order;
    }else{
      order = "";
    }
    int l = page * max;
    int r = l + max;
    sql = StringUtil.formatSql(sql, cols,table,on,where,order,l,r);
//    System.out.println(sql);
    rst.setCode("0").setData(mapper.list(sql));
    return rst;
  }

View Full Code Here

Examples of org.yfsoft.comm.util.BizResult

   * @param table 表
   * @param where 条件
   * @return
   */
  public BizResult delete(String table,String where){
    BizResult rst = new BizResult().setCode("-1");
    String sql = "delete from {0} where {1}";
    sql = StringUtil.format(sql,table, where);
    int rows = this.mapper.execute(sql);
    //System.out.println("DELETE:"+sql);
    return rst.setCode("0").setData(rows);
  }

View Full Code Here

Examples of org.yfsoft.comm.util.BizResult

    //System.out.println("DELETE:"+sql);
    return rst.setCode("0").setData(rows);
  }
  
  public BizResult update(Map<String,String> e,String where ,String table){
    BizResult rst = new BizResult().setCode("-1");
    String sql = "desc "+table;
    String f,t,k;
    List<Map<String,Object>> list = this.mapper.list(sql);
    sql = "update {0} set {1} where {2}";
    StringBuffer cols = new StringBuffer();
    for(Map<String,Object> o : list){
      k = o.get("Key").toString();//主键不能修改
      if("PRI".equals(k)) continue;
      f = o.get("Field").toString();//字段名称
      if(!e.containsKey(f)) continue;//未设置字段
      cols.append(f).append("=");
      t = o.get("Type").toString();//字段类型
      if(t.indexOf("int")<0){
        //字段未非整形
        cols.append("'").append(e.get(f)).append("'").append(",");
      }else{
        cols.append(e.get(f)).append(",");
      }
    }
    cols = cols.deleteCharAt(cols.length()-1);
    if(StringUtil.isNullOrEmpty(where))
      where = "1 = 1";
    sql = StringUtil.formatSql(sql,table, cols.toString(),where);
//    System.out.println(sql);
    int rows = this.mapper.execute(sql);
    return rst.setCode("0").setData(rows);
  }

View Full Code Here

Examples of org.yfsoft.comm.util.BizResult

   * @param e
   * @param table
   * @return
   */
  public BizResult insert(Map<String,String> e,String table){
    BizResult rst = new BizResult().setCode("-1");
    String sql = "desc "+table;
    String f,t,a;
    List<Map<String,Object>> list = this.mapper.list(sql);
    sql = "insert into {0}({1}) values({2})";
    StringBuffer cols = new StringBuffer();
    StringBuffer vals = new StringBuffer();
    for(Map<String,Object> o : list){
      a = o.get("Extra").toString();//自增字段,过滤
      if("auto_increment".equals(a))  continue;
      f = o.get("Field").toString();//字段名称
      if(!e.containsKey(f)) continue;//未设置字段
      cols.append(f).append(",");
      t = o.get("Type").toString();//字段类型
      if(t.indexOf("int")<0){
        //字段未非整形
        vals.append("'").append(e.get(f)).append("'").append(",");
      }else{
        vals.append(e.get(f)).append(",");
      }
    }
    cols = cols.deleteCharAt(cols.length()-1);
    vals = vals.deleteCharAt(vals.length()-1);
    sql = StringUtil.formatSql(sql,table, cols.toString(),vals.toString());
//    System.out.println(sql);
    int rows = this.mapper.execute(sql);
    if(rows==1){
      rst.setCode("0");
    }
    return rst;
  }

View Full Code Here

Examples of org.yfsoft.comm.util.BizResult

  public void setDao( CommonDao dao) {
    this.dao = dao;
  }
  
  public BizResult list(Map<String,String> input){
    BizResult rst = this.dao.list("sys_control",null,null,null,100,0);
    rst.setType(String.valueOf(ResultType.REDIRECT));
    rst.setPage("control/list.jsp");
    this.setReqAttr("controls", rst.getData());
    return rst;
  }

View Full Code Here

Examples of org.yfsoft.comm.util.BizResult

    this.setReqAttr("controls", rst.getData());
    return rst;
  }
  
  public BizResult add(Map<String,String> input){
    BizResult rst = this.dao.insert(input, "sys_control");
    if("0".equals(rst.getCode())){
      this.setReqAttr("msg", "OK");
    }else{
      this.setReqAttr("msg", rst.getMsg());
    }
    return list(input);
  }

View Full Code Here

Examples of org.yfsoft.comm.util.BizResult

    }
    return list(input);
  }


  public BizResult del(Map<String,String> input){
    BizResult rst = new BizResult().setCode("0");
    rst.setType(String.valueOf(ResultType.REDIRECT));
    rst.setPage("model/add.jsp");
    return rst;
  }

View Full Code Here

Examples of org.yfsoft.comm.util.BizResult

    rst.setPage("model/add.jsp");
    return rst;
  }
  
  public BizResult addform(Map<String,String> input){
    BizResult rst = new BizResult().setCode("0");
    rst.setType(String.valueOf(ResultType.JUMP));
    rst.setPage("control/add.jsp");
    return rst;
  }

View Full Code Here

Examples of org.yfsoft.comm.util.BizResult

    return rst;
  }
  
  public BizResult updform(Map<String,String> input){
    //TODO..获取值
    BizResult rst = new BizResult().setCode("0");
    rst.setType(String.valueOf(ResultType.REDIRECT));
    rst.setPage("model/upd.jsp");
    return rst;
  }

View Full Code Here

0 1 2 3 4 5

TOP

All source code are property of their respective owners. Java is a trademark of Sun Microsystems, Inc and owned by ORACLE Inc. Contact coftware#gmail.com.