JDBC的数据库查询

查询代码：

package JDBC;

import java.sql.Connection;
import java.sql.DriverManager;
import java.sql.PreparedStatement;
import java.sql.ResultSet;
import java.sql.Statement;


public class text {
	private static String jdbcurl = "jdbc:mysql://localhost:3306/qwe";
	private static String name = "root";
	private static String password = "666666";
	private static String jdbcname = "com.mysql.jdbc.Driver";

	public Connection make_ready() throws Exception {
		Class.forName(jdbcname);
		Connection con = DriverManager.getConnection(jdbcurl, name, password);
		return con;
	}

	public void make_close(Statement stmt, Connection con) throws Exception {
		stmt.close();
		con.close();
	}

	public static void main(String[] args) throws Exception // 为什么加，我也不知道。
	{
		String sql = "select * from student";
		text x = new text();
		Connection con = x.make_ready();

		PreparedStatement pstmt = con.prepareStatement(sql);
		ResultSet z=pstmt.executeQuery(); 				// 这个函数是用来统计有多少列的。
		while(z.next())
		{
			int id=z.getInt("id");
			String name=z.getString("name");
			int age=z.getInt("age");
			System.out.println(id+"   "+name+"   "+age);
		}
		x.make_close(pstmt, con);
	}
}