SSM框架学习——8.1商品添加之Dao层的实现

商品添加之Dao层的实现与测试

本章进入商品添加的开发学习阶段。
学习目标：实现商品添加、掌握批量图片添加。
entity/Product.java

public class Product {
   
    private Long productId;
    private String productName;
    private String productDesc;
    //简略图
    private String imgAddr;
    private String normalPrice;
    private String promotionPrice;
    private Integer priority;
    private Date createTime;
    private Date lastEditTime;
    //-1not 0end 1display 上下架状态位
    private Integer enableStatus;
	//商品详细图
    private List<ProductImg> productImgList;
    private ProductCategory productCategory;
    private Shop shop;
    set/get略
    } 

SQL:tb_product

product_id
product_name
product_desc
img_addr
normal_price
promotion_price
priority
create_time
last_edit_time
enable_status
product_category_id
shop_id

entity/ProductImg.java

/**
 * 商品详情图
 */
public class ProductImg {
   
    private Long productImgId;
    private String imgAddr;
    private String imgDesc;
    private Integer priority;
    private Date createTime;
    private Long productId;
    set/get略
}

SQL:tb_product_img

product_img_id
img_addr
img_desc
priority
create_time
product_id

dao/ProductDao.java

    /**
     * 插入商品
     * @param product
     * @return
     */
    int insertProduct(Product product);

mapper/ProductDao.xml

    <insert id="insertProduct" parameterType="com.imooc.o2o.entity.Product"
            useGeneratedKeys="true" keyProperty="productId" keyColumn="product_id">
        INSERT INTO
        tb_product(product_name, product_desc, img_addr, normal_price, promotion_price,
        priority, create_time, last_edit_time, enable_status, product_category_id, shop_id)
        VALUES
		(#{productName},#{productDesc},#{imgAddr},