java，

java，

public static void main(String[] args) {
		Connection connection = DBConnection.getConn();
		Statement statement = null;
		ResultSet  resultSet = null;
		try {
			statement=connection.createStatement(ResultSet.TYPE_SCROLL_INSENSITIVE,
			ResultSet.CONCUR_READ_ONLY);
			String sql = "select name,age,sex from person";
			resultSet = statement.executeQuery(sql);
			System.out.println("当前游标是否在第一行之前：										"+resultSet.isBeforeFirst());
			System.out.println("从前往后的顺序显示结果集：");
			while(resultSet.next()){
				String name = resultSet.getString("name");
				String age = resultSet.getInt("age");
				String sex = resultSet.getString("sex");
				System.out.println("姓名："+name+" 年龄："+age+" 性别："+sex); 
				 }
			System.out.println("当前游标是否在最后一行之"+resultSet.isAfterLast()); 
			System.out.println("从后往前的顺序显示结果集：");
			while(resultSet.previous()){
				String name = resultSet.getString("name");
				String age = resultSet.getString("age");
				String sex = resultSet.getString("sex");
				System.out.println("姓名："+name+" 年龄："+age+" 性别："+sex); 
			}
			System.out.println("将游标移到第一行");
			resultSet.first();
			System.out.println("游标是否在第一行"+resultSet.isFirst());
			System.out.println("将游标移到最后一行");
			resultSet.last();
			System.out.println("游标是否在最后一行"+resultSet.isLast());
			System.out.println("将游标移到到最后一行的前3行");
			resultSet.relative(-3);
			System.out.println("游标最后一行的前3行的结果集为：");
			System.out.println("姓名："+resultSet.getString("name")+" 年龄："
			+resultSet.getString("age")+" 性别："+resultSet.getString("sex"));
			System.out.println("将游标移到第2行");
			resultSet.absolute(2);
			System.out.println("第2行的结果集为：");
			System.out.println("姓名： "+resultSet.getString("name")+" 年龄："
			+resultSet.getString("age")+" 性别："+resultSet.getString("sex"));
		} catch (SQLException e) {
			e.printStackTrace();
		}finally{
			DBConnection.close(connection, statement, resultSet);
		}
	}