treedaoimpl.java

jsf在线考试系统的实例

						position[root] = i;
					}
				}
			}

			if (root > 0) {
				for (int i = 0; i < department.length; i++) {
					for (int j = 0; j < department.length; j++) {
						if (department[j].getParent().equals(
								department[i].getId())) {
							tree[i].getChildren().add(tree[j]);
						}
					}
				}

				for (int i = 0; i < root + 1; i++) {
					treeData.getChildren().add(tree[position[i]]);
				}
				return treeData;
			} else {

				tree[0] = new TreeNodeChecked("DepartmentLocate", department[0]
						.getLocalName(), department[0].getId() + "", false);

				for (int i = 0; i < department.length; i++) {
					for (int j = i + 1; j < department.length; j++) {
						if (department[j].getParent().equals(
								department[i].getId())) {
							tree[i].getChildren().add(tree[j]);
						}
					}
				}
				return tree[0];
			}

		}
		return null;
	}

	public TreeNodeChecked getSelectSubjectTree(Long mid) {
		String hql = " select G.*,level as Level_ \r\n"
				+ "            from (select id_, class_,parent_,name_,localname_,sort_,status_,type_ \r\n"
				+ "        	           from jot_id_group \r\n"
				+ "                   where id_ != parent_ \r\n"
				+ "                  ) G \r\n "
				+ "            start with parent_= -4 \r\n"
				+ "            connect by prior id_=parent_ ";

		if (this.session == null) {
			this.setSession(HibernateSessionFactory.getSession());
		}
		TreeNodeChecked treeData = new TreeNodeChecked("Office", "科目", "2200",
				false, false);
		List lt = this.session.createSQLQuery(hql).addEntity(
				DepartmentTree.class).list();

		DepartmentTree[] department = new DepartmentTree[lt.size()];
		String type = null;
		if (lt.size() > 0) {
			int root = 0;
			int[] position = new int[lt.size()];
			position[0] = 0;
			TreeNodeChecked[] tree = new TreeNodeChecked[lt.size()];
			for (int i = 0; i < lt.size(); i++) {
				department[i] = (DepartmentTree) lt.get(i);

				tree[i] = new TreeNodeChecked(
						((department[i].getLevel() == 1) ? "Office" : "Locate"),
						department[i].getLocalName(), department[i].getId()
								+ "", false, false);
				if (i > 0) {
					if (department[i].getLevel().equals(
							department[0].getLevel())) {
						root++;
						position[root] = i;
					}
				}
			}

			if (root > 0) {
				for (int i = 0; i < department.length; i++) {
					for (int j = 0; j < department.length; j++) {
						if (department[j].getParent().equals(
								department[i].getId())) {
							tree[i].getChildren().add(tree[j]);
						}
					}
				}

				for (int i = 0; i < root + 1; i++) {
					treeData.getChildren().add(tree[position[i]]);
				}
				return treeData;
			} else {

				tree[0] = new TreeNodeChecked("Office", department[0]
						.getLocalName(), department[0].getId() + "", false,
						false);

				for (int i = 0; i < department.length; i++) {
					for (int j = i + 1; j < department.length; j++) {
						if (department[j].getParent().equals(
								department[i].getId())) {
							tree[i].getChildren().add(tree[j]);
						}
					}
				}
				return tree[0];
			}

		}
		return null;
	}

	public TreeNodeChecked getSelectTypeTree(Long mid) {
		String hql = " select G.*,level as Level_ \r\n"
				+ "            from (select * \r\n"
				+ "        	           from jot_id_group \r\n"
				+ "                   where id_ != parent_ \r\n"
				+ "                  ) G \r\n "
				+ "            start with parent_= -5 \r\n"
				+ "            connect by prior id_=parent_ ";

		if (this.session == null) {
			this.setSession(HibernateSessionFactory.getSession());
		}
		TreeNodeChecked treeData = new TreeNodeChecked("Office", "题型", "-5",
				false, false);
		List lt = this.session.createSQLQuery(hql).addEntity(
				DepartmentTree.class).list();

		DepartmentTree[] department = new DepartmentTree[lt.size()];
		String type = null;
		if (lt.size() > 0) {
			int root = 0;
			int[] position = new int[lt.size()];
			position[0] = 0;
			TreeNodeChecked[] tree = new TreeNodeChecked[lt.size()];
			for (int i = 0; i < lt.size(); i++) {
				department[i] = (DepartmentTree) lt.get(i);

				tree[i] = new TreeNodeChecked(
						((department[i].getLevel() == 1) ? "Office" : "Locate"),
						department[i].getLocalName(), department[i].getId()
								+ "", false, false);
				if (i > 0) {
					if (department[i].getLevel().equals(
							department[0].getLevel())) {
						root++;
						position[root] = i;
					}
				}
			}

			if (root > 0) {
				for (int i = 0; i < department.length; i++) {
					for (int j = 0; j < department.length; j++) {
						if (department[j].getParent().equals(
								department[i].getId())) {
							tree[i].getChildren().add(tree[j]);
						}
					}
				}

				for (int i = 0; i < root + 1; i++) {
					treeData.getChildren().add(tree[position[i]]);
				}
				return treeData;
			} else {

				tree[0] = new TreeNodeChecked("Office", department[0]
						.getLocalName(), department[0].getId() + "", false,
						false);

				for (int i = 0; i < department.length; i++) {
					for (int j = i + 1; j < department.length; j++) {
						if (department[j].getParent().equals(
								department[i].getId())) {
							tree[i].getChildren().add(tree[j]);
						}
					}
				}
				return tree[0];
			}

		}
		System.out.print("题型输出完毕");
		return null;
	}

	public TreeNode getDictionarySubject() {
		String hql = "select G.*,level as Level_ \r\n"
				+ "	from (select id_, class_,parent_,name_,localname_,sort_,status_,type_ \r\n"
				+ "			from jot_id_group \r\n"
				+ "			   where id_ != parent_ \r\n" + "		  ) G \r\n"
				+ "  start with parent_= -4 \r\n"
				+ " connect by prior id_=parent_";
		if (this.session == null) {
			this.setSession(HibernateSessionFactory.getSession());
		}
		TreeNode treeData = new TreeNodeBase("Office", "考试科目", "-4", false);
		List lt = this.session.createSQLQuery(hql).addEntity(
				DepartmentTree.class).list();

		DepartmentTree[] department = new DepartmentTree[lt.size()];

		if (lt.size() > 0) {
			int root = 0;
			int[] position = new int[lt.size()];
			position[0] = 0;
			TreeNode[] tree = new TreeNode[lt.size()];
			for (int i = 0; i < lt.size(); i++) {
				department[i] = (DepartmentTree) lt.get(i);
				tree[i] = new TreeNodeBase("Locate", department[i]
						.getLocalName(), department[i].getId() + "", false);
				if (i > 0) {
					if (department[i].getLevel().equals(
							department[0].getLevel())) {
						root++;
						position[root] = i;
					}
				}
			}

			if (root > 0) {
				for (int i = 0; i < department.length; i++) {
					for (int j = 0; j < department.length; j++) {
						if (department[j].getParent().equals(
								department[i].getId())) {
							tree[i].getChildren().add(tree[j]);
						}
					}
				}

				for (int i = 0; i < root + 1; i++) {
					treeData.getChildren().add(tree[position[i]]);
				}
				return treeData;
			} else {

				tree[0] = new TreeNodeBase("Locate", department[0]
						.getLocalName(), department[0].getId() + "", false);

				for (int i = 0; i < department.length; i++) {
					for (int j = i + 1; j < department.length; j++) {
						if (department[j].getParent().equals(
								department[i].getId())) {
							tree[i].getChildren().add(tree[j]);
						}
					}
				}
				return tree[0];
			}

		}
		return null;
	}
	
	public TreeNode getDcitionaryType() {
		String hql = "select G.*,level as Level_ \r\n"
				+ "	from (select id_, class_,parent_,name_,localname_,sort_,status_,type_ \r\n"
				+ "			from jot_id_group \r\n"
				+ "			   where id_ != parent_ \r\n" + "		  ) G \r\n"
				+ "  start with parent_= -5 \r\n"
				+ " connect by prior id_=parent_";
		if (this.session == null) {
			this.setSession(HibernateSessionFactory.getSession());
		}
		TreeNode treeData = new TreeNodeBase("Office", "试题类型", "-5", false);
		List lt = this.session.createSQLQuery(hql).addEntity(
				DepartmentTree.class).list();

		DepartmentTree[] department = new DepartmentTree[lt.size()];

		if (lt.size() > 0) {
			int root = 0;
			int[] position = new int[lt.size()];
			position[0] = 0;
			TreeNode[] tree = new TreeNode[lt.size()];
			for (int i = 0; i < lt.size(); i++) {
				department[i] = (DepartmentTree) lt.get(i);
				tree[i] = new TreeNodeBase("Locate", department[i]
						.getLocalName(), department[i].getId() + "", false);
				if (i > 0) {
					if (department[i].getLevel().equals(
							department[0].getLevel())) {
						root++;
						position[root] = i;
					}
				}
			}

			if (root > 0) {
				for (int i = 0; i < department.length; i++) {
					for (int j = 0; j < department.length; j++) {
						if (department[j].getParent().equals(
								department[i].getId())) {
							tree[i].getChildren().add(tree[j]);
						}
					}
				}

				for (int i = 0; i < root + 1; i++) {
					treeData.getChildren().add(tree[position[i]]);
				}
				return treeData;
			} else {

				tree[0] = new TreeNodeBase("Locate", department[0]
						.getLocalName(), department[0].getId() + "", false);

				for (int i = 0; i < department.length; i++) {
					for (int j = i + 1; j < department.length; j++) {
						if (department[j].getParent().equals(
								department[i].getId())) {
							tree[i].getChildren().add(tree[j]);
						}
					}
				}
				return tree[0];
			}

		}
		return null;
	}

	public TreeNode getPaperSetTree(User user) {
		// TODO Auto-generated method stub
		return null;
	}

	public TreeNodeChecked getExaminationDepartmentAndUserTree(Long eid) {
		// TODO Auto-generated method stub
		return null;
	}

	public TreeNode getExaminationTree() {
		String hql = " FROM Examination";

		if (this.session == null) {
			this.setSession(HibernateSessionFactory.getSession());
		}
		this.session.clear();
		TreeNode treeData = new TreeNodeBase("Office", "考试管理", "30",
				false);
		List lt = this.session.createQuery(hql).list();
		Examination examination = null;
		for(int i=0;i<lt.size();i++){
			examination = (Examination)lt.get(i);
			TreeNode et = new TreeNodeBase("Locate",examination.getName(),examination.getId()+"",true);
			treeData.getChildren().add(et);
		}
		return treeData;
	}

	
}