connection proxy not usable after transaction comp

最新推荐文章于 2023-07-11 20:55:31 发布

最新推荐文章于 2023-07-11 20:55:31 发布 · 93 阅读

文章标签：

本文介绍了一个Java实现的任务线段与点的数据获取方法，通过数据库查询获取特定层级的任务线段及其上各点的信息，并返回给调用者。同时，还提供了一个按时间筛选计划的方法。

public class PlanDAOImpl extends GenericHibernateDAO<Plan, String> implements
		PlanDAO {
	private Logger logger = Logger.getLogger("MonthPlanDAOImpl");
	private QueryUtil query;

	public PlanDAOImpl() {
		query = new QueryUtil();
	}

	public int findByTime(String value,String groupid) {
		String hql = "from Plan where endtime>to_date('"+value+"','yyyy/mm/dd') and begintime<to_date('"+value+"','yyyy/mm/dd')";
		Query hquery = getSession().createQuery(hql);
		//hquery.setParameter("month", value);
		return hquery.list().size();
	}

	// 任务线段及点
	public List<TreeNode> getLines(String linelevel, String patrolgroupid)
			throws Exception {
		String sql = "select sublineid id,sublinename name from sublineinfo s,lineinfo l where l.lineid = s.lineid and s.state !="+SysConstant.STATE_DEL+" and l.linelevel ='"
				+ linelevel + "' and s.patrolgroupid='" + patrolgroupid + "' ";
		logger.info("getModuleMenu:" + sql);
		//if (query == null)
		//query = new QueryUtil();
		List<TreeNode> lines = new ArrayList<TreeNode>();
		List<BasicDynaBean> linesBean = query.queryBeans(sql);
		for (BasicDynaBean bean : linesBean) {
			TreeNode node = new TreeNode();
			String ID = (String) bean.get("id");
			String Name = (String) bean.get("name");
			node.setID(ID);
			node.setName(Name);
			node.setSon(getPoints(ID));// 获得线段上的点
			lines.add(node);
		}
		return lines;
	}

	// 获得线段上的点
	private List<TreeNode> getPoints(String id) throws Exception {
		String sql = "select pointname name,pointid id from pointinfo where sublineid='"
				+ id + "' order by inumber";
		//query = new QueryUtil();
		List<TreeNode> points = new ArrayList<TreeNode>();
		List<BasicDynaBean> beanPoints = query.queryBeans(sql);
		for (BasicDynaBean bean : beanPoints) {
			TreeNode node = new TreeNode();
			String ID = (String) bean.get("id");
			String Name = (String) bean.get("name");
			node.setID(ID);
			node.setName(Name);
			points.add(node);
		}
		return points;
	}

注意QueryUtil对象创建的位置。

public class PlanDAOImpl extends GenericHibernateDAO<Plan, String> implements
		PlanDAO {
	private Logger logger = Logger.getLogger("MonthPlanDAOImpl");
	private QueryUtil query;

	public PlanDAOImpl() {

	}

	public int findByTime(String value,String groupid) {
		String hql = "from Plan where endtime>to_date('"+value+"','yyyy/mm/dd') and begintime<to_date('"+value+"','yyyy/mm/dd')";
		Query hquery = getSession().createQuery(hql);
		//hquery.setParameter("month", value);
		return hquery.list().size();
	}

	// 任务线段及点
	public List<TreeNode> getLines(String linelevel, String patrolgroupid)
			throws Exception {
		String sql = "select sublineid id,sublinename name from sublineinfo s,lineinfo l where l.lineid = s.lineid and s.state !="+SysConstant.STATE_DEL+" and l.linelevel ='"
				+ linelevel + "' and s.patrolgroupid='" + patrolgroupid + "' ";
		logger.info("getModuleMenu:" + sql);
		//if (query == null)
		query = new QueryUtil();
		List<TreeNode> lines = new ArrayList<TreeNode>();
		List<BasicDynaBean> linesBean = query.queryBeans(sql);
		for (BasicDynaBean bean : linesBean) {
			TreeNode node = new TreeNode();
			String ID = (String) bean.get("id");
			String Name = (String) bean.get("name");
			node.setID(ID);
			node.setName(Name);
			node.setSon(getPoints(ID));// 获得线段上的点
			lines.add(node);
		}
		return lines;
	}

	// 获得线段上的点
	private List<TreeNode> getPoints(String id) throws Exception {
		String sql = "select pointname name,pointid id from pointinfo where sublineid='"
				+ id + "' order by inumber";
		query = new QueryUtil();
		List<TreeNode> points = new ArrayList<TreeNode>();
		List<BasicDynaBean> beanPoints = query.queryBeans(sql);
		for (BasicDynaBean bean : beanPoints) {
			TreeNode node = new TreeNode();
			String ID = (String) bean.get("id");
			String Name = (String) bean.get("name");
			node.setID(ID);
			node.setName(Name);
			points.add(node);
		}
		return points;
	}