## 實例 ~~~ //注冊驅動 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(); ~~~