display_student.java

来自「主要是对于JAVA的编程的基本语言 希望能够帮得上你。」· Java 代码 · 共 51 行

package database;

import java.sql.*;

public class Display_Student {

	public static void main(String[] args) {
		try {
			//安装驱动程序
			Class.forName("sun.jdbc.odbc.JdbcOdbcDriver");
			//创建数据库连接
			Connection conn=DriverManager.getConnection("jdbc:odbc:student");
			//创建SQL语句
			Statement stmt=conn.createStatement(ResultSet.TYPE_SCROLL_SENSITIVE,
					ResultSet.CONCUR_READ_ONLY);
			//执行SQL命令获得结果集
			ResultSet rs=stmt.executeQuery("select * from studentbase");
			//显示记录
			while(rs.next()){
				System.out.println(rs.getLong(1)+", "+rs.getString("姓名")+", "
					+rs.getInt("年龄")+", "+rs.getString("性别")+", "
					+rs.getString("系名"));
			}
			
			rs.first();
			System.out.println("第一条记录：");
			System.out.println(rs.getLong(1)+", "+rs.getString(2)+", "
					+rs.getInt(3)+", "+rs.getString(4)+", "
					+rs.getString(5));			
			
			rs.last();
			System.out.println("最后一条记录：");
			System.out.println(rs.getLong(1)+", "+rs.getString(2)+", "
					+rs.getInt(3)+", "+rs.getString(4)+", "
					+rs.getString(5));
			
			rs.previous();
			System.out.println("倒数第二条记录：");
			System.out.println(rs.getLong(1)+", "+rs.getString(2)+", "
					+rs.getInt(3)+", "+rs.getString(4)+", "
					+rs.getString(5));
			
		} catch (ClassNotFoundException e) {			
			System.err.println(e.getMessage());
		} catch (SQLException e) {			
			System.err.println(e.getMessage());
		}
		
	}
}