Java连接mysql七步！

最新推荐文章于 2025-06-23 09:11:52 发布

置顶 YatKam

最新推荐文章于 2025-06-23 09:11:52 发布

阅读量3.2k

点赞数 6

CC 4.0 BY-SA版权

本文链接：https://blog.youkuaiyun.com/github_27609763/article/details/46048195

java 专栏收录该内容

34 篇文章

订阅专栏

本文提供了一步到位的Java连接MySQL数据库指南，包括初始化数据库连接类、加载驱动、设置URL、用户名、密码等关键步骤，并通过示例代码验证连接是否成功。

摘要生成于 C知道，由 DeepSeek-R1 满血版支持，前往体验 >

Java如何连接mysql数据库，本归纳总结7步，即可顺利达成！
前提你的java项目已经导入下载好的jdbc驱动包！！
没有可以此处下载
1> 声明驱动变量 driver:

//Database Driver
private static final String driver = "com.mysql.jdbc.Driver";

2> 声明mysql连接地址url:

//URL address for database connection
    private static final String url = "jdbc:mysql://localhost:3306/shopping?useUnicode=true&characterEncoding=UTF-8";

3> 声明数据库用户username：

//Username of database
    private static final String username = "root";

4> 声明数据连接密码password:

//password of database
    private static final String password = "123456";

5> 初始化数据库连接类实例 conn:

private static Connection conn = null;

6> 加载mysql驱动

//static code for load driver
    static{
         try{
             Class.forName(driver);

         }catch(Exception ex){
             ex.printStackTrace();
         }
    }

7> 连接数据库

//return database connection object via single sample model
    public static Connection getConnection()throws Exception{
        if(conn == null){
            conn = DriverManager.getConnection(url,username,password);
            return conn;
        }
        return conn;
    }

数据库连接测试代码：

public static void main(String[] args){

        try{
            Connection conn = DBHelper.getConnection();
            if(conn != null){
                System.out.println("Database Connects successfully!");
            }else{
                System.out.println("Database Connects unsuccessfully！");
            }
        }catch(Exception ex){
            ex.printStackTrace();
        }
    }

完整java代码：

package util;

import java.sql.Connection;
import java.sql.DriverManager;



public class DBHelper { 
    //Database Driver
    private static final String driver = "com.mysql.jdbc.Driver";
    //URL address for database connection
    private static final String url = "jdbc:mysql://localhost:3306/shopping?useUnicode=true&characterEncoding=UTF-8";
    //Username of database
    private static final String username = "root";
    //password of database
    private static final String password = "123456";

    private static Connection conn = null;

    //static code for load driver
    static{
         try{
             Class.forName(driver);

         }catch(Exception ex){
             ex.printStackTrace();
         }
    }
    //return database connection object via single sample model
    public static Connection getConnection()throws Exception{
        if(conn == null){
            conn = DriverManager.getConnection(url,username,password);
            return conn;
        }
        return conn;
    }

    public static void main(String[] args){

        try{
            Connection conn = DBHelper.getConnection();
            if(conn != null){
                System.out.println("Database Connects successfully!");
            }else{
                System.out.println("Database Connects unsuccessfully！");
            }
        }catch(Exception ex){
            ex.printStackTrace();
        }
    }
}