packagecom.mckz;importorg.mybatis.spring.annotation.MapperScan;importorg.springframework.boot.SpringApplication;importorg.springframework.boot.autoconfigure.SpringBootApplication;@MapperScan("com.mckz.*")@SpringBootApplicationpublicclassSpringbootInvoicingApplication{publicstaticvoidmain(String[]args){SpringApplication.run(SpringbootInvoicingApplication.class,args);}}entity:product
packagecom.mckz.entity;publicclassProduct{privateIntegerpid;privateStringproductName;privateintquantity;publicIntegergetPid(){returnpid;}publicvoidsetPid(Integerpid){this.pid=pid;}publicStringgetProductName(){returnproductName;}publicvoidsetProductName(StringproductName){this.productName=productName;}publicintgetQuantity(){returnquantity;}publicvoidsetQuantity(intquantity){this.quantity=quantity;}}
entity:user
packagecom.mckz.entity;importorg.springframework.stereotype.Repository;@RepositorypublicclassUser{privateIntegeruid;privateStringuserName;privateStringpassword;privateStringrealName;publicIntegergetUid(){returnuid;}publicvoidsetUid(Integeruid){this.uid=uid;}publicStringgetUserName(){returnuserName;}publicvoidsetUserName(StringuserName){this.userName=userName;}publicStringgetPassword(){returnpassword;}publicvoidsetPassword(Stringpassword){this.password=password;}publicStringgetRealName(){returnrealName;}publicvoidsetRealName(StringrealName){this.realName=realName;}}entity:sale
Userdao
packagecom.mckz.dao;importcom.mckz.entity.Product;importorg.apache.ibatis.annotations.Param;importorg.apache.ibatis.annotations.Select;importorg.springframework.stereotype.Repository;importjava.util.List;@RepositorypublicinterfaceProductDao{//查库存@Select("select*fromproduct")publicList
packagecom.mckz.dao;importcom.mckz.entity.Product;importcom.mckz.entity.Sale;importorg.apache.ibatis.annotations.Param;importorg.apache.ibatis.annotations.Select;importorg.springframework.stereotype.Repository;importjava.util.List;@RepositorypublicinterfaceSaleDao{//查询publicList
packagecom.mckz.service;importcom.mckz.entity.Product;importjava.util.List;publicinterfaceProductService{//查库存publicList
packagecom.mckz.service;importcom.github.pagehelper.PageInfo;importcom.mckz.entity.Product;importcom.mckz.entity.Sale;importorg.apache.ibatis.annotations.Param;importjava.util.List;publicinterfaceSaleService{//查询publicPageInfo
packagecom.mckz.service.impl;importcom.mckz.dao.ProductDao;importcom.mckz.entity.Product;importcom.mckz.service.ProductService;importorg.springframework.beans.factory.annotation.Autowired;importorg.springframework.stereotype.Service;importjava.util.List;@Service("ProductService")publicclassProductServiceImplimplementsProductService{@AutowiredProductDaoproductDao;@OverridepublicList
packagecom.mckz.service.impl;importcom.github.pagehelper.Page;importcom.github.pagehelper.PageHelper;importcom.github.pagehelper.PageInfo;importcom.mckz.dao.ProductDao;importcom.mckz.dao.SaleDao;importcom.mckz.entity.Product;importcom.mckz.entity.Sale;importcom.mckz.service.SaleService;importorg.springframework.beans.factory.annotation.Autowired;importorg.springframework.stereotype.Service;importjava.util.List;@Service("SaleService")publicclassSaleServiceImplimplementsSaleService{@AutowiredSaleDaosaleDao;@AutowiredProductDaoproductDao;@OverridepublicPageInfo
packagecom.mckz.service.impl;importcom.mckz.dao.UserDao;importcom.mckz.entity.*;importcom.mckz.service.UserService;importorg.springframework.beans.factory.annotation.Autowired;importorg.springframework.stereotype.Service;@Service("UserService")publicclassUserServiceImplimplementsUserService{@AutowiredUserDaouserDao;@OverridepublicUserlogin(Useruser){returnuserDao.login(user);}}application.properties
spring.datasource.driver-class-name=com.mysql.jdbc.Driverspring.datasource.url=jdbc:mysql:///invoicingsystemspring.datasource.username=rootspring.datasource.password=123mybais.mapper-locations=classpath:mapper/*.xmlmybatis.type-aliases-package=com.zn.entity#映射级别mybatis.configuration.auto-mapping-behavior=full#SpringDataJPA配置spring.jpa.hibernate.ddl-auto=updatespring.jpa.show-sql=truespring.jackson.serialization.indent-output=truespring.jpa.database=mysqlspring.main.allow-bean-definition-overriding=true