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