数据源DBCP的使用

一、给项目中导jar包

在WEB-INF/lib中导入commons-dbcp.jar、commons.pool-1.5.3.jar、classes12.jar包

二、在src下创建*.properties文件

在文件中写

[plain] view plain copy

print ?

1. username=scott  
2. password=123456  
3. url=jdbc:oracle:thin:@localhost:1521:orcl  
4. driverClass=oracle.jdbc.driver.OracleDriver  
5. maxActive=100  
6. maxWait=20  

username=scott
password=123456
url=jdbc:oracle:thin:@localhost:1521:orcl
driverClass=oracle.jdbc.driver.OracleDriver
maxActive=100
maxWait=20

等属性

三、创建DBUtil.java帮助类

[java] view plain copy

print ?

1. public class DBUtil {  
2.   
3.     public static Connection getconn() {  
4.         ResourceBundle bundle = ResourceBundle.getBundle(”dbcp”);// 文件名.properties  
5.         String username = bundle.getString(”username”);  
6.         String password = bundle.getString(”password”);  
7.         String url = bundle.getString(”url”);  
8.         String driverClass = bundle.getString(”driverClass”);  
9.         int maxActive = Integer.parseInt(bundle.getString(“maxActive”));  
10.         int maxWait = Integer.parseInt(bundle.getString(“maxWait”));  
11.   
12.         BasicDataSource dataSource = new BasicDataSource();  
13.         dataSource.setUsername(username);  
14.         dataSource.setPassword(password);  
15.         dataSource.setDriverClassName(driverClass);  
16.         dataSource.setMaxActive(maxActive);  
17.         dataSource.setUrl(url);  
18.         dataSource.setMaxIdle(20);  
19.         dataSource.setMaxWait(maxWait);  
20.   
21.         try {  
22.             Connection connection = dataSource.getConnection();  
23.             return connection;  
24.         } catch (SQLException e) {  
25.             e.printStackTrace();  
26.         }  
27.         return null;  
28.     }  
29. }  

public class DBUtil {

    public static Connection getconn() {
        ResourceBundle bundle = ResourceBundle.getBundle("dbcp");// 文件名.properties
        String username = bundle.getString("username");
        String password = bundle.getString("password");
        String url = bundle.getString("url");
        String driverClass = bundle.getString("driverClass");
        int maxActive = Integer.parseInt(bundle.getString("maxActive"));
        int maxWait = Integer.parseInt(bundle.getString("maxWait"));

        BasicDataSource dataSource = new BasicDataSource();
        dataSource.setUsername(username);
        dataSource.setPassword(password);
        dataSource.setDriverClassName(driverClass);
        dataSource.setMaxActive(maxActive);
        dataSource.setUrl(url);
        dataSource.setMaxIdle(20);
        dataSource.setMaxWait(maxWait);

        try {
            Connection connection = dataSource.getConnection();
            return connection;
        } catch (SQLException e) {
            e.printStackTrace();
        }
        return null;
    }
}

这些都完成后，这前台显示就OK！是不是挺简单的呢！

[html] view plain copy

print ?

1. <%  
2.         Connection conn = DBUtil.getconn();  
3.      %>  
4.      <h1><%=conn %></h1>  

<%
        Connection conn = DBUtil.getconn();
     %>
     <h1><%=conn %></h1>