微信小程序> 微信查询,微信小程序简单的数据表格及查询功能

微信查询,微信小程序简单的数据表格及查询功能

浏览量:638 时间: 来源:weixin_30614587
简介:此项目是一个前后端分离的小demo,
开发工具:idea+微信小程序开发工具
前端:界面布局样式和js的跳转
后端:依靠SpringBoot的业务逻辑层
项目的码云地址:微信开发工具的使用和代码的结构及其含义参考
后端业务逻辑的完成1.数据库的创建工具:Navicat

2.dao层及其方法的实现1bookinfo的实例化,利用@Entity完成映射@Entity@Table(name="bookinfo")publicclassBookinfoEntity{@Id@GeneratedValue(strategy=GenerationType.IDENTITY)privateintbookId;@ColumnprivateStringbookType;@ColumnprivateStringbookName;@ColumnprivateintbookNum;@ColumnprivateintbookState;publicintgetBookId(){returnbookId;}publicvoidsetBookId(intbookId){this.bookId=bookId;}publicStringgetBookType(){returnbookType;}publicvoidsetBookType(StringbookType){this.bookType=bookType;}publicStringgetBookName(){returnbookName;}publicvoidsetBookName(StringbookName){this.bookName=bookName;}publicintgetBookNum(){returnbookNum;}publicvoidsetBookNum(intbookNum){this.bookNum=bookNum;}publicintgetBookState(){returnbookState;}publicvoidsetBookState(intbookState){this.bookState=bookState;}}bookinfoentity2bookstate的实例化@Entity@Table(name="bookstate")publicclassBookstateEntity{@IdprivateintbookState;@ColumnprivateStringbookStateinfo;publicintgetBookState(){returnbookState;}publicvoidsetBookState(intbookState){this.bookState=bookState;}publicStringgetBookStateinfo(){returnbookStateinfo;}publicvoidsetBookStateinfo(StringbookStateinfo){this.bookStateinfo=bookStateinfo;}}bookstateEntity3利用repository实现对对象的持久化操作,是OO的真正实现@RepositorypublicinterfaceBookInfoRepositoryextendsJpaRepositoryBookinfoEntity,Integer{}@RepositorypublicinterfaceBookstateRepositoryextendsJpaRepositoryBookstateEntity,Integer{}3.service层的实现、3.1BookinfoService接口packagecom.example.demo.service;importcom.example.demo.vo.BookinfoVo;importjava.util.List;/Author:wuhenDate:2018/10/9Time:20:40/publicinterfaceBookinfoService{//查询书籍BookinfoVofindbookOne(IntegerbookId);//查询所有书籍ListBookinfoVofindbookAll();}BookinfoService3.2接口的实现packagecom.example.demo.service.impl;importcom.example.demo.entity.BookinfoEntity;importcom.example.demo.entity.BookstateEntity;importcom.example.demo.repository.BookinfoRepository;importcom.example.demo.repository.BookstateRepository;importcom.example.demo.service.BookinfoService;importcom.example.demo.util.BookConverter;importcom.example.demo.vo.BookinfoVo;importorg.springframework.beans.factory.annotation.Autowired;importorg.springframework.stereotype.Service;importjava.util.ArrayList;importjava.util.List;/Author:wuhenDate:2018/10/9Time:20:48/@ServicepublicclassBookinfoServiceImplimplementsBookinfoService{@AutowiredprivateBookinfoRepositorybookinfoRepository;@AutowiredprivateBookstateRepositorybookstateRepository;BookConverterbookConverter=newBookConverter();@OverridepublicBookinfoVofindbookOne(IntegerbookId){BookinfoEntitybookinfoEntity=bookinfoRepository.findById(bookId).get();BookstateEntitybookstateEntity=bookstateRepository.findById(bookinfoEntity.getBookState()).get();BookinfoVobookinfoVo;bookinfoVo=bookConverter.convert(bookinfoEntity,BookinfoVo.class);bookinfoVo.setBookStateinfo(bookstateEntity.getBookStateinfo());returnbookinfoVo;}@OverridepublicListBookinfoVofindbookAll(){ListBookinfoEntitybookinfoEntitys=bookinfoRepository.findAll();ListBookinfoVobookinfoVos=newArrayList();for(BookinfoEntitybookinfoEntity:bookinfoEntitys){BookinfoVobookinfoVo;BookstateEntitybookstateEntity=bookstateRepository.findById(bookinfoEntity.getBookState()).get();bookinfoVo=bookConverter.convert(bookinfoEntity,BookinfoVo.class);bookinfoVo.setBookStateinfo(bookstateEntity.getBookStateinfo());bookinfoVos.add(bookinfoVo);}returnbookinfoVos;}}BookinfoServiceImpl4.controller层的实现packagecom.example.demo.controller;importcom.example.demo.service.BookinfoService;importcom.example.demo.util.ResultVOUtil;importcom.example.demo.vo.BookinfoVo;importcom.example.demo.vo.ResultVO;importorg.springframework.beans.factory.annotation.Autowired;importorg.springframework.web.bind.annotation.GetMapping;importorg.springframework.web.bind.annotation.RequestMapping;importorg.springframework.web.bind.annotation.RequestParam;importorg.springframework.web.bind.annotation.RestController;importjava.util.List;/Author:wuhenDate:2018/10/9Time:20:55/@RestController@RequestMapping("/book")publicclassBookinfoController{@AutowiredprivateBookinfoServicebookinfoService;//查询单个@GetMapping("/findOne")publicResultVOBookinfoVofindbookOne(@RequestParam(value="bookId")IntegerbookId){BookinfoVobookinfoVo=bookinfoService.findbookOne(bookId);returnResultVOUtil.success(bookinfoVo);}//查询所有@GetMapping("/findAll")publicResultVOBookinfoVofindbookAll(){ListBookinfoVobookinfoVo=bookinfoService.findbookAll();returnResultVOUtil.success(bookinfoVo);}}BookinfoController5.请求返回json数据{"code":0,"msg":"成功","data":[{"bookId":1,"bookType":"数学","bookName":"大数宣讲","bookNum":20,"bookStateinfo":"在架"},{"bookId":2,"bookType":"语文","bookName":"国语","bookNum":30,"bookStateinfo":"在架"},{"bookId":3,"bookType":"英语","bookName":"四六级","bookNum":45,"bookStateinfo":"在架"},{"bookId":4,"bookType":"科技","bookName":"天眼","bookNum":12,"bookStateinfo":"在架"}]}{"code":0,"msg":"成功","data":{"bookId":2,"bookType":"语文","bookName":"国语","bookNum":30,"bookStateinfo":"在架"}}前端业务逻辑的完成1.效果
2.结构布局
具体代码参考源代码

版权声明

即速应用倡导尊重与保护知识产权。如发现本站文章存在版权问题,烦请提供版权疑问、身份证明、版权证明、联系方式等发邮件至197452366@qq.com ,我们将及时处理。本站文章仅作分享交流用途,作者观点不等同于即速应用观点。用户与作者的任何交易与本站无关,请知悉。

产品经理

手机 : 13312967497

擅长 : 小程序流量变现

扫码领取礼包

热门模板

  • 头条
  • 搜狐
  • 微博
  • 百家
  • 一点资讯
  • 知乎