Mybitis模糊查詢語句錯誤問題分析

• java代碼為

List<Category> cs=session.selectList("listCategoryByName","新");
        for(Category c3:cs){
            System.out.println("新關鍵字查出的"+c.getName());
        }
           

• 錯誤1

  mybitis配置

<select id="listCategoryByName"    resultType="Category">
            select * from category_ t where t.name like concat('%',#{name},'%')
        </select>  
           

結果：報錯ORA-00909: 參數個數無效

- 錯誤2

<select id="listCategoryByName"    resultType="Category">
            select * from category_ t where t.name like concat(concat("%",#{name}),"%")
        </select>  
           

結果，錯誤ORA-00904: “%”: 辨別符無效

• 正确

select * from category_ t where t.name like concat(concat('%',#{name}),'%')