org.springframework.boot spring-boot-starter-web mysql mysql-connector-java 5.1.22 com.baomidou mybatis-plus-boot-starter 3.5.2 org.projectlombok lombok true org.springframework.boot spring-boot-starter-test test org.springframework.boot spring-boot-starter-web
@Data
@TableName("userinfo")
public class UserInfo {@TableId(type = IdType.AUTO)private Integer id;private String username;private String password;
}
@Mapper
public interface UserInfoMapper extends BaseMapper {//分页public Page findByPage(int pageCode, int pageSize);
}
public interface UserInfoService extends IService {//分页public Page findBy(int pageCode, int pageSize);
}
service 下面impl 的业务实现类:
@Service
public class UserInfoServiceImpl extends ServiceImpl implements UserInfoService {@Autowiredprivate UserInfoMapper userInfoMapper;@Overridepublic Page findByPage(int pageCode, int pageSize) {//1.创建Page对象,传入两个参数:当前页和每页显示记录数Page page = new Page(pageCode,pageSize);//2.将分页查询到的所有数据封装到Page对象中userInfoMapper.selectPage(page,null);return page;}
}
@Configuration
@MapperScan("com.mapper")
public class MybatisPlusConfig {@Beanpublic MybatisPlusInterceptor mybatisPlusInterceptor(){MybatisPlusInterceptor interceptor=new MybatisPlusInterceptor();interceptor.addInnerInterceptor(new PaginationInnerInterceptor(DbType.MYSQL));return interceptor;}
}
@CrossOrigin //允许跨域 禁止ajax 访问
@RestController
@RequestMapping("/userinfo")
public class UserInfoController {@Autowiredprivate UserInfoService userService;// 分页@GetMapping("/page/{pageCode}/{pageSize}")public Page findByPage(@PathVariable(value = "pageCode") int pageCode,@PathVariable(value = "pageSize") int pageSize) {Page pageInfo = userService.findByPage(pageCode, pageSize);return pageInfo;}}
修改 删除
这里的index.js和index.css 是element 的js和css。
下载链接-前端插件vue+elementui+axios.rar