学习笔记：mysql数据库与idea链接的五种方法

十个大肉包

已于 2024-08-12 13:21:50 修改

阅读量239

点赞数 10

分类专栏：学习笔记文章标签：数据库学习笔记

于 2024-07-20 18:09:55 首次发布

本文链接：https://blog.csdn.net/m0_73599442/article/details/140574729

版权

学习笔记专栏收录该内容

6 篇文章 0 订阅

订阅专栏

一、运用线程池

首先配置pom环境

<dependencies>
        <!-- c3p0连接池 -->
        <dependency>
            <groupId>c3p0</groupId>
            <artifactId>c3p0</artifactId>
            <version>0.9.1.2</version>
        </dependency>
        <!-- Druid连接池 -->
        <dependency>
            <groupId>com.alibaba</groupId>
            <artifactId>druid</artifactId>
            <version>1.2.1</version>
        </dependency>
        <dependency>
            <groupId>mysql</groupId>
            <artifactId>mysql-connector-java</artifactId>
            <version>8.0.30</version>
        </dependency>
     <!-- 测试文件 -->
        <dependency>
            <groupId>junit</groupId>
            <artifactId>junit</artifactId>
            <version>4.13.1</version>
            <scope>test</scope>
        </dependency>
    </dependencies>

1.运用c3p0链接池

    @Test
     public void c3p0() throws Exception {
        ComboPooledDataSource dataSource = new ComboPooledDataSource();
        // 设置数据库连接参数
        dataSource.setDriverClass("com.mysql.jdbc.Driver");
        dataSource.setJdbcUrl("jdbc:mysql://localhost:3306/bao");//bao：自己的数据库名
        dataSource.setUser("root");
        dataSource.setPassword("123456");
        // 获得连接对象
        Connection connection = dataSource.getConnection();
       
    }

2.运用druid链接池

    @Test
     public void c3p0() throws Exception {
   // 创建数据源
   DruidDataSource dataSource = new DruidDataSource();
   // 设置数据库连接参数
   dataSource.setDriverClassName("com.mysql.jdbc.Driver");
   dataSource.setUrl("jdbc:mysql://localhost:3306/bao");
   dataSource.setUsername("root");
   dataSource.setPassword("123456");
   // 获得连接对象
   Connection connection = dataSource.getConnection();
   System.out.println(connection);
    }

二、运用配置文件

3、读取jdbc.properties配置文件

调用jdbc.properties链接（方便修改）

    @Test
    public void C3P0ByProperties() throws Exception {
// 加载类路径下的 jdbc.properties
        ResourceBundle rb = ResourceBundle.getBundle("jdbc");
        ComboPooledDataSource dataSource = new ComboPooledDataSource();
        dataSource.setDriverClass(rb.getString("jdbc.driver"));
        dataSource.setJdbcUrl(rb.getString("jdbc.url"));
        dataSource.setUser(rb.getString("jdbc.username"));
        dataSource.setPassword(rb.getString("jdbc.password"));
        Connection connection = dataSource.getConnection();
        System.out.println(connection);
    }

三、使用applicationContext，set注入的方式

4、

 <bean id="dataSource" class="com.mchange.v2.c3p0.ComboPooledDataSource">
        <property name="driverClass" value="com.mysql.jdbc.Driver"/>
        <property name="jdbcUrl" value="jdbc:mysql://localhost:3306/bao"/>
        <property name="user" value="root"/>
        <property name="password" value="123456"/>
    </bean>

四、使用applicationContext和jdbc.properties，也方便修改

5、

<?xml version="1.0" encoding="UTF-8"?>
<beans xmlns="http://www.springframework.org/schema/beans"
       xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance"
       xmlns:context="http://www.springframework.org/schema/context"
       xsi:schemaLocation="http://www.springframework.org/schema/beans http://www.springframework.org/schema/beans/spring-beans.xsd
http://www.springframework.org/schema/context http://www.springframework.org/schema/context/spring-context.xsd">
<!--    sql活得链接对象 与jdbc.properites想关-->
    <context:property-placeholder location="classpath*:jdbc.properties" />
    <bean id="dataSourceAction" class="com.mchange.v2.c3p0.ComboPooledDataSource">
        <property name="driverClass" value="${jdbc.driver}"/>
        <property name="jdbcUrl" value="${jdbc.url}"/>
        <property name="user" value="${jdbc.username}"/>
        <property name="password" value="${jdbc.password}"/>
    </bean>
</beans>