bean层
public class Person { private Integer id; private String name; private Integer age; private String gender; private String tel; private String address; private Date birth;
dao层
public List<Person> selectUser(@Param("user")Person person,@Param("first") Integer first,@Param("last") Integer last);
mapper.xml
<select id="selectUser" resultType="cn.szh.bean.Person"> select * from person <where> <if test="id != null">AND Id=#{id}</if> <if test="name != null">AND Name=#{name}</if> <if test="address !=null">AND Address=#{address}</if> </where> limit #{first},#{last} </select>
serviceimp层
@Override public List<Person> selectUser(Person person,Integer currentPage, Integer size) { List<Person> personList = userDao.selectUser(person,(currentPage - 1) * size, size); return personList; }
controller层
@RequestMapping("select") public String selectUser(Model model,Person person,Integer currentPage,Integer size){ List<Person> personList = userService.selectUser(person,currentPage,size); model.addAttribute("persons",personList); return "hello"; }
报错
Parameter 'id' not found. Available parameters are [last, param3, user, param1, first, param2]
user.id
@Param("user")Person person
person的属性都用user.*来取