qq_22948413
qq_22948413
2015-08-01 06:51
采纳率: 44.4%
浏览 2.6k
已采纳

SpringMVC+Spring+Mybatis+DWZ(模糊查询)

Mybatis里面:

select

from AUS_USERS
where 1 = 1

and AUS_CARDCODE LIKE CONCAT(CONCAT('%','#{ausCardcode}','%'))

    <if test="ausUsername != null">
        and AUS_CARDCODE LIKE CONCAT(CONCAT('%','#{ausUsername}','%') )
    </if>       

接口:
/** String ausCardcode, String ausUsername
 * 根据账号,姓名查询
 * @param ausCardcode
 * @param ausUsername
 * @return
 */

List allUser(Map map);

 Controller里面:
 @RequestMapping("userInfo")
public String userInfo(HttpServletRequest request,
        HttpServletResponse response,Map map) throws IOException {      
    map.get("ausCardcode");
    map.get("ausUsername");

    List<AusUsers> ausUser=ausUsersMapper.allUser(map); 
    request.setAttribute("AusUser", ausUser);

    return "system/userInfo";

}

Jsp:
    <li>账号:<input type="text" name="ausCardcode" size="10" maxlength="30" /></li>
                <li>姓名:<input type="text" name="ausUsername" size="10" maxlength="30" /></li>

            </ul>
            <input type="submit" name="button" value="查询" class="btn btn-success">

            为什么获取不到name="ausCardcode"和 name="ausUsername"这两个参数的值?
  • 点赞
  • 写回答
  • 关注问题
  • 收藏
  • 邀请回答

4条回答 默认 最新

  • Evankaka
    Evankaka 2015-08-01 10:03
    已采纳

    用request.getparameter("ausCardcode")试试看

    点赞 评论
  • gao36951
    RelievedAbility 2015-08-01 07:09

    没这么用过,可以在controller的方法里面用参数@requestParameter String ausCardcode,@requestParameter String ausUsername

    点赞 评论
  • gao36951
    RelievedAbility 2015-08-01 07:11

    @RequestParameter

    点赞 评论
  • caozhy

    就是表单的问题,和 Mybatis+DWZ 没有关系
    http://blog.csdn.net/wxwzy738/article/details/9832705

    点赞 评论

相关推荐