Criteria查询方式
在hibernate中提供了HQL外,还提供了一种更面向对象的查询方式,就是Criteria查询。它的模式其实与QUERY接口都差不多。
示例如下:(关键代码)
sess = HibernateUtil.getSession();
Criteria cri = sess.createCriteria(User.class);
cri.add(Restrictions.eq("id", num));
//实现分页
/*cri.setFirstResult(0);
cri.setMaxResults(1);*/
List<User> list = cri.list();
通过hibernate实现简单的DAO层
private static SessionFactory sessionFactory = null;
private HibernateUtil(){}
static{
Configuration cfg = new Configuration();
cfg.configure();
sessionFactory = cfg.buildSessionFactory();}
public static SessionFactory getSessionFactory(){
return sessionFactory;}
public static Session getSession(){
return sessionFactory.openSession();}
public static void add(Object entity){
Session sess = null;
Transaction tx = null;
try {
sess = HibernateUtil.getSession();
tx = sess.beginTransaction();
sess.save(entity);
tx.commit();
} finally{
if(sess != null){
sess.close();}}}
public static void delete(Object entity){
Session sess = null;
Transaction tx = null;
try {
sess = HibernateUtil.getSession();
tx = sess.beginTransaction();
sess.delete(entity);
tx.commit();
} finally{
if(sess != null){
sess.close();}}}
public static void update(Object entity){
Session sess = null;
Transaction tx = null;
try {
sess = HibernateUtil.getSession();
tx = sess.beginTransaction();
sess.update(entity);
tx.commit();
} finally{
if(sess != null){
sess.close();}}}
@SuppressWarnings("unchecked")
public static Object get(Class clazz,Serializable id){
Session sess = null;
try {
sess = HibernateUtil.getSession();
Object obj = sess.get(clazz, id);
return obj;
} finally{
if(sess != null){
sess.close();}}}}
UserDAO:
public interface UserDAO {
public void saveUser(User user);
public void deleteUser(User user);
public void updateUser(User user);
public User findUserById(int id);
public User findUserByName(String name);
}
UserDAOHibernate:
public class UserDAOHibernate implements UserDAO {
public void deleteUser(User user) {
HibernateUtil.delete(user);
}
public User findUserById(int id) {
return (User) HibernateUtil.get(User.class, id);
}
public User findUserByName(String name) {
Session sess = null;
try {
sess = HibernateUtil.getSession();
Criteria cri = sess.createCriteria(User.class);
cri.add(Restrictions.eq("name", name));
return (User) cri.uniqueResult();
} finally{
if(sess != null){
sess.close();}}}
public void saveUser(User user) {
HibernateUtil.add(user);}
public void updateUser(User user) {
HibernateUtil.update(user);
}}