创建UserController文件查找ID内容,在浏览器中查看。http://localhost:8080/blogssm/blogController/index
@Controller
@RequestMapping("userController")
public class UserController {
@Autowired //自动注入方法
private UserService userService;
@RequestMapping("index")
public String index(Model model, HttpServletRequest request){
User user= userService.findById(3);
model.addAttribute("user",user);
return "user/userList";
}
}
@Controller为自动注入方法。
@RequestMapping为指针,指向userController文件中。
新建一个user调用userService类中的findById方法,
public interface UserService {
User findById(Integer id);
}
然后findById进入UserServiceImpl 中执行userMapper类中的selectByPrimaryKey方法查找内容,并回复值给user。
@Service("userService")
public class UserServiceImpl implements UserService {
@Autowired
private UserMapper userMapper;
@Override
public User findById(Integer id) {
User user = userMapper.selectByPrimaryKey((long) id);
return user;
}
}
selectByPrimaryKey方法的源码为:
<select id="selectByPrimaryKey" parameterType="java.lang.Long" resultMap="BaseResultMap">
select
<include refid="Base_Column_List" />
from user
where id = #{id,jdbcType=BIGINT}
</select>
执行完后回复值到user中,在model.addAttribute("user",user);
的key\value回复到index中显示出来。