Set OraSession=CreateObject("OracleInProcServer.XOraSession")
Set OraDatabase=OraSession.DbOpenDatabase("数据库名","用户名/密码",0)
sql="select * from 表名 "
set oraDynaset=oraDatabase.DbCreateDynaset(sql,0)
if OraDynaset.RecordCount=0 then
response.write"没有您所需要得数据,对不起"
else
response.write"<h3>查询结果</h3>"
response.write"<table border=5><tr>"
for i=0 to OraDynaset.Fields.Count-1
Response.write"<td>"
response.write OraDynaset.Fields(i).name&""
response.write "</td>"
next
response.write"</tr>"
do until oradynaset.eof
response.write"<tr>"
for i=0 to OraDynaset.Fields.Count-1
response.write"<td>"
response.write oradynaset.fields(i).value
response.write"</td>"
next
response.write"</tr>"
oradynaset.dbmovenext
loop
response.write"</table>"
end if
OraDatabase.close
连接
<%
On Error Resume Next
Set OraSession=CreateObject("OracleInProcServer.XOraSession")
Set OraDatabase=OraSession.DbOpenDatabase("数据库名","用户名/密码",0)
If Err.Number>0 Then
response.write"<h4>ASP的错误控制</h4><br>"
response.write"ASP的错误来源:"&err.source&"<br>"
response.write"ASP的错误代码:"&err.Number&"<br>"
response.write"ASP的错误说明:"&err.Descripition&"<br>"
Err.clear
response.write"<h4>Oracle OLE的错误控制</h4><br>"
response.write"Oracle的错误代码:"&OraSession.lastServerErr&"<br>"
response.write"Oracle的错误说明:"&OraSession.LastServerErrText&"<br>"
else
response.write"<center><h3>数据库连接成功</center>"
OraDatabase.close
set OraSession=nothing
End If
%>
<%
option explicit
response.buffer=true
dim conn
dim connstr
dim db
db="article.mdb"
Set conn = Server.CreateObject("ADODB.Connection")
connstr="Provider=Microsoft.Jet.OLEDB.4.0;Data Source=" & Server.MapPath(""&db&"")
conn.Open connstr
%>
这是ACCESS数据库的连接,如果转成ORACLE该怎么写?
desc table_name 可以查询表的结构
select field_name,... from ... 可以查询字段的值
select * from all_tables where table_name like '%'
select * from all_tab_columns where table_name='??'