hibernate查询语言

package com.ittx.hibernate.dao;import java.util.Date;import java.util.List;import org.hibernate.Query;import org.hibernate.Session;import org.hibernate.SessionFactory;import org.hibernate.boot.registry.StandardServiceRegistryBuilder;import org.hibernate.cfg.Configuration;import org.junit.After;import org.junit.Before;import org.junit.Test;import com.ittx.hibernate.model.User;public class UserTest {Session session;//junit测试，先执行before,后内容，最后执行after，这样减少重复代码量@Beforepublic void before(){Configuration configuration = new Configuration().configure();SessionFactory sessionFactory = configuration.buildSessionFactory(new StandardServiceRegistryBuilder().applySettings(configuration.getProperties()).build());session = sessionFactory.getCurrentSession();  //sessionFactory.openSession()session.beginTransaction();}@Afterpublic void after(){session.getTransaction().commit();}@Testpublic void testAddUser() {User user = new User(1,"张三","abcd",new Date());session.save(user);}@Testpublic void testSelectUserById(){//User user = (User) session.get(User.class, 1);User user = (User) session.load(User.class, 1);System.out.println(user);}@Testpublic void testUpdate(){//User user = new User(1,"李四1","123",new Date());//session.update(user);User user = (User) session.get(User.class, 1);user.setUserName("王二");session.update(user);}@Testpublic void testDelete(){//User user = new User(1,"李四1","123",new Date());//session.delete(user);User user = (User)session.get(User.class, 2);session.delete(user);}@Testpublic void testSelectAllUser(){String hql = "FROM User ORDER BY id DESC ";Query query = session.createQuery(hql);List<User> userLists = query.list();for(User user:userLists){System.out.println(user);}}@Testpublic void testSelectUserName(){String hql = "SELECT u.userName FROM User AS u";Query query = session.createQuery(hql);List<String> userLists = query.list();for(String user:userLists){System.out.println(user);}}@Testpublic void testSelectdUserByUsername(){String hql = "FROM User WHERE userName = :name AND passWord = :psw";Query query = session.createQuery(hql);query.setParameter("name", "张三");query.setParameter("psw", "abcd");User user = (User) query.uniqueResult();System.out.println(user);}@Testpublic void testUpdateUsers(){String hql = "UPDATE User SET userName=:name WHERE passWord=:psw";Query query = session.createQuery(hql);query.setParameter("name", "麻子");query.setParameter("psw", "123");int order = query.executeUpdate();System.out.println("order :"+order);}@Testpublic void testDeleteUserByUserName(){String hql = "DELETE User WHERE userName = :name";Query query = session.createQuery(hql);query.setParameter("name", "张三");query.executeUpdate();}}