Javascript+access本地连接实例

来源：百度知道 编辑：UC知道 时间：2024/05/14 02:54:11
因工作需要一个Javascript+access数据库的本地连接实例·
因为我主要搞设计 对程序不大懂
程序上没什么要求 能显示数据就行
请各位高手帮帮忙 最好能将程序打包发到邮箱，谢谢。
E-mail：188154144@qq.com 谢谢了··
。。。。要javascript客户端脚本··

Public sql As String
Public res As Data.OleDb.OleDbDataReader
Dim con As New Data.OleDb.OleDbConnection
Dim com As New Data.OleDb.OleDbCommand
Dim path As String
path = System.Web.HttpContext.Current.Server.MapPath("db1.mdb")
con.ConnectionString = "Provider=Microsoft.Jet.OLEDB.4.0;Data Source=" & path & ";Persist Security Info=False"
If con.State = Data.ConnectionState.Open Then
con.Close()
Else
con.Open()
End If
If con.State = Data.ConnectionState.Closed Then
response.Write("数据库打开出错！")
response.End()
End If
com = con.CreateCommand
com2 = con.CreateCommand

sql="select * from 表名"
com.CommandText = sql
res = com.ExecuteReader
while res.Read
response.write res.GetValue(第几列的值？)
end while
res.Close()
con.Close()