解决Spring Spring Data JPA 错误: Page 1 of 1 containing UNKNOWN instances
来源:互联网 发布:甲骨文数据库培训 编辑:程序博客网 时间:2024/06/05 00:16
解决Spring Spring Data JPA 错误: Page 1 of 1 containing UNKNOWN instances
SpringBoot 整合 Spring-Data-JPA 的时候出现此问题:
前端 js 代码
$(function () { var searchText = $('.search').find('input').val() var columns = []; columns.push({ title: '分类', field: 'category', align: 'center', valign: 'middle', formatter: function (value, row, index) { return value } }, { title: '美图', field: 'url', align: 'center', valign: 'middle', formatter: function (value, row, index) { return "![](" + value + ")" } }) $.extend($.fn.bootstrapTable.defaults, $.fn.bootstrapTable.locales['zh-CN']); $('#meituFavoriteTable').bootstrapTable({ url: 'meituSearchFavoriteJson', sidePagination: "server", queryParamsType: 'page,size', contentType: "application/x-www-form-urlencoded", method: 'get', striped: false, //是否显示行间隔色 cache: false, //是否使用缓存,默认为true,所以一般情况下需要设置一下这个属性(*) pagination: true, //是否显示分页(*) paginationLoop: true, paginationHAlign: 'right', //right, left paginationVAlign: 'bottom', //bottom, top, both paginationDetailHAlign: 'left', //right, left paginationPreText: ' 上一页', paginationNextText: '下一页', search: true, searchText: searchText, searchTimeOut: 500, searchAlign: 'right', searchOnEnterKey: false, trimOnSearch: true, sortable: true, //是否启用排序 sortOrder: "desc", //排序方式 sortName: "id", pageNumber: 1, //初始化加载第一页,默认第一页 pageSize: 10, //每页的记录行数(*) pageList: [5, 10, 20, 50, 100], // 可选的每页数据 totalField: 'totalPages', dataField: 'content', //后端 json 对应的表格数据 key columns: columns, queryParams: function (params) { return { size: params.pageSize, page: params.pageNumber, sortName: params.sortName, sortOrder: params.sortOrder, searchText: params.searchText } }, classes: 'table table-responsive full-width', }) $(document).on('keydown', function (event) { // 键盘翻页事件 var e = event || window.event || arguments.callee.caller.arguments[0]; if (e && e.keyCode == 38 || e && e.keyCode == 37) {//上,左 // 上一页 $('.page-pre').click() } if (e && e.keyCode == 40 || e && e.keyCode == 39) {//下,右 // 下一页 $('.page-next').click() } })})
后端接口
MeituController
package com.easy.kotlin.controllerimport com.easy.kotlin.chapter11_kotlin_springboot.dao.ImageRepositoryimport com.easy.kotlin.chapter11_kotlin_springboot.entity.Imageimport org.springframework.beans.factory.annotation.Autowiredimport org.springframework.data.domain.Pageimport org.springframework.data.domain.PageRequestimport org.springframework.data.domain.Sortimport org.springframework.stereotype.Controllerimport org.springframework.web.bind.annotation.RequestMappingimport org.springframework.web.bind.annotation.RequestMethodimport org.springframework.web.bind.annotation.RequestParamimport org.springframework.web.bind.annotation.ResponseBodyimport org.springframework.web.servlet.ModelAndView/** * Created by jack on 2017/7/22. */@Controllerclass MeituController { @Autowired var imageRepository: ImageRepository? = null @RequestMapping(value = "meituJson", method = arrayOf(RequestMethod.GET)) @ResponseBody fun wotuJson(@RequestParam(value = "page", defaultValue = "0") page: Int, @RequestParam(value = "size", defaultValue = "10") size: Int): Page<Image>? { return getPageResult(page, size) } @RequestMapping(value = "meituSearchJson", method = arrayOf(RequestMethod.GET)) @ResponseBody fun wotuSearchJson(@RequestParam(value = "page", defaultValue = "0") page: Int, @RequestParam(value = "size", defaultValue = "10") size: Int, @RequestParam(value = "searchText", defaultValue = "") searchText: String): Page<Image>? { return getPageResult(page, size, searchText) } @RequestMapping(value = "meituSearchFavoriteJson", method = arrayOf(RequestMethod.GET)) @ResponseBody fun wotuSearchFavoriteJson(@RequestParam(value = "page", defaultValue = "0") page: Int, @RequestParam(value = "size", defaultValue = "10") size: Int, @RequestParam(value = "searchText", defaultValue = "") searchText: String): Page<Image>? { return getFavoritePageResult(page, size, searchText) } @RequestMapping(value = "meituView", method = arrayOf(RequestMethod.GET)) fun meituView(): ModelAndView { return ModelAndView("meituView") } @RequestMapping(value = "meituFavoriteView", method = arrayOf(RequestMethod.GET)) fun meituFavoriteView(): ModelAndView { return ModelAndView("meituFavoriteView") } private fun getPageResult(page: Int, size: Int): Page<Image>? { val sort = Sort(Sort.Direction.DESC, "id") val pageable = PageRequest(page, size, sort) return imageRepository?.findAll(pageable) } private fun getPageResult(page: Int, size: Int, searchText: String): Page<Image>? { val sort = Sort(Sort.Direction.DESC, "id") val pageable = PageRequest(page, size, sort) if (searchText == "") { return imageRepository?.findAll(pageable) } else { return imageRepository?.search(searchText, pageable) } } private fun getFavoritePageResult(page: Int, size: Int, searchText: String): Page<Image>? { val sort = Sort(Sort.Direction.DESC, "id") val pageable = PageRequest(page, size, sort) if (searchText == "") { val allFavorite = imageRepository?.findAllFavorite(pageable) return allFavorite } else { val searchFavorite = imageRepository?.searchFavorite(searchText, pageable) return searchFavorite } }}
ImageRepository
package com.easy.kotlin.chapter11_kotlin_springboot.daoimport com.easy.kotlin.chapter11_kotlin_springboot.entity.Imageimport org.springframework.data.domain.Pageimport org.springframework.data.domain.Pageableimport org.springframework.data.jpa.repository.Queryimport org.springframework.data.repository.PagingAndSortingRepositoryimport org.springframework.data.repository.query.Param/** Created by jack on 2017/7/17.@Query注解里面的value和nativeQuery=true,意思是使用原生的sql查询语句.sql模糊查询like语法,我们在写sql的时候是这样写的like '%?%'但是在@Query的value字符串中, 这样写like %?1% */interface ImageRepository : PagingAndSortingRepository<Image, Long> { @Query("SELECT a from #{#entityName} a where a.isDeleted=0 and a.category like %?1%") fun findByCategory(category: String): MutableList<Image> @Query("select count(*) from #{#entityName} a where a.isDeleted=0 and a.url = ?1") fun countByUrl(url: String): Int @Query("SELECT a from #{#entityName} a where a.isDeleted=0 and a.category like %:searchText%") fun search(@Param("searchText") searchText: String, pageable: Pageable): Page<Image> @Query("SELECT a from #{#entityName} a where a.isDeleted=0 and a.isFavorite=1") fun findAllFavorite(pageable: Pageable): Page<Image> @Query("SELECT a from #{#entityName} a where a.isDeleted=0 and a.isFavorite=1 and a.category like %:searchText%") fun searchFavorite(@Param("searchText") searchText: String, pageable: Pageable): Page<Image>}
前台请求第一页的数据, 参数 &page=1&start=0&limit=50
后台得不到数据, 并提示 Page 1 of 1 containing UNKNOWN instances
原因page从0开始不是从1开始
解决方式把page修改为0
... pageNumber: 0, //初始化加载第一页,默认第一页 pageSize: 10, //每页的记录行数(*) ...
完整工程源代码
https://github.com/EasyKotlin/chatper15_net_io_img_crawler
参考连接:
Page 1 of 1 containing UNKNOWN instances when findByUserNameLike(String userName,Pageable pageable)
https://jira.spring.io/browse/DATAJPA-225
阅读全文
0 0
- 解决Spring Spring Data JPA 错误: Page 1 of 1 containing UNKNOWN instances
- 解决Spring Data JPA提示Page 1 of 1 containing UNKNOWN instances
- Page size must not be less than one&Page 1 of 1 containing UNKNOWN instances
- spring data jpa page interface
- Spring Data Jpa 概述(Spring Data Jpa 1)
- 1、Spring Data JPA 入门
- Spring-data-jpa常见错误
- Spring-Data-JPA 错误总结
- Spring Boot -- Spring Data Jpa(1)
- 解决Spring Data JPA延迟加载no session错误
- 开始使用 Spring Data JPA(1)
- spring-data-jpa 中文文档(1)
- spring-data-jpa的理解(1)
- spring-data-jpa 中文文档(1)
- spring data jpa使用错误记录
- Spring Data JPA使用JpaRepository自动装配报No qualifying bean of type错误
- Jpa到Spring data jpa
- Spring Data JPA
- 最近邻 相关推荐
- spring-data-jpa + SpringBoot + bootstrapTable 后端分页 模糊查询
- javascript drag()拖拽
- 一致性(连续性)hash算法(Consistent hashing)
- 成为高级程序员的 10 个步骤
- 解决Spring Spring Data JPA 错误: Page 1 of 1 containing UNKNOWN instances
- json文件注意事项
- 使用docker创建python3.5
- spring data jpa @Query注解中delete语句报错 : @Modifying注解的使用
- Java Web 实现导航栏 active 状态随着页面自动切换
- jQuery 实现图片下载代码
- SpringBoot SpringMVC实现文件下载
- AttributeError: 'numpy.ndarray' object has no attribute 'index'
- 哪本最具影响力的书,是每个程序员都应该读的?