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();
%>