出现原因:搜索结果中出现重复列名,虽然sql中可以运⾏,但是由于mybatis中没有sql的⾃动列名序号,导致出现列名重复。
解决办法:搜索时,添加AS别名
select
driver.id, driver.name, dept_id, gender, birthday, card, phone, entrytime, address, driver_no,driver_type, driver.remarks, driver.isdisable, dept.id as did, dept.dept_namefrom
driver, deptwhere
driver.dept_id = dept.id
and driver.name like \"%\"#{driverLike}\"%\"order by driver.id desc
因篇幅问题不能全部显示,请点此查看更多更全内容