- 博客(0)
- 资源 (1)
空空如也
用户管理系统
用户管理系统
public boolean isExists(User u) {
boolean flag=false;
Session session=sessionFactory.openSession();
String hql="from User as u where u.username=? and u.userpass=? and u.userright=?";
Query query=session.createQuery(hql) ;
query.setString(0, u.getUsername());
query.setString(1, u.getUserpass());
query.setInteger(2, u.getUserright());
List<User> list=query.list();
if(list.size()>0){
flag=true;
}
return flag;
}
public List<User> selectAll() {
System.out.println("dao中查询所有");
Session session=sessionFactory.openSession();
Transaction tran=session.beginTransaction();
String hql="from User";
Query query=session.createQuery(hql);
List list=query.list();
tran.commit();
session.close();
return list;
}
public boolean add(User u) {
System.out.println("在执行UserDAO的add方法");
boolean flag=false;
try {
Session session=sessionFactory.openSession();
Transaction trans=session.beginTransaction();
session.save(u);
trans.commit();
session.close();
flag=true;
System.out.println("dao中添加成功"+flag);
} catch (HibernateException e) {
System.out.println("dao中添加失败");
e.printStackTrace();
}
return flag;
}
public boolean delete(int uid) {
System.out.println("dao中执行delete方法");
boolean flag = false;
Session session=sessionFactory.openSession();
session.clear();
Transaction trans = session.beginTransaction();
String hql = "delete User as u where u.uid=?";
Query query = session.createQuery(hql);
query.setInteger(0, uid);
int state = query.executeUpdate();
trans.commit();
session.close();
if (state != 0) {
flag = true;
System.out.println("dao中删除成功");
} else {
System.out.println("dao中删除不成功");
}
return flag;
}
public User selectByUid(int uid) {
System.out.println("dao中执行selectByUid方法");
Session session=sessionFactory.openSession();
session.clear();
Transaction trans = session.beginTransaction();
String hql = "from User as u where u.uid =?";
Query query = session.createQuery(hql);
query.setInteger(0, uid);
List list = query.list();
return (User) list.get(0);
}
public boolean update(User u) {
System.out.println("dao中执行update方法");
boolean flag = false;
try {
Session session=sessionFactory.openSession();
session.clear();
Transaction trans = session.beginTransaction();
session.update(u);
trans.commit();
session.close();
flag = true;
System.out.println("dao中修改成成功");
} catch (HibernateException e) {
System.out.println("dao中修改成不成功");
e.printStackTrace();
}
return flag;
}
2014-06-17
空空如也
TA创建的收藏夹 TA关注的收藏夹
TA关注的人