论坛徽章:: 0

电梯直达

1楼 [收藏(0)] [报告]

发表于 2004-07-17 15:25 |只看该作者 |倒序浏览

我在用jsp尝试做程序的时候，用到了根据时间查询，将查询的结果分页显示出来！当我选择了时间后进行查询，结果第一面的结果能显示出来，可是想翻页就不好使了

代码如下：
<%@ page contentType="text/html;charset=gb2312" %>;
<html>;
<head>;
<title>;逾期的维修项目内容</title>;
<link rel=stylesheet href="../style.css" type="text/css">;

<link rel=stylesheet href="../style.css" type="text/css">;

</head>;
<body leftmargin="0">;
<script LANGUAGE="javascript">;
function submit10()
{
self.location.replace("rsnormalequry1.jsp"

}
</script>;
<center>;;<h4>;;;逾期维修项目内容管理;;</h4>;
<%@ page language="java" import="java.sql.*" %>;
<jsp:useBean id="normalview" scope="page" class="opendb.opendb" />;
<%
String year =request.getParameter("year"

;
String day= request.getParameter("day"

; 我总觉得问题出在这里，可就是不会解决，希望指点
String mounth=request.getParameter("mounth"

;
String date=year+mounth+day;
%>;
<%
//指定行数
int pageLine=10;
int totalRec=0;
int totalSub=0;
int intPage=1;
int i;
if (request.getParameter("page"

!=null)
intPage=Integer.parseInt(request.getParameter("page"

);

try{
ResultSet countrs=null;

//取得总记录数
countrs=normalview.executeQuery("select count(*) as cnt from ITEMINFO where NAME='" + session.getValue("realname"

+ "' and NEXTDATE >; to_date('" + date + "','yyyyMMdd')"

;
String rowid;
if (countrs.next())
totalRec=countrs.getInt("cnt"

;
countrs.close();
normalview.closeStmt();

}
catch(Exception e){
e.printStackTrace();
}

//取得总页数
int intPageCount=0;
intPageCount = (totalRec+pageLine-1) / pageLine;
%>;
<%
ResultSet RS = normalview.executeQuery("SELECT ROWNUM,EQUIPNAME,ITEMNAME,ITEMPROTY,ITEMCIRCLE,WORKINGTIME,NAME,ASSINAME,MEMO,SELECT_SIGN,TO_CHAR(PREDATE),TO_CHAR(NEXTDATE) FROM ITEMINFO where NAME='" + session.getValue("realname"

+ "' and NEXTDATE >; to_date('" + date + "','yyyyMMdd')");
String rowid;
String equipname;
String itemname;
String itemproty;
String itemcircle;
String workingtime;
String name;
String assiname;
String memo;
String select_sign;
String predate;
String nextdate;

%>;
<table border='1' cellspacing='0' width='901' bgcolor='#99CCFF' bordercolorlight='#008000' bordercolordark='#ECF5FF' height="43">;
<tr bgcolor='#c8cc98' align='center'>;
 <td width ='17' bgcolor="#99CCFF" height="17">;;序号;</td>;
<td width ='145' bgcolor="#99CCFF" height="17">;;设备名称;</td>;
<td width ='102' bgcolor="#99CCFF" height="17">;;项目内容;</td>;
<td width ='58' bgcolor="#99CCFF" height="17">;;项目属性;</td>;
<td width ='35' bgcolor="#99CCFF" height="17">;;周期;</td>;
<td width ='52' bgcolor="#99CCFF" height="17">;;实施时间;</td>;
<td width ='55' bgcolor="#99CCFF" height="17">;;岗位人员;</td>;
<td width ='52' bgcolor="#99CCFF" height="17">;;协力方;</td>;
<td width ='149' bgcolor="#99CCFF" height="17">;;备注;</td>;
</center>;
<td bgcolor="#99CCFF" height="17" width="76">;
;;上次检修时间;;
</td>;
<center>;
<td bgcolor="#99CCFF" height="17" width="76">;;预计检修时间;</td>;
 <td width ='34' bgcolor="#99CCFF" height="17">;;选择;</td>; </tr>;
<%
if (intPageCount>;0)
{
 for(i=1;i<=(intPage-1)*pageLine;i++)
RS.next();
 for(i=1;i<=pageLine;i++) {
if (RS.next()) {
rowid=RS.getString("ROWNUM");
equipname=RS.getString("EQUIPNAME");
itemname=RS.getString("ITEMNAME");
itemproty=RS.getString("ITEMPROTY");
itemcircle=RS.getString("ITEMCIRCLE");
workingtime=RS.getString("WORKINGTIME");
name=RS.getString("NAME");
assiname=RS.getString("ASSINAME");
memo=RS.getString("MEMO");
select_sign=RS.getString("SELECT_SIGN");
predate=RS.getString("TO_CHAR(PREDATE)");
nextdate=RS.getString("TO_CHAR(NEXTDATE)");
%>;
<tr>;
<td width='17' align='center' bgcolor="#E7F1FA" height="18">;;<%=rowid%>;</td>;
<td width='145' align='center' bgcolor="#E7F1FA" height="18">;;<%=equipname%>;</td>;
<td width='102' align='center' bgcolor="#E7F1FA" height="18">;;<%=itemname%>;</td>;
<td width='58' align='center' bgcolor="#E7F1FA" height="18">;;<%=itemproty%>;</td>;
<td width='35' align='center' bgcolor="#E7F1FA" height="18">;;<%=itemcircle%>;</td>;
<td width='52' align='center' bgcolor="#E7F1FA" height="18">;;<%=workingtime%>;</td>;
<td width='55' align='center' bgcolor="#E7F1FA" height="18">;;<%=name%>;</td>;
<td width='52' align='center' bgcolor="#E7F1FA" height="18">;;<%=assiname%>;</td>;
<td width='149' align='center' bgcolor="#E7F1FA" height="18">;;<%=memo%>;</td>;
<td width='76' align='center' bgcolor="#E7F1FA" height="18">;;<%=predate%>;</td>;
<td width='76' align='center' bgcolor="#E7F1FA" height="18">;;<%=nextdate%>;</td>;
<td width='34' align='center' bgcolor="#E7F1FA" height="18">;<a href="select.jsp?id=<%=equipname%>;" onClick="return newwin(this.href);">;;选择;</a>;</td>;

</tr>;
<%
 }
}
RS.close();
}
%>;
;
<%
out.print("<tr>;");
if (intPageCount*pageLine<totalRec)
intPageCount++;
if (intPage>;intPageCount )
intPage=intPageCount;
if (intPage < 1 )
intPage=1;
out.print("<form method='POST' name=fPageNum action='rsnormalequry1.jsp'>;");
out.print(";&&分页&");

 if (intPage<2)
out.print(";首页上一页;&");
 else{
 out.print("<a href='rsnormalequry1.jsp?page=1'>;首页</a>;&");
out.print("<a href='rsnormalequry1.jsp?page=" + (intPage-1) + "'>;上一页</a>;&" );
}


 if( intPage-intPageCount>;=0 )
out.print(";下一页尾页;" );
 else{

out.print("<a href='rsnormalequry1.jsp?page="+(intPage+1)+"'>;下一页</a>; <a href='rsnormalequry1.jsp?page=" + intPageCount + "'>;尾页</a>;");
}

 out.print("&页次：;;"+intPage+";/"+intPageCount+";页 " );
 out.print("&共;"+totalRec+";条记录 ;"+pageLine+";条/页 " );
 out.print(" 转到第<input type='text' name='page' size=2 maxlength=10 class=smallInput value="+intPage+">;");
 out.print("页<input class=buttonface type='submit' value='GO' name='cndok'>;;;</form>;" );

out.print("</td>;");
out.print("</tr>;");

%>;

</table>;
<a href="javascript:window.close();">;[关闭]</a>;
</center>;

</html>;