lelonta

daoImpl：

public String isVipCode(String vipcode) {
String sql = "from FfzjUserEntity where vip_code='"+vipcode+"' ";
Query queryObject = getSession().createQuery(sql.toString());
List<FfzjUserEntity> list = queryObject.list();
if(list.size() > 0) {
//查詢出結果 說明數據庫中存在
return "false";
}
//反之 數據庫中不存在
return "true";
}

controller:

/************************************ 判斷會員編號是否存在開始 ******************************/
@RequestMapping(params = "IsVipcode")
@ResponseBody
public void IsVipcode(FfzjUserEntity ffzjUserEntity,
HttpServletRequest req,HttpServletResponse response) {
response.setContentType("text/html;charset=UTF-8");
PrintWriter printWriter = null;
String vipcode = req.getParameter("vipCode");
req.setAttribute("vipcode", vipcode);
String str = "";
if(ffzjUserSerive.isVipCode(vipcode).equals("true")) {
//沒有從數據庫中查詢出數據
str = "false";
}else {
//數據庫中已有數據
str = "true";
}try {
printWriter = response.getWriter();
printWriter.print(str);
} catch (IOException ex) {
ex.printStackTrace();
} finally {
if (null != printWriter) {
printWriter.flush();
printWriter.close();
}
}
}
/************************************ 判斷會員編號是否存在結束 ******************************/

jsp:

$(function() {
//設置全局變量str 默認為true
var strd = true;
$("#vipCode").on("blur",function() {
/*================ 驗證vipcode start ====================*/
var vipCode = $("#vipCode").val();
var vipCode2 = $("#vipCode2").val();
var params = {"vipCode" : vipCode};
/*與服務器的數據進行交互 start*/
if(vipCode != vipCode2) {
$.ajax( {
type:"post",
data:params,
dataType:"json",
url:"<%=basePath%>/ffzjUser.do?IsVipcode",
success : function(data) {
//data == true說明從數據庫中查到了數據
if (data == true){
//將tred設為false
strd = false;
alert("會員編號重復!");
$("#vipCode").focus();
}else {
strd = true;
alert("會員編碼可用!");
showMessage("會員編碼可用!");
}
}
});
/*與服務器的數據進行交互 end*/
/*================ 驗證vipcode end ====================*/
}
});
$("#formobj").Validform(
{
tiptype : 4,
btnSubmit : "#btn_sub",
btnReset : "#btn_reset",
ajaxPost : true,
usePlugin : {
passwordstrength : {
minLen : 6,
maxLen : 18,
trigger : function(obj, error) {
if (error) {
obj.parent().next().find(
".Validform_checktip")
.show();
obj.find(".passwordStrength")
.hide();
} else {
$(".passwordStrength").show();
obj.parent().next().find(
".Validform_checktip")
.hide();
}
}
}
},
callback : function(data) {
var win = frameElement.api.opener;
if (data.success == true) {
frameElement.api.close();
win.tip(data.msg);
} else {
if (data.responseText == ''
|| data.responseText == undefined)
$("#formobj").html(data.msg);
else
$("#formobj").html(data.responseText);
return false;
}
win.reloadTable();
},
beforeCheck:function(curform){
//說明填寫的數據與數據庫中的重復
if(strd==false) {
alert("會員編號重復!");
$("#vipCode").focus();
return false;
}
var userType = $("#userType").val();
if(userType=="" || userType==null){
alert("用戶類型不能為空");
return false;
}

var cardType = $("#cardType").val();
if(cardType=="" || cardType==null){
alert("證件類型不能為空");
return false;
}

var sex = $("#sex").val();
if(sex=="" || sex==null){
alert("請選擇性別");
return false;
}
}
});

});