Oracle 和 JSP 开发的小型信息管理系统 (七) 源代码5

<%
int intPageSize;
int intRowCount;//記錄總數
int intPageCount;//總頁數
int intPage;//頁面參數
String strPage;//定義變數用來傳遞page
int i,j;
intPageSize=5;//定義每頁顯示5條記錄
strPage=request.getParameter("page");//取得當前的頁碼
if(strPage==null){//判斷初始頁面,如果沒有顯示記錄,就置為第一頁
intPage=1;
}else{
intPage=Integer.parseInt(strPage);//將strPage轉化為整數
if(intPage<1) intPage=1;
}

if(types.equals("null"))
{sqlname=" select count(article_id) from learning ";}
else
{sqlname=" select count(article_id) from learning where types='"+types+"' "; }

//sqlname="select count(article_id) from learning where title like '%"+keyword+"%' and types like '%"+typename+"%' order by article_id desc";

PreparedStatement ps=conn.prepareStatement(sqlname);
ResultSet rs1=ps.executeQuery();
rs1.next();
intRowCount=rs1.getInt(1);//取得整數保存與intRowCount變數中
intPageCount=(intRowCount+intPageSize-1)/intPageSize;//計算出總頁數(記錄總數+每頁顯示的記錄-1)/每頁顯示的記錄)
if(intPage>intPageCount)
intPage=intPageCount;

if(types.equals("null"))
{query=" select * from learning order by article_id ";}
else
{query=" select * from learning where types='"+types+"' order by article_id "; }

ps=conn.prepareStatement(query);
//String query=" select * from learning order by article_id ";

ResultSet rs=ps.executeQuery(query);//執行sql，按照時間先後排序顯示
i=(intPage-1)*intPageSize;
for(j=0;jrs.next();
%>
<%-- 設置intPage參數 --%>
<form action=index.jsp method=POST>

第<%=intPage%>頁 &nbsp;&nbsp;&nbsp;共<%=intPageCount%>頁&nbsp;&nbsp;&nbsp;

<%if(intPage>1){%>
&types=<%=types%>">上一頁&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;
<%}%>
<%if(intPage &types=<%=types%>">下一頁&nbsp;&nbsp;&nbsp;
<%}%>
</form>