@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;
}
@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;
}
