asp下用OracleInProcServer完成对Oracle的连接和操作
来源:CSDN 时间:2008-04-13 07:10:00
< % Response.CharSet="gb2312"
tblname=request("tb")
Dim objOraSession,objOraDb
Dim strDbUser,strDbPwd,strDbConn
Call ConnectDB()
Sub ConnectDB() '连接数据库
On Error Resume Next
strDbUser = "liujincai" '连接用户名
strDbPwd = "ljc1001" '用户密码
strDbConn = "hp1" '连接字符串
Set objOraSession = Server.CreateObject("OracleInProcServer.XOraSession")
Set objOraDB = objOraSession.OpenDatabase(strDbConn,strDbUser & "/" & strDbPwd,0)
If Err.Number>0 then
Response.Write "错误 :" & err.description & ""
response.end
End if
End Sub
Sub EndDB()
Set objOraDB = Nothing
Set objOraSession = Nothing
End Sub
Function getTableList(str)
Dim strSql,strTmp
Dim objRs
strSql = "Select at.table_name as tname,au.username as uname from all_tables at,all_users au Where au.username=at.owner order by au.username"
Set objRs = objOraDb.DbCreateDynaset(strSql,0)
While Not objRs.Eof
strA = objRs("uname") & "." & objRs("tname")
If str=strA then
strTmp = strTmp & "" & strA & ""
Else
strTmp = strTmp & "" & strA & ""
End if
objRs.MoveNext
Wend
Set objRs = Nothing
getTableList = strTmp
End Function
% >
<form name=form1 action="aa.asp" method=POST target="main">
<table width="100%" border=0 align="center">
<tr><td>
All Tables : <select name="tb">
< %=getTableList(tblName)% >
</select>
<input type=hidden name="submitc" value="view">
<input type=submit name="submit" value="View Data">
<font color=red>(< %=strDbUser & "/" & strDbPwd & "@" & strDbConn% >)</font>
</td></tr>
</table>
</form>
<table border=1 cellspacing=0>
< %
if tblname<>"" then
strSql = "Select * from " & tblname
Set Rs = objOraDb.DbCreateDynaset(strSql,0)
Response.Write "<tr>"
for i=0 to rs.Fields.count-1
Response.Write "<td>" & rs.fields(i).name & "</td>"
next
Response.Write "</tr>"
While Not Rs.Eof
Response.Write "<tr>"
for i=0 to rs.fields.count -1
Response.Write "<td>" & Rs.Fields(i).Value & "</td>"
next
Response.Write "</tr>"
Rs.MoveNext
Wend
Set Rs = Nothing
end if
% >
</table>
标签:Oracle,数据库,asp
0
投稿
猜你喜欢
Python Django切换MySQL数据库实例详解
2024-01-21 02:02:47
新手入门学习python Numpy基础操作
2023-10-08 07:46:27
python中扫描条形码和二维码的实现代码
2023-02-15 23:00:12
selenium+python自动化测试之鼠标和键盘事件
2022-10-28 03:32:25
如何高效使用Python字典的方法详解
2021-07-26 04:29:03
python集合比较(交集,并集,差集)方法详解
2023-09-30 22:11:13
Fuse.js模糊查询算法学习指南
2024-04-19 11:02:54
用python给csv里的数据排序的具体代码
2021-02-15 01:12:25
Oracle数据加载和卸载的实现方法
2024-01-27 20:19:08
python使用smtplib模块发送邮件
2023-05-16 22:25:38
最适合人工智能开发的5种编程语言 附人工智能入门书籍
2023-06-02 03:15:18
Google开源的Python格式化工具YAPF的安装和使用教程
2023-02-02 12:32:16
在Python的Bottle框架中使用微信API的示例
2022-06-02 00:12:47
MySQL动态SQL拼接实例详解
2024-01-20 15:13:55
Golang使用Gin创建Restful API的实现
2024-05-21 10:24:04
python3 实现函数写文件路径的正确方法
2023-12-09 11:38:51
python中利用xml.dom模块解析xml的方法教程
2022-08-17 01:44:47
Python字典创建 遍历 添加等实用基础操作技巧
2021-05-23 22:22:31
python使用arp欺骗伪造网关的方法
2023-01-02 19:22:48
详解Python+OpenCV实现图像二值化
2022-01-02 13:08:07