departmentbean.java

本书主要介绍了从基础开始建立Portal的快速应用开发过程（RAD）的方法。通过本书你可以了解到关于Oracle 9iAS Portal产品的主要特性、入口的开发和组织、网络开发和管理、实际的关系型数

		String fatherNo=getFatherNo();
		if(bmNo.equals("00000000000000000000"))
			sql = "select JBXH from ZZ_BMB where BMMC='"+ bmName+ "' and BMFBH is null and BMZT=0";
		else
			sql = "select JBXH from ZZ_BMB where BMMC='"+ bmName+ "' and BMFBH='"+ fatherNo+ "' and BMZT=0";

		ResultSet rs1 = selectRecord(sql);
		int yjbxh=999;
		Statement stmt = null;
		try{
			if(rs1.next())
				yjbxh=Integer.parseInt(rs1.getString("JBXH"));
		}catch(Exception e){System.out.println("DepartmentBean.modRec(Hashtable,String)运行时出错："+e);}
		finally{
			if(rs1!=null)try{ stmt = rs1.getStatement(); rs1.close();}catch(Exception e){System.out.println("DepartmentBean.modRec(Hashtable,String)关闭记录集rs时出错"+e);}
			if(stmt!=null) try{stmt.close();}catch(Exception e){System.out.println("DepartmentBean.modRec(Hashtable,String)关闭声明时statement出错"+e);}		
		}
		if (flg.equals("0")) { //父部门没变

			int jbxh=0;
			if(!jbNo.equals(""))
				jbxh=Integer.parseInt(jbNo);
			
			if(!fatherNo.equals(""))
			{
				int maxjbNo=makeID("ZZ_BMB","BMFBH","BMZT","JBXH",fatherNo,"0",false,true);
				if(jbxh==0||jbxh>=maxjbNo)
					{ jbxh=maxjbNo;jbNo=""+jbxh;}
				if(jbxh < yjbxh){
					String sql1="update ZZ_BMB set jbxh=jbxh+1 where BMFBH='"
								+ fatherNo	
								+ "' and BMZT=0 and JBXH >=" 
								+ jbxh
								+ "  and  JBXH<"
								+ yjbxh;
					deleteRecord(sql1);
				}
				else if(jbxh > yjbxh && yjbxh!=0){
					String sql2="update ZZ_BMB set jbxh=jbxh-1 where BMFBH='"
								+ fatherNo	
								+ "' and BMZT=0 and JBXH <=" 
								+ jbxh
								+ "  and  JBXH>"
								+ yjbxh;
					deleteRecord(sql2);
				}
			}

			sqlvt.add("ZZ_BMB");
			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", ckqx, "CHAR"));
			sqlvt.add("BMBH='" + bmNo + "'");
			updateRecord(sqlvt);
			rebuildTree();
			return 0;
		}
		else {
			depNo = bmNo;
			return delRec();
		}
	}

	//删除一条纪录(由公共变量-部门编号depNo确定)
	//考虑部门下是否有纪录 有返回false,无纪录删除(挂起)并返回true
	public int delRec(){
		String sql1 = "", sql2 = "",sql3="";
		String strBMZT = "1";

		sql1 = "select * from ZZ_BMB where BMFBH = '" + depNo + "' and BMZT=0";
		sql2 = "select * from ZZ_ZWB where BMBH = '" + depNo + "' and ZWZT=0";
		sql3 = "select * from ZZ_ZGB where BMBH = '" + depNo + "' and ZZZT=0";
		ResultSet rs1 = selectRecord(sql1);
		ResultSet rs2 = selectRecord(sql2);
		ResultSet rs3 = selectRecord(sql3);
		Statement stmt = null;
		try{
		if (rs1.next()) {
			return -2; //部门下有子部门，不能删除该部门
		}
		///判断部门下有没有人
		if(rs3.next())
		{
			return -4; //部门下有人，不能删除该部门
		}
		if (rs2.next()) {
			stmt = rs2.getStatement();
			rs2.close();
			stmt.close();
			sql2 = "select * from ZZ_ZGZWB where BMBH = '" + depNo + "'";
			rs2 = selectRecord(sql2);
			if (rs2.next()) {
				return -3; //部门下的职务有人担当，不能删除部门
			}
			else {
				sql1 =
					"update ZZ_ZWB set ZWZT=1 where BMBH = '"
						+ depNo
						+ "' and ZWZT=0";
				deleteRecord(sql1);
			}
		}
		}catch(Exception e){System.out.println("DepartmentBean.delRec()运行时出错："+e);}
		finally{
			if(rs1!=null)try{ stmt = rs1.getStatement(); rs1.close();}catch(Exception e){System.out.println("DepartmentBean.delRec()关闭记录集rs时出错"+e);}
			if(stmt!=null) try{stmt.close();}catch(Exception e){System.out.println("DepartmentBean.delRec()关闭声明时statement出错"+e);}		
			if(rs2!=null)try{ stmt = rs2.getStatement(); rs2.close();}catch(Exception e){System.out.println("DepartmentBean.delRec()关闭记录集rs时出错"+e);}
			if(stmt!=null) try{stmt.close();}catch(Exception e){System.out.println("DepartmentBean.delRec()关闭声明时statement出错"+e);}		
			if(rs3!=null)try{ stmt = rs3.getStatement(); rs3.close();}catch(Exception e){System.out.println("DepartmentBean.delRec()关闭记录集rs时出错"+e);}
			if(stmt!=null) try{stmt.close();}catch(Exception e){System.out.println("DepartmentBean.delRec()关闭声明时statement出错"+e);}		
		}
		String fatherNo=getFatherNo();
		ResultSet rst = selectRecord(
				"select JBXH from ZZ_BMB where BMBH = '"
					+ depNo
					+ "' and BMFBH='"
					+ fatherNo
					+ "' and BMZT=0");
		int yjbxh=999;
		try{
			if(rst.next())
				yjbxh=Integer.parseInt(rst.getString("JBXH"));
		}catch(Exception e){System.out.println("DepartmentBean.delRec()运行时出错："+e);}
		finally{
			if(rst!=null)try{ stmt = rst.getStatement(); rst.close();}catch(Exception e){System.out.println("DepartmentBean.delRec()关闭记录集rs时出错"+e);}
			if(stmt!=null) try{stmt.close();}catch(Exception e){System.out.println("DepartmentBean.delRec()关闭声明时statement出错"+e);}		
		}
		String sql="update ZZ_BMB set jbxh=jbxh-1 where BMFBH='"
					+ fatherNo	
					+ "' and BMZT=0 and JBXH >" 
					+ yjbxh;
		deleteRecord(sql);
		sql = "update ZZ_BMB set BMZT=1 where BMBH='" + depNo + "'";
		deleteRecord(sql);
		rebuildTree();
		return 0;
	}

	public String toName()
	{
		return db.toName("ZZ_BMB", "BMBH", "BMMC", depNo);
	}

	public String toName(String depno)
	{
		return db.toName("ZZ_BMB", "BMBH", "BMMC", depno);
	}

	public String getJBNo(){
		String jbNo = "", maxNo = "0";
		int ljbNo = -1, lmaxNo = 0;
		String sql = "select JBXH from ZZ_BMB where BMFBH='" + depNo + "' and BMZT=0";
		ResultSet rs = selectRecord(sql);
		Statement stmt = null;
		try{
			while (rs.next()) { //取得本部门的级别序号的最大编号
				jbNo = ds.toString(rs.getString("JBXH"));
				ljbNo = Integer.parseInt(jbNo);
				if (ljbNo > lmaxNo) {
					lmaxNo = ljbNo;
					maxNo = jbNo;
				}
			}
		}catch(Exception e){System.out.println("DepartmentBean.getJBNo()运行时出错："+e);}
		finally{
			if(rs!=null)try{ stmt = rs.getStatement(); rs.close();}catch(Exception e){System.out.println("DepartmentBean.getJBNo()关闭记录集rs时出错"+e);}
			if(stmt!=null) try{stmt.close();}catch(Exception e){System.out.println("DepartmentBean.getJBNo()关闭声明时statement出错"+e);}		
		}
		jbNo = String.valueOf(lmaxNo + 1);
		return jbNo;
	}

	//返回父编号
	public String getFatherNo(){
		String sql = "select BMFBH from ZZ_BMB where BMBH='" + depNo + "'";
		ResultSet rs = selectRecord(sql);
		String fatherNo = "";
		Statement stmt = null;
		try{
			if (rs.next())
				fatherNo = ds.toString(rs.getString("BMFBH"));
		}catch(Exception e){System.out.println("DepartmentBean.getFatherNo()运行时出错："+e);}
		finally{
			if(rs!=null)try{ stmt = rs.getStatement(); rs.close();}catch(Exception e){System.out.println("DepartmentBean.getFatherNo()关闭记录集rs时出错"+e);}
			if(stmt!=null) try{stmt.close();}catch(Exception e){System.out.println("DepartmentBean.getFatherNo()关闭声明时statement出错"+e);}		
		}
		return fatherNo;
	}
	public String getBmNo(String bmName)
	{ 
		String sql = "select BMBH from ZZ_BMB where BMMC='" + bmName + "'";
		ResultSet rs = selectRecord(sql);
		String bmNo = "";
		Statement stmt = null;
		try{
			if (rs.next())
				bmNo = ds.toString(rs.getString("BMBH"));
		}catch(Exception e){System.out.println("DepartmentBean.getBmNo(String)运行时出错："+e);}
		finally{
			if(rs!=null)try{ stmt = rs.getStatement(); rs.close();}catch(Exception e){System.out.println("DepartmentBean.getBmNo(String)关闭记录集rs时出错"+e);}
			if(stmt!=null) try{stmt.close();}catch(Exception e){System.out.println("DepartmentBean.getBmNo(String)关闭声明时statement出错"+e);}		
		}
		return bmNo;
	}

	public String getBossDutyNo(String bossName)
	{
		String sql =
			"select ZWBH from ZZ_ZWB where trim(ZWMC)='"
				+ bossName
				+ "' and BMBH='"
				+ depNo
				+ "'";

		ResultSet rs = selectRecord(sql);
		String bossNo = "";
		Statement stmt = null;
		try{
			if (rs.next())
				bossNo = ds.toString(rs.getString("ZWBH"));
		}catch(Exception e){System.out.println("DepartmentBean.getBossDutyNo(String)运行时出错："+e);}
		finally{
			if(rs!=null)try{ stmt = rs.getStatement(); rs.close();}catch(Exception e){System.out.println("DepartmentBean.getBossDutyNo(String)关闭记录集rs时出错"+e);}
			if(stmt!=null) try{stmt.close();}catch(Exception e){System.out.println("DepartmentBean.getBossDutyNo(String)关闭声明时statement出错"+e);}		
		}
		return bossNo;
	}
	public String getDutyNo()
	{
		String sql = "select TZWBH from ZZ_BMB where BMBH='" + depNo + "'";
		ResultSet rs = selectRecord(sql);
		String bossNo = "";
		Statement stmt = null;
		try{
			if (rs.next())
				bossNo = ds.toString(rs.getString("TZWBH"));
		}catch(Exception e){System.out.println("DepartmentBean.getDutyNo()运行时出错："+e);}
		finally{
			if(rs!=null)try{ stmt = rs.getStatement(); rs.close();}catch(Exception e){System.out.println("DepartmentBean.getDutyNo()关闭记录集rs时出错"+e);}
			if(stmt!=null) try{stmt.close();}catch(Exception e){System.out.println("DepartmentBean.getDutyNo()关闭声明时statement出错"+e);}		
		}
		return bossNo;
	}
	public Vector allBmName()
	{
		String sql = "select BMMC from ZZ_BMB where BMBH!='" + depNo + "'";
		ResultSet rs = selectRecord(sql);
		Vector allBmName = new Vector();
		String bmName = "";
		Statement stmt = null;
		try{
			while (rs.next()) {
				bmName = ds.toString(rs.getString("BMMC"));
				allBmName.add(bmName);
			}
		}catch(Exception e){System.out.println("DepartmentBean.allBmName()运行时出错："+e);}
		finally{
			if(rs!=null)try{ stmt = rs.getStatement(); rs.close();}catch(Exception e){System.out.println("DepartmentBean.allBmName()关闭记录集rs时出错"+e);}
			if(stmt!=null) try{stmt.close();}catch(Exception e){System.out.println("DepartmentBean.allBmName()关闭声明时statement出错"+e);}		
		}
		return allBmName;
	}

	public Hashtable getAllInf()
	{
		String sql =
			"select a.BMMC as FBMMC,b.BMMC as BMMC,b.TZWBH as TZWBH,b.JBXH as JBXH,b.GLYZWBH as GLYZWBH,b.WSZWBH as WSZWBH,b.CKQX as CKQX from ZZ_BMB a,ZZ_BMB b where a.BMBH=b.BMFBH and b.BMBH='"
				+ depNo
				+ "'";
		ResultSet rs = selectRecord(sql);
		Statement stmt = null;
		Hashtable ht = new Hashtable();
		String zwmc = ""; 		                  
		String tzwbh = "";
		String ckqxbh = "";
		String glyxm = "";
		String wsxm = ""; 
		String glyzwbh = "";
		String wszwbh = "";
		try{
			if(rs.next())
			{
				ht.put("BMFBH", ds.toString(rs.getString("FBMMC")));
				ht.put("BMMC", ds.toString(rs.getString("BMMC")));
				ht.put("JBXH", ds.toString(rs.getString("JBXH")));
				ht.put("GLYZWBH", ds.toString(rs.getString("GLYZWBH")));
				ht.put("WSZWBH", ds.toString(rs.getString("WSZWBH")));
				ht.put("CKQXBH", ds.toString(rs.getString("CKQX")));

				zwmc = ""; 

				tzwbh = ds.toString(rs.getString("TZWBH"));
				ckqxbh = ds.toString(rs.getString("CKQX"));			
				glyxm = "";
				wsxm = "";
				glyzwbh = ds.toString(rs.getString("GLYZWBH"));
				wszwbh = ds.toString(rs.getString("WSZWBH"));
			}
		}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 (!tzwbh.equals("") && tzwbh != null) {
			sql =
				"select ZWMC from ZZ_ZWB where ZWBH="
					+ tzwbh
					+ " and BMBH='"
					+ depNo
					+ "'";
			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);

		if (!glyzwbh.equals("") && glyzwbh != null) {