JDBC(Java Database Connection)驱动MySQL

1.找到驱动对应MySQL版本的的jar包

https://mvnrepository.com/artifact/mysql/mysql-connector-java

2.Idea创建新目录lib并把jar包放进来

 

3.把jar压入库中

 

4.执行语句

public static void main(String[] args) throws ClassNotFoundException, SQLException {
        //1.加载驱动
        Class.forName("com.mysql.jdbc.Driver");//固定写法，加载驱动

        //2.用户信息和url
        /*
        注意 "jdbc:mysql//localhost;3306/
             [这里填写的是database名]
             ?useUnicode=true&characterEncoding=utf8&useSSL=true"
        */
        String url = "jdbc:mysql://localhost:3306/book_system?useUnicode=true&characterEncoding=utf8&useSSL=true";
        String username = "root";
        String password = "123456";
        //3.连接成功，数据库对象
        Connection connection = DriverManager.getConnection(url,username,password);

        //4.执行sql的对象 statement 执行sql的对象
        Statement statement = connection.createStatement();

        //5.执行SQL的对象 去执行SQL ，可能存在结果，查看返回结果
        String sql = "SELECT * FROM teacher";
        ResultSet resultSet = statement.executeQuery(sql);

        while(resultSet.next()){
            System.out.println("num="+resultSet.getObject("num"));
            System.out.println("pwd="+resultSet.getObject("sw"));
            System.out.println("name="+resultSet.getObject("name"));
            System.out.println("sex="+resultSet.getObject("teacher_sex"));
            System.out.println("address="+resultSet.getObject("teacher_address"));
            System.out.println("birth="+resultSet.getObject("teacher_birthday"));
            System.out.println("email="+resultSet.getObject("teacher_email"));
        }

        //6.释放连接
        resultSet.close();
        statement.close();
        connection.close();
    }

5.执行语句，完成

 

对比MySQL内的表格（剩下的留给前端处理就行）