JDBC——java连接数据库 （统一驱动）

1、创建数据库

2、导包

<dependency>
    <groupId>mysql</groupId>
    <artifactId>mysql-connector-java</artifactId>
    <version>8.0.28</version>
</dependency>

3、idea连接数据库

4、配置JDBC连接

		String url="jdbc:mysql://localhost:3306/jdbc?useuUnicode=true&characterEncoding=utf-8";
        String name="root";
        String password="990929";

        //1.加载驱动
        Class.forName("com.mysql.jdbc.Driver");
        //2.连接数据库
        Connection connection = DriverManager.getConnection(url, name, password);
        //3.向数据库发送SQL的对象statment：CRUD
        Statement statement = connection.createStatement();
        //4.编写SQL
        String sql = "select * from users";
        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"));

        }

        //5.关闭连接以免浪费资源
        rs.close();
        statement.close();
        connection.close();