tomcat6.0配置mysql数据库连接池

1，mysql驱动jar包：mysql-connector-java-5.1.0-bin.jar 连接文件放到$CATALINA_HOME/lib/下。
2，安装mysql数据库
3，修改$CATALINA_HOME/conf/ context.xml，<Context></Context>之间加入如下内容

        <Resource name="jdbc/mldn"  auth="Container"  type="javax.sql.DataSource"  maxActive="100"  maxIdle="30"  maxWait="10000"   username="root"    password="admin"   driverClassName="com.mysql.jdbc.Driver"    url="jdbc:mysql://localhost:3306/music_tap?autoReconnect=true" />

此时要注意修改自己的数据库的用户名和密码
数据库：music_tap
用户名：root
密码：admin
5 修改工程目录下的web.xml文件添加如下
<description>MySQL Test App</description>
  <resource-ref>
      <description>DB Connection</description>
      <res-ref-name>jdbc/music_tap</res-ref-name>
      <res-type>javax.sql.DataSource</res-type>
      <res-auth>Container</res-auth>
  </resource-ref>
6，创建数据源：

package com.amigo.dao;import javax.sql.DataSource;import javax.naming.Context;import javax.naming.InitialContext;  import javax.naming.NamingException;public class BasicDao {public static DataSource getDS() throws NamingException{Context ctx = new InitialContext();return (DataSource) ctx.lookup("java:comp/env/jdbc/music_tap");}}

具体例子一个，结合DBUtils:

package com.amigo.dao;import java.sql.SQLException;import javax.naming.NamingException;import org.apache.commons.dbutils.QueryRunner;import org.apache.commons.dbutils.ResultSetHandler;import org.apache.commons.dbutils.handlers.BeanHandler;import com.amigo.bean.loginBean;public class LoginBeanDaoImpl extends BasicDao implements LoginBeanDao {public loginBean GetClientLog(){QueryRunner run = null;try {run = new QueryRunner(getDS());} catch (NamingException e) {e.printStackTrace();}ResultSetHandler<loginBean> h = new BeanHandler<loginBean>(loginBean.class);loginBean p = null;try {p = run.query("SELECT * FROM login;",h);} catch (SQLException e) {e.printStackTrace();}return p;}}

Bean：

package com.amigo.bean;public class loginBean {int id;String usr_name;String password;public int getId() {return id;}public void setId(int id) {this.id = id;}public String getUsr_name() {return usr_name;}public void setUsr_name(String usrName) {usr_name = usrName;}public String getPassword() {return password;}public void setPassword(String password) {this.password = password;}}

打完收工，呵呵