JSP使用连接池连接数据库的问题

新客网 XKER.COM 2006-09-14 来源：收藏本文

import java.sql.*;
import java.util.*;

public class DBConnManager {
//连接池名列表
private Vector poolnames =new Vector();
//驱动程序名列表
private Vector drivernames=new Vector();
//数据库标识列表
private Vector dbids=new Vector();
//用户名列表
private Vector usernames=new Vector();
//用户密码列表
private Vector passwds=new Vector();
//最大连接数列表
private Vector maxconns=new Vector();
//连接池队列
private Hashtable connPools=new Hashtable();

public DBConnManager() {
//添加Access数据库的连接信息
poolnames.addElement("access");
drivernames.addElement("sun.jdbc.odbc.JdbcOdbcDriver");
dbids.addElement("jdbc:odbc:shopping");
usernames.addElement("");
passwds.addElement("");
maxconns.addElement("5");

//添加SQL Server2000数据库的连接信息
poolnames.addElement("sqlserver2000");
drivernames.addElement("com.microsoft.jdbc.sqlserver.SQLServerDriver");
dbids.addElement("jdbc:microsoft:sqlserver://localhost:1433;DatabserName=shopping");
usernames.addElement("");
passwds.addElement("");
maxconns.addElement("5");

//连接Mysql数据库信息
poolnames.addElement("mysql");
drivernames.addElement("org.gjt.mm.mysql.Driver");
dbids.addElement("jdbc:mysql://localhost/shopping");
usernames.addElement("");
passwds.addElement("");
maxconns.addElement("5");

//连接Oracle8i/9i数据库
poolnames.addElement("oracle");
drivernames.addElement("oracle.jdbc.driver.OracleDriver");
dbids.addElement("jdbc:oracle:thin:@localhost:1521:shopping");
usernames.addElement("");
passwds.addElement("");
maxconns.addElement("5");

//创建连接池
createPools();
}

/*将连接返回给由指定的连接池*/
public void returnConnection(String name,Connection conn){
DBConnPool pool=(DBConnPool) connPools.get(name);
if (pool!=null)
{
pool.returnConnection(conn);
}
}

/*得到一个指定连接池中的连接*/
public Connection getConnection(String name){
DBConnPool pool=(DBConnPool) connPools.get(name);
if (pool!=null)
{
return pool.getConnection();
}
return null;
}

/*关闭所有连接*/
public synchronized void closeConns(){
Enumeration allPools=connPools.elements();
while (allPools.hasMoreElements()){
DBConnPool pool=(DBConnPool) allPools.nextElement();
pool.closeConn();
}
}

/*创建连接池*/
private void createPools(){
for (int i=0;i<poolnames.size();i++)
{
String poolname=poolnames.elementAt(i).toString();
String drivername=drivernames.elementAt(i).toString();
String dbid=dbids.elementAt(i).toString();
String username=usernames.elementAt(i).toString();
String passwd=passwds.elementAt(i).toString();
int maxconn=0;
try{
maxconn=Integer.parseInt(maxconns.elementAt(i).toString());
}catch (NumberFormatException e){
e.printStackTrace();
}
DBConnPool pool=new DBConnPool(poolname,drivername,dbid,username,
passwd,maxconn);
connPools.put(poolname,pool);
}
}
}
本篇文章发表于www.xker.com(小新技术网)
下面这个是主页面.JSP文件

<%@ page contentType="text/html; charset=GBK" %>
<%@ page import ="java.sql.*" %>
<jsp:useBean id="connManager" scope="application" class="mybean.DBConnManager" />
<html>
<head>
<title>
购物商城首页
</title>
</head>
<body bgcolor="#B0C4DE">
<center><h1>欢迎访问本购物商城</h1></center>

共3页: 上一页 [1] [2] [3] 下一页

上一篇：Tomcat JSP经典配置实例下一篇：java的md5加密类(zt)

【收藏】【评论】【推荐】【投稿】【打印】【关闭】