使用Java代码连接mysql数据库

来源：互联网发布：linux复制压缩包编辑：程序博客网时间：2024/06/06 07:12

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

用eclipse创建一个Java工程

http://blog.csdn.net/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 |+----+----------+-----------+----------------+----------+------+

0 0