package com.thinkgem.jeesite.modules.goodsmanage.entity;

public class Good extends CommentEntity {

    private String id;
    private String name;
    private String price;
    private String number;
    private String tolPrice;
    private String remarks;

    private Provider provider;   //Good是一个自定义对象，在good中仍然有另一个自定义对象Provider

   //*......
　　getter和setter方法省略
　　....*//

    @Override
    public String toString() {
        // TODO Auto-generated method stub
        return "id:" + this.id + "name:" + this.name + "price:" + this.price + "number:" + this.number + "remarks:"
                + this.remarks + "provider:" + this.provider.getCompanyName();
    }

}

package com.thinkgem.jeesite.modules.goodsmanage.entity;

public class Provider {

    private String id;
    private String companyName;
    private String managerName;
    private String phone;
    private String address;
    private String type;

   //*......
　　getter和setter方法省略
　　....*//

 @Override public String toString() {
// TODO Auto-generated method stub return "id:" + this.id+" "
 +"companyName:" +" "+ this.companyName+" " +"managerName:"
  +this.managerName+" "+" "+"phone:" +this.phone +" " + " address:" + this.address + " ";
 } }

package com.thinkgem.jeesite.modules.goodsmanage.dao;

import java.util.List;

import org.apache.ibatis.annotations.Param;

import com.thinkgem.jeesite.common.persistence.annotation.MyBatisDao;
import com.thinkgem.jeesite.modules.goodsmanage.entity.Good;
/**
* mybatis接口类
* @author 31899
*
*
*/
@MyBatisDao
public interface GoodDao {

public List<Good> getAllGood();

public Good getGoodById(@Param("id")String id);

public void saveGood(Good good);

public int deleteGood(String id);
}

<?xml version="1.0" encoding="UTF-8"?>
<!DOCTYPE mapper PUBLIC "-//mybatis.org//DTD Mapper 3.0//EN" "http://mybatis.org/dtd/mybatis-3-mapper.dtd">

<mapper namespace="com.thinkgem.jeesite.modules.goodsmanage.dao.GoodDao">




<sql id="goodColumns">
    g.id AS id ,
    g.name AS name,
    g.price AS price,
    g.number AS number,
    g.tolPrice AS tolPrice,
    g.remarks AS remarks,
    g.providerId AS "provider.id",
    g.delFlag AS delFlag,
    p.companyName as "provider.companyName",
    p.companyName as "provider.managerName",
    p.phone as "provider.phone",
    p.address as "provider.address"
    
    
    
</sql>

<sql id="goodJoins">
join ma_provider p on g.providerId = p.id
</sql>



<select id="getAllGood" resultType="com.thinkgem.jeesite.modules.goodsmanage.entity.Good">
select 
    <include refid="goodColumns"></include>
    from ma_good g
    <include refid="goodJoins"></include>
    where g.delFlag!="1"
</select>

<select id="getGoodById" resultType="com.thinkgem.jeesite.modules.goodsmanage.entity.Good">
    select <include refid="goodColumns"></include>
    from ma_good g
    <include refid="goodJoins"></include>
     where g.id=#{id} and g.delFlag!="1" 
</select>


<select id=""></select>

    
<insert id="saveGood">
    insert into ma_good(id,name,price,number,tolPrice,remarks,providerId,delFlag) 
    values(#{id},#{name},#{price},#{number},#{tolPrice},#{remarks},#{provider.id},"0"})
</insert>

<delete id="deleteGood">
    update ma_good set delFlag="1" where id=#{id}
</delete> 

</mapper>

<sql id="goodColumns">
    g.id AS id ,
    g.name AS name,
    g.price AS price,
    g.number AS number,
    g.tolPrice AS tolPrice,                        整体的谁对应谁：可以这样的想，左侧是想要的表别名.字段名，as的右侧是想要将左侧的对应到那个对象的那个属性上面，
　　　　　　　　　　　　　　　　　　　　　　　　　　　　　　　　就写成单独的属性名，如tolPrice   如果是内部的对象 的属性的话，应该写成：provider.compantName这样的 ，
　　　　　　　　　　　　　　　　　　　　　　　　　　　　　　　　 其中的provider是good对象的一个自定义复合属性
    g.remarks AS remarks,
    g.providerId AS "provider.id",
    g.delFlag AS delFlag,  
    p.companyName as "provider.companyName",  #其中的g、p都为后面select时 from后面的表别名，  p代表provider表别名，其中的
    p.managerName as "provider.managerName",  g 代表good表，而  p.  和g.   （粉色字体）后面的是表中字段名称
　　　　　　　　　　　　　　　　　　　　　　　　　　　　（通过明确字段名称属于哪个表，就选p.还是g.），
　　　　　　　　　　　　　　　　　　　　　　　　　　　　而As后面的是具体的 就是具体 的对选bean中的属性的名称

p.phone as "provider.phone",                  可以根据颜色去找是对应的是表字段还是bean的属性
p.address as "provider.address"  

 </sql> <sql id="goodJoins"> join ma_provider p on g.providerId = p.id </sql> <select id="getAllGood" resultType="com.thinkgem.jeesite.modules.goodsmanage.entity.Good"> select <include refid="goodColumns"></include> from ma_good g <include refid="goodJoins"></include> where g.delFlag!="1" </select>