Springboot项目搭建

@RunWith(SpringRunner.class)//spring测试的运行器注解
@SpringBootTest(classes = MyApp.class) //springboot测试类注解
public class JavaConfigTest {

    @Autowired
    TestService service;

    @Test
    public void test(){
        service.add();
    }

}

@Data
@TableName("user_info")
public class UserInfo extends MyPage implements Serializable {

    private static final long serialVersionUID=1L;

    @TableId(value = "user_id", type = IdType.AUTO)
    private Integer userId;

    private String userName;

    private String userPwd;
    
    private String userDetailId;


}

public interface UserInfoMapper extends BaseMapper<UserInfo> {
}

 

//insert新增
@Test
public void add(){
    UserInfo user = new UserInfo();
    user.setUserName("lisi");
    user.setUserPwd("123");
    int num = userInfoMapper.insert(user);
    System.out.println("num="+num);
}

//根据id修改
@Test
public void update(){
    UserInfo user = new UserInfo();
    //定义修改的值
    user.setUserName("admin");
    user.setUserPwd("123");
    //定义修改条件的id
    user.setUserId(1);
    int num = userInfoMapper.updateById(user);
    System.out.println("num="+num);

}
//根据自定义条件修改
@Test
public void update02(){
    //创建修改对象
    UpdateWrapper<UserInfo> wrapper = new UpdateWrapper<>();
    //定义修改条件
    wrapper.ge("user_id",1);
    //创建要修改的值
    UserInfo user = new UserInfo();
    user.setUserPwd("123");
    int num = userInfoMapper.update(user,wrapper);
    System.out.println("num="+num);

}

//根据id删除
@Test
public void del01(){
    int rs = userInfoMapper.deleteById(6);
}
//根据 Wrapper 查询对象删除数据
@Test
public void del02(){
    //定义查询对象
    QueryWrapper<UserInfo> w = new QueryWrapper<>();
    w.ge("user_id",8);
    int rs = userInfoMapper.delete(w);
}
//批量删除数据
@Test
public void del03(){
    //定义要删除的id集合
    List<Integer> ids = Arrays.asList(3,4,6);
    int rs = userInfoMapper.deleteBatchIds(ids);
    System.out.println("rs="+rs);

}

//根据id查询
@Test
public void search01(){
    UserInfo u = userInfoMapper.selectById(1);
    System.out.println(u.toString());
}
 

//根据 Wrapper 查询，且只返回一条记录
@Test
public void search02(){
    QueryWrapper<UserInfo> w = new QueryWrapper<>();
    w.eq("user_id",1);
    UserInfo u = userInfoMapper.selectOne(w);
    System.out.println(u.toString());
}

//根据 Wrapper 查询，返回多条记录
@Test
public void search03(){
    QueryWrapper<UserInfo> w = new QueryWrapper<>();
    w.ge("user_id",1);
    List<UserInfo> listu = userInfoMapper.selectList(w);
    System.out.println(listu.size());
}

//动态查询
@Test
public void search05(){
    //定义要传入的参数
    Integer queryId=1;
    String queryName=null;

    QueryWrapper<UserInfo> w = new QueryWrapper<>();
    // 第一个参数为是否执行条件，为true则执行该条件
    // 下面实现根据 user_id 和 user_name 动态查询
    w.eq(queryId!=null,"user_id",queryId);
    w.eq(StringUtils.isEmpty(queryName)&&queryName!=null,"user_name",queryName);
    //查询结果
    List<UserInfo> listu = userInfoMapper.selectList(w);
    System.out.println(listu.size());
}

/**
 * @Description 分页插件配置
 * @Autor 伍军
 * @Date 2021/8/6 13:50
 * @Version 1.0
 **/
@Configuration
public class MybatisPlusPaginationConfig {

    @Bean
    public PaginationInterceptor paginationInterceptor() {
        return new PaginationInterceptor();
    }

}

//分页查询
@Test
public void search06(){
    //定义分页对象（1表示第一页；2表示每页大小为2）
    Page<UserInfo> page = new Page<>(1,2);
    //定义查询条件
    QueryWrapper<UserInfo> w = new QueryWrapper<>();
    //查询分页结果对象
    Page<UserInfo> pageList = userInfoMapper.selectPage(page,w);
    System.out.println("每页集合" + pageList.getRecords());
    System.out.println("总页数: " + pageList.getPages());
    System.out.println("总条数: " + pageList.getTotal());
}