转载请标明出处:
https://blog.csdn.net/weixin_41965979/article/details/81026486
本文出自付付讶的博客
最近项目中需要写多个模糊查询且需要传中文的情况,已解决所以记录一下
controller
@Controller
public class PatrolController {
@Autowired
private PatrolService patrolService;
/**
*
* @param
* @return
*/
@RequestMapping(value = "/getPatrolDetails",method = {RequestMethod.POST,RequestMethod.GET})
@ResponseBody
public List<PatrolEntity> getPatrolDetails(String taskName,String taskPlace,Model model){
List<PatrolEntity> patrolDetails = patrolService.findAll(taskName,taskPlace);
model.addAttribute("patrolDetails",patrolDetails);
//request.setAttribute("patrolsList",patrolDetails);
return patrolDetails;
}
}
service
@Service
public class PatrolService {
@Autowired
private PatrolDao patrolDao;
public List<PatrolEntity> findAll(String taskName,String taskPlace){
return patrolDao.findAll(taskName,taskPlace);
}
}
dao
@Repository
public interface PatrolDao {
List<PatrolEntity> findAll(@Param("taskName")String taskName,
@Param("taskPlace")String taskPlace);
}
dao.xml
<select id="findAll" parameterType="String" resultType="patrol">
select <include refid="patrol_column"/> from emergency where 1=1
<if test="null!=taskName and ''!=taskName">
and taskName like '%${taskName}%'
</if>
<if test="null!=taskPlace and ''!=taskPlace">
and taskPlace like '%${taskPlace}%'
</if>
</select>
以上就能进行模糊查询了
接下来说说传中文乱码的问题
找到你的tomcat路径,打开tomcat下的conf,再打开conf下的server.xml,加上图中方框里的那句话就行了