28,391
社区成员
发帖
与我相关
我的任务
分享
<input id="g_name" maxlength="10"size="25" name="g_name" style="border:solid 1px #535353;float:left; margin-right:10px;" onChange="Validname();" onkeyup="Validname()" /><div id="S_name" style="height:14px;width:150px;border:solid;border-width:1px;border-color:#00CC99; background: #F0FBEC;padding-top:5px;padding-left:10px;display:none;"></div>
<script language="javascript">
function Validname()
{
xmlhtml=new XMLHttpRequest();
var uname=document.getElementById("g_name").value;
var Nurl="IsName.asp?action="+uname;
if (uname!="")
{
xmlhtml.onreadystatechange=function(){
if(xmlhtml.readyState==4)
{ document.getElementById("S_name").innerHTML=xmlhtml.responseText;
}
}
}
xmlhtml.open("GET",Nurl,true);
xmlhtml.send(null);
return true;
}
</script>
'这是IsName.asp
<!--#include file="conn.asp" -->
<%
Response.ContentType="text/html"
Response.Charset="gb2312"
g_name=request.QueryString("action")
set rs=conn.execute("select top 1 * from Luser where username='"&g_name&"'")
if not rs.eof then
response.Write "<font color=#FF0000>请点击下一步</font>"
else
response.Write "<font color=#FF0000>用户名不存在</font>"
end if
Set rs=Nothing
%>
function ajaxPost(inputBoxID,refGoURL){
var oID=trim(inputBoxID);
if(oID=="") return;
var para=trim($(inputBoxID).value);
if(para=="") {alert('请输入数据...'); $(inputBoxID).focus(); return;}
var xmlHR;
var goURL=refGoURL+"?p="+para; //create the URL with the parameter
if(!xmlHR) xmlHR=createXMLHttp();
xmlHR.open('GET', goURL, true);
xmlHR.onreadystatechange = callBackFun;
//xmlHR.withCredentials = "true";
xmlHR.send(null);
function callBackFun(){
if(xmlHR.readyState == 4) {
if(xmlHR.status == 200) {
var r = xmlHR.responseText;
r=r.toLowerCase();
if(r=="ok")
alert("OK\n\nData save into DB ok.");
else
alert("False\n\nSomething wrong happend when data save into DB.");
}
}
}
}
<!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.01 Transitional//EN"
"http://www.w3.org/TR/html4/loose.dtd">
<html>
<head>
<meta http-equiv="Content-Type" content="text/html; charset=gb2312">
<title>无标题文档</title>
</head>
<style type="text/css">
*{font-family:verdana; font-size:12px;}
</style>
<!--
<script type="text/javascript" src="https://ajax.googleapis.com/ajax/libs/jquery/1.4.4/jquery.min.js" language="javascript"></script>
-->
<script language="javascript" type="text/javascript">
function $(id){
return "string" == typeof(id) ? document.getElementById(id) : id ;
}
function trim(str){
return str.replace(/^\s*|\s*$/g,"");
}
function createXMLHttp(){
var objXMLHttp;
if (window.XMLHttpRequest) {
objXMLHttp = new XMLHttpRequest();
if (objXMLHttp.overrideMimeType){
objXMLHttp.overrideMimeType("text/xml");
}
}else if(!objXMLHttp && window.ActiveXObject){
var activexName = ["MSXML2.XMLHTTP.6.0","MSXML2.XMLHTTP.5.0","MSXML2.XMLHTTP.4.0","MSXML2.XMLHTTP.3.0","MSXML2.XMLHTTP","Microsoft.XMLHTTP"];
for (var i = 0; i < activexName.length; i++) {
try{
objXMLHttp = new ActiveXObject(activexName[i]);
}catch(e){
continue;
}
if(objXMLHttp) break;
}
}
//确认XMLHTtpRequest对象创建成功
if(objXMLHttp){
return objXMLHttp;
}else{
alert("Can not create XMLHttpRequest object, maybe update your browser to new version.\n\nXMLHttpRequest对象创建失败! 请升级你的浏览器");
return;
}
}
function ajaxPost(inputBoxID,refGoURL){
var oID=trim(inputBoxID);
if(oID=="") return;
var para=trim($(inputBoxID).value);
if(para=="") {alert('请输入数据...'); return;}
var xmlHR;
var goURL=refGoURL+"?p="+para; //create the URL with the parameter
if(!xmlHR) xmlHR=createXMLHttp();
xmlHR.open('GET', goURL, true);
xmlHR.onreadystatechange = callBackFun;
xmlHR.withCredentials = "true";
xmlHR.send(null);
function callBackFun(){
if(xmlHR.readyState == 4) {
if(xmlHR.status == 200) {
var r = xmlHR.responseText;
r=r.toLowerCase();
if(r=="ok")
alert("OK\n\nData save into DB ok.");
else
alert("False\n\nSomething wrong happend when data save into DB.");
}
}
}
}
}
</script>
<body>
<br>
<br>
<br>
<input name="inx" id="inx" value="" onBlur="javascript:ajaxPost('inx','xxxPage.asp');">
<br><br>
<input name="inx2" id="inx2" value="" onBlur="javascript:ajaxPost('inx2','xxxPage.asp');">
</body>
</html>
<%
'DB connection fisrt....
dim p,reStr,xSQL
reStr="ok"
err.clear
on error resume next
p=trim(request.QueryString("p")) '//还可以其他处理
xSQL="update yourTable set xxCol ='" & p & "'" '// 这里根据你的具体情况设计SQL保存代码
'or
'xSQL="insert into yourTable(xxCol) valude ('" & p & "')" '//这里根据你的具体情况设计SQL保存代码
objDBCon.execute(xSQL)
if err.number=0 then
reStr="ok"
else
reStr="wrong"
end if
'DB close at the end ...
response.Write reStr
%>