homework hibernate 5（1314010420 王弘智）

在hibernate编写hql中实现查询

附截图

import java.util.List;

import org.hibernate.Session;
import org.hibernate.SessionFactory;
import org.hibernate.Transaction;
import org.hibernate.cfg.Configuration;
import org.hibernate.query.Query;


import demo.entity.User;


public class Main {
    public static void main(String[] args) {
        // 读取hibernate.cfg.xml文件
        Configuration cfg = new Configuration().configure();
        // 建立SessionFactory
        SessionFactory factory = cfg.buildSessionFactory();
        // 建立Session
        Session session = factory.getCurrentSession();
        Transaction transaction = null;
        try {
            // 得到事务对象
            transaction = session.beginTransaction();
            // 查询操作
            String hql = "from User where username=:username";
            Query<User> query = session.createQuery(hql, User.class);
            query.setParameter("username", "xxx");
            List<User> list = query.getResultList();
            for (User user : list) {
                System.out.print(user.getUserId() + ", " + user.getUsername() + ", ");
                System.out.println(user.getNickname() + ", " + user.getPassword());
            }
            // 提交事务
            transaction.commit();
        } catch (Exception e) {
            if (transaction != null) {
                // 事务回滚
                transaction.rollback();
            }
            e.printStackTrace();
        }
        return;
    }
}