使用Java代码连接mysql数据库

创建Java工程的具体步骤参照：

用eclipse创建一个Java工程

http://blog.youkuaiyun.com/mixzxu/article/details/64442783

以下是用Java连接到mysql数据库的代码实现。

mysql jar包：mysql-connector-java-6.0.3.jar

package mysql1_1;
import java.sql.Connection;
import java.sql.DriverManager;
import java.sql.ResultSet;
import java.sql.Statement;

public class Test1 {

    public static void main(String[] args) throws Exception {
        //加载jdbc驱动
        Class.forName("com.mysql.cj.jdbc.Driver");
        //创建connection对象
        String url = "jdbc:mysql://localhost:3306/test?useUnicode=true&characterEncoding=utf8&zeroDateTimeBehavior=convertToNull&useSSL=false&serverTimezone=UTC";
        String user = "root";
        String password = "mysql";
        Connection conn = DriverManager.getConnection(url, user, password);
        //获取statement对象
        Statement sta = conn.createStatement();
        //执行SQL
        String sql = "select * from person";
        ResultSet rs = sta.executeQuery(sql);
        while (rs.next()) {
            System.out.println(rs.getString(2));
        }
        //关闭链接，释放资源
        rs.close();
        sta.close();
        conn.close();
    }
}

mysql> select * from person;
+----+----------+-----------+----------------+----------+------+
| id | lastname | firstname | address        | city     | Year |
+----+----------+-----------+----------------+----------+------+
|  1 | Adams    | John      | Oxford Street  | London   | 1970 |
|  2 | Bush     | George    | Fifth Avenue   | New York | 1975 |
|  3 | Carter   | Thomas    | Changan Street | Beijing  | 1980 |
|  4 | Gates    | Bill      | Xuanwumen 10   | Beijing  | 1985 |
+----+----------+-----------+----------------+----------+------+