gethibernate.java

该源代码是关于一个博客网站的源码

				tx = (Transaction) session.beginTransaction();
				Query query = session
						.createQuery("from Article as c where c.typeID =:aid");
				query.setInteger("aid", aid);
				query.setFirstResult(intFrist);
				query.setMaxResults(intPages);
				list = query.list();
				tx.commit();
				hib.closeSession(session);
			} catch (Exception e) {
			    e.printStackTrace();
			    tx.rollback(); 
			}
			return list;
		}
//		查看文章类型
		public  List findArity(int aid) {
			Transaction tx = null;
			List list = null;
			try {
				session = hib.openSession();
				tx = (Transaction) session.beginTransaction();
				Query query = session
						.createQuery("from Article as c where c.typeID =:aid");
				query.setInteger("aid", aid);
				list = query.list();
				tx.commit();
				hib.closeSession(session);
			} catch (Exception e) {
			    e.printStackTrace();
			    tx.rollback(); 
			}
			return list;
		}
		//查看文档总数
		public int findAritiCount(int aid) {
			   Transaction tx = null;
				int intCount=0;
				try {
					session = hib.openSession();
					tx = (Transaction) session.beginTransaction();
					intCount = ((Integer) session.createQuery("select count(*)from Article u  where u.typeID ="+"'"+aid+"'").uniqueResult()).intValue();
					tx.commit();
					hib.closeSession(session);
				} catch (Exception e) {
					e.printStackTrace();
					tx.rollback(); 
				}
				return intCount;
			}
//		查看所有公告信息,并分页
		public  List findDiss(int intFrist,int intPages) {
			Transaction tx = null;
			List list = null;
			try {
				session = hib.openSession();
				tx = (Transaction) session.beginTransaction();
				Query query = session
						.createQuery("from Discuss");
				query.setFirstResult(intFrist);
				query.setMaxResults(intPages);
				list = query.list();
				tx.commit();
				hib.closeSession(session);
			} catch (Exception e) {
			    e.printStackTrace();
			    tx.rollback(); 
			}
			return list;
		}
//查询公告总数
		public int findDissCount() {
			   Transaction tx = null;
				int intCount=0;
				try {
					session = hib.openSession();
					tx = (Transaction) session.beginTransaction();
					intCount = ((Integer) session.createQuery("select count(*)from Discuss").uniqueResult()).intValue();
					tx.commit();
					hib.closeSession(session);
				} catch (Exception e) {
					e.printStackTrace();
					tx.rollback(); 
				}
				return intCount;
			}
//		查看所有照片方法
		public  List findPhoto(int intFrist,int intPages) {
			Transaction tx = null;
			List list = null;
			try {
				session = hib.openSession();
				tx = (Transaction) session.beginTransaction();
				Query query = session
						.createQuery("from Photo");
				query.setFirstResult(intFrist);
				query.setMaxResults(intPages);
				list = query.list();
				tx.commit();
				hib.closeSession(session);
			} catch (Exception e) {
			    e.printStackTrace();
			    tx.rollback(); 
			}
			return list;
		}
//查询照片总数
		public int findPhotoCount() {
			   Transaction tx = null;
				int intCount=0;
				try {
					session = hib.openSession();
					tx = (Transaction) session.beginTransaction();
					intCount = ((Integer) session.createQuery("select count(*)from Photo").uniqueResult()).intValue();
					tx.commit();
					hib.closeSession(session);
				} catch (Exception e) {
					e.printStackTrace();
					tx.rollback(); 
				}
				return intCount;
			}
//按照id号查看公告总数
		public  List findDiss(int aid) {
			Transaction tx = null;
			List list = null;
			try {
				session = hib.openSession();
				tx = (Transaction) session.beginTransaction();
				Query query = session
						.createQuery("from Discuss as c where c.id=:aid");
				query.setInteger("aid", aid);
				list = query.list();
				tx.commit();
				hib.closeSession(session);
			} catch (Exception e) {
			    e.printStackTrace();
			    tx.rollback(); 
			}
			return list;
		}
		
