📄 statdevicecheckdbbean.java
字号:
selectSql02.setParameter("date2", Date.valueOf(getDate()));
selectSql02.setParameter("date3", Date.valueOf(getEnddate()));
selectSql02.setParameter("date4", Date.valueOf(getDate()));
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("date02", class$java$sql$Date == null ? (class$java$sql$Date = class$("java.sql.Date")) : class$java$sql$Date, 91);
statementmetadata.addParameter("date03", class$java$sql$Date == null ? (class$java$sql$Date = class$("java.sql.Date")) : class$java$sql$Date, 91);
statementmetadata.addParameter("date04", class$java$sql$Date == null ? (class$java$sql$Date = class$("java.sql.Date")) : class$java$sql$Date, 91);
selectSql02.setParameter("delflag", getDelflag());
selectSql02.setParameter("date02", Date.valueOf(getDate()));
selectSql02.setParameter("date03", Date.valueOf(getEnddate()));
selectSql02.setParameter("date04", Date.valueOf(getDate()));
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("runtimes2", class$java$lang$String == null ? (class$java$lang$String = class$("java.lang.String")) : class$java$lang$String, 12);
selectSql02.setParameter("delflag", getDelflag());
selectSql02.setParameter("runtimes2", getRuntimes());
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("trouble2", class$java$lang$String == null ? (class$java$lang$String = class$("java.lang.String")) : class$java$lang$String, 12);
selectSql02.setParameter("delflag", getDelflag());
selectSql02.setParameter("trouble2", getTrouble());
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("recorder2", class$java$lang$String == null ? (class$java$lang$String = class$("java.lang.String")) : class$java$lang$String, 12);
selectSql02.setParameter("delflag", getDelflag());
selectSql02.setParameter("recorder2", getRecorder());
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(0x7ca25);
setStatusMessage("查询所有设备检查记录失败");
}
catch(DataException dataexception)
{
setStatusCode(0x7ca26);
setStatusMessage("查询所有设备检查记录的SQL语句初始化失败");
switch(dataexception.getErrorCode())
{
case 214:
setStatusCode(0x7ca27);
setStatusMessage("查询所有设备检查记录的SQL语句执行失败");
break;
default:
throw dataexception;
}
}
}
public void setAllSqlStatement()
{
allSqlStatement.addElement(new String("SELECT NUMBER,EQUIPMENT,CHECKDATE,CHECKTIME,MAN,STARTDATE,RUNTIMES,TROUBLE,RECORDER FROM ECHECKUP WHERE ((DELFLAG=?)) ORDER BY CHECKDATE DESC,CHECKTIME DESC"));
allSqlStatement.addElement(new String("SELECT NUMBER,EQUIPMENT,CHECKDATE,CHECKTIME,MAN,STARTDATE,RUNTIMES,TROUBLE,RECORDER FROM ECHECKUP WHERE ((DELFLAG=?)AND(EQUIPMENT like ?)) ORDER BY CHECKDATE DESC,CHECKTIME DESC"));
allSqlStatement.addElement(new String("SELECT NUMBER,EQUIPMENT,CHECKDATE,CHECKTIME,MAN,STARTDATE,RUNTIMES,TROUBLE,RECORDER FROM ECHECKUP WHERE ((DELFLAG=?)AND(MAN like ?)) ORDER BY CHECKDATE DESC,CHECKTIME DESC"));
allSqlStatement.addElement(new String("SELECT NUMBER,EQUIPMENT,CHECKDATE,CHECKTIME,MAN,STARTDATE,RUNTIMES,TROUBLE,RECORDER FROM ECHECKUP WHERE ((DELFLAG=?)AND((CHECKDATE >=?)AND(CHECKDATE<=?)OR(CHECKDATE=?))) ORDER BY CHECKDATE DESC,CHECKTIME DESC"));
allSqlStatement.addElement(new String("SELECT NUMBER,EQUIPMENT,CHECKDATE,CHECKTIME,MAN,STARTDATE,RUNTIMES,TROUBLE,RECORDER FROM ECHECKUP WHERE ((DELFLAG=?)AND((STARTDATE >=?)AND(STARTDATE<=?)OR(STARTDATE=?))) ORDER BY CHECKDATE DESC,CHECKTIME DESC"));
allSqlStatement.addElement(new String("SELECT NUMBER,EQUIPMENT,CHECKDATE,CHECKTIME,MAN,STARTDATE,RUNTIMES,TROUBLE,RECORDER FROM ECHECKUP WHERE ((DELFLAG=?)AND(RUNTIMES like ?)) ORDER BY CHECKDATE DESC,CHECKTIME DESC"));
allSqlStatement.addElement(new String("SELECT NUMBER,EQUIPMENT,CHECKDATE,CHECKTIME,MAN,STARTDATE,RUNTIMES,TROUBLE,RECORDER FROM ECHECKUP WHERE ((DELFLAG=?)AND(TROUBLE=?)) ORDER BY CHECKDATE DESC,CHECKTIME DESC"));
allSqlStatement.addElement(new String("SELECT NUMBER,EQUIPMENT,CHECKDATE,CHECKTIME,MAN,STARTDATE,RUNTIMES,TROUBLE,RECORDER FROM ECHECKUP WHERE ((DELFLAG=?)AND(RECORDER like ?)) ORDER BY CHECKDATE DESC,CHECKTIME DESC"));
}
public void setCheckdate(String s)
{
checkdate = s;
}
public void setCheckitem(String s)
{
checkitem = s;
}
public void setChecktime(String s)
{
checktime = s;
}
public void setDate(String s)
{
date = s;
}
public void setDelflag(String s)
{
delflag = s;
}
public void setDisplay(String s)
{
display = s;
}
public void setEnddate(String s)
{
enddate = s;
}
public void setEndtime(String s)
{
endtime = s;
}
public void setEquipment(String s)
{
equipment = s;
}
public void setMan(String s)
{
man = s;
}
public void setNumber(String s)
{
number = s;
}
public void setPageindex(int i)
{
pageindex = i;
}
public void setParameter(String s)
{
parameter = s;
}
public void setReason(String s)
{
reason = s;
}
public void setRecorder(String s)
{
recorder = s;
}
public void setRemark(String s)
{
remark = s;
}
public void setResult02()
throws Exception
{
try
{
int i = result.getNumRowsInCache();
if(i != 0)
{
if(i % 5 != 0)
{
if(i > 5)
pagecount = i / 5;
else
pagecount = 0;
} else
if(i > 5)
pagecount = i / 5 - 1;
else
pagecount = 0;
for(int j = 0; j < i; j++)
{
result.setCurrentRow(j + 1);
numbervec.addElement(result.getColumnValueToString("number"));
equipmentvec.addElement(result.getColumnValueToString("equipment"));
checkdatevec.addElement(result.getColumnValueToString("checkdate"));
checktimevec.addElement(result.getColumnValueToString("checktime"));
manvec.addElement(result.getColumnValueToString("man"));
startdatevec.addElement(result.getColumnValueToString("startdate"));
runtimesvec.addElement(result.getColumnValueToString("runtimes"));
troublevec.addElement(result.getColumnValueToString("trouble"));
recordervec.addElement(result.getColumnValueToString("recorder"));
}
setStatusCode(0x7ca28);
setStatusMessage("查询所有设备检查记录成功");
} else
{
setStatusCode(0x7ca29);
setStatusMessage("对不起，没有符合条件的设备检查记录");
}
}
catch(Exception exception1)
{
setStatusCode(0x7ca2a);
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 setRuntimes(String s)
{
runtimes = s;
}
public void setSelect02(String s)
{
select02 = s;
}
public void setStartdate(String s)
{
startdate = s;
}
public void setStarttime(String s)
{
starttime = s;
}
public void setStatus(String s)
{
status = s;
}
public void setTheSqlStatement()
{
switch(Integer.parseInt(getRetrieveindex()))
{
case 0: // '\0'
setSelect02((String)allSqlStatement.elementAt(0));
break;
case 1: // '\001'
setSelect02((String)allSqlStatement.elementAt(1));
break;
case 2: // '\002'
setSelect02((String)allSqlStatement.elementAt(2));
break;
case 3: // '\003'
setSelect02((String)allSqlStatement.elementAt(3));
break;
case 4: // '\004'
setSelect02((String)allSqlStatement.elementAt(4));
break;
case 5: // '\005'
setSelect02((String)allSqlStatement.elementAt(5));
break;
case 6: // '\006'
setSelect02((String)allSqlStatement.elementAt(6));
break;
case 7: // '\007'
setSelect02((String)allSqlStatement.elementAt(7));
break;
default:
setSelect02((String)allSqlStatement.elementAt(0));
break;
}
}
public void setTrouble(String s)
{
trouble = s;
}
public void setType(String s)
{
type = 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 + -