导入的包
public class manageUser {
Configuration cfg= null;
SessionFactory sf = null;
Session session = null;
Transaction ts = null;
@Test
public void DatabasePersistence(){
User u = new User();
u.setName("孙铭阳");
u.setAge(222);
try{
cfg = new Configuration().configure();
sf = cfg.buildSessionFactory();
session = sf.openSession();
ts = session.beginTransaction();
session.save(u);
}catch (Exception exception){
exception.printStackTrace();
}finally {
session.close();
sf.close();
}
}
//增
@Test
public void addSession(){
try{
cfg = new Configuration().configure();
sf = cfg.buildSessionFactory();
session = sf.openSession();
ts = session.beginTransaction();
User u = new User("smz",22);
session.save(u);
}catch (Exception exception){
exception.printStackTrace();
}finally {
session.close();
sf.close();
}
}
//删
@Test
public void delSession(){
try{
cfg = new Configuration().configure();
sf = cfg.buildSessionFactory();
session = sf.openSession();
ts = session.beginTransaction();
User u = session.get(User.class,11);
session.delete(u);
ts.commit();
}catch (Exception exception){
exception.printStackTrace();
}finally {
session.close();
sf.close();
}
}
// 改
@Test
public void updateSession(){
try{
cfg = new Configuration().configure();
sf = cfg.buildSessionFactory();
session = sf.openSession();
ts = session.beginTransaction();
User u = session.get(User.class,10);
u.setName("maDi");
session.saveOrUpdate(u);
ts.commit();
}catch (Exception exception){
exception.printStackTrace();
}finally {
session.close();
sf.close();
}
}
//查
@Test
public void querySession(){
try{
cfg = new Configuration().configure();
sf = cfg.buildSessionFactory();
session = sf.openSession();
ts = session.beginTransaction();
Query<User> userQuery =session.createQuery("from dao.User ");
List<User> userList =userQuery.list();
for (User user:userList){
System.out.println(user.toString());
}
}catch (Exception exception){
exception.printStackTrace();
}finally {
session.close();
sf.close();
}
}
}