原生jdbc查询数据库内容

public static void selectDemo() throws ClassNotFoundException, SQLException {
//		1.注册驱动
		Class.forName("com.mysql.jdbc.Driver");
//		2.获取数据库连接
		Connection connection = DriverManager.getConnection("jdbc:mysql://localhost:3306/doubleseven", "root", "ROOT");
//		3.获取执行sql语句的平台对象啊
		Statement stat = connection.createStatement();
//		4.执行sql语句
		ResultSet set = stat.executeQuery("select * from student");
		while(set.next()) {
			int sid = set.getInt("sid");
			String sname = set.getString("sname");
			String gender = set.getString("gender");
			String phone = set.getString("phone");
			System.out.println(sid+"---"+sname+"---"+gender+"---"+phone);
		}
		set.close();
		stat.close();
		connection.close();
	}

用list集合获取更加简洁：

	public static void selectDemo1() throws ClassNotFoundException, SQLException {
//		1.注册驱动
		Class.forName("com.mysql.jdbc.Driver");
//		2.获取数据库连接
		Connection connection = DriverManager.getConnection("jdbc:mysql://localhost:3306/doubleseven", "root", "ROOT");
//		3.获取执行sql语句的平台对象啊
		Statement stat = connection.createStatement();
//		4.执行sql语句
		ResultSet set = stat.executeQuery("select * from student");
		ArrayList<Student> list = new ArrayList<Student>();
		while (set.next()) {
			int sid = set.getInt("sid");
			String sname = set.getString("sname");
			String gender = set.getString("gender");
			String phone = set.getString("phone");
			Student student = new Student(sid, sname, gender, phone);
			list.add(student);
		}
		for (Student student1 : list) {
			System.out.println(student1);
		}
		set.close();
		stat.close();
		connection.close();
	}