---
title: "体会真正的Struts开发(2期) 2"
author: "fanjava"
date: "2004-06-27T19:01:00Z"
tags: []
slug: "struts-2-2"
draft: false
lastmod: "2004-06-27T19:01:00Z"
id: 601990
url: "https://fanjava.iteye.com/blog/601990"
---

&lt;?xml:namespace prefix = o ns = "urn:schemas-microsoft-com:office:office" /&gt;

**&lt;name&gt;username&lt;/name&gt;**

**&lt;value&gt;root&lt;/value&gt;**

**&lt;/parameter&gt;**

**&lt;parameter&gt;**

**&lt;name&gt;password&lt;/name&gt;**

**&lt;value&gt;&lt;/value&gt;**

**&lt;/parameter&gt;**

**&lt;parameter&gt;**

**&lt;name&gt;driverClassName&lt;/name&gt;**

**&lt;value&gt;com.mysql.jdbc.Driver&lt;/value&gt;**

**&lt;/parameter&gt;**

&lt;!--

数据库地址

--&gt;

**&lt;parameter&gt;**

**&lt;name&gt;url&lt;/name&gt;**

**&lt;value&gt;jdbc:mysql://localhost/test?useUnicode=true&lt;/value&gt;**

**&lt;/parameter&gt;**

**&lt;/ResourceParams&gt;**

**&lt;/Context&gt;**

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

我们编写一个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());

}

}

}