tomcat5.0连接池配置详细步骤

<!-- [if gte mso 9]><xml> <w:WordDocument> <w:View>Normal</w:View> <w:Zoom>0</w:Zoom> <w:PunctuationKerning/> <w:DrawingGridVerticalSpacing>7.8 磅</w:DrawingGridVerticalSpacing> <w:DisplayHorizontalDrawingGridEvery>0</w:DisplayHorizontalDrawingGridEvery> <w:DisplayVerticalDrawingGridEvery>2</w:DisplayVerticalDrawingGridEvery> <w:ValidateAgainstSchemas/> <w:SaveIfXMLInvalid>false</w:SaveIfXMLInvalid> <w:IgnoreMixedContent>false</w:IgnoreMixedContent> <w:AlwaysShowPlaceholderText>false</w:AlwaysShowPlaceholderText> <w:Compatibility> <w:SpaceForUL/> <w:BalanceSingleByteDoubleByteWidth/> <w:DoNotLeaveBackslashAlone/> <w:ULTrailSpace/> <w:DoNotExpandShiftReturn/> <w:AdjustLineHeightInTable/> <w:BreakWrappedTables/> <w:SnapToGridInCell/> <w:WrapTextWithPunct/> <w:UseAsianBreakRules/> <w:DontGrowAutofit/> <w:UseFELayout/> </w:Compatibility> <w:BrowserLevel>MicrosoftInternetExplorer4</w:BrowserLevel> </w:WordDocument> </xml><![endif]--><!-- [if gte mso 9]><xml> <w:LatentStyles DefLockedState="false" LatentStyleCount="156"> </w:LatentStyles> </xml><![endif]--> <!-- /* Font Definitions */ @font-face {font-family:宋体; panose-1:2 1 6 0 3 1 1 1 1 1; mso-font-alt:SimSun; mso-font-charset:134; mso-generic-font-family:auto; mso-font-pitch:variable; mso-font-signature:3 135135232 16 0 262145 0;} @font-face {font-family:"\@宋体"; panose-1:2 1 6 0 3 1 1 1 1 1; mso-font-charset:134; mso-generic-font-family:auto; mso-font-pitch:variable; mso-font-signature:3 135135232 16 0 262145 0;} /* Style Definitions */ p.MsoNormal, li.MsoNormal, div.MsoNormal {mso-style-parent:""; margin:0cm; margin-bottom:.0001pt; text-align:justify; text-justify:inter-ideograph; mso-pagination:none; font-size:10.5pt; mso-bidi-font-size:12.0pt; font-family:"Times New Roman"; mso-fareast-font-family:宋体; mso-font-kerning:1.0pt;} p.MsoHeader, li.MsoHeader, div.MsoHeader {margin:0cm; margin-bottom:.0001pt; text-align:center; mso-pagination:none; tab-stops:center 207.65pt right 415.3pt; layout-grid-mode:char; border:none; mso-border-bottom-alt:solid windowtext .75pt; padding:0cm; mso-padding-alt:0cm 0cm 1.0pt 0cm; font-size:9.0pt; font-family:"Times New Roman"; mso-fareast-font-family:宋体; mso-font-kerning:1.0pt;} p.MsoFooter, li.MsoFooter, div.MsoFooter {margin:0cm; margin-bottom:.0001pt; mso-pagination:none; tab-stops:center 207.65pt right 415.3pt; layout-grid-mode:char; font-size:9.0pt; font-family:"Times New Roman"; mso-fareast-font-family:宋体; mso-font-kerning:1.0pt;} /* Page Definitions */ @page {mso-page-border-surround-header:no; mso-page-border-surround-footer:no;} @page Section1 {size:595.3pt 841.9pt; margin:72.0pt 90.0pt 72.0pt 90.0pt; mso-header-margin:42.55pt; mso-footer-margin:49.6pt; mso-paper-source:0; layout-grid:15.6pt;} div.Section1 {page:Section1;} --> <!-- [if gte mso 10]> <style> /* Style Definitions */ table.MsoNormalTable {mso-style-name:普通表格; mso-tstyle-rowband-size:0; mso-tstyle-colband-size:0; mso-style-noshow:yes; mso-style-parent:""; mso-padding-alt:0cm 5.4pt 0cm 5.4pt; mso-para-margin:0cm; mso-para-margin-bottom:.0001pt; mso-pagination:widow-orphan; font-size:10.0pt; font-family:"Times New Roman"; mso-fareast-font-family:"Times New Roman"; mso-ansi-language:#0400; mso-fareast-language:#0400; mso-bidi-language:#0400;} </style> <![endif]-->

Tomcat5.0 版本。

首先，创建数据源，为了方便，用界面方式操作。

其次，在项目中 WEB.XML 的 WEB-APP 根节点下面添加

<resource-ref>

    <description>DB Connection</description>

    <res-ref-name>jdbc/testpool</res-ref-name>

    <res-type>javax.sql.DataSource</res-type>

    <res-auth>Container</res-auth>

     <res-sharing-scope>Shareable</res-sharing-scope>

</resource-ref>

接着，配置TOMCAT下conf/Catalina/localhost下的项目文件NewNongSou.xml。

<?xml version='1.0' encoding='utf-8'?>

<Context displayName="for test" docBase="H:\Program Files\Apache Software Foundation\Tomcat 5.0\webapps\NewNongSou" path="/NewNongSou">

<Resource name="jdbc/testpool" type="javax.sql.DataSource"/>

<ResourceParams name="jdbc/testpool">

<parameter>

<name>maxWait</name>

<value>5000</value>

</parameter>

<parameter>

<name>maxActive</name>

<value>10</value>

</parameter>

<parameter>

<name>password</name>

<value>123</value>

</parameter>

<parameter>

<name>url</name>

<value>jdbc:mysql://localhost:3306/agricultural</value>

</parameter>

<parameter>

<name>driverClassName</name>

<value>com.mysql.jdbc.Driver</value>

</parameter>

<parameter>

<name>maxIdle</name>

<value>5</value>

</parameter>

<parameter>

<name>username</name>

<value>root</value>

</parameter>

</ResourceParams>

</Context>

最后在TOMCAT下common/lib添加数据库驱动mysql-connector-java-5.0.6-bin.jar。

 

 

JSP 测试用例

<%@ page language = "java" contentType = "text/html; charset=UTF-8"

    pageEncoding = "UTF-8" %>

<%@ page import = "ChartDirector.*" %>

<%@ page import = "java.sql.*" %>

<%@ page import = "javax.sql.*" %>

<%@ page import = "javax.naming.*" %>

<%

// 操作数据库

DataSource ds = null ;

try {

   InitialContext ctx = new InitialContext();

   Context envCtx = (Context)ctx.lookup( "java:comp/env" );

   ds = (DataSource)envCtx.lookup( "jdbc/testpool" );

   Connection conn = ds.getConnection();

   Statement stmt = conn.createStatement();

   // test 是数据库已有的表

   // 这里的数据库是前文提及的 Data Source URL 配置里包含的数据库。

   String strSql = "SELECT * FROM t_sjny_page LIMIT 0,3" ;

   ResultSet rs = stmt.executeQuery(strSql);

   while (rs.next()) {

       System.out.print(rs.getString(1));

   }

} catch (Exception ex) {

   ex.printStackTrace();

}

%>