JDBC操作步骤

---

package com;

import java.sql.*;

public class Demo1 {
    public static void main(String[] args)  {
        Connection connection = null;
        Statement statement = null;
        ResultSet resultSet = null;
        //1.加载驱动
        try {
            Class.forName("com.mysql.cj.jdbc.Driver");
            //2.获得链接
            String userName = "root";
            String passWord = "123456";
            String url = "jdbc:mysql://localhost:3306/xhl? serverTimezone=UTC";
            connection = DriverManager.getConnection(url, userName, passWord);
            //3.定义sql，创建状态通道
            statement = connection.createStatement();
            resultSet = statement.executeQuery("select * from emp1");
            //4.取出结果集信息
            while(resultSet.next()){
                //取出数据:
                System.out.println(resultSet.getString("ename"));

            }
        } catch (ClassNotFoundException e) {
            e.printStackTrace();
        } catch (SQLException throwables) {
            throwables.printStackTrace();
        } finally {
            //5.关闭资源
            try {
                if (resultSet != null) {
                    resultSet.close();
                }
                if (statement != null) {
                    statement.close();
                }
                if (connection != null) {
                    connection.close();
                }
            } catch (SQLException throwables) {
                throwables.printStackTrace();
            }
        }

    }

}

注意：mysql8.0版本后的加载驱动那里为

com.mysql.cj.jdbc.Driver

之前版本不需要cj

url那里xhl换成自己的数据库名，查询语句表名也注意更改。

---