bad request 求帮助

zxgmdzz 2017-07-13 06:23:55

页面是这个样子 html代码
<form class="form-inline" method="post" id="queryForm" >
标题:
<input type="text" name="noticeTitle" id="noticeTitle" placeholder="标题" style="width:200px" class="input-text" value="${resource.noticeTitle }" />
类型:
<select name="noticeType" id="noticeType" style="width:200px" class="input-text">
<option value="">请选择</option>
<c:forEach var="rT" items="${rTList }">
<option
<c:if test="${resource.noticeType eq rT.id }">selected</c:if>
value="${rT.id }">${rT.noticetype }</option>
</c:forEach>
</select>
作者:
<input type="text" name="author" id="author" placeholder="作者" style="width:200px" class="input-text" value="${resource.author}">
来源:
<input type="text" name="source" id="source" placeholder="来源" style="width:200px" class="input-text" value="${resource.source}">
<br/><br/>
发布日期:
<input name="issueDate1" id="issueDate1" style="width:200px" class="input-text" onClick="WdatePicker()"/>

<input name="issueDate2" id="issueDate2" style="width:200px" class="input-text" onClick="WdatePicker()"/>
状态:
<select name="status" id="status" style="width:200px" class="input-text">
<option value="">请选择</option>
<c:forEach var="rS" items="${rSList }">
<option
<c:if test="${resource.status eq rS.id }">selected</c:if>
value="${rS.id }">${rS.status }</option>
</c:forEach>
</select>
        
<button class="btn btn-success" type="submit" onclick="publicPage()"><i class="Hui-iconfont"></i> 查询</button>
<button class="btn btn-warning btn-info search-btn" type="submit" onclick="cleanQuery()" ><i class="Hui-iconfont"></i> 清空</button>
</form>

//定义跳转地址、不能修改
var url = "<%=path%>/resource/list";
//查询数据项表单提交
function publicPage(url){
$("#queryForm").attr("action",url);
$("#queryForm").submit();
}

点了查询之后

xml文件

<mapper namespace="com.cn.reebotoo.mapper.ResourceMapper" >
<resultMap id="BaseResultMap" type="com.cn.reebotoo.model.Resource" >
<id column="ID" property="id" jdbcType="INTEGER" />
<result column="NOTICE_TITLE" property="noticeTitle" jdbcType="VARCHAR" />
<result column="NOTICE_TYPE" property="noticeType" jdbcType="INTEGER" />
<result column="SOURCE" property="source" jdbcType="VARCHAR" />
<result column="CLICK_NUM" property="clickNum" jdbcType="INTEGER" />
<result column="KEYWORD" property="keyword" jdbcType="VARCHAR" />
<result column="STATUS" property="status" jdbcType="INTEGER" />
<result column="AUTHOR" property="author" jdbcType="VARCHAR" />
<result column="USER_ID" property="userId" jdbcType="INTEGER" />
<result column="ISSUE_DATE" property="issueDate" jdbcType="TIMESTAMP" />
<result column="MODIFIER_ID" property="modifierId" jdbcType="INTEGER" />
<result column="MODIFY_DATE" property="modifyDate" jdbcType="TIMESTAMP" />
<result column="CONTENT" property="content" jdbcType="LONGVARCHAR" />
<!-- 加载自定义 -->
<collection property="resourceStatus" column="STATUS" select="com.cn.reebotoo.mapper.ResourceStatusMapper.selectByPrimaryKey"></collection>
<collection property="resourceType" column="NOTICE_TYPE" select="com.cn.reebotoo.mapper.ResourceTypeMapper.selectByPrimaryKey"></collection>
</resultMap>
<!-- 分页查询 -->
<select id="selectList" resultMap="BaseResultMap" parameterType="com.cn.reebotoo.model.Resource" >
select
*
from t_tm_resource
<where>
1=1
<if test="noticeTitle!=null and noticeTitle!=''">
and NOTICE_TITLE like concat('%',#{noticeTitle},'%')
</if>
<if test="noticeType!=null and noticeType!=''">
and NOTICE_TYPE =#{noticeType,jdbcType=INTEGER}
</if>
<if test="author!=null and author!=''">
and AUTHOR like concat('%',#{author},'%')
</if>
<if test="source!=null and source!=''">
and source like concat('%',#{source},'%')
</if>
<if test="issueDate1!=null and issueDate1!=''">
and ISSUE_DATE > #{issueDate1,jdbcType=DATE}
</if>
<if test="issueDate2!=null and issueDate2!=''">
and #{issueDate2,jdbcType=DATE} > ISSUE_DATE
</if>
<if test="status!=null and status!=''">
and STATUS =#{status,jdbcType=INTEGER}
</if>
</where>
</select>
</mapper>


求大腿 谢谢
...全文
86 回复 打赏 收藏 转发到动态 举报
写回复
用AI写文章
回复
切换为时间正序
请发表友善的回复…
发表回复

8,906

社区成员

发帖
与我相关
我的任务
社区描述
XML/XSL相关问题讨论专区
社区管理员
  • XML/XSL社区
加入社区
  • 近7日
  • 近30日
  • 至今
社区公告
暂无公告

试试用AI创作助手写篇文章吧