Tomcat5.0+MySql配置JDBC，DBCP，SSL

<service name="catalina">...    <context path="/manager" debug="0" privileged="true"             docbase="/usr/local/kinetic   /tomcat5/server/webapps/manager">    </context></service>

<context path="/manager" debug="0" privileged="true"         docbase="/usr/local/kinetic   /tomcat5/server/webapps/manager">         <valve classname="org.apache.   catalina.valves.remoteaddrvalve"                allow="127.0.0.1"/></context>

create table users (  user_name           varchar(15) not null primary key,  user_pass           varchar(15) not null);create table user_roles (  user_name           varchar(15) not null,  role_name           varchar(15) not null,  primary key (user_name, role_name));

connectionurl="jdbc:mysql://localhost/authority?user=dbuser&password=dbpass")      <realm  classname="org.apache.catalina.   realm.jdbcrealm" debug="99"             drivername="    org.gjt.mm.mysql.driver"          connectionurl="jdbc:mysql:    //localhost/ycg?user=root"         connectionname=""    connectionpassword=""              usertable="users"      usernamecol="user_name"     usercredcol="user_pass"          userroletable="user_roles"    rolenamecol="role_name" />

<parameter>    <name>removeabandoned</name>        <value>true</value>            </parameter>

<parameter>    <name>removeabandonedtimeout</name>          <value>60</value>            </parameter>

<parameter>    <name>logabandoned</name>         <value>true</value>            </parameter>

mysqladmin -u root -h localhost password "198277"

shell> mysql -h host -u user -penter password: ********//如果root没有密码,以下是不成功的.(试过了) mysql> grant all privileges on *.* to [email protected]     ->   identified by 'javadude'  with grant option;mysql> create database javatest;mysql> use javatest;mysql> create table testdata(    ->   id int not null  auto_increment primary key,    ->   foo varchar(25),     ->   bar int);在conf/server.xml中<host></host>中添加<context path="/dbtest" docbase="dbtest"        debug="5" reloadable="true"   crosscontext="true">  <logger classname="org.apache.  catalina.logger.filelogger"             prefix="localhost_dbtest_log."     suffix=".txt"             timestamp="true"/>  <resource name="jdbc/testdb"               auth="container"               type="javax.sql.datasource"/>  <resourceparams name="jdbc/testdb">    <parameter>      <name>factory</name>      <value>org.apache.commons.dbcp.   basicdatasourcefactory</value>    </parameter>    <!-- maximum number of db connections  in pool. make sure you         configure your mysqld    max_connections large enough to handle         all of your db connections.    set to 0 for no limit.         -->    <parameter>      <name>maxactive</name>      <value>100</value>    </parameter>    <!-- maximum number of idle db connections to retain in pool.         set to 0 for no limit.         -->    <parameter>      <name>maxidle</name>      <value>30</value>    </parameter>    <!-- maximum time to wait for a  db connection to become available         in ms, in this example 10   seconds. an exception is thrown if         this timeout is exceeded.    set to -1 to wait indefinitely.         -->    <parameter>      <name>maxwait</name>      <value>10000</value>    </parameter>    <!-- mysql db username and password for db connections  -->    <parameter>     <name>username</name>     <value>javauser</value>    </parameter>    <parameter>     <name>password</name>     <value>javadude</value>    </parameter>    <!-- class name for the old mm. mysql jdbc driver - uncomment this entry and comment next         if you want to use this driver   - we recommend using connector/j though    <parameter>       <name>driverclassname</name>       <value>org.gjt.mm.mysql.driver</value>    </parameter>     -->        <!-- class name for the official mysql connector/j driver -->    <parameter>       <name>driverclassname</name>       <value>com.mysql.jdbc.driver</value>    </parameter>        <!-- the jdbc connection url for  connecting to your mysql db.         the autoreconnect=true argument    to the url makes sure that the         mm.mysql jdbc driver will    automatically reconnect if mysqld closed the         connection.  mysqld by default    closes idle connections after 8 hours.         -->    <parameter>      <name>url</name>      <value>jdbc:mysql://localhost:3306  /javatest?autoreconnect=true</value>    </parameter>            <parameter>              <name>removeabandoned</name>              <value>true</value>            </parameter>             <parameter>              <name>removeabandonedtimeout</name>              <value>60</value>            </parameter>            <parameter>              <name>logabandoned</name>              <value>true</value>            </parameter>  </resourceparams></context>

<web-app xmlns="http://java.sun.com/xml/ns/j2ee"    xmlns:xsi= "http://www.w3.org/2001/xmlschema-instance"    xsi:schemalocation= "http://java.sun.com/xml/ns/j2eehttp://java.sun.com/xml/ns/j2ee/web-app_2_4.xsd"    version="2.4">  <description>mysql test app</description>  <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>

<%@ 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>

dbtest/    web-inf/        web.xml        lib/            jstl.jar            standard.jar    test.jsp

resultsfoo hellobar 12345