blogjava's web log

<% @ page contentType = " text/html;charset=gb2312 "   %>
<% @ page errorPage = " jsp1_error.jsp "    import = " java.util.*, java.sql.* "   %>
<%
// String sConn="jdbc:oracle:thin:@local:1521:test" ;
String sConn = " jdbc:odbc:test " ;
// String cl="oracle.jdbc.driver.OracleDriver";
  String sq2 = " sun.jdbc.odbc.JdbcOdbcDriver " ;
Class.forName(sq2);
Connection conn = DriverManager.getConnection(sConn, " sa " , "" );
// Connection conn=DriverManager.getConnection(sConn,"admin","admin");
Statement stmt = conn.createStatement(ResultSet.TYPE_SCROLL_SENSITIVE,ResultSet.CONCUR_READ_ONLY );
Statement stmtcount = conn.createStatement(ResultSet.TYPE_SCROLL_SENSITIVE,ResultSet.CONCUR_READ_ONLY );

ResultSet rs = stmt.executeQuery( " select * from jobs " );
String sqlcount = " select count(*) as count1 from jobs " ;
ResultSet rscount = stmtcount.executeQuery(sqlcount);
// rscount.last() ;
// rscount.getRow() ;

int  pageSize = 3 ; // 一页所包括的行数
int  rowCount = 0 ;  // 总的记录数
while (rscount.next())
   {
   rowCount = rscount.getInt( " count1 " ); // 取的表总的记录数
  }
int  pageCount;  // 总的页数
int  currPage;  // 当前页数
String strPage; // 获的上一页或下一页的页码值.



strPage = request.getParameter( " page " ); // 获的上一页或下一页的页码值.
if  (strPage == null ) {
currPage = 1 ;
}
else {
currPage = Integer.parseInt(strPage);
if  (currPage < 1 )
currPage = 1 ;
}



pageCount = (rowCount + pageSize - 1 ) / pageSize; // 计算总的页码数



if  (currPage > pageCount)
    currPage = pageCount;

int  thepage = (currPage - 1 ) * pageSize; // 计算当前的所在的行数
int  n = 1 ;  // 控制变量
if (thepage != 0 )

 rs.absolute(thepage); // 光标下移thepage+1 行
  else
  rs.beforeFirst() ;
   //   rs.absolute(1);

%>
< div id = " Layer1 "  align = " center "  style =   " background-color: #999999 " >
第 <%= currPage %> 页 共 <%= pageCount %> 页 共 <%= rowCount %> 条
<% if (currPage > 1 ) { %>< a href = " jsp1.jsp?page=1 " > 首页 </ a ><% } %>
<% if (currPage > 1 ) { %>< a href = " jsp1.jsp?page=<%=currPage-1%> " > 上一页 </ a ><% } %>
<% if (currPage < pageCount) { %>< a href = " jsp1.jsp?page=<%=currPage+1%> " > 下一页 </ a ><% } %>
<% if (pageCount > 1 ) { %>< a href = " jsp1.jsp?page=<%=pageCount%> " > 尾页 </ a ><% } %>
  < table border = 1  cellspacing = " 1 "  cellpadding = " 1 " >
    < tr >
     < td > 工号 < td >
     < td > 描述 < td >
     < td > 最小工资 < td >
     < td > 最大工资 < td >
    </ tr >
<%
while  (n <= 3   &&  rs.next()) // 当n<＝一页的行数时
{

%>
   < tr >
     < td ><%= rs.getInt( 1 ) %>< td >
     < td ><%= rs.getString( 2 ) %>< td >
     < td ><%= rs.getInt( 3 ) %>< td >
     < td ><%= rs.getInt( 4 ) %>< td >
    </ tr >
   <%

//  if((thepage+n)==rowCount)  // 如果当前行数大于总的行数跳出循环
//     break;

  n ++ ; // 控制变量加一

}

%>
</ table >
</ div >
<%
rs.close();
rscount.close();
stmt.close();
stmtcount.close();
conn.close();
%>