IDEA连接MySQL数据库的四种方法

以你之姓@ 2024-03-23 14:57 85阅读 0赞

首先右击此电脑点击管理，进入页面

![f1853893f5434d51bdd5c648637e7c5d.png][]

再服务栏确保MySQL是正常运行状态

打开IDEA,

![021ebedd88014d1e84b571fb10ff6b1f.png][]

左边栏选择Maven Archetype,新建一个名为javaweb的新工程

![2b1d9eccd20d43b595324ba9e3b80229.png][]进行如图编辑完成新建

在Main包下新建一个java包，右击java包进行下图操作，java包拥有新建class的权限

![c8d54bcb928f4e32a46ae88c8243217c.png][]

### 方法一： ###

在java下面新建一个HelloConnection1的类，用浏览器输入[https://mvnrepository.com/][https_mvnrepository.com]进入Maven网页，输入mysql![752956082a8d4919bdcb135b0c5b3522.png][]

进入 MySQL Connector Java,选择5.1.40版本进入![ea4a0c0019c14951a874351a4895e1eb.png][]

复制如下文字到IDEA中pom.xml中

![1c031df6feb64546b5dd6fbdaa19b6af.png][]

在HelloConnection1中输入如下编码

import java.sql.Connection;
    import java.sql.DriverManager;
    
    public class HelloConnection1 {
        public static void main(String[] args) {
    
            try {
                //1.加载驱动
                Class.forName("com.mysql.jdbc.Driver");
                //2.获取连接
                //jdbc:mysql://localhost:3306/test
                // 技术名字  ：连接的数据库：//ip：端口/数据库名
                Connection connection = DriverManager.getConnection("jdbc:mysql://localhost:3306/test","root","abc123");
                System.out.println(connection);
            } catch (Exception e) {
                e.printStackTrace();
            }
    
        }
    }

![f3e3391a52b246bea6dfbc2d850fd842.png][]

运行结果如上图即为连接成功

### 方法二：外部文件方式连接 ###

新建HelloConnection2的类，再新建一个file格式的文件，名为jdbc.properties,进入里面进行编辑输入如下代码

jdbc.driverClass=com.mysql.jdbc.Driver
    jdbc.url=jdbc:mysql://localhost:3306/test
    jdbc.user=root
    jdbc.poassworld=abc123

再进入类中输入代码

import java.io.InputStream;
    import java.sql.Connection;
    import java.sql.DriverManager;
    import java.util.Properties;
    
    public class HelloConnection2 {
        public static void main(String[] args) {
            Properties pro=new Properties();
            try {
                InputStream resourceAsStream = HelloConnection2.class.getClassLoader().getResourceAsStream("jdbc.properties");
    
                pro.load(resourceAsStream);
    
                String className = pro.getProperty("jdbc.driverClass");
                String url = pro.getProperty("jdbc.url");
                String user=pro.getProperty("jdbc.user");
                String password = pro.getProperty("jdbc.poassworld");
    
                Class.forName(className);
                Connection connection = DriverManager.getConnection(url, user, password);
                System.out.println(connection);
    
            } catch (Exception e) {
                e.printStackTrace();
            }
        }
    }

![38eb153e3bc34f518b4ea7729aa1e848.png][]

运行结果如上图所示即为连接成功

### 方法三：外部c3p0连接数据库 ###

![cbb37dd76b674595aa737508c32fd386.png][]

输入如下代码到pom.xml文件中，新建HelloConnection3的类，输入如下代码

###  ###

import com.mchange.v2.c3p0.ComboPooledDataSource;
    
    import java.sql.Connection;
    
    public class HelloConnection3 {
    
        public static void main(String[] args) {
    
            ComboPooledDataSource cpds = new ComboPooledDataSource();
            try {
                cpds.setDriverClass( "com.mysql.jdbc.Driver" ); //loads the jdbc driver
    
                cpds.setJdbcUrl( "jdbc:mysql://localhost:3306/test" );
                cpds.setUser("root");
                cpds.setPassword("abc123");
                Connection connection = cpds.getConnection();
                System.out.println(connection);
    
            } catch (Exception e) {
                e.printStackTrace();
            }
        }
    }

![eb236ce9124d45a8883eb9d964cd94f0.png][]

运行结果如图所示即为连接成功

### 方法四： ###

### 新建file格式文件c3p0-config.xml,输入如下代码 ###

c3p0-config>
        
        <named-config name="hello">
            <property name="driverClass">com.mysql.jdbc.Driver</property>
            <property name="jdbcUrl">jdbc:mysql://localhost:3306/test</property>
            <property name="user">root</property>
            <property name="password">abc123</property>
        </named-config>
    </c3p0-config>

新建类，HelloConnection4,输入如下代码

import com.mchange.v2.c3p0.ComboPooledDataSource;
    
    import java.sql.Connection;
    import java.sql.SQLException;
    
    public class HelloConnection4 {
        public static void main(String[] args) {
            ComboPooledDataSource cpds= new ComboPooledDataSource("hello");
            try {
                Connection connection = cpds.getConnection();
                System.out.println(connection);
            } catch (SQLException e) {
                e.printStackTrace();
            }
        }
    }

![5c8b560cbca640c7819584f65563fe30.png][]

运行结果如图所示即为连接成功

[f1853893f5434d51bdd5c648637e7c5d.png]: https://image.dandelioncloud.cn/pgy_files/images/2024/03/23/82c51151d6594585ae1d2fbb1e0342de.png
[021ebedd88014d1e84b571fb10ff6b1f.png]: https://image.dandelioncloud.cn/pgy_files/images/2024/03/23/dce0c711c5c248e1ae3ac9aa88253496.png
[2b1d9eccd20d43b595324ba9e3b80229.png]: https://image.dandelioncloud.cn/pgy_files/images/2024/03/23/7f1a1d31b9124b36a9d788ca93142fe8.png
[c8d54bcb928f4e32a46ae88c8243217c.png]: https://image.dandelioncloud.cn/pgy_files/images/2024/03/23/b8595690fdf044069408f95d8d80f44d.png
[https_mvnrepository.com]: https://mvnrepository.com/
[752956082a8d4919bdcb135b0c5b3522.png]: https://image.dandelioncloud.cn/pgy_files/images/2024/03/23/910503720c5147acbe79e9d55b5b2ad6.png
[ea4a0c0019c14951a874351a4895e1eb.png]: https://image.dandelioncloud.cn/pgy_files/images/2024/03/23/3e5aed1fb2684ffeb3d97a7ecde4bd5f.png
[1c031df6feb64546b5dd6fbdaa19b6af.png]: https://image.dandelioncloud.cn/pgy_files/images/2024/03/23/1289c40a4c7041ecab8c5a0baaec5e92.png
[f3e3391a52b246bea6dfbc2d850fd842.png]: https://image.dandelioncloud.cn/pgy_files/images/2024/03/23/ec1719948cac47e7a0db2bb0a2269b9d.png
[38eb153e3bc34f518b4ea7729aa1e848.png]: https://image.dandelioncloud.cn/pgy_files/images/2024/03/23/13c39f38dafe4998aa5b1fe06dec2076.png
[cbb37dd76b674595aa737508c32fd386.png]: https://image.dandelioncloud.cn/pgy_files/images/2024/03/23/c9436d7ea17e4ef69bc8661eefbb6dcd.png
[eb236ce9124d45a8883eb9d964cd94f0.png]: https://image.dandelioncloud.cn/pgy_files/images/2024/03/23/a40b303c38ee421fb3baaab536feda68.png
[5c8b560cbca640c7819584f65563fe30.png]: https://image.dandelioncloud.cn/pgy_files/images/2024/03/23/705fad2eaf734ab69207d146d6886b0a.png