Tomcat5.5.20 使用JDBC 配置Mysql 5.0.22数据库连接池

最新推荐文章于 2024-10-02 12:42:27 发布

zuzong

最新推荐文章于 2024-10-02 12:42:27 发布

阅读量1.6k

点赞数

文章标签： jdbc 数据库连接池 mysql tomcat exception documentation

本文链接：https://blog.csdn.net/zuzong/article/details/1528284

版权

咱废话不多说，http://localhost:8080 , 开始...
这是全局配法

1、TomCat Administration
    |_
       Resources
                            |_
                                    Data sources
                               |_
                                  Data Source Actions (右上角处)
                                         |_
                                            Create New Data Source(下拉菜单中选择此项)

2、在新建数据源中，设置Vaule

Property                     Value

JNDI Name:         jdbc/mysql(名字随便)
Data Source URL:              jdbc:mysql://localhost:3306/<databasename>
JDBC Driver Class:         org.gjt.mm.mysql.Driver
User Name:                        root（根据自己设置MySql的用户名来定）
Password:                           ××××××
。
。
。
。
剩下的视应用的情况来定，一般默认就可。

3、配置XML
来到TomCat的安装目录

./conf/server.xml

<Context path="/DBTest" docBase="DBTest"
        debug="5" reloadable="true" crossContext="true">

    <!-- maxActive: 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.
         -->

    <!-- maxIdle: Maximum number of idle dB connections to retain in pool.
         Set to -1 for no limit.  See also the DBCP documentation on this
         and the minEvictableIdleTimeMillis configuration parameter.
         -->

    <!-- maxWait: 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.
         -->

    <!-- username and password: MySQL dB username and password for dB connections  -->

    <!-- driverClassName: Class name for the old mm.mysql JDBC driver is
         org.gjt.mm.mysql.Driver - we recommend using Connector/J though.
         Class name for the official MySQL Connector/J driver is com.mysql.jdbc.Driver.
         -->
    
    <!-- url: 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.
         -->

  <Resource name="jdbc/TestDB（要与自己的JNDI一致）" 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?autoReconnect=true（一致）"/>

</Context>

再到

自己的WEB-INF/web.xml

<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/j2ee
http://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>

OK！重启tomcat，写个TestJsp.jsp

<%@page contentType="text/html"%>
<%@page pageEncoding="UTF-8"%>
<%@ page import="java.sql.*"%>
<%@ page import="javax.sql.*"%>
<%@ page import="javax.naming.*"%>
<%--
The taglib directive below imports the JSTL library. If you uncomment it,
you must also add the JSTL library to the project. The Add Library... action
on Libraries node in Projects view can be used to add the JSTL 1.1 library.
--%>
<%--
<%@taglib uri="http://java.sun.com/jsp/jstl/core" prefix="c"%>
--%>

<!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.01 Transitional//EN"
"http://www.w3.org/TR/html4/loose.dtd">

<html>
    <head>
        <meta http-equiv="Content-Type" content="text/html; charset=UTF-8">
        <title>JSP Page</title>
    </head>
    <body>

        <h1>JSP Page</h1>

        <%--
    This example uses JSTL, uncomment the taglib directive above.
    To test, display the page like this: index.jsp?sayHello=true&name=Murphy
    --%>
        <%--
    <c:if test="${param.sayHello}">
        
        Hello ${param.name}!
    </c:if>
    --%>

        <%

        out.println("开始>>>");

        try{
            InitialContext ct = new InitialContext();
            DataSource ds = (DataSource)ct.lookup("java:comp/env/jdbc/mysql");

            Connection conn = ds.getConnection();
            Statement stm = conn.createStatement();

            String sql = "select * from help_category";
            ResultSet rs = stm.executeQuery(sql);

            while(rs.next()){
                out.println("<br>");
                for(int i=0;i<rs.getMetaData().getColumnCount();i++){
                    out.print(rs.getString(i+1));
                }
            }

            out.print("经过'rs'循环");

        }catch(Exception ex){
            out.print("Error: "+ex.getMessage());
            ex.printStackTrace();
        }
        %>

    </body>
</html>