第一个JDBC程序

public class JDBC {
        public static void main(String[] args) throws ClassNotFoundException, SQLException {
                //加载驱动
                Class.forName("com.mysql.jdbc.Driver");
                //用户信息和url
                String url = ("jdbc:mysql://localhost:3306/jdbcstudy?useUnicode=true&characterEncoding=utf8&&useSSL=true");
                String name= ("root");
                String password=("123456");
                //连接成功，数据库对象
                Connection connection = DriverManager.getConnection(url, name, password);
                //执行sql的对象
                Statement statement = connection.createStatement();
                //执行sql 的对象去执行sql，可能存在结果，查看返回结果
                ResultSet resultSet = statement.executeQuery("SELECT * FROM `users`");
                while (resultSet.next()){
                        System.out.println("id="+resultSet.getObject("id"));
                        System.out.println("name="+resultSet.getObject("name"));
                        System.out.println("pwd="+resultSet.getObject("password"));
                        System.out.println("email="+resultSet.getObject("email"));
                        System.out.println("================================================");
                }
                //释放连接
                resultSet.close();
                statement.close();
                connection.close();
        }
}