体会真正的Struts开发(2期) 2

 

<name>username</name>

<value>root</value>

</parameter>

<parameter>

<name>password</name>

<value></value>

</parameter>

<parameter>

<name>driverClassName</name>

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

</parameter>

<!--

   数据库地址

-->

<parameter>

<name>url</name>

<value>jdbc:mysql://localhost/test?useUnicode=true</value>

</parameter>

</ResourceParams>

</Context>

 

设置好连接池，我们对连接池进行测试

我们编写一个Servlet测试在Servlet使用连接池

代码如下

 

package com.test.web;

import java.sql.Connection;

import java.sql.PreparedStatement;

import java.sql.ResultSet;

 

import javax.naming.Context;

import javax.naming.InitialContext;

import javax.naming.NamingException;

import javax.servlet.ServletException;

import javax.servlet.http.HttpServlet;

import javax.sql.DataSource;

 

import org.apache.log4j.Logger;

/**

 * @author yanghx

* To change the template for this generated type comment go to Window -

 * Preferences - Java - Code Generation - Code and Comments

 */

public class TestServlet extends HttpServlet {

    private static Logger log = Logger.getLogger(TestServlet.class);

   

    public void init() throws ServletException {

        super.init();

        String jndiName = "java:comp/env/jdbc/mysql";

        try {

            Context ctx = new InitialContext();

            if (ctx == null) {

                log.error("找不到上下文");

                throw new Exception("找不到上下文");

            }

            DataSource ds = (DataSource) ctx.lookup(jndiName);

            Connection conn = ds.getConnection();

            PreparedStatement psmt = conn

                    .prepareStatement("select * from tbl_testhbm");

            ResultSet rs = psmt.executeQuery();

            log.info("连接池OK");

            rs.close();

        } catch (NamingException e) {

            log.error("找不到上下文" + e.getMessage());

        } catch (Exception e) {

            log.error("出现错误" + e.getMessage());

        }

    }

}