【JAVAWeb】JDBC的使用步骤

JDBC的使用步骤:
1.注册驱动
Class. forName (“驱动的全限定名”); //mysql驱动的全限定名是com . mysql. jdbc . Driver
如果你使用的是mysql8.0那么请你使用mysql8的驱动jar包，并且驱动的全限定名是com. mysql.cj. jdbc
2. 获得连接(建立客户端与mysql服务器的连接)
Connection conn = DriverManager . getConnection(“数据库服务器路径”, “用户名”, “密码”);
3.创建执行Sql语句的S tatement对象
Statement statement = conn. createStcsement();
4. 使用statement执行SQL语句
4.1 执行增删改的SQL语句: int num
= statement. executeUpdate(sql);返回值表示受到影响的函
4.2 执行查询的SQL语句: ResultSet rst = statement. executeQuery(sql);返回值是查询到的结
5. 如果第四步执行的SQL语句是查询，那么我们就要将查询到的结果集中数据遍历出来(难点)
6.关闭资源:后创建的资源先关闭
rst.close();
statement.close();
conn.close();

package com.sdjzu.jdbc;

import java.sql.*;

/*
* 连接数据库
* */
public class TestJDBC {
    public static void main(String[] args) throws ClassNotFoundException, SQLException {
        //1.注册驱动
        Class.forName("com.mysql.cj.jdbc.Driver");
        //2.获取连接
        //jdbc:mysql://服务器的主机地址:端口号/数据库名?characterEncoding=utf8
        //如果数据库主机地址是localhost,并且端口号是3306，那么可以省略localhost: 3306
        String url="jdbc:mysql://localhost:3306/atguigudb?characterEncoding=utf8&&serverTimezone=UTC";
        String user="root";
        String password="root";
        Connection conn = DriverManager.getConnection(url,user,password);
        //3.创建statement对象
        Statement statement = conn.createStatement();
        //4.使用statement对象执行sql语句
        String sql="SELECT * FROM departments";
        //执行查询的SQL语句，获取查询的结果
        ResultSet rst = statement.executeQuery(sql);
        //遍历resultSet结果集，从中获取查询的结果
        try {
            while(rst.next()) {
                //每次调用next()就是将游标移动到结果集的下-行
                //获取当前行的每列数据，根据列名获取
                int department_id=(int)rst.getObject("department_id");
                String department_name=(String)rst.getObject("department_name");
                int manager_id=(int)rst.getObject("manager_id");
                int location_id=(int)rst.getObject("location_id");
                System.out.println(department_name + ":" + department_id + ":" + manager_id + ":" + location_id);
                System.out.println("___________________");
        }

        }catch (Exception e){
            System.out.println("不影响结果");

        }

        //5.关闭资源，后创建的先关闭
        rst.close();
        statement.close();
        conn.close();


    }
}

D:\developertool\Java\jdk1.8.0\bin\java.exe "-javaagent:D:\developertool\Java\IntelliJ IDEA 2021.2.2\lib\idea_rt.jar=58651:D:\developertool\Java\IntelliJ IDEA 2021.2.2\bin" -Dfile.encoding=UTF-8 -classpath D:\developertool\Java\jdk1.8.0\jre\lib\charsets.jar;D:\developertool\Java\jdk1.8.0\jre\lib\deploy.jar;D:\developertool\Java\jdk1.8.0\jre\lib\ext\access-bridge-64.jar;D:\developertool\Java\jdk1.8.0\jre\lib\ext\cldrdata.jar;D:\developertool\Java\jdk1.8.0\jre\lib\ext\dnsns.jar;D:\developertool\Java\jdk1.8.0\jre\lib\ext\jaccess.jar;D:\developertool\Java\jdk1.8.0\jre\lib\ext\jfxrt.jar;D:\developertool\Java\jdk1.8.0\jre\lib\ext\localedata.jar;D:\developertool\Java\jdk1.8.0\jre\lib\ext\nashorn.jar;D:\developertool\Java\jdk1.8.0\jre\lib\ext\sunec.jar;D:\developertool\Java\jdk1.8.0\jre\lib\ext\sunjce_provider.jar;D:\developertool\Java\jdk1.8.0\jre\lib\ext\sunmscapi.jar;D:\developertool\Java\jdk1.8.0\jre\lib\ext\sunpkcs11.jar;D:\developertool\Java\jdk1.8.0\jre\lib\ext\zipfs.jar;D:\developertool\Java\jdk1.8.0\jre\lib\javaws.jar;D:\developertool\Java\jdk1.8.0\jre\lib\jce.jar;D:\developertool\Java\jdk1.8.0\jre\lib\jfr.jar;D:\developertool\Java\jdk1.8.0\jre\lib\jfxswt.jar;D:\developertool\Java\jdk1.8.0\jre\lib\jsse.jar;D:\developertool\Java\jdk1.8.0\jre\lib\management-agent.jar;D:\developertool\Java\jdk1.8.0\jre\lib\plugin.jar;D:\developertool\Java\jdk1.8.0\jre\lib\resources.jar;D:\developertool\Java\jdk1.8.0\jre\lib\rt.jar;D:\developertool\Java\idea202122space\JAVAWeb\out\production\module01-jdbc;D:\developertool\Java\idea202122space\JAVAWeb\lib\mysql-connector-java-8.0.17.jar com.sdjzu.jdbc.TestJDBC
Administration:10:200:1700
___________________
Marketing:20:201:1800
___________________
Purchasing:30:114:1700
___________________
Human Resources:40:203:2400
___________________
Shipping:50:121:1500
___________________
IT:60:103:1400
___________________
Public Relations:70:204:2700
___________________
Sales:80:145:2500
___________________
Executive:90:100:1700
___________________
Finance:100:108:1700
___________________
Accounting:110:205:1700
___________________
不影响结果

Process finished with exit code 0