if(intPage<intPageCount){%>
<a href="ods.jsp?page=<%=intPage+1%>&serialnum="+serial+"&Comsat="Submit"">=></a><%
}%>
<%if(intPage>1){%>
<a href="ods.jsp?page=<%=intPage-1%>&serialnum="+serial+"&Comsat="Submit""><=</a><%
}
%>
问题在这里！！！
<a href="ods.jsp?page=<%=intPage+1%>&serialnum="+serial+"&Comsat="Submit"">=></a><%
}%>
<%if(intPage>1){%>
<a href="ods.jsp?page=<%=intPage-1%>&serialnum="+serial+"&Comsat="Submit""><=</a><%
}
%>
问题在这里！！！
可以的话请给我一个实例好吗?
不用再传serialnum变量了
慧聪聘高级 系统网络工程师 ava高级程序员 DBA资深工程师 深思2005 回交解决方
泛微协同OA 免费下载！ 【活动】注册VIC 中文技术支持得 Cell组件 表完美案
【活动】Ja Cup大学生信息 技术大奖赛 JAVA报表开发工具 年费制的 间件使用方
泛微协同OA 免费下载！ 【活动】注册VIC 中文技术支持得 Cell组件 表完美案
【活动】Ja Cup大学生信息 技术大奖赛 JAVA报表开发工具 年费制的 间件使用方
泛微协同OA 免费下载！ 【活动】注册VIC 中文技术支持得 Cell组件 表完美案
【活动】Ja Cup大学生信息 技术大奖赛 JAVA报表开发工具 年费制的 间件使用方而且都是读同一个表里的同一个字段里.还有一个就是所有数据都带一个相应的连接...
如果可以的话请给完整的BEAN的源码我去学习学习..谢谢.
<%@ page import = "system.gr.pk.IBSLszTools.*" %>
<%@ page import = "system.gr.pk.bank.*" %>
<%@ page import = "system.gr.pk.TradeCode.*" %>
<%@ page import = "java.util.*" %>
<html>
<head>
<script language="JavaScript">
<!-- Begin
function scrollit() {
for (I=1; I<=7500; I++){
parent.scroll(1,I)
}
}function scrollit1() {
for (I=750; I>1; I=I-1){
parent.scroll(1,I)
}
}
// End -->
</script>
<link href="/css/hunan.css" rel="stylesheet" type="text/css">
<title>后台管理系统</title>
<meta http-equiv="Content-Type" content="text/html; charset=gb2312">
<script language="JavaScript" type="text/JavaScript">
<!--
function isCharsInBag (s, bag)
{
var i,c;
for (i = 0; i < s.length; i++)
{
c = s.charAt(i);//字符串s中的字符
if (bag.indexOf(c) > -1)
return c;
}
return "";
}
function QueryPage(thisform){
var st = form1.Query_Page.value;
var errorChar;
var report;
var badChar = "0123456789";
errorChar = isCharsInBag( st, badChar)
if (errorChar == "" ){
alert("请输入合法的数字\n");
form1.Query_Page.value="";
return ;
}
else
// window.open('1_1_0_2.jsp?Query_Page='+st);
location = "Sel_Vo_B2BList.jsp?Query_Page="+st;
}
function del(pkey,yshStart,yshEnd){
var st = confirm("确定要删除吗???");
if(st != 0){
location = "delcard.jsp?pkey="+pkey+"&yshStart="+yshStart+"&yshEnd="+yshEnd;
}
}
function doPrint(){
var str="<html>";
var article;
var css;
var strAdBegin="<!--NEWSZW_HZH_BEGIN-->";
var strAdEnd="<!--NEWSZW_HZH_END-->";
var strFontSize='【<A href="javascript:doZoom(16)">大</A> <A href="javascript:doZoom(14)">中</A> <A href="javascript:doZoom(12)">小</A>】'
var strdoPrint="doPrint()";
var strTmp;
css="<style>"
+"body{font-family:宋体}"
+"td,.f12{font-size:12px}"
+".f24 {font-size:24px;}"
+".f14 {font-size:14px;}"
+".title14 {font-size:14px;line-height:130%}"
+".l17 {line-height:170%;}"
+"</style>";
str += css;
str += '<meta http-equiv="content-type" content="text/html; charset=gb2312">';
str += '<title>'+document.title+'</title>';
str += "<body bgcolor=#ffffff topmargin=5 leftmargin=5 marginheight=5 marginwidth=5 onLoad='window.print()'>";
str += "<center><table width=800 border=0 cellspacing=0 cellpadding=0><tr><td height=34 width=150><a href='javascript:history.back()'>返回</a> <a href='javascript:window.print()'>打印</a></td></tr></table>";
str += "<table width=800 border=0 cellpadding=0 cellspacing=20 bgcolor=#EDF0F5><tr><td>";
article=document.getElementById('article').innerHTML;
if(article.indexOf(strAdBegin)!=-1){
str +=article.substr(0,article.indexOf(strAdBegin));
strTmp=article.substr(article.indexOf(strAdEnd)+strAdEnd.length, article.length);
}else{
strTmp=article
}
str +=strTmp
str += window.location.href
str += "</td></tr></table></center>";
str += "</body></html>";
document.write(str);
document.close(); }
//-->
</script>
<style type="text/css">
<!--
.style1 {color: #3366FF}
.style2 {color: #FF0000}
-->
</style>
</head>
<jsp:useBean id = "Pobean"scope="session" class = "system.pub.jsp.Pobean"/>
<jsp:useBean id="PageCt" scope="page" class="system.pub.jsp.Gr_Find" />
<body bgcolor="#EFFAFE" leftmargin="0" topmargin="0" marginwidth="0" marginheight="0" onload='clearInterval(timer);Loading.style.display="none";'>
<div id="Loading" style="position:absolute;width:100%; height:100%;z-index:100;background:"#9999FF";"><div id="Waiting" style="position:absolute;left:40%;top:50%;"></div></div>
<script>var text="请您稍等,服务器正在生成数据";i=0;function load() {if (i<6) {text+=".";Waiting.innerText=text;i++;}else {text="请您稍等,服务器正在生成数据";i=0;}}timer=window.setInterval("load()",300);</script>
<table width="100%" height="100%" border="0" cellpadding="0" cellspacing="0">
<tr align="center" valign="top">
<td height="86"><%@ include file="/inc/top.htm" %></td>
</tr>
<tr>
<td height="100%" align="left" valign="top" bgcolor="#9FD7FF"><table width="100%" height="100%" border="0" cellpadding="0" cellspacing="1">
<tr>
<td width="0" height="100%" align="left" valign="top"></td>
<td align="left" valign="top" bgcolor="#FFFFFF">
<table width="100%" border="0" cellspacing="0" cellpadding="0">
<tr>
<td height="30" align="right" valign="middle"><table width="90%" border="0" cellpadding="0" cellspacing="0">
<tr>
<td align="left" valign="middle"><font color="#0000FF">
<%@ include file="/inc/code.jsp" %>
</font></td>
<td height="40" align="right" valign="middle">【<A href="javascript:doPrint()">打印</A>】<font color="#0000FF">所处位置：<a href="/welcome.jsp" class=blue5>首页</a> > 统计查询 > <a href="../welcome.jsp"><font color="#0000FF">交易流水查询</font></a> <span class="style3">></span> </font><span class="style1 style2">B2B交易流水查询 </span><font color="#0000FF">> <a href="javascript:history.go(-1)" class=green1>返回</a> </font></td>
</tr>
</table>
</td>
</tr>
<tr>
<td height="25"> </td>
</tr>
<tr>
<td align="center" valign="middle"><form name="form1" method="post" action="">
<input type="hidden" name = "scount" value="">
<table width="95%" border="0" cellpadding="0" cellspacing="0">
<tr bgcolor="#E8E8E8">
<td width="10" height="20" ><img src="/images/biaotibg_left.gif"></td>
<td height="20" align="left" valign="middle" background="/images/biaotibg_center.gif" class="big2"><div align="center">B2B交易流水查询</div></td>
<td width="10" height="20"><img src="/images/biaotibg_right.gif"></td>
</tr></table>
<br>
<table width="95%" border="0" cellspacing="0" cellpadding="0">
<tr>
<td bgcolor="#666666">
<div id="article">
<table width="100%" border="1" align="center" cellpadding="0" cellspacing="1" bordercolor="#99CCFF">
<tr bgcolor="#99FFFF">
<td align="center" bgcolor="#99CCFF"><span class="style1">客户号</span></td>
<td align="center" bgcolor="#99CCFF"><span class="style1">交易名称</span></td>
<td align="center" bgcolor="#99CCFF"><span class="style1">网银凭证号</span></td>
<td align="center" bgcolor="#99CCFF"><span class="style1">帐号1</span></td>
<td align="center" bgcolor="#99CCFF"><span class="style1">帐号2</span></td>
<td align="center" bgcolor="#99CCFF"><span class="style1">发生额</span></td>
<td align="center" bgcolor="#99CCFF"><span class="style1">手续费</span></td>
<td align="center" bgcolor="#99CCFF"><span class="style1">付款单位名称</span></td>
<td align="center" bgcolor="#99CCFF"><span class="style1">收款单位名称</span></td>
<td align="center" bgcolor="#99CCFF"><span class="style1">开户机构名称1</span></td>
<td align="center" bgcolor="#99CCFF"><span class="style1">开户机构名称2</span></td>
<td align="center" bgcolor="#99CCFF"><span class="style1">交易日期</span></td>
<td align="center" bgcolor="#99CCFF"><span class="style1">交易时间</span></td>
<td align="center" bgcolor="#99CCFF"><span class="style1">成功标志</span></td>
</tr>
<%
String sc="",scount="";
String khh = "";
String jym = "";
String wyjyrq = "";
String jysj = "";
String wypzh = "";
String zh1 = "";
String zh2 = "";
String fse = "";
String sxf = "";
String fkdwmc = "";
String skdwmc = "";
String khjgbm1 = "";
String khjgbm2 = "";
String jymc = "";
String cgbz = "";
String post_code = "",clerk_post="",re = "";
scount = (String)request.getParameter("sql");
System.out.println("scount=="+scount);
Hashtable Vobank = new Hashtable();
if(scount==null||scount.equals("")){
scount = Pobean.get_scount();
}
else
Pobean.set_scount(scount);
IBSLszList Dumy = new IBSLszList();
//TradeCodeList tradeCodeList = new TradeCodeList();
b2bList Dumy1 = new b2bList();
TradeCodeList tradeCodeList = new TradeCodeList();
Vector enuntvv = Dumy.getList(scount);
//Enumeration enunt = Dumy.getList(scount);
IBSLsz com = null;
long data_num=0;
data_num = enuntvv.size();
Enumeration enunt = enuntvv.elements();
/*
while(enunt.hasMoreElements()){
com=(IBSLsz)enunt.nextElement();
data_num++;
}
*/
long Current_Page = 0;
String currentpage=(String)request.getParameter("currentpage");
if (currentpage != null && !currentpage.equals(""))
{
Current_Page = Integer.parseInt(request.getParameter("currentpage"));
}
String Query_Page=(String)request.getParameter("Query_Page");
if (Query_Page!=null && !Query_Page.equals(""))
{
Current_Page = Integer.parseInt(request.getParameter("Query_Page"))-1;
}
PageCt.Init(Current_Page,data_num);
long l_start = PageCt.getStart();
long l_end = PageCt.getEnd();
int iT = 0;
//Enumeration enunt1 = Dumy.getList(scount);
IBSLsz com1 = null;
long i=0;
while((i<l_start)&&enunt.hasMoreElements()){
com1=(IBSLsz)enunt.nextElement();
i++;
}
long j =0;
Vector vv = new Vector();
vv = (Vector)tradeCodeList.getVList();
while(enunt.hasMoreElements()&&(i<l_end)){
com1=(IBSLsz)enunt.nextElement();
j=i+1;
khh = com1.getKhh();
jym = com1.getJym().trim();
//jymc = tradeCodeList.getJYMC(jym);
wyjyrq = com1.getWyjyrq();
jysj = com1.getJysj();
wypzh = com1.getWypzh();
zh1 = com1.getZh1();
//klxname = Dumy.getcardtypename(klx);
zh2 = com1.getZh2();
//jgmc = Dumy1.getjgmc(lyjgbm);
fse = com1.getFse();
sxf = com1.getSxf();
fkdwmc = com1.getFkdwmc();
skdwmc = com1.getSkdwmc();
khjgbm1 = com1.getKhjgbm1();
khjgbm2 = com1.getKhjgbm2();
cgbz = com1.getCgbz().trim();
%>
<tr>
<td height="25" align="center" bgcolor="#E8E8E8"><%
if(khh.equals(""))out.print(" ");
else out.print(khh);
%></td>
<td height="25" align="center" bgcolor="#E8E8E8">
<%
for(int k=0;k<vv.size();k++){
TradeCode tc= null;
tc = (TradeCode)vv.get(k);
if(tc.getJym().equals(jym)){
jymc = tc.getJymc();
}
}
if(jymc.equals("")){out.print("未知交易名称("+jym+")");}
else out.print(jymc);
%>
</td>
<td height="25" align="center" bgcolor="#E8E8E8"><%=wypzh%></td>
<td height="25" align="center" bgcolor="#E8E8E8"><%=zh1%></td>
<td height="25" align="center" bgcolor="#E8E8E8"><%=zh2%></td>
<td height="25" align="center" bgcolor="#E8E8E8"><%=fse%></td>
<td height="25" align="center" bgcolor="#E8E8E8"><%=sxf%></td>
<td height="25" align="center" bgcolor="#E8E8E8"><%=fkdwmc%></td>
<td height="25" align="center" bgcolor="#E8E8E8"><%=skdwmc%></td>
<td height="25" align="center" bgcolor="#E8E8E8"><%=khjgbm1%></td>
<td height="25" align="center" bgcolor="#E8E8E8"><%=khjgbm2%></td>
<td height="25" align="center" bgcolor="#E8E8E8"><%=wyjyrq%></td>
<td height="25" align="center" bgcolor="#E8E8E8"><%=jysj%></td>
<td height="25" align="center" bgcolor="#E8E8E8">
<%
if(cgbz.equals("4"))out.print("成功");
else out.print("失败");
%></td>
</tr>
<%i++;}%>
</table>
</div>
<!--NEWSZW_HZH_END-->
</td>
</tr>
</table><br>
<table width=90% align="center" class="nprint">
<tr bgcolor=#FFFFFF>
<td align=center valign=bottom ><font color="#000000">共</font>
<font color="#000000"><%=PageCt.getTotalnum()%> 条 </font><font color="#000000"><%=PageCt.getCurpage()+1%>/<%=PageCt.getTotalpage()%> 页 </font><font color="#000000">查看第(页)</font>
<font color="#000000"><input type="text" name="Query_Page" size=3><a href="javascript:QueryPage(this);"style="text-decoration:none;" color="#FFFF66">查询 </a></font>
<%if((PageCt.getCurpage()+1)>1){%>
<a href=Sel_Vo_B2BList.jsp?currentpage=<%=PageCt.getPrepage()%>><font color="#000000"style="text-decoration:none;">上页</font></a>
<%}%>
<%if((PageCt.getCurpage()+1)< PageCt.getTotalpage()){%>
<a href=Sel_Vo_B2BList.jsp?currentpage=<%=PageCt.getNextpage()%>><font color="#000000"style="text-decoration:none;">下页</font></a>
<%}%>
</td>
</table>
</form></td>
</tr>
</table></td>
</tr>
</table></td>
</tr>
<tr>
<td height="32" align="center" valign="middle" background="/images/bottom_bg2.gif"> </td>
</tr>
</table>
</body>
</html>
代码：package system.pub.jsp;import java.util.Vector;/**
*
* 创建日期：(2003-07-12)
*
*
*/
public class Pobean {
static String sql = ""; static String scount = ""; static String khh = ""; static String qyqsrq = ""; static String qyzzrq = "";
public void set_sql(String sqlt) {
sql = sqlt; } public void set_scount(String scountt) {
scount = scountt; } public String get_sql() {
return sql;
} public String get_scount() {
return scount;
} /**
* @return Returns the khh.
*/
public String getKhh() {
return khh;
} /**
* @param khh
* The khh to set.
*/
public void setKhh(String khh) {
Pobean.khh = khh;
} /**
* @return Returns the qyqsrq.
*/
public String getQyqsrq() {
return qyqsrq;
} /**
* @param qyqsrq
* The qyqsrq to set.
*/
public void setQyqsrq(String qyqsrq) {
Pobean.qyqsrq = qyqsrq;
} /**
* @return Returns the qyzzrq.
*/
public String getQyzzrq() {
return qyzzrq;
} /**
* @param qyzzrq
* The qyzzrq to set.
*/
public void setQyzzrq(String qyzzrq) {
Pobean.qyzzrq = qyzzrq;
}
}Gr_find:分页：package system.pub.jsp;/**
* 处理分页程序。处理统计查询所用
* 创建日期：(2003-07-00)
*
*/
public class Gr_Find
{
private long l_start; //开始纪录
private long l_end; //结束纪录
private long l_curpage; //当前页数
private long l_totalnum;//总记录数
private int int_num=100; //每页50000条
private long l_totalpage; //总的页数 public void Init(long currentpage,long totalnum)
{
l_curpage = currentpage;
l_totalnum = totalnum; if (currentpage>=0)
{
if (currentpage>=(long)Math.ceil((double)l_totalnum/(double)int_num))
l_curpage = (long)Math.floor((double)l_totalnum/(double)int_num);
else
l_curpage = currentpage;
}
else
{
l_curpage = 0;
} l_start = l_curpage * int_num;
l_end = l_start + int_num; if (l_end > l_totalnum)
l_end = l_totalnum; l_totalpage = (long)Math.ceil((double)l_totalnum/(double)int_num); } public long getCurpage()
{
return l_curpage;
}
public long getPrepage()
{
if (l_curpage-1>=0)
{
return l_curpage-1;
}
else
{
return 0;
}
}
public long getNextpage()
{
if (l_curpage+1<=l_totalpage)
{
return l_curpage+1;
}
else
{
return l_totalpage;
}
}
public long getTotalnum()
{
return l_totalnum;
}
public long getTotalpage()
{
return l_totalpage;
}
public long getStart()
{
return l_start;
}
public long getEnd()
{
return l_end;
}}其余你替换一下就可以，另外还提供了div显示数据正在生成，请等待的方法，还有提供用户打印的方法，这是我做的，都没问题，你只要替换以下肯定可以用
String sql = "select top 10 xxmc,xxlsh,xxwz from xt_txxx where ztbz = '1' and xxxm = '0102' order by xxrq desc ,czsj desc";
这条语句就可以啊??