java常用的连接池01

来源：互联网发布：visio2013网络图标库编辑：程序博客网时间：2024/06/05 10:41

1.在Tomcat中使用数据库连接池

1)在server.xml文件中配置数据库连接池

<Context path="/dataTest01" reloadable="true" docBase="E:\Users\Administrator\J2eeWorkspace\DataTest01\WebContent">  <Manager className="org.apache.catalina.session.PersistentManager">    debug=0 saveOnRestart="true"    maxActiveSession="-1" minIdleSwap="-1"    maxIdleSwap="-1" maxIdleBackup="-1"   <Store className="org.apache.catalina.session.FileStore" directory="d:\temp"/>   </Manager>   <Resource name="anthony"      auth="Container"    type="javax.sql.DataSource"     maxActive="100"      maxIdle="30"       maxWait="10000"      username="root"      password="123456"      driverClassName="org.gjt.mm.mysql.Driver"     url="jdbc:mysql://localhost:3306/demo"/>  </Context>

2)配置web.xml

<resource-ref><res-ref-name>anthony</res-ref-name><res-type>javax.sql.DataSource</res-type><res-auth>Container</res-auth></resource-ref>

3)连接数据库

package com.anthony.demo ;import java.sql.* ;import javax.sql.* ;import javax.naming.* ;public class DatabaseConnection {private static final String DSNAME = "java:comp/env/demo" ;private Connection conn ;public DatabaseConnection() throws Exception {Context ctx = new InitialContext() ;DataSource ds = (DataSource) ctx.lookup(DSNAME) ;this.conn = ds.getConnection() ;}public Connection getConnection(){return this.conn ;}public void close() throws Exception {if(this.conn != null){try{this.conn.close() ;}catch(Exception e){throw e ;}}}}

4.用JSP完成连接

<%@ page language="java" contentType="text/html; charset=ISO-8859-1"    pageEncoding="ISO-8859-1"%><%@ page import="javax.naming.*"%><%@ page import="javax.sql.*"%><%@ page import="java.sql.*"%><!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=ISO-8859-1"><title>Insert title here</title></head><body><%String DSNAME = "java:comp/env/anthony" ;

Context ctx = new InitialContext() ;DataSource ds = (DataSource) ctx.lookup(DSNAME) ;Connection conn = ds.getConnection() ;

%><%=conn%><%conn.close() ;

%></body></html>

6.测试

http://localhost/dataTest01/data.jsp

未完待续。。。。。