SET QUOTED_IDENTIFIER OFF
GO
SET ANSI_NULLS OFF
GO
--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时,计算记录集总数并输出
AS
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
GO
SET QUOTED_IDENTIFIER OFF
GO
SET ANSI_NULLS ON
GO
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("<font face=webdings>9</font>");
}
else {
Tep.append("<a href=/"?iPages=1&Cn=" + totalCount + ""+url+"/" title=
首页><font face=webdings>9</font></a>");
}
Tep.append("</td><td class=/"tab2/">");
if (P * 10 > 0) {
Tep.append("<a href=/"?iPages=" + P * 10 + "&Cn=" + totalCount +
""+url+"/" title=
上10页><font face=webdings>7</font></a> ");
}
else {
Tep.append("<font face=webdings>7</font> ");
}
Tep.append("</td>");
for (II = P * 10 + 1; II <= P * 10 + 10; II++) {
if (II == iPage) {
Tep.append("<td class=/"tab2/"><font color='red'>"+II+"</font></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页><font face=webdings>8</font></a>");
}
else {
Tep.append("<font face=webdings>8</font>");
}
Tep.append("</td><td class=/"tab2/">");
if (iPage == PageCount) {
Tep.append("<font face=webdings>:</font>");
}
else {
Tep.append("<a href=/"?iPages="+PageCount+"&Cn="+totalCount+
""+url+"/" title=
尾页><font face=webdings>:</font></a>");
}
Tep.append("</td><td class=/"tab3/">
共 " + totalCount +
"
信息 </td><td class=/"tab3/"> 第 <font color=red>" + iPage +
"</font>/" + 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{
background-image: url(../images/BBSbg/tr.jpg);
line-height: 25px;
}
.tr1{
background-image: url(../images/BBSbg/tr1.jpg);
}
.tr2{
COLOR: #000000;
BACKGROUND-COLOR: #E3F2FD;
margin: 1px;
padding: 1px;
font-size: 12px;
border: 1px solid #FFFFFF;
background-image: url(../images/BBSbg/tr2.jpg);
}
.td{
word-break:break-all;
COLOR: #000000;
BACKGROUND-COLOR: #D1E8FC;
margin: 1px;
padding: 1px;
font-size: 12px;
border: 1px solid #FFFFFF;
background-image: url(../images/BBSbg/td.jpg);
}
.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;
}