tomcat c3p0 mysql_Tomcatc3p0配置jnid数据源2种实现方法解析

使用c3p0

导入c3p0jar包

com.mchange

c3p0

0.9.5.2

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

auth="Container"

description="DB Connection"

driverClass="com.mysql.jdbc.Driver"

maxPoolSize="100" minPoolSize="2"

acquireIncrement="2"

name="jdbc/myDB"

user="root"

password="123456"

factory="org.apache.naming.factory.BeanFactory"

type="com.mchange.v2.c3p0.ComboPooledDataSource"

jdbcUrl="jdbc:mysql://localhost:3306/attendance_system?characterEncoding=utf8&serverTimezone=GMT%2B8" />

获取连接

protected void doGet(HttpServletRequest request, HttpServletResponse response)

throws ServletException, IOException {

try {

//创建上下文

Context context=new InitialContext();

//获取数据源

ComboPooledDataSource comboPooledDataSource= (ComboPooledDataSource) context.lookup

("java:comp/env/jdbc/myDB");

//获取数据库连接

Connection connection=comboPooledDataSource.getConnection();

if(!connection.isClosed()){

System.out.println("已经连接成功");

}

} catch (NamingException e) {

e.printStackTrace();

} catch (SQLException e) {

e.printStackTrace();

}

}

使用druid

导入jar包

com.alibaba

druid

1.1.16

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

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&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();

}

}

以上就是本文的全部内容，希望对大家的学习有所帮助，也希望大家多多支持脚本之家。