Tomcat - DBCP 配置-白红宇

Tomcat - DBCP 配置

阅读量：4314 次

发布时间：2019-06-06

本文共 1349 字，大约阅读时间需要 4 分钟。

1. Database configuration

Create a new test user, a new database and a single test table. Your MySQL user must have a password assigned. The driver will fail if you try to connect with an empty password.

GRANT 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.

3. web.xml configuration

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


     
             
              
       
        DB Connection
               
       
        jdbc/TestDB
               
       
        javax.sql.DataSource
               
       
        Container

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"%>
     
      select id, foo, bar from testdata
                 DB Test                Results
        
     
                  Foo ${row.foo}
      
            Bar ${row.bar}