我想获取登录用户的更多数据库数据,应该怎么获得呢?我现在只能获得用户名和密码,我想获取用户的state,role,email,请问是把现在的代码改一下,还是写一个新的方法呢?
现在的登录代码如下:
public User getUserByMassage(@Param("username") String username, @Param("password") String password);
<select id="getUserByMassage" resultType="com.bishe.springboot.bean.User">
SELECT * FROM user WHERE username = #{username} AND password = #{password} AND state = 1;
</select>
@RequestMapping("/login")
public String login(@RequestBody User user){
String flag = "error";
User us = userDao.getUserByMassage(user.getUsername(),user.getPassword());
HashMap<String,Object> res = new HashMap<>();
if(us!=null){
flag = "ok";
}
res.put("flag",flag);
res.put("user",user);
String res_json = JSON.toJSONString(res);//转字符串
return res_json;
}