1.打开Tomcat 6.0\conf\context.xml文件,编辑成如下代码形式:
<?xml version='1.0' encoding='utf-8'?>
type="javax.sql.DataSource" driverClassName="oracle.jdbc.OracleDriver" url="jdbc:oracle:thin:@127.0.0.1:1521:ghyghost" username="sa"password="123"maxActive="200"maxIdle="10" maxWait="-1"/>
2.然后在web.xml文件中的web-app节点下加入如下代码形式:
pinyou connection oracle9ijdbc/ghyghostjavax.sql.DataSource
3.新建一个JSP文件如下:
try {
Context envContext = (Context) new InitialContext()
.lookup("java:/comp/env");
DataSource ds = (DataSource) envContext.lookup("jdbc/pinyou"); //查找配置
Connection conn = ds.getConnection();
Statement st = conn.createStatement();
ResultSet rs = st.executeQuery("select pyid from pyinfo");
while (rs.next()) {
out.println(rs.getString("pyid") + "
");
}
} catch (NamingException e) {
e.printStackTrace();
} catch (SQLException e) {
e.printStackTrace();
}
%>
4.别忘了将ORACLE的JDBC驱动放入到TOMCAT的lib目录中。
OVER!~