JDBC连接MySQL

最新推荐文章于 2024-10-09 18:19:09 发布

爱学习的赛亚人

最新推荐文章于 2024-10-09 18:19:09 发布

阅读量118

点赞数 2

文章标签： mysql 数据库 java

本文链接：https://blog.csdn.net/zhangpupupupu/article/details/121034893

版权

标题IDEA2020 jdbc连接数据库代码事例

package com.zhang.test;
import java.sql.*;
public class TestJdbc {
    public static void main(String[] args) throws ClassNotFoundException, SQLException {

        //配置信息
        String url="jdbc:mysql://localhost:3306/jdbc?useUnicode=true&characterEncoding=utf-8&useSSL=false&serverTimezone = GMT";
        String username="root";
        String password="qwe740626";

        //1.加载驱动
        Class.forName("com.mysql.cj.jdbc.Driver");

        //2.连接数据库,代表数据库
        Connection connection = DriverManager.getConnection(url, username, password);

        //3.向数据库发送sql的对象Statement:CRUD
        Statement statement = connection.createStatement();

        //4.编写sql语句
        String sql="select * from users";

        //5.执行查询sql,返回一个ResultSet:结果集
        ResultSet rs = statement.executeQuery(sql);

        while (rs.next()){
            System.out.println("id="+rs.getObject("id"));
            System.out.println("name="+rs.getObject("name"));
            System.out.println("password="+rs.getObject("password"));
            System.out.println("email="+rs.getObject("email"));
            System.out.println("birthday="+rs.getObject("birthday"));
        }

        //6.关闭链接,释放资源(一定要做) 先开后关
        rs.close();
        statement.close();
        connection.close();


    }
}

注意事项

Loading class com.mysql.jdbc.Driver'. This is deprecated. The new driver class iscom.mysql.cj.jdbc.Driver’. The driver is automatically registered via the SPI and manual loading of the driver class is generally unnecessary.

com.mysql.jdbc.Driver 是 mysql-connector-java 5中的；
com.mysql.cj.jdbc.Driver 是 mysql-connector-java 6中的,注意你的mysql版本,否则会出现错误.

String url=“jdbc:mysql://localhost:3306/数据库名c?useUnicode=true&characterEncoding=utf-8&useSSL=false&serverTimezone = GMT”;