//	查看文章类型id
		public  List findAid(String strname) {
			Transaction tx = null;
			List list = null;
			try {
				session = hib.openSession();
				tx = (Transaction) session.beginTransaction();
				Query query = session
						.createQuery("from AriticleType as u where u.typeName=:strname");
				query.setString("strname", strname);
				
				list = query.list();
				tx.commit();
				hib.closeSession(session);
			} catch (Exception e) {
			    e.printStackTrace();
			    tx.rollback(); 
			}
			return list;
		}
//		保存文章
		public  void saveArricle(Article ariticle) {
			Transaction tx = null;
			try {
				session = hib.openSession();
				tx = (Transaction) session.beginTransaction();
				session.save(ariticle);
				tx.commit();
				hib.closeSession(session);
			} catch (Exception e) {
				e.printStackTrace();
				tx.rollback(); 
			}
		}
//		按照id号查找照片
		public  List findPhotoId(int id) {
			Transaction tx = null;
			List list = null;
			try {
				session = hib.openSession();
				tx = (Transaction) session.beginTransaction();
				Query query = session
						.createQuery("from Photo as p where p.id=:id");
				query.setInteger("id", id);
				
				list = query.list();
				tx.commit();
				hib.closeSession(session);
			} catch (Exception e) {
			    e.printStackTrace();
			    tx.rollback(); 
			}
			return list;
		}
//		删除照片方法
		public  void deletePhoto(Photo photo) {
			Transaction tx = null;
			try {
				session = hib.openSession();
				tx = (Transaction) session.beginTransaction();
				session.delete(photo);
				tx.commit();
				hib.closeSession(session);
			} catch (Exception e) {
				e.printStackTrace();
				tx.rollback(); 
			}
		}
//		保存日志信息
		public  void saveVote(Vote vote) {
			Transaction tx = null;
			try {
				session = hib.openSession();
				tx = (Transaction) session.beginTransaction();
				session.save(vote);
				tx.commit();
				hib.closeSession(session);
			} catch (Exception e) {
				e.printStackTrace();
				tx.rollback(); 
			}
		}
//		修改日志信息
		public  void updateVote(Vote vote) {
			Transaction tx = null;
			try {
				session = hib.openSession();
				tx = (Transaction) session.beginTransaction();
				session.update(vote);
				tx.commit();
				hib.closeSession(session);
			} catch (Exception e) {
				e.printStackTrace();
				tx.rollback(); 
			}
		}
//		修改日志信息
		public  void deleVote(Vote vote) {
			Transaction tx = null;
			try {
				session = hib.openSession();
				tx = (Transaction) session.beginTransaction();
				session.delete(vote);
				tx.commit();
				hib.closeSession(session);
			} catch (Exception e) {
				e.printStackTrace();
				tx.rollback(); 
			}
		}
//		保存照片信息
		public  void savePhoto(Photo photo) {
			Transaction tx = null;
			try {
				session = hib.openSession();
				tx = (Transaction) session.beginTransaction();
				session.save(photo);
				tx.commit();
				hib.closeSession(session);
			} catch (Exception e) {
				e.printStackTrace();
				tx.rollback(); 
			}
		}
//		保存文章类型
		public  void saveArricleType(AriticleType ariticle) {
			Transaction tx = null;
			try {
				session = hib.openSession();
				tx = (Transaction) session.beginTransaction();
				session.save(ariticle);
				tx.commit();
				hib.closeSession(session);
			} catch (Exception e) {
				e.printStackTrace();
				tx.rollback(); 
			}
		}
//		查看所有日志信息
		public  List findVito() {
			Transaction tx = null;
			List list = null;
			try {
				session = hib.openSession();
				tx = (Transaction) session.beginTransaction();
				Query query = session
						.createQuery("from Vote");
			    list = query.list();
				tx.commit();
				hib.closeSession(session);
			} catch (Exception e) {
			    e.printStackTrace();
			    tx.rollback(); 
			}
			return list;
		}
//		按id号查找日志信息
		public  List findVito(int id) {
			Transaction tx = null;
			List list = null;
			try {
				session = hib.openSession();
				tx = (Transaction) session.beginTransaction();
				Query query = session
						.createQuery("from Vote where id =:id");
				query.setInteger("id", id);
			    list = query.list();
				tx.commit();
				hib.closeSession(session);
			} catch (Exception e) {
			    e.printStackTrace();
			    tx.rollback(); 
			}
			return list;
		}
