• SpringBoot项目整合

    一、创建项目

    IDEA中采用spring initialzer...创建，jdk选择8，maven,jar。。。springboot版本2.5.0（稳定）

    项目依赖：

    二、项目结构：

    原始pom.xml文件

    1. "1.0" encoding="UTF-8"?>
    2. "http://maven.apache.org/POM/4.0.0" xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance"
    3. 	xsi:schemaLocation="http://maven.apache.org/POM/4.0.0 https://maven.apache.org/xsd/maven-4.0.0.xsd">
    4. 	4.0.0
    5. 	
    6. 		org.springframework.boot
    7. 		spring-boot-starter-parent
    8. 		2.5.0
    9. 		 
    10. 	
    11. 	com.itheima
    12. 	springboot_09_ssm
    13. 	0.0.1-SNAPSHOT
    14. 	springboot_09_ssm
    15. 	Demo project for Spring Boot
    16. 	
    17. 		1.8
    18. 	
    19. 	
    20. 		
    21. 			org.springframework.boot
    22. 			spring-boot-starter-web
    23. 		
    24. 		
    25. 			org.mybatis.spring.boot
    26. 			mybatis-spring-boot-starter
    27. 			2.2.0
    28. 		
    29.  
    30. 		
    31. 			mysql
    32. 			mysql-connector-java
    33. 			runtime
    34. 		
    35. 		
    36. 			org.springframework.boot
    37. 			spring-boot-starter-test
    38. 			test
    39. 		
    40. 		
    41. 		
    42. 			com.alibaba
    43. 			druid
    44. 			1.1.16
    45. 		
    46. 	
    47.  
    48. 	
    49. 		
    50. 			
    51. 				org.springframework.boot
    52. 				spring-boot-maven-plugin
    53. 			
    54. 		
    55. 	
    56.

     原始application.yml

    1.  
    2.  
    3. spring:
    4.   datasource:
    5.     type: com.alibaba.druid.pool.DruidDataSource
    6.     driver-class-name: com.mysql.cj.jdbc.Driver
    7.     url: jdbc:mysql://localhost:3306/www #?servierTimezone=UTC
    8.     username: root
    9.     password: root
    10. server:
    11.   port: 80

    domain层

    用于存储实体类

    1. public class Book {
    2.     private Integer id;
    3.     private String type;
    4.     private String name;
    5.     private String description;
    6.     @Override
    7.     public String toString() {
    8.         return "Book{" +
    9.                 "id=" + id +
    10.                 ", type='" + type + '\'' +
    11.                 ", name='" + name + '\'' +
    12.                 ", description='" + description + '\'' +
    13.                 '}';
    14.     }
    15.  
    16.     public Integer getId() {
    17.         return id;
    18.     }
    19.  
    20.     public void setId(Integer id) {
    21.         this.id = id;
    22.     }
    23.  
    24.     public String getType() {
    25.         return type;
    26.     }
    27.  
    28.     public void setType(String type) {
    29.         this.type = type;
    30.     }
    31.  
    32.     public String getName() {
    33.         return name;
    34.     }
    35.  
    36.     public void setName(String name) {
    37.         this.name = name;
    38.     }
    39.  
    40.     public String getDescription() {
    41.         return description;
    42.     }
    43.  
    44.     public void setDescription(String description) {
    45.         this.description = description;
    46.     }
    47. }

    dao层

    用于操作数据库 

    1. @Mapper  //注意mapper
    2. public interface BookDao {
    3.     @Insert("insert into tbl_book (type,name,description) values(#{type},#{name},#{description})")
    4.     public int save(Book book);
    5.     @Update("update tbl_book set type = #{type}, name = #{name}, description = #{description} where id = #{id}")
    6.     public int update(Book book);
    7.     @Delete("delete from tbl_book where id = #{id}")
    8.     public int delete(Integer id);
    9.     @Select("select * from tbl_book where id = #{id}")
    10.     public Book getById(Integer id);
    11.     @Select("select * from tbl_book")
    12.     public List getAll();
    13. }

    service层

    用于业务实现

    接口：

    1. @Transactional
    2. public interface BookService {
    3.     /**
    4.      * 保存
    5.      * @param book
    6.      * @return
    7.      */
    8.     public boolean save(Book book);
    9.     /**
    10.      * 修改
    11.      * @param book
    12.      * @return
    13.      */
    14.     public boolean update(Book book);
    15.     /**
    16.      * 按id删除
    17.      * @param id
    18.      * @return
    19.      */
    20.     public boolean delete(Integer id);
    21.     /**
    22.      * 按id查询
    23.      * @param id
    24.      * @return
    25.      */
    26.     public Book getById(Integer id);
    27.     /**
    28.      * 查询全部
    29.      * @return
    30.      */
    31.     public List getAll();
    32. }

    类：

    1. @Service
    2. public class BookServiceImpl implements BookService {
    3.     @Autowired
    4.     private BookDao bookDao;
    5.  
    6.     public boolean save(Book book) {
    7.         return bookDao.save(book) > 0;
    8.     }
    9.  
    10.     public boolean update(Book book) {
    11.         return bookDao.update(book) > 0;
    12.     }
    13.  
    14.     public boolean delete(Integer id) {
    15.         return bookDao.delete(id) > 0;
    16.     }
    17.  
    18.     public Book getById(Integer id) {
    19.         
    20.         return bookDao.getById(id);
    21.     }
    22.  
    23.     public List getAll() {
    24.         return bookDao.getAll();
    25.     }
    26. }

    controller层

    用于控制业务流程

    1. @RestController
    2. @RequestMapping("/books")
    3. public class BookController {
    4.     @Autowired
    5.     private BookService bookService;
    6.  
    7.     @PostMapping
    8.     public Result save(@RequestBody Book book) {
    9.         boolean flag = bookService.save(book);
    10.         return new Result(flag ? Code.SAVE_OK:Code.SAVE_ERR,flag);
    11.     }
    12.  
    13.     @PutMapping
    14.     public Result update(@RequestBody Book book) {
    15.         boolean flag = bookService.update(book);
    16.         return new Result(flag ? Code.UPDATE_OK:Code.UPDATE_ERR,flag);
    17.     }
    18.  
    19.     @DeleteMapping("/{id}")
    20.     public Result delete(@PathVariable Integer id) {
    21.         boolean flag = bookService.delete(id);
    22.         return new Result(flag ? Code.DELETE_OK:Code.DELETE_ERR,flag);
    23.     }
    24.  
    25.     @GetMapping("/{id}")
    26.     public Result getById(@PathVariable Integer id) {
    27.         Book book = bookService.getById(id);
    28.         Integer code = book != null ? Code.GET_OK : Code.GET_ERR;
    29.         String msg = book != null ? "" : "数据查询失败，请重试！";
    30.         return new Result(code,book,msg);
    31.     }
    32.  
    33.     @GetMapping
    34.     public Result getAll() {
    35.         List bookList = bookService.getAll();
    36.         Integer code = bookList != null ? Code.GET_OK : Code.GET_ERR;
    37.         String msg = bookList != null ? "" : "数据查询失败，请重试！";
    38.         return new Result(code,bookList,msg);
    39.     }
    40. }

    tip: Code 类和 Result 和ProjectExceptionAdvice在Controller层中

    code类用于规定result返回的编码类别

    1. public class Code {
    2.     public static final Integer SAVE_OK = 20011;
    3.     public static final Integer DELETE_OK = 20021;
    4.     public static final Integer UPDATE_OK = 20031;
    5.     public static final Integer GET_OK = 20041;
    6.  
    7.     public static final Integer SAVE_ERR = 20010;
    8.     public static final Integer DELETE_ERR = 20020;
    9.     public static final Integer UPDATE_ERR = 20030;
    10.     public static final Integer GET_ERR = 20040;
    11.  
    12.     public static final Integer SYSTEM_ERR = 50001;
    13.     public static final Integer SYSTEM_TIMEOUT_ERR = 50002;
    14.     public static final Integer SYSTEM_UNKNOW_ERR = 59999;
    15.  
    16.     public static final Integer BUSINESS_ERR = 60002;
    17.  
    18. }

    result用于封装返回的结果，让后台数据进行统一化处理

    1. public class Result {
    2.     private Object data;
    3.     private Integer code;
    4.     private String msg;
    5.  
    6.     public Result() {
    7.     }
    8.  
    9.     public Result(Integer code,Object data) {
    10.         this.data = data;
    11.         this.code = code;
    12.     }
    13.  
    14.     public Result(Integer code, Object data, String msg) {
    15.         this.data = data;
    16.         this.code = code;
    17.         this.msg = msg;
    18.     }
    19.  
    20.     public Object getData() {
    21.         return data;
    22.     }
    23.  
    24.     public void setData(Object data) {
    25.         this.data = data;
    26.     }
    27.  
    28.     public Integer getCode() {
    29.         return code;
    30.     }
    31.  
    32.     public void setCode(Integer code) {
    33.         this.code = code;
    34.     }
    35.  
    36.     public String getMsg() {
    37.         return msg;
    38.     }
    39.  
    40.     public void setMsg(String msg) {
    41.         this.msg = msg;
    42.     }
    43. }

    ProjectExceptionAdvice类用于规定 系统异常都抛到业务控制层，也就是controller层

    1. @RestControllerAdvice
    2. public class ProjectExceptionAdvice {
    3.     @ExceptionHandler(SystemException.class)
    4.     public Result doSystemException(SystemException ex){
    5.         //记录日志
    6.         //发送消息给运维
    7.         //发送邮件给开发人员,ex对象发送给开发人员
    8.         return new Result(ex.getCode(),null,ex.getMessage());
    9.     }
    10.  
    11.     @ExceptionHandler(BusinessException.class)
    12.     public Result doBusinessException(BusinessException ex){
    13.         return new Result(ex.getCode(),null,ex.getMessage());
    14.     }
    15.  
    16.     @ExceptionHandler(Exception.class)
    17.     public Result doOtherException(Exception ex){
    18.         //记录日志
    19.         //发送消息给运维
    20.         //发送邮件给开发人员,ex对象发送给开发人员
    21.         return new Result(Code.SYSTEM_UNKNOW_ERR,null,"系统繁忙，请稍后再试！");
    22.     }
    23. }

    exception层

    封装异常类

    BusinessException ，业务异常

    1. public class BusinessException extends RuntimeException{
    2.     private Integer code;
    3.  
    4.     public Integer getCode() {
    5.         return code;
    6.     }
    7.  
    8.     public void setCode(Integer code) {
    9.         this.code = code;
    10.     }
    11.  
    12.     public BusinessException(Integer code, String message) {
    13.         super(message);
    14.         this.code = code;
    15.     }
    16.  
    17.     public BusinessException(Integer code, String message, Throwable cause) {
    18.         super(message, cause);
    19.         this.code = code;
    20.     }
    21.  
    22. }

    SystemException  系统异常 

    1. public class SystemException extends RuntimeException{
    2.     private Integer code;
    3.  
    4.     public Integer getCode() {
    5.         return code;
    6.     }
    7.  
    8.     public void setCode(Integer code) {
    9.         this.code = code;
    10.     }
    11.  
    12.     public SystemException(Integer code, String message) {
    13.         super(message);
    14.         this.code = code;
    15.     }
    16.  
    17.     public SystemException(Integer code, String message, Throwable cause) {
    18.         super(message, cause);
    19.         this.code = code;
    20.     }
    21.  
    22. }

    测试：

    1. @SpringBootTest
    2. public class BookServiceTest {
    3.  
    4.     @Autowired
    5.     private BookService bookService;  //测试哪个  装配哪个
    6.  
    7. //    @Test
    8. //    public void testGetById(){
    9. //        Book book = bookService.getById(2);
    10. //        System.out.println(book);
    11. //    }
    12.  
    13.     @Test
    14.     public void testGetAll(){
    15.         List all = bookService.getAll();
    16.         System.out.println(all);
    17.     }
    18.  
    19. }

  • 相关阅读:
    [极客大挑战 2019]EasySQL
    .NET Core Apollo 配置中心
    dns域名解析服务和bond网卡
    挂耳式蓝牙耳机性价比推荐，盘点五款性能高的耳机分享
    thinkphp5.1 单元测试phpunit使用和常见问题
    油罐清洗抽吸系统设计
    《C++ primer plus》精炼（OOP部分）——对象和类（6）
    C语言考试题库之单选题
    实现异步转同步的几种方式
    死锁的成因及避免
  • 原文地址：https://blog.csdn.net/m0_61395860/article/details/133700156