（Java）编写关于连接数据库相关设置代码

最新推荐文章于 2024-10-02 12:42:27 发布

--陳

最新推荐文章于 2024-10-02 12:42:27 发布

阅读量200

点赞数

文章标签： mysql jdbc 数据库 sql

本文链接：https://blog.csdn.net/weixin_46694903/article/details/106321816

版权

1连接数据库并对其设置相关功能.

package cn.edu.mju.project1.persiste.impl;

import com.alibaba.druid.pool.DruidAbstractDataSource;
import com.alibaba.druid.pool.DruidDataSource;

import java.sql.Connection;

public class MySqlDbUtil {
    private static DruidAbstractDataSource dataSource =null;
    private static void initDataSource(){
        if(dataSource == null){
            dataSource = new DruidDataSource();
            dataSource.setUrl("jdbc:mysql://localhost:3306/project1?serverTimezone=UTC&useUnicode=true&characterEncoding=utf8");
            dataSource.setUsername("root");
            dataSource.setPassword("root");
            dataSource.setDriverClassName("com.mysql.jdbc.Driver");

            dataSource.setInitialSize(2);
            dataSource.setMinIdle(2);
            dataSource.setMaxActive(10);

            dataSource.setMaxWait(20000);
            dataSource.setTimeBetweenConnectErrorMillis(20000);

            dataSource.setValidationQuery("SELECT 'x'");
            dataSource.setTestWhileIdle(true);
            dataSource.setTestOnBorrow(true);
        }
    }
    public static Connection getCOnnection() throws Exception{
        initDataSource();
        return dataSource.getConnection();

    }

    public static Connection getConnection() {
        return null;
    }
}

2.测试代码：

public class TestDbUtil {
    @Test
    public void testConnection(){
        try {
            MySqlDbUtil. getConnection();
        } catch (Exception e) {
            e.printStackTrace();
        }
    }
}