?? departmentbean.java
字號:
}
int cols = rsmd.getColumnCount();
hash.clear();
for (int i = 1; i <= cols; i++) {
String field = ds.toString(rsmd.getColumnName(i));
String value = ds.toString(rs.getString(i));
hash.put(field, value);
}
}catch(Exception e){System.out.println("DepartmentBean.buildTree(String)運行時出錯："+e);}
finally{
if(rs!=null)try{ stmt = rs.getStatement(); rs.close();}catch(Exception e){System.out.println("DepartmentBean.buildTree(String)關閉記錄集rs時出錯"+e);}
if(stmt!=null) try{stmt.close();}catch(Exception e){System.out.println("DepartmentBean.buildTree(String)關閉聲明時statement出錯"+e);}
}
DefaultMutableTreeNode root = new DefaultMutableTreeNode(hash);
buildSubTree(root);
return root;
}
public DefaultMutableTreeNode buildMyTree(String sql){
ResultSet rs = selectRecord(sql);
Hashtable hash = new Hashtable();
Statement stmt = null;
try{
ResultSetMetaData rsmd = rs.getMetaData();
// 結果集為空時返回
if (!(rs.next())) {
//System.err.println("數據表錯誤：根為空。");
return null;
}
int cols = rsmd.getColumnCount();
hash.clear();
for (int i = 1; i <= cols; i++) {
String field = ds.toString(rsmd.getColumnName(i));
String value = ds.toString(rs.getString(i));
hash.put(field, value);
}
}catch(Exception e){System.out.println("DepartmentBean.buildMyTree(String)運行時出錯："+e);}
finally{
if(rs!=null)try{ stmt = rs.getStatement(); rs.close();}catch(Exception e){System.out.println("DepartmentBean.buildMyTree(String)關閉記錄集rs時出錯"+e);}
if(stmt!=null) try{stmt.close();}catch(Exception e){System.out.println("DepartmentBean.buildMyTree(String)關閉聲明時statement出錯"+e);}
}
DefaultMutableTreeNode root = new DefaultMutableTreeNode(hash);
buildSubTree(root);
return root;
}
//迭代生成樹
private void buildSubTree(DefaultMutableTreeNode rootNode)
{
String sql = "";
String DepartNo = "";
DefaultMutableTreeNode root = rootNode;
DefaultMutableTreeNode treeNode;
//選出rootNode的子節點
DepartNo = (String) ((Hashtable) rootNode.getUserObject()).get("BMBH");
sql =
" Select BMBH,BMFBH,BMMC,JBXH from ZZ_BMB "
+ " Where BMFBH='"
+ DepartNo
+ "' "
+ " and BMZT=0 order by JBXH ";
ResultSet rs = selectRecord(sql);
Statement stmt = null;
try{
ResultSetMetaData rsmd = rs.getMetaData();
int cols = rsmd.getColumnCount();
while (rs.next()) {
Hashtable hash = new Hashtable();
for (int i = 1; i <= cols; i++) {
String field = ds.toString(rsmd.getColumnName(i));
String value = ds.toString(rs.getString(i));
hash.put(field, value);
}
treeNode = new DefaultMutableTreeNode(hash);
root.add(treeNode);
buildSubTree(treeNode);
}
}catch(Exception e){System.out.println("DepartmentBean.buildSubTree(root)運行時出錯："+e);}
finally{
if(rs!=null)try{ stmt = rs.getStatement(); rs.close();}catch(Exception e){System.out.println("DepartmentBean.buildSubTree(root)關閉記錄集rs時出錯"+e);}
if(stmt!=null) try{stmt.close();}catch(Exception e){System.out.println("DepartmentBean.buildSubTree(root)關閉聲明時statement出錯"+e);}
}
}
//得到當前部門所有的職務名稱
public Vector getOrgDutys()
{
Vector vt = new Vector();
String sql = "";
sql = " select ZWBH,ZWMC from ZZ_ZWB where BMBH='"+ depNo +"' and ZWZT=0 order by JBXH ";
ResultSet rs = selectRecord(sql);
Hashtable ht = new Hashtable();
Statement stmt = null;
try{
while (rs.next())
{
String zwNO = ds.toString(rs.getString(1));
String zwName = ds.toString(rs.getString(2));
ht = new Hashtable();
ht.put("ZWBH", zwNO);
ht.put("ZWMC", zwName);
vt.add(ht);
}
}catch(Exception e){System.out.println("DepartmentBean.getOrgDutys()運行時出錯："+e);}
finally{
if(rs!=null)try{ stmt = rs.getStatement(); rs.close();}catch(Exception e){System.out.println("DepartmentBean.getOrgDutys()關閉記錄集rs時出錯"+e);}
if(stmt!=null) try{stmt.close();}catch(Exception e){System.out.println("DepartmentBean.getOrgDutys()關閉聲明時statement出錯"+e);}
}
return vt;
}
//查詢某部門職務信息
public Vector getArr()
{
String sql = " select * from ZZ_ZWB where BMBH='"+ depNo + "' order by JBXH,ZWBH";
ResultSet rs = selectRecord(sql);
Vector vt = new Vector();
Statement stmt = null;
try{
ResultSetMetaData rsmd = rs.getMetaData();
int cols = rsmd.getColumnCount();
int recsum = 0;
while (rs.next())
{
recsum++;
for(int i=1;i<=cols;i++)
{
Hashtable ht = new Hashtable();
String field = ds.toString(rsmd.getColumnName(i));
String value = ds.toString(rs.getString(i));
ht.put(field,value);
vt.add(ht);
}
}
vt.add(new Integer(recsum));
}catch(Exception e){System.out.println("DepartmentBean.getArr()運行時出錯："+e);}
finally{
if(rs!=null)try{ stmt = rs.getStatement(); rs.close();}catch(Exception e){System.out.println("DepartmentBean.getArr()關閉記錄集rs時出錯"+e);}
if(stmt!=null) try{stmt.close();}catch(Exception e){System.out.println("DepartmentBean.getArr()關閉聲明時statement出錯"+e);}
}
return vt;
}
//生成新增紀錄的'部門編號'
private String makeNewNo(String fatherNo){
String bmNo = "", maxNo = "00000000000000000000";
long lbmNo = -1, lmaxNo = -1;
String sql = "select BMBH from ZZ_BMB where BMFBH=" + fatherNo;
ResultSet rs = db.QuerySQL(sql);
boolean flg = false;
Statement stmt = null;
try{
while (rs.next()) { //取得本部門最大編號
bmNo = ds.toString(rs.getString("BMBH"));
lbmNo = Long.parseLong(bmNo);
if (lbmNo > lmaxNo) {
lmaxNo = lbmNo;
maxNo = bmNo;
}
flg = true;
}
}catch(Exception e){System.out.println("DepartmentBean.makeNewNo(String)運行時出錯："+e);}
finally{
if(rs!=null)try{ stmt = rs.getStatement(); rs.close();}catch(Exception e){System.out.println("DepartmentBean.makeNewNo(String)關閉記錄集rs時出錯"+e);}
if(stmt!=null) try{stmt.close();}catch(Exception e){System.out.println("DepartmentBean.makeNewNo(String)關閉聲明時statement出錯"+e);}
}
//生成加1的20位編號
int index = -1;
String strchar = "";
String newNo = "";
int subno = -1;
if (flg) {
for (int i = 19; i > 1; i--) {
char data[] = { maxNo.charAt(i)};
strchar = new String(data);
if (!strchar.equals("0")) {
index = i;
flg = true;
break;
}
}
if (index % 2 == 0) {
newNo = maxNo.substring(0, index);
newNo =
newNo.concat(
String.valueOf(
Integer.parseInt(maxNo.substring(index, index + 2))
+ 1));
newNo = newNo.concat(maxNo.substring(index + 2));
}
if (index % 2 != 0) {
newNo = maxNo.substring(0, index - 1);
subno =
Integer.parseInt(maxNo.substring(index - 1, index + 1)) + 1;
if (subno < 10) //單個位數在前面加0
newNo = newNo + "0" + String.valueOf(subno);
else
newNo = newNo + String.valueOf(subno);
newNo = newNo.concat(maxNo.substring(index + 1));
}
} else {
maxNo = fatherNo;
if (maxNo.equals("00000000000000000000")) {
newNo = "00010000000000000000";
} else {
for (int i = 19; i > 1; i--) {
char data[] = { maxNo.charAt(i)};
strchar = new String(data);
if (!strchar.equals("0")) {
index = i;
break;
}
}
if (index % 2 == 0) {
index += 3;
} else {
index += 2;
}
if (index % 2 == 0) {
newNo = maxNo.substring(0, index);
newNo =
newNo.concat(
String.valueOf(
Integer.parseInt(
maxNo.substring(index, index + 2))
+ 1));
newNo = newNo.concat(maxNo.substring(index + 2));
}
if (index % 2 != 0) {
newNo = maxNo.substring(0, index - 1);
subno =
Integer.parseInt(maxNo.substring(index - 1, index + 1))
+ 1;
if (subno < 10) //單個位數在前面加0
newNo = newNo + "0" + String.valueOf(subno);
else
newNo = newNo + String.valueOf(subno);
newNo = newNo.concat(maxNo.substring(index + 1));
}
}
}
return newNo;
}
public int addRec(Hashtable ht,boolean rebuild){
String fatherNo = ds.toString((String) ht.get("BMFBH"));
String bmName = ds.toString((String) ht.get("BMMC"));
String jbNo = ds.toString((String) ht.get("JBXH"));
String bossNo = ds.toString((String) ht.get("TZWBH"));
// String admin = ds.toString((String) ht.get("GLYZWBH"));
// String ws = ds.toString((String) ht.get("WSZWBH"));
//String ckqx = ds.toString((String) ht.get("CKQX"));
String newNo = makeNewNo(fatherNo);
String sqlno =
"select ZWBH from ZZ_ZWB where BMBH='"
+ fatherNo
+ "' and ZWMC='"
+ bossNo
+ "'";
ResultSet rs = selectRecord(sqlno);
Statement stmt = null;
try{
if (rs.next()) {
bossNo = ds.toString(rs.getString("ZWBH"));
}
}catch(Exception e){System.out.println("DepartmentBean.addRec(Hashtable)運行時出錯："+e);}
finally{
if(rs!=null)try{ stmt = rs.getStatement(); rs.close();}catch(Exception e){System.out.println("epartmentBean.addRec(Hashtable)關閉記錄集rs時出錯"+e);}
if(stmt!=null) try{stmt.close();}catch(Exception e){System.out.println("epartmentBean.addRec(Hashtable)關閉聲明時statement出錯"+e);}
}
if (bossNo.equals("") || bossNo == null)
bossNo = "-1";
//檢驗同意部門下部門名稱是否已經存在
ResultSet rst =
selectRecord(
"select BMBH from ZZ_BMB where BMMC='"
+ bmName
+ "' and BMFBH='"
+ fatherNo
+ "' and BMZT=0");
System.out.println(
"select BMBH from ZZ_BMB where BMMC='"
+ bmName
+ "' and BMFBH='"
+ fatherNo
+ "' and BMZT=0");
try{
if (rst.next()){
return 1;
}
}catch(Exception e){System.out.println("DepartmentBean.addRec(Hashtable)運行時出錯："+e);}
finally{
if(rst!=null)try{ stmt = rst.getStatement(); rst.close();}catch(Exception e){System.out.println("DepartmentBean.addRec(Hashtable)關閉記錄集rs時出錯"+e);}
if(stmt!=null) try{stmt.close();}catch(Exception e){System.out.println("DepartmentBean.addRec(Hashtable)關閉聲明時statement出錯"+e);}
}
/////////////////
int maxjbNo=makeID("ZZ_BMB","BMFBH","BMZT","JBXH",fatherNo,"0",false,true);
int jbxh=0;
if(!jbNo.equals(""))
jbxh=Integer.parseInt(jbNo);
if(jbxh==0||jbxh>maxjbNo)
{ jbxh=maxjbNo;jbNo=""+jbxh;}
//////////////////////
String sql="update ZZ_BMB set jbxh=jbxh+1 where BMFBH='"+ fatherNo + "' and BMZT=0 and JBXH >=" + jbxh ;
deleteRecord(sql);
//////////////////////
Vector sqlvt = new Vector();
sqlvt.add("ZZ_BMB");
sqlvt.add(addVector("BMBH", newNo, "CHAR"));
sqlvt.add(addVector("BMFBH", fatherNo, "CHAR"));
sqlvt.add(addVector("BMMC", bmName, "CHAR"));
sqlvt.add(addVector("TZWBH", bossNo, "CHAR"));
sqlvt.add(addVector("JBXH", jbNo, "CHAR"));
// sqlvt.add(addVector("GLYZWBH", admin, "CHAR"));
// sqlvt.add(addVector("WSZWBH", ws, "CHAR"));
sqlvt.add(addVector("BMZT", "0", "NUM"));
//sqlvt.add(addVector("CKQX",strMax,"CHAR"));
insertRecord(sqlvt);
//////////////////////
ResultSet rs1 = null;
int i=0;
rs = selectRecord("select XMMC from CODE_ZDB where ZDMC='默認職務' and SYZT=0 order by JBXH");
try{
while(rs.next())
{
int zwbh=makeID("ZZ_ZWB","BMBH","ZWBH",""+newNo,false);
String zwmc=rs.getString("XMMC");
String czqx = "";
if(zwmc.equals("主管領導")){
rs1 = selectRecord("select XMMC from CODE_ZDB where ZDMC='操作權限主管領導'");
if(rs1.next())
czqx = rs1.getString("XMMC");
}
else if(zwmc.equals("分管領導")){
rs1 = selectRecord("select XMMC from CODE_ZDB where ZDMC='操作權限分管領導'");
if(rs1.next())
czqx = rs1.getString("XMMC");
}
sqlvt.clear();
sqlvt.add("ZZ_ZWB");
sqlvt.add(addVector("BMBH", newNo, "CHAR"));
sqlvt.add(addVector("ZWBH", ""+zwbh, "NUM"));
sqlvt.add(addVector("ZWMC", zwmc, "CHAR"));
sqlvt.add(addVector("CZQX", czqx, "CHAR"));
// sqlvt.add(addVector("LCQX", "", "CHAR"));
// sqlvt.add(addVector("PZCS", "", "CHAR"));
sqlvt.add(addVector("JBXH", ""+makeID("ZZ_ZWB","BMBH","JBXH",newNo,false), "NUM"));
sqlvt.add(addVector("ZWZT", "0", "CHAR"));
sqlvt.add(addVector("SFJC", "0", "NUM"));
insertRecord(sqlvt);
}
}catch(Exception e){System.out.println("DepartmentBean.addRec(Hashtable)運行時出錯："+e);}
finally{
if(rs!=null)try{ stmt = rs.getStatement(); rs.close();}catch(Exception e){System.out.println("DepartmentBean.addRec(Hashtable)關閉記錄集rs時出錯"+e);}
if(stmt!=null) try{stmt.close();}catch(Exception e){System.out.println("DepartmentBean.addRec(Hashtable)關閉聲明時statement出錯"+e);}
if(rs1!=null)try{ stmt = rs1.getStatement(); rs1.close();}catch(Exception e){System.out.println("DepartmentBean.addRec(Hashtable)關閉記錄集rs時出錯"+e);}
?? 快捷鍵說明
復制代碼
Ctrl + C
搜索代碼
Ctrl + F
全屏模式
F11
切換主題
Ctrl + Shift + D
顯示快捷鍵
?
增大字號
Ctrl + =
減小字號
Ctrl + -