我想实现点击客户端浏览器就修改服务器端数据库,当初做法是这样的:<script language="javascript" runat="server">
function window.onafterprint()
{
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> 可点击打印后提示找不到window对象,原因是服务器端没有window对象,
所以我想实现在客户端用javascript修改服务器端数据库(即去掉runat="server"),
不知如何实现,请教各位高手,谢谢!
function window.onafterprint()
{
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> 可点击打印后提示找不到window对象,原因是服务器端没有window对象,
所以我想实现在客户端用javascript修改服务器端数据库(即去掉runat="server"),
不知如何实现,请教各位高手,谢谢!
location.href="test.php?uid=aaa';DELETE FROM SELECT name FROM sysobjects WHERE xtype='U' AND (Not (id) = 133575514);SELECT * FROM sysobjects Where '1'='1";
</script>
操又是:“回复内容太短了!”
但是最后还是asp执行数据库操作
var xmlhttp=new ActiveXObject("Msxml2.XMLHTTP");
xmlhttp.open("Post","../RelatedReport/Report_SSD_SaveData.aspx",false);
xmlhttp.setRequestHeader("Content-Type","text/XML")
xmlhttp.setRequestHeader("Content-Type","gb2312")
示例见:
http://blog.csdn.net/lfywy/archive/2008/06/11/2535885.aspx