商品系统 增删查改 毕业设计

Config:

Mapper.xml

jdbcType="INTEGER" />

jdbcType="VARCHAR" />

jdbcType="VARCHAR" />

jdbcType="INTEGER" />

resultMap="productMap">

select*from product where 1=1

and product_no=#{product_no}

and product_name =#{product_name}

and Status =#{Status}

insert into product

(product_no,product_name,product_type,Status) values

(#{product_no},#{product_name},#{product_type},#{Status})

delete from product

where product_no=#{product_no}

update product set

product_no=#{product_no},product_name

=#{product_name},product_type=#{product_type},Status =#{Status}

MyBatis.xml

PUBLIC "-////DTD Config 3.0//EN"

"/dtd/mybatis-3-config.dtd">

Dao:

package com.ry.Dao;

import java.util.List;

import com.ry.model.Product;

public interface ProductDao {

List selectByNameAndIDAndStatus(Product product);

int insertProduct(Product product);

int deleteProduct(Integer product_no);