/**
* ajax验证用户名是否重复
*
* @param req
* @return
* @throws Exception
*/
public IResData ajaxCheckName(IReqData req) throws Exception {
BaseZrarIDao dao = this.getBaseZrarDao();
IResData resEvent = new SwordRes();
//从前端获取yhdm,根据用户账户来判重
String username = req.getFormData(user_FormID).get("yhdm");
if ("".equals(username)) {
resEvent.addValidator(false, "名称不能为空!");
return resEvent;
}
if (username.length() > 20) {
resEvent.addValidator(false, "用户代码不超过20个字符!");
return resEvent;
}
//调用这个方法去数据库使用sql语句进行查询,查出结果大于0,说明存在记录
if (checkName(username, dao)) {
resEvent.addValidator(false, "名称[" + username + "]已经存在,请使用其它的名称!");
} else {
resEvent.addValidator(true, "名称[" + username + "]可以使用!");
}
return resEvent;
}
/**
*
* @param formName
* @param dao
* @return
* @throws PersistenceCheckedException
*/
private boolean checkName(String formName, BaseZrarIDao dao)
throws PersistenceCheckedException {
List parmLists = new ArrayList();
parmLists.add(formName);
List<TXtYhBO> userlist = (List<TXtYhBO>) dao.query(TXtYhBO.class,
"select yh_dm from t_xt_yh where YH_DM=?", parmLists);
return userlist.size() > 0;
}