ssm框架,mybatis的select语句传递多个参数报错?

Question

持久层:<select id="get" resultType="People">     select * from #{identity} where id= #{id}     </select>People get(@Param("identity") String identity,@Param("id") String id);service层:People get(String identity,String id);@Override public People get(String identity,String id) { return peopleMapper.get(identity,id); }controller层:p2=peopleService.get(p.getIdentity(),p.getId());报错信息:

Answer 1

identity要使用${identity}，不然无法识别成表名，导致sql语法错误

Answer 2

传实例化的People对象，就只传入一个参数，不报错。