Struts + Hibernate实现增删改查实例代码

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