codemanager.java

网上商店

	/***************************************************************************
	 * 读出所有通用代码表的资料 *
	 **************************************************************************/
	public ArrayList loadAllbyCode(String code) {
		ArrayList codelist = new ArrayList();		
		try {
			String sql = "select * from srms_dmk where CODE='"+code+"' order by sequenceno,id";
			ResultSet rs = dbc.executeQuery(sql);			
			rs.last();// 移动到最后一行
			int row = rs.getRow();// 得到总记录数
			//System.out.println("----测试:----总记录数:"+row);
			if (row <= 0) {// 如果没有子结点
				return null;// 返回null
			} else {// 如果有子结点
				rs.beforeFirst();
				while (rs.next()) {
					CodeManager codeManager = new CodeManager(false);
					codeManager.setId(rs.getInt("ID"));
					codeManager.setName(rs.getString("NAME"));
					codeManager.setParentid(rs.getInt("PARENTID"));
					codeManager.setCode(rs.getString("CODE"));
					codeManager.setNote(rs.getString("NOTE"));
					codeManager.setSequenceNo(rs.getString("sequenceNo"));
					codelist.add(codeManager);
					int p_id = rs.getInt("ID");
					if(codeManager.canExpand(p_id))
					{   
						codelist=codeManager.loadChild(p_id, codelist,dbc);
					}
				}
				rs.close();
				return codelist;// 返回该记录的所有子结点
			}
		} catch (Exception e) {
			System.err.println(e);
		}
		return codelist;
	}

	/***************************************************************************
	 * 是否能够展开 *
	 **************************************************************************/
	
	public boolean canExpand(int id) {
		String sql ="select ID from srms_dmk where PARENTID="+id;
		ResultSet rs2=null;
		try {
			rs2 = dbc.executeQuery(sql);
			rs2.last();//移动到最后一行
			int row = rs2.getRow();//得到总记录数
			if (row <= 0) {
				rs2.close();
				return false;
			}				
		    else{
		    	rs2.close();
		    	return true;
		    }
		} catch (Exception e1) {
			// TODO Auto-generated catch block
			e1.printStackTrace();
			return false;
		}		//执行sql语句并返回ResultSet
		finally {
			try {// 最后关闭ResutltSet,Statement.并释放连接
				if (rs2 != null)
					rs2.close();
			} catch (SQLException e) {
				e.printStackTrace();
			}
		}
	}
	
	/***************************************************************************
	 * 查找所有child节点 *
	 **************************************************************************/
	public ArrayList loadChild(int id,ArrayList codelist,SQLBean dbc) {
		try {
			String sql = "select * from srms_dmk where PARENTID='"+id+"' order by sequenceno,id";
			ResultSet rs = dbc.executeQuery(sql);			
			rs.last();// 移动到最后一行
			int row = rs.getRow();// 得到总记录数
			//System.out.println("----测试:----总记录数:"+row);
			if (row <= 0) {// 如果没有子结点
				return null;// 返回null
			} else {// 如果有子结点
				rs.beforeFirst();
				while (rs.next()) {
					CodeManager codeManager = new CodeManager(false);
					codeManager.setId(rs.getInt("ID"));
					codeManager.setName(rs.getString("NAME"));
					codeManager.setParentid(rs.getInt("PARENTID"));
					codeManager.setCode(rs.getString("CODE"));
					codeManager.setNote(rs.getString("NOTE"));
					codeManager.setSequenceNo(rs.getString("sequenceNo"));
					codelist.add(codeManager);
					int p_id = rs.getInt("ID");
					if(codeManager.canExpand(p_id))
						codelist=codeManager.loadChild(p_id,codelist,dbc);
				}
				rs.close();
				return codelist;// 返回该记录的所有子结点
			}
		} catch (Exception e) {
			System.err.println(e);
		}
		return codelist;
	}
	/***************************************************************************
	 * 删除节点 *
	 **************************************************************************/
	public int del(int id) {
		int i = 0;
		try {
			String sql = "select * from srms_dmk where PARENTID =" + id;
			ResultSet rs = dbc.executeQuery(sql);
			while (rs.next()) {
				CodeManager codeManager = new CodeManager(false);
				codeManager.del(rs.getInt("ID"));
			}
			sql = "delete from srms_dmk where ID =" + id;
			dbc.executeUpdate(sql);
			i = 1;
		} catch (Exception e) {
			e.printStackTrace();
		}
		return i;
	}

	/***************************************************************************
	 * 修改节点 *
	 **************************************************************************/
	public int modify(HttpServletRequest request) {
		int i = 0;
		try {
			String name = request.getParameter("name");
			int id = Integer.parseInt(request.getParameter("id"));
			String note = request.getParameter("note");
			String code = request.getParameter("code");
			System.out.println(name + "," + id + "," + note + "," + code); // test
			String sql = "update srms_dmk set name='" + name + "', note='"
					+ note + "', code='" + code + "', where id=" + id;
			dbc.executeUpdate(sql);
			dbc.close();
			i = 1;
		} catch (Exception e) {
			e.printStackTrace();
		}
		return i;
	}

	/***************************************************************************
	 * 读出所有指标体系的root资料 *
	 **************************************************************************/
	public ArrayList loadAllRoot() {
		ArrayList codelist = new ArrayList();
		try {
			String sql = "select * from srms_dmk WHERE PARENTID=-1 order by ID";
			ResultSet rs = dbc.executeQuery(sql);
			while (rs.next()) {
				CodeManager codeManager = new CodeManager(false);
				codeManager.setId(rs.getInt("ID"));
				codeManager.setName(rs.getString("NAME"));
				codeManager.setParentid(rs.getInt("PARENTID"));
				codeManager.setCode(rs.getString("CODE"));
				codeManager.setNote(rs.getString("NOTE"));
				codeManager.setSequenceNo(rs.getString("sequenceNo"));
				codelist.add(codeManager);
			}
			rs.close();
		} catch (Exception e) {
			System.err.println(e);
		}
		return codelist;
	}

	/***************************************************************************
	 * 读出制定体系所有资料 *
	 **************************************************************************/
	public ArrayList loadContent(int id) {
		ArrayList al = new ArrayList();
		try {
			String sql = "select * from srms_dmk where id=" + id;
			ResultSet rs = dbc.executeQuery(sql);
			while (rs.next()) {
				CodeManager codeManager = new CodeManager(false);
				codeManager.setId(rs.getInt("ID"));
				codeManager.setCode(rs.getString("CODE"));
				codeManager.setName(rs.getString("NAME"));
				codeManager.setParentid(rs.getInt("PARENTID"));
				codeManager.setNote(rs.getString("NOTE"));
				codeManager.setSequenceNo(rs.getString("sequenceNo"));
				al.add(codeManager);
			}
			sql = "select * from srms_dmk where parent_criterion_id=" + id
					+ "order by criterion_id";
			rs = dbc.executeQuery(sql);
			ArrayList all = new ArrayList();
			while (rs.next()) {
				all = loadContent(rs.getInt("ID"));
				al.addAll(all);
			}
			rs.close();
			return al;
		} catch (Exception e) {
			e.printStackTrace();
		}
		return al;
	}

	/***************************************************************************
	 * 编辑root资料 *
	 **************************************************************************/
	public boolean editCodeType(HttpServletRequest request) throws Exception {
		// boolean updateok = false;
		String name = ParamUtils.getString(request, "name", "");
		String id = ParamUtils.getString(request, "id", "");
		String note = ParamUtils.getString(request, "note", "");
		String sequenceNo = ParamUtils.getString(request, "sequenceNo", "");
		String sql = "update srms_dmk set NAME='" + name + "', NOTE='" + note
				+ "',sequenceNo='" + sequenceNo + "' where ID=" + id
				+ " and PARENTID=-1";
		dbc.executeUpdate(sql);
		// updateok=true;
		dbc.close();
		return true;
	}

	/***************************************************************************
	 * 读出所有指标体系的资料 *
	 **************************************************************************/
	public Vector loadAll(String str) {
		Vector codeVector = new Vector();
		try {
			String sql = "select * from srms_dmk where PARENTID=-1 order by "
					+ str;
			ResultSet rs = dbc.executeQuery(sql);
			rs.last();// 移动到最后一行
			int row = rs.getRow();// 得到总记录数
			if (row <= 0) {// 如果没有子结点
				return null;// 返回null
			} else {// 如果有子结点
				rs.beforeFirst();
				while (rs.next()) {
					CodeManager codeManager = new CodeManager(false);
					codeManager.setId(rs.getInt("ID"));
					codeManager.setName(rs.getString("NAME"));
					codeManager.setCode(rs.getString("CODE"));
					codeVector.add(codeManager);
					int parentid = rs.getInt("ID");
					sql = "select * from srms_dmk WHERE PARENTID='" + parentid
							+ "' order by " + str;
					ResultSet rs1 = dbc.executeQuery(sql);
					while (rs1.next()) {
						CodeManager codeManager1 = new CodeManager(false);
						codeManager1.setId(rs1.getInt("ID"));
						codeManager1.setName(rs1.getString("NAME"));
						codeManager1.setCode(rs1.getString("CODE"));
						codeVector.add(codeManager1);
					}
				}
				rs.close();
				return codeVector;// 返回该记录的所有子结点
			}

		} catch (Exception e) {
			System.err.println(e);
		}
		return codeVector;
	}

	/***************************************************************************
	 * 读出所有指标体系的CHILDREN资料 *
	 **************************************************************************/
	public Vector loadAllChild(int id, String str) {
		Vector codeVector = new Vector();
		try {
			String sql = "select * from srms_dmk WHERE PARENTID='" + id
					+ "' order by " + str;
			ResultSet rs = dbc.executeQuery(sql);
			rs.last();// 移动到最后一行
			int row = rs.getRow();// 得到总记录数
			if (row <= 0) {// 如果没有子结点
				return null;// 返回null
			} else {// 如果有子结点
				rs.beforeFirst();
				while (rs.next()) {
					CodeManager codeManager = new CodeManager(false);
					codeManager.setId(rs.getInt("ID"));
					codeManager.setName(rs.getString("NAME"));
					codeManager.setCode(rs.getString("CODE"));
					codeVector.add(codeManager);
					id = rs.getInt("ID");
					sql = "select * from srms_dmk WHERE PARENTID='" + id
							+ "' order by " + str;
					ResultSet rs1 = dbc.executeQuery(sql);
					while (rs1.next()) {
						CodeManager codeManager1 = new CodeManager(false);
						codeManager1.setId(rs1.getInt("ID"));
						codeManager1.setName(rs1.getString("NAME"));
						codeManager1.setCode(rs1.getString("CODE"));
						codeVector.add(codeManager1);
					}
				}
				rs.close();
				return codeVector;// 返回该记录的所有子结点
			}

		} catch (Exception e) {
			System.err.println(e);
		}
		return codeVector;
	}

	/***************************************************************************
	 * 关闭sqlbean *
	 **************************************************************************/
	public void close() throws SQLException {
		if (dbc != null)
			dbc.close();
	}

}