ssm的模糊查询且解决传中文乱码的问题

转载请标明出处：
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，加上图中方框里的那句话就行了