我用下面的代码把AAA和BBB两个文本框的值插入到SQL2005(数据库:webgps, 表:Privacy,字段是pri_lat,pri_lot)
为什么存不进去?function res() { //获取输入值(myname和mymail是两个文本框的id)
var uname = document.getElementById("AAA").value;
var umail = document.getElementById("BBB").value;
//数据库连接对象
var con = new ActiveXObject("ADODB.Connection"); //连接字符串
var str = "DRIVER={SQL SERVER}; SERVER=(ST-DD7E7D887C27); uid=sa; pwd=123; database=webgps";
//打开数据源
con.Open(str);
//sql语句
var sql = "insert into Privacy(pri_lat,pri_lot) values('" + uname + "','" + umail + "')";
try {
//执行sql语句
con.Execute(sql);
//关闭连接
con.Close();
//转向成功页面
window.location.href = " http://www.aspxcs.net/";
}
catch (e) {
alert(e);
}
}
为什么存不进去?function res() { //获取输入值(myname和mymail是两个文本框的id)
var uname = document.getElementById("AAA").value;
var umail = document.getElementById("BBB").value;
//数据库连接对象
var con = new ActiveXObject("ADODB.Connection"); //连接字符串
var str = "DRIVER={SQL SERVER}; SERVER=(ST-DD7E7D887C27); uid=sa; pwd=123; database=webgps";
//打开数据源
con.Open(str);
//sql语句
var sql = "insert into Privacy(pri_lat,pri_lot) values('" + uname + "','" + umail + "')";
try {
//执行sql语句
con.Execute(sql);
//关闭连接
con.Close();
//转向成功页面
window.location.href = " http://www.aspxcs.net/";
}
catch (e) {
alert(e);
}
}
有JDBC驱动的,代码哪有问题啊?谢谢
Ajax怎么链接????谢谢