📄 treedemo.java
字号:
}
public ArrayList getElecInfoAddrAndElecMeterRegNo(String isInsert , String organofuser) {
ArrayList list = new ArrayList();
DBPoolManager db = new DBPoolManager();
db.getConnection();
try {
String sAddr = null;
String sqlAddr = "select distinct(addr) from ElecInfo where OrganId in ( Select organid from organ Connect by prior organid=suporganid Start with organid = " + organofuser + " ) order by addr";
Statement stmt = db.conn.createStatement();
ResultSet rest = stmt.executeQuery(sqlAddr);
Hashtable htAddr = new Hashtable();
htAddr.put("OrganID", "1");
htAddr.put("SupOrganID", "0");
htAddr.put("OrganName", "所有地址");
list.add(htAddr);
int i = 11;
while (rest.next()) {
Hashtable hash = new Hashtable();
sAddr = rest.getString("addr");
if(sAddr == null || sAddr.equals("")) {
continue;
}
sAddr = sAddr.trim();
hash.put("OrganID", String.valueOf(i));
hash.put("SupOrganID", "1");
hash.put("OrganName", sAddr);
// 得到地址下的户号
String sUserID = null;
String sqlUserID = "select userId from ElecInfo where addr='" + sAddr + "' order by userId Desc";
Statement stmtUserID = db.conn.createStatement();
ResultSet restUserID = stmtUserID.executeQuery(sqlUserID);
int iUser = 1;
while (restUserID.next()) {
sUserID = restUserID.getString("userId");
sUserID = sUserID.trim();
// 得到电表编号
if(isInsert.equals("yes")) {
Hashtable hashNo = new Hashtable();
hashNo.put("OrganID", String.valueOf(i * 10 + iUser));
hashNo.put("SupOrganID", i);
hashNo.put("OrganName", sUserID);
list.add(hashNo);
} else {
String sNo = null;
String sqlNo = "select ElecMeterRegNo from ElecMeter_Info where UserId='" + sUserID + "' order by ElecMeterRegNo Desc";
Statement stmtNo = db.conn.createStatement();
ResultSet restNo = stmtNo.executeQuery(sqlNo);
while (restNo.next()) {
Hashtable hashNo = new Hashtable();
sNo = restNo.getString("ElecMeterRegNo");
sNo = sNo.trim();
hashNo.put("OrganID", String.valueOf(i * 10 + iUser));
hashNo.put("SupOrganID", i);
hashNo.put("OrganName", sNo);
list.add(hashNo);
iUser++;
}
restNo.close();
stmtNo.close();
}
iUser++;
}
restUserID.close();
stmtUserID.close();
list.add(hash);
i++;
}
rest.close();
stmt.close();
} catch (SQLException ex) {
//System.err.println("Get OrganTree SQLException: " + ex.toString());
ex.printStackTrace();
} catch(Exception e) {
e.printStackTrace();
} finally {
db.freeConnection();
}
return list;
}
// 得到单位和该单位下的所有电表编号
public ArrayList getElecInfoDepaAndElecMeterRegNo(String isInsert) {
ArrayList list = new ArrayList();
DBPoolManager db = new DBPoolManager();
db.getConnection();
try {
String sAddr = null;
String sqlAddr = "select distinct(Depa) from ElecInfo order by depa";
Statement stmt = db.conn.createStatement();
ResultSet rest = stmt.executeQuery(sqlAddr);
Hashtable htAddr = new Hashtable();
htAddr.put("OrganID", "1");
htAddr.put("SupOrganID", "0");
htAddr.put("OrganName", "所有单位");
list.add(htAddr);
int i = 11;
while (rest.next()) {
Hashtable hash = new Hashtable();
sAddr = rest.getString("Depa");
if(sAddr == null || sAddr.equals("")) {
continue;
}
sAddr = sAddr.trim();
hash.put("OrganID", String.valueOf(i));
hash.put("SupOrganID", "1");
hash.put("OrganName", sAddr);
// 得到地址下的户号
String sUserID = null;
String sqlUserID = "select userId from ElecInfo where Depa='" + sAddr + "' order by userId Desc";
Statement stmtUserID = db.conn.createStatement();
ResultSet restUserID = stmtUserID.executeQuery(sqlUserID);
int iUser = 1;
while (restUserID.next()) {
sUserID = restUserID.getString("userId");
sUserID = sUserID.trim();
// 得到电表编号
if(isInsert.equals("yes")) {
Hashtable hashNo = new Hashtable();
hashNo.put("OrganID", String.valueOf(i * 10 + iUser));
hashNo.put("SupOrganID", i);
hashNo.put("OrganName", sUserID);
list.add(hashNo);
} else {
String sNo = null;
String sqlNo = "select ElecMeterRegNo from ElecMeter_Info where UserId='" + sUserID + "' order by ElecMeterRegNo Desc";
Statement stmtNo = db.conn.createStatement();
ResultSet restNo = stmtNo.executeQuery(sqlNo);
while (restNo.next()) {
Hashtable hashNo = new Hashtable();
sNo = restNo.getString("ElecMeterRegNo");
sNo = sNo.trim();
hashNo.put("OrganID", String.valueOf(i * 10 + iUser));
hashNo.put("SupOrganID", i);
hashNo.put("OrganName", sNo);
list.add(hashNo);
iUser++;
}
restNo.close();
stmtNo.close();
}
iUser++;
}
restUserID.close();
stmtUserID.close();
list.add(hash);
i++;
}
rest.close();
stmt.close();
} catch (SQLException ex) {
//System.err.println("Get OrganTree SQLException: " + ex.toString());
ex.printStackTrace();
} catch(Exception e) {
e.printStackTrace();
} finally {
db.freeConnection();
}
return list;
}
public ArrayList getElecInfoDepaAndElecMeterRegNo(String isInsert , String organofuser) {
ArrayList list = new ArrayList();
DBPoolManager db = new DBPoolManager();
db.getConnection();
try {
String sAddr = null;
String sqlAddr = "select distinct(Depa) from ElecInfo where OrganId in ( Select organid from organ Connect by prior organid=suporganid Start with organid = " + organofuser + " ) order by depa";
Statement stmt = db.conn.createStatement();
ResultSet rest = stmt.executeQuery(sqlAddr);
Hashtable htAddr = new Hashtable();
htAddr.put("OrganID", "1");
htAddr.put("SupOrganID", "0");
htAddr.put("OrganName", "所有单位");
list.add(htAddr);
int i = 11;
while (rest.next()) {
Hashtable hash = new Hashtable();
sAddr = rest.getString("Depa");
if(sAddr == null || sAddr.equals("")) {
continue;
}
sAddr = sAddr.trim();
hash.put("OrganID", String.valueOf(i));
hash.put("SupOrganID", "1");
hash.put("OrganName", sAddr);
// 得到地址下的户号
String sUserID = null;
String sqlUserID = "select userId from ElecInfo where Depa='" + sAddr + "' order by userId Desc";
Statement stmtUserID = db.conn.createStatement();
ResultSet restUserID = stmtUserID.executeQuery(sqlUserID);
int iUser = 1;
while (restUserID.next()) {
sUserID = restUserID.getString("userId");
sUserID = sUserID.trim();
// 得到电表编号
if(isInsert.equals("yes")) {
Hashtable hashNo = new Hashtable();
hashNo.put("OrganID", String.valueOf(i * 10 + iUser));
hashNo.put("SupOrganID", i);
hashNo.put("OrganName", sUserID);
list.add(hashNo);
} else {
String sNo = null;
String sqlNo = "select ElecMeterRegNo from ElecMeter_Info where UserId='" + sUserID + "' order by ElecMeterRegNo Desc";
Statement stmtNo = db.conn.createStatement();
ResultSet restNo = stmtNo.executeQuery(sqlNo);
while (restNo.next()) {
Hashtable hashNo = new Hashtable();
sNo = restNo.getString("ElecMeterRegNo");
sNo = sNo.trim();
hashNo.put("OrganID", String.valueOf(i * 10 + iUser));
hashNo.put("SupOrganID", i);
hashNo.put("OrganName", sNo);
list.add(hashNo);
iUser++;
}
restNo.close();
stmtNo.close();
}
iUser++;
}
restUserID.close();
stmtUserID.close();
list.add(hash);
i++;
}
rest.close();
stmt.close();
} catch (SQLException ex) {
//System.err.println("Get OrganTree SQLException: " + ex.toString());
ex.printStackTrace();
} catch(Exception e) {
e.printStackTrace();
} finally {
db.freeConnection();
}
return list;
}
// 得到用户和该用户下的所有用电设备编号
public ArrayList getElecInfoUserAndElecDevNo() {
ArrayList list = new ArrayList();
DBPoolManager db = new DBPoolManager();
db.getConnection();
try {
String s = null;
String sql = "select 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", "用户下的用电设备编号");
ht.put("SupName", "null");
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);
hash.put("SupName", s);
// 得到电表编号
String sNo = null;
String sqlNo = "select ElecDevNo from ElecDev_info where UserId='" + s + "' order by ElecDevNo Desc";
Statement stmtNo = db.conn.createStatement();
ResultSet restNo = stmtNo.executeQuery(sqlNo);
int iUser = 1;
while (restNo.next()) {
Hashtable hashUser = new Hashtable();
sNo = restNo.getString("ElecDevNo");
sNo = sNo.trim();
hashUser.put("OrganID", String.valueOf(i * 10 + iUser));
hashUser.put("SupOrganID", i);
hashUser.put("OrganName", sNo);
hashUser.put("SupName", s);
//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 getElecInfoUserAndElecDevNo(String orus) {
ArrayList list = new ArrayList();
DBPoolManager db = new DBPoolManager();
db.getConnection();
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 = " + orus + " ) 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", "用户下的用电设备编号");
ht.put("SupName", "null");
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);
hash.put("SupName", s);
// 得到电表编号
String sNo = null;
String sqlNo = "select ElecDevNo from ElecDev_info where UserId='" + s + "' order by ElecDevNo Desc";
Statement stmtNo = db.conn.createStatement();
ResultSet restNo = stmtNo.executeQuery(sqlNo);
int iUser = 1;
while (restNo.next()) {
Hashtable hashUser = new Hashtable();
sNo = restNo.getString("ElecDevNo");
sNo = sNo.trim();
hashUser.put("OrganID", String.valueOf(i * 10 + iUser));
hashUser.put("SupOrganID", i);
hashUser.put("OrganName", sNo);
hashUser.put("SupName", s);
//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;
}
// zy
// 得到用户和该用户下的所有用电设备类型
public ArrayList getElecDevChkIdAndChkDevType() {
ArrayList list = new ArrayList();
DBPoolManager db = new DBPoolManager();
db.getConnection();
try {
String s = null;
String sql = "select 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", "户号下的设备类型");
ht.put("SupOrganName", "根");
ht.put("TypeName", "null");
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);
hash.put("SupOrganName", "户号下的设备类型");
hash.put("TypeName", "null");
// 得到设备类型
String sNo = null;
String sTypeName = null; // 类型名称
// String sqlNo = "select ElecDevTypeNo from ElecDev_info where UserId='" + s + "' order by ElecDevTypeNo Desc";
String sqlNo = "select distinct(e4.ElecDevTypeNo),e3.elecdevtypename from ElecDev_info e4,ElecDev_Type e3 " +
"where e4.elecdevtypeno=e3.elecdevtypeno and UserId='" + s + "' order by ElecDevTypeNo Desc";
Statement stmtNo = db.conn.createStatement();
ResultSet restNo = stmtNo.executeQuery(sqlNo);
int iUser = 1;
while (restNo.next()) {
⌨️ 快捷键说明
复制代码
Ctrl + C
搜索代码
Ctrl + F
全屏模式
F11
切换主题
Ctrl + Shift + D
显示快捷键
?
增大字号
Ctrl + =
减小字号
Ctrl + -