Herbnate session.createsqlquery (SQL) and session.createquery (SQL) use

 Public classDistributedaoImplementsserializable{Privatesessionfactory sessionfactory;  PublicSession getsession () {returnsessionfactory.getcurrentsession (); }         Publicsessionfactory getsessionfactory () {returnsessionfactory; }         Public voidsetsessionfactory (sessionfactory sessionfactory) { This. Sessionfactory =sessionfactory; }           PublicTask gettask (Integer ID) {Session session= This. getsession (); Transaction Tran=session.begintransaction (); List<Task> datas = Session.createquery ("From TestMessage"). List (); //testmessage is a Java class, and this class corresponds to a table!        Tran.commit (); returndatas.get (ID); }     Public voidSavetask (Task Task) {Session Session= This. getsession (); Transaction Tran=session.begintransaction ();         Session.save (Task);    Tran.commit (); }     PublicList<task>Findalltask () {Session session= This. getsession (); Transaction Tran=session.begintransaction (); List<Task> datas = Session.createquery ("From Task"). List ();        Tran.commit (); returndatas; }         PublicList<task>Findallfinishedtask () {Session session= This. getsession (); Transaction Tran=session.begintransaction (); List<Task> datas = Session.createquery ("From Task where state=2"). List ();        Tran.commit (); returndatas; }         PublicList<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=\ '" + Developna Me + "\ ') and task.state=2"; List<Task> datas = (list<task>) session.createsqlquery (SQL). Addentity (Task.class). List ();        Tran.commit (); returndatas; }         PublicList<task>Findusertasknoparticipatetask (String Developname) {Session session= This. getsession (); Transaction Tran=session.begintransaction (); String SQL= "SELECT * from the 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 ();//Must have Addentity () method, otherwise you cannot
Return the specific type, actually return is Object Tran.commit (); returndatas; }         PublicList<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 (); returndatas; }         PublicList<developingparty> Findtaskalluser (intTaskID) {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 (); returndatas; }}

Herbnate session.createsqlquery (SQL) and session.createquery (SQL) use