秋写的分页存储过程及样式

来源：互联网发布：交互式flash制作软件编辑：程序博客网时间：2024/05/17 03:36

SET QUOTED_IDENTIFIER OFF

SET ANSI_NULLS OFF

--EXECUTE System_Write_Page 5,1,0,'[id], username','ASK',0,'[ID]','property=''A''',NULL

ALTER PROCEDURE System_Write_Page

@PageSize int, --每页输出记录数

@Page int, --当前页面数

@Total int, --记录集总数

@Row Varchar(1000), --输出列

@Table Varchar(30), --操作表名

@Order int, --排序：0正序1倒序

@Main Varchar(20), --主键

@Search Varchar(1000), --搜索条件[property=''A'']将'转换成''要不出错

@CountTotal int OutPut --当@Total=0时，计算记录集总数并输出

DECLARE @NSQL Nvarchar(3000),@SearchStr Varchar(1000),@OrderStr Varchar(200),@Str Varchar(100)

IF (@Search<>'') AND (@Search IS NOT NULL)

BEGIN

SET @SearchStr=' AND '+@Search

END

ELSE

BEGIN

SET @SearchStr=' '

END

IF @Order=0

BEGIN

SET @OrderStr=' ORDER BY '+@Main

SET @Str='>(SELECT MAX('

END

ELSE

BEGIN

SET @OrderStr=' ORDER BY '+@Main+' DESC'

SET @Str='<(SELECT MIN('

END

IF @Total=0

BEGIN

SET @NSQL=N'SELECT @CountTotal=COUNT(*) FROM '+@Table+' WHERE (1=1)'+@SearchStr

EXECUTE sp_executesql @nSQL,N'@CountTotal int OutPut',@CountTotal OutPut

END

ELSE

BEGIN

SET @CountTotal=@Total

END

IF @Page=1

BEGIN

SET @NSQL=N'SELECT TOP '+CAST(@PageSize AS VARCHAR)+' '+@Row+' FROM '+@Table+' WHERE (1=1)'+@SearchStr+@OrderStr

END

ELSE

BEGIN

SET @NSQL=N'SELECT TOP '+CAST(@PageSize AS VARCHAR)+' '+@Row+' FROM '+@Table+' WHERE '+@Main+@Str+@Main+')'

SET @NSQL=@NSQL+N' FROM (SELECT TOP '+CAST((@Page-1)*@PageSize AS VARCHAR)+' '+@Main+' FROM '+@Table+' WHERE (1=1)'+@SearchStr+@OrderStr+') DD )'

SET @NSQL=@NSQL+N' '+@SearchStr+@OrderStr

END

EXECUTE sp_executesql @nSQL

SET QUOTED_IDENTIFIER OFF

SET ANSI_NULLS ON

package zixun;

