MyBatis之多参数传递

查询花卉信息

Mapper接口代码

    //查询指定的花卉信息
    public   Flower  selectOne(int  id ,String  name);
    public   Flower  selectOne2(@Param("a") int  id , @Param("b") String  name);
    public   Flower   selectOne3(Flower flower);
    public   Flower   selectOne4(Flower flower,Flower flower2);

Mapper.xml文件

 <select id="selectOne" resultType="flower">
     SELECT   * from  flower  where  id =#{param1}  and  name=#{param2}
   </select>
    <select id="selectOne2" resultType="flower">
        SELECT   * from  flower  where  id =#{a}  and  name=#{b}
    </select>
    <select id="selectOne3" resultType="flower">
        SELECT   * from  flower  where  id =#{id}  and  name=#{name}
    </select>
    <select id="selectOne4" resultType="flower">
        SELECT   * from  flower  where  id =#{param1.id}  and  name=#{param1.name}
    </select>