<!DOCTYPE html PUBLIC "-//W3C//DTD XHTML 1.0 Transitional//EN" "http://www.w3.org/TR/xhtml1/DTD/xhtml1-transitional.dtd">
<html xmlns="http://www.w3.org/1999/xhtml">
<head>
<meta http-equiv="Content-Type" content="text/html; charset=gb2312" />
<title>禁用物质检测系统</title>
<style type="text/css">
<!--
body {
background-image: url(../image/exptextb.jpg);
}
.STYLE7 {
font-size: 24px;
color: #FF0000;
font-weight: bold;
}
.STYLE8 {color: #FF0000}
.STYLE10 {color: #FF0000; font-size: 14px; }
.STYLE11 {
color: #000000;
font-weight: bold;
}
-->
</style>
<script type="text/javascript">
function SelectSubmit(){
document.all.registerForm.submit();
return true;
}
function submit1(){
if(document.all.bgbh.value.length==0)
alert("请输入报告编号!");
return false
}
</script>
</head>
<script type="text/javascript" src="../html/function.js"></script>
<body>
<form action="insert_liaohao.asp" method="post" name="form1" id="form1" onsubmit="this.action=this.action+document.form1.liaohao1.value">
<div align="center"><span class="STYLE7">报告编号对应新增物料料号</span> </div>
<table width="1165" height="314" align="center">
<tr>
<td height="23"><div align="left"><a href="../index.asp"> 返回主页</a></div></td>
<td><span class="STYLE11">报告编号:</span></td>
<td colspan="2"><input name="bgbh" type="text" id="bgbh" value="" />
<span class="STYLE8">*</span></td>
<td colspan="4"><strong>MSDS文件位置:</strong>
<input name="msds" type="file" id="msds" /></td>
</tr>
<tr>
<td width="107" height="18">物料料号1:</td>
<td width="176"><input name="liaohao1" type="text" id="liaohao1" onblur="CheckUserName(this.value)"/><div align="left" id="CheckUserName" class="alert"></div></td>
<td width="118">物料料号2:</td>
<td width="168"><input name="liaohao2" type="text" id="liaohao2" onblur="CheckUserName(this.value)"/><div align="left" id="CheckUserName" class="alert"></div></td>
<td width="106">物料料号3:</td>
<td width="168"><input name="liaohao3" type="text" id="liaohao3" onblur="CheckUserName(this.value)"/><div align="left" id="CheckUserName" class="alert"></div></td>
<td width="116">物料料号4:</td>
<td><input name="liaohao4" type="text" id="liaohao4" onblur="CheckUserName(this.value)"/><div align="left" id="CheckUserName" class="alert"></div></td>
</tr>
<tr>
<td height="18">物料料号5:</td>
<td><input name="liaohao5" type="text" id="liaohao5" onblur="CheckUserName(this.value)"/><div align="left" id="CheckUserName" class="alert"></div></td>
<td>物料料号6:</td>
<td><input name="liaohao6" type="text" id="liaohao6" onblur="CheckUserName(this.value)"/><div align="left" id="CheckUserName" class="alert"></div></td>
<td>物料料号7:</td>
<td><input name="liaohao7" type="text" id="liaohao7" onblur="CheckUserName(this.value)"/><div align="left" id="CheckUserName" class="alert"></div></td>
<td>物料料号8:</td>
<td><input name="liaohao8" type="text" id="liaohao8" onblur="CheckUserName(this.value)"/><div align="left" id="CheckUserName" class="alert"></div></td>
</tr>
<tr>
<td height="22">物料料号9:</td>
<td><input name="liaohao9" type="text" id="liaohao9" onblur="CheckUserName(this.value)"/><div align="left" id="CheckUserName" class="alert"></div></td>
<td>物料料号10:</td>
<td><input name="liaohao10" type="text" id="liaohao10" onblur="CheckUserName(this.value)"/><div align="left" id="CheckUserName" class="alert"></div></td>
<td>物料料号11:</td>
<td><input name="liaohao11" type="text" id="liaohao11" onblur="CheckUserName(this.value)"/><div align="left" id="CheckUserName" class="alert"></div></td>
<td>物料料号12:</td>
<td><input name="liaohao12" type="text" id="liaohao12" onblur="CheckUserName(this.value)"/><div align="left" id="CheckUserName" class="alert"></div></td>
</tr>
<tr>
<td height="18">物料料号13:</td>
<td><input name="liaohao13" type="text" id="liaohao13" onblur="CheckUserName(this.value)"/><div align="left" id="CheckUserName" class="alert"></div></td>
<td>物料料号14:</td>
<td><input name="liaohao14" type="text" id="liaohao14" onblur="CheckUserName(this.value)"/><div align="left" id="CheckUserName" class="alert"></div></td>
<td>物料料号15:</td>
<td><input name="liaohao15" type="text" id="liaohao15" onblur="CheckUserName(this.value)"/><div align="left" id="CheckUserName" class="alert"></div></td>
<td>物料料号16:</td>
<td><input name="liaohao16" type="text" id="liaohao16" onblur="CheckUserName(this.value)"/><div align="left" id="CheckUserName" class="alert"></div></td>
</tr>
<tr>
<td height="18">物料料号17:</td>
<td><input name="liaohao17" type="text" id="liaohao17" onblur="CheckUserName(this.value)"/><div align="left" id="CheckUserName" class="alert"></div></td>
<td>物料料号18:</td>
<td><input name="liaohao18" type="text" id="liaohao18" onblur="CheckUserName(this.value)"/><div align="left" id="CheckUserName" class="alert"></div></td>
<td>物料料号19:</td>
<td><input name="liaohao19" type="text" id="liaohao19" onblur="CheckUserName(this.value)"/><div align="left" id="CheckUserName" class="alert"></div></td>
<td>物料料号20:</td>
<td><input name="liaohao20" type="text" id="liaohao20" onblur="CheckUserName(this.value)"/><div align="left" id="CheckUserName" class="alert"></div></td>
</tr>
<%
end if %>
<tr>
<td colspan="8"><div align="center">
<input type="submit" name="Submit1" value="保 存" onclick="return submit1()"/>
<input type="reset" name="Submit" value="重 置" />
</div></td>
</tr>
<tr>
<td colspan="8"><span class="STYLE10">备注:带*号必须输入</span></td>
</tr>
</table>
</form>
</body>
</html>
以上是要实现批量数据验证的页面,有20个Textbox,现在已通过一个用ajax+asp的验证数据是否和数据库中的记录重复,现在想验证20个textbox的写法不会,请指教。
<!-- #include file="conn.asp" -->
<%
Response.Charset="gb2312"
if Request.ServerVariables("Request_method") <> "POST" then Response.End
if request("liaohao1")<>"" then
'response.Write request("liaohao1")&"<br>"
UserName=Trim(Request.QueryString("liaohao1"))
if not Conn.Execute("Select id From liaohao where liaohao1='"&UserName&"'" ).eof Then
Response.write("<img onload='nosubmit()' src='/jiny/Ajax_register/images/check_error.gif' align=absmiddle /> "&UserName&"料号已存在,请重新输入!")
else
Response.write("<img src='/jiny/Ajax_register/images/check_right.gif' />")
end if
end if
conn.close
set conn=nothing
%>
这个是check.asp 实现验证的功能页面
function Ajax_GetXMLHttpRequest() {
if (window.ActiveXObject) {
return new ActiveXObject("Microsoft.XMLHTTP");
}
else if (window.XMLHttpRequest) {
return new XMLHttpRequest();
}
}
function Ajax_CallBack(FormName,ID,URL){
var x = Ajax_GetXMLHttpRequest();
var ID = document.getElementById(ID);
x.open("POST",URL);
x.setRequestHeader("REFERER", location.href);
x.setRequestHeader("Content-Type", "application/x-www-form-urlencoded");
x.onreadystatechange = function(){if(x.readyState == 4 && x.status == 200 && ID){ID.innerHTML=x.responseText;}}
var encodedData=""
if (document.forms.length > 0 && FormName) {
var form = document.forms[FormName];
for (var i = 0; i < form.length; ++i) {
var element = form.elements[i];
if (element.name) {
var elementValue = null;
if (element.nodeName == "INPUT") {
var inputType = element.getAttribute("TYPE").toUpperCase();
if (inputType == "TEXT" || inputType == "PASSWORD" || inputType == "HIDDEN") {
elementValue = escape(element.value);
} else if (inputType == "CHECKBOX" || inputType == "RADIO") {
if (element.checked) {
elementValue = escape(element.value);
}
}
} else if (element.nodeName == "SELECT" || element.nodeName == "TEXTAREA") {
elementValue = escape(element.value);
}
if (elementValue) {
if(encodedData==""){
encodedData = element.name + "=" + encodeURIComponent(elementValue);
}
else{
encodedData += "&" + element.name + "=" + encodeURIComponent(elementValue);
}
}
}
}
}
x.send(encodedData);
}
//Ajax End
function ShowCheckResult(ObjectID, Message, ImageName) {
obj = document.getElementById(ObjectID);
obj.style.display = '';
obj.innerHTML = '<img src="/jiny/Ajax_register/images/check_'+ImageName+'.gif" align="absmiddle" /> ' + Message;
}
function CheckUserName(UserName) {
Ajax_CallBack(false,"CheckUserName","check1.asp?liaohao1=" + escape(UserName));
}
这个是function.js 是实现ajax功能的js.