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
投稿
猜你喜欢
使用ASP订制自己的XML文件读写方法
2008-10-24 09:35:00
整理各种js按比例缩放图片方法
2007-09-27 20:01:00
XML DOM介绍和例子
2007-10-15 20:23:00
网页设计细节不能丢
2007-09-26 11:54:00
Doctype之谜
2009-07-22 20:48:00
一个Access数据库数据传递的实例方法
2008-11-28 16:24:00
ASP四级连动下拉列表程序段
2009-07-03 15:33:00
Oracle RMAN快速入门指南
2010-07-18 12:50:00
从MySQL 5.5发布看开源数据库新模式
2010-01-03 19:54:00
ASP动态生成的javascript表单验证代码
2008-10-13 20:11:00
在SQL Server 2000数据仓库中使用分区
2008-12-23 13:52:00
形成视觉冲击的几种方式
2008-08-03 15:57:00
快速掌握怎样选择准备安装的 MySQL版本
2008-12-17 16:42:00
如何实现表单提交时提示正在发送
2008-12-23 13:30:00
Oracle密码文件的使用和维护第1/3页
2010-07-30 12:43:00
Div即父容器不根据内容自适应高度的解决方法
2010-04-23 18:19:00
13个超级有用的 jQuery 内容滚动插件和教程
2011-08-10 19:10:08
细化解析:SQL Server 2000 的各种版本
2009-02-05 15:41:00
SqlServer 索引自动优化工具
2012-10-07 10:41:09
plsql和tsql常用函数比对
2009-09-13 17:50:00