【MySQL】JavaWeb项目中配置数据库的连接池

时间:2021-09-29 13:58:45

在META-INF目录下新建context.xml

<?xml version="1.0" encoding="UTF-8"?>
<Context>
    <Resource name="jdbc/TestDB" auth="Container" type="javax.sql.DataSource"
    maxActive="10" maxIdle="4"
    username="root" password="" driverClassName="com.mysql.jdbc.Driver"
    url="jdbc:mysql://localhost:3306/库名" />
</Context>

在DAO中获取连接实例

    public static Connection getConnect(){
        Context initContext;
        Context envContext;
        Connection con = null;
        try {
            initContext = new InitialContext();
            envContext = (Context) initContext.lookup("java:/comp/env");
            DataSource ds = (DataSource) envContext.lookup("jdbc/PriceDB");
            con = ds.getConnection();
            System.out.println("数据库连接成功");
        } catch (NamingException e) {
            // TODO Auto-generated catch block
            e.printStackTrace();
        } catch (SQLException e) {
            // TODO Auto-generated catch block
            e.printStackTrace();
        }
        
        return con;
    }