数据库表myuser.sql
entity--->myuser.java
private int id;
private String username;
private String password;
private String name;
private String classNum;
/*mapper---->名字自己起
* 根据id 有时候用的上的项目抽取
* */
public Map<String,Object> getUserNameandClassNum(int userId);
sevice--->名字自己起
public Map<String,Object> getUserNameandClassNum(int userId){
Map<String,Object> mpp=myuserMapper.getUserNameandClassNum(userId);
System.out.println("取出来的名字是"+mpp.get("mingzi"));
System.out.println("取出来的班级是"+mpp.get("banji"));
return mpp;
}
mapping---->名字自己起
<select id="getUserNameandClassNum" parameterType="java.lang.Integer" resultType="java.util.Map">
select
name as mingzi,
classnum as banji
from myuser m
where m.id=#{userId}
</select>
controller--->名字自己起
@ApiOperation(value ="demo",notes="demo")
@ApiImplicitParam(name = "userId",value = "demo",paramType = "query")
@RequestMapping(value = "getuserNameandClass",method = RequestMethod.GET)
Object getUserNameandClassNum(int userId){
return myuserService.getUserNameandClassNum(userId);
}
出现上图加上@Repository就好了