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

zuzong

浏览: 115009 次
性别:
来自: 济南

最近访客更多访客>>

guanghuiqq

commdos

haiyupeter

xuyexw

博主相关

博客

微博

相册

留言

关于我

文章分类

社区版块

存档分类

博客分类：

java

MySQL JDBC Tomcat SQL SQL Server

这是我最早在csdn发的文章，2007年3月13日，很有纪念意义啊，真的精工细作，仔仔细细的写，认真的排版，虽然现在看着还是有些简陋，但在当时对我来说真是激动啊，第一次发技术文章~~~~

咱废话不多说，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/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>

OK！重启tomcat，写个TestJsp.jsp

<%@page contentType="text/html"%>
<%@page pageEncoding="UTF-8"%>
<%@ page import="java.sql.*"%>        
<%@ page import="javax.sql.*"%>        
<%@ page import="javax.naming.*"%>

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

分享到：

enum的写法 | Spring之IOC

2008-12-21 01:17
浏览 3002
评论(2)
查看更多

2 楼 helloworld365 2009-02-11

不错，学习了

1 楼 sharp_lover 2009-02-03

虽然自己经常配置但是，对新手仍是不错的教程～～～～～

发表评论

您还没有登录,请您登录后再发表评论

最近访客更多访客>>

博主相关

文章分类

社区版块

存档分类

最新评论