<%
xingming=request.form("xingming")
dianhua=request.form("dianhua")
dizhi=request.form("dizhi")
shangpin=request.form("shangpin")
shuliang=request.form("shuliang")
if xingming=""or dianhu=""or dizhi=""or shangpin=""or shuliang=""then
response.Write"将资料填完整"
response.End
end if
set objconn=server.createobject("adodb.connection")
dbpath=server.MapPath("shiyan.mdb")
objconn.open"driver={microsoft access driver(*.mdb)};uid=dwdjq;pwd=789963;dbp="&dbpath
set rs=server.CreateObject("adodb.recordset")
rs.open"gouwu",objconn,adopendynamic,3
rs.addnew
rs("xingming")=xingming
rs("dianhua")=dianhua
rs("dizhi")=dizhi
rs("shangpin")=shangpin
rs("shuliang")=shuliang
rs.update
response.write"zhunihaoyun"
%>
这段代码有问题吗?怎么总是插不进数据。哪位高人救命阿!
xingming=request.form("xingming")
dianhua=request.form("dianhua")
dizhi=request.form("dizhi")
shangpin=request.form("shangpin")
shuliang=request.form("shuliang")
if xingming=""or dianhu=""or dizhi=""or shangpin=""or shuliang=""then
response.Write"将资料填完整"
response.End
end if
set objconn=server.createobject("adodb.connection")
dbpath=server.MapPath("shiyan.mdb")
objconn.open"driver={microsoft access driver(*.mdb)};uid=dwdjq;pwd=789963;dbp="&dbpath
set rs=server.CreateObject("adodb.recordset")
rs.open"gouwu",objconn,adopendynamic,3
rs.addnew
rs("xingming")=xingming
rs("dianhua")=dianhua
rs("dizhi")=dizhi
rs("shangpin")=shangpin
rs("shuliang")=shuliang
rs.update
response.write"zhunihaoyun"
%>
这段代码有问题吗?怎么总是插不进数据。哪位高人救命阿!
要不写成adOpenDynamic, adLockReadOnlyAdOpenDynamic 动态游标。可以看见其他用户所作的添加、更改和删除。允许在记录集中进行所有类型的移动,但不包括提供者不支持的书签操作。
uid=dwdjq;pwd=789963;dbp="&dbpath '应该为dbq="&dbpath
set rs=server.CreateObject("adodb.recordset")
rs.open"gouwu",objconn,adopendynamic,3
这里改为 rs.open sql语句(例如 "select * from 要添加数据的表名" ),objconn,2,3
问题还没解决。
我的表单文件代码执行后总是显示“将资料填完整”,而插入不进数据库。请问这是为什么?拜请各位帮忙看一下。代码如下:
<!--index.htm-->
<html>
<head>
<meta http-equiv="Content-Type" content="text/html; charset=gb2312">
<title>charu</title>
</head>
<body>
<form action="shiyan03.asp" method=get>
xingming<input type=text name="xingming"><br>
dianhua<input type=text name="dianhua"><br>
dizhi<input type=text name="dizhi"><br>
shangpin<input type=text name="shangpin"><br>
shuliang<input type=text name="shuliang"><br>
<input type="submit" name="action1" value="确定">
<input type="reset" name="action2" value="重置">
</form></body>
</html>
调整一下空格的位置试一试
输出一下看看是那个时空的