谁有完整的jsp分页程序？
各位：
谁有完整的jsp分页程序？
[解决办法]
网上多的是，如果找不到你Ｑ我，晚上给你！
[解决办法]
<%@ page contentType= "text/html; charset=gb2312 " language= "java " import= "java.sql.* " errorPage= " " %>
<!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.01 Transitional//EN " "http://www.w3.org/TR/html4/loose.dtd ">
<%@ page import= "java.util.* "%>
<%@ page import= "shenzhou.DAO.* "%>
<%@ page import= "shenzhou.Bean.* "%>
<html>
<title> 新视窗管理 </title>
<style>
td{ font-size:14px;}
</style>
<body>
<table width= "98% " border= "0 " align= "center " cellpadding= "1 " cellspacing= "0 " bgcolor= "E6E6E6 ">
<tr bgcolor= "#CCCCCC ">
<td align= "center "> <strong> 视窗大类管理 </strong> </td>
</tr>
<tr>
<form name= "form1 " method= "post " action= "/ad/shichuang/DaleiView.html?dalei=delete ">
<td height= "200 " valign= "top " bgcolor= "#FFFFFF "> <br>
<table width= "100% " border= "0 " align= "center " cellpadding= "0 " cellspacing= "1 " bgcolor= "E6E6E6 ">
<tr height= "20 " bgcolor= "#FFFFFF ">
<td width= "10% " align= "center "> 大类名称 </td>
<td width= "15% " align= "center "> 版本 </td>
<td WIDTH= "8% " align= "center "> 删除 </td>
<td WIDTH= "6% " align= "center "> 修改 </td>
</tr>
<%
LinkedList talkList=(LinkedList)session.getAttribute( "daleiview ");
int countSize=0; //总记录数
int sumPage=0; //总页数
int sizePage=20; //每页显示页数
int dPage=0; //当前第几页
int start=0;
int end=0;
if(talkList.size()==0)
{
out.println( " <font color= 'red '> 对不起，暂无数据！！！ </font> ");
}
else
{
String strPage=request.getParameter( "page ");
if(strPage==null)
{
dPage=1;
}
else
{
dPage=Integer.parseInt(strPage);
if(dPage <1)
{
dPage=1;
}
}
if(talkList!=null)
{
countSize=talkList.size(); //得总记录
}
sumPage=(countSize+sizePage-1)/sizePage; //得总页数
if(dPage==sumPage)
{
dPage=sumPage;
}
start=(dPage-1)*sizePage; //定位记录号
end=sizePage*dPage;
for(int i=start;i <end&&i <countSize;i++)
{
DaleiBean daleibean = new DaleiBean();
daleibean=(DaleiBean)talkList.get(i);
%>
<tr align= "center " bgcolor= "#FFFFFF " height= "20 ">
<td align= "center "> <%=daleibean.getDalei_name()%> </td>
<td align= "center "> <%=daleibean.getDalei_banben()%> </td>
<td> <input name= "chuangid " type= "checkbox " id= "daleiid " value= " <%=daleibean.getDalei_id()%> " > </td>
<td align= "center "> <a href= "/ad/shichuang/DaleiView.html?dalei=updateview&daleiid= <%=daleibean.getDalei_id()%> "> 修改 </a> </td>
</tr>
<%
}
%>
</table>
<br> <br> <div align= "center ">
<input type= "submit " name= "Submit " value= "删除所选用户 " onClick= "return confirm( '您确定要这样操作吗？ ') ">
全选 <input type= "checkbox " name= "checkbox2 " value= "Check All " onClick= "mm() ">
共 <font color= "red "> <%=countSize%> </font> 记录
共 <font color= "red "> <%=sumPage%> </font> 页
当前第 <font color= "red "> <%=dPage%> </font> 页
<% if(dPage==1)
{
%>
首 页
<%
}
else
{
%>
<a href= "/shenzhou/common/shichuang/daleiview.jsp?page=1 "> 首 页 </a>
<%
}
%>
<%
if(dPage> 1)
{
%>
<a href= "/shenzhou/common/shichuang/daleiview.jsp?page= <%=dPage-1%> "> 上一页 </a>
<%
}else{
%>
上一页
<% } %>
<%
if(dPage <sumPage)
{
%>
<a href= "/shenzhou/common/shichuang/daleiview.jsp?page= <%=dPage+1%> "> 下一页 </a>
<% }else{ %>
下一页
<% } %>
<% if(dPage==sumPage)
{ %>
尾 页
<% }else{ %>
<a href= "/shenzhou/common/shichuang/daleiview.jsp?page= <%=sumPage%> "> 尾 页 </a>
<% } %>
</div> </td>
<%}%>
</form>
<%
Object obj=request.getAttribute( "chuangdel ");
if(obj!=null)
{
out.println( " <script> alert( '删除成功！！！ '); </script> ");
}
%>
</tr>
</table>
</body>
</html>
<script language=javascript>
function mm()
{
var a = document.getElementsByTagName( "input ");
if(a[0].checked==true){
for (var i=0; i <a.length; i++)
if (a[i].type == "checkbox ") a[i].checked = false;
}
else
{
for (var i=0; i <a.length; i++)
if (a[i].type == "checkbox ") a[i].checked = true;
}
}
</script>
凑合着看吧
[解决办法]
<%@ page import= "java.sql.* " %>
<%@ page import= "java.io.* " %>
<%@ page import= "java.util.* " %>
<jsp:useBean id= "sqlconn " scope= "page " class= "kk.database.sqlconn " />
<%! String aTitle,aAuthor,AType,ArticleType,InsertTime,Color; %>
<!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.0 Transitional//EN ">
<HTML>
<HEAD>
<TITLE> ArticleList </TITLE>
<META NAME= "Generator " CONTENT= "jBuilder3.5 && jEdit1.0 ">
<META NAME= "Author " CONTENT= "bigangell ">
<META NAME= "Keywords " CONTENT= "Java,Servlet,Jsp,Beans,PHP ">
<META NAME= "Description " CONTENT= "A Pure World For Programming Include C/C++,Java ">
<META HTTP-EQUIV= "Content-Type " CONTENT= "text/html; CHARSET=gb2312 ">
<link rel= "stylesheet " href= "style.css ">
</head>
<body bgcolor= "#FFFFFF ">
<table width= "760 " border= "0 " cellspacing= "0 " cellpadding= "0 " align= "center ">
<tr>
<td>
<table width= "750 " border= "0 " cellspacing= "2 " cellpadding= "2 " align= "center ">
<tr align= "center ">
<td> </td>
</tr>
<tr>
<td>
<table width= "740 " border= "0 " cellspacing= "1 " cellpadding= "1 " align= "center ">
<tr align= "center " bgcolor= "#CCCCCC ">
<td> <b> 标题 </b> </td>
<td> <b> 作者 </b> </td>
<td> <b> 类型 </b> </td>
<td> <b> 点击 </b> </td>
<td> <b> 加入时间 </b> </td>
</tr>
<%
int i;
int ipage=10; //分页单位
int allpage; //总页数
int pages; //接受的页码变量
int cpage=1; //当前页
int spage; //开始页
//数据库连接声明
java.lang.String sql,pagesql;
java.sql.ResultSet rs,pagers;
pagesql = "select count(a_id) as A from article ";
//取总文章数
pagers = sqlconn.executeQuery(pagesql);
int allCol = pagers.getInt( "A ");
//获得总页面数
allpage = (int)Math.ceil((allCol + ipage-1) / ipage);
//判断参数pages是否为空
if (request.getParameter( "pages ")==null) {
pages=1;
} else {
pages = new Integer(request.getParameter( "pages ")).intValue();
}
//判断当前页
if(pages > allpage // pages == 0){
cpage = 1;
} else {
cpage = pages;
}
//判断起始页
spage=(cpage-1)*ipage;
sql = "select a_id,a_title,a_author,aID,a_time,a_readtime,sID from article order by a_id desc limit "+ spage + ", "+ ipage;
rs = sqlconn.executeQuery(sql);
int cu=1;
//循环取数据库值
while (rs.next()) {
int aID = rs.getInt( "a_id ");
aTitle = rs.getString( "a_title ");
aAuthor = rs.getString( "a_author ");
int ArticleTypeID = rs.getInt( "aID ");
int ReadTime = rs.getInt( "a_readtime ");
InsertTime = rs.getString( "a_time ");
if (cu % 2 == 0) { Color= "#DBECFD "; }
else { Color= "#C6E1FD "; }
switch (ArticleTypeID) {
case(1):
ArticleType= "小说 ";
break;
case(2):
ArticleType= "散文 ";
break;
case(3):
ArticleType= "诗歌 ";
break;
case(4):
ArticleType= "随笔 ";
break;
}
%>
<tr bgcolor= " <%= Color %> ">
<td width= "300 "> <a href= "viewarticle.jsp?aID= <%= aID %> "> <%= aTitle %> </a> </td>
<td align= "center " width= "100 "> <%= aAuthor %> </td>
<td align= "center " width= "50 "> <%= ArticleType %> //Author tar（bigangell@yesky.com）
<%@ page import= "java.sql.* " %>
<%@ page import= "java.io.* " %>
<%@ page import= "java.util.* " %>
<jsp:useBean id= "sqlconn " scope= "page " class= "kk.database.sqlconn " />
<%! String aTitle,aAuthor,AType,ArticleType,InsertTime,Color; %>
<!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.0 Transitional//EN ">
<HTML>
<HEAD>
<TITLE> ArticleList </TITLE>
<META NAME= "Generator " CONTENT= "jBuilder3.5 && jEdit1.0 ">
<META NAME= "Author " CONTENT= "bigangell ">
<META NAME= "Keywords " CONTENT= "Java,Servlet,Jsp,Beans,PHP ">
<META NAME= "Description " CONTENT= "A Pure World For Programming Include C/C++,Java ">
<META HTTP-EQUIV= "Content-Type " CONTENT= "text/html; CHARSET=gb2312 ">
<link rel= "stylesheet " href= "style.css ">
</head>
<body bgcolor= "#FFFFFF ">
<table width= "760 " border= "0 " cellspacing= "0 " cellpadding= "0 " align= "center ">
<tr>
<td>
<table width= "750 " border= "0 " cellspacing= "2 " cellpadding= "2 " align= "center ">
<tr align= "center ">
<td> </td>
</tr>
<tr>
<td>
<table width= "740 " border= "0 " cellspacing= "1 " cellpadding= "1 " align= "center ">
<tr align= "center " bgcolor= "#CCCCCC ">
<td> <b> 标题 </b> </td>
<td> <b> 作者 </b> </td>
<td> <b> 类型 </b> </td>
<td> <b> 点击 </b> </td>
<td> <b> 加入时间 </b> </td>
</tr>
<%
int i;
int ipage=10; //分页单位
int allpage; //总页数
int pages; //接受的页码变量
int cpage=1; //当前页
int spage; //开始页
//数据库连接声明
java.lang.String sql,pagesql;
java.sql.ResultSet rs,pagers;
pagesql = "select count(a_id) as A from article ";
//取总文章数
pagers = sqlconn.executeQuery(pagesql);
int allCol = pagers.getInt( "A ");
//获得总页面数
allpage = (int)Math.ceil((allCol + ipage-1) / ipage);
//判断参数pages是否为空
if (request.getParameter( "pages ")==null) {
pages=1;
} else {
pages = new Integer(request.getParameter( "pages ")).intValue();
}
//判断当前页
if(pages > allpage // pages == 0){
cpage = 1;
} else {
cpage = pages;
}
//判断起始页
spage=(cpage-1)*ipage;
sql = "select a_id,a_title,a_author,aID,a_time,a_readtime,sID from article order by a_id desc limit "+ spage + ", "+ ipage;
rs = sqlconn.executeQuery(sql);
int cu=1;
//循环取数据库值
while (rs.next()) {
int aID = rs.getInt( "a_id ");
aTitle = rs.getString( "a_title ");
aAuthor = rs.getString( "a_author ");
int ArticleTypeID = rs.getInt( "aID ");
int ReadTime = rs.getInt( "a_readtime ");
InsertTime = rs.getString( "a_time ");
if (cu % 2 == 0) { Color= "#DBECFD "; }
else { Color= "#C6E1FD "; }
switch (ArticleTypeID) {
case(1):
ArticleType= "小说 ";
break;
case(2):
ArticleType= "散文 ";
break;
case(3):
ArticleType= "诗歌 ";
break;
case(4):
ArticleType= "随笔 ";
break;
}
%>
<tr bgcolor= " <%= Color %> ">
<td width= "300 "> <a href= "viewarticle.jsp?aID= <%= aID %> "> <%= aTitle %> </a> </td>
<td align= "center " width= "100 "> <%= aAuthor %> </td>
<td align= "center " width= "50 "> <%= ArticleType %> </td>
<td align= "center " width= "50 "> <%= ReadTime %> </td>
<td align= "center " width= "240 "> <%= InsertTime %> </td>
</tr>
<%
cu++;
}
%>
<tr bgcolor= "#CCCCCC ">
<td colspan= "5 " align= "right " valign= "middle "> 共 <%= allCol %> 条记录 共 <%= allpage %> 页 <% if (cpage> 1) { %> <a href= "article.jsp?pages= <%= cpage-1 %> "> <img src= "images/prev.gif " border= "0 "> </a> <% } if (cpage <allpage) { %> <a href= "article.jsp?pages= <%= cpage+1 %> "> <img src= "images/next.gif " border= "0 "> </a> <% } %> / <% for (i=1;i <=allpage;i++) { if (i != pages) {%> <a href= "article.jsp?pages= <%= i %> "> <%= i %> </a> <% } }%> </td>
</tr>
</table>
</td>
</tr>
</table>
</td>
</tr>
</table>
</body>
</html>
[解决办法]
用存储过程就可以了
[解决办法]
最好是写一个javaBean来分页，直接在页面上面分页太乱了
