Mybatis的sql语句传入多个参数

Mapper文件的方法参数要加注解@Param(" ")
如下

    //根据classname查询classify
    Classify queryClassifyByClassname(@Param("classname")String classname, @Param("uid") int uid);

Mapper.xml文件中

<!--    根据classname查询classify-->
    <select id="queryClassifyByClassname" resultType="com.pojo.Classify">
        select * from myblog.classify
        where classname=#{classname}
        and uid = #{uid};
    </select>

controller文件中要加@RequestParam(" ")

    //查询classname对应的id
    @RequestMapping("/getCid")
    @ResponseBody
    public String getCid(@RequestParam("classname") String classname, @RequestParam("uid") int uid){
//        String classname = classify.getClassname();
//        int uid = classify.getUid();
        System.out.println(classname);
        System.out.println("uid"+uid);
        Classify classify1 = classifyService.queryClassifyByClassname(classname,uid);
        Integer id = classify1.getId();
        System.out.println(id.toString());
        return id.toString();

    }