我想通过javascript实现点击客户端浏览器打印按钮后触发服务器端对数据库的修改,服务器端修改数据库的js已有, <script language="javascript" runat="server">
var conn = new ActiveXObject("ADODB.Connection");
conn.Open("Provider=SQLOLEDB.1; Data Source=localhost; User ID=sa; "
+ "Password=password; Initial Catalog=CourseSelect");
var sql="update Table1 set aaa='myval' where bbb='testval'";
conn.execute (sql); conn.close(); conn = null;
</script> 下面该怎么办呢?请教各位高手,谢谢!
var conn = new ActiveXObject("ADODB.Connection");
conn.Open("Provider=SQLOLEDB.1; Data Source=localhost; User ID=sa; "
+ "Password=password; Initial Catalog=CourseSelect");
var sql="update Table1 set aaa='myval' where bbb='testval'";
conn.execute (sql); conn.close(); conn = null;
</script> 下面该怎么办呢?请教各位高手,谢谢!
//创建xmlHttp对象
function createXMLHttpRequest(){
var xmlHttp=false;
try{
xmlHttp = new XMLHttpRequest();
}
catch(trymicrosoft)
{
try{xmlHttp=new ActiveXObject("Msxml2.XMLHTTP");}
catch(othermicrosoft){
try{xmlHttp = new ActiveXObject("Microsoft.XMLHTTP");}
catch(failed){}
}
}
return xmlHttp;
}
//提交数据,参数url为需要访问哪个地址,比如post.aspx?id=1
function countHits(url){
var xmlHttp = createXMLHttpRequest();
xmlHttp.open("get",url,true);
xmlHttp.onreadystatechange=function(){
if(xmlHttp.readyState==4&&xmlHttp.status==200){
alert("数据提交完成");
}//end if readyState
}//eixt function
xmlHttp.send(null);
}