数据源DBCP的使用

2019-11-06 06:42:53

字体：大中小

来源：转载

供稿：网友

一、给项目中导jar包

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

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

在文件中写[plain] view plain copy print?username=scott passWord=123456 url=jdbc:Oracle:thin:@localhost:1521:orcl driverClass=oracle.jdbc.driver.OracleDriver maxActive=100 maxWait=20

username=scottpassword=123456url=jdbc:oracle:thin:@localhost:1521:orcldriverClass=oracle.jdbc.driver.OracleDrivermaxActive=100maxWait=20等属性
三、创建DBUtil.java帮助类
[java] view plain copy print?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;      }  }  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?<%          Connection conn = DBUtil.getconn();       %>       <h1><%=conn %></h1>  <%        Connection conn = DBUtil.getconn();     %>     <h1><%=conn %></h1>