WEBLOGIC6.1的ORACLE数据库连接！

[stYy2002]

我在weblogic中是这样设置的。请问我在JSP页面中如何实现连接oracle数据库呢？
请提供代码！连接sqlserver是否也一样呢？
JDBC Connection Pools的设置
Name:oraclePool
URL:jdbc:oracle:thin:@localhost:1521:oradb
Driver Classname:oracle.jdbc.driver.OracleDriver
Properties(key=value):
user=scott
password=tiger

JDBC Data Sources的设置
Name:mySourcesTest
JNDI Name:mySourcesTest
Pool Name:oraclePool

[ylunar]

<%@ page import="java.sql.*" %>
<%@ page import="javax.sql.*" %>
<%@ page import="javax.naming.*" %>
<%@ page import="javax.ejb.*" %>


<%
Connection con=null;
try{
Context initialContext=null;
initialContext=new InitialContext();
DataSource dataSource=(DataSource)initialContext.lookup("mySourcesTest");
con=dataSource.getConnection();
PreparedStatement stm=con.prepareStatement("select * from tree");
ResultSet result=stm.executeQuery();
result.next();
out.println(result.getString("link"));
}
catch(Exception e)
{System.out.println(e.getMessage());}
finally
{con.close();}

%>

[ylunar]

连接sqlserver也一样,你只需要改变连接池的配置就行了，不需要更改以上jsp程序。