基于Hibernate实现CRUD

基于Hibernate实现CRUD

1、增加
public void testSave(){

	Customer c=new Customer();
	c.setName("a");
	
	Configuration cfg=new Configuration().configure();
	SessionFactory  factory=cfg.buildSessionFactory();
	Session session=factory.openSession();
	
	Transaction tx=session.beginTransaction();
	session.save(c);

	tx.commit();
	session.close();
	factory.close();
	
}

结果：

2、删除
public void testDel(){

	Configuration cfg=new Configuration().configure();
	SessionFactory  factory=cfg.buildSessionFactory();
	Session session=factory.openSession();
	

	Transaction tx=session.beginTransaction();
	Customer c=(Customer) session.get(Customer.class,1);
	
	session.delete(c);

	tx.commit();
	session.close();
	factory.close();
	
}

结果：

3、修改
public void testUpdate(){

	Configuration cfg=new Configuration().configure();
	SessionFactory  factory=cfg.buildSessionFactory();
	Session session=factory.openSession();
	

	Transaction tx=session.beginTransaction();
	Customer c=(Customer) session.get(Customer.class,1);
	
	c.setName("b");
	session.update(c);
	System.out.println(c);

	tx.commit();
	session.close();
	factory.close();
	
}

结果：

4、查询
public void testFindOne(){

	Configuration cfg=new Configuration().configure();
	SessionFactory  factory=cfg.buildSessionFactory();
	Session session=factory.openSession();
	
	Transaction tx=session.beginTransaction();
	Customer c=(Customer) session.get(Customer.class,1);
	System.out.println(c);

	tx.commit();
	session.close();
	factory.close();
	
}

结果：

1．打开MyEclipce，点击File->New->Module



2. 将项目命名为“hibernate”,其他选项保持默认，点击Next or Finished

3.由于是项目需要在文件中导入相关依赖jar包

4.在hibernateDemo项目src/main/java目录下新建实体类User及配置文件User.hbm.xml，

至此，hibernate开发环境配置完毕。（以上带有整个实验完成的部分代码）
7. 使用hibernate框架操作数据库表创建功能

1. 在src/test/java建立Test类用来执行CURD代码，相应代码如下。
   public class UserTest extends TestCase{
   private UserDao userdao = null;
   private User user = null;
   public void testAdd() throws ParseException {
   userdao = new UserDaoImpl();
   user = new User();
   user.setUsername(“小王”);
   user.setAge(25);
   user.setBirthday(new SimpleDateFormat(“yyyy-MM-dd HH:mm:ss”).parse(“1995-07-20 05:32:31”));
   userdao.addUser(user);
   }
   public void testDelete(){
   userdao = new UserDaoImpl();
   userdao.deleteUser(1);
   }
   public void testUpdate() throws ParseException {
   userdao = new UserDaoImpl();
   user = new User();
   user.setId(1);
   user.setAge(23);
   user.setUsername(“小强”);
   user.setBirthday(new SimpleDateFormat(“yyyy-MM-dd HH:mm:ss”).parse(“1996-08-21 08:20:13”));

    userdao.updateUser(user);
   

   }
   public void testQueryUsers(){
   userdao = new UserDaoImpl();
   List users = userdao.queryUsers();
   System.out.println(“id”+"\t"+“name”+"\t"+“age”+"\t"+“birthday”);
   for(User u : users){
   System.out.println(u.getId()+"\t"+u.getUsername()+"\t"+u.getAge()+"\t"+u.getBirthday());

    }
   

   }
   public void testQueryUser(){
   userdao = new UserDaoImpl();
   user = userdao.queryUser(1);
   System.out.println(“id”+"\t"+“name”+"\t"+“age”+"\t"+“birthday”);
   System.out.println(user.getId()+"\t"+user.getUsername()+"\t"+user.getAge()+"\t"+user.getBirthday());

   }
   }
   运行截图

添加用户：

更新用户id为1的用户名字为小小

删除用户id为1的用户

查询所有用户