TOMCat 5.5.9+Mysql5.0.15中的数据源配置

来源：互联网发布：js 滚动时间选择插件编辑：程序博客网时间：2024/05/16 00:27

1.现在%tomcat home%/conf/catalina/localhost 下面添加一段独立的context xml段,命名为MyWebProject.xml,例如

<?xml version="1.0" encoding="UTF-8"?>
<Context path="/MyWebProject" docBase="MyWebProject" debug="1" reloadable="true" crossContext="true">
</Context>

2.通过admin的界面(或手动在server.xml界面里进行配置)数据源,以mysql5.0.15为例,配置后的server.xml,只添加全局资源就可以了

<?xml version="1.0" encoding="UTF-8"?>
<Server>
<Listener className="org.apache.catalina.mbeans.GlobalResourcesLifecycleListener"/>
<Listener className="org.apache.catalina.storeconfig.StoreConfigLifecycleListener"/>
<Listener className="org.apache.catalina.mbeans.ServerLifecycleListener"/>
<GlobalNamingResources>

<Environment name="simpleValue" type="java.lang.Integer" value="30"/>

<Resource name="UserDatabase" auth="Container"
              type="org.apache.catalina.UserDatabase"
       description="User database that can be updated and saved"
           factory="org.apache.catalina.users.MemoryUserDatabaseFactory"
          pathname="conf/tomcat-users.xml" />
    <Resource
      name="mysql/test"
      type="javax.sql.DataSource"
      password="123456"
      driverClassName="com.mysql.jdbc.Driver"
      maxIdle="2"
      maxWait="5000"
      username="root"
      url="jdbc:mysql://localhost:3306/test"
      maxActive="20"/>
</GlobalNamingResources>

3.在conf下面的context.xml文件中,</Context>之前加入

<ResourceLink name="mysql/test" global="mysql/test" type="javax.sql.DataSourcer"/>

4.在你的web文件夹下面的WEB-INF中找到web.xml,在最后</web-app>之前加入

<resource-ref>
    <description>mysqlDB Connection</description>
    <res-ref-name>mysql/test</res-ref-name>
    <res-type>javax.sql.DataSource</res-type>
    <res-auth>Container</res-auth>
</resource-ref>

5:测试页面:testDataSource.jsp

<%@ page contentType="text/html;charset=gb2312" %>
<%@ page import="java.sql.*"%>
<%@ page import="javax.sql.*"%>
<%@ page import="javax.naming.*"%>
<%@ page session="false" %>
<html>
<head>
<title></title>
<%
   out.print("我的测试开始"+"<br/>");
   DataSource ds = null;
   try{
   InitialContext ctx=new InitialContext();
   ds=(DataSource)ctx.lookup("java:comp/env/dhzMySql");
   Connection conn = ds.getConnection();
   Statement stmt = conn.createStatement();
   String strSql = " select * from tabur";
   ResultSet rs = stmt.executeQuery(strSql);
   while(rs.next()){
      out.print(rs.getString(1)+"<br/>");
   }
   rs.close();
   stmt.close();
   conn.close();
out.print("我的测试结束");

}

catch(Exception ex){

out.print("出现例外，信息是:"+ex.getMessage());

ex.printStackTrace();

}

</head>

<body>

</body>

</html>