dbaccessnews.java

这是一个上传下载的原代码

		}catch(HibernateException ex){
			ex.printStackTrace();
		}finally{
			this.release(session);
			HibernateUtil.closeSessio(session);
		}
		return map;
	}
	/**
	 * @author YangSen
	 * @描述 经济运行工作显示模块
	 */
	public Map selectNewsEconomyInfo(int pageNum,int pageSize,String role,String flag) {
		List temp = new ArrayList();
		Map map = new HashMap();
		Query query = null;
		String[] name = new String[]{"工作动态","经济运行月报","经济运行简报"};
		int newsNum = 0;
		try{
			session = this.getSession();
			for(int i=0;i < 3;i++){
				Map tempMap = new HashMap(2);
				newsNum = HibernateUtil.getNewsNum(session,"经济运行工作",name[i],role);
				if(name[i].equals(flag)){
					query = session.createSQLQuery("select {a.*} from (select * from erma_news_info order by createDate desc ) a where sort='" + name[i] + "' and newrole in ('0','"+ role +"')").addEntity("a", NewsInfo.class);
					temp = HibernateUtil.paginationQuery(query, pageNum, pageSize);
					tempMap.put(name[i], temp);
					tempMap.put("newsNum", newsNum);
				}else{
					query = session.createSQLQuery("select {a.*} from (select * from erma_news_info order by createDate desc ) a where sort='" + name[i] + "' and newrole in ('0','"+ role +"')").addEntity("a", NewsInfo.class);
					temp = HibernateUtil.paginationQuery(query, 0, pageSize);
					tempMap.put(name[i], temp);
					tempMap.put("newsNum", newsNum);
				}
				map.put(name[i], tempMap);
			}
		}catch(HibernateException ex){
			ex.printStackTrace();
		}finally{
			this.release(session);
			HibernateUtil.closeSessio(session);
		}
		return map;
	}
	/**
	 * @author YangSen
	 * @描述 省市情况显示模块
	 */
	public Map selectNewsCityCircsInfo(int pageNum,int pageSize,String role,String flag) {
		List temp = new ArrayList();
		Map map = new HashMap();
		Query query = null;
		String[] name = new String[]{"地方动态"};
		int newsNum = 0;
		try{
			session = this.getSession();
			for(int i=0;i < 1;i++){
				Map tempMap = new HashMap(2);
				newsNum = HibernateUtil.getNewsNum(session,"地方动态",name[i],role);
				if(name[i].equals(flag)){
					query = session.createSQLQuery("select {a.*} from (select * from erma_news_info order by createDate desc ) a where sort='" + name[i] + "' and newrole in ('0','"+ role +"')").addEntity("a", NewsInfo.class);
					temp = HibernateUtil.paginationQuery(query, pageNum, pageSize);
					tempMap.put(name[i], temp);
					tempMap.put("newsNum", newsNum);
				}else{
					query = session.createSQLQuery("select {a.*} from (select * from erma_news_info order by createDate desc ) a where sort='" + name[i] + "' and newrole in ('0','"+ role +"')").addEntity("a", NewsInfo.class);
					temp = HibernateUtil.paginationQuery(query, 0, pageSize);
					tempMap.put(name[i], temp);
					tempMap.put("newsNum", newsNum);
				}
				map.put(name[i], tempMap);
			}
		}catch(HibernateException ex){
			ex.printStackTrace();
		}finally{
			this.release(session);
			HibernateUtil.closeSessio(session);
		}
		return map;
	}
	/**
	 * @author YangSen
	 * @描述 index页面 初始化数据
	 */
	public Map selectAllNews(String role) {
		Map map = new HashMap();
		Query query = null;
		String[] name = new String[]{"政策动态","运行动态","综合分析","行业分析","网摘信息","工作动态","经济运行月报","经济运行简报","地方动态"};
		NewsInfo newsInfo = new NewsInfo();
		try{
			session = this.getSession();
			for(int i=0;i < 9;i++){
				query = session.createSQLQuery("select {a.*} from (select * from erma_news_info order by createDate desc ) a where sort='" + name[i] + "' and rownum <=3 and newrole in ('0','"+ role +"')").addEntity("a", NewsInfo.class);
				map.put(name[i], query.list());
			}
			query = session.createSQLQuery("select {a.*} from (select * from erma_news_info order by createDate desc ) a where kind='通知公告' and rownum <=3 and newrole in ('0','"+ role +"')").addEntity("a",NewsInfo.class);
			map.put("通知公告", query.list());
			query = session.createSQLQuery("select {a.*} from (select * from erma_news_info order by createDate desc ) a where kind='信息服务' and rownum <=3").addEntity("a",NewsInfo.class);
			map.put("信息服务", query.list());
			query = session.createQuery("from NewsInfo where kind='滚动条'");
			newsInfo = (NewsInfo)query.list().get(0);
			try {
				map.put("滚动条", (newsInfo.getContent()==null)?"热烈庆祝网站开通":newsInfo.getContent().getSubString(1, (int)newsInfo.getContent().length()));
			} catch (SQLException e) {
				e.printStackTrace();
			}
		}catch(HibernateException ex){
			ex.printStackTrace();
		}finally{
			this.release(session);
			HibernateUtil.closeSessio(session);
		}
		return map;
	}
	/**
	 * @author Yangsen
	 * @return 返回要查找的新闻对象
	 */
	public Map selectNewsContent(String newsId) {
		Accessories acc = null;
		NewsInfo newsInfo = null;
		List list = new ArrayList();
		Map map = new HashMap();
		try{
			session = this.getSession();
			newsInfo = (NewsInfo)session.get(NewsInfo.class,newsId);
			Set set = newsInfo.getAccessoriess();
			if(set != null || set.size() > 0){
				Iterator it = set.iterator();
				while(it.hasNext()){
					acc = (Accessories)it.next();
					list.add(acc);
				}
			}
		}catch(HibernateException ex){
			ex.fillInStackTrace();
		}finally{
			this.release(session);
			HibernateUtil.closeSessio(session);
		}
		map.put("newsInfo", newsInfo);
		map.put("accInfo",list);
		return map;
	}
	/**
	 * @author YangSen
	 * @描述 根据条件进行自由查询
	 */
	public Map selectQueryNews(QueryNewsForm form,int pageNum,int pageSize,String role) {
		List list = null;
		Map map = new HashMap();
		DetachedCriteria deat = null;
		try {
			session = this.getSession();
			deat = DetachedCriteria.forClass(NewsInfo.class);
			
			if(!"".equals(form.getTitle())){
				deat.add(Restrictions.like("title", form.getTitle(),MatchMode.ANYWHERE));
			}if(!"".equals(form.getKey())){
				deat.add(Restrictions.like("newsKey", form.getKey(),MatchMode.ANYWHERE));
			}if(!"全部".equals(form.getKind())){
				deat.add(Restrictions.eq("kind", form.getKind()));
			}if(!"".equals(form.getStartTime())){
				deat.add(Restrictions.ge("createDate", form.getStartTime()));
			}if(!"".equals(form.getEndTime())){
				deat.add(Restrictions.le("createDate", form.getEndTime()));
			}if(!"".equals(role)){
				String[] name = {"0",role};
				deat.add(Restrictions.in("newsRole", name));
			}
			deat.addOrder(Order.desc("createDate"));
			list = HibernateUtil.findNews(deat, session,pageNum,pageSize);
			map.put("newsInfo", list.get(1));
			map.put("newsNum", list.get(0));
		}catch(HibernateException ex) {
			ex.printStackTrace();
		}finally{
			this.release(session);
			HibernateUtil.closeSessio(session);
		}
		return map;
	}
	/**
	 * @author YangSen
	 * @描述 查询所有公告信息
	 */
	public Map selectAffiche(int pageNum, int pageSize, String role) {
		Map map = new HashMap();
		Query query = null; 
		List list = null;
		try{
			session = this.getSession();
			query = session.createQuery("from NewsInfo where kind='通知公告' and newrole in ('0','" + role + "') order by createDate desc");
			list = query.list();
			map.put("afficheInfo", list);
			map.put("newsNum", list.size());
		}catch(HibernateException ex){
			ex.fillInStackTrace();
		}finally{
			this.release(session);
			HibernateUtil.closeSessio(session);
		}
		return map;
	}
	/**
	 * @author YangSen
	 * @描述  文件列表读取
	 */
	public Map selectServiceInfo(int pageNum,int pageSize) {
		Query query = null;
		Map map = new HashMap();
		int newsNum = 0;
		List temp = new ArrayList();
		try{
			session = this.getSession();
			newsNum = HibernateUtil.getNewsNum(session,"信息服务");
			query = session.createSQLQuery("select {a.*} from (select * from erma_news_info order by createDate desc ) a where kind='信息服务'").addEntity("a", NewsInfo.class);
			temp = HibernateUtil.paginationQuery(query, pageNum, pageSize);
			map.put("newsNum", newsNum);
			map.put("serviceInfo", temp);
		}catch(HibernateException ex){
			ex.printStackTrace();
		}finally{
			this.release(session);
			HibernateUtil.closeSessio(session);
		}
		return map;
	}
	/**
	 * @author YangSen
	 * @描述 上传文件
	 */
	public boolean upload(NewsInfo newsInfo) {
		this.getHibernateTemplate().save(newsInfo);
		return true;
	}
	/**
	 * @author YangSen
	 * @描述 下载文件
	 */
	public List downLoad(String newsId) {
		return this.getHibernateTemplate().find("from NewsInfo where newsId=?",newsId);
	}
	/**
	 * @author YangSen
	 * @描述 删除信息服务
	 */
	public boolean deleteServiceInfo(NewsInfo newsInfo) {
		this.getHibernateTemplate().delete(newsInfo);
		return true;
	}
	/**
	 * @author YangSen
	 * @描述 编辑信息服务
	 */
	public List editServiceInfo(String newsId) {
		return	this.getHibernateTemplate().find("from NewsInfo where newsId=?", newsId);
	}
	/**
	 * @author YangSen
	 * @描述 编辑信息服务提交
	 */
	public boolean editServiceInfoSubmit(NewsInfo newsInfo) {
		this.getHibernateTemplate().update(newsInfo);
		return	true;
	}
	/**
	 * @author YangSen
	 * @描述 清空缓存
	 */
	public void release(Session session) {
		this.session.flush();
		this.session.clear();
	}
}