public class JumpPage {

/**

* 分页Html

* @param totalCount 记录集总数类型 int

* @param pageNum 每页显示数量类型 int

* @param iPage 当前页,类型 int

* @param url 需要传递的参数如："&Action=a"

* @return

//=====================主题列表分页代码=======================//

public static String pageJump(int totalCount, int pageNum, int iPage,String url){

if (iPage <=0 ){iPage= 1;}

int PageCount=(totalCount%pageNum==0)?(totalCount/pageNum):(totalCount/pageNum+1);//页面总数

if(PageCount==0) PageCount=1;//MaxPage=PageCount;

if(iPage>PageCount){iPage=PageCount;}

/**********************************************/

StringBuffer Tep = new StringBuffer();

int P,II;//分页信息开始//

Tep.append("<table height=/"25/" border=/"0/" cellpadding=/"2/" cellspacing=/"1/" class=/"tab_0/"><tr class=/"tab1/">");

Tep.append("<td class=/"tab2/">");

if ( (iPage - 1) % 10 == 0) {

P = (iPage - 1) / 10;

}

else {

P = (iPage - 1) / 10;

}

if (iPage == 1) {

Tep.append("9");

}

else {

Tep.append("<a href=/"?iPages=1&Cn=" + totalCount + ""+url+"/" title=首页>9</a>");

}

Tep.append("</td><td class=/"tab2/">");

if (P * 10 > 0) {

Tep.append("<a href=/"?iPages=" + P * 10 + "&Cn=" + totalCount +

""+url+"/" title=上10页>7</a> ");

}

else {

Tep.append("7 ");

}

Tep.append("</td>");

for (II = P * 10 + 1; II <= P * 10 + 10; II++) {

if (II == iPage) {

Tep.append("<td class=/"tab2/">"+II+"</td>");

}

else {

Tep.append("<td class=/"tab2/"><a href=/"?iPages="+II+"&Cn="+totalCount+""+url+"/">" + II + "</a> </td>");

}

if (II == PageCount) {

break;

}

Tep.append("<td class=/"tab2/">");

if (II < PageCount) {

Tep.append("<a href=/"?iPages="+II+"&Cn="+totalCount+""+url+"/" title=下10页>8</a>");

}

else {

Tep.append("8");

}

Tep.append("</td><td class=/"tab2/">");

if (iPage == PageCount) {

Tep.append(":");

}

else {

Tep.append("<a href=/"?iPages="+PageCount+"&Cn="+totalCount+

""+url+"/" title=尾页>:</a>");

}

Tep.append("</td><td class=/"tab3/">  共 " + totalCount +

" 信息 </td><td class=/"tab3/"> 第 " + iPage +

"/" + PageCount + " 页 </td><td class=/"tab3/"> 每页 " +

pageNum + " 条  </td></tr></table>");

return Tep.toString();

}

@charset "UTF-8";

body {

PADDING-TOP: 0px;

PADDING-BOTTOM: 0px;

PADDING-LEFT: 0px;

PADDING-right: 0px;

margin-left: 5px;

margin-top: 0px;

margin-right: 5px;

margin-bottom: 0px;

word-break:break-all;

line-height: 18PX;

font-size: 12px;

background-color: #ffffff;

scrollbar-highlight-color: buttonface;

scrollbar-shadow-color: buttonface;

scrollbar-3dlight-color: buttonhighlight;

scrollbar-track-color: #eeeeee;

scrollbar-darkshadow-color: buttonshadow;

}

td {

font-size: 12px;

font-family: "Verdana","宋体", "Arial";

word-break:break-all;

}

a:link{font-size: 12PX; color: #333333; text-decoration: none;}

a:visited { font-size: 12PX;color: #333333;text-decoration: none;}

a:active {font-size: 12PX;color: #CC0000;text-decoration: none;}

a:hover {font-size: 12PX;color: #ff0000;text-decoration:underline;}

.key{font-size: 12px;color: #cc0000;font-family: "Verdana","宋体", "Arial"; word-break:break-all;line-height: 19PX;}

.content{margin-left: 8px;font-size: 14px;font-family: "Verdana","宋体", "Arial"; word-break:break-all;}

.barbgOut{COLOR: #000000; background-color: #98c6f3;}

.barbgOver{ BORDER-LEFT: #fff 1px solid; BORDER-RIGHT: #fff 1px solid; BORDER-BOTTOM: #fff 1px solid; BORDER-TOP: #fff 1px solid; COLOR: #000000;BACKGROUND-COLOR: #D1E8FC}

.bg0{

font-size: 12px;

BACKGROUND-COLOR: #ffffff;

word-break:break-all;

}

.bg1{

word-break:break-all;

font-size: 12px;

BACKGROUND-COLOR: #98c6f3;

}

.bg2{font-size: 12px; BACKGROUND-COLOR: #F0FAFF; }

.tab{

COLOR: #000000;

BACKGROUND-COLOR: #B6D6F3;

margin-bottom: 2px;

margin-top: 2px;

margin-right: 0px;

margin-left: 0px;

}

.tab_0{

COLOR: #000000;

BACKGROUND-COLOR: #B6D6F3;

margin-bottom: 2px;

margin-top: 0px;

margin-right: 0px;

margin-left: 0px;

}

.tab1{

COLOR: #000000;

BACKGROUND-COLOR: #D1E8FC;

margin: 1px;

padding: 1px;

font-size: 12px;

border: 1px solid #FFFFFF;

}

.tab2{

COLOR: #000000;

word-break:break-all;

BACKGROUND-COLOR: #E3F2FD;

margin: 1px;

padding: 1px;

font-size: 12px;

border: 1px solid #FFFFFF;

}

.tab3 {

word-break:break-all;

COLOR: #000000;

BACKGROUND-COLOR: #EFF8FE;

margin: 1px;

padding: 1px;

font-size: 12px;

border: 1px solid #FFFFFF;

}

.tr{

line-height: 25px;

}

.tr1{

}

.tr2{

COLOR: #000000;

BACKGROUND-COLOR: #E3F2FD;

margin: 1px;

padding: 1px;

font-size: 12px;

border: 1px solid #FFFFFF;

}

.td{

word-break:break-all;

COLOR: #000000;

BACKGROUND-COLOR: #D1E8FC;

margin: 1px;

padding: 1px;

font-size: 12px;

border: 1px solid #FFFFFF;

}

.inputText{

FONT-SIZE: 12px;

color: #000099;

BACKGROUND-IMAGE: url(../GVimgs/GVbg/home.gif);

background-position: 2px;

BACKGROUND-REPEAT: no-repeat;

PADDING-LEFT: 20px;

PADDING-BOTTOM: 2px;

PADDING-RIGHT: 2px;

BORDER-RIGHT: buttonface 1px solid;

BORDER-TOP: buttonface 1px solid;

BORDER-LEFT: buttonface 1px solid;

BORDER-BOTTOM: buttonface 1px solid;

vertical-align: bottom;

padding-top: 2px;

}

.smallTxt{FONT-SIZE: 11px; FONT-FAMILY: "verdana", "宋体"}

.smallTxt:link {FONT-SIZE: 11px; FONT-FAMILY: "verdana", "宋体"}

.smallTxt:visited {FONT-SIZE: 11px; FONT-FAMILY: "verdana", "宋体"}

.smallTxt:active {FONT-SIZE: 11px; FONT-FAMILY: "verdana", "宋体"}

.smallTxt:hover {FONT-SIZE: 11px; FONT-FAMILY: "verdana", "宋体"}

textarea {font-size: 12px; color: #000000; FONT-FAMILY: "verdana", "宋体"}

.pageTree {font-family:"Verdana", "宋体"; font-size: 18px; COLOR: #000011;}

.menuskin {

BORDER-RIGHT: #666666 1px solid; BORDER-TOP: #666666 1px solid; BACKGROUND-IMAGE: url(Skins/Default/dvmenubg3.gif); VISIBILITY: hidden; FONT: 12px Verdana; BORDER-LEFT: #666666 1px solid; BORDER-BOTTOM: #666666 1px solid; BACKGROUND-REPEAT: repeat-y; POSITION: absolute; BACKGROUND-COLOR: #efefef

}

.poplayer {

BORDER-RIGHT: #000000 1px solid; PADDING-RIGHT: 3px; BORDER-TOP: #000000 1px solid; PADDING-LEFT: 3px; FONT-SIZE: 9pt; VISIBILITY: hidden; PADDING-BOTTOM: 3px; BORDER-LEFT: #000000 1px solid; COLOR: #000000; PADDING-TOP: 3px; BORDER-BOTTOM: #000000 1px solid; FONT-FAMILY: "宋体"; POSITION: absolute; BACKGROUND-COLOR: #ffffdd

}

.showMenu{

PADDING-RIGHT: 2px;

PADDING-LEFT: 12px;

PADDING-BOTTOM: 2px;

PADDING-TOP: 2px;

BORDER-RIGHT: #B6D6F3 1px solid;

BORDER-TOP: #B6D6F3 1px solid;

BORDER-LEFT: #B6D6F3 1px solid;

BORDER-BOTTOM: #B6D6F3 1px solid;

BACKGROUND-IMAGE: url(../images/BBSmenu.gif);

VISIBILITY: hidden;

BACKGROUND-REPEAT: repeat-y; POSITION: absolute;

BACKGROUND-COLOR: #ECF7FF

}

.showMenu UL {

PADDING-RIGHT: 0px;

PADDING-LEFT: 0px;

PADDING-BOTTOM: 0px;

PADDING-TOP: 0px;MARGIN: 0px;

}

.showMenu LI {

PADDING-RIGHT: 4px;

PADDING-LEFT: 4px;

PADDING-BOTTOM: 2px;

PADDING-TOP: 2px;

LIST-STYLE-TYPE: none;

list-style-position: inside;

}

.showMenu LI A {

PADDING-RIGHT: 4px;

PADDING-LEFT: 4px;

PADDING-BOTTOM: 2px;

PADDING-TOP: 2px;

COLOR: #000000;

}

.showMenu LI A:hover {

PADDING-RIGHT: 4px;

PADDING-LEFT: 4px;

PADDING-BOTTOM: 2px;

PADDING-TOP: 2px;

BACKGROUND-COLOR: #498FD6;

COLOR: #FFFFFf;

}

input {

padding: 1px 1px 1px 1px;

margin-left: 0px;

margin-top: 0px;

margin-right: 0px;

margin-bottom: 0px;

}

.btn {

BORDER-LEFT: 1px solid #F6F6F6;

BORDER-TOP: 1px solid #F6F6F6;

BORDER-RIGHT: 1px solid #999999;

BORDER-BOTTOM: 1px solid #999999;

FONT-SIZE: 12px;

HEIGHT: 19pt;

background-color: #D4D0C8;

padding-top: 3px;

padding-right: 2px;

padding-left: 2px;

}

.file {

BORDER-LEFT: 1px solid #D4D0C8;

BORDER-TOP: 1px solid #D4D0C8;

BORDER-RIGHT: 1px solid #999999;

BORDER-BOTTOM: 1px solid #999999;

FONT-SIZE: 12px;

HEIGHT: 18pt;

background-color: #ffffff;

PADDING-TOP: 4px;

padding-right: 2px;

padding-bottom: 2px;

padding-left: 2px;

}

.input {

BACKGROUND-COLOR:#FFffFF; BORDER-BOTTOM: #999999 1px solid; BORDER-LEFT: #999999 1px solid; BORDER-RIGHT: #999999 1px solid; BORDER-TOP: #999999 1px solid; FONT-SIZE: 10pt;color:#000000

}

hr {

border: 1px solid #B6D6F3;

line-height: 1px;

margin: 0px;

height: 1px;

}