当前位置：Gxlcms >
数据库问题 >
herbnate session.createSQLQuery(sql) 和 session.createQuery(sql)使用
herbnate session.createSQLQuery(sql) 和 session.createQuery(sql)使用
时间：2021-07-01 10:21:17
帮助过：2人阅读
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<Task> 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<Task>
findAllTask() {
Session session =
this.getSession();
Transaction tran =
session.beginTransaction();
List<Task> datas = session.createQuery("from Task"
).list();
tran.commit();
return datas;
}
public List<Task>
findAllFinishedTask() {
Session session =
this.getSession();
Transaction tran =
session.beginTransaction();
List<Task> datas = session.createQuery("from Task where state=2"
).list();
tran.commit();
return datas;
}
public List<Task>
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<Task> datas = (List<Task>)session.createSQLQuery(sql).addEntity(Task.
class).list();
tran.commit();
return datas;
}
public List<Task>
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<Task> datas = (List<Task>)session.createSQLQuery(sql).
addEntity(Task.class).list();//必须有addEntity()方法，否则不能
//返回具体的类型，其实返回的是Object
tran.commit();
return datas;
}
public List<Task>
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<Task> datas = (List<Task>)session.createSQLQuery(sql).addEntity(Task.
class).list();
tran.commit();
return datas;
}
public List<DevelopingParty> 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<DevelopingParty> datas = session.createSQLQuery(sql).addEntity(DevelopingParty.
class).list();
tran.commit();
return datas;
}
}
herbnate session.createSQLQuery(sql) 和 session.createQuery(sql)使用
标签：
