简易java的旅行代理GUI系统

package com.whut.service; import java.util.List; import org.hibernate.Query; import org.hibernate.Session; import org.hibernate.SessionFactory; import org.hibernate.cfg.AnnotationConfiguration; import com.whut.model.Client; import com.whut.model.Groups; import com.whut.model.Guide; import com.whut.model.Orders; import com.whut.model.Rout; public class Services { public Session getSession() { SessionFactory sessionFatory = new AnnotationConfiguration().configure().buildSessionFactory(); Session ss=sessionFatory.getCurrentSession(); return ss; } //添加新用户 public void addClient(Client clt) { Session ss = getSession(); ss.beginTransaction(); ss.save(clt); ss.getTransaction().commit(); } //添加客户订单 public int addOrders(Orders ord) { Session ss = getSession(); ss.beginTransaction(); ss.save(ord); ss.getTransaction().commit(); int number=ord.getId(); return number; } //登录的检查 public int checkClient(String userName,String password) { Session session = getSession(); session.beginTransaction(); Query q = session.createQuery("select c.id from Client c where c.password= :pw and c.username= :user"); q.setParameter("pw", password); q.setParameter("user", userName); Integer count = (Integer)q.uniqueResult(); session.getTransaction().commit(); if(count==null) return 0; else return count; } //旅行路线查询 public List<Rout> getRout()//读取该用户进行的那些操作 { Session ss = getSession(); ss.beginTransaction(); Query q = ss.createQuery("from Rout"); List<Rout> rout= (List<Rout>)q.list();//a new method ss.getTransaction().commit(); return rout; } //旅行旅行团查询查询 public List<Groups> getGroup()//读取该用户进行的那些操作 { Session ss = getSession(); ss.beginTransaction(); Query q = ss.createQuery("from Groups"); List<Groups> group= (List<Groups>)q.list();//a new method ss.getTransaction().commit(); return group; } //导游查询 public List<Guide> getGuide()//读取该用户进行的那些操作 { Session ss = getSession(); ss.beginTransaction(); Query q = ss.createQuery("from Guide"); List<Guide> guide= (List<Guide>)q.list();//a new method ss.getTransaction().commit(); return guide; } //判断户型id的正确性 public Groups checkGroups(int id) { Session ss=getSession(); ss.beginTransaction(); Groups fam=(Groups)ss.get(Groups.class,id); ss.getTransaction().commit(); return fam; } //获取该登记客户的对象的正确性 public Client getClient(String userName,String password) { Session session = getSession(); session.beginTransaction(); Query q = session.createQuery("select c.id from Client c where c.password= :pw and c.username= :user"); q.setParameter("pw", password); q.setParameter("user", userName); Integer count = (Integer)q.uniqueResult(); Client ars1=(Client)session.get(Client.class,count); session.getTransaction().commit(); return ars1; } //订单显示返回主键 //判断户型id的正确性 public Orders getOrders(int id) { Session ss=getSession(); ss.beginTransaction(); Orders fam=(Orders)ss.get(Orders.class,id); ss.getTransaction().commit(); return fam; } }