使用SpringBoot集成Mybatis
利用注解开发完成基本的增删改查操作
基本的注解有
User实体类
public class User {
private int id;
private String name;
private String password;
//......注意配置get、set和ToString函数
}
UserMapper
@Mapper
@Repository
public interface UserMapper {
@Select("select * from user")
public List<User> findAll();
@Insert("insert into user values(#{id},#{name},#{password})")
public void save(User user);
@Update("update user set name=#{name},password=#{password} where id=#{id}")
public void update(User user);
@Delete("delete from user where id=#{id}")
public void delete(int id);
@Select("select * from user where id=#{id}")
public User findById(int id);
}
测试
@RunWith(SpringRunner.class)
@SpringBootTest
class SpringBootMybatisApplicationTests {
@Autowired
private UserMapper userMapper;
@Test
public void testFindAllAnno(){
List<User> userList = userMapper.findAll();
System.out.println(userList);
}
@Test
public void testFindByIdAnno(){
User user = userMapper.findById(1);
System.out.println(user);
}
@Test
public void testDelectAnno(){
userMapper.delete(1);
}
@Test
public void testSaveAnno(){
User user = new User();
user.setName("张三");
user.setId(1);
user.setPassWord("123456");
userMapper.save(user);
}
@Test
public void testUpdateAnno(){
User user = new User();
user.setName("张三");
user.setId(1);
user.setPassWord("123");
userMapper.update(user);
}
}