在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;
}
}