?? orgmenubean.java
字號(hào):
/**********************************************************
Copyright (C),2003-11-27, Beijing USTB.
All rights reserved.
Filename: OrgMenuBean.java
Author:鄒晨
Version 1.0
Date:2003-10-21
Description:部門(mén)子類(lèi):查詢(xún)、單條信息查詢(xún)、增加記錄、修改記錄、刪除記錄
Other:
Variable List:
1.int strID //菜單唯一編號(hào)
2.int strParentID //父菜單編號(hào)
Function List:
1.public MenuBean()//構(gòu)造函數(shù)
2.public void setID(String o)//設(shè)置菜單唯一編號(hào)
2.public void setParentID(String o)//設(shè)置父菜單編號(hào)
3.public Vector getData(String orgid)//根據(jù)部門(mén)編號(hào)取得此部門(mén)下的所有子類(lèi)的樹(shù)形結(jié)構(gòu)
4.puboic int addMenu(Hashtable hash)//新增子類(lèi)信息
5.public int updateMenu(Hashtable hash)//修改子類(lèi)信息
6.public int delMenu()//刪除子類(lèi)信息
7.public Vector getClass(String id)//取得所有信息
8.public Hashtable getUpCs(String id)//取得上一級(jí)父類(lèi)信息
9.public Vector getDownCs(String id)//取得下一級(jí)類(lèi)信息
10.public Vector getAllDownCs(String id)//取得所有下一級(jí)類(lèi)信息
11.public int setJBXH()//
12.public String toName();//根據(jù)編號(hào)取得名稱(chēng)
13.public String getDetailPath(String id)//取得當(dāng)前子類(lèi)位置
14.public boolean isChild(String orgid,String pid)//判斷是否有子類(lèi)
15 public String getID1();//取得一級(jí)類(lèi)別
16 public String getPathWithoutOrg();//取得當(dāng)前子類(lèi)位置(不含部門(mén)名稱(chēng))
History:
***********************************************************/
package oa.bean;
import java.text.*;
import java.util.*;
import java.lang.*;
import java.io.*;
import java.sql.*;
import oa.main.*;
import javax.swing.tree.DefaultMutableTreeNode;
public class OrgMenuBean extends ParentBean
{
int strID=-1;//當(dāng)前類(lèi)唯一編號(hào)
int strParentID=-1;//父類(lèi)編號(hào)
String strOrgID="";
public void setID(int o)//設(shè)置菜單唯一編號(hào)
{
strID = o;
}
public void setParentID(int o)//設(shè)置父菜單編號(hào)
{
strParentID = o;
}
public void setOrgID(String o)//設(shè)置父菜單編號(hào)
{
strOrgID = o;
}
//根據(jù)職部門(mén)編號(hào)生成其子樹(shù)并返回根節(jié)點(diǎn)
public DefaultMutableTreeNode buildTree(String orgid)
{
String sql = "";
sql = "select * from news.ZZ_BMB where BMBH='"+orgid+"'";
Statement stmt = null;
Hashtable hash = new Hashtable();//存放部門(mén)信息
ResultSet rs = selectRecord(sql);
try{
ResultSetMetaData rsmd = rs.getMetaData();
int cols = rsmd.getColumnCount();
if(rs.next())
{
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("運(yùn)行時(shí)出錯(cuò)："+e);}
finally{
if(rs!=null)try{ stmt = rs.getStatement(); rs.close();}catch(Exception e){System.out.println("關(guān)閉記錄集rs時(shí)出錯(cuò)"+e);}
if(stmt!=null) try{stmt.close();}catch(Exception e){System.out.println("關(guān)閉聲明時(shí)statement出錯(cuò)"+e);}
}
DefaultMutableTreeNode root = new DefaultMutableTreeNode(hash);//建立樹(shù)根
//System.out.println("部門(mén)信息"+hash);
//開(kāi)始建立類(lèi)樹(shù)
String DepartNo = "";
String strPBH = "0";
DepartNo = (String)((Hashtable) root.getUserObject()).get("BMBH");
sql = "select * from news.orgmenu where BMBH = '"+DepartNo+"' and PBH = "+strPBH+" order by JBXH";
ResultSet rs1 = selectRecord(sql);
try{
ResultSetMetaData rsmd1 = rs1.getMetaData();
int cols1 = rsmd1.getColumnCount();
while(rs1.next())
{
Hashtable hash1 = new Hashtable();
hash1.clear();
for (int i = 1; i <= cols1; i++)
{
String field = ds.toString(rsmd1.getColumnName(i));
String value = ds.toString(rs1.getString(i));
hash1.put(field, value);
}
//System.out.println("一級(jí)類(lèi)別信息"+hash1);
DefaultMutableTreeNode treeNode = new DefaultMutableTreeNode(hash1);
root.add(treeNode);
buildSubTree(treeNode);
}
}catch(Exception e){System.out.println("運(yùn)行時(shí)出錯(cuò)："+e);}
finally{
if(rs1!=null)try{ stmt = rs1.getStatement(); rs1.close();}catch(Exception e){System.out.println("關(guān)閉記錄集rs時(shí)出錯(cuò)"+e);}
if(stmt!=null) try{stmt.close();}catch(Exception e){System.out.println("關(guān)閉聲明時(shí)statement出錯(cuò)"+e);}
}
return root;
}
//迭代生成樹(shù)
private void buildSubTree(DefaultMutableTreeNode rootNode)
{
String sql = "";
String DepartNo = "";
DefaultMutableTreeNode root = rootNode;
DefaultMutableTreeNode treeNode;
//選出rootNode的子節(jié)點(diǎn)
DepartNo = (String)((Hashtable) rootNode.getUserObject()).get("BMBH");
String strPBH = (String)((Hashtable) rootNode.getUserObject()).get("BH");
//System.out.println("DepartNo="+DepartNo);
//System.out.println("strPBH="+strPBH);
sql ="select * from news.orgmenu where BMBH = '"+DepartNo+"' and PBH = "+strPBH+" order by JBXH";
ResultSet rs = selectRecord(sql);
Statement stmt = null;
try{
ResultSetMetaData rsmd = rs.getMetaData();
int cols = rsmd.getColumnCount();
//System.out.println("dddddddddd");
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);
//System.out.println("二級(jí)類(lèi)別信息"+hash);
root.add(treeNode);
buildSubTree(treeNode);
}
}catch(Exception e){System.out.println("運(yùn)行時(shí)出錯(cuò)："+e);}
finally{
if(rs!=null)try{ stmt = rs.getStatement(); rs.close();}catch(Exception e){System.out.println("關(guān)閉記錄集rs時(shí)出錯(cuò)"+e);}
if(stmt!=null) try{stmt.close();}catch(Exception e){System.out.println("關(guān)閉聲明時(shí)statement出錯(cuò)"+e);}
}
}
//新增子類(lèi)信息
public int addMenu(Hashtable hash)
{
int intMax = makeID("ORGMENU","BH","","",true);
String strParentId = ds.toString((String)hash.get("PBH"));
String strOrgId = ds.toString((String)hash.get("BMBH"));
String strName = ds.toString((String)hash.get("MC"));
String strJBXH = ds.toString((String)hash.get("JBXH"));
if(strParentId.equals("")) strParentId = "0";
String sql ="";
sql = "select * from news.ORGMENU where BMBH = '"+strOrgId+"' and PBH = "+strParentId+" and MC = '"+strName+"'";
ResultSet rs = selectRecord(sql);
Statement stmt = null;
try{
if(rs.next())
return 1;
}
catch(Exception e){System.out.println("運(yùn)行時(shí)出錯(cuò):"+e);}
finally{
if(rs!=null)try{ stmt = rs.getStatement(); rs.close();}catch(Exception e){System.out.println("關(guān)閉記錄集rs時(shí)出錯(cuò)"+e);}
if(stmt!=null)try{stmt.close();}catch(Exception e){System.out.println("關(guān)閉聲明statement時(shí)出錯(cuò)；錯(cuò)誤為："+e);}
}
int intJBXH = setJBXH(strOrgId,strParentId,strJBXH);
Vector vect =new Vector();
vect.add("ORGMENU");
vect.add(addVector("BH",String.valueOf(intMax),"NUM"));
vect.add(addVector("PBH",strParentId,"NUM"));
vect.add(addVector("BMBH",strOrgId,"CHAR"));
vect.add(addVector("MC",strName,"CHAR"));
vect.add(addVector("JBXH",String.valueOf(intJBXH),"NUM"));
return insertRecord(vect);
}
//修改子類(lèi)信息
public int updateMenu(Hashtable hash)
{
String strId = ds.toString((String)hash.get("BH"));
String strParentId = ds.toString((String)hash.get("PBH"));
String strOrgId = ds.toString((String)hash.get("BMBH"));
String strName = ds.toString((String)hash.get("MC"));
String strJBXH = ds.toString((String)hash.get("JBXH"));
String sql ="";
String stroName = "";
sql = "select MC from news.ORGMENU where BH = "+strId+"";
ResultSet rs1 = selectRecord(sql);
Statement stmt = null;
try{
if(rs1.next())
{
stroName = ds.toString(rs1.getString("MC"));
}
}catch(Exception e){System.out.println("運(yùn)行時(shí)出錯(cuò)："+e);}
finally{
if(rs1!=null)try{ stmt = rs1.getStatement(); rs1.close();}catch(Exception e){System.out.println("關(guān)閉記錄集rs時(shí)出錯(cuò)"+e);}
if(stmt!=null) try{stmt.close();}catch(Exception e){System.out.println("關(guān)閉聲明時(shí)statement出錯(cuò)"+e);}
}
//被修改名稱(chēng)
if(!stroName.equals(strName))
{
sql = "select * from news.ORGMENU where BMBH = '"+strOrgId+"' and PBH = "+strParentId+" and MC = '"+strName+"'";
ResultSet rs = selectRecord(sql);
try{
if(rs.next()){ return 1; }
}catch(Exception e){System.out.println("運(yùn)行時(shí)出錯(cuò)："+e);}
finally{
if(rs!=null)try{ stmt = rs.getStatement(); rs.close();}catch(Exception e){System.out.println("關(guān)閉記錄集rs時(shí)出錯(cuò)"+e);}
if(stmt!=null) try{stmt.close();}catch(Exception e){System.out.println("關(guān)閉聲明時(shí)statement出錯(cuò)"+e);}
}
}
int intJBXH = setJBXH(strId,strOrgId,strParentId,strJBXH);
Vector vect =new Vector();
vect.add("ORGMENU");
vect.add(addVector("MC",strName,"CHAR"));
vect.add(addVector("JBXH",String.valueOf(intJBXH),"NUM"));
vect.add("BH="+strId+"");
return updateRecord(vect);
}
//刪除子類(lèi)信息
public int delMenu()
{
String sql = "";
String strJBXH = "0";
String strOrgID ="";
String strid ="";
ResultSet rs = null;
int intJBXH = Integer.parseInt(strJBXH);
sql = "select * from news.orgmenu where BH = "+strID+"";
rs = selectRecord(sql);
Statement stmt = null;
try{
if(rs.next())
{
strJBXH = ds.toString(rs.getString("JBXH"));
strOrgID = ds.toString(rs.getString("BMBH"));
strid = ds.toString(rs.getString("BH"));
}
}catch(Exception e){System.out.println("運(yùn)行時(shí)出錯(cuò)："+e);}
finally{
if(rs!=null)try{ stmt = rs.getStatement(); rs.close();}catch(Exception e){System.out.println("關(guān)閉記錄集rs時(shí)出錯(cuò)"+e);}
if(stmt!=null) try{stmt.close();}catch(Exception e){System.out.println("關(guān)閉聲明時(shí)statement出錯(cuò)"+e);}
}
sql = "select count(id) from news.article where article.organid='"+strOrgID+"' and article.wzlx="+strID+"";
rs = selectRecord(sql);
int article_num = 0;
try{
if(rs.next())
article_num = rs.getInt(1);
}catch(Exception e){System.out.println("運(yùn)行時(shí)出錯(cuò)："+e);}
finally{
if(rs!=null)try{ stmt = rs.getStatement(); rs.close();}catch(Exception e){System.out.println("關(guān)閉記錄集rs時(shí)出錯(cuò)"+e);}
if(stmt!=null) try{stmt.close();}catch(Exception e){System.out.println("關(guān)閉聲明時(shí)statement出錯(cuò)"+e);}
}
if(article_num!=0){
return article_num;
}
if(isChild(strOrgID,strid)) return -5;
intJBXH = Integer.parseInt(strJBXH);
sql = "update news.orgmenu set JBXH = JBXH-1 where BMBH = '"+strOrgID+"' and PBH="+strParentID+" and JBXH>"+intJBXH+"";
deleteRecord(sql);
sql = "delete from news.orgmenu where BH = "+strID+"";
return deleteRecord(sql);
}
//取得所有下一級(jí)類(lèi)信息
public Vector getAllDownCs(String id)
{
Vector vect = new Vector();
return vect;
}
//新增的時(shí)候設(shè)置級(jí)別序號(hào)
public int setJBXH(String id,String pid,String jbxh)
{
int intJBXH = makeID("ORGMENU","BMBH","PBH","JBXH",id,pid,false,true);
if(jbxh.equals("")) jbxh = "0";
int intxh = Integer.parseInt(jbxh);
if(intxh>0&&intxh<intJBXH)
{
intJBXH = intxh;
String sql = "";
sql = "update orgmenu set JBXH=JBXH+1 where BMBH = '"+id+"' and PBH = "+pid+" and JBXH>="+intxh;
deleteRecord(sql);
}
return intJBXH;
}
//修改的時(shí)候設(shè)置級(jí)別序號(hào)
public int setJBXH(String id,String orgid,String pid,String strJBXH)
{
if(pid.equals(""))
pid = "0";
ResultSet rs1 = selectRecord("select JBXH from news.ORGMENU where BH=" + id);
int yjbxh=999;
Statement stmt = null;
try{
if(rs1.next())
yjbxh=Integer.parseInt(rs1.getString("JBXH"));
}catch(Exception e){System.out.println("運(yùn)行時(shí)出錯(cuò)："+e);}
finally{
if(rs1!=null)try{ stmt = rs1.getStatement(); rs1.close();}catch(Exception e){System.out.println("關(guān)閉記錄集rs時(shí)出錯(cuò)"+e);}
if(stmt!=null) try{stmt.close();}catch(Exception e){System.out.println("關(guān)閉聲明時(shí)statement出錯(cuò)"+e);}
}
///////////////
int jbxh = Integer.parseInt(strJBXH);
int maxjbNo = makeID("ORGMENU","BMBH","PBH","JBXH",orgid,pid,false,true);
if(jbxh==0||jbxh>=maxjbNo)
jbxh=maxjbNo-1;
if(jbxh < yjbxh){
String sql1="update ORGMENU set JBXH=JBXH+1 where BMBH='"
+ orgid + "' and PBH = " + pid
+ " and JBXH >="
+ jbxh
+ " and JBXH<"
+ yjbxh;
deleteRecord(sql1);
}
else if(jbxh > yjbxh && yjbxh!=0){
String sql2="update ORGMENU set jbxh=jbxh-1 where BMBH='"
+ orgid + "' and PBH = " + pid
+ " and JBXH <="
+ jbxh
+ " and JBXH>"
+ yjbxh;
deleteRecord(sql2);
}
//////////////////////
return jbxh;
}
//根據(jù)編號(hào)取得名稱(chēng)
public String toName(String id)
{
String sql ="";
String name = "";
if(id.equals("")) return name;
sql = "select mc from news.orgmenu where BH = "+id+"";
?? 快捷鍵說(shuō)明
復(fù)制代碼
Ctrl + C
搜索代碼
Ctrl + F
全屏模式
F11
切換主題
Ctrl + Shift + D
顯示快捷鍵
?
增大字號(hào)
Ctrl + =
減小字號(hào)
Ctrl + -