【六袆-Java】mybatis模糊查询；mysql模糊查询；

 

mybatis模糊查询mysql模糊查询

  @Select("<script> " +
            "select * from job a \n" +
            "left join job_type b on a.job_id = b.job_type_id\n" +
            "where  a.delete_flag=0  and a.status=1 and  \n" +
            "<if test = \"jobName !=null \" >\n" +
            "   a.job_name like concat(concat('%',#{jobName,jdbcType=VARCHAR},'%')) " +
            "</if>\n" +
            "\n" +
            "<if test = \"jobTypeName !=null \" >\n" +
            " and  b.job_type_name like concat(concat('%',#{jobTypeName,jdbcType=VARCHAR},'%')) " +
            "</if>\n" +
            "</script>")
    List<Job> searchjobName(String jobName,String jobTypeName );