package com.report.common.database;
import com.alibaba.druid.pool.DruidDataSource;
import com.report.common.utils.database.DbFactory;
import com.report.common.utils.database.DriverUtil;
import java.sql.*;
import java.util.concurrent.TimeUnit;
public class DruidDataSourcePerformanceTest {
// 数据库配置(需修改为实际值)
private static final String BASE_URL = "jdbc:mysql://localhost:3306/edu";
private static final String USER = "root";
private static final String PASSWORD = "123456";
private static final String DRIVER = "com.mysql.cj.jdbc.Driver";
private static final String TEST_SQL = "SELECT * FROM testbigdata";
// 两个独立数据源
private DruidDataSource normalDataSource; // 普通查询
private DruidDataSource cursorDataSource; // 游标查询
public void setup() {
// 使用原有工厂方法创建两个独立数据源
normalDataSource = createDataSource(false); // 不启用游标
cursorDataSource = createDataSource(true); // 启用游标
}
private DruidDataSource createDataSource(boolean useCursor) {
DriverUtil driverUtil = new DriverUtil();
driverUtil.setDbId("testDb_" + (useCursor ? "cursor" : "normal"));
driverUtil.setDriverName(DRIVER);
// 动态构建URL
String url
游标性能测试
最新推荐文章于 2025-04-28 15:27:03 发布