JDBC的连接过程

//加载驱动
DriverManager.registerDriver(new Driver());
        
//获取连接
        Connection connection = DriverManager.getConnection("jdbc:mysql://localhost:3306/myemployees",
                "root", "root");
//        System.out.println(connection==null?"失败":"成功");
        //编写sql语句
        String sql="select * from user";
        //创建命令对象
        Statement statement = connection.createStatement();
        //执行sql语句
        ResultSet resultSet = statement.executeQuery(sql);
        //处理结果
        while (resultSet.next()){
            int id = resultSet.getInt("id");
            String username = resultSet.getString("username");
            int password = resultSet.getInt("pwd");
            System.out.println(id+"\t"+username+"\t"+password);
        }
        resultSet.close();
        statement.close();
        connection.close();

    }