吉他弹唱谱突然的自我:怎么实现网页和数据库的连接

来源:百度文库 编辑:中科新闻网 时间:2024/04/28 18:00:18

ASP,连接ACCESS数据库

<%
set conn=server.createobject("ADODB.Connection")
filepath=server.mappath("Data.mdb") ''-------假设数据库文件是"Data.mdb"
conn.Open "driver={Microsoft Access Driver (*.mdb)};dbq=" & filepath
%>
2、查询数据库
<%
set rs=server.createobject("ADODB.Recordset")
sql="select * from Tb_UserName"
rs.open sql,conn,1,1
%>
3、显示表里的数据
<%
Response.Write "<table border=1>"
Do While Not rs.Eof
For i=0 to Fields.Count-1
Response.Write "<tr><td>"
Response.Write rs(i)
Response.Write "</tr></td>"
Next
rs.MoveNext
Loop
Response.Write "</table>"
%>
好好研究吧!
---------------------------------------------------------------

连接ACCESS数据库的几种方法:
1.
set dbconnection=Server.CREATEOBJECT("ADODB.CONNECTION")
DBPath = Server.MapPath("customer.mdb")
dbconnection.Open "driver={Microsoft Access Driver (*.mdb)};dbq=" & DBPath
SQL="select * from auth where id="" & user_id &"""
SET uplist=dbconnection.EXECUTE(SQL)

2.
set dbconnection=Server.CreateObject("ADODB.Connection")
DBPath = Server.MapPath("customer.mdb")
dbconnection.Open "provider=microsoft.jet.oledb.4.0;data source="&dbpath
SQL="select * from auth where id="" & user_id &"""
SET uplist=dbconnection.EXECUTE(SQL)

3.
DBPath = Server.MapPath("customer.mdb")
set session("rs")=Server.CreateObject("ADODB.Recordset")
" rs=Server.CreateObject("ADODB.Recordset")
connstr="provider=microsoft.jet.oledb.4.0;data source="&dbpath
SQL="select * from auth where id="" & user_id &"""
session("rs").Open sql,connstr,1,3

4.
建odbc源xxx
set conn=server.createobject("Adodb.connection")
conn.open "DSN=xxx;UID=;PWD=;Database=customer

显示数据:
Response.write rs("字段名")

什么语言啊? 什么数据库阿? 访问量大约有多少啊? 是企业级应用还是课程设计?

什么都不知道怎么写?