jdbc配置步骤

1.注册驱动，加载驱动

 Class.forName("com.mysql.cj.jdbc.Driver");

2.获得连接

String url = "jdbc:mysql://localhost:3306/company";
String user = "root";
String password = "1234";
Connection connection = DriverManager.getConnection(url, user, password);
if (connection != null) {
       System.out.println("连接成功");
} else {
       System.out.println("连接失败");

3.获得执行sql语句的对象

 Statement statement = connection.createStatement();

4.编写sql语句

String sql = "select * from t_jobs ";
ResultSet resultSet = statement.executeQuery(sql);

5.处理接受结果

 while (resultSet.next()) {//判断下一行是否有数据
            //对当前行的每列数据进行获取，根据列的编号
            String job_id = resultSet.getString(1);
            String job_title = resultSet.getString(2);
            int min_salary = resultSet.getInt(3);
            int max_salary = resultSet.getInt(4);
            System.out.println(job_id + "\t" + job_title + "\t" + min_salary + "\t" + max_salary);
        }

6.释放资源，先开后闭

resultSet.close();
statement.close();
connection.close();