tomcat下使用druid配置jnid数据源

导入jar包

 <!-- https://mvnrepository.com/artifact/com.alibaba/druid -->
    <dependency>
      <groupId>com.alibaba</groupId>
      <artifactId>druid</artifactId>
      <version>1.1.16</version>
    </dependency>

在tomcat的context.xml文件加入数据源配置

<Resource
    name="jdbc/MysqlDataSource"
    factory="com.alibaba.druid.pool.DruidDataSourceFactory"
    auth="Container"
    type="javax.sql.DataSource"
    driverClassName="com.mysql.cj.jdbc.Driver"
    url="jdbc:mysql://localhost:3306/yl?characterEncoding=utf8&amp;serverTimezone=GMT%2B8"
    username="root"
    password="123456"
    maxActive="50"
    maxWait="10000"
    removeabandoned="true"
    removeabandonedtimeout="60"
    logabandoned="false"
    filters="stat"/>

获取连接

protected void doGet(HttpServletRequest request, HttpServletResponse response)
            throws ServletException, IOException {
        try {
            //获取上下文对象
            Context context=new InitialContext();
            //获取数据源
            DataSource ds= (DataSource) context.lookup("java:comp/env/jdbc/MysqlDataSource");
            //获取Connection对象
            Connection connection=ds.getConnection();

            if(!connection.isClosed()){
                System.out.println("连接成功");

            }
        } catch (NamingException e) {
            e.printStackTrace();
        } catch (SQLException e) {
            e.printStackTrace();
        }
    }

记得快乐