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