📄 treedemo.java
字号:
Hashtable hashUser = new Hashtable();
sNo = restNo.getString("ElecDevTypeNo");
sNo = sNo.trim();
sTypeName = restNo.getString("elecdevtypename");
sTypeName = sTypeName.trim();
hashUser.put("OrganID", String.valueOf(i * 10 + iUser));
hashUser.put("SupOrganID", i);
hashUser.put("OrganName", sNo);
hashUser.put("SupOrganName", s);
hashUser.put("TypeName", sTypeName);
//System.out.println("UserID = " + sUser);
list.add(hashUser);
iUser++;
}
restNo.close();
stmtNo.close();
list.add(hash);
i++;
}
rest.close();
stmt.close();
} catch (SQLException ex) {
//System.err.println("Get OrganTree SQLException: " + ex.toString());
ex.printStackTrace();
} finally {
db.freeConnection();
}
return list;
}
//得到用电检查派单id
public ArrayList getElecDevChkId() {
ArrayList list = new ArrayList();
DBPoolManager db = new DBPoolManager();
db.getConnection();
try {
String s = null;
String sql = "select distinct UserId from ElecInfo order by UserId Desc";
Statement stmt = db.conn.createStatement();
ResultSet rest = stmt.executeQuery(sql);
Hashtable ht = new Hashtable();
ht.put("OrganID", "1");
ht.put("SupOrganID", "0");
ht.put("OrganName", "户号下的检查单编号");
list.add(ht);
int i = 11;
while (rest.next()) {
Hashtable hash = new Hashtable();
s = rest.getString("UserId");
s = s.trim();
hash.put("OrganID", String.valueOf(i));
hash.put("SupOrganID", "1");
hash.put("OrganName", s);
//System.out.println("s="+s);
// 得到检查单编号
String sNo = null;
String sqlNo = "select ElecDevChkId from ElecDev_Chk where UserId='"+s+"' order by ElecDevChkId Desc";
Statement stmtNo = db.conn.createStatement();
ResultSet restNo = stmtNo.executeQuery(sqlNo);
int iUser = 1;
while (restNo.next()) {
Hashtable hashUser = new Hashtable();
sNo = restNo.getString("ElecDevChkId");
sNo = sNo.trim();
hashUser.put("OrganID", String.valueOf(i * 10 + iUser));
hashUser.put("SupOrganID", i);
hashUser.put("OrganName", sNo);
//System.out.println("UserID = " + sNo);
list.add(hashUser);
iUser++;
}
restNo.close();
stmtNo.close();
list.add(hash);
i++;
}
rest.close();
stmt.close();
} catch (SQLException ex) {
//System.err.println("Get OrganTree SQLException: " + ex.toString());
ex.printStackTrace();
} finally {
db.freeConnection();
}
return list;
}
public ArrayList getElecDevChkId(String organofuser) {
ArrayList list = new ArrayList();
DBPoolManager db = new DBPoolManager();
db.getConnection();
//System.out.println(organofuser);
try {
String s = null;
String sql = "select userId from ElecInfo where OrganId in ( Select organid from organ Connect by prior organid=suporganid Start with organid = " + organofuser + " ) order by userId Desc";
Statement stmt = db.conn.createStatement();
ResultSet rest = stmt.executeQuery(sql);
//System.out.println(sql);
Hashtable ht = new Hashtable();
ht.put("OrganID", "1");
ht.put("SupOrganID", "0");
ht.put("OrganName", "户号下的检查单编号");
list.add(ht);
int i = 11;
while (rest.next()) {
Hashtable hash = new Hashtable();
s = rest.getString("UserId");
s = s.trim();
hash.put("OrganID", String.valueOf(i));
hash.put("SupOrganID", "1");
hash.put("OrganName", s);
//System.out.println("s="+s);
// 得到检查单编号
String sNo = null;
String sqlNo = "select ElecDevChkId from ElecDev_Chk where UserId='"+s+"' order by ElecDevChkId Desc";
Statement stmtNo = db.conn.createStatement();
ResultSet restNo = stmtNo.executeQuery(sqlNo);
int iUser = 1;
while (restNo.next()) {
Hashtable hashUser = new Hashtable();
sNo = restNo.getString("ElecDevChkId");
sNo = sNo.trim();
hashUser.put("OrganID", String.valueOf(i * 10 + iUser));
hashUser.put("SupOrganID", i);
hashUser.put("OrganName", sNo);
//System.out.println("UserID = " + sNo);
list.add(hashUser);
iUser++;
}
restNo.close();
stmtNo.close();
list.add(hash);
i++;
}
rest.close();
stmt.close();
} catch (SQLException ex) {
//System.err.println("Get OrganTree SQLException: " + ex.toString());
ex.printStackTrace();
} finally {
db.freeConnection();
}
return list;
}
//得到维修派单表id
public ArrayList getElecDevRepId() {
ArrayList list = new ArrayList();
DBPoolManager db = new DBPoolManager();
db.getConnection();
try {
String s = null;
String sql = "select distinct UserId from ElecInfo order by UserId Desc";
Statement stmt = db.conn.createStatement();
ResultSet rest = stmt.executeQuery(sql);
Hashtable ht = new Hashtable();
ht.put("OrganID", "1");
ht.put("SupOrganID", "0");
ht.put("OrganName", "户号下的维修单编号");
list.add(ht);
int i = 11;
while (rest.next()) {
Hashtable hash = new Hashtable();
s = rest.getString("UserId");
s = s.trim();
hash.put("OrganID", String.valueOf(i));
hash.put("SupOrganID", "1");
hash.put("OrganName", s);
// 得到设备类型
String sNo = null;
String sqlNo = "select ElecDevRepId from ElecDev_Rep where UserId='"+s+"' order by ElecDevRepId Desc";
Statement stmtNo = db.conn.createStatement();
ResultSet restNo = stmtNo.executeQuery(sqlNo);
int iUser = 1;
while (restNo.next()) {
Hashtable hashUser = new Hashtable();
sNo = restNo.getString("ElecDevRepId");
sNo = sNo.trim();
hashUser.put("OrganID", String.valueOf(i * 10 + iUser));
hashUser.put("SupOrganID", i);
hashUser.put("OrganName", sNo);
//System.out.println("UserID = " + sUser);
list.add(hashUser);
iUser++;
}
restNo.close();
stmtNo.close();
list.add(hash);
i++;
}
rest.close();
stmt.close();
} catch (SQLException ex) {
//System.err.println("Get OrganTree SQLException: " + ex.toString());
ex.printStackTrace();
} finally {
db.freeConnection();
}
return list;
}
//得到用电设备类型号,给树用的
public ArrayList getElecDev_Type() {
ArrayList list = new ArrayList();
DBPoolManager db = new DBPoolManager();
db.getConnection();
try {
String s = null;
String t =null;
String sql = "select ElecDevTypeNo,ElecDevTypeName from ElecDev_Type order by ElecDevTypeNo Desc";
Statement stmt = db.conn.createStatement();
ResultSet rest = stmt.executeQuery(sql);
Hashtable ht = new Hashtable();
ht.put("OrganID", "1");
ht.put("SupOrganID", "0");
ht.put("OrganName", "用电设备类型号");
ht.put("TypeName","null");
list.add(ht);
int i = 11;
while (rest.next()) {
Hashtable hash = new Hashtable();
s = rest.getString("ElecDevTypeNo");
t=rest.getString("ElecDevTypeName");
s = s.trim();
t = t.trim();
hash.put("OrganID", String.valueOf(i));
hash.put("SupOrganID", "1");
hash.put("OrganName", s);
hash.put("TypeName", t);
list.add(hash);
i++;
}
rest.close();
stmt.close();
} catch (SQLException ex) {
//System.err.println("Get OrganTree SQLException: " + ex.toString());
ex.printStackTrace();
} finally {
db.freeConnection();
}
return list;
}
// 得到用电设备类型号,给页面用的
public HashMap getElecDev_TypeForTable() {
HashMap list = new HashMap();
DBPoolManager db = new DBPoolManager();
db.getConnection();
try {
String sql = "select ElecDevTypeNo,ElecDevTypeName from ElecDev_Type order by ElecDevTypeNo";
Statement stmt = db.conn.createStatement();
ResultSet rest = stmt.executeQuery(sql);
while (rest.next()) {
list.put(rest.getInt("ElecDevTypeNo"), rest.getString("ElecDevTypeName"));
}
rest.close();
stmt.close();
} catch (SQLException ex) {
//System.err.println("Get OrganTree SQLException: " + ex.toString());
ex.printStackTrace();
} finally {
db.freeConnection();
}
return list;
}
// 得到用电检查单的户号,给页面用的
public ArrayList getElecDev_UserIdForTable() {
ArrayList list = new ArrayList();
DBPoolManager db = new DBPoolManager();
db.getConnection();
try {
String sql = "select userId from ElecInfo order by userId Desc";
Statement stmt = db.conn.createStatement();
ResultSet rest = stmt.executeQuery(sql);
while (rest.next()) {
list.add(rest.getInt("userId"));
}
rest.close();
stmt.close();
} catch (SQLException ex) {
//System.err.println("Get OrganTree SQLException: " + ex.toString());
ex.printStackTrace();
} finally {
db.freeConnection();
}
return list;
}
// 得到六个月的信息
public ArrayList getSixMonth(String userId) {
ArrayList list = new ArrayList();
DBPoolManager db = new DBPoolManager();
db.getConnection();
Date date = new Date();
Calendar calendar = new GregorianCalendar();
calendar.setTime(date);
SimpleDateFormat format = new SimpleDateFormat("yyyy-MM");
calendar.add(Calendar.MONTH, -6);
String endDate = format.format(date);
String startDate = format.format(calendar.getTime());
try {
String sql = "SELECT e1.UserId,e2.ElecMeterRegNo,e2.NowReading,e2.ElecMeterReading,e2.ReadOn," +
"e2.XianLoss,e2.BianLoss,e2.TuiBu,e2.SumElec,e2.PriceUnit,e2.ReadDate,e2.ReMark,e2.Memo " +
"FROM ElecMeter_info e1,Elec_Use_Info e2 " +
"WHERE e1.ElecMeterRegNo=e2.ElecMeterRegNo and e1.UserId='" + userId +
"' and ReadDate between (to_date('" + startDate + "','yyyy-mm')) AND (to_date('" + endDate + "','yyyy-mm')) order by ElecMeterRegNo,ReadDate";
Statement stmt = db.conn.createStatement();
ResultSet rs = stmt.executeQuery(sql);
while (rs.next()) {
ElecUseInfoTO elecUseInfo = new ElecUseInfoTO();
elecUseInfo.setElecMeterRegNo(rs.getString("ElecMeterRegNo"));
elecUseInfo.setNowReading(rs.getDouble("NowReading"));
elecUseInfo.setElecMeterReading(rs.getDouble("ElecMeterReading"));
elecUseInfo.setReadOn(rs.getString("ReadOn"));
elecUseInfo.setXianLoss(rs.getDouble("XianLoss"));
elecUseInfo.setBianLoss(rs.getDouble("BianLoss"));
elecUseInfo.setTuiBu(rs.getDouble("TuiBu"));
elecUseInfo.setSumElec(rs.getDouble("SumElec"));
elecUseInfo.setPriceUnit(rs.getDouble("PriceUnit"));
elecUseInfo.setReadDate(rs.getDate("ReadDate").toString());
elecUseInfo.setReMark(rs.getInt("ReMark"));
elecUseInfo.setUserId(rs.getString("UserId"));
list.add(elecUseInfo);
}
rs.close();
stmt.close();
} catch (SQLException ex) {
//System.err.println("Get OrganTree SQLException: " + ex.toString());
ex.printStackTrace();
} finally {
db.freeConnection();
}
return list;
}
// 得到电表编号的单价,给页面用的
public String getPriceForTable(String elecMeterRegNo) {
DBPoolManager db = new DBPoolManager();
db.getConnection();
String priceUnit = "";
try {
// 得到电表编号的用电分类
String sql = "select UseElecType from ElecMeter_info where ElecMeterRegNo='" + elecMeterRegNo +"'";
Statement stmt = db.conn.createStatement();
ResultSet rest = stmt.executeQuery(sql);
int useElecType = -1;
while (rest.next()) {
useElecType = rest.getInt("UseElecType");
}
rest.close();
stmt.close();
// 得到电表编号的用电分类的单价
String sql2 = "select PriceUnit from Elec_Fee_info where ElecUseType=" + useElecType;
Statement stmt2 = db.conn.createStatement();
ResultSet rest2 = stmt2.executeQuery(sql2);
while (rest2.next()) {
priceUnit = String.valueOf(rest2.getDouble("PriceUnit"));
}
rest2.close();
stmt2.close();
} catch (SQLException ex) {
//System.err.println("Get OrganTree SQLException: " + ex.toString());
ex.printStackTrace();
} finally {
db.freeConnection();
}
return priceUnit;
}
// 得到户号下用电设备类型号,给页面用的
public HashMap getElecDev_TypeByUserId(String userId) {
HashMap list = new HashMap();
DBPoolManager db = new DBPoolManager();
db.getConnection();
try {
String sql = "select e4.ElecDevTypeNo,e3.elecdevtypename from ElecDev_info e4,ElecDev_Type e3 "+
"where e4.elecdevtypeno=e3.elecdevtypeno and UserId='"+userId+"' order by ElecDevTypeNo Desc";
Statement stmt = db.conn.createStatement();
ResultSet rest = stmt.executeQuery(sql);
while (rest.next()) {
list.put(rest.getInt("ElecDevTypeNo"), rest.getString("ElecDevTypeName"));
}
rest.close();
stmt.close();
} catch (SQLException ex) {
//System.err.println("Get OrganTree SQLException: " + ex.toString());
ex.printStackTrace();
} finally {
db.freeConnection();
}
return list;
}
}
⌨️ 快捷键说明
复制代码
Ctrl + C
搜索代码
Ctrl + F
全屏模式
F11
切换主题
Ctrl + Shift + D
显示快捷键
?
增大字号
Ctrl + =
减小字号
Ctrl + -