📄 statsounddbbean.java
字号:
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("iffydept", 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("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("date", class$java$sql$Date == null ? (class$java$sql$Date = class$("java.sql.Date")) : class$java$sql$Date, 91);
statementmetadata.addColumn("exponent", class$java$lang$String == null ? (class$java$lang$String = class$("java.lang.String")) : class$java$lang$String, 12);
statementmetadata.addColumn("acceptman", class$java$lang$String == null ? (class$java$lang$String = class$("java.lang.String")) : class$java$lang$String, 12);
statementmetadata.addColumn("nextman", class$java$lang$String == null ? (class$java$lang$String = class$("java.lang.String")) : class$java$lang$String, 12);
statementmetadata.addColumn("treatidea", class$java$lang$String == null ? (class$java$lang$String = class$("java.lang.String")) : class$java$lang$String, 12);
statementmetadata.addColumn("overdate", class$java$sql$Date == null ? (class$java$sql$Date = class$("java.sql.Date")) : class$java$sql$Date, 91);
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("iffydept2", class$java$lang$String == null ? (class$java$lang$String = class$("java.lang.String")) : class$java$lang$String, 12);
selectSql02.setParameter("delflag", getDelflag());
selectSql02.setParameter("iffydept2", getIffydept());
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("tenement2", class$java$lang$String == null ? (class$java$lang$String = class$("java.lang.String")) : class$java$lang$String, 12);
selectSql02.setParameter("delflag", getDelflag());
selectSql02.setParameter("tenement2", getTenement());
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("acceptman2", class$java$lang$String == null ? (class$java$lang$String = class$("java.lang.String")) : class$java$lang$String, 12);
selectSql02.setParameter("delflag", getDelflag());
selectSql02.setParameter("acceptman2", getAcceptman());
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("nextman2", class$java$lang$String == null ? (class$java$lang$String = class$("java.lang.String")) : class$java$lang$String, 12);
selectSql02.setParameter("delflag", getDelflag());
selectSql02.setParameter("nextman2", getNextman());
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("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 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;
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(0x757b1);
setStatusMessage("查询所有投诉意见记录失败");
}
catch(DataException dataexception)
{
setStatusCode(0x757b2);
setStatusMessage("查询所有投诉意见记录的SQL语句初始化失败");
switch(dataexception.getErrorCode())
{
case 214:
setStatusCode(0x757b3);
setStatusMessage("查询所有投诉意见记录的SQL语句执行失败");
break;
default:
throw dataexception;
}
}
}
public void setAcceptman(String s)
{
acceptman = s;
}
public void setAllSqlStatement()
{
allSqlStatement.addElement(new String("SELECT NUMBER,IFFYDEPT,TENEMENT,SUBAREA,BUILDING,STAIR,FLOOR,CELL,DATE,EXPONENT,ACCEPTMAN,NEXTMAN,TREATIDEA,OVERDATE,SIGN FROM LIVESOUND WHERE ((DELFLAG=?)) ORDER BY DATE"));
allSqlStatement.addElement(new String("SELECT NUMBER,IFFYDEPT,TENEMENT,SUBAREA,BUILDING,STAIR,FLOOR,CELL,DATE,EXPONENT,ACCEPTMAN,NEXTMAN,TREATIDEA,OVERDATE,SIGN FROM LIVESOUND WHERE ((DELFLAG=?)AND(IFFYDEPT like ?)) ORDER BY DATE"));
allSqlStatement.addElement(new String("SELECT NUMBER,IFFYDEPT,TENEMENT,SUBAREA,BUILDING,STAIR,FLOOR,CELL,DATE,EXPONENT,ACCEPTMAN,NEXTMAN,TREATIDEA,OVERDATE,SIGN FROM LIVESOUND WHERE ((DELFLAG=?)AND(TENEMENT like ?)) ORDER BY DATE"));
allSqlStatement.addElement(new String("SELECT NUMBER,IFFYDEPT,TENEMENT,SUBAREA,BUILDING,STAIR,FLOOR,CELL,DATE,EXPONENT,ACCEPTMAN,NEXTMAN,TREATIDEA,OVERDATE,SIGN FROM LIVESOUND WHERE ((DELFLAG=?)AND(ACCEPTMAN like ?)) ORDER BY DATE"));
allSqlStatement.addElement(new String("SELECT NUMBER,IFFYDEPT,TENEMENT,SUBAREA,BUILDING,STAIR,FLOOR,CELL,DATE,EXPONENT,ACCEPTMAN,NEXTMAN,TREATIDEA,OVERDATE,SIGN FROM LIVESOUND WHERE ((DELFLAG=?)AND(NEXTMAN like ?)) ORDER BY DATE"));
allSqlStatement.addElement(new String("SELECT NUMBER,IFFYDEPT,TENEMENT,SUBAREA,BUILDING,STAIR,FLOOR,CELL,DATE,EXPONENT,ACCEPTMAN,NEXTMAN,TREATIDEA,OVERDATE,SIGN FROM LIVESOUND WHERE ((DELFLAG=?)AND((DATE>=?)AND(DATE<=?)OR(DATE=?))) ORDER BY DATE"));
allSqlStatement.addElement(new String("SELECT NUMBER,IFFYDEPT,TENEMENT,SUBAREA,BUILDING,STAIR,FLOOR,CELL,DATE,EXPONENT,ACCEPTMAN,NEXTMAN,TREATIDEA,OVERDATE,SIGN FROM LIVESOUND WHERE ((DELFLAG=?)AND((OVERDATE>=?)AND(OVERDATE<=?)OR(OVERDATE=?))) ORDER BY DATE"));
}
public void setBuilding(String s)
{
building = s;
}
public void setCell(String s)
{
cell = s;
}
public void setDate(String s)
{
date = s;
}
public void setDelflag(String s)
{
delflag = s;
}
public void setEnddate(String s)
{
enddate = s;
}
public void setExponent(String s)
{
exponent = s;
}
public void setFloor(String s)
{
floor = s;
}
public void setIffydept(String s)
{
iffydept = s;
}
public void setNextman(String s)
{
nextman = s;
}
public void setNumber(String s)
{
number = s;
}
public void setOverdate(String s)
{
overdate = s;
}
public void setPageindex(int i)
{
pageindex = i;
}
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 = 5 * pageindex; j < 5 * (pageindex + 1); j++)
{
if(j == i)
break;
result.setCurrentRow(j + 1);
numbervec.addElement(result.getColumnValueToString("number"));
iffydeptvec.addElement(result.getColumnValueToString("iffydept"));
if(result.getColumnValueToString("tenement").equals(""))
tenementvec.addElement("不详");
else
tenementvec.addElement(result.getColumnValueToString("tenement"));
subareavec.addElement(result.getColumnValueToString("subarea"));
buildingvec.addElement(result.getColumnValueToString("building"));
stairvec.addElement(result.getColumnValueToString("stair"));
floorvec.addElement(result.getColumnValueToString("floor"));
cellvec.addElement(result.getColumnValueToString("cell"));
datevec.addElement(result.getColumnValueToString("date"));
acceptmanvec.addElement(result.getColumnValueToString("acceptman"));
if(result.getColumnValueToString("sign").equals("0"))
signvec.addElement("未处理");
else
signvec.addElement("已处理");
}
for(int k = 0; k < i; k++)
{
result.setCurrentRow(k + 1);
numbervec1.addElement(result.getColumnValueToString("number"));
iffydeptvec1.addElement(result.getColumnValueToString("iffydept"));
if(result.getColumnValueToString("tenement").equals(""))
tenementvec1.addElement("不详");
else
tenementvec1.addElement(result.getColumnValueToString("tenement"));
subareavec1.addElement(result.getColumnValueToString("subarea"));
buildingvec1.addElement(result.getColumnValueToString("building"));
stairvec1.addElement(result.getColumnValueToString("stair"));
floorvec1.addElement(result.getColumnValueToString("floor"));
cellvec1.addElement(result.getColumnValueToString("cell"));
datevec1.addElement(result.getColumnValueToString("date"));
acceptmanvec1.addElement(result.getColumnValueToString("acceptman"));
exponentvec1.addElement(result.getColumnValueToString("exponent"));
if(result.getColumnValue("nextman") == null)
nextmanvec1.addElement("");
else
nextmanvec1.addElement(result.getColumnValueToString("nextman"));
if(result.getColumnValue("treatidea") == null)
treatideavec1.addElement("");
else
treatideavec1.addElement(result.getColumnValueToString("treatidea"));
if(result.getColumnValue("overdate") == null)
overdatevec1.addElement("不详");
else
overdatevec1.addElement(result.getColumnValueToString("overdate"));
if(result.getColumnValueToString("sign").equals("0"))
signvec1.addElement("未处理");
else
signvec1.addElement("已处理");
String s = "";
s = result.getColumnValueToString("date").substring(5, 7) + "_TS_" + result.getColumnValueToString("number");
soundnovec1.addElement(s);
}
setStatusCode(0x757b4);
setStatusMessage("查询所有投诉意见记录成功");
} else
{
setStatusCode(0x757b5);
setStatusMessage("对不起，没有符合条件的投诉意见记录");
}
}
catch(Exception exception1)
{
setStatusCode(0x757b6);
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 setSelect02(String s)
{
select02 = s;
}
public void setStair(String s)
{
stair = s;
}
public void setSubarea(String s)
{
subarea = s;
}
public void setTenement(String s)
{
tenement = 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;
default:
setSelect02((String)allSqlStatement.elementAt(0));
break;
}
}
public void setTreatidea(String s)
{
treatidea = 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 + -