本人编写了如下程序,目的就是当用户从下拉选择框选择一个数据id号,就连接数据库,从库中提取数据,然后更新文本框的数据,请问高手如何用javascript或用vbscript编写程序,下列程序出错在那里?请高手写出程序来,谢谢!
<html>
<head>
<meta http-equiv="Content-Language" content="zh-cn">
<meta name="GENERATOR" content="Microsoft FrontPage 4.0">
<meta name="ProgId" content="FrontPage.Editor.Document">
<meta http-equiv="Content-Type" content="text/html; charset=gb2312">
<title>网上考试系统</title>
<link rel="stylesheet" type="text/css" href="../css.css">
</head><body topmargin="0" leftmargin="0">
<p>
<p align="center"><font class=test1>试卷管理理</font></p>
<div align="center">
<center>
<form name=form1 action="">
请选择要修改的ID:
<select name="sjid" size="1" align="center" onchange="selectedMade()">
<option value="1"> 1
<option value="2"> 2
<option value="3"> 3
<option value="4"> 4 </select> <input type="text" name="tkt" size="5" class="line" value="">
</form>
</center>
<script language=javascript>
function selectedMade() {
sjid=document.form1.sjid.value;
var db="../data/test_admin.mdb";
var str = "Provider = Microsoft.Jet.OLEDB.4.0;Data Source= "+Server.MapPath(""&db&"");
var Conn=Server.CreateObject("ADODB.Connection");
Conn.Open(str);
var sjrs= Server.CreateObject("ADODB.RecordSet");
var sql="select * from test where 试卷id= '" & sjid & "'";
sjrs.Open sql,Conn,3,3;
if not sjrs.EOF){
document.form1.tkt=sjrs("填空题数");
}
}
</script>
</body>
</html>
<html>
<head>
<meta http-equiv="Content-Language" content="zh-cn">
<meta name="GENERATOR" content="Microsoft FrontPage 4.0">
<meta name="ProgId" content="FrontPage.Editor.Document">
<meta http-equiv="Content-Type" content="text/html; charset=gb2312">
<title>网上考试系统</title>
<link rel="stylesheet" type="text/css" href="../css.css">
</head><body topmargin="0" leftmargin="0">
<p>
<p align="center"><font class=test1>试卷管理理</font></p>
<div align="center">
<center>
<form name=form1 action="">
请选择要修改的ID:
<select name="sjid" size="1" align="center" onchange="selectedMade()">
<option value="1"> 1
<option value="2"> 2
<option value="3"> 3
<option value="4"> 4 </select> <input type="text" name="tkt" size="5" class="line" value="">
</form>
</center>
<script language=javascript>
function selectedMade() {
sjid=document.form1.sjid.value;
var db="../data/test_admin.mdb";
var str = "Provider = Microsoft.Jet.OLEDB.4.0;Data Source= "+Server.MapPath(""&db&"");
var Conn=Server.CreateObject("ADODB.Connection");
Conn.Open(str);
var sjrs= Server.CreateObject("ADODB.RecordSet");
var sql="select * from test where 试卷id= '" & sjid & "'";
sjrs.Open sql,Conn,3,3;
if not sjrs.EOF){
document.form1.tkt=sjrs("填空题数");
}
}
</script>
</body>
</html>
解决方案 »
- [分享] csdn你就天天改你那个破登录页面吧...
- js高手看过来,这个点击切换选项卡代码为什么点击选项卡1会出错?掉到下边了,点击选项卡2效果正确的
- 网页如何自适应浏览器客户端
- JS如何实现页面刷新后单选框状态的保留!急1
- 关于在document对象上绑定事件
- 小问题求解
- 一个急的问题:请问怎么清空某个table
- 在一个TEXT中如何触发回车事件???在线等
- 如何用Up Arrow和Down Arrow两键分别实现Tab和Shift Tab键功能,谢谢!
- 下面出错???:<input type=button name=min value=min onclick="window.moveto(1000,2000)">
- 如何传递一个document对象?
- 如何将数据库中的数据赋值到JavaScript数组中
Server对象是ASP里固有的,在JS里无法引用.
Server.MapPath无效.
Server.CreateObject可改作new ActiveXObject()
其它的sjrs.Open sql,Conn,3,3;改为sjrs.Open(sql,Conn,3,3)
总之,你这种方式是不安全的..