求各位电脑大师帮帮,小弟不胜感激

来源:百度知道 编辑:UC知道 时间:2024/05/14 09:03:02
<html><body><%
dim objconn
set objconn=server.CreateObject("ADODB.connection")
objconn.connectionstring="provider=Microsoft.Jet.OLEDB.4.0;"&"Data source="&server.MapPath("mydb.mdb")
objconn.open
dim objrs
set objrs=server.CreateObject("ADODB.recordset")
objrs.open"学生基本情况",objconn,adopenforwardonly,adlocktype,adcmdtable
if not objrs.eof then
response.Write"学号:"&objrs("学号")&"<br>"
response.Write"姓名:"&objrs("姓名")&"<br>"
response.Write"专业:"&objrs("专业")&"<br>"
response.Write"年级: "&objrs("年级")&"<br>"
response.Write"性别:"&objrs("性别")&"<br>"
response.Write"成绩:"&objrs("成绩")&"<br>"
else
response.Write("is in end"

ASP问题啊?这个我没接触,等下面强人回答吧

open后面应该一句sql语句去查询数据库吧,不是"学生基本情况"
应该是"select * from [学生基本情况]"吧