主题:一个数据库的问题
我做了一个网页把一个表单中的内容写入到数据库中去,可总是有错代码如下:
网页代码:
<!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.01 Transitional//EN"
"http://www.w3.org/TR/html4/loose.dtd">
<html>
<head>
<meta http-equiv="Content-Type" content="text/html; charset=gb2312">
<title>调查表</title>
<style type="text/css">
<!--
.style1 {
font-size: large;
font-weight: bold;
}
-->
</style>
</head>
<body>
<h2 align="center" class="style1">调查表</h2>
<hr>
<form action="3.asp" method="post">
<p>用户名:
<input type="text" name="name" size="50">
</p>
<p>密码:
<input type="password" name="pass" size="35">
</p>
<p>电子邮箱:
<input type="text" name="mailbox" size="60">
</p>
<p>家庭住址:</p>
<p> <input type="text" name="address" size="100">
</p>
<p>就读的院系:
<input type="text" name="academic" size="55" >
</p>
<p> 个人爱好:
<input type="checkbox" name="checkbox" value="跳舞">
跳舞
<input type="checkbox" name="checkbox" value="唱歌">
唱歌
<input type="checkbox" name="checkbox" value="打牌">
打牌
<input type="checkbox" name="checkbox" value="阅读">
阅读</p>
<p>性别:
<select name="select" size="1">
<option selected>男</option>
<option>女</option>
</select>
血型:
<input type="radio" name="radiobutton" value="A">
A
<input type="radio" name="radiobutton" value="B">
B
<input type="radio" name="radiobutton" value="C">
AB
<input type="radio" name="radiobutton" value="D">
O
</p>
<p>
<input type="submit" name="Submit" value="提交">
</p>
</body>
</html>
ASP代码:
<%Response.Expires=0%>
<html>
<head>
<title>数据库的应用</title>
</head>
<body bgcolor=white>
<%
Set Conn=Server.CreateObject("ADODB.Connection")
Conn.Open "sj"
name=request.form("name")
password=request.form("pass")
mailbox=request.form("mailbox")
address=request.form("address")
academic=request.form("academic")
like=request.form("checkbox")
sex=request.form("select")
blood=request.form("radiobutton")
exec="insert into blank(name,password,mailbox,address,academic,like,sex,blood)values('"+name+"','"+pass+"','"+mailbox+"','"+address+"','"+academic+"','"+checkbox+"','"+select+"','"+radiobutton+"')"
conn.execute exec
conn.close
set conn=nothing
response.write "记录添加成功!"
%>
<a href="litao.mdb">数据库</a>
</body>
</html>
总提示“like=request.form("checkbox")”有问题,这是为什么
网页代码:
<!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.01 Transitional//EN"
"http://www.w3.org/TR/html4/loose.dtd">
<html>
<head>
<meta http-equiv="Content-Type" content="text/html; charset=gb2312">
<title>调查表</title>
<style type="text/css">
<!--
.style1 {
font-size: large;
font-weight: bold;
}
-->
</style>
</head>
<body>
<h2 align="center" class="style1">调查表</h2>
<hr>
<form action="3.asp" method="post">
<p>用户名:
<input type="text" name="name" size="50">
</p>
<p>密码:
<input type="password" name="pass" size="35">
</p>
<p>电子邮箱:
<input type="text" name="mailbox" size="60">
</p>
<p>家庭住址:</p>
<p> <input type="text" name="address" size="100">
</p>
<p>就读的院系:
<input type="text" name="academic" size="55" >
</p>
<p> 个人爱好:
<input type="checkbox" name="checkbox" value="跳舞">
跳舞
<input type="checkbox" name="checkbox" value="唱歌">
唱歌
<input type="checkbox" name="checkbox" value="打牌">
打牌
<input type="checkbox" name="checkbox" value="阅读">
阅读</p>
<p>性别:
<select name="select" size="1">
<option selected>男</option>
<option>女</option>
</select>
血型:
<input type="radio" name="radiobutton" value="A">
A
<input type="radio" name="radiobutton" value="B">
B
<input type="radio" name="radiobutton" value="C">
AB
<input type="radio" name="radiobutton" value="D">
O
</p>
<p>
<input type="submit" name="Submit" value="提交">
</p>
</body>
</html>
ASP代码:
<%Response.Expires=0%>
<html>
<head>
<title>数据库的应用</title>
</head>
<body bgcolor=white>
<%
Set Conn=Server.CreateObject("ADODB.Connection")
Conn.Open "sj"
name=request.form("name")
password=request.form("pass")
mailbox=request.form("mailbox")
address=request.form("address")
academic=request.form("academic")
like=request.form("checkbox")
sex=request.form("select")
blood=request.form("radiobutton")
exec="insert into blank(name,password,mailbox,address,academic,like,sex,blood)values('"+name+"','"+pass+"','"+mailbox+"','"+address+"','"+academic+"','"+checkbox+"','"+select+"','"+radiobutton+"')"
conn.execute exec
conn.close
set conn=nothing
response.write "记录添加成功!"
%>
<a href="litao.mdb">数据库</a>
</body>
</html>
总提示“like=request.form("checkbox")”有问题,这是为什么