简单查询
@Override
public List<XXX> getXXXList() {
List<XXX> result = new ArrayList<XXX>();
Session session = null;
try {
session = getSession();
String hql = " FROM XXX order by id ";
Query query = session.createQuery(hql);
result = query.list();
} catch (Exception e) {
e.printStackTrace();
} finally {
if (session != null) {
session.close();
}
}
return result;
}
属性查询
public List<XXX> getXXXList(XXX) {
Session session = null;
Transaction transaction = null;
try {
session = getSession();
transaction = session.beginTransaction();
String hql = "from XXX where username=:username";
Query<User> query = session.createQuery(hql, XXX.class);
query.setParameter("username", "测试");
List<User> list = query.getResultList();
transaction.commit();
result = query.list();
} catch (Exception e) {
if (transaction != null) {
transaction.rollback();
}
e.printStackTrace();
}
}
实例化查询
public List<XXX> getXXXList(XXX) {
Session session = null;
Transaction transaction = null;
try {
session = getSession();
transaction = session.beginTransaction();
String hql = "select new XXX(u.username,u.age) from XX as u";
Query<User> query = session.createQuery(hql, XXX.class);
query.setParameter("username", "测试");
List<User> list = query.getResultList();
transaction.commit();
result = query.list();
} catch (Exception e) {
if (transaction != null) {
transaction.rollback();
}
e.printStackTrace();
}
}