在IntelliJ IDEA中使用Java连接MySQL数据库

朱雀 2023-10-05 12:56 146阅读 0赞

## 一、下载MySQL数据库并进行安装和配置 ##

下载地址：[https://dev.mysql.com/downloads/installer/][https_dev.mysql.com_downloads_installer]

![在这里插入图片描述][watermark_type_ZmFuZ3poZW5naGVpdGk_shadow_10_text_aHR0cHM6Ly9ibG9nLmNzZG4ubmV0L1ExMzY4MDg5MzIz_size_16_color_FFFFFF_t_70_pic_center]

MySQL的官网上提供了两个共享版本的安装包，一个2.5M，一个405.2M。  
二者区别：  
第一个是联网安装包，安装时必须能访问互联网。  
第二个是离线安装包，一般建议下载离线安装使用的版本。

## 二、下载JDBC连接器 ##

下载地址：[https://dev.mysql.com/downloads/connector/j/][https_dev.mysql.com_downloads_connector_j]

![在这里插入图片描述][watermark_type_ZmFuZ3poZW5naGVpdGk_shadow_10_text_aHR0cHM6Ly9ibG9nLmNzZG4ubmV0L1ExMzY4MDg5MzIz_size_16_color_FFFFFF_t_70_pic_center 1]  
![在这里插入图片描述][watermark_type_ZmFuZ3poZW5naGVpdGk_shadow_10_text_aHR0cHM6Ly9ibG9nLmNzZG4ubmV0L1ExMzY4MDg5MzIz_size_16_color_FFFFFF_t_70_pic_center 2]  
下载好压缩包并解压后找到mysql-connector-java-8.0.22.jar文件放在自己指定的路径下。

## 三、在项目中导入jar包 ##

![在这里插入图片描述][watermark_type_ZmFuZ3poZW5naGVpdGk_shadow_10_text_aHR0cHM6Ly9ibG9nLmNzZG4ubmV0L1ExMzY4MDg5MzIz_size_16_color_FFFFFF_t_70_pic_center 3]  
  
  
**用于测试数据库连接的测试类Test.java代码：**

import java.sql.Connection;
    import java.sql.DriverManager;
    
    public class Test {
        
        public static void main(String[] args) {
        
            String driverName = "com.mysql.cj.jdbc.Driver";
            
            String dbURL="jdbc:mysql://localhost:3306/websql?&useSSL=false&serverTimezone=Asia/Shanghai";  //websql为数据库名
            
            String userName = "root";
            
            String userPwd = "root";
            
            try {
        
                Class.forName(driverName);
                
                Connection con= DriverManager.getConnection(dbURL, userName, userPwd);
                
                System.out.println("连接数据库成功");
                
            }  catch (Exception e) {
        
    
                e.printStackTrace();
    
                System.out.print("连接失败");
    
            }
        }
    
    }

[https_dev.mysql.com_downloads_installer]: https://dev.mysql.com/downloads/installer/
[watermark_type_ZmFuZ3poZW5naGVpdGk_shadow_10_text_aHR0cHM6Ly9ibG9nLmNzZG4ubmV0L1ExMzY4MDg5MzIz_size_16_color_FFFFFF_t_70_pic_center]: https://img-blog.csdnimg.cn/2020110411353880.PNG?x-oss-process=image/watermark,type_ZmFuZ3poZW5naGVpdGk,shadow_10,text_aHR0cHM6Ly9ibG9nLmNzZG4ubmV0L1ExMzY4MDg5MzIz,size_16,color_FFFFFF,t_70#pic_center
[https_dev.mysql.com_downloads_connector_j]: https://dev.mysql.com/downloads/connector/j/
[watermark_type_ZmFuZ3poZW5naGVpdGk_shadow_10_text_aHR0cHM6Ly9ibG9nLmNzZG4ubmV0L1ExMzY4MDg5MzIz_size_16_color_FFFFFF_t_70_pic_center 1]: https://img-blog.csdnimg.cn/20201030231610303.png?x-oss-process=image/watermark,type_ZmFuZ3poZW5naGVpdGk,shadow_10,text_aHR0cHM6Ly9ibG9nLmNzZG4ubmV0L1ExMzY4MDg5MzIz,size_16,color_FFFFFF,t_70#pic_center
[watermark_type_ZmFuZ3poZW5naGVpdGk_shadow_10_text_aHR0cHM6Ly9ibG9nLmNzZG4ubmV0L1ExMzY4MDg5MzIz_size_16_color_FFFFFF_t_70_pic_center 2]: https://img-blog.csdnimg.cn/20201030232014911.PNG?x-oss-process=image/watermark,type_ZmFuZ3poZW5naGVpdGk,shadow_10,text_aHR0cHM6Ly9ibG9nLmNzZG4ubmV0L1ExMzY4MDg5MzIz,size_16,color_FFFFFF,t_70#pic_center
[watermark_type_ZmFuZ3poZW5naGVpdGk_shadow_10_text_aHR0cHM6Ly9ibG9nLmNzZG4ubmV0L1ExMzY4MDg5MzIz_size_16_color_FFFFFF_t_70_pic_center 3]: https://img-blog.csdnimg.cn/20201030232144257.png?x-oss-process=image/watermark,type_ZmFuZ3poZW5naGVpdGk,shadow_10,text_aHR0cHM6Ly9ibG9nLmNzZG4ubmV0L1ExMzY4MDg5MzIz,size_16,color_FFFFFF,t_70#pic_center