hibernate学习记录3

hibernate实现DAO(CURD)

DAO代码实现时可以不写回滚，在代码报异常时，hibernate会自动回滚数据，抛异常

query

1.根据id查询表，Session的get、load方法(其中load延迟加载，当机制使用时才加载)

Session s = HibernateUtil.getSession();

UserTest user = (UserTest)s.get(UserTset.class,id);

2.使用HQL语句条件查询，

String hql="from UserTest as user where user.userName=:name";
Query query = session.createQuery(hql);
query.setString("name", name);
List<UserTest> list = query.list();

3.使用Criteria类，

Criteria c=session.createCriteria(UserTest.class);
c.add(Restrictions.eq("userName", name));
UserTest user = (UserTest)c.uniqueResult();

查询时没有涉及到修改数据库，可以不用开启事物

----------------------------------------------------------------------------------------------------------------------------------------

delete

1.根据对象删除数据，使用Session的delete方法

ts = session.beginTransaction();
session.delete(user);
ts.commit();

----------------------------------------------------------------------------------------------------------------------------------------

create

1.根据对象添加一条数据，使用Session的save方法

ts = session.beginTransaction();
session.save(user);
ts.commit();

----------------------------------------------------------------------------------------------------------------------------------------

update

1.根据对象添加一条数据，使用Session的update方法

ts = session.beginTransaction();
session.update(user);
ts.commit();

----------------------------------------------------------------------------------------------------------------------------------------

测试上面的DAO

UserDAO dao = new UserDAOImpl();
UserTest user = new UserTest();
user.setUserName("names");
user.setBirthday(new Date());
System.out.println("1111添加");
dao.saveUser(user);

user.setUserName("namess");
System.out.println("222更新");
dao.updateUser(user);

UserTest user1 = dao.findUserByName("namess");
System.out.println("3333查询");
System.out.println(user1.getUserId()+"::"+user1.getUserName()+"::"+user1.getBirthday());

dao.remove(user1);
System.out.println("4444删除");