<?xml version="1.0" encoding="UTF-8" ?>
<!DOCTYPE mapper
PUBLIC "-//mybatis.org//DTD Mapper 3.0//EN"
"http://mybatis.org/dtd/mybatis-3-mapper.dtd">
<mapper namespace="com.lu.mapper.userMapper">
<select id="getUsers" resultType="User">
select * from user
</select>
<select id="getUser" resultType="User" parameterType="int">
select * from user where id =#{int}
</select>
</mapper>
com.lu.controller.userController
package com.lu.controller;
import com.lu.mapper.userMapper;
import com.lu.pojo.User;
import org.springframework.beans.factory.annotation.Autowired;
import org.springframework.web.bind.annotation.GetMapping;
import org.springframework.web.bind.annotation.RestController;
import java.util.List;
@RestController
public class UserController {
@Autowired
private userMapper userMapper;
@GetMapping("/getUsers")
public List<User> getUsers(){
List<User> users = userMapper.getUsers();
for (User user : users) {
System.out.println(user);//后台查看我不看
}
return users;
}
@GetMapping("/getUser")
public User getUser(int id){
System.out.println("------------");
User user = userMapper.getUser(id);
System.out.println(user);
return user;
}
}
com.lu.mapper.userMapper
package com.lu.mapper;
import com.lu.pojo.User;
import org.apache.ibatis.annotations.Mapper;
import org.springframework.stereotype.Repository;
import java.util.List;
//这个注解表示这是mybatis的mapper类
@Mapper
@Repository
//@MapperScan("com.lu.mapper")另外一种写法,这个不放在这里要放在运行主类里面
public interface userMapper {
List<User> getUsers();
User getUser(int id);
// int addUser(User user);
// int deleteUser(int id);
// int updateUser(User user);
}