UsersDao
import java.util.List;
import com.dreamer.entity.Users;
public interface UsersDao {
public Users login(int uId); //�û���¼
public int add(Users u); //�����˻�
public int update(Users u); //�����˻�
public List<Users> selectAll(); //��ѯȫ���˻�
}
UsersDaoImpl
package com.dreamer.impl;
import java.util.ArrayList;
import java.util.Iterator;
import java.util.List;
import org.hibernate.Criteria;
import org.hibernate.HibernateException;
import org.hibernate.Query;
import org.hibernate.Session;
import org.hibernate.SessionFactory;
import org.hibernate.Transaction;
import org.hibernate.criterion.Order;
import org.hibernate.criterion.Restrictions;
import com.dreamer.dao.UsersDao;
import com.dreamer.entity.Users;
public class UsersDaoImpl implements UsersDao {
private SessionFactory sessionFactory;
private Transaction tr =null;
private Session session = null;
private Users user = null;
public SessionFactory getSessionFactory() {
return sessionFactory;
}
public void setSessionFactory(SessionFactory sessionFactory) {
this.sessionFactory = sessionFactory;
}
public Users login(int uid) {
user = null;
try {
session = sessionFactory.openSession();
String hql = "from Users where UId="+uid+" and isdeleted = 0";
Query query = session.createQuery(hql);
Iterator it=query.list().iterator();
if(it.hasNext()){
user=(Users)it.next();
}
} catch (HibernateException e) {
e.printStackTrace();
}finally {
session.close();
}
return user;
}
public int add(Users u) {
int i = 0;
try {
session = sessionFactory.openSession();
tr = session.beginTransaction();
session.save(u);
tr.commit();
i = 1;
} catch (HibernateException e) {
if (tr != null){
tr.rollback();
}
e.printStackTrace();
}finally {
session.close();
}
return i;
}
public int update(Users u) {
int i = 0;
try {
session = sessionFactory.openSession();
tr = session.beginTransaction();
session.update(u);
tr.commit();
i = 1;
} catch (HibernateException e) {
if (tr != null){
tr.rollback();
}
e.printStackTrace();
}finally {
session.close();
}
return i;
}
public List<Users> selectAll() {
List<Users> list= new ArrayList<Users>();
try {
session = sessionFactory.openSession();
//����Criteria�����
Criteria criteria = session.createCriteria(Users.class);
criteria.add(Restrictions.eq("isdeleted", 0));
//��ѯ�����������
criteria.addOrder(Order.asc("UId"));
//��ѯUsers�࣬�����õ��ļ��ϸ���list
list = criteria.list();
} catch (HibernateException e) {
e.printStackTrace();
}finally{
session.close();
}
return list;
}
}
分享到:
相关推荐
hibernate2的核心jar包 hibernate2.jar
hibernate2.jar是hibernate的一个核心库
hibernate2 升级为hibernate3的需要注意的事项
hibernate2文档,hibernate2文档,hibernate2文档,hibernate2
主要针对ssh框架 ,hibernate2 升级到hibernate3 的一些要注意的地方。
Hibernate2和Hibernate3连接池配置.doc
Manning出版 Java Persistence With Hibernate 第二版 清晰pdf Hibernate, an open source project that is almost 15 years old. In a recent poll, Hibernate was among the top five tools used by many Java ...
hibernate2 安装手记,让你快速掌握hibernate2的安装技巧
hibernate中访问access数据库需要的jar包hibernate2access
Struts1+Spring2+Hibernate2整合详细例子
struts2spring3hibernate2
Struts 2,Spring 2,Hibernate S2SH 整合例子
Hibernate2 参考文档
hibernate2架构图
Ajax+Spring+Hibernate 2 Ajax+Spring+Hibernate 2 Ajax+Spring+Hibernate 2 Ajax+Spring+Hibernate 2 Ajax+Spring+Hibernate 2 Ajax+Spring+Hibernate 2
一部很好的hibernate参考文档,内容全面,包括了hibernate2参考文档,hibernate3参考文档,是开发j2ee必备书籍。
Hibernate连接DB2
java persistence with hibernate 第二部分压缩包