ajlb.jsp

来自「公务员工资系统软件工程文档及源代码——JAVA编写（包括整个分析设计代码实现全过」· JSP 代码 · 共 47 行

<%--
  File Name :index.jsp 
  Author:daugtou
  Date:2002.11.20 
  Note:首页
  Last Modify : 
--%>

<%@page language="java" contentType="text/html;charset=gb2312" %>
<%@page import="com.vstsoft.std.*" %>
<%@page import="java.sql.*" %> 
<%@page import="java.lang.*"%>
<%@page import="sun.jdbc.rowset.*"%>
<jsp:useBean id="PageList" class="com.vstsoft.std.PageList" scope = "page" />
<%
  response.setHeader("Pragma","No-cache");
  response.setHeader("Cache-Control","no-cache");
  response.setDateHeader("Expires",0);

  PageList.setJndi("zcdb");
  PageList.setPagenum(1);
  PageList.setListnum(20);
  PageList.setSql("select tname from tab");
  
  CachedRowSet crs = new CachedRowSet();
  crs =   PageList.getRs();
  
  crs.first();
  crs.deleteRow();
  crs.cancelRowDelete();
crs.beforeFirst();
  while(crs.next()){
    out.println(crs.getString(1)+"<br>");
  }
  out.println(crs.getRow());
  crs.last();
  crs.close();
  out.println(crs.getRow());
  out.println(crs.size());
  
  //CachedRowSet crs1 = new CachedRowSet();
  CachedRowSet crs1 =   PageList.getRs();
  
  
%>