用if(request.getParameter("page")!=null)得到page的值,
out.println("<a href=\"DeleteItem.jsp? page=1\">首页</a> ");可以得到1;
out.println("<a href=\"DeleteItem.jsp? page="+(intPage-1)+"\">上一页</a> ");得到的就是null,为什么呢?!请各位大人救命!!!程序如下:<%@page contentType="text/html; charset=GBK"%>
<%@ page import="my1.Item"%>
<%@ page import="com.ht.pubpkg.ExecDb"%>
<%@ page import="java.sql.*"%><html>
<head>
<meta http-equiv="Content-Type" content="text/html; charset=gb2312"><title>DeleteItem</title><script type="javascript">
function newwin(url) {
var newwin=window.open(url,"newwin","toolbar=no,location=no,directories=no,status=no, menubar=no,scrollbars=yes,resizable=yes,width=600,height=450");
newwin.focus();
return false;
}
</script>
</head><body>
<script type="javascript">
function submit11()
{
self.location.replace("DeleteItem.jsp")
}
</script><center>
<font color="#3399FF" size="+3">删除项目</font>
</center>
<hr><%
int pageLine=3;
int totalRec=0;
int totalSub=0;
int intPage=1;if(request.getParameter("page")!=null)
intPage=Integer.parseInt(request.getParameter("page"));
else
out.println("null");ResultSet rs =null;
ExecDb mydb = new ExecDb();try{
rs = mydb.executeQuery("select * from itemlist");
totalRec=mydb.getRecordCount(rs);
rs.close();}
catch(Exception e){e.printStackTrace();}int intPageCount=0;
intPageCount=(totalRec+pageLine-1)/pageLine;
%><table width="801" border="1" align="center" cellspacing="0" bgcolor="#FFFFFF">
<!--DWLayoutTable-->
<tr align="center" bgcolor="#0099FF">
<td width="120">项目代码</td>
<td width="120">项目名称</td>
<td width="120">项目等级</td>
<td width="120">项目说明</td>
<td width="120">项目风险系数</td>
<td width="120">操作</td>
</tr><%
int i=0;
String itemID=new String();
String itemName=new String();
String itemLevel=new String();
String itemXS=new String();
String itemComment=new String(); try{
rs = mydb.executeQuery("select * from itemlist");
if(intPageCount>0){ for(i=1;i<=(intPage-1)*pageLine;i++)
rs.next(); for(i=1;i<=pageLine;i++)
{
if(rs.next()){
itemID=rs.getString("itemid");
itemName=rs.getString("itemname");
itemLevel=rs.getString("itemlevel");
itemXS=rs.getString("itemxs");
itemComment=rs.getString("itemcomment");
%> <tr>
<td width="120" align="center"><%=itemID%></td>
<td width="120" align="center"><%=itemName%></td>
<td width="120" align="center"><%=itemLevel%></td>
<td width="120" align="center"><%=itemComment%></td>
<td width="120" align="center"><%=itemXS%></td>
<td width="120"><a href="DelIResult.jsp? id=<%=itemID%>">删除</a></td>
</tr>
<% }
}
rs.next();
}} catch(Exception e){e.printStackTrace();}
%><%
out.print("<TR>");
if(intPageCount*pageLine<totalRec)
intPageCount++;if(intPage>intPageCount)
intPage=intPageCount;if(intPage<1)
intPage=1;out.println("<form method=\"post\" name=fPageNum action=\"DeleteItem.jsp\">"); if(intPage<2)
out.println("<font color=\"whilte\">首页 上一页</font>");
else{
out.println("<a href=\"DeleteItem.jsp? page=1\">首页</a> ");
out.println("<a href=\"DeleteItem.jsp? page="+(intPage-1)+"\">上一页</a> ");
} if((intPage-intPageCount)>=0)
out.println("<font color=\"whilte\">下一页 尾页</font>");
else {out.println("<a href=\"DeleteItem.jsp? page=" + (intPage+1) + "\">下一页</a> ");
out.println("<a href=\"DeleteItem.jsp? page=" + intPageCount + "\">尾页</a>");}
out.print(" 跳转到<input type=\"text\" name=\"page\" size=\"5\" maxlength=\"10\" value=\"" + intPage + "\">"); out.print("<input class=buttonface type=\"submit\" value=\"GO\" name=\"cndok\"></span></p></form>");
out.print("</td>");
out.print("</tr>");
%>
</table></body>
</html>
out.println("<a href=\"DeleteItem.jsp? page=1\">首页</a> ");可以得到1;
out.println("<a href=\"DeleteItem.jsp? page="+(intPage-1)+"\">上一页</a> ");得到的就是null,为什么呢?!请各位大人救命!!!程序如下:<%@page contentType="text/html; charset=GBK"%>
<%@ page import="my1.Item"%>
<%@ page import="com.ht.pubpkg.ExecDb"%>
<%@ page import="java.sql.*"%><html>
<head>
<meta http-equiv="Content-Type" content="text/html; charset=gb2312"><title>DeleteItem</title><script type="javascript">
function newwin(url) {
var newwin=window.open(url,"newwin","toolbar=no,location=no,directories=no,status=no, menubar=no,scrollbars=yes,resizable=yes,width=600,height=450");
newwin.focus();
return false;
}
</script>
</head><body>
<script type="javascript">
function submit11()
{
self.location.replace("DeleteItem.jsp")
}
</script><center>
<font color="#3399FF" size="+3">删除项目</font>
</center>
<hr><%
int pageLine=3;
int totalRec=0;
int totalSub=0;
int intPage=1;if(request.getParameter("page")!=null)
intPage=Integer.parseInt(request.getParameter("page"));
else
out.println("null");ResultSet rs =null;
ExecDb mydb = new ExecDb();try{
rs = mydb.executeQuery("select * from itemlist");
totalRec=mydb.getRecordCount(rs);
rs.close();}
catch(Exception e){e.printStackTrace();}int intPageCount=0;
intPageCount=(totalRec+pageLine-1)/pageLine;
%><table width="801" border="1" align="center" cellspacing="0" bgcolor="#FFFFFF">
<!--DWLayoutTable-->
<tr align="center" bgcolor="#0099FF">
<td width="120">项目代码</td>
<td width="120">项目名称</td>
<td width="120">项目等级</td>
<td width="120">项目说明</td>
<td width="120">项目风险系数</td>
<td width="120">操作</td>
</tr><%
int i=0;
String itemID=new String();
String itemName=new String();
String itemLevel=new String();
String itemXS=new String();
String itemComment=new String(); try{
rs = mydb.executeQuery("select * from itemlist");
if(intPageCount>0){ for(i=1;i<=(intPage-1)*pageLine;i++)
rs.next(); for(i=1;i<=pageLine;i++)
{
if(rs.next()){
itemID=rs.getString("itemid");
itemName=rs.getString("itemname");
itemLevel=rs.getString("itemlevel");
itemXS=rs.getString("itemxs");
itemComment=rs.getString("itemcomment");
%> <tr>
<td width="120" align="center"><%=itemID%></td>
<td width="120" align="center"><%=itemName%></td>
<td width="120" align="center"><%=itemLevel%></td>
<td width="120" align="center"><%=itemComment%></td>
<td width="120" align="center"><%=itemXS%></td>
<td width="120"><a href="DelIResult.jsp? id=<%=itemID%>">删除</a></td>
</tr>
<% }
}
rs.next();
}} catch(Exception e){e.printStackTrace();}
%><%
out.print("<TR>");
if(intPageCount*pageLine<totalRec)
intPageCount++;if(intPage>intPageCount)
intPage=intPageCount;if(intPage<1)
intPage=1;out.println("<form method=\"post\" name=fPageNum action=\"DeleteItem.jsp\">"); if(intPage<2)
out.println("<font color=\"whilte\">首页 上一页</font>");
else{
out.println("<a href=\"DeleteItem.jsp? page=1\">首页</a> ");
out.println("<a href=\"DeleteItem.jsp? page="+(intPage-1)+"\">上一页</a> ");
} if((intPage-intPageCount)>=0)
out.println("<font color=\"whilte\">下一页 尾页</font>");
else {out.println("<a href=\"DeleteItem.jsp? page=" + (intPage+1) + "\">下一页</a> ");
out.println("<a href=\"DeleteItem.jsp? page=" + intPageCount + "\">尾页</a>");}
out.print(" 跳转到<input type=\"text\" name=\"page\" size=\"5\" maxlength=\"10\" value=\"" + intPage + "\">"); out.print("<input class=buttonface type=\"submit\" value=\"GO\" name=\"cndok\"></span></p></form>");
out.print("</td>");
out.print("</tr>");
%>
</table></body>
</html>
if(intPage<0) intPage=1; //原因,首页为1,总不能小于1吧,
发个分页的代码如下:(用了javaBean)<table width="820" border="1" cellpadding="0" cellspacing="0" bordercolor="#993333">
<tr>
<td height="23" colspan="9" align="center" class="hea STYLE1"> 没邮政卡号名单</td>
<td colspan="2" align="center" class="tdmy"><a href="workman.jsp">返回</a></td>
</tr>
<tr>
<td width="72" align="center" bgcolor="#D4D0C8" class="trmy">卡号</td>
<td width="72" align="center" bgcolor="#D4D0C8" class="trmy">姓名</td>
<td width="58" align="center" bgcolor="#D4D0C8" class="trmy">公司</td>
<td width="58" align="center" bgcolor="#D4D0C8" class="trmy">部门</td>
<td width="57" align="center" bgcolor="#D4D0C8" class="trmy">职位</td>
<td width="64" align="center" bgcolor="#D4D0C8" class="trmy">计粮方式</td>
<td width="140" align="center" bgcolor="#D4D0C8" class="trmy">银行卡号</td>
<td width="63" align="center" bgcolor="#D4D0C8" class="trmy">底薪</td>
<td width="79" align="center" bgcolor="#D4D0C8" class="trmy">入厂日期</td>
<td width="62" align="center" bgcolor="#D4D0C8" class="trmy">编辑</td>
<td width="57" align="center" bgcolor="#D4D0C8" class="trmy">删除</td>
</tr>
<%
// String sql="select * from Guestbook order by id DESC";
// ResultSet rs=stmt.executeQuery(sql); String sql="";
sql="select * from works where bankid='0' order by workid";
ResultSet rs=DBconn.executeQuery(sql);
// if(rs.next()){ rs.previous();
int intPageSize; //一页显示的记录数
int intRowCount; //记录总数
int intPageCount; //总页数
int intPage; //待显示页码
String strPage;
int i;
//设置一页显示的记录数
intPageSize = 16; //取得待显示页码
strPage = request.getParameter("page");
if(strPage==null){//表明在QueryString中没有page这一个参数,此时显示第一页数据
intPage = 1;
} else{//将字符串转换成整型
intPage = java.lang.Integer.parseInt(strPage);
if(intPage< 1) intPage = 1;
}
//获取记录总数
rs.last();
intRowCount = rs.getRow(); //总记录数
//out.print(intRowCount);
//记算总页数
intPageCount = (intRowCount+intPageSize-1) / intPageSize; //总页数
//调整待显示的页码
if(intPage >intPageCount) intPage = intPageCount;
if(intPageCount >0){
//将记录指针定位到待显示页的第一条记录上
rs.absolute((intPage-1) * intPageSize+1); i = 0;
while( i<intPageSize &&!rs.isAfterLast()){
int id=rs.getInt("ID");
int workid=rs.getInt("WORKID");
String na=rs.getString("NA");
String company=rs.getString("COMPANY");
String department=rs.getString("DEPARTMENT");
String d_salary=rs.getString("d_salary");
if(d_salary==null) d_salary="0";
String bankid=rs.getString("bankid");
if(bankid==null){bankid="";}
String duty_s=rs.getString("duty_s");
String methods=rs.getString("methods");
String r_dates=rs.getString("r_dates");
if(r_dates==null) r_dates="0000-00-00";
else r_dates=rs.getDate("r_dates").toString();
%>
<form action="bankid_mod.jsp" method="post" name="form1" id="form1" >
<tr>
<input type="hidden" name="id" value="<%=id%>" />
<td align="left"><input name="card" type="text" id="card" value="<%=workid%>" size="8" /></td>
<td align="left"><input name="name" type="text" id="name2" value="<%=na%>" size="8" /></td>
<td align="left">
<input name="company" type="text" value="<%=company%>" size="9" /> </td>
<td align="left"><input name="department" type="text" value="<%=department%>" size="9" /> </td>
<td align="left" class="trmy"><input name="duty2" type="text" id="duty2" value="<%=duty_s%>" size="8" /></td>
<td align="left" class="trmy"><select name="methods" id="methods">
<option value="<%=methods%>"><%=methods%></option>
<option value="员工" >员工</option>
<option value="员工85">员工85</option>
<option value="员工10">员工10</option>
<option value="员工11">员工11</option>
<option value="杂工">杂工</option>
<option value="职员">职员</option>
<option value="职员1">职员1</option>
<option value="职员2">职员2</option>
</select></td>
<td align="left"><input name="bankid" type="text" id="bankid2" value="<%=bankid%>" size="19" /></td>
<td align="left"><span class="trmy">
<input name="d_salary" type="text" id="d_salary" value="<%=d_salary%>" size="5" />
</span></td>
<td align="left"><input name="r_dates" type="text" id="r_dates" value="<%=r_dates%>" size="10" readonly="readonly" onClick="setday(this,r_dates)" /></td>
<td align="center" class="trmy"><input type="submit" name="Submit2" value="编辑" /></td>
<td align="center" class="trmy"><a href="javascript:go('bankid_del.jsp?id=<%=id%>','你确定要删除?不考虑一下?')">删除</a></td>
</tr>
</form>
<%
i++;
rs.next();
}
rs.close();
%>
<tr>
<td height="20" colspan="11" align="left"><div align="right">第<%=intPage%>页 共<%=intRowCount%>条记录/共<%=intPageCount%>页|||<a href="no_bankid.jsp?page=<%=intPage%>">刷新</a>|||
<%
if(intPage<2){
out.print("首页 | 上一页");
}else
{
%>
<a href="no_bankid.jsp?page=1">首页 </a> | <a href="no_bankid.jsp?page=<%=intPage-1%>">上一页</a>
<%
}
%>|
<%
if((intPageCount-intPage)<1)
{
out.print("下一页 | 尾页");
}else{%>
<a href="no_bankid.jsp?page=<%=intPage+1%>">下一页</a> | <a href="no_bankid.jsp?page=<%=intPageCount%>">尾页</a>
<%}
}
else
{
}
DBconn.closeStmt();
DBconn.closeConn();
%>
</div></td>
</tr>
</table>
out.print("</td>");
out.print("</tr>");</span></p>这两个标记怎么来的???
还有这个out.print("</td>");
还有这个out.print("</td>");去掉看看