tomcat配置数据源连接(针对单个web应用)

最新推荐文章于 2022-03-15 00:35:36 发布

Dean_Deng

最新推荐文章于 2022-03-15 00:35:36 发布

阅读量727

点赞数

分类专栏： tomcat

tomcat 专栏收录该内容

4 篇文章 0 订阅

订阅专栏

如图简历web应用项目

：

在META-INF目录下建立context.xml，并配置数据源连接如下：

<?xml version="1.0" encoding="UTF-8"?>
<Context antiResourceLocking="false" privileged="true" useHttpOnly="true" >

<Resource
name="jdbc/oracle"
auth="Container"
type="javax.sql.DataSource"
maxActive="100"
maxIdle="30"
maxWait="10000"
username="scott"
password="dean"
driverClassName="oracle.jdbc.driver.OracleDriver"
url="jdbc:oracle:thin:@localhost:1521:ORCL"/>
</Context>

在WEB-INF目录下建立web.xml文件如下：

<?xml version="1.0" encoding="ISO-8859-1"?>
<web-app xmlns="http://java.sun.com/xml/ns/javaee"
xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance"
xsi:schemaLocation="http://java.sun.com/xml/ns/javaee http://java.sun.com/xml/ns/javaee/web-app_2_5.xsd"
version="2.5">
<resource-ref>
<description>oracleDBConnection</description>
<res-ref-name>jdbc/oracleDataSource</res-ref-name>
<res-type>javax.sql.DataSource</res-type>
<res-auth>Container</res-auth>
</resource-ref>
</web-app>

同时在WEB-INF目录下建立lib目录，放入oracle数据库驱动jar包：ojdbc14.jar

D:\apache-tomcat-6.0.37\webapps\OraceDataSourceTest在此目录下建立testOracleDataSource.jsp文件

代码如下：

<%@ page language="java" import="java.util.*" pageEncoding="UTF-8"%>
<%
String path = request.getContextPath();
String basePath = request.getScheme()+"://"+request.getServerName()+":"+request.getServerPort()+path+"/";
%>
<%@ page import="java.sql.*"%>
<%@ page import="javax.sql.*"%>
<%@ page import="javax.naming.*"%>
<!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.01 Transitional//EN">
<html>
<head>
<base href="<%=basePath%>">

<title>My JSP 'testPool.jsp' starting page</title>

<meta http-equiv="pragma" c>
<meta http-equiv="cache-control" c>
<meta http-equiv="expires" c>
<meta http-equiv="keywords" c>
<meta http-equiv="description" c>


</head>

<body>
This is my JSP page. <br>
<%
Connection conn;
Context initCtx=new InitialContext();
javax.sql.DataSource ds =(javax.sql.DataSource)initCtx.lookup("java:/comp/env/jdbc/oracle");
conn = ds.getConnection();
Statement stmt=conn.createStatement();
PreparedStatement ps=conn.prepareStatement("select * from emp");
ResultSet rs=ps.executeQuery();
while(rs.next()){
out.println(rs.getString(1)+" "+rs.getString(2)+" "+rs.getString(3)+"<br>");
}
rs.close();
stmt.close();
out.println("ok");
%>
</body>
</html>