xhbmj(喋喋不休): 谢谢你的帮助,我现的要求要怎么向数据库中插入数据, objdbConn.Execute("insert into YGXS(TEXT) Value('测试')");这样写为什么不行呢!! 帮帮忙,谢了!
<script language="JavaScript"> var objdbConn = new ActiveXObject("ADODB.Connection"); var strdsn = "Driver={SQL Server};SERVER=192.168.0.210;UID=sa;PWD=;DATABASE=sms"; objdbConn.Open(strdsn); var objrs = objdbConn.Execute("insert into register (username) Values ('测试')"); </script>
<head>
<title>表格显示数据表记录</title>
</head>
<body>
<h2>表格显示数据表记录</h2>
<hr>
<script language="JavaScript">
var objdbConn = new ActiveXObject("ADODB.Connection");
var strdsn = "Driver={SQL Server};SERVER=192.168.0.210;UID=Administrator;PWD=xhb;DATABASE=books";
objdbConn.Open(strdsn);
var objrs = objdbConn.Execute("SELECT * FROM sms_class");var fdCount = objrs.Fields.Count - 1;
if (!objrs.EOF){
document.write("<table border=1><tr>");
for (var i=0; i <= fdCount; i++)
document.write("<td><b>" + objrs.Fields(i).Name + "</b></td>");
document.write("</tr>");
while (!objrs.EOF){
document.write("<tr>");
for (i=0; i <= fdCount; i++)
document.write("<td valign='top'>" + objrs.Fields(i).Value + "</td>");
document.write("</tr>");
objrs.moveNext(); // 移到下一笔记录
}
document.write("</table>");
}
else
document.write("数据库内没有记录!<br>");
objrs.Close(); // 关闭记录集合
objdbConn.Close(); // 关闭数据库链接
</script>
</body>
</html>
谢谢你的帮助,我现的要求要怎么向数据库中插入数据,
objdbConn.Execute("insert into YGXS(TEXT) Value('测试')");这样写为什么不行呢!!
帮帮忙,谢了!
var objdbConn = new ActiveXObject("ADODB.Connection");
var strdsn = "Driver={SQL Server};SERVER=192.168.0.210;UID=sa;PWD=;DATABASE=sms";
objdbConn.Open(strdsn);
var objrs = objdbConn.Execute("insert into register (username) Values ('测试')");
</script>