jsp:
<td align="right"><span style="font-size:12px;">身份证号</span></td>
<td><input style="width:200px;height:25px;"name="identityId" id="identityId" class="easyui-validatebox" validType="youthIdentity" required="true" /></td>
js:
youthIdentity:{ validator : function(identityId){ var reg = /(^\d{15}$)|(^\d{18}$)|(^\d{17}(\d|X|x)$)/; if(reg.test(identityId) === false) { message : '身份证输入不合法' return false; } var vali=true; $.ajax({ url:basepath +'youth/checkAddYouth.do', async: false, processData: false, data: "identityId="+identityId, success: function(responseText){ var result = eval("(" + responseText + ")");//转换为json对象 vali=result.success; console(responseText.data); } }); return vali; }, message : '身份证号已存在或格式错误,请检查!' },
后台:
java
//增加青年,判断数据库是否已经存在系统身份证的青年
public void checkAddYouth(){
try {
BaseDao dao = getDao();
int count = (Integer) dao.selectObject("youth.getListIdentityId", model);
String s=null;
//count!=0 表示已存在
if(count!=0){
s="身份证号已存在";
this.setSuccess(false);
}else{
s="身份证号可用";
this.setSuccess(true);
}
this.setData(s);
this.send();
} catch (Exception e) {
e.printStackTrace();
this.setData("操作失败");
this.setSuccess(false);
this.send();
}
}
sql:
<select id="getListIdentityId" parameterClass="youth" resultClass="java.lang.Integer">
select count(1) from ybc_youth a
<dynamic prepend="where">
<isNotEmpty prepend="and" property="identityId">
identityId = #identityId#
</isNotEmpty>
</dynamic>
</select>