1、建库
//根据实体字段创建数据库字段
2、实体和xxxxx.hbm.xml
package com.entity;
/**
* 产品表实体,对应数据库表product字段,
* Created by lvjun on 2018-03-28.
*/
public class ProductEntity {
int id;
String name;
float price;
public int getId() {
return id;
}
public void setId(int id) {
this.id = id;
}
public String getName() {
return name;
}
public void setName(String name) {
this.name = name;
}
public float getPrice() {
return price;
}
public void setPrice(float price) {
this.price = price;
}
}
ProductEntity.hbm.xml
<?xml version="1.0"?>
<!DOCTYPE hibernate-mapping PUBLIC
"-//Hibernate/Hibernate Mapping DTD 3.0//EN"
"http://www.hibernate.org/dtd/hibernate-mapping-3.0.dtd">
<!--映射实体类-->
<hibernate-mapping package="com.entity">
<!--ProductEntity实体类,对应数据库表product-->
<class name="ProductEntity" table="product">
<!--属性id,映射表里的字段id-->
<id name="id" column="id">
<!--id的自增长方式采用数据库的本地方式-->
<generator class="native"></generator>
</id>
<!--字段属性-->
<property name="name" />
<property name="price" />
</class>
</hibernate-mapping>
3、dao类
package com.dao;
import com.entity.ProductEntity;
import org.hibernate.Query;
import org.hibernate.Session;
import org.hibernate.SessionFactory;
import org.hibernate.cfg.Configuration;
import java.util.ArrayList;
import java.util.List;
/**
* 数据库操作类:增删改查,获取方法
* Created by lvjun on 2018-03-28.
*/
public class ProductDao {
/**
* 查询列表
*/
public List<ProductEntity> listProduct() {
List<ProductEntity> result = new ArrayList();
SessionFactory sessionFactory = new Configuration().configure().buildSessionFactory();
Session session = sessionFactory.openSession();
Query query = session.createQuery("from ProductEntity "); //hql
result = query.list();
session.close();
sessionFactory.close();
return result;
}
/**
* 删除信息
*/
public void deleteProduct(int id){
List<ProductEntity> result = new ArrayList();
SessionFactory sessionFactory = new Configuration().configure().buildSessionFactory();
Session session = sessionFactory.openSession();
session.beginTransaction();
//查询是否存在这条数据
ProductEntity productEntity=(ProductEntity) sessio