//控制翻页的帮助类PageHelper.java
/*****************************************/
package com.broha.common;
/**
* @version 1.0
*/
/**
* 控制翻页的帮助类。
*
*
*/
public class PageHelper
{
/**
* 当前页面的页号
*/
private int currPageNo = 1;
/**
* 翻页操作
*/
private String action = "first";
/**
* 是否第一页
*/
private boolean isFirstPage = true;;
/**
* 是否最后一页
*/
private boolean isLastPage = true;
/**
* 每页中的行数
*/
private int linesPerPage = 10;
/**
* 总行数
*/
private int totalLines = 1;
/**
* 总页数
*/
private int totalPages = 1;
/**
* 当前页的起始行号
*/
private int lineFrom = 1;
/**
* 当前页的终止行号
*/
private int lineTo = 1;
private void refresh() {
totalPages = ( totalLines % linesPerPage > 0 ) ? ( totalLines / linesPerPage + 1 ) : ( totalLines / linesPerPage );
if ( action.equalsIgnoreCase( "first" ) ) {
currPageNo = 1;
} else if ( action.equalsIgnoreCase( "last" ) ) {
currPageNo = totalPages;
} else if ( action.equalsIgnoreCase( "next" ) ) {
currPageNo++;
} else if ( action.equalsIgnoreCase( "previous" ) ) {
currPageNo--;
} else if ( action.equalsIgnoreCase( "current" )){
if (this.currPageNo > totalPages )
currPageNo = totalPages;
if (this.currPageNo < 1)
currPageNo = 1;
}
isFirstPage = ( currPageNo <= 1 ) ? true : false;
isLastPage = ( currPageNo >= totalPages ) ? true : false;
if(isFirstPage)
currPageNo=1;
if(isLastPage)
currPageNo=totalPages;
lineFrom = ( currPageNo - 1 ) * linesPerPage + 1;
lineTo = lineFrom + linesPerPage - 1;
if (lineTo > totalLines) {
lineTo = totalLines;
}
if(lineFrom<1)
lineFrom=1;
action = "current";
}
/**
* 获得当前页数。
*/
public int getCurrPageNo()
{
return currPageNo;
}
/**
* 设置当前页数。
*/
public void setCurrPageNo(int aCurrPageNo)
{
currPageNo = aCurrPageNo;
}
/**
* 获得翻页操作
*/
public String getAction()
{
return action;
}
/**
* 设置翻页操作。
*
* "first" － 第一页
* "last" － 最后一页
* "next" － 下一页
* "previous" － 上一页
* "jump" － 跳到指定的页
*/
public void setAction(String aAction)
{
action = aAction;
}
/**
* 是否第一页。
*/
public boolean getIsFirstPage()
{
return isFirstPage;
}
/**
*设置是否第一页。
*/
public void setIsFirstPage(boolean aIsFirstPage)
{
isFirstPage = aIsFirstPage;
}
/**
* 是否最后一页。
*/
public boolean getIsLastPage()
{
return isLastPage;
}
/**
* 设置是否最后一页。
*/
public void setIsLastPage(boolean aIsLastPage)
{
isLastPage = aIsLastPage;
}
/**
* 获得每页显示纪录的行数。
*/
public int getLinesPerPage()
{
return linesPerPage;
}
/**
* 设置每页显示纪录的行数。
*/
public void setLinesPerPage(int aLinesPerPage)
{
linesPerPage = aLinesPerPage;
}
/**
* 获得总记录数。
*/
public int getTotalLines()
{
return totalLines;
}
/**
* 设置总记录数。
*/
public void setTotalLines(int aTotalLines)
{
totalLines = aTotalLines;
refresh();
}
/**
* 获得总页数。
*/
public int getTotalPages()
{
return totalPages;
}
/**
* 设置总页数。
*/
public void setTotalPages(int aTotalPages)
{
totalPages = aTotalPages;
}
/**
* 获得当前页的起始记录行号
*/
public int getLineFrom()
{
return lineFrom;
}
/**
* 设置当前页的起始纪录行号。
*/
public void setLineFrom(int aLineFrom)
{
lineFrom = aLineFrom;
}
/**
* 获得当前页的终止纪录行号。
*/
public int getLineTo()
{
return lineTo;
}
/**
* 设置当前页的终止纪录行号。
*/
public void setLineTo(int aLineTo)
{
lineTo = aLineTo;
}
public String toString(){
return "\r\n currPageNo : " + this.currPageNo +
"\r\n totalLines : " + this.totalLines +
"\r\n totalPages : " + this.totalPages +
"\r\n linesPerPage : " + this.linesPerPage +
"\r\n isFirstPage : " + this.isFirstPage +
"\r\n isLastPage : " + this.isLastPage +
"\r\n lineFrom : " + this.lineFrom +
"\r\n lineTo : " + this.lineTo +
"\r\n action : " + this.action;
}
}
/*****************************************/
在Form中声明此类的对象
private PageHelper pageHelper = new PageHelper(); //翻页帮助类
然后在DAO中调用该类的方法：
/*****************************************************/
/*
* 创建日期 2007-8-30
* @author guozk
* TODO 要更改此生成的文件的模板，请转至
* 窗口 － 首选项 － Java － 代码样式 － 代码模板
*/
package com.broha.platform.cxtx.xmgl.myipsa.dao;
import java.sql.ResultSet;
import java.util.ArrayList;
import sun.jdbc.rowset.CachedRowSet;
import com.broha.common.Constants;
import com.broha.common.DBSuper;
import com.broha.common.PageHelper;
import com.broha.common.Pub;
import com.broha.common.SelectOptions;
import com.broha.platform.cxtx.xmgl.myipsa.bean.IpsaData;
import com.broha.platform.cxtx.xmgl.myipsa.forms.IpsaForm;
/**
* @author Administrator
* @date 2007-8-30
* TODO 要更改此生成的类型注释的模板，请转至
* 窗口 － 首选项 － Java － 代码样式 － 代码模板
*/
public class IpsaDAO {
private String sqlMsg = "";
private String errLog = "";
private int sqlCode = Constants.SQLCODE_INIT;
private void initSqlCode() {
sqlCode = Constants.SQLCODE_INIT;
}
/**
* @return 返回 sqlCode。
*/
public int getSqlCode() {
return sqlCode;
}
/**
* @return 返回 sqlMsg。
*/
public String getSqlMsg() {
return sqlMsg;
}
//查询
public ArrayList slIpsa(DBSuper dbs, IpsaForm form) throws Exception{
ArrayList al = new ArrayList();
String condition = "";
String sql = "";
CachedRowSet rs = null;
int totalNum = 0;
try{
//查询条件开始
condition = Pub.addStrSql("", form.getIpsainnu(),condition, "IPSAINNU");
condition = Pub.addLksSql("", form.getIpsameac(),condition, "IPSAMEAC");
condition = Pub.addLksSql("", form.getIpsacuno(),condition, "IPSACUNO");
condition = Pub.addLksSql("", form.getIpsaprja(),condition, "IPSAPRJA");
condition = Pub.addLksSql("", form.getIpsatpsd(),condition, "IPSATPSD");
condition = Pub.addLksSql("", form.getIpsaartc(),condition, "IPSAARTC");
condition = Pub.addStrSql("", "02",condition, "IPSATPPF");
condition = Pub.addLksSql("", form.getIpsascpj(),condition, "IPSASCPJ");
condition = Pub.addLksSql("", form.getIpsaelvp(),condition, "IPSAELVP");
condition = Pub.addLksSql("", form.getIpsalpjc(),condition, "IPSALPJC");
condition = Pub.addLksSql("", form.getIpsaacrd(),condition, "IPSAACRD");
condition = Pub.addLksSql("", form.getIpsaglpj(),condition, "IPSAGLPJ");
condition = Pub.addLksSql("", form.getIpsaowpj(),condition, "IPSAOWPJ");
condition = Pub.addLksSql("", form.getIpsaowcn(),condition, "IPSAOWCN");
condition = Pub.addLksSql("", form.getIpsacttl(),condition, "IPSACTTL");
condition = Pub.addLksSql("", form.getIpsapctp(),condition, "IPSAPCTP");
condition = Pub.addLksSql("", form.getIpsasctp(),condition, "IPSASCTP");
condition = Pub.addLksSql("", form.getIpsatchp(),condition, "IPSATCHP");
condition = Pub.addLksSql("", form.getIpsatcdp(),condition, "IPSATCDP");
condition = Pub.addLksSql("", form.getIpsaprhp(),condition, "IPSAPRHP");
condition = Pub.addLksSql("", form.getIpsaprdp(),condition, "IPSAPRDP");
condition = Pub.addLksSql("", form.getIpsaeqhp(),condition, "IPSAEQHP");
condition = Pub.addLksSql("", form.getIpsaeqdp(),condition, "IPSAEQDP");
condition = Pub.addLksSql("", form.getIpsafnhp(),condition, "IPSAFNHP");
condition = Pub.addLksSql("", form.getIpsafndp(),condition, "IPSAFNDP");
condition = Pub.addLksSql("", form.getIpsaexhp(),condition, "IPSAEXHP");
condition = Pub.addLksSql("", form.getIpsaexdp(),condition, "IPSAEXDP");
condition = Pub.addLksSql("", form.getIpsawecs(),condition, "IPSAWECS");
condition = Pub.addLksSql("", form.getIpsawecd(),condition, "IPSAWECD");
condition = Pub.addLksSql("", form.getIpsaepsp(),condition, "IPSAEPSP");
condition = Pub.addLksSql("", form.getIpsaepdp(),condition, "IPSAEPDP");
condition = Pub.addLksSql("", form.getIpsaocgp(),condition, "IPSAOCGP");
condition = Pub.addLksSql("", form.getIpsaocdp(),condition, "IPSAOCDP");
condition = Pub.addLksSql("", form.getIpsaefrt(),condition, "IPSAEFRT");
condition = Pub.addLksSql("", form.getIpsaetoc(),condition, "IPSAETOC");
condition = Pub.addLksSql("", form.getIpsaehro(),condition, "IPSAEHRO");
condition = Pub.addLksSql("", form.getIpsaedfp(),condition, "IPSAEDFP");
condition = Pub.addLksSql("", form.getIpsaesim(),condition, "IPSAESIM");
condition = Pub.addLksSql("", form.getIpsaeevp(),condition, "IPSAEEVP");
condition = Pub.addLksSql("", form.getIpsaeewc(),condition, "IPSAEEWC");
condition = Pub.addDouSql(form.getJipsaivin(), form.getIpsaivin(),condition, "IPSAIVIN");
condition = Pub.addDouSql(form.getJipsaaivr(), form.getIpsaaivr(),condition, "IPSAAIVR");
condition = Pub.addLksSql("", form.getIpsadtps(),condition, "IPSADTPS");
condition = Pub.addLksSql("", form.getIpsadepc(),condition, "IPSADEPC");
condition = Pub.addLksSql("", form.getIpsanote(),condition, "IPSANOTE");
condition = Pub.addLksSql("", form.getIpsapclk(),condition, "IPSAPCLK");
condition = Pub.addLksSql("", form.getIpsaaslk(),condition, "IPSAASLK");
condition = Pub.addLksSql("", form.getIpsaiefu(),condition, "IPSAIEFU");
condition = Pub.addLksSql("", form.getIpsaiofg(),condition, "IPSAIOFG");
condition = Pub.addLksSql("", form.getIpsaadfg(),condition, "IPSAADFG");
condition = Pub.addLksSql("", form.getIpsapbfg(),condition, "IPSAPBFG");
condition = Pub.addLksSql("", form.getIpsaopfg(),condition, "IPSAOPFG");
condition = Pub.addLksSql("", form.getIpsasequ(),condition, "IPSASEQU");
condition = Pub.addLksSql("", form.getArtcname(),condition, "(select SSLFNDNM from SSLF where SSLFSTCD='A' and SSLFCNDN=IPSAARTC)");
//查询条件结束
}catch(Exception e){
sqlCode = Constants.ERRORCODE_ORGANIZE;
sqlMsg=e.getMessage();
e.printStackTrace();
errLog = e.getMessage();
Pub.dberrlog(errLog, sql);
return null;
}
try{
sql = "select count(*) from IPSA where IPSASTCD='A' " + condition;
rs = dbs.doQueryByCache(sql);
rs.next();
totalNum = rs.getInt(1);
}catch(Exception e) {
sqlCode = Constants.SQLCODE_EXECERROR;
e.printStackTrace();
errLog = e.getMessage();
Pub.dberrlog(errLog, sql);
return null;
}
try{
PageHelper pageHelper = form.getPageHelper();
pageHelper.setTotalLines(totalNum);
int first = pageHelper.getLineFrom();
int last = pageHelper.getLineTo();
sql = "select * from ( "
+"select"
+ " ROW_NUMBER() OVER (ORDER BY IPSASEQU ASC,IPSADTOP DESC) AS ROWNUMBER,"
+ "IPSAINNU,"
+ "IPSAMEAC,"
+ "IPSACUNO,"
+ "IPSAPRJA,"
+ "IPSATPSD,"
+ "IPSAARTC,"
+ "IPSATPPF,"
+ "IPSASCPJ,"
+ "IPSAELVP,"
+ "IPSALPJC,"
+ "IPSAACRD,"
+ "IPSAGLPJ,"
+ "IPSAOWPJ,"
+ "IPSAOWCN,"
+ "IPSACTTL,"
+ "IPSAPCTP,"
+ "IPSASCTP,"
+ "IPSATCHP,"
+ "IPSATCDP,"
+ "IPSAPRHP,"
+ "IPSAPRDP,"
+ "IPSAEQHP,"
+ "IPSAEQDP,"
+ "IPSAFNHP,"
+ "IPSAFNDP,"
+ "IPSAEXHP,"
+ "IPSAEXDP,"
+ "IPSAWECS,"
+ "IPSAWECD,"
+ "IPSAEPSP,"
+ "IPSAEPDP,"
+ "IPSAOCGP,"
+ "IPSAOCDP,"
+ "IPSAEFRT,"
+ "IPSAETOC,"
+ "IPSAEHRO,"
+ "IPSAEDFP,"
+ "IPSAESIM,"
+ "IPSAEEVP,"
+ "IPSAEEWC,"
+ "IPSAIVIN,"
+ "IPSAAIVR,"
+ "IPSADTPS,"
+ "IPSADEPC,"
+ "IPSANOTE,"
+ "IPSAPCLK,"
+ "IPSAASLK,"
+ "IPSAIEFU,"
+ "IPSAIOFG,"
+ "IPSABPJF,"
+ "IPSADTOP,"
+ "IPSADTCL,"
+ "IPSADTMT,"
+ "IPSAOPOP,"
+ "IPSAOPCL,"
+ "IPSAOPMT,"
+ "IPSAMTSQ,"
+ "IPSATMMT,"
+ "IPSASEQU,"
+ "IPSAADFG,"
+ "IPSAPBFG,"
+ "IPSAOPFG,"
+ "IPSASTCD,"
+ "(select SSLFNDNM from SSLF where SSLFSTCD='A' and SSLFCNDN=IPSAARTC) ARTCNAME, "
+ "(select SYPMPNCH from SYPM where SYPMSTCD='A' and SYPMPMTP='TPSD' and SYPMPMNB=IPSATPSD) TPSDNAME,"
+ "(select SYPMPNCH from SYPM where SYPMSTCD='A' and SYPMPMTP='TPPF' and SYPMPMNB=IPSATPPF) TPPFNAME,"
+ "(select SYPMPNCH from SYPM where SYPMSTCD='A' and SYPMPMTP='SCPJ' and SYPMPMNB=IPSASCPJ) SCPJNAME,"
+ "(select SYPMPNCH from SYPM where SYPMSTCD='A' and SYPMPMTP='ELVP' and SYPMPMNB=IPSAELVP) ELVPNAME,"
+ "(select SYPMPNCH from SYPM where SYPMSTCD='A' and SYPMPMTP='LPJC' and SYPMPMNB=IPSALPJC) LPJCNAME,"
+ "(select BIEPNACH from BIEP where BIEPSTCD='A' and BIEPCUNO=IPSACUNO) BIEPNACH,"
+ "(select BIEPNAEN from BIEP where BIEPSTCD='A' and BIEPCUNO=IPSACUNO) BIEPNAEN,"
+ "(select BIEPTELN from BIEP where BIEPSTCD='A' and BIEPCUNO=IPSACUNO) BIEPTELN,"
+ "(select BIEPCADD from BIEP where BIEPSTCD='A' and BIEPCUNO=IPSACUNO) BIEPCADD"
+ " from IPSA where IPSASTCD='A' "
+ condition
+ " ) as ALL WHERE ROWNUMBER BETWEEN " + first + " AND "+ last;
rs = dbs.doQueryByCache(sql);
System.out.println("ipsa:"+sql);
while (rs.next()) {
IpsaData data = new IpsaData();
data.setIpsainnu(Pub.trimStr(rs.getString("IPSAINNU")));
data.setIpsameac(Pub.trimStr(rs.getString("IPSAMEAC")));
data.setIpsacuno(Pub.trimStr(rs.getString("IPSACUNO")));
data.setIpsaprja(Pub.trimStr(rs.getString("IPSAPRJA")));
data.setIpsatpsd(Pub.trimStr(rs.getString("IPSATPSD")));
data.setIpsaartc(Pub.trimStr(rs.getString("IPSAARTC")));
data.setIpsatppf(Pub.trimStr(rs.getString("IPSATPPF")));
data.setIpsascpj(Pub.trimStr(rs.getString("IPSASCPJ")));
data.setIpsaelvp(Pub.trimStr(rs.getString("IPSAELVP")));
data.setIpsalpjc(Pub.trimStr(rs.getString("IPSALPJC")));
data.setIpsaacrd(Pub.trimStr(rs.getString("IPSAACRD")));
data.setIpsaglpj(Pub.trimStr(rs.getString("IPSAGLPJ")));
data.setIpsaowpj(Pub.trimStr(rs.getString("IPSAOWPJ")));
data.setIpsaowcn(Pub.trimStr(rs.getString("IPSAOWCN")));
data.setIpsacttl(Pub.trimStr(rs.getString("IPSACTTL")));
data.setIpsapctp(Pub.trimStr(rs.getString("IPSAPCTP")));
data.setIpsasctp(Pub.trimStr(rs.getString("IPSASCTP")));
data.setIpsatchp(Pub.trimStr(rs.getString("IPSATCHP")));
data.setIpsatcdp(Pub.trimStr(rs.getString("IPSATCDP")));
data.setIpsaprhp(Pub.trimStr(rs.getString("IPSAPRHP")));
data.setIpsaprdp(Pub.trimStr(rs.getString("IPSAPRDP")));
data.setIpsaeqhp(Pub.trimStr(rs.getString("IPSAEQHP")));
data.setIpsaeqdp(Pub.trimStr(rs.getString("IPSAEQDP")));
data.setIpsafnhp(Pub.trimStr(rs.getString("IPSAFNHP")));
data.setIpsafndp(Pub.trimStr(rs.getString("IPSAFNDP")));
data.setIpsaexhp(Pub.trimStr(rs.getString("IPSAEXHP")));
data.setIpsaexdp(Pub.trimStr(rs.getString("IPSAEXDP")));
data.setIpsawecs(Pub.trimStr(rs.getString("IPSAWECS")));
data.setIpsawecd(Pub.trimStr(rs.getString("IPSAWECD")));
data.setIpsaepsp(Pub.trimStr(rs.getString("IPSAEPSP")));
data.setIpsaepdp(Pub.trimStr(rs.getString("IPSAEPDP")));
data.setIpsaocgp(Pub.trimStr(rs.getString("IPSAOCGP")));
data.setIpsaocdp(Pub.trimStr(rs.getString("IPSAOCDP")));
data.setIpsaefrt(Pub.trimStr(rs.getString("IPSAEFRT")));
data.setIpsaetoc(Pub.trimStr(rs.getString("IPSAETOC")));
data.setIpsaehro(Pub.trimStr(rs.getString("IPSAEHRO")));
data.setIpsaedfp(Pub.trimStr(rs.getString("IPSAEDFP")));
data.setIpsaesim(Pub.trimStr(rs.getString("IPSAESIM")));
data.setIpsaeevp(Pub.trimStr(rs.getString("IPSAEEVP")));
data.setIpsaeewc(Pub.trimStr(rs.getString("IPSAEEWC")));
data.setIpsaivin(Pub.trimStr(rs.getString("IPSAIVIN")));
data.setIpsaaivr(Pub.trimStr(rs.getString("IPSAAIVR")));
data.setIpsadtps(Pub.trimStr(rs.getString("IPSADTPS")));
data.setIpsadepc(Pub.trimStr(rs.getString("IPSADEPC")));
data.setIpsanote(Pub.trimStr(rs.getString("IPSANOTE")));
data.setIpsapclk(Pub.trimStr(rs.getString("IPSAPCLK")));
data.setIpsaaslk(Pub.trimStr(rs.getString("IPSAASLK")));
data.setIpsaiefu(Pub.trimStr(rs.getString("IPSAIEFU")));
data.setIpsaiofg(Pub.trimStr(rs.getString("IPSAIOFG")));
data.setIpsabpjf(Pub.trimStr(rs.getString("IPSABPJF")));
data.setIpsadtop(Pub.trimStr(rs.getString("IPSADTOP")));
data.setIpsadtcl(Pub.trimStr(rs.getString("IPSADTCL")));
data.setIpsadtmt(Pub.trimStr(rs.getString("IPSADTMT")));
data.setIpsaopop(Pub.trimStr(rs.getString("IPSAOPOP")));
data.setIpsaopcl(Pub.trimStr(rs.getString("IPSAOPCL")));
data.setIpsaopmt(Pub.trimStr(rs.getString("IPSAOPMT")));
data.setIpsamtsq(Pub.trimStr(rs.getString("IPSAMTSQ")));
data.setIpsatmmt(Pub.trimStr(rs.getString("IPSATMMT")));
data.setIpsasequ(Pub.trimStr(rs.getString("IPSASEQU")));
data.setIpsaadfg(Pub.trimStr(rs.getString("IPSAADFG")));
data.setIpsapbfg(Pub.trimStr(rs.getString("IPSAPBFG")));
data.setIpsaopfg(Pub.trimStr(rs.getString("IPSAOPFG")));
data.setIpsastcd(Pub.trimStr(rs.getString("IPSASTCD")));
data.setTpsdname(Pub.trimStr(rs.getString("TPSDNAME")));
data.setTppfname(Pub.trimStr(rs.getString("TPPFNAME")));
data.setScpjname(Pub.trimStr(rs.getString("SCPJNAME")));
data.setElvpname(Pub.trimStr(rs.getString("ELVPNAME")));
data.setLpjcname(Pub.trimStr(rs.getString("LPJCNAME")));
data.setBiepnach(Pub.trimStr(rs.getString("BIEPNACH")));
data.setBiepnaen(Pub.trimStr(rs.getString("BIEPNAEN")));
data.setBiepteln(Pub.trimStr(rs.getString("BIEPTELN")));
data.setBiepcadd(Pub.trimStr(rs.getString("BIEPCADD")));
data.setIpsaprja1(Pub.trimStrTo20(Pub.trimStr(rs.getString("IPSAPRJA"))));
data.setIpsaacrd1(Pub.trimStrTo20(Pub.trimStr(rs.getString("IPSAACRD"))));
data.setIpsaglpj1(Pub.trimStrTo20(Pub.trimStr(rs.getString("IPSAGLPJ"))));
data.setIpsaowpj1(Pub.trimStrTo20(Pub.trimStr(rs.getString("IPSAOWPJ"))));
data.setIpsaowcn1(Pub.trimStrTo20(Pub.trimStr(rs.getString("IPSAOWCN"))));
// data.setIpsacttl1(Pub.trimStrTo20(Pub.trimStr(rs.getString("IPSACTTL"))));
data.setIpsapctp1(Pub.trimStrTo20(Pub.trimStr(rs.getString("IPSAPCTP"))));
data.setIpsasctp1(Pub.trimStrTo20(Pub.trimStr(rs.getString("IPSASCTP"))));
data.setIpsatchp1(Pub.trimStrTo20(Pub.trimStr(rs.getString("IPSATCHP"))));
data.setIpsatcdp1(Pub.trimStrTo20(Pub.trimStr(rs.getString("IPSATCDP"))));
data.setIpsaprhp1(Pub.trimStrTo20(Pub.trimStr(rs.getString("IPSAPRHP"))));
data.setIpsaprdp1(Pub.trimStrTo20(Pub.trimStr(rs.getString("IPSAPRDP"))));
data.setIpsaeqhp1(Pub.trimStrTo20(Pub.trimStr(rs.getString("IPSAEQHP"))));
data.setIpsaeqdp1(Pub.trimStrTo20(Pub.trimStr(rs.getString("IPSAEQDP"))));
data.setIpsafnhp1(Pub.trimStrTo20(Pub.trimStr(rs.getString("IPSAFNHP"))));
data.setIpsafndp1(Pub.trimStrTo20(Pub.trimStr(rs.getString("IPSAFNDP"))));
data.setIpsaexhp1(Pub.trimStrTo20(Pub.trimStr(rs.getString("IPSAEXHP"))));
data.setIpsaexdp1(Pub.trimStrTo20(Pub.trimStr(rs.getString("IPSAEXDP"))));
data.setIpsawecs1(Pub.trimStrTo20(Pub.trimStr(rs.getString("IPSAWECS"))));
data.setIpsawecd1(Pub.trimStrTo20(Pub.trimStr(rs.getString("IPSAWECD"))));
data.setIpsaepsp1(Pub.trimStrTo20(Pub.trimStr(rs.getString("IPSAEPSP"))));
data.setIpsaepdp1(Pub.trimStrTo20(Pub.trimStr(rs.getString("IPSAEPDP"))));
data.setIpsaocgp1(Pub.trimStrTo20(Pub.trimStr(rs.getString("IPSAOCGP"))));
data.setIpsaocdp1(Pub.trimStrTo20(Pub.trimStr(rs.getString("IPSAOCDP"))));
data.setIpsaefrt1(Pub.trimStrTo20(Pub.trimStr(rs.getString("IPSAEFRT"))));
data.setIpsaetoc1(Pub.trimStrTo20(Pub.trimStr(rs.getString("IPSAETOC"))));
data.setIpsaehro1(Pub.trimStrTo20(Pub.trimStr(rs.getString("IPSAEHRO"))));
data.setIpsaedfp1(Pub.trimStrTo20(Pub.trimStr(rs.getString("IPSAEDFP"))));
data.setIpsaesim1(Pub.trimStrTo20(Pub.trimStr(rs.getString("IPSAESIM"))));
data.setIpsaeevp1(Pub.trimStrTo20(Pub.trimStr(rs.getString("IPSAEEVP"))));
data.setIpsaeewc1(Pub.trimStrTo20(Pub.trimStr(rs.getString("IPSAEEWC"))));
// data.setIpsaivin1(Pub.trimStrTo20(Pub.trimStr(rs.getString("IPSAIVIN"))));
// data.setIpsaaivr1(Pub.trimStrTo20(Pub.trimStr(rs.getString("IPSAAIVR"))));
data.setIpsadtps1(Pub.trimStrTo20(Pub.trimStr(rs.getString("IPSADTPS"))));
data.setIpsadepc1(Pub.trimStrTo20(Pub.trimStr(rs.getString("IPSADEPC"))));
data.setIpsanote1(Pub.trimStrTo20(Pub.trimStr(rs.getString("IPSANOTE"))));
data.setIpsapclk1(Pub.trimStrTo20(Pub.trimStr(rs.getString("IPSAPCLK"))));
data.setIpsaaslk1(Pub.trimStrTo20(Pub.trimStr(rs.getString("IPSAASLK"))));
data.setArtcname(Pub.trimStr(rs.getString("ARTCNAME")));
data.setAdfgname(SelectOptions.getAdfgName(data.getIpsaadfg()));
data.setPbfgname(SelectOptions.getPbfgName(data.getIpsapbfg()));
data.setOpfgname(SelectOptions.getOpfgName(data.getIpsaopfg()));
data.setIofgname(SelectOptions.getIofgName(data.getIpsaiofg()));
if(data.getIpsapclk() != null) data.setPclkname(Pub.getFilenameByLink(data.getIpsapclk()));
if(data.getIpsaaslk() != null) data.setAslkname(Pub.getFilenameByLink(data.getIpsaaslk()));
al.add(data);
data = null;
}
rs.close();
rs = null;
} catch (Exception e) {
al = null;
sqlCode = Constants.SQLCODE_EXECERROR;
e.printStackTrace();
errLog = e.getMessage();
Pub.dberrlog(errLog, sql);
}
return al;
}
}
/*****************************************************/
一个公用的JSP（在用到翻页的页面将此页include进来，具体方法：<jsp:include page="/common/flip.jsp?formName=ipsaViewForm&dataList=ipsaList" flush="true"/>）
flip.jsp:
<%@ taglib uri="/WEB-INF/struts-html.tld" prefix="html"%>
<%@ taglib uri="/WEB-INF/struts-bean.tld" prefix="bean"%>
<%@ taglib uri="/WEB-INF/struts-logic.tld" prefix="logic"%>
<%@ page language="java" contentType="text/html; charset=GBK" pageEncoding="GBK"%>
<%
String formName = request.getParameter("formName");
String dataList = request.getParameter("dataList");
%>
<logic:notEmpty name="<%=formName%>" property="<%=dataList%>">
<!-- page start -->
<table border="0" class="tblPage">
<tr>
<td align="right" valign="bottom">
<logic:greaterThan name="<%=formName%>" property="pageHelper.totalPages" value="0">
共有<bean:write name="<%=formName%>" property="pageHelper.totalLines"/>条记录
第<bean:write name="<%=formName%>" property="pageHelper.currPageNo"/>
/<bean:write name="<%=formName%>" property="pageHelper.totalPages"/>页
<logic:equal name="<%=formName%>" property="pageHelper.isFirstPage" value="false">
<a href="javascript:pageSubmit(<%=formName%>,'first');" >首页 </a>
<a href="javascript:pageSubmit(<%=formName%>,'previous');" >上一页</a>
</logic:equal>
<logic:equal name="<%=formName%>" property="pageHelper.isFirstPage" value="true">
首页 上一页
</logic:equal>
<logic:equal name="<%=formName%>" property="pageHelper.isLastPage" value="false">
<a href="javascript:pageSubmit(<%=formName%>,'next');">下一页</a>
<a href="javascript:pageSubmit(<%=formName%>,'last');">尾页</a>
</logic:equal>
<logic:equal name="<%=formName%>" property="pageHelper.isLastPage" value="true">
下一页 尾页
</logic:equal>
转到<html:text property="pageHelper.currPageNo" size="4" onblur="this.className='inputnormal'"
onfocus="this.className='inputedit';this.select()" styleClass="inputnormal" />页
<a href="javascript:pageSubmit(<%=formName%>,'current');">
<img src="<%=request.getContextPath()%>/images/go.gif" border="0">
</a>
</logic:greaterThan>
<logic:lessEqual name="<%=formName%>" property="pageHelper.totalPages" value="1">
<html:hidden property="pageHelper.currPageNo" value="1"/>
</logic:lessEqual>
</td>
</tr>
</table>
<!-- page end -->
</logic:notEmpty>
pub.jsp:一些公用的方法
<%@ page language="java" contentType="text/js; charset=GBK" pageEncoding="GBK"%>
//分页提交
function pageSubmit(theForm,action) {
theForm.elements["pageHelper.action"].value = action;
theForm.submit();
}
posted on 2007-12-24 16:27
我爱家人 阅读(221)
评论(0) 编辑 收藏 所属分类:
struts