public class JdbcStatementQueryPart {
/*
* TODO: 步驟總結 (6步)*    1. 注冊驅動*    2. 獲取連接*    3. 創建statement*    4. 發送SQL語句,并獲取結果*    5. 結果集解析*    6. 關閉資源
*/public static void main(String[] args) throws SQLException {//1.注冊驅動/*** TODO: 注意*   Driver -> com.mysql.cj.jdbc.Driver*/DriverManager.registerDriver(new Driver());//2.獲取連接/*** TODO: 注意*   面向接口編程*   java.sql 接口 = 實現類*   connection 使用java.sql.Connection接口接收*/Connection connection = DriverManager.getConnection("jdbc:mysql://localhost:3306/empolyee","root","123456");//3.創建小車Statement statement = connection.createStatement();//4.發送SQL語句String sql = "select id,account,password,nickname from t_user ;";ResultSet resultSet =  statement.executeQuery(sql);//5.結果集解析while (resultSet.next()){int id = resultSet.getInt("id");String account = resultSet.getString("account");String password = resultSet.getString("password");String nickname = resultSet.getString("nickname");System.out.println(id+"::"+account+"::"+password+"::"+nickname);}//6.關閉資源  【先開后關】resultSet.close();statement.close();connection.close();}}