package c3p0;
import com.mysql.jdbc.jdbc2.optional.MysqlDataSource;
import java.sql.Connection;
import java.sql.PreparedStatement;
import java.sql.ResultSet;
import java.sql.SQLException;
public class ConnectionDemo {
public static void main(String[] args) throws SQLException {
System.out.println("使用连接池................................");
for (int i = 0; i < 20; i++) {
long beginTime = System.currentTimeMillis();
Connection conn = ConnectionManager.getInstance().getConnection();
try {
PreparedStatement pstmt = conn.prepareStatement("select * from student");
ResultSet rs = pstmt.executeQuery();
while (rs.next()) {
// do nothing...
}
} catch (SQLException e) {
e.printStackTrace();
} finally {
try {
conn.close();
} catch (SQLException e) {
e.printStackTrace();
}
}
long endTime = System.currentTimeMillis();
System.out.println("第" + (i + 1) + "次执行花费时间为:" + (endTime - beginTime) + " ns");
}
System.out.println("不使用连接池................................");
for (int i = 0; i < 20; i++) {
long beginTime = System.currentTimeMillis();
MysqlDataSource mds = new MysqlDataSource();
mds.setURL("jdbc:mysql://localhost:3306/test?useUnicode=true&characterEncoding=utf-8&useSSL=false");
mds.setUser("root");
mds.setPassword("123456");
Connection conn = mds.getConnection();
try {
PreparedStatement pstmt = conn.prepareStatement("select * from student");
ResultSet rs = pstmt.executeQuery();
while (rs.next()) {
// do nothing...
}
} catch (SQLException e) {
e.printStackTrace();
} finally {
try {
conn.close();
} catch (SQLException e) {
e.printStackTrace();
}
}
long endTime = System.currentTimeMillis();
System.out.println("第" + (i + 1) + "次执行花费时间为:"
+ (endTime - beginTime)+" ns");
}
}
}
数据库连接池的三种实现方法
需积分: 27 5 浏览量
2018-05-10
14:00:36
上传
评论
收藏 30KB ZIP 举报
databasepool.zip （32个子文件） 
demo src test java main resources 
dbcp.properties 680B java druid Main.java 1KB ConnectionFactory.java 1KB c3p0 ConnectionManager.java 2KB ConnectionDemo.java 2KB dbcp ThreadTest.java 1KB DBManager.java 2KB target generated-sources annotations classes druid Main.class 2KB ConnectionFactory.class 1KB c3p0 ConnectionManager.class 2KB ConnectionDemo.class 3KB dbcp TheadTest2.class 996B DBManager.class 3KB ThreadTest.class 545B dbcp.properties 680B .idea libraries Maven__com_alibaba_druid_1_1_5.xml 486B Maven__me_geso_jdbcutils_2_2_0.xml 498B Maven__org_slf4j_slf4j_api_1_7_7.xml 506B Maven__mysql_mysql_connector_java_5_1_42.xml 574B Maven__com_mchange_c3p0_0_9_5_2.xml 493B Maven__commons_logging_commons_logging_1_2.xml 558B Maven__commons_pool_commons_pool_1_5_4.xml 539B Maven__commons_dbcp_commons_dbcp_1_4.xml 525B Maven__com_mchange_mchange_commons_java_0_2_11.xml 598B misc.xml 454B compiler.xml 620B uiDesigner.xml 9KB workspace.xml 37KB modules.xml 248B junitgenerator-prj-settings.xml 6KB pom.xml 2KB demo.iml 2KB资源评论
