请问在jsp分页时实现显示4行4列信息,怎么实现!
最好给些代码,谢谢!
最好给些代码,谢谢!
解决方案 »
- 求助,java web程序发布tomcat的问题!
- 哪位大神帮我看看啊????
- Oracle 乱码问题
- 如何向 Struts 中的 offset 属性 传变量值
- tomcat发布helloworld怎么都出错拉?!!!!
- servlet定时器访问数据库NullPointerException
- 要实现类似资源管理器一样,公司组织结构图(包括经理下面的员工),该怎么做?
- 一个调用servlet问题
- servlet如何实现对文件的删除?
- org.apache.cxf.transport.http.HTTPException: HTTP response '400:Bad Request'
- 用web可以做弹出界面的形式吗?
- javabean不能更新ACCESS2003数据库,高手请帮忙,谢谢
CODE:
-----------------------------------------------------------------------
<table id="t" width="602" border="1" cellpadding="0" cellspacing="0" bordercolorlight=#333333 bordercolordark=#efefef >
<%
Connection connect = null;
connect = dbcommand.dbConnect("","","");
int i=0; //记录当前的记录的行号
int count=0; //总记录条数,为计算页码所用
int ipage = 1; //超链接传递过来的页码数
int pages = 0; //总页码数,通过计算得来
String ipages = request.getParameter("ipage");
if (ipages!=null) { ipage = Integer.parseInt(ipages); }
Statement stmt = null;
ResultSet rs =null;
String sSql; //获取记录总条数,计算总页数 .start
sSql = "SELECT...........";
stmt = connect.createStatement();
rs = stmt.executeQuery(sSql);
while(rs.next()) { count = rs.getInt(1); }
pages = count%4 == 0 ?(count/4):(count/4+1);
pages = pages > 10 ? 10:pages;
rs.close();
stmt.close();
rs = null;
stmt = null;
// 获取记录总条数,计算总页数 .end
sSql = "select.........."
sSql += " from ";
stmt = connect.createStatement();
rs = stmt.executeQuery(sSql);
while(rs.next())
{
i = rs.getRow();
if( i > (ipage-1)*4 && i <= ipage*4 )
{
int num = i - 4*(ipage-1);
out.println("<tr height='18' onclick='setPoint(this)'>");
out.println("<td width='100'><div align='left'><span class='STYLE1'>"+ rs.getString(1) +"</span></div></td>");
out.println("<td width='216'><div align='left'><span class='STYLE1'>"+ rs.getString(2) +"</span></div></td>");
out.println("<td width='111'><div align='left'><span class='STYLE1'>"+ rs.getDouble(3) +"</span></div></td>");
out.println("<td width='123'><div align='left'><span class='STYLE1'>"+ rs.getString(4) +"</span></div></td>");
out.println("</tr>");
}
}
out.println("</table><hr style='border:thin;'/>");
rs.close(); stmt.close(); connect.close();
rs = null; stmt = null; connect = null;
<body >
<table width="602" border="1" cellpadding="0" cellspacing="0" bordercolorlight=#333333 bordercolordark=#efefef bgcolor="#33CCCC">
<tr height="20">
<td width="100"><div align="center" class="STYLE1">学号</div></td>
<td width="100"><div align="center" class="STYLE1">姓名</div></td>
<td width="50"><div align="center" class="STYLE1">年龄</div></td>
<td width="50"><div align="center" class="STYLE1">性别</div></td>
</tr>
</table>
<table align="center">
<tr>
<th class="msg" colspan="4">新闻管理</th>
</tr>
<tr class="top_title">
<td width="5%">ID</td>
<td width="60%">新闻标题</td>
<td width="20%">发布时间</td>
<td>操作</td>
</tr>
<c:if test="${requestScope['newslist']==null}" var="flag">
<tr height="25px">
<td colspan="4">暂无任何新闻</td>
</tr>
</c:if>
<c:if test="${flag==false}">
<c:set var="list" value="${requestScope['newslist']}"></c:set>
<c:forEach items="${requestScope['newslist']['page']}" var="news">
<tr class="outline" onmouseover="this.className='online'" onmouseout="this.className='outline'">
<td>${news.id}</td>
<td>${news.title}</td>
<td>${news.greatdate}</td>
<td><input type="button" value="修改" onclick="javascript:window.location.href='NewsServlet?do=edit&id=${news.id}'" />
<input type="button" value="删除" onclick="javascript:window.location.href='NewsDoServlet?do=del&id=${news.id}'"/></td>
</tr>
</c:forEach>
<tr>
<td colspan="4">
<table align="right">
<tr>
<td>当前是第${param["page"]}页</td>
<td width="20px">|</td>
<td>共${list["maxpage"]}页</td>
<td width="20px">|</td>
<td>每页${list.perpage}条</td>
<td width="20px">|</td>
<td>
<c:if test="${list['maxpage']==1}">
</c:if>
<c:if test="${param['page']==1&¶m['page']<list['maxpage']}">
<a href="NewsServlet?page=${param['page']+1}">下一页</a>
<a href="NewsServlet?page=${list['maxpage']}">尾页</a>
</c:if>
<c:if test="${param['page']!=1&¶m['page']==list['maxpage']}">
<a href="NewsServlet?page=1">首页</a>
<a href="NewsServlet?page=${param['page']-1}">上一页</a>
</c:if>
<c:if test="${param['page']!=1&¶m['page']!=list['maxpage']}">
<a href="NewsServlet?page=1">首页</a>
<a href="NewsServlet?page=${param['page']-1}">上一页</a>
<a href="NewsServlet?page=${param['page']+1}">下一页</a>
<a href="NewsServlet?page=${list['maxpage']}">尾页</a>
</c:if>
</td>
<td width="20px">|</td>
<td>
转到第<select onchange="javascript:window.location.href=this.options[this.selectedIndex].value;">
<%
Page p = (Page)request.getAttribute("newslist");
for (int i = 1; i <= p.getMaxpage(); i++) {
if(i==Integer.parseInt(request.getParameter("page"))){%>
<option value="NewsServlet?page=${param['page']}" selected="selected">${param['page']}</option>
<%}else{%>
<option value="NewsServlet?page=<%=i%>"><%=i%></option>
<%}
}
%></select>页
</td>
</tr>
</table>
</td>
</tr>
</c:if>
</table>
http://www.family168.com/tutorial/jsp/html/jsp-ch-15.html