今天完成的事情：今天完成作品模块和类目分类模块
明天计划的事情：明天做留言模块，写Cotroller层，调试接口
遇到的问题：自己不怎么熟悉这种查询的逻辑，关联查询，字段设计，像是我在作品表中放了一个类目id，我的实体类是设置一个类目对象的属性，还是设置一个类目id属性，而且在什么情况下实体类中放list集合属性，这些我还没总结处理，比较迷糊。
收获：

catalog的dao

<?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.hyx.dao.CatalogDao">
    <resultMap id="forCatalog" type="Catalog">
        <id column="id" property="id"  javaType="Integer"></id>
        <result column="create_at" property="createAt" javaType="Long"></result>
        <result column="update_at" property="updateAt" javaType="Long"></result>
        <result column="create_by" property="createBy" javaType="String"></result>
        <result column="create_by" property="updateBy" javaType="String"></result>
    </resultMap>
    <insert id="addCatalog" useGeneratedKeys="true" keyProperty="id" parameterType="Catalog">
        insert into catalog (name,parent_id,create_at,update_at,create_by,update_by)value(#{name},#{parent.id},#{createAt},#{updateAt},#{createBy},#{updateBy})
    </insert>
    <select id="findCatalog" resultMap="forCatalog" >
        select id,name,parent_id,create_at,update_at,create_by,update_by
        from catalog
        <choose>
            <when test="catalogCondition != null">
                where parent_id=#{catalogCondition.id}
            </when>
            <when test="catalogCondition.parent != null">
                where parent_id=#{catalogCondition.parent.id}
            </when>
        </choose>

    </select>
    <update id="updateCatalog" parameterType="Catalog">
        update banner set intro=#{intro},update_at=#{updateAt},update_by=#{updateBy} where id=#{id}
    </update>
    <delete id="deleteCatalog" parameterType="Long">
        delete from banner  id = #{id}
    </delete>
</mapper>

@Repository("catalogDao")
public interface CatalogDao {
    List<Catalog> findCatalog(@Param("catalogCondition") Catalog catalogCondition);
    int updateCatalog(Catalog catalog);
    int addCatalog( Catalog catalog);
    int deleteCatalog(Long id);
}

service

@Service("catalogService")
public interface CatalogService {
    List<Catalog> findCatalog(Catalog catalog);
    int updateCatalog(Catalog catalog);
    int addCatalog(Catalog catalog);
    int deleteCatalog(Long id);
}

@Service
public class CatalogServiceImpl implements CatalogService {
    @Resource
    private CatalogDao catalogDao;

    @Override
    public List<Catalog> findCatalog(Catalog catalog) {
        return catalogDao.findCatalog(catalog);
    }
    @Override
    public int updateCatalog(Catalog catalog) { return catalogDao.updateCatalog(catalog); }
    @Override
    public int addCatalog(Catalog catalog) {
        return catalogDao.addCatalog(catalog);
    }
    @Override
    public int deleteCatalog(Long id) { return catalogDao.deleteCatalog(id); }
}

CatalogTest

@RunWith(SpringJUnit4ClassRunner.class)
@ContextConfiguration("classpath:spring-biz.xml")
public class CatalogTest {

    private Long date = new Date().getTime();
    @Resource
    private CatalogService catalogService;

    @Test
    public void addCatalog(){
        Catalog catalog =new Catalog();
        Catalog catalog1 =new Catalog();
        catalog1.setId(1);
        catalog.setName("dadasdas");
        catalog.setParent(catalog1);
        catalog.setCreateAt(date);
        catalog.setUpdateAt(date);
        catalog.setUpdateBy("超级管理员");
        catalog.setCreateBy("超级管理员");
        int num = catalogService.addCatalog(catalog);
        System.out.println(num);
    }

    @Test
    public void findCatalogParent(){
        Catalog catalog = new Catalog();
        catalog.setId(0);
        List<Catalog> listParent = catalogService.findCatalog(catalog);
        System.out.println(listParent);
    }
    @Ignore
    public void updateCatalog(){
        Catalog catalog = new Catalog();
        catalog.setId(1);
        catalog.setName("dada");
        catalog.setUpdateAt(date);
        catalog.setUpdateBy("dad");
        int num = catalogService.updateCatalog(catalog);
        System.out.println(num);
    }
    @Ignore
    public void deleteCatalog(){
        int num = catalogService.deleteCatalog(2L);
        System.out.println(num);
    }
}