Java连接mysql七步！

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();
        }
    }
}

运行结果：

转载请注明原文出处，谢谢！