Ejemplo n.º 1
0
 @Override
 public boolean saveUsers(Users users) throws Exception {
   String sql =
       "insert into users (userNumber,userName,loginName,enName,sex,telephone,birthday,telephoneExt,email,mobilePhone,msn,fax,msn2,skype,msn3,qq,companyId,departmentId,jobDescription,sortNumber,address,zip,remark,imagePath,password) values(?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?)";
   int rs =
       this.update(
           sql,
           users.getUserNumber(),
           users.getUserName(),
           users.getLoginName(),
           users.getEnName(),
           users.getSex(),
           users.getTelephone(),
           users.getBirthday(),
           users.getTelephoneExt(),
           users.getEmail(),
           users.getMobilePhone(),
           users.getMsn(),
           users.getFax(),
           users.getMsn2(),
           users.getSkype(),
           users.getMsn3(),
           users.getQq(),
           users.getCompanyId(),
           users.getDepartmentId(),
           users.getJobDescription(),
           users.getSortNumber(),
           users.getAddress(),
           users.getZip(),
           users.getRemark(),
           users.getImagePath(),
           FengHuangMd5Util.getMD5("111111"));
   return rs > 0;
 }
Ejemplo n.º 2
0
  @Override
  public boolean updateUsers(Users users) throws Exception {

    String sql =
        "update users set userNumber=?,userName=?,loginName=?,enName=?,sex=?,telephone=?,birthday=?,telephoneExt=?,email=?,mobilePhone=?,msn=?,fax=?,msn2=?,skype=?,msn3=?,qq=?,companyId=?,departmentId=?,jobDescription=?,sortNumber=?,address=?,zip=?,remark=?,imagePath=? where id =? ";
    int rs =
        this.update(
            sql,
            users.getUserNumber(),
            users.getUserName(),
            users.getLoginName(),
            users.getEnName(),
            users.getSex(),
            users.getTelephone(),
            users.getBirthday(),
            users.getTelephoneExt(),
            users.getEmail(),
            users.getMobilePhone(),
            users.getMsn(),
            users.getFax(),
            users.getMsn2(),
            users.getSkype(),
            users.getMsn3(),
            users.getQq(),
            users.getCompanyId(),
            users.getDepartmentId(),
            users.getJobDescription(),
            users.getSortNumber(),
            users.getAddress(),
            users.getZip(),
            users.getRemark(),
            users.getImagePath(),
            users.getId());
    return rs > 0;
  }
Ejemplo n.º 3
0
  @Override
  public Pagination<Users> getPaginationUsers(int currentPage, int numPerPage, Users users)
      throws Exception {
    // date_format(users.birthday,'%Y-%m-%d') as birthday
    StringBuffer sql =
        new StringBuffer(
            "SELECT users.id,users.userNumber,users.userName,users.loginName,users.enName,users.sex,users.telephone,date_format(users.birthday,'%Y-%m-%d') as birthday,users.telephoneExt,users.email,users.mobilePhone,users.msn,users.fax,users.msn2,users.skype,users.msn3,users.qq,users.companyId,users.departmentId,");
    sql.append("users.jobDescription,");
    sql.append("users.sortNumber,");
    sql.append("users.address,");
    sql.append("users.zip,");
    sql.append("users.remark,");
    sql.append("users.imagePath,");
    sql.append("department.departName,");
    sql.append("company.companyName");
    sql.append(" FROM ");
    sql.append("users ,");
    sql.append("department,company");
    sql.append(" WHERE ");
    sql.append("department.id =  users.departmentId  and users.companyId =company.id and 1=1");
    if (users.getUserNumber() != null && !"".equals(users.getUserNumber())) {
      sql.append("  and users.userNumber like '");
      sql.append(users.getUserNumber());
      sql.append("%'");
    }

    if (users.getUserName() != null && !"".equals(users.getUserName())) {
      sql.append("  and users.userName like '");
      sql.append(users.getUserName());
      sql.append("%'");
    }
    if (users.getLoginName() != null && !"".equals(users.getLoginName())) {
      sql.append("  and users.loginName like '");
      sql.append(users.getLoginName());
      sql.append("%'");
    }

    if (users.getEnName() != null && !"".equals(users.getEnName())) {
      sql.append("  and users.enName like '");
      sql.append(users.getEnName());
      sql.append("%'");
    }

    if (users.getSex() != null && !"".equals(users.getSex())) {
      sql.append("  and users.sex='");
      sql.append(users.getSex());
      sql.append("'");
    }
    if (users.getTelephone() != null && !"".equals(users.getTelephone())) {
      sql.append("  and users.telephone like '");
      sql.append(users.getTelephone());
      sql.append("%'");
    }
    if (users.getTelephoneExt() != null && !"".equals(users.getTelephoneExt())) {
      sql.append("  and users.telephoneExt like '");
      sql.append(users.getTelephoneExt());
      sql.append("%'");
    }
    if (users.getEmail() != null && !"".equals(users.getEmail())) {
      sql.append("  and users.email like '");
      sql.append(users.getEmail());
      sql.append("%'");
    }
    if (users.getMobilePhone() != null && !"".equals(users.getMobilePhone())) {
      sql.append("  and users.mobilePhone like '");
      sql.append(users.getMobilePhone());
      sql.append("%'");
    }
    if (users.getMsn() != null && !"".equals(users.getMsn())) {
      sql.append("  and users.msn like '");
      sql.append(users.getMsn());
      sql.append("%'");
    }
    if (users.getFax() != null && !"".equals(users.getFax())) {
      sql.append("  and users.fax like '");
      sql.append(users.getFax());
      sql.append("%'");
    }
    if (users.getMsn2() != null && !"".equals(users.getMsn2())) {
      sql.append("  and users.msn2 like '");
      sql.append(users.getMsn2());
      sql.append("%'");
    }
    if (users.getSkype() != null && !"".equals(users.getSkype())) {
      sql.append("  and users.skype like '");
      sql.append(users.getSkype());
      sql.append("%'");
    }

    if (users.getMsn3() != null && !"".equals(users.getMsn3())) {
      sql.append("  and users.msn3 like '");
      sql.append(users.getMsn3());
      sql.append("%'");
    }

    if (users.getQq() != null && !"".equals(users.getQq())) {
      sql.append("  and users.qq like '");
      sql.append(users.getQq());
      sql.append("%'");
    }

    if (users.getCompanyId() != null && users.getCompanyId() != 0) {
      sql.append("  and users.companyId ='");
      sql.append(users.getCompanyId());
      sql.append("'");
    }
    if (users.getDepartmentId() != null && users.getDepartmentId() != 0) {
      sql.append("  and users.departmentId ='");
      sql.append(users.getDepartmentId());
      sql.append("'");
    }
    if (users.getSortNumber() != null && users.getSortNumber() != 0) {
      sql.append("  and users.sortNumber ='");
      sql.append(users.getSortNumber());
      sql.append("'");
    }

    if (users.getAddress() != null && !"".equals(users.getAddress())) {
      sql.append("  and users.address like '");
      sql.append(users.getAddress());
      sql.append("%'");
    }

    if (users.getZip() != null && !"".equals(users.getZip())) {
      sql.append("  and users.zip like '");
      sql.append(users.getZip());
      sql.append("%'");
    }

    if (users.getRemark() != null && !"".equals(users.getRemark())) {
      sql.append("  and users.remark like '");
      sql.append(users.getRemark());
      sql.append("%'");
    }
    Pagination<Users> paginUsers = this.getPagination(currentPage, numPerPage, sql.toString());
    return paginUsers;
  }