Dao层:
select id,hero_name heroName from t_hero where hero_name LIKE CONCAT('%',#{heroName},'%')
Service:
String newHeroName = "%"+heroName+"%";
List<Hero> heroes = heroDao.selectByName(newHeroName);
return heroes;
sql模糊查询的两种方式
最新推荐文章于 2023-10-19 09:50:00 发布