<%
//變量聲明
java.sql.connection sqlcon; //數據庫連接對象
java.sql.statement sqlstmt; //sql語句對象
java.sql.resultset sqlrst; //結果集對象
java.lang.string strcon; //數據庫連接字符串
java.lang.string strsql; //sql語句
int intpagesize; //一頁顯示的記錄數
int introwcount; //記錄總數
int intpagecount; //總頁數
int intpage; //待顯示頁碼
int layer;
int idlayer;
idlayer=1;
java.lang.string outtext;
outtext="";
java.lang.string strpage;
int j;
int i;
//設置一頁顯示的記錄數
intpagesize = 10;
//取得待顯示頁碼
strpage = request.getparameter("page");
if(strpage==null){//表明在querystring中沒有page這一個參數，此時顯示第一頁數據
intpage = 1;
}
else{//將字符串轉換成整型
intpage = java.lang.integer.parseint(strpage);
if(intpage<1) intpage = 1;
}
//裝載jdbc驅動程序
class.forname("org.gjt.mm.mysql.driver").newinstance();
//連接數據庫
sqlcon = java.sql.drivermanager.getconnection("jdbc:mysql://218.22.156.3/kjeny_db","kjeny","cdgame");
//創建語句對象
sqlstmt = sqlcon.createstatement(java.sql.resultset.type_scroll_insensitive,java.sql.resultset.concur_read_only);
//執行sql語句并獲取結果集
sqlrst = sqlstmt.executequery("select * from dxswlxh");
//獲取記錄總數
sqlrst.last();
introwcount = sqlrst.getrow();
//記算總頁數
intpagecount = (introwcount+intpagesize-1) / intpagesize;
//調整待顯示的頁碼
if(intpage>intpagecount) intpage = intpagecount;
%>
<html>
<head>
<meta http-equiv="content-type" content="text/html; charset=gb2312">
<base target="contents">
<link rel="stylesheet" href="css.css">
<script language="javascript">
function bytelen(str) {
var ibytelen = 0;
if (str == null || str == "") {
ibytelen = 0;
} else {
for (var i = 0; i < str.length; i++) {
if(str.charcodeat(i) < 0x80) {
ibytelen++;
} else {
ibytelen += 2;
}
}
}
return ibytelen;
}
</script>
</head>
<body topmargin="0" leftmargin="0" bgcolor=ccffcc>
<table width="100%"><tr><td bgcolor="ff66cc">
>> 分頁
<form method=post action="pink.jsp?page=1" target=ttop>
<input type=submit value="首 頁">
</form>
<%if(intpage>1){
%>
<form method=post action="pink.jsp?page=<%=intpage-1%>" target=ttop>
<input type=submit value=上一頁>
</form>
<%}%>
<%if(intpage<intpagecount)
{%>
<form method=post action="pink.jsp?page=<%=intpage+1%>" target=ttop>
<input type=submit value=下一頁>
</form>
<%}%>
<form method=post action="pink.jsp?page=<%=intpagecount%>" target=ttop>
<input type=submit value="尾 頁">
</form>
頁次：<%=intpage%>/<%=intpagecount%>頁 <%=intpagesize%>條/頁
</td></tr></table>
<table>
<td width="%100"><ul><%
if(intpagecount>0){
sqlrst.absolute((intpage-1) * intpagesize + 1);
i = 0;
while(i<intpagesize && !sqlrst.isafterlast()){
string names = sqlrst.getstring(3);
string use_xi = sqlrst.getstring(4);
%>
<li><%=names%> - 【<%=use_xi%>】
<%
sqlrst.next();
i++;
}
}
%>
</ul></td></table>
</body>
</html>
<%
//關閉結果集
sqlrst.close();
//關閉sql語句對象
sqlstmt.close();
//關閉數據庫
sqlcon.close();
%>
新聞熱點
疑難解答
