当前位置：Gxlcms > 数据库问题 > Tomcat - DBCP 配置

Tomcat - DBCP 配置

时间：2021-07-01 10:21:17 帮助过：9人阅读

ALL PRIVILEGES ON *.* TO javauser@localhost IDENTIFIED BY ‘javadude‘ WITH GRANT OPTION; CREATE DATABASE javatest; USE javatest; CREATE TABLE testdata ( id INT NOT NULL AUTO_INCREMENT PRIMARY KEY, foo VARCHAR(25), bar INT ); INSERT INTO testdata VALUES(NULL, ‘hello‘, 12345);

2. Context configuration

Configure the JNDI DataSource in Tomcat by adding a declaration for your resource to your Context.

<Resource name="jdbc/TestDB" auth="Container" type="javax.sql.DataSource"
       maxActive="100" maxIdle="30" maxWait="10000"
       username="javauser" password="javadude" driverClassName="com.mysql.jdbc.Driver"
       url="jdbc:mysql://localhost:3306/javatest"/>

3. web.xml configuration

Now create a WEB-INF/web.xml for this test application.

<?xml version="1.0" encoding="UTF-8"?>
<web-app version="2.5" 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">
    
    <resource-ref>
        <description>DB Connection</description>
        <res-ref-name>jdbc/TestDB</res-ref-name>
        <res-type>javax.sql.DataSource</res-type>
        <res-auth>Container</res-auth>
    </resource-ref>
</web-app>

4. Test code

Now create a simple test.jsp page for use later.

<%@ taglib uri="http://java.sun.com/jsp/jstl/sql" prefix="sql"%>
<%@ taglib uri="http://java.sun.com/jsp/jstl/core" prefix="c"%>

<sql:query var="rs" dataSource="jdbc/TestDB">
select id, foo, bar from testdata
</sql:query>

<html>
    <head>
        <title>DB Test</title>
    </head>
    <body>
        <h2>Results</h2>
        <c:forEach var="row" items="${rs.rows}">
            Foo ${row.foo}<br />
            Bar ${row.bar}<br />
        </c:forEach>
    </body>
</html>

Tomcat - DBCP 配置

标签：

Tomcat - DBCP 配置

人气教程排行