增加:
public void testSaveUser() {
Configuration cfg = null;
SessionFactory sf = null;
Session session = null;
Transaction ts = null;
User u = new User();
u.setName("于悦");
u.setGender("女");
u.setAge(21);
u.setBirthday(Date.valueOf("2000-7-1"));
try {
sf = HibernateUtil.getSessionFactory();
session = sf.getCurrentSession();
ts = session.beginTransaction();
session.save(u);
ts.commit();
} catch (HibernateException e) {
// TODO Auto-generated catch block
e.printStackTrace();
if(ts != null) {
ts.rollback();
}
}finally {
session.close();
sf.close();
}
}
删除:
public void testDeleteUser() {
Configuration cfg = null;
SessionFactory sf = null;
Session session = null;
Transaction ts = null;
try {
sf = HibernateUtil.getSessionFactory();
session = sf.getCurrentSession();
ts = session.beginTransaction();
User u = session.get(User.class, 2);
session.delete(u);
u.setName("玛卡巴卡");
u.setAge(21);
ts.commit();
} catch (HibernateException e) {
// TODO Auto-generated catch block
e.printStackTrace();
if(ts != null) {
ts.rollback();
}
}finally {
session.close();
sf.close();
}
}
修改:
ts = session.beginTransaction();
Query query = session.createQuery("update User set name='玛卡巴卡' where name='于悦'");
query.executeUpdate();
List users=query.list();
for(int i=0;i<users.size();i++)
{
User user =(User)users.get(i);
System.out.println(i+"--姓名:"+user.getName()+"--年龄"+user.getAge());
}
ts.commit();
查询:
public void testQueryUser() {
Configuration cfg = null;
SessionFactory sf = null;
Session session = null;
Transaction ts = null;
try {
sf = HibernateUtil.getSessionFactory();
session = sf.getCurrentSession();
ts = session.beginTransaction();
Query query = session.createQuery("from User");
List<User> users = query.List();
for(int i = 0; i < users.size(); i++) {
User u = users.get(i);
System.out.printIn(u.getName() + " " + u.getAge());
}
ts.commit();
} catch (HibernateException e) {
// TODO Auto-generated catch block
e.printStackTrace();
if(ts != null) {
ts.rollback();
}
}finally {
session.close();
sf.close();
}
}