使用纯Java方式连接数据库

Question

Answer 1

这个需要用到 jar 包，也是Java的：

mysql-connector http://static.runoob.com/download/mysql-connector-java-5.1.39-bin.jar

代码如下：

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


public class Main {
    private static final String username = "root";//用户名
    private static final String pwd = "root";//密码
    private static final String driverClass = "com.mysql.jdbc.Driver";//驱动类名
    static String url = "jdbc:mysql://localhost:3306/game_king?characterEncoding=utf-8";//连接地址

    public static Connection getConn() throws ClassNotFoundException, SQLException {
        Class.forName(driverClass); 
        Connection conn = DriverManager.getConnection(url, username, pwd);
        if (conn != null) {
            System.out.println("建立连接成功！");
            return conn;
        } else {
            System.out.println("建立连接失败！");
            return null;
        }
    }
}

```