publicinterfaceUserMapperextendsBaseMapper<User>{
List<User>findAll();@Insert("insert into demo_user (id,name,age,sex) value (null,#{name},#{age},#{sex})")voidinsertUser(User user);@Update("update demo_user set name = #{newName} where name=#{oldName}")voidupdateByname(String oldName,String newName);@Delete("delete from demo_user where name=#{name}")voiddeleteByName(String name);}
2.添加日志
logging:level:com.jt.mapper: debug
3.查询
@SpringBootTestpublicclassTestMP{
@AutowiredprivateUserMapper userMapper;//根据id=23查询@Testpublicvoidselect01(){
User user = userMapper.selectById(23);System.out.println(user);}@Testpublicvoidselect02(){
User user =newUser();
user.setName("潘凤").setSex("男");QueryWrapper