1.创建dbcp.properties 文件
driver=com.mysql.jdbc.Driver url=jdbc:mysql://127.0.0.1:3306/zhang username=root password=123456
2.创建连接工具类
package com.util; import org.apache.commons.dbcp.BasicDataSource; import java.sql.Connection; import java.sql.SQLException; import java.util.ResourceBundle; public class MysqlDbcp { private static BasicDataSource ds; private static String driver; private static String url; private static String username; private static String password; private static void init(){ ResourceBundle bundle=ResourceBundle.getBundle("mysql"); driver=bundle.getString("driver"); url=bundle.getString("url"); username=bundle.getString("username"); password=bundle.getString("password"); ds=new BasicDataSource(); ds.setDriverClassName(driver); ds.setUrl(url); ds.setUsername(username); ds.setPassword(password); } public static Connection getConnection(){ if(ds==null){init();} Connection conn=null; try { conn=ds.getConnection(); } catch (SQLException e) { e.printStackTrace(); } return conn; } public static void closeConnection(Connection conn){ if(conn!=null){ try { conn.close(); } catch (SQLException e) { e.printStackTrace(); } } } }
end