81,092
社区成员
发帖
与我相关
我的任务
分享SSM框架查询问题
编程小白写了个SSM框架，现在写了一条查询语句，写的是条件查询，按名字或者用户ID查询，当只输入名字时，网页400，只输入ID时，不会遍历我查询的内容。当二个一起输入的时候，就能成功查询，大神们帮我看看怎么会出现这种问题啊？
代码如下：
测试方法
@RequestMapping(value="/findUser.action",method=RequestMethod.POST)
public String findUser(User u ,Model model){
List<User> listU = userService.fUser(u);
model.addAttribute("users", listU);
return "/findUser.jsp";
}
JSP网页代码
<%@ page language="java" contentType="text/html; charset=UTF-8"
pageEncoding="UTF-8"%>
<%@ taglib prefix="c" uri="http://java.sun.com/jsp/jstl/core"%>
<!DOCTYPE html PUBLIC "-//W3C//DTD HTML 4.01 Transitional//EN" "http://www.w3.org/TR/html4/loose.dtd">
<html>
<head>
<meta http-equiv="Content-Type" content="text/html; charset=UTF-8">
<title>Insert title here</title>
</head>
<body>
<form action="/TestSSM/findUser.action" method="post">
<table>
<tr>
<td>姓名</td>
<td><input type="text" name="username"></td>
</tr>
<tr>
<td>用户ID</td>
<td><input type="text" name="userid"></td>
</tr>
<tr>
<td><input type="submit" value="提交"></td>
</tr>
</table>
</form>
<table>
<c:forEach items="${users}" var="user">
<tr>
<td>${user.userid}</td>
<td>${user.username}</td>
<td>${user.sex}</td>
<td>${user.age}</td>
<td>${user.brithday}</td>
<td>${user.adress}</td>
<td><a href="/TestSSM/user/${user.username}/delete">删除</a></td>
<td><a href="/TestSSM/user/${user.username}/update">更新</a></td>
</tr>
</c:forEach>
</table>
</body>
</html>
UserMapper.xml
<select id="fUser" parameterType="com.test.pojo.User" resultType="com.test.pojo.User">
select *from T_user
<where>
<if test="username != null">
and username=#{username}
</if>
<if test="userid != null">
and userid=#{userid}
</if>
</where>
</select>
UserMapper.java代码
public List<User> fUser(User u);
UserService里的方法
public List<User> fUser(User u) {
List<User> l = userMapper.fUser(u);
return l;
}
代码如下：
测试方法
@RequestMapping(value="/findUser.action",method=RequestMethod.POST)
public String findUser(User u ,Model model){
List<User> listU = userService.fUser(u);
model.addAttribute("users", listU);
return "/findUser.jsp";
}
JSP网页代码
<%@ page language="java" contentType="text/html; charset=UTF-8"
pageEncoding="UTF-8"%>
<%@ taglib prefix="c" uri="http://java.sun.com/jsp/jstl/core"%>
<!DOCTYPE html PUBLIC "-//W3C//DTD HTML 4.01 Transitional//EN" "http://www.w3.org/TR/html4/loose.dtd">
<html>
<head>
<meta http-equiv="Content-Type" content="text/html; charset=UTF-8">
<title>Insert title here</title>
</head>
<body>
<form action="/TestSSM/findUser.action" method="post">
<table>
<tr>
<td>姓名</td>
<td><input type="text" name="username"></td>
</tr>
<tr>
<td>用户ID</td>
<td><input type="text" name="userid"></td>
</tr>
<tr>
<td><input type="submit" value="提交"></td>
</tr>
</table>
</form>
<table>
<c:forEach items="${users}" var="user">
<tr>
<td>${user.userid}</td>
<td>${user.username}</td>
<td>${user.sex}</td>
<td>${user.age}</td>
<td>${user.brithday}</td>
<td>${user.adress}</td>
<td><a href="/TestSSM/user/${user.username}/delete">删除</a></td>
<td><a href="/TestSSM/user/${user.username}/update">更新</a></td>
</tr>
</c:forEach>
</table>
</body>
</html>
UserMapper.xml
<select id="fUser" parameterType="com.test.pojo.User" resultType="com.test.pojo.User">
select *from T_user
<where>
<if test="username != null">
and username=#{username}
</if>
<if test="userid != null">
and userid=#{userid}
</if>
</where>
</select>
UserMapper.java代码
public List<User> fUser(User u);
UserService里的方法
public List<User> fUser(User u) {
List<User> l = userMapper.fUser(u);
return l;
}
...全文
请发表友善的回复…
发表回复
