📄 retrievefitapplydbbean.java
字号:
{
return pagecount;
}
public int getPageindex()
{
return pageindex;
}
public String getPaperdate()
{
return paperdate;
}
public String getPaperman()
{
return paperman;
}
public String getRemark()
{
return remark;
}
public String getRetrievecom()
{
return retrievecom;
}
public String getRetrievecon()
{
return retrievecon;
}
public String getRetrieveindex()
{
return retrieveindex;
}
public String getSelect02()
{
return select02;
}
public String getSign()
{
return sign;
}
public Vector getSignvec()
{
return signvec;
}
public String getStair()
{
return stair;
}
public Vector getStairvec()
{
return stairvec;
}
public String getStartdate()
{
return startdate;
}
public String getSubarea()
{
return subarea;
}
public Vector getSubareavec()
{
return subareavec;
}
public String getTeam()
{
return team;
}
public String getTeamgrantno()
{
return teamgrantno;
}
public String getTeamlevel()
{
return teamlevel;
}
public String getTeamno()
{
return teamno;
}
public String getTouchway()
{
return touchway;
}
public Vector getTouchwayvec()
{
return touchwayvec;
}
public String getTransactor()
{
return transactor;
}
public String getUpdownindex()
{
return updownindex;
}
protected void initSelect02()
throws DataException, IOException
{
StatementMetaData statementmetadata = null;
selectSql02 = new SelectStatement();
selectSql02.setConnection(connBean);
statementmetadata = selectSql02.getMetaData();
statementmetadata.setSQL(getSelect02());
statementmetadata.addTable(getTableName());
statementmetadata.addColumn("number", class$java$lang$Integer == null ? (class$java$lang$Integer = class$("java.lang.Integer")) : class$java$lang$Integer, 4);
statementmetadata.addColumn("subarea", class$java$lang$String == null ? (class$java$lang$String = class$("java.lang.String")) : class$java$lang$String, 12);
statementmetadata.addColumn("building", class$java$lang$String == null ? (class$java$lang$String = class$("java.lang.String")) : class$java$lang$String, 12);
statementmetadata.addColumn("stair", class$java$lang$String == null ? (class$java$lang$String = class$("java.lang.String")) : class$java$lang$String, 12);
statementmetadata.addColumn("floor", class$java$lang$String == null ? (class$java$lang$String = class$("java.lang.String")) : class$java$lang$String, 12);
statementmetadata.addColumn("cell", class$java$lang$String == null ? (class$java$lang$String = class$("java.lang.String")) : class$java$lang$String, 12);
statementmetadata.addColumn("name", class$java$lang$String == null ? (class$java$lang$String = class$("java.lang.String")) : class$java$lang$String, 12);
statementmetadata.addColumn("touchway", class$java$lang$String == null ? (class$java$lang$String = class$("java.lang.String")) : class$java$lang$String, 12);
statementmetadata.addColumn("applydate", class$java$sql$Date == null ? (class$java$sql$Date = class$("java.sql.Date")) : class$java$sql$Date, 91);
statementmetadata.addColumn("acceptsign", class$java$lang$String == null ? (class$java$lang$String = class$("java.lang.String")) : class$java$lang$String, 12);
statementmetadata.addColumn("sign", class$java$lang$String == null ? (class$java$lang$String = class$("java.lang.String")) : class$java$lang$String, 12);
switch(Integer.parseInt(getRetrieveindex()))
{
case 0: // '\0'
statementmetadata.addParameter("delflag", class$java$lang$String == null ? (class$java$lang$String = class$("java.lang.String")) : class$java$lang$String, 1);
selectSql02.setParameter("delflag", getDelflag());
break;
case 1: // '\001'
statementmetadata.addParameter("delflag", class$java$lang$String == null ? (class$java$lang$String = class$("java.lang.String")) : class$java$lang$String, 1);
statementmetadata.addParameter("name2", class$java$lang$String == null ? (class$java$lang$String = class$("java.lang.String")) : class$java$lang$String, 12);
selectSql02.setParameter("delflag", getDelflag());
selectSql02.setParameter("name2", getName());
break;
case 2: // '\002'
statementmetadata.addParameter("delflag", class$java$lang$String == null ? (class$java$lang$String = class$("java.lang.String")) : class$java$lang$String, 1);
statementmetadata.addParameter("team2", class$java$lang$String == null ? (class$java$lang$String = class$("java.lang.String")) : class$java$lang$String, 12);
selectSql02.setParameter("delflag", getDelflag());
selectSql02.setParameter("team2", getTeam());
break;
case 3: // '\003'
statementmetadata.addParameter("delflag", class$java$lang$String == null ? (class$java$lang$String = class$("java.lang.String")) : class$java$lang$String, 1);
statementmetadata.addParameter("approveman2", class$java$lang$String == null ? (class$java$lang$String = class$("java.lang.String")) : class$java$lang$String, 12);
selectSql02.setParameter("delflag", getDelflag());
selectSql02.setParameter("approveman2", getApproveman());
break;
case 4: // '\004'
statementmetadata.addParameter("delflag", class$java$lang$String == null ? (class$java$lang$String = class$("java.lang.String")) : class$java$lang$String, 1);
statementmetadata.addParameter("acceptman21", class$java$lang$String == null ? (class$java$lang$String = class$("java.lang.String")) : class$java$lang$String, 12);
statementmetadata.addParameter("acceptman22", class$java$lang$String == null ? (class$java$lang$String = class$("java.lang.String")) : class$java$lang$String, 12);
selectSql02.setParameter("delflag", getDelflag());
selectSql02.setParameter("acceptman21", getAcceptman1());
selectSql02.setParameter("acceptman22", getAcceptman2());
break;
case 5: // '\005'
statementmetadata.addParameter("delflag", class$java$lang$String == null ? (class$java$lang$String = class$("java.lang.String")) : class$java$lang$String, 1);
statementmetadata.addParameter("transactor2", class$java$lang$String == null ? (class$java$lang$String = class$("java.lang.String")) : class$java$lang$String, 12);
selectSql02.setParameter("delflag", getDelflag());
selectSql02.setParameter("transactor2", getTransactor());
break;
case 6: // '\006'
statementmetadata.addParameter("delflag", class$java$lang$String == null ? (class$java$lang$String = class$("java.lang.String")) : class$java$lang$String, 1);
statementmetadata.addParameter("day2", class$java$sql$Date == null ? (class$java$sql$Date = class$("java.sql.Date")) : class$java$sql$Date, 91);
statementmetadata.addParameter("day3", class$java$sql$Date == null ? (class$java$sql$Date = class$("java.sql.Date")) : class$java$sql$Date, 91);
statementmetadata.addParameter("day4", class$java$sql$Date == null ? (class$java$sql$Date = class$("java.sql.Date")) : class$java$sql$Date, 91);
selectSql02.setParameter("delflag", getDelflag());
selectSql02.setParameter("day2", Date.valueOf(getDate()));
selectSql02.setParameter("day3", Date.valueOf(getEnddate()));
selectSql02.setParameter("day4", Date.valueOf(getDate()));
break;
case 7: // '\007'
statementmetadata.addParameter("delflag", class$java$lang$String == null ? (class$java$lang$String = class$("java.lang.String")) : class$java$lang$String, 1);
statementmetadata.addParameter("day2", class$java$sql$Date == null ? (class$java$sql$Date = class$("java.sql.Date")) : class$java$sql$Date, 91);
statementmetadata.addParameter("day3", class$java$sql$Date == null ? (class$java$sql$Date = class$("java.sql.Date")) : class$java$sql$Date, 91);
statementmetadata.addParameter("day4", class$java$sql$Date == null ? (class$java$sql$Date = class$("java.sql.Date")) : class$java$sql$Date, 91);
selectSql02.setParameter("delflag", getDelflag());
selectSql02.setParameter("day2", Date.valueOf(getDate()));
selectSql02.setParameter("day3", Date.valueOf(getEnddate()));
selectSql02.setParameter("day4", Date.valueOf(getDate()));
break;
case 8: // '\b'
statementmetadata.addParameter("delflag", class$java$lang$String == null ? (class$java$lang$String = class$("java.lang.String")) : class$java$lang$String, 1);
statementmetadata.addParameter("day2", class$java$sql$Date == null ? (class$java$sql$Date = class$("java.sql.Date")) : class$java$sql$Date, 91);
statementmetadata.addParameter("day3", class$java$sql$Date == null ? (class$java$sql$Date = class$("java.sql.Date")) : class$java$sql$Date, 91);
statementmetadata.addParameter("day4", class$java$sql$Date == null ? (class$java$sql$Date = class$("java.sql.Date")) : class$java$sql$Date, 91);
selectSql02.setParameter("delflag", getDelflag());
selectSql02.setParameter("day2", Date.valueOf(getDate()));
selectSql02.setParameter("day3", Date.valueOf(getEnddate()));
selectSql02.setParameter("day4", Date.valueOf(getDate()));
break;
case 9: // '\t'
statementmetadata.addParameter("delflag", class$java$lang$String == null ? (class$java$lang$String = class$("java.lang.String")) : class$java$lang$String, 1);
statementmetadata.addParameter("day2", class$java$sql$Date == null ? (class$java$sql$Date = class$("java.sql.Date")) : class$java$sql$Date, 91);
statementmetadata.addParameter("day3", class$java$sql$Date == null ? (class$java$sql$Date = class$("java.sql.Date")) : class$java$sql$Date, 91);
statementmetadata.addParameter("day4", class$java$sql$Date == null ? (class$java$sql$Date = class$("java.sql.Date")) : class$java$sql$Date, 91);
selectSql02.setParameter("delflag", getDelflag());
selectSql02.setParameter("day2", Date.valueOf(getDate()));
selectSql02.setParameter("day3", Date.valueOf(getEnddate()));
selectSql02.setParameter("day4", Date.valueOf(getDate()));
break;
case 10: // '\n'
statementmetadata.addParameter("delflag", class$java$lang$String == null ? (class$java$lang$String = class$("java.lang.String")) : class$java$lang$String, 1);
statementmetadata.addParameter("day2", class$java$sql$Date == null ? (class$java$sql$Date = class$("java.sql.Date")) : class$java$sql$Date, 91);
statementmetadata.addParameter("day3", class$java$sql$Date == null ? (class$java$sql$Date = class$("java.sql.Date")) : class$java$sql$Date, 91);
statementmetadata.addParameter("day4", class$java$sql$Date == null ? (class$java$sql$Date = class$("java.sql.Date")) : class$java$sql$Date, 91);
statementmetadata.addParameter("day5", class$java$sql$Date == null ? (class$java$sql$Date = class$("java.sql.Date")) : class$java$sql$Date, 91);
statementmetadata.addParameter("day6", class$java$sql$Date == null ? (class$java$sql$Date = class$("java.sql.Date")) : class$java$sql$Date, 91);
statementmetadata.addParameter("day7", class$java$sql$Date == null ? (class$java$sql$Date = class$("java.sql.Date")) : class$java$sql$Date, 91);
selectSql02.setParameter("delflag", getDelflag());
selectSql02.setParameter("day2", Date.valueOf(getDate()));
selectSql02.setParameter("day3", Date.valueOf(getEnddate()));
selectSql02.setParameter("day4", Date.valueOf(getDate()));
selectSql02.setParameter("day5", Date.valueOf(getDate()));
selectSql02.setParameter("day6", Date.valueOf(getEnddate()));
selectSql02.setParameter("day7", Date.valueOf(getDate()));
break;
default:
statementmetadata.addParameter("delflag", class$java$lang$String == null ? (class$java$lang$String = class$("java.lang.String")) : class$java$lang$String, 1);
selectSql02.setParameter("delflag", getDelflag());
break;
}
}
public void select02()
throws Exception
{
try
{
initSelect02();
selectSql02.execute();
result = selectSql02.getResult();
setStatusCode(2052);
setStatusMessage("查询所有装修申请记录失败");
}
catch(DataException dataexception)
{
setStatusCode(2053);
setStatusMessage("查询所有装修申请记录的SQL语句初始化失败");
switch(dataexception.getErrorCode())
{
case 214:
setStatusCode(2054);
setStatusMessage("查询所有装修申请记录的SQL语句执行失败");
break;
default:
throw dataexception;
}
}
}
public void setAccept1(String s)
{
accept1 = s;
}
public void setAccept2(String s)
{
accept2 = s;
}
public void setAcceptdate1(String s)
{
acceptdate1 = s;
}
public void setAcceptdate2(String s)
{
acceptdate2 = s;
}
public void setAcceptman1(String s)
{
acceptman1 = s;
}
public void setAcceptman2(String s)
{
acceptman2 = s;
}
public void setAcceptsign(String s)
{
acceptsign = s;
}
public void setAllSqlStatement()
{
allSqlStatement.addElement(new String("SELECT NUMBER,SUBAREA,BUILDING,STAIR,FLOOR,CELL,NAME,TOUCHWAY,APPLYDATE,ACCEPTSIGN,SIGN FROM FITAPPLY WHERE ((DELFLAG=?)) ORDER BY APPLYDATE DESC"));
allSqlStatement.addElement(new String("SELECT NUMBER,SUBAREA,BUILDING,STAIR,FLOOR,CELL,NAME,TOUCHWAY,APPLYDATE,ACCEPTSIGN,SIGN FROM FITAPPLY WHERE ((DELFLAG=?)AND(NAME like ?)) ORDER BY APPLYDATE DESC"));
allSqlStatement.addElement(new String("SELECT NUMBER,SUBAREA,BUILDING,STAIR,FLOOR,CELL,NAME,TOUCHWAY,APPLYDATE,ACCEPTSIGN,SIGN FROM FITAPPLY WHERE ((DELFLAG=?)AND(TEAM like ?)) ORDER BY APPLYDATE DESC"));
allSqlStatement.addElement(new String("SELECT NUMBER,SUBAREA,BUILDING,STAIR,FLOOR,CELL,NAME,TOUCHWAY,APPLYDATE,ACCEPTSIGN,SIGN FROM FITAPPLY WHERE ((DELFLAG=?)AND(APPROVEMAN like ?)) ORDER BY APPLYDATE DESC"));
allSqlStatement.addElement(new String("SELECT NUMBER,SUBAREA,BUILDING,STAIR,FLOOR,CELL,NAME,TOUCHWAY,APPLYDATE,ACCEPTSIGN,SIGN FROM FITAPPLY WHERE ((DELFLAG=?)AND((ACCEPTMAN1 like ?)OR(ACCEPTMAN2 like ?))) ORDER BY APPLYDATE DESC"));
allSqlStatement.addElement(new String("SELECT NUMBER,SUBAREA,BUILDING,STAIR,FLOOR,CELL,NAME,TOUCHWAY,APPLYDATE,ACCEPTSIGN,SIGN FROM FITAPPLY WHERE ((DELFLAG=?)AND(TRANSACTOR like ?)) ORDER BY APPLYDATE DESC"));
allSqlStatement.addElement(new String("SELECT NUMBER,SUBAREA,BUILDING,STAIR,FLOOR,CELL,NAME,TOUCHWAY,APPLYDATE,ACCEPTSIGN,SIGN FROM FITAPPLY WHERE ((DELFLAG=?)AND((APPLYDATE>=?)AND(APPLYDATE<=?)OR(APPLYDATE=?))) ORDER BY APPLYDATE DESC"));
allSqlStatement.addElement(new String("SELECT NUMBER,SUBAREA,BUILDING,STAIR,FLOOR,CELL,NAME,TOUCHWAY,APPLYDATE,ACCEPTSIGN,SIGN FROM FITAPPLY WHERE ((DELFLAG=?)AND((STARTDATE>=?)AND(STARTDATE<=?)OR(STARTDATE=?))) ORDER BY APPLYDATE DESC"));
allSqlStatement.addElement(new String("SELECT NUMBER,SUBAREA,BUILDING,STAIR,FLOOR,CELL,NAME,TOUCHWAY,APPLYDATE,ACCEPTSIGN,SIGN FROM FITAPPLY WHERE ((DELFLAG=?)AND((ENDDATE>=?)AND(ENDDATE<=?)OR(ENDDATE=?))) ORDER BY APPLYDATE DESC"));
allSqlStatement.addElement(new String("SELECT NUMBER,SUBAREA,BUILDING,STAIR,FLOOR,CELL,NAME,TOUCHWAY,APPLYDATE,ACCEPTSIGN,SIGN FROM FITAPPLY WHERE ((DELFLAG=?)AND((APPROVEDATE>=?)AND(APPROVEDATE<=?)OR(APPROVEDATE=?))) ORDER BY APPLYDATE DESC"));
allSqlStatement.addElement(new String("SELECT NUMBER,SUBAREA,BUILDING,STAIR,FLOOR,CELL,NAME,TOUCHWAY,APPLYDATE,ACCEPTSIGN,SIGN FROM FITAPPLY WHERE ((DELFLAG=?)AND(((ACCEPTDATE1>=?)AND(ACCEPTDATE1<=?)OR(ACCEPTDATE1=?))OR((ACCEPTDATE2>=?)AND(ACCEPTDATE2<=?)OR(ACCEPTDATE2=?)))) ORDER BY APPLYDATE DESC"));
}
public void setApply(String s)
{
apply = s;
}
⌨️ 快捷键说明
复制代码
Ctrl + C
搜索代码
Ctrl + F
全屏模式
F11
切换主题
Ctrl + Shift + D
显示快捷键
?
增大字号
Ctrl + =
减小字号
Ctrl + -