📄 stathelpdbbean.java
字号:
throws DataException, IOException
{
StatementMetaData statementmetadata = null;
selectStatement01 = new SelectStatement();
selectStatement01.setConnection(connBean);
statementmetadata = selectStatement01.getMetaData();
statementmetadata.setSQL(getSelectSQL01());
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("tenement", class$java$lang$String == null ? (class$java$lang$String = class$("java.lang.String")) : class$java$lang$String, 12);
statementmetadata.addColumn("ldate", class$java$sql$Date == null ? (class$java$sql$Date = class$("java.sql.Date")) : class$java$sql$Date, 91);
statementmetadata.addColumn("ltime", class$java$sql$Time == null ? (class$java$sql$Time = class$("java.sql.Time")) : class$java$sql$Time, 92);
statementmetadata.addColumn("deskclerk", class$java$lang$String == null ? (class$java$lang$String = class$("java.lang.String")) : class$java$lang$String, 12);
statementmetadata.addColumn("exponent", class$java$lang$String == null ? (class$java$lang$String = class$("java.lang.String")) : class$java$lang$String, 12);
statementmetadata.addColumn("pass", class$java$lang$String == null ? (class$java$lang$String = class$("java.lang.String")) : class$java$lang$String, 12);
statementmetadata.addColumn("dept", class$java$lang$String == null ? (class$java$lang$String = class$("java.lang.String")) : class$java$lang$String, 12);
statementmetadata.addColumn("treatman", class$java$lang$String == null ? (class$java$lang$String = class$("java.lang.String")) : class$java$lang$String, 12);
statementmetadata.addColumn("finishdate", class$java$lang$String == null ? (class$java$lang$String = class$("java.lang.String")) : class$java$lang$String, 12);
statementmetadata.addColumn("recorder", 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);
selectStatement01.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("ldate1", class$java$sql$Date == null ? (class$java$sql$Date = class$("java.sql.Date")) : class$java$sql$Date, 91);
statementmetadata.addParameter("ldate2", class$java$sql$Date == null ? (class$java$sql$Date = class$("java.sql.Date")) : class$java$sql$Date, 91);
statementmetadata.addParameter("ldate3", class$java$sql$Date == null ? (class$java$sql$Date = class$("java.sql.Date")) : class$java$sql$Date, 91);
selectStatement01.setParameter("delflag", getDelFlag());
selectStatement01.setParameter("ldate1", Date.valueOf(getLdate()));
selectStatement01.setParameter("ldate2", Date.valueOf(getEnddate()));
selectStatement01.setParameter("ldate3", Date.valueOf(getLdate()));
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("deskclerk1", class$java$lang$String == null ? (class$java$lang$String = class$("java.lang.String")) : class$java$lang$String, 12);
selectStatement01.setParameter("delflag", getDelFlag());
selectStatement01.setParameter("deskclerk1", getDeskclerk());
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("dept1", class$java$lang$String == null ? (class$java$lang$String = class$("java.lang.String")) : class$java$lang$String, 12);
selectStatement01.setParameter("delflag", getDelFlag());
selectStatement01.setParameter("dept1", getDept());
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("treatman1", class$java$lang$String == null ? (class$java$lang$String = class$("java.lang.String")) : class$java$lang$String, 12);
selectStatement01.setParameter("delflag", getDelFlag());
selectStatement01.setParameter("treatman1", getTreatman());
break;
default:
statementmetadata.addParameter("delflag", class$java$lang$String == null ? (class$java$lang$String = class$("java.lang.String")) : class$java$lang$String, 1);
selectStatement01.setParameter("delflag", getDelFlag());
break;
}
}
public void selectSQL01()
throws Exception
{
try
{
initSelectSQL011();
selectStatement01.execute();
result = selectStatement01.getResult();
setStatusCode(0x6dfc5);
setStatusMessage("查询所有文章失败");
}
catch(DataException dataexception)
{
setStatusCode(0x6dfc6);
setStatusMessage("查询所有文章的SQL语句初始化失败");
switch(dataexception.getErrorCode())
{
case 214:
setStatusCode(0x6dfc7);
setStatusMessage("查询所有文章的SQL语句执行失败");
break;
default:
throw dataexception;
}
}
}
public void setAllSqlStatement()
{
allSqlStatement.addElement(new String("SELECT NUMBER,SUBAREA,BUILDING,STAIR,FLOOR,CELL,TENEMENT,LDATE,LTIME,DESKCLERK,EXPONENT,PASS,DEPT,TREATMAN,FINISHDATE,RECORDER FROM LIVEHELP WHERE (DELFLAG=?) ORDER BY LDATE"));
allSqlStatement.addElement(new String("SELECT NUMBER,SUBAREA,BUILDING,STAIR,FLOOR,CELL,TENEMENT,LDATE,LTIME,DESKCLERK,EXPONENT,PASS,DEPT,TREATMAN,FINISHDATE,RECORDER FROM LIVEHELP WHERE ((DELFLAG=?)AND ((LDATE>=? )AND(LDATE<=?)OR(LDATE=?))) ORDER BY LDATE"));
allSqlStatement.addElement(new String("SELECT NUMBER,SUBAREA,BUILDING,STAIR,FLOOR,CELL,TENEMENT,LDATE,LTIME,DESKCLERK,EXPONENT,PASS,DEPT,TREATMAN,FINISHDATE,RECORDER FROM LIVEHELP WHERE ((DELFLAG=?)AND (DESKCLERK like ?)) ORDER BY LDATE"));
allSqlStatement.addElement(new String("SELECT NUMBER,SUBAREA,BUILDING,STAIR,FLOOR,CELL,TENEMENT,LDATE,LTIME,DESKCLERK,EXPONENT,PASS,DEPT,TREATMAN,FINISHDATE,RECORDER FROM LIVEHELP WHERE ((DELFLAG=?)AND (DEPT like ?)) ORDER BY LDATE"));
allSqlStatement.addElement(new String("SELECT NUMBER,SUBAREA,BUILDING,STAIR,FLOOR,CELL,TENEMENT,LDATE,LTIME,DESKCLERK,EXPONENT,PASS,DEPT,TREATMAN,FINISHDATE,RECORDER FROM LIVEHELP WHERE ((DELFLAG=?)AND (TREATMAN like ? )) ORDER BY LDATE"));
}
public void setAllcheck(String s)
{
allcheck = s;
}
public void setDelFlag(String s)
{
delflag = s;
}
public void setDept(String s)
{
dept = s;
}
public void setDeskclerk(String s)
{
deskclerk = s;
}
public void setEnddate(String s)
{
enddate = s;
}
public void setExponent(String s)
{
exponent = s;
}
public void setLdate(String s)
{
ldate = s;
}
public void setLtime(String s)
{
ltime = s;
}
public void setNumber(String s)
{
number = s;
}
public void setPageindex(int i)
{
pageindex = i;
}
public void setPass(String s)
{
pass = s;
}
public void setRecorder(String s)
{
recorder = s;
}
public void setRemark(String s)
{
remark = s;
}
public void setResultall()
throws Exception
{
try
{
if(result.getNumRowsInCache() != 0)
{
setAllcheck(String.valueOf(result.getNumRowsInCache()));
if(result.getNumRowsInCache() % 5 != 0)
{
if(result.getNumRowsInCache() > 5)
pagecount = result.getNumRowsInCache() / 5;
else
pagecount = 0;
} else
if(result.getNumRowsInCache() > 5)
pagecount = result.getNumRowsInCache() / 5 - 1;
else
pagecount = 0;
for(int i = 5 * pageindex; i < 5 * (pageindex + 1); i++)
{
if(i == result.getNumRowsInCache())
break;
result.setCurrentRow(i + 1);
numbervec.addElement(result.getColumnValueToString("number"));
ldatevec.addElement(result.getColumnValueToString("ldate"));
ltimevec.addElement(result.getColumnValueToString("ltime"));
deskclerkvec.addElement(result.getColumnValueToString("deskclerk"));
deptvec.addElement(result.getColumnValueToString("dept"));
treatmanvec.addElement(result.getColumnValueToString("treatman"));
}
for(int j = 0; j < result.getNumRowsInCache(); j++)
{
result.setCurrentRow(j + 1);
numbervec1.addElement(result.getColumnValueToString("number"));
if(result.getColumnValue("subarea") != null)
subareavec1.addElement(result.getColumnValueToString("subarea"));
else
subareavec1.addElement(" ");
if(result.getColumnValue("building") != null)
buildingvec1.addElement(result.getColumnValueToString("building"));
else
buildingvec1.addElement(" ");
if(result.getColumnValue("stair") != null)
stairvec1.addElement(result.getColumnValueToString("stair"));
else
stairvec1.addElement(" ");
if(result.getColumnValue("floor") != null)
floorvec1.addElement(result.getColumnValueToString("floor"));
else
floorvec1.addElement(" ");
if(result.getColumnValue("cell") != null)
cellvec1.addElement(result.getColumnValueToString("cell"));
else
cellvec1.addElement(" ");
if(result.getColumnValue("tenement") != null)
tenementvec1.addElement(result.getColumnValueToString("tenement"));
else
tenementvec1.addElement(" ");
ldatevec1.addElement(result.getColumnValueToString("ldate"));
ltimevec1.addElement(result.getColumnValueToString("ltime"));
deskclerkvec1.addElement(result.getColumnValueToString("deskclerk"));
deptvec1.addElement(result.getColumnValueToString("dept"));
exponentvec1.addElement(result.getColumnValueToString("exponent"));
passvec1.addElement(result.getColumnValueToString("pass"));
treatmanvec1.addElement(result.getColumnValueToString("treatman"));
recordervec1.addElement(result.getColumnValueToString("recorder"));
if(result.getColumnValue("finishdate") != null)
finishdatevec1.addElement(result.getColumnValueToString("finishdate"));
else
finishdatevec1.addElement(" ");
String s = "";
s = result.getColumnValueToString("ldate").substring(5, 7) + "_XQ_" + result.getColumnValueToString("number");
helpnovec1.addElement(s);
}
setStatusCode(0x6dfc8);
setStatusMessage("查询主题下所有文章成功");
} else
{
setStatusCode(0x6dfc9);
setStatusMessage("对不起，没有符合条件的文章");
}
}
catch(Exception exception1)
{
setStatusCode(0x6dfca);
setStatusMessage("处理查询指定主题下的文章的结果集出错");
throw exception1;
}
finally
{
closeResultSet();
}
}
public void setRetrievecom(String s)
{
retrievecom = s;
}
public void setRetrievecon(String s)
{
retrievecon = s;
}
public void setRetrieveindex(String s)
{
retrieveindex = s;
}
public void setSelectSQL01(String s)
{
selectSQL01 = s;
}
public void setTheSqlStatement()
{
switch(Integer.parseInt(getRetrieveindex()))
{
case 0: // '\0'
setSelectSQL01((String)allSqlStatement.elementAt(0));
break;
case 1: // '\001'
setSelectSQL01((String)allSqlStatement.elementAt(1));
break;
case 2: // '\002'
setSelectSQL01((String)allSqlStatement.elementAt(2));
break;
case 3: // '\003'
setSelectSQL01((String)allSqlStatement.elementAt(3));
break;
case 4: // '\004'
setSelectSQL01((String)allSqlStatement.elementAt(4));
break;
default:
setSelectSQL01((String)allSqlStatement.elementAt(0));
break;
}
}
public void setTreatman(String s)
{
treatman = s;
}
public void setUpdownindex()
{
int i = getPageindex();
int j = getPagecount();
if((i == 0) & (j != 0))
updownindex = "1";
if((i == j) & (j != 0))
updownindex = "2";
if((i > 0) & (i < j))
updownindex = "3";
}
}
⌨️ 快捷键说明
复制代码
Ctrl + C
搜索代码
Ctrl + F
全屏模式
F11
切换主题
Ctrl + Shift + D
显示快捷键
?
增大字号
Ctrl + =
减小字号
Ctrl + -