? <%@ page contentType="text/html;charset=gb2312" %><%@ page import="java.sql.*, javax.sql.DataSource, javax.naming.InitialContext" %><% //建立一个JNDI查找对象 InitialContext JNDI_Context = new InitialContext(); //JNDI查找数据源 DataSource ds = (DataSource) JNDI_Context.lookup("jdbc/mysqlDbPage"); //得到一个数据源连接Connection conn = ds.getConnection(); int intPageSize; //一页显示的记录数 int intRowCount; //记录总数 int intPageCount; //总页数 int intPage; //待显示页码 java.lang.String strPage; int i;//设置一页显示的记录数intPageSize = 2;//取得待显示页码 strPage = request.getParameter("page"); if(strPage==null){//表明在QueryString中没有page这一个参数,此时显示第一页数据 intPage = 1; } else{//将字符串转换成整型 intPage = java.lang.Integer.parseInt(strPage); if(intPage<1) intPage = 1;} // 得到结果stmt = conn.createStatement(); ResultSet sqlRst = stmt.executeQuery("select f1 from test"); //获取记录总数 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"> <title>JSP数据库操作例程 - 数据分页显示 - JDBC 2.0 - mysql</title> </head> <body> <table border="1" cellspacing="0" cellpadding="0"><tr> <th>姓名</th> </tr><% if(intPageCount>0){ //将记录指针定位到待显示页的第一条记录上 sqlRst.absolute((intPage-1) * intPageSize + 1); //显示数据 i = 0;while(i<intPageSize && !sqlRst.isAfterLast()){ %> <tr> <td><%=sqlRst.getString(1)%></td> </tr><% sqlRst.next(); i++; } } %> </table>第<%=intPage%>页 共<%=intPageCount%>页 <%if(intPage<intPageCount){%><a href="mysqlpage.jsp?page=<%=intPage+1%>">下一页</a><%}%><%if(intPage>1){%><a href="mysqlpage.jsp?page=<%=intPage-1%>">上一页</a><%}%> </body> </html>
解决方案 »
- 拓展训练之感——自己写的第一篇感想
- <c:forEach items 显示列表时,集合的值已经取到,怎么分项显示是空白的呀?哪里问题,请高手不吝赐教啊
- tapestry结合javabean
- 如何为自己的网站添加rss功能?
- 在网页编程里用什么方法可以去掉地址栏!
- 急问!!!!!!!!!!关于applet中用图片做背景的在线等!!!!!!!!!1
- 如何将从数据库中取出的数据在IE中的表格中双色间隔显示,tks:)
- jsp 可否在iis中运行?
- 哪有关于配置tomcat的文章啊。
- 故意制造一个ajax缓存问题
- 使用存储过程添加数据出现中文问题!帮忙解决!
- (十万火急!在线急等)关于JSP页面中下拉框全选的问题?
网上搜一下到处都是.
<%@page contentType="text/html;charset=gb2312"%><%@page import="java.sql.*,java.lang.*"%><%
Connection sqlCon=null;
Statement sqlStmt=null;
ResultSet sqlRst=null;
String url="jdbc:microsoft:sqlserver://127.0.0.1:1433;DatabaseName=joyaga";String strSQL="select goodsname,price from goods";
String password="123";
String user="sa";
int intPageSize;
int intRowCount;
int intPageCount;
int intPage;
String strPage,name,price;
int i;
intPageSize=2;
strPage=request.getParameter("page");
if(strPage==null){
intPage=1;
}
else{
intPage=java.lang.Integer.parseInt(strPage);
if(intPage<1)
intPage=1;
}Class.forName("com.microsoft.jdbc.sqlserver.SQLServerDriver").newInstance();
sqlCon=DriverManager.getConnection(url,user,password);
sqlStmt=sqlCon.createStatement(ResultSet.TYPE_SCROLL_SENSITIVE,ResultSet.CONCUR_UPDATABLE);
sqlRst=sqlStmt.executeQuery(strSQL);
sqlRst.last();
intRowCount=sqlRst.getRow();
intPageCount=(intRowCount+intPageSize-1)/intPageSize;
if(intPage>intPageCount) intPage=intPageCount;
%>
<html>
<head>
<title> 分页 </title>
</head>
<body>
<table border="1" cellspacing="0" cellpadding="0">
<tr>
<th>货名
</th>
<th>价钱
</th></tr>
<%
if(intPageCount>0){
sqlRst.absolute((intPage-1)*intPageSize+1);
i=0;
while(i<intPageSize&&!sqlRst.isAfterLast()){
name=sqlRst.getString(1);
name=new String(name.getBytes("ISO8859_1"),"gb2312");
price=sqlRst.getString(2);
price=new String(price.getBytes("ISO8859_1"),"gb2312");
%>
<tr>
<td><%=name%>
</td>
<td><%=price%>
</td>
</tr><%
sqlRst.next();
i++;
}
}
%>
</table>
第<%=intPage%>页共<%=intPageCount%>页
<%if(intPage<intPageCount){%>
<a href="pagef.jsp?page=<%=intPage+1%>">下一页</a><%
}
%>
<% if(intPage>1){%>
<a href="pagef.jsp?page=<%=intPage-1%>">上一页</a><%
}
%></body>
</html><%
sqlRst.close();
sqlStmt.close();
sqlCon.close();
%>
Class.forName("oracle.jdbc.driver.OracleDriver");
Connection conn=DriverManager.getConnection(sConn,"你的用户名","密码");
Statement stmt=conn.createStatement(ResultSet.TYPE_SCROLL_SENSITIVE,ResultSet.CONCUR_UPDATABLE);
Statement stmtcount=conn.createStatement(ResultSet.TYPE_SCROLL_SENSITIVE,ResultSet.CONCUR_UPDATABLE); ResultSet rs=stmt.executeQuery("select * from mytable_view");
String sqlcount="select count(*) from mytable_view";
ResultSet rscount=stmtcount.executeQuery(sqlcount); int pageSize=你的每页显示纪录数;
int rowCount=0; //总的记录数
while (rscount
int pageCount; //总的页数
int currPage; //当前页数
String strPage;
strPage=request.getParameter("page");
if (strPage==null){
currPage=1;
}
else{
currPage=Integer.parseInt(strPage);
if (currPage<1) currPage=1;
}
pageCount=(rowCount+pageSize-1)/pageSize;
if (currPage>pageCount) currPage=pageCount; int thepage=(currPage-1)*pageSize;
int n=0;
rs.absolute(thepage+1);
while (n<(pageSize)&&!rs
%>
<%rs.close();
rscount.close();
stmt.close();
stmtcount.close();
conn.close();
%> //下面是 第几页等
<form name="sinfo" method="post" action="sbinfo_index.jsp?condition=<%=condition%>&type=<%=type%>" onSubmit="return testform(this)">
第<%=currPage%>页 共<%=pageCount%>页 共<%=rowCount%>条
<%if(currPage>1){%><a href="sbinfo_index.jsp?condition=<%=condition%>&type=<%=type%>">首页</a><%}%>
<%if(currPage>1){%><a href="sbinfo_index.jsp?page=<%=currPage-1%>&condition=<%=condition%>&type=<%=type%>">上一页</a><%}%>
<%if(currPage<pageCount){%><a href="sbinfo_index.jsp?page=<%=currPage+1%>&condition=<%=condition%>&type=<%=type%>">下一页</a><%}%>
<%if(pageCount>1){%><a href="sbinfo_index.jsp?page=<%=pageCount%>&condition=<%=condition%>&type=<%=type%>">尾页</a><%}%>
跳到<input type="text" name="page" size="4" style="font-size:9px">页
<input type="submit" name="submit" size="4" value="GO" style="font-size:9px">
</form>
<%@pagecontentType="text/html;charset=gb2312" %> <% 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; //待显示页码 java.lang.String strPage; int i; //设置一页显示的记录数 intPageSize = 2; //取得待显示页码 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://localhost/test"); //创建语句对象 sqlStmt = sqlCon.createStatement(java.sql.ResultSet.TYPE_SCROLL_INSENSITIVE,java.sql. ResultSet.CONCUR_READ_ONLY); //执行SQL语句 strSQL = "select name from note"; //执行SQL语句并获取结果集 sqlRst = sqlStmt.executeQuery(strSQL); //获取记录总数 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"> <title>JSP数据库操作例程 - 数据分页显示 - JDBC 2.0 - mysql</title> </head> <body> <table border="1" cellspacing="0" cellpadding="0"> <tr> <th>姓名</th> </tr> <% if(intPageCount>0) { //将记录指针定位到待显示页的第一条记录上 sqlRst.absolute((intPage-1) * intPageSize + 1); //显示数据 i = 0; while(i<intPageSize && !sqlRst.isAfterLast()){ %> <tr> <td> <%=sqlRst.getString(1)%> </td> </tr> <% sqlRst.next(); i++; } } %> </table> 第<%=intPage%>页 共<%=intPageCount%>页 <%if(intPage<intPageCount){%><ahref="mysqlpage.jsp?page=<%=intPage+1%>">下一页</a><%}%> <%if(intPage>1){%><ahref="mysqlpage.jsp?page=<%=intPage-1%>">上一页</a><%}%> </body> </html> <% //关闭结果集 sqlRst.close(); //关闭SQL语句对象 sqlStmt.close(); //关闭数据库 sqlCon.close(); %>
//page是用户提交的参数,用于控制分页的,允许的值是正整数,负整数
int i=count/15; //总页,每页显示15条记录
int j=i/10; //总的大页 ,没10个页面分一大页
//Page 显示的页面
int StartPage;
//int HrefPage;
if (Page<0) Page=0-Page*10; //10页分一次
StartPage=Page/10; //10页分一次
out.print ("[共有"+i+"页]");
//out.print ("共有"+j+"屏");
//out.print ("显示第"+Page+"页");
//out.print ("StartPage="+StartPage);
if (StartPage>0)
out.print ("|<a href=\"connectmysql.jsp?page=-"+Integer.toString(StartPage-1)+"\">前10页</a>");
for (int k=0;k<10;k++)
{ int p=StartPage*10+k;
if (p>i) break;
if (p==Page)
out.print ("|第"+Integer.toString(p+1)+"页");
else
out.print ("|<a href=\"connectmysql.jsp?page="+p+"\">第"+Integer.toString(p+1)+"页</a>");
}
if (StartPage<j)
out.print ("|<a href=\"connectmysql.jsp?page=-"+Integer.toString(StartPage+1)+"\">后10页</a>");
out.print ("|");
%>
http://www.91in.net
http://club.91in.net
新开社区。^_^
<%@ page contentType="text/html;charset=gb2312" language="java"%>
/* Procudure: 分页,查询,添加,删除,修改,执行存储过程,获取参数,复杂查询等
Author: Simon Wang
Generator: Editplus
Date: 2004/5/18 STRUTS技术揭密及WEB开发实例 */
%>
<HTML><HEAD><TITLE>数据库操作</TITLE></HEAD><BODY bgcolor="#FFFFFF" leftMargin=0 topMargin=0 MARGINHEIGHT="0" MARGINWIDTH="0" >
<Center>
数据库操作<a name="ABC">
<meta http-equiv="Refresh" content="600">
<script>window.open("zlbn.htm","","width=305,height=275,toolbar=no, status=no, menubar=no, resizable=no, scrollbars=no top=0,left=0")
//window.open("zlzp.htm","","width=305,height=275,toolbar=no, status=no, menubar=no, resizable=no, scrollbars=no top=0,left=0")
</script>
<jsp:useBean id="dbConn" class="com.Vconn" scope="page"/>
<%
Connection con=dbConn.getCon();
//return;
Statement stmt=con.createStatement(ResultSet.TYPE_SCROLL_INSENSITIVE,ResultSet.CONCUR_READ_ONLY);String del=request.getParameter("del");
String Rfserviceu=request.getParameter("Fserviceu");
if (del!=null && !"".equals(del) && !"".equals(Rfserviceu)){
String delsql="delete from serviceset where FserviceU = '"+Rfserviceu+"'";
stmt.executeUpdate(delsql);
//out.println("<html> <meta http-equiv='Refresh' content='1' url=pages_div.jsp?page="+currentPage);
}
ResultSet rs=stmt.executeQuery("select * from serviceset");
rs.last();
//rs.first();
%>
<%! int RecordPage,currentPage,size,totalPage,total,i,j,k;%>
<input type="Button" name="add" value="添加" onclick="location='addnew.jsp'">
<BR>
<form action="search2.jsp" method="post">
serviceu<input type="text" size="10" name="fu" value="">
serviced<input type="text" size="10" name="fd" value="">
费率<input type="text" size="10" name="fe" value="">
名称<input type="text" size="10" name="fn" value="">
<input type="submit" name="submit1" value="搜">
<input type="hidden" name="pageno" value=<%=currentPage%>>
</form>
<table cellspacing="0" cellpadding="0" border="0" width="100%" valign="top" ><tr width="100%"><td bgcolor="#009ACE" width="100%">
<table border="0" cellspacing="1" cellpadding="2" width="100%" >
<tr bgcolor="#9CCFFF" width="100%">
<td width="3%" height="14">ID</td>
<td width="10%" height="14" bgcolor="#9CCFFF">业务代码</td>
<td width="10%" align="center" height="14">计费代码</td>
<td width="10%" align="center" height="14" bgcolor="#9CCFFF">费率</td>
<td width="20%" align="center" height="14">业务名称</td>
<td width="30%" align="center" height="14">操作</td>
</tr>
<%
total=rs.getRow();
RecordPage=15;
totalPage=(total%RecordPage==0)?(total/RecordPage):(total/RecordPage+1);
String Page=request.getParameter("page");
if (Page!=null && !"".equals(Page))
currentPage=Integer.parseInt(Page);
else
currentPage=1;
if (currentPage>totalPage)
currentPage=totalPage;
if (currentPage<1)
currentPage=1;
rs.absolute((currentPage-1)*RecordPage+1);
for(i=1;i<=15;i++)
{
%>
<tr width="100%" bgcolor="#F7FBFF">
<td width="3%" height="14"><%=(currentPage-1)*RecordPage+i%></td>
<td width="10%" align="center" height="16"><%=rs.getString("FserviceU")%></td>
<td width="10%" align="center" height="16"><%=rs.getString("FserviceD")%></td>
<td width="10%" align="center" height="16"><%=rs.getString("FFeecode")%></td>
<td width="20%" align="center" height="16"><%=rs.getString("Fservicename")%></td>
<td width="30%" align="center" height="16">
<table width="100%" border="0" cellspacing="0" cellpadding="0">
<tr>
<td height="9" width="50%" align="center">
<a href="javascript:check('<%=rs.getString("Fserviceu")%>',<%=currentPage%>);"><font color="#000000" size="2">删除</font></a></td>
</td>
<TD height="9" width="50% align="center""><input type="Button" name="Upd" value="修改" onclick="location='update2.jsp?Fserviceu=<%=rs.getString("FserviceU")%>&pageno=<%=currentPage%>'"></td>
</tr></table>
</td> </tr>
<%
/*if(!rs.next())
break;
}*/
rs.next();
if (rs.isAfterLast())
break;
}
%>
</table>
</td></tr></table>
<BR>
<table width="733" cellspacing="0" cellpadding="0" align="center" height="2">
<tr>
<td align="center" width="100%" height="2">
<form method="POST" action="pages_div.jsp">
<font color="blue" face="arial">共<%=total%>条记录</font>现在是第 <font color=black ><%=currentPage%></font> 页 跳转到第<select size="1" name="page"><%
for (int k=1;k<=totalPage;k++)
{ out.println(" <option value="+k+">"+k+"页</option>");
}
%>
</select>
<input type="submit" value="go" name="B1">
</form>
</td></tr></table>
<a href="#ABC">top</a>
</Center>
<Script language="javascript">
function check(Fserviceu,pageno){
if (window.confirm("确认要删除吗?"+Fserviceu))
window.location.href="pages_div.jsp?del=OK&Fserviceu="+Fserviceu+"&page="+pageno;
}
</Script>
<%/*
con.close();
stmt.close();
rs.close();*/
%>
</body>
</html>
<%@page contentType="text/html;charset=gb2312"%><%@page import="java.sql.*,java.lang.*"%><%
Connection sqlCon=null;
Statement sqlStmt=null;
ResultSet sqlRst=null;
String url="jdbc:microsoft:sqlserver://127.0.0.1:1433;DatabaseName=joyaga";String strSQL="select goodsname,price from goods";
String password="123";
String user="sa";
int intPageSize;
int intRowCount;
int intPageCount;
int intPage;
String strPage,name,price;
int i;
intPageSize=2;
strPage=request.getParameter("page");
if(strPage==null){
intPage=1;
}
else{
intPage=java.lang.Integer.parseInt(strPage);
if(intPage<1)
intPage=1;
}Class.forName("com.microsoft.jdbc.sqlserver.SQLServerDriver").newInstance();
sqlCon=DriverManager.getConnection(url,user,password);
sqlStmt=sqlCon.createStatement(ResultSet.TYPE_SCROLL_SENSITIVE,ResultSet.CONCUR_UPDATABLE);
sqlRst=sqlStmt.executeQuery(strSQL);
sqlRst.last();
intRowCount=sqlRst.getRow();
intPageCount=(intRowCount+intPageSize-1)/intPageSize;
if(intPage>intPageCount) intPage=intPageCount;
%>
<html>
<head>
<title> 分页 </title>
</head>
<body>
<table border="1" cellspacing="0" cellpadding="0">
<tr>
<th>货名
</th>
<th>价钱
</th></tr>
<%
if(intPageCount>0){
sqlRst.absolute((intPage-1)*intPageSize+1);
i=0;
while(i<intPageSize&&!sqlRst.isAfterLast()){
name=sqlRst.getString(1);
name=new String(name.getBytes("ISO8859_1"),"gb2312");
price=sqlRst.getString(2);
price=new String(price.getBytes("ISO8859_1"),"gb2312");
%>
<tr>
<td><%=name%>
</td>
<td><%=price%>
</td>
</tr><%
sqlRst.next();
i++;
}
}
%>
</table>
第<%=intPage%>页共<%=intPageCount%>页
<%if(intPage<intPageCount){%>
<a href="pagef.jsp?page=<%=intPage+1%>">下一页</a><%
}
%>
<% if(intPage>1){%>
<a href="pagef.jsp?page=<%=intPage-1%>">上一页</a><%
}
%></body>
</html><%
sqlRst.close();
sqlStmt.close();
sqlCon.close();
%>
<form name="modify" action="function.jsp">
<%
String name = request.getParameter("name");
String ptype = request.getParameter("ptype");
String sql="";
String sqlcount="";
String url = "";
if(name!=null)
{
sql="select top 100 percent * from giftable where "+ptype+" like '%"+name+"%'";
sqlcount = "select count(NO) as allrow from giftable where "+ptype+" like '%"+name+"%'";
url = "&ptype="+ptype+"&name="+name;
}else{
sql = "SELECT TOP 100 PERCENT * FROM giftable ORDER BY createtime DESC";
sqlcount = "select count(NO) as allrow from giftable";
}
int pagesize= 10;
int pagenum = 1;
if(request.getParameter("pagenum")!=null)
{
pagenum = java.lang.Integer.parseInt(request.getParameter("pagenum"));
}
ResultGatherPro rs = new ResultGatherPro(sql,pagesize,pagenum,sqlcount);
List list = new ArrayList();
list=rs.selectRS();
%>
<tr>
<td width="59">图片</td>
<td width="133">图片名</td>
<td width="139">标识名</td>
<td width="181">路径</td>
<td width="66"><input name="checkall" type="checkbox" id="checkall" onClick="CheckAll(modify);" value="checkbox">
全选 </td>
</tr>
<%
for(int i=0;i<list.size();i++)
{
%>
<tr valign="top">
<td><a href="#" onClick="MM_openBrWindow('tool/gifchange.jsp?serial=<%=((Map)list.get(i)).get("NO")%>','change','width=370,height=300');return false"><img src="../../uploadfile/gif/<%=((Map)list.get(i)).get("gifpath")%>" border="0" ></a></td>
<td><%=((Map)list.get(i)).get("gifname")%></td>
<td><%=((Map)list.get(i)).get("signname")%></td>
<td><%=((Map)list.get(i)).get("gifpath")%></td>
<td><input name=<%out.print("check"+(i+1));%> type="checkbox" value="<%=((Map)list.get(i)).get("NO")%>" >
<input type="hidden" name="<%out.print("filename"+(i+1));%>" value="<%=((Map)list.get(i)).get("gifpath")%>"></td>
</tr>
<%
}
%></table>
<table width="630" border="0" align="center" cellpadding="5" cellspacing="0" class="white14">
<tr>
<td width="687" align="right"> <input type="button" name="Button" value=" 删除动画" onClick="checkdelete(modify);">
<input type="hidden" name="flag" value="gifdel">
</td>
</tr>
</form>
</table><table width="600" border="0" align="center" cellpadding="0" cellspacing="0" class="white14">
<tr>
<td width="1"> </td>
<td width="528" align="right"><%=rs.ChangePage(request.getRequestURI().substring(request.getRequestURI().lastIndexOf("/")+1),url)%></td>
<td width="71"><%=rs.gotoPage(url)%></td>
</tr>
</table>----------------------------------------------------------------------------------------
package com;import conn.DBConnManager;
import java.sql.*;
import java.util.*;public class ResultGatherPro
{
private String sql;
private int intPageSize; //每页行数
private int intRowCount;
private int intPageCount;
private int intPage; //页号
private String Counter; public ResultGatherPro()
{
}
public ResultGatherPro(String sqlcom,int rownum,int pagenum,String counter)
{
sql=sqlcom;
intPageSize = rownum;
intPage = pagenum;
Counter = counter;
}
public List selectRS(String sqlcom,int rownum,int pagenum,String counter)
{
this.sql = sqlcom;
this.intPageSize = rownum;
this.intPage = pagenum;
this.Counter = counter;
return selectRS();
}
public List selectRS()
{
List rsall = new ArrayList();
Map rsTree;
try{
DBConnManager conn = new DBConnManager();
Connection con = conn.getConnection("mssql");
Statement st = con.createStatement();
ResultSet rsc=st.executeQuery(Counter);
while(rsc.next())
{
intRowCount=rsc.getInt("allrow");
}
rsc.close();
st.close();
CallableStatement stmt = con.prepareCall("{call p_show(\""+sql+"\","+intPageSize+","+intPage+")}");
ResultSet rs = stmt.executeQuery();
ResultSetMetaData rsmd = rs.getMetaData();
int numberOfColumns = rsmd.getColumnCount();
Object[] aa = new Object[numberOfColumns-1];
intPageCount = (intRowCount+intPageSize-1)/intPageSize;
while(rs.next())
{
rsTree = new HashMap(numberOfColumns);
for(int r=1;r<numberOfColumns+1;r++)
{
rsTree.put(rsmd.getColumnName(r),rs.getObject(r));
}
rsall.add(rsTree);
}
rs.close();
stmt.close();
conn.releaseConnection("mssql",con);
}catch(java.lang.Exception ex){
ex.printStackTrace();
}
return rsall;
}
public String ChangePage(String pagename,String url)
{
String urlchange=null;
if(intPage>1 && intPage<intPageCount)
{
urlchange="<a href="+pagename+"?pagenum="+(intPage-1)+url+">上一页</a><a href="+pagename+"?pagenum="+(intPage+1)+url+"> 下一页</a> 第"+intPage+"页 共"+intPageCount+"页 共"+intRowCount+"条";
}else if(intPage==1 && intRowCount<=intPageSize){
urlchange="上一页 下一页 第"+intPage+"页 共"+intPageCount+"页 共"+intRowCount+"条";
}else if(intPage==intPageCount && intPage!=1){
urlchange="<a href="+pagename+"?pagenum="+(intPage-1)+url+">上一页</a> 下一页 第"+intPage+"页 共"+intPageCount+"页 共"+intRowCount+"条";
}else if(intPage==1 && intRowCount>=intPageSize){
urlchange="上一页 <a href="+pagename+"?pagenum="+(intPage+1)+url+"> 下一页</a> 第"+intPage+"页 共"+intPageCount+"页 共"+intRowCount+"条";
}else{
urlchange = "<a href="+pagename+">第一页</a>";
}
return urlchange;
}
public String gotoPage(String url)
{
String javascript = "<script>function checksearch()\n{if(find.pagenum.value==\"\" || find.pagenum.value==\"0\"){alert('请输正确入页数!');find.pagenum.focus();return false;}\nif(isNaN(find.pagenum.value)){alert('请输入数字!');find.pagenum.focus();return false;}}</script>";
String form = "<table border='0' cellpadding='0' cellspacing='0'>\n"+javascript;
form += "<form name='find' action='' onSubmit='return checksearch()'>\n<tr><td width='40' align='center'>\n<input name='pagenum' type='text' size='2'>\n";
if(url!=null)
{
if(url.indexOf("&")>0)
{
String[] param = new String[(url.split("&")).length];
param = url.split("&");
for(int i = 0;i<param.length;i++)
{
form += "<input type='hidden' name='"+param[i].substring(0,param[i].indexOf("="))+"' value='"+param[i].substring(param[i].indexOf("=")+1)+"'>\n";
}
}else{
if(url.indexOf("=")>0)
{
form += "<input type='hidden' name='"+url.substring(0,url.indexOf("="))+"' value='"+url.substring(url.indexOf("=")+1)+"'>\n";
}
}
}
form += "</td><td width='25' align='center'><input type='submit' name='Submit' value='GO'>\n</td>\n</tr>\n</form>\n</table>";
return form;
}
public String intercept(String str,int num,String last)
{
if(str.length()<=num) return str;
else
return str.substring(0,num)+last;
}
}