本文共 3196 字，大约阅读时间需要 10 分钟。
public class DistributeDao implements Serializable{ private SessionFactory sessionFactory; public Session getSession() { return sessionFactory.getCurrentSession(); } public SessionFactory getSessionFactory() { return sessionFactory; } public void setSessionFactory(SessionFactory sessionFactory) { this.sessionFactory = sessionFactory; } public Task getTask(Integer id) { Session session = this.getSession(); Transaction tran = session.beginTransaction(); List datas = session.createQuery("from TestMessage").list();//TestMessage是一个java类，这个类和某一个表对应！ tran.commit(); return datas.get(id); } public void saveTask(Task task) { Session session = this.getSession(); Transaction tran = session.beginTransaction(); session.save(task); tran.commit(); } public List findAllTask() { Session session = this.getSession(); Transaction tran = session.beginTransaction(); List datas = session.createQuery("from Task").list(); tran.commit(); return datas; } public List findAllFinishedTask() { Session session = this.getSession(); Transaction tran = session.beginTransaction(); List datas = session.createQuery("from Task where state=2").list(); tran.commit(); return datas; } public List findUserTaskFinish(String developName){ Session session = this.getSession(); Transaction tran = session.beginTransaction(); String sql="select * from task where task.taskid in (select taskteam.taskid from taskteam where taskteam.developName=\'" + developName + "\') and task.state=2"; List datas = (List )session.createSQLQuery(sql).addEntity(Task.class).list(); tran.commit(); return datas; } public List findUserTaskNoParticipateTask(String developName){ Session session = this.getSession(); Transaction tran = session.beginTransaction(); String sql="select * from task where task.taskid not in (select taskteam.taskid from taskteam where developName=\'" + developName + "\')"; List datas = (List )session.createSQLQuery(sql).addEntity(Task.class).list();//必须有addEntity()方法，否则不能 //返回具体的类型，其实返回的是Object tran.commit(); return datas; } public List findUserTaskParticipating(String developName){ Session session = this.getSession(); Transaction tran = session.beginTransaction(); String sql="select * from task where task.taskid in (select taskteam.taskid from taskteam where developName=\'" + developName + "\') and task.state=1"; List datas = (List )session.createSQLQuery(sql).addEntity(Task.class).list(); tran.commit(); return datas; } public List findTaskAllUser(int taskid){ Session session = this.getSession(); Transaction tran = session.beginTransaction(); String sql="select * from developingparty where developingparty.developName in (select taskteam.developingparty from taskteam where taskteam.taskid=" + taskid + ")"; List datas = session.createSQLQuery(sql).addEntity(DevelopingParty.class).list(); tran.commit(); return datas; }} 转载地址：http://ogfsa.baihongyu.com/