//		查看所有日志总数
		public  List findVoteP(int intFrist,int intPages) {
			Transaction tx = null;
			List list = null;
			try {
				session = hib.openSession();
				tx = (Transaction) session.beginTransaction();
				Query query = session
						.createQuery("from Vote");
				query.setFirstResult(intFrist);
				query.setMaxResults(intPages);
				list = query.list();
				tx.commit();
				hib.closeSession(session);
			} catch (Exception e) {
			    e.printStackTrace();
			    tx.rollback(); 
			}
			return list;
		}
//		查询日志总数
		public int findVCount() {
			   Transaction tx = null;
				int intCount=0;
				try {
					session = hib.openSession();
					tx = (Transaction) session.beginTransaction();
					intCount = ((Integer) session.createQuery("select count(*)from Vote").uniqueResult()).intValue();
					tx.commit();
					hib.closeSession(session);
				} catch (Exception e) {
					e.printStackTrace();
					tx.rollback(); 
				}
				return intCount;
			}
//		保存好友信息
		public  void saveFriend(Friend friend) {
			Transaction tx = null;
			try {
				session = hib.openSession();
				tx = (Transaction) session.beginTransaction();
				session.save(friend);
				tx.commit();
				hib.closeSession(session);
			} catch (Exception e) {
				e.printStackTrace();
				tx.rollback(); 
			}
		}
//		查看所有好友并分页
		public  List findFriend(int intFrist,int intPages) {
			Transaction tx = null;
			List list = null;
			try {
				session = hib.openSession();
				tx = (Transaction) session.beginTransaction();
				Query query = session
						.createQuery("from Friend");
				query.setFirstResult(intFrist);
				query.setMaxResults(intPages);
				list = query.list();
				tx.commit();
				hib.closeSession(session);
			} catch (Exception e) {
			    e.printStackTrace();
			    tx.rollback(); 
			}
			return list;
		}
//		查询所有好友总数
		public int findFriendCount() {
			   Transaction tx = null;
				int intCount=0;
				try {
					session = hib.openSession();
					tx = (Transaction) session.beginTransaction();
					intCount = ((Integer) session.createQuery("select count(*)from Friend").uniqueResult()).intValue();
					tx.commit();
					hib.closeSession(session);
				} catch (Exception e) {
					e.printStackTrace();
					tx.rollback(); 
				}
				return intCount;
			}
//		修改好友信息
		public void updateFrinend(Friend friend) {
			Transaction tx = null;
			try {
				session = hib.openSession();
				tx = (Transaction) session.beginTransaction();
				session.update(friend);
				tx.commit();
				hib.closeSession(session);
			} catch (Exception e) {
				e.printStackTrace();
				tx.rollback(); 
			}
		}
//		删除好友信息
		public void deleteFrinend(Friend friend) {
			Transaction tx = null;
			try {
				session = hib.openSession();
				tx = (Transaction) session.beginTransaction();
				session.delete(friend);
				tx.commit();
				hib.closeSession(session);
			} catch (Exception e) {
				e.printStackTrace();
				tx.rollback(); 
			}
		}
//		按照id号查找好友
		public  List findFriend(int id) {
			Transaction tx = null;
			List list = null;
			try {
				session = hib.openSession();
				tx = (Transaction) session.beginTransaction();
				Query query = session
						.createQuery("from Friend where id =:id");
				query.setInteger("id",id);
			    list = query.list();
				tx.commit();
				hib.closeSession(session);
			} catch (Exception e) {
			    e.printStackTrace();
			    tx.rollback(); 
			}
			return list;
		}
public static void main(String args[]){	  
	Gethibernate gethib = new Gethibernate();
	List list = gethib.findFriend(2);
	System.out.println("gggggg"+list.size());
	if(list==null){
		System.out.println("ok");
	}
		for(int i = 0;i<list.size();i++){
	     Friend frinend = (Friend)list.get(i);
	     System.out.println(frinend.getDescription());
	}
		
}
}