import java.sql.DriverManager;
import java.sql.ResultSet;
import java.sql.SQLException;

import com.mysql.jdbc.Connection;
import com.mysql.jdbc.PreparedStatement;
import com.mysql.jdbc.Statement;


public class Test {

	public static void main(String[] args) {
		ResultSet rs=null;
		try {
			Class.forName("com.mysql.jdbc.Driver");//驱动的类名
			Connection conn=
			(Connection) DriverManager.getConnection(
					"jdbc:mysql://127.0.0.1:3306/zhang", //服务器的IP地址和端口号，数据库的名字
					"root",//用户名
					"128928818"//密码
					);
			Statement stmt=(Statement) conn.createStatement();
			rs=stmt.executeQuery("select * from student");
			while(rs.next())
			{
				System.out.println(rs.getInt(1));
				System.out.println(rs.getString(2));
				System.out.println(rs.getString(3));
			}
		} catch (Exception e) {
			// TODO Auto-generated catch block
			e.printStackTrace();
		}
		finally
		{
			if(rs!=null)
			{
				try {
					rs.close();
				} catch (SQLException e) {
					// TODO Auto-generated catch block
					e.printStackTrace();
				}
			}
		}
	}

}