📄 treedemo.java
字号:
package imis_hous.com.tree;
import java.sql.Connection;
import java.sql.ResultSet;
import java.sql.SQLException;
import java.sql.Statement;
import java.util.ArrayList;
import java.util.Hashtable;
import database.DBPoolManager;
public class TreeDemo {
// 锟矫碉拷锟矫伙拷
public ArrayList getElecInfoUser() {
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", "锟矫伙拷锟斤拷锟?");
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);
list.add(hash);
i++;
}
rest.close();
stmt.close();
} catch (SQLException ex) {
} finally {
db.freeConnection();
}
return list;
}
// 锟矫碉拷锟矫伙拷锟酵革拷锟矫伙拷锟铰碉拷锟斤拷锟叫碉拷锟斤拷锟?
public ArrayList getElecInfoUserAndElecMeterRegNo() {
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", "锟矫伙拷锟铰的碉拷锟斤拷锟?");
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 ElecMeterRegNo from ElecMeter_Info where UserId='" + s + "' order by ElecMeterRegNo Desc";
Statement stmtNo = db.conn.createStatement();
ResultSet restNo = stmtNo.executeQuery(sqlNo);
int iUser = 1;
while (restNo.next()) {
Hashtable hashUser = new Hashtable();
sNo = restNo.getString("ElecMeterRegNo");
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) {
} finally {
db.freeConnection();
}
return list;
}
// 锟矫碉拷锟斤拷址锟酵该碉拷址锟铰碉拷锟斤拷锟叫碉拷锟斤拷锟?
public ArrayList getElecInfoAddrAndElecMeterRegNo() {
ArrayList list = new ArrayList();
DBPoolManager db = new DBPoolManager();
db.getConnection();
try {
String sAddr = null;
String sqlAddr = "select distinct(addr) from ElecInfo 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");
sAddr = sAddr.trim();
//System.out.println("Add = " + sAddr);
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();
// 锟矫碉拷锟斤拷锟斤拷锟?
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);
//System.out.println("UserID = " + sUser);
list.add(hashNo);
iUser++;
}
restNo.close();
stmtNo.close();
//System.out.println("UserID = " + sUser);
iUser++;
}
restUserID.close();
stmtUserID.close();
list.add(hash);
i++;
}
rest.close();
stmt.close();
} catch (SQLException ex) {
} finally {
db.freeConnection();
}
return list;
}
// 锟矫碉拷锟斤拷位锟酵该碉拷位锟铰碉拷锟斤拷锟叫碉拷锟斤拷锟?
public ArrayList getElecInfoDepaAndElecMeterRegNo() {
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");
sAddr = sAddr.trim();
//System.out.println("Add = " + sAddr);
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();
// 锟矫碉拷锟斤拷锟斤拷锟?
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);
//System.out.println("UserID = " + sUser);
list.add(hashNo);
iUser++;
}
restNo.close();
stmtNo.close();
//System.out.println("UserID = " + sUser);
iUser++;
}
restUserID.close();
stmtUserID.close();
list.add(hash);
i++;
}
rest.close();
stmt.close();
} catch (SQLException ex) {
} 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", "锟矫伙拷锟铰碉拷锟矫碉拷锟借备锟斤拷锟?");
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 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);
//System.out.println("UserID = " + sUser);
list.add(hashUser);
iUser++;
}
restNo.close();
stmtNo.close();
list.add(hash);
i++;
}
rest.close();
stmt.close();
} catch (SQLException ex) {
} finally {
db.freeConnection();
}
return list;
}
}
⌨️ 快捷键说明
复制代码
Ctrl + C
搜索代码
Ctrl + F
全屏模式
F11
切换主题
Ctrl + Shift + D
显示快捷键
?
增大字号
Ctrl + =
减小字号
Ctrl + -