## 实例 ~~~ //注册驱动 Class.forName("com.mysql.cj.jdbc.Driver"); //获得实例 Connection conn = DriverManager.getConnection("jdbc:mysql://192.168.10.10:3306/jdbc?useSSL=false&serverTimezone=UTC", "homestead", "secret"); //创建执行对象 Statement statement = conn.createStatement(); String sql = "select * from category"; //执行语句,获取结果集 ResultSet resultSet = statement.executeQuery(sql); while (resultSet.next()) { //一般用getObject Object id = resultSet.getInt("cid"); String cname = resultSet.getString("cname"); System.out.println(id + ":" + cname); } //关闭连接 statement.close(); //只有执行查询,才有结果集对象,如果执行增删改,只有int类型 resultSet.close(); conn.close(); ~~~