JSP实际是一个servlet,只不过其中输出的html代码复杂点罢了,DBConnectionManager 是连接池,下面的代码是jsp里的,也可以把它放到javabean里,看你的意思,用javabean的话不需要在jsp里建连接池,在bean里建连接池就可以了,在jsp里的到bean的数据就可以了。
<%
//System.out.println(request.getParameter("list"));//链接参数由此传入
DBConnectionManager connMgr = DBConnectionManager.getInstance();
Connection con = connMgr.getConnection("idb");
if (con == null) {
out.println("不能获取数据库连接.");
return;
} ResultSet rs = null; Statement stmt = null;
try {
stmt = con.createStatement();
rs = stmt.executeQuery("SELECT * FROM PROVINCE"); }catch(Exception ee){ee.printStackTrace();}%>
<%
//System.out.println(request.getParameter("list"));//链接参数由此传入
DBConnectionManager connMgr = DBConnectionManager.getInstance();
Connection con = connMgr.getConnection("idb");
if (con == null) {
out.println("不能获取数据库连接.");
return;
} ResultSet rs = null; Statement stmt = null;
try {
stmt = con.createStatement();
rs = stmt.executeQuery("SELECT * FROM PROVINCE"); }catch(Exception ee){ee.printStackTrace();}%>
import 类
Connection con=null;
创建该类实例test
con=test.getConnection();
这是属性文件
========================
DBINFO.propertiesdatabase[user]=aaa
database[password]=aaa
database[ConnectionPollName]=aaa=========================
package com.database;
import java.sql.*;
import java.io.*;
import java.util.Properties;
import weblogic.db.jdbc.*;import javax.naming.*;
import java.lang.String;
import java.util.*;public class ConPool
{ //class
private Properties obj_prop;
private Driver obj_dri;
private Connection obj_con;
public ConPool()
{ //ConPool()
obj_prop=null;
obj_dri=null;
obj_con=null;
} //ConPool() public Connection setConnection() //setConnection()
{
try{ //try
ResourceBundle initTbl=ResourceBundle.getBundle("DBINFO");
String str_dbusr = initTbl.getString("database[user]");
String str_dbpwd = initTbl.getString("database[password]");
String str_dbCPN = initTbl.getString("database[ConnectionPollName]"); obj_prop = new Properties();
obj_prop.setProperty("user",str_dbusr);
obj_prop.setProperty("password",str_dbpwd);
obj_dri=(Driver)Class.forName("weblogic.jdbc.pool.Driver").newInstance();
obj_con = obj_dri.connect("jdbc:weblogic:pool:"+str_dbCPN,obj_prop);
} //try
catch(Exception e){e.printStackTrace();}
return obj_con;
} //setConnection()
}
你用的时候只要:
ConPool newConPool = new ConPool();
newConPool.setConnection();
就能得到一个Connection 对象了