ssm连表查询Mapper动态代理

import java.util.List;

import org.apache.ibatis.annotations.Param;

import com.bawei.pojo.Employee;

public interface EmployeeMapper {
    public List<Employee> selectByName(String name);
    public List<Employee> selectAll();
    public List<Employee> selectByIds(@Param("ids")int[] ids);
    public void insert(Employee employee);
    public void delete(Integer id);
    public void update(Employee employee);
}

<?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="comi.dao.EmployeeMapper">
    <select id="selectByName" parameterType="string" resultMap="rm">
        select e.*,d.id d_id,d.name d_name from employee e,department d
        where e.did=d.id and e.name like '%${value}%'
    </select>
    <resultMap type="employee" id="rm">
        <id column="id" property="id"/>
        <result column="name" property="name"/>
        <result column="salary" property="salary"/>
        <result column="position" property="position"/>
        <association property="department" javaType="department">
            <id column="d_id" property="id"/>
            <result column="d_name" property="name"/>
        </association>
    </resultMap>
    <select id="selectAll" resultMap="rm">
        select e.*, d.id d_id,d.name d_name from employee e,department d
        where e.did=d.id
    </select>
    <insert id="insert" parameterType="employee">
        insert into employee(name,salary,position,did)
        value(#{name},#{salary},#{position},#{department.id})
    </insert>
    <delete id="delete" parameterType="int">
        delete from employee where id=#{id}
    </delete>
</mapper>