?? departmentbean.java
字號:
rs = selectRecord(sql);
try{
if (rs.next())
zwmc = ds.toString(rs.getString("ZWMC"));
}catch(Exception e){System.out.println("DepartmentBean.getAllInf()運行時出錯："+e);}
finally{
if(rs!=null)try{ stmt = rs.getStatement(); rs.close();}catch(Exception e){System.out.println("DepartmentBean.getAllInf()關閉記錄集rs時出錯"+e);}
if(stmt!=null) try{stmt.close();}catch(Exception e){System.out.println("DepartmentBean.getAllInf()關閉聲明時statement出錯"+e);}
}
}
ht.put("ZWMC", zwmc);
// added by wangzhen
if (!glyzwbh.equals("") && glyzwbh != null) {
sql =
"select XM from ZZ_ZGB where ZGBH= '"
+ glyzwbh
+ "' and BMBH='"
+ depNo
+ "'";
rs = selectRecord(sql);
try{
if (rs.next())
glyxm = ds.toString(rs.getString("XM"));
}catch(Exception e){System.out.println("DepartmentBean.getAllInf()運行時出錯："+e);}
finally{
if(rs!=null)try{ stmt = rs.getStatement(); rs.close();}catch(Exception e){System.out.println("DepartmentBean.getAllInf()關閉記錄集rs時出錯"+e);}
if(stmt!=null) try{stmt.close();}catch(Exception e){System.out.println("DepartmentBean.getAllInf()關閉聲明時statement出錯"+e);}
}
}
ht.put("GLYZWXM", glyxm);
if (!wszwbh.equals("") && wszwbh != null) {
sql =
"select XM from ZZ_ZGB where ZGBH= '"
+ wszwbh
+ "' and BMBH='"
+ depNo
+ "'";
rs = selectRecord(sql);
try{
if (rs.next())
wsxm = ds.toString(rs.getString("XM"));
}catch(Exception e){System.out.println("DepartmentBean.getAllInf()運行時出錯："+e);}
finally{
if(rs!=null)try{ stmt = rs.getStatement(); rs.close();}catch(Exception e){System.out.println("DepartmentBean.getAllInf()關閉記錄集rs時出錯"+e);}
if(stmt!=null) try{stmt.close();}catch(Exception e){System.out.println("DepartmentBean.getAllInf()關閉聲明時statement出錯"+e);}
}
}
//
ht.put("WSZWXM", wsxm);
String[] ckqxMax = null;
String psName = "";
String strMax = "";
if (!ckqxbh.equals("") && ckqxbh != null) {
ckqxMax = ckqxbh.split(",");
for (int i = 0; i < ckqxMax.length; i++) {
sql = "select XM from ZZ_ZGB where ZGBH='" + ckqxMax[i] + "'";
rs = selectRecord(sql);
try{
if (rs.next())
psName = ds.toString(rs.getString("XM"));
}catch(Exception e){System.out.println("DepartmentBean.getAllInf()運行時出錯："+e);}
finally{
if(rs!=null)try{ stmt = rs.getStatement(); rs.close();}catch(Exception e){System.out.println("DepartmentBean.getAllInf()關閉記錄集rs時出錯"+e);}
if(stmt!=null) try{stmt.close();}catch(Exception e){System.out.println("DepartmentBean.getAllInf()關閉聲明時statement出錯"+e);}
}
if (!strMax.equals(""))
strMax += "," + psName;
if (strMax.equals(""))
strMax = psName;
}
}
ht.put("CKQX", strMax);
return ht;
}
public Hashtable getRootInf() //管理員和文書數據已經漢化
{
String sql =
"select BMMC,TZWBH,GLYZWBH,WSZWBH,CKQX from ZZ_BMB where BMBH='"
+ depNo
+ "' and BMFBH is null";
ResultSet rs = selectRecord(sql);
ResultSet rs1 = null;
Statement stmt = null;
Hashtable ht = null;
try{
if (rs.next()) {
ht = new Hashtable();
ht.put("BMMC", ds.toString(rs.getString(1)));
ht.put("GLYZWBH", ds.toString(rs.getString(3)));
ht.put("WSZWBH", ds.toString(rs.getString(4)));
ht.put("CKQXBH", ds.toString(rs.getString(5)));
ht.put("BMFBH", "");
ht.put("JBXH", "");
String zwmc = "";
String glyxm = "";
String wsxm = "";
String tzwbh = ds.toString(rs.getString(2));
String ckqxbh = ds.toString(rs.getString(5));
//
String glyzwbh = ds.toString(rs.getString(3));
String wszwbh = ds.toString(rs.getString(4));
if (!tzwbh.equals("") && tzwbh != null) {
sql =
"select ZWMC from ZZ_ZWB where ZWBH="
+ tzwbh
+ " and BMBH='"
+ depNo
+ "'";
try{
rs1 = selectRecord(sql);
if (rs1.next())
zwmc = ds.toString(rs1.getString("ZWMC"));
}catch(Exception e){System.out.println("DepartmentBean.getRootInf()運行時出錯："+e);}
finally{
if(rs1!=null)try{ stmt = rs1.getStatement(); rs1.close();}catch(Exception e){System.out.println("DepartmentBean.getRootInf()關閉記錄集rs時出錯"+e);}
if(stmt!=null) try{stmt.close();}catch(Exception e){System.out.println("DepartmentBean.getRootInf()關閉聲明時statement出錯"+e);}
}
ht.put("ZWMC", zwmc);
if (!glyzwbh.equals("") && glyzwbh != null) {
sql =
"select XM from ZZ_ZGB where ZGBH= '"
+ glyzwbh
+ "' and BMBH='"
+ depNo
+ "'";
try{
rs1 = selectRecord(sql);
if (rs1.next())
glyxm = ds.toString(rs.getString("XM"));
}catch(Exception e){System.out.println("DepartmentBean.getRootInf()運行時出錯："+e);}
finally{
if(rs1!=null)try{ stmt = rs1.getStatement(); rs1.close();}catch(Exception e){System.out.println("DepartmentBean.getRootInf()關閉記錄集rs時出錯"+e);}
if(stmt!=null) try{stmt.close();}catch(Exception e){System.out.println("DepartmentBean.getRootInf()關閉聲明時statement出錯"+e);}
}
}
ht.put("GLYZWXM", glyxm);
if (!wszwbh.equals("") && wszwbh != null) {
sql =
"select XM from ZZ_ZGB where ZGBH="
+ wszwbh
+ " and BMBH='"
+ depNo
+ "'";
try{
rs1 = selectRecord(sql);
if (rs1.next())
wsxm = ds.toString(rs.getString("XM"));
}catch(Exception e){System.out.println("DepartmentBean.getRootInf()運行時出錯："+e);}
finally{
if(rs1!=null)try{ stmt = rs1.getStatement(); rs1.close();}catch(Exception e){System.out.println("DepartmentBean.getRootInf()關閉記錄集rs時出錯"+e);}
if(stmt!=null) try{stmt.close();}catch(Exception e){System.out.println("DepartmentBean.getRootInf()關閉聲明時statement出錯"+e);}
}
}
ht.put("WSZWXM", wsxm);
String[] ckqxMax = null;
String psName = "";
String strMax = "";
if (!ckqxbh.equals("") && ckqxbh != null) {
ckqxMax = ckqxbh.split(",");
for (int i = 0; i < ckqxMax.length; i++) {
sql =
"select XM from ZZ_ZGB where ZGBH='" + ckqxMax[i] + "'";
try{
rs1 = selectRecord(sql);
if (rs1.next())
psName = ds.toString(rs.getString("XM"));
}catch(Exception e){System.out.println("DepartmentBean.getRootInf()運行時出錯："+e);}
finally{
if(rs1!=null)try{ stmt = rs1.getStatement(); rs1.close();}catch(Exception e){System.out.println("DepartmentBean.getRootInf()關閉記錄集rs時出錯"+e);}
if(stmt!=null) try{stmt.close();}catch(Exception e){System.out.println("DepartmentBean.getRootInf()關閉聲明時statement出錯"+e);}
}
if (!strMax.equals(""))
strMax += "," + psName;
if (strMax.equals(""))
strMax = psName;
}
}
ht.put("CKQX", strMax);
}
}
}catch(Exception e){System.out.println("DepartmentBean.getRootInf()運行時出錯："+e);}
finally{
if(rs!=null)try{ stmt = rs.getStatement(); rs.close();}catch(Exception e){System.out.println("DepartmentBean.getRootInf()關閉記錄集rs時出錯"+e);}
if(stmt!=null) try{stmt.close();}catch(Exception e){System.out.println("DepartmentBean.getRootInf()關閉聲明時statement出錯"+e);}
}
return ht;
}
public boolean nameExist(String bmname) //判斷同一個部門下名稱是否重
{
boolean bool = false;
String sql =
"select BMMC from zz_bmb where BMFBH='"
+ depNo
+ "' and BMMC='"
+ bmname
+ "'";
ResultSet rs = selectRecord(sql);
Statement stmt = null;
try{
if (rs.next())
bool = true;
else
bool = false;
}catch(Exception e){System.out.println("DepartmentBean.nameExist(String)運行時出錯："+e);}
finally{
if(rs!=null)try{ stmt = rs.getStatement(); rs.close();}catch(Exception e){System.out.println("DepartmentBean.nameExist(String)關閉記錄集rs時出錯"+e);}
if(stmt!=null) try{stmt.close();}catch(Exception e){System.out.println("DepartmentBean.nameExist(String)關閉聲明時statement出錯"+e);}
}
return bool;
}
//分頁時取得一頁的數據量
public Vector getOnePage(int page, int records) {
String sql =
"select * from ZZ_ZWB where BMBH='"
+ depNo
+ "' order by JBXH";
return db.getOnePage(sql, page, records);
}
//返回某個部門的在職所有人員
public Vector getOneBMPs(){
String sql =
"select XM from ZZ_ZGB where BMBH='" + depNo + "' and ZZZT=0 order by XM";
ResultSet rs = selectRecord(sql);
Statement stmt = null;
Vector oneBmPerson = new Vector();
try{
String psName = "";
while (rs.next()) {
psName = ds.toString(rs.getString("XM"));
oneBmPerson.add(psName);
}
}catch(Exception e){System.out.println("DepartmentBean.getOneBMPs()運行時出錯："+e);}
finally{
if(rs!=null)try{ stmt = rs.getStatement(); rs.close();}catch(Exception e){System.out.println("DepartmentBean.getOneBMPs()關閉記錄集rs時出錯"+e);}
if(stmt!=null) try{stmt.close();}catch(Exception e){System.out.println("DepartmentBean.getOneBMPs()關閉聲明時statement出錯"+e);}
}
return oneBmPerson;
}
// //返回某個部門的在職所有人員及職工編號 (added by wangzhen)
public Vector getOneBMPsBH(){
String sql =
"select ZGBH,XM from ZZ_ZGB where BMBH='" + depNo + "' and ZZZT=0 order by XM";
ResultSet rs = selectRecord(sql);
Vector oneBmPerson = new Vector();
String psName = "";
Statement stmt = null;
try{
while (rs.next()) {
psName = ds.toString(rs.getString("ZGBH"));
oneBmPerson.add(psName);
}
}catch(Exception e){System.out.println("DepartmentBean.getOneBMPsBH()運行時出錯："+e);}
finally{
if(rs!=null)try{ stmt = rs.getStatement(); rs.close();}catch(Exception e){System.out.println("DepartmentBean.getOneBMPsBH()關閉記錄集rs時出錯"+e);}
if(stmt!=null) try{stmt.close();}catch(Exception e){System.out.println("DepartmentBean.getOneBMPsBH()關閉聲明時statement出錯"+e);}
}
return oneBmPerson;
}
public String getBMBH(String strPersonNO)//取得當前人員所在部門的部門編號new
{
String sql = "";
String name = "";
sql = " select BMBH from ZZ_ZGB where ZGBH = '"+strPersonNO+"'";
ResultSet rs = selectRecord(sql);
Statement stmt = null;
try{
if(rs.next())
name = ds.toString(rs.getString("BMBH"));
}catch(Exception e){System.out.println("DepartmentBean.getBMBH(String)運行時出錯："+e);}
finally{
if(rs!=null)try{ stmt = rs.getStatement(); rs.close();}catch(Exception e){System.out.println("DepartmentBean.getBMBH(String)關閉記錄集rs時出錯"+e);}
if(stmt!=null) try{stmt.close();}catch(Exception e){System.out.println("DepartmentBean.getBMBH(String)關閉聲明時statement出錯"+e);}
}
return name;
}
public String isWho(String zgbh)
{//判斷當前人員的身份new
String bmno = getBMBH(zgbh);
String sql = "";
String admin="",ws="";
if(bmno!=null && !bmno.equals(""))
sql = " select GLYZWBH,WSZWBH from ZZ_BMB where BMBH = '"+bmno+"'";
ResultSet rs = selectRecord(sql);
Statement stmt = null;
try{
if(rs.next())
{
admin = ds.toString(rs.getString("GLYZWBH"));
ws = ds.toString(rs.getString("WSZWBH"));
if(admin.equals(zgbh) || (admin.equals(zgbh) && ws.equals(zgbh)))
{
return "bmadmin";
}
else if(ws.equals(zgbh))
{
return "bmws";
}
}
}catch(Exception e){System.out.println("DepartmentBean.isWho(String)運行時出錯："+e);}
finally{
if(rs!=null)try{ stmt = rs.getStatement(); rs.close();}catch(Exception e){System.out.println("DepartmentBean.isWho(String)關閉記錄集rs時出錯"+e);}
if(stmt!=null) try{stmt.close();}catch(Exception e){System.out.println("DepartmentBean.isWho(String)關閉聲明時statement出錯"+e);}
}
return "person";
}
public String getOrgNo(String bmbh){ //取得二級部門編號
String org = bmbh.substring(0,4);
for(int i=0;i<16;i++)
org = org+"0";
return org;
}
public int unit(String strDepA,String strDepB)
{
try{
String sql = "update ZZ_ZGB set BMBH='"+strDepB+"' where BMBH='"+strDepA+"'";
executeUpdate(sql);
if(!strDepA.substring(0,4).equals(strDepB.substring(0,4)))//當兩個部門是不同的二級部門時刪除職務
{
sql = "delete from ZZ_ZGZWB where BMBH='"+strDepA+"'";
executeUpdate(sql);
}
}
catch(Exception e){}
finally{
}
return 0;
}
public static void main(String[] args) {
System.out.println("Hello World!");
try {
Hashtable ht = new Hashtable();
ht.put("BMFBH", "00020000000000000000");
ht.put("BMMC", "財會室");
ht.put("JBXH", "3");
ht.put("TZWBH", "");
ht.put("GLYZWBH", "");
ht.put("WSZWBH", "");
ht.put("BMBH", "00020200000000000000");
DealString ds = new DealString();
DepartmentBean dpartbn = new DepartmentBean();
//System.out.println(dpartbn.addRec(ht));
dpartbn.buildSelectedBMTree("1155");
} catch (Exception e) {
}
}
}
?? 快捷鍵說明
復制代碼
Ctrl + C
搜索代碼
Ctrl + F
全屏模式
F11
切換主題
Ctrl + Shift + D
顯示快捷鍵
?
增大字號
Ctrl + =
減小字號
Ctrl + -