hibernate简单的crud

来源:互联网 发布:java 计算逻辑表达式 编辑:程序博客网 时间:2024/05/29 18:08
hibernate:查看sql语句 配置文件配置show_sql=true




myeclipse:


DB Browser中配置连接数据库 ,选中对应的表右键Hibernate Reverse Engineeing




勾选 create pojo

Java Date Object
 




创建项目 选中项目右键myeclipse -->add hibernate Annotions 


勾选所有的hibernate3.3


测试:


public class TestHb {


//增
@Test
public  void saveFood() {
Session session = HibernateSessionFactory.getSession();


AbstractFood food=new Food();

food.setPrice(667.0);


food.setFoodname("鸡蛋kj");


session.getTransaction().begin();


session.save(food);


session.getTransaction().commit();


}

//删
@Test
public  void deleteFood() {
Session session = HibernateSessionFactory.getSession();


Food food = new Food();


food.setFoodid(11);


session.getTransaction().begin();


session.delete(food);


session.getTransaction().commit();
}

//改
@Test
public  void updateFood() {
Session session = HibernateSessionFactory.getSession();


Food food = new Food();


food.setFoodid(11);

food.setPrice(555.0);


session.getTransaction().begin();


session.update(food);


session.getTransaction().commit();
}

//查
@Test
public  void queryFood() {
Session session = HibernateSessionFactory.getSession();




Food food=(Food)session.load(Food.class, 6);
System.out.println(food.getFoodname());

// hsql語言
Query query=session.createQuery("from Food where foodName like ? ");
query.setString(0, "%鸡%");

Query queryd=session.createQuery("from Food where foodName like :xx ");
query.setString("xx", "%鸡%");


List<Food> foodList=query.list();
System.out.println(foodList.size());

}

}