devbox
运维做开发
这个屌丝很懒，什么也没留下！
关注作者
热门标签
热门文章
当前位置:   article > 正文

Springboot整合_classfinal springboot

作者：运维做开发 | 2024-07-11 11:49:55

赞

踩

classfinal springboot

  • 新建一个Spring Initializr项目

  • 创建项目的文件结构以及jdk的版本 

  • 选择项目所需要的依赖

 

  •  POM文件修改

  1. <?xml version="1.0" encoding="UTF-8"?>
  2. <project xmlns="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.     <modelVersion>4.0.0</modelVersion>
  5.     <parent>
  6.         <groupId>org.springframework.boot</groupId>
  7.         <artifactId>spring-boot-starter-parent</artifactId>
  8.         <version>2.6.4</version>
  9.         <relativePath/> <!-- lookup parent from repository -->
  10.     </parent>
  11.     <groupId>aoyi</groupId>
  12.     <artifactId>sn</artifactId>
  13.     <version>0.0.1-SNAPSHOT</version>
  14.     <name>sn</name>
  15.     <description>Demo project for Spring Boot</description>
  16.     <properties>
  17.         <java.version>1.8</java.version>
  18.     </properties>
  19.     <dependencies>
  20.         <dependency>
  21.             <groupId>org.springframework.boot</groupId>
  22.             <artifactId>spring-boot-starter</artifactId>
  23.         </dependency>
  24.  
  25.         <dependency>
  26.             <groupId>org.springframework.boot</groupId>
  27.             <artifactId>spring-boot-starter-test</artifactId>
  28.             <scope>test</scope>
  29.         </dependency>
  30.  
  31.  
  32.         <dependency>
  33.             <groupId>org.springframework.boot</groupId>
  34.             <artifactId>spring-boot-starter-web</artifactId>
  35.         </dependency>
  36.  
  37.         <dependency>
  38.             <groupId>mysql</groupId>
  39.             <artifactId>mysql-connector-java</artifactId>
  40.             <version>8.0.28</version>
  41.         </dependency>
  42.  
  43.         <dependency>
  44.             <groupId>org.projectlombok</groupId>
  45.             <artifactId>lombok</artifactId>
  46.         </dependency>
  47.  
  48.         <dependency>
  49.             <groupId>org.mybatis</groupId>
  50.             <artifactId>mybatis</artifactId>
  51.             <version>3.5.0</version>
  52.         </dependency>
  53.  
  54.         <!--缺少此jar包，导致@Mapper注解无效-->
  55.         <dependency>
  56.             <groupId>org.mybatis.spring.boot</groupId>
  57.             <artifactId>mybatis-spring-boot-starter</artifactId>
  58.             <version>2.0.1</version>
  59.             <exclusions>
  60.                 <exclusion>
  61.                     <artifactId>mybatis</artifactId>
  62.                     <groupId>org.mybatis</groupId>
  63.                 </exclusion>
  64.             </exclusions>
  65.         </dependency>
  66.  
  67.          <!--分页插件-->
  68.         <dependency>
  69.             <groupId>com.github.pagehelper</groupId>
  70.             <artifactId>pagehelper-spring-boot-starter</artifactId>
  71.             <version>1.2.5</version>
  72.             <exclusions>
  73.                 <exclusion>
  74.                     <artifactId>mybatis-spring-boot-starter</artifactId>
  75.                     <groupId>org.mybatis.spring.boot</groupId>
  76.                 </exclusion>
  77.             </exclusions>
  78.         </dependency>
  79.  
  80.         <!--swagger-->
  81.         <dependency>
  82.             <groupId>io.springfox</groupId>
  83.             <artifactId>springfox-swagger2</artifactId>
  84.             <version>2.7.0</version>
  85.         </dependency>
  86.         <!--swagger ui-->
  87.         <dependency>
  88.             <groupId>io.springfox</groupId>
  89.             <artifactId>springfox-swagger-ui</artifactId>
  90.             <version>2.7.0</version>
  91.         </dependency>
  92.  
  93.         <dependency>
  94.             <groupId>com.alibaba</groupId>
  95.             <artifactId>fastjson</artifactId>
  96.             <version>1.2.29</version>
  97.         </dependency>
  98.  
  99.         <dependency>
  100.             <groupId>org.apache.commons</groupId>
  101.             <artifactId>commons-lang3</artifactId>
  102.             <version>3.10</version>
  103.         </dependency>
  104.  
  105.         <!--rabbitmq 依赖客户端--> <dependency>
  106.         <groupId>com.rabbitmq</groupId>
  107.         <artifactId>amqp-client</artifactId>
  108.         <version>5.8.0</version>
  109.     </dependency>
  110.         <!--操作文件流的一个依赖--> <dependency>
  111.         <groupId>commons-io</groupId>
  112.         <artifactId>commons-io</artifactId>
  113.         <version>2.6</version>
  114.     </dependency>
  115.  
  116.  
  117.     </dependencies>
  118.  
  119.     <build>
  120.         <!--读取数据库配置-->
  121.         <resources>
  122.             <resource>
  123.                 <directory>src/main/resources</directory>
  124.                 <includes>
  125.                     <include>**/*.properties</include>
  126.                     <include>**/*.xml</include>
  127.                     <include>**/*.yml</include>
  128.                 </includes>
  129.                 <filtering>true</filtering>
  130.             </resource>
  132.         </resources>
  133.         <plugins>
  134.             <plugin>
  135.                 <groupId>org.springframework.boot</groupId>
  136.                 <artifactId>spring-boot-maven-plugin</artifactId>
  137.             </plugin>
  139.             <!-- 具体插件，逆向工程的操作是以构建过程中插件形式出现的 --> <plugin>
  140.             <groupId>org.mybatis.generator</groupId>
  141.             <artifactId>mybatis-generator-maven-plugin</artifactId>
  142.             <version>1.3.0</version>
  143.             <!-- 插件的依赖 -->
  144.             <dependencies>
  145.                 <!-- 逆向工程的核心依赖 -->
  146.                 <dependency>
  147.                     <groupId>org.mybatis.generator</groupId>
  148.                     <artifactId>mybatis-generator-core</artifactId>
  149.                     <version>1.3.2</version> </dependency>
  150.                 <!-- 数据库连接池 -->
  151.                 <dependency>
  152.                     <groupId>com.mchange</groupId>
  153.                     <artifactId>c3p0</artifactId>
  154.                     <version>0.9.2</version>
  155.                 </dependency>
  156.                 <!-- MySQL驱动 -->
  157.                 <dependency>
  158.                     <groupId>mysql</groupId>
  159.                     <artifactId>mysql-connector-java</artifactId>
  160.                     <version>5.1.8</version> </dependency>
  161.             </dependencies>
  162.         </plugin>
  166.         </plugins>
  168.     </build>
  170. </project>

  • 修改配置文件

将resource文件夹下原有的application.properties文件删除，创建application.yml配置文件（备注：其实SpringBoot底层会把application.yml文件解析为application.properties），本文创建了两个yml文件（application.yml和application-dev.yml）

application.yml

  1. spring:
  2.   profiles:
  3.     active: dev

application-dev.yml

  1. server:
  2.   port: 8080
  3.  
  4. spring:
  5.   datasource:
  6.     username: root
  7.     password: 1234
  8.     url: jdbc:mysql://localhost:3306/springboot?useUnicode=true&characterEncoding=utf-8&useSSL=true&serverTimezone=UTC
  9.     driver-class-name: com.mysql.jdbc.Driver
  10.  
  11.     #解决循环依赖的问题
  12.   main:
  13.     allow-circular-references: true
  14. mybatis:
  15.   mapper-locations: classpath:mapping/*.xml
  16.   type-aliases-package: org.aoyi.sn.entity
  17. pagehelper:
  18.     helperDialect: mysql
  19.     reasonable: true
  20.     page-size-zero: true
  21.     supportMethodsArguments: true
  22.     params: count=countSql
  23. #showSql
  24. logging:
  25.   level:
  26.     com.example.demo.mapper: debug

在项目中配置多套环境的配置方法。
 

笔记：在Spring Boot中多环境配置文件名需要满足application-{profile}.yml的格式，其中{profile}对应你的环境标识，比如：

application-dev.yml：开发环境
application-test.yml：测试环境
application-prod.yml：生产环境
至于哪个具体的配置文件会被加载，需要在application.yml文件中通过spring.profiles.active属性来设置，其值对应{profile}值。

  • 配置 mybatis-generator-core

  • 在resource文件下创建generatorConfig.xml文件
  • 修改自己要生成的位置
  1. <?xml version="1.0" encoding="UTF-8"?>
  2. <!DOCTYPE generatorConfiguration
  3.         PUBLIC "-//mybatis.org//DTD MyBatis Generator Configuration 1.0//EN"
  4.         "http://mybatis.org/dtd/mybatis-generator-config_1_0.dtd">
  5. <generatorConfiguration>
  6.     <!-- targetRuntime: 执行生成的逆向工程的版本 MyBatis3Simple: 生成基本的CRUD（清新简洁版）
  7.     MyBatis3: 生成带条件的CRUD（奢华尊享版） -->
  8.     <context id="DB2Tables" targetRuntime="MyBatis3Simple">
  9.         <!-- 数据库的连接信息 -->
  10.     <jdbcConnection driverClass="com.mysql.jdbc.Driver" connectionURL="jdbc:mysql://rm-bp1vc9osk3mo2o4h3lo.mysql.rds.aliyuncs.com:端口/数据库名称" userId=" " password=" "></jdbcConnection>
  11.         <!-- javaBean的生成策略-->
  12.         <javaModelGenerator targetPackage="org.aoyi.sn.entity" targetProject=".\src\main\java">
  13.             <property name="enableSubPackages" value="true" /> <property name="trimStrings" value="true" />
  14.         </javaModelGenerator>
  15.         <!-- SQL映射文件的生成策略 xml生成 -->
  16.         <sqlMapGenerator targetPackage="mapping" targetProject=".\src\main\resources">
  17.             <property name="enableSubPackages" value="true" />
  18.         </sqlMapGenerator>
  19.         <!-- Mapper接口的生成策略 -->
  20.         <javaClientGenerator type="XMLMAPPER" targetPackage="org.aoyi.sn.mapper" targetProject=".\src\main\java">
  21.             <property name="enableSubPackages" value="true" />
  22.         </javaClientGenerator>
  23.         <!-- 逆向分析的表 -->
  24.         <!-- tableName设置为*号，可以对应所有表，此时不写domainObjectName -->
  25.     <!-- domainObjectName属性指定生成出来的实体类的类名 -->
  26.         <table tableName="aoyi_sn_order" domainObjectName="AoyiSnOrder" />
  27.  
  28.  
  29.     </context>
  30. </generatorConfiguration>
  • 右键Run maven build

  • 生成效果

  • 基本方法都已经生成好了

  • 启动类配置扫描mapper

  • 在resource文件下创建logback-spring.xml

  1. <?xml version="1.0" encoding="UTF-8"?>
  2. <configuration  scan="true" scanPeriod="10 seconds">
  3.  
  4.     <contextName>logback</contextName>
  5.     <property name="log.path" value="D:/project/helen/guli_log/edu" /> //输出路径
  6.  
  7.     <!--控制台日志格式：彩色日志-->
  8.     <!-- magenta:洋红 -->
  9.     <!-- boldMagenta:粗红-->
  10.     <!-- cyan:青色 -->
  11.     <!-- white:白色 -->
  12.     <!-- magenta:洋红 -->
  13.     <property name="CONSOLE_LOG_PATTERN"
  14.               value="%yellow(%date{yyyy-MM-dd HH:mm:ss}) |%highlight(%-5level) |%blue(%thread) |%blue(%file:%line) |%green(%logger) |%cyan(%msg%n)"/>
  15.  
  16.     <!--文件日志格式-->
  17.     <property name="FILE_LOG_PATTERN"
  18.               value="%date{yyyy-MM-dd HH:mm:ss} |%-5level |%thread |%file:%line |%logger |%msg%n" />
  19.  
  20.     <!--编码-->
  21.     <property name="ENCODING"
  22.               value="UTF-8" />
  23.  
  24.     <!--输出到控制台-->
  25.     <appender name="CONSOLE" class="ch.qos.logback.core.ConsoleAppender">
  26.         <filter class="ch.qos.logback.classic.filter.ThresholdFilter">
  27.             <!--日志级别-->
  28.             <level>DEBUG</level>
  29.         </filter>
  30.         <encoder>
  31.             <!--日志格式-->
  32.             <Pattern>${CONSOLE_LOG_PATTERN}</Pattern>
  33.             <!--日志字符集-->
  34.             <charset>${ENCODING}</charset>
  35.         </encoder>
  36.     </appender>
  37.  
  38.     <!--输出到文件-->
  39.     <appender name="INFO_FILE" class="ch.qos.logback.core.rolling.RollingFileAppender">
  40.         <!--日志过滤器：此日志文件只记录INFO级别的-->
  41.         <filter class="ch.qos.logback.classic.filter.LevelFilter">
  42.             <level>INFO</level>
  43.             <onMatch>ACCEPT</onMatch>
  44.             <onMismatch>DENY</onMismatch>
  45.         </filter>
  46.         <!-- 正在记录的日志文件的路径及文件名 -->
  47.         <file>${log.path}/log_info.log</file>
  48.         <encoder>
  49.             <pattern>${FILE_LOG_PATTERN}</pattern>
  50.             <charset>${ENCODING}</charset>
  51.         </encoder>
  52.         <!-- 日志记录器的滚动策略，按日期，按大小记录 -->
  53.         <rollingPolicy class="ch.qos.logback.core.rolling.TimeBasedRollingPolicy">
  54.             <!-- 每天日志归档路径以及格式 -->
  55.             <fileNamePattern>${log.path}/info/log-info-%d{yyyy-MM-dd}.%i.log</fileNamePattern>
  56.             <timeBasedFileNamingAndTriggeringPolicy class="ch.qos.logback.core.rolling.SizeAndTimeBasedFNATP">
  57.                 <maxFileSize>100MB</maxFileSize>
  58.             </timeBasedFileNamingAndTriggeringPolicy>
  59.             <!--日志文件保留天数-->
  60.             <maxHistory>15</maxHistory>
  61.         </rollingPolicy>
  62.     </appender>
  63.  
  64.     <appender name="WARN_FILE" class="ch.qos.logback.core.rolling.RollingFileAppender">
  65.         <!-- 日志过滤器：此日志文件只记录WARN级别的 -->
  66.         <filter class="ch.qos.logback.classic.filter.LevelFilter">
  67.             <level>WARN</level>
  68.             <onMatch>ACCEPT</onMatch>
  69.             <onMismatch>DENY</onMismatch>
  70.         </filter>
  71.         <!-- 正在记录的日志文件的路径及文件名 -->
  72.         <file>${log.path}/log_warn.log</file>
  73.         <encoder>
  74.             <pattern>${FILE_LOG_PATTERN}</pattern>
  75.             <charset>${ENCODING}</charset> <!-- 此处设置字符集 -->
  76.         </encoder>
  77.         <!-- 日志记录器的滚动策略，按日期，按大小记录 -->
  78.         <rollingPolicy class="ch.qos.logback.core.rolling.TimeBasedRollingPolicy">
  79.             <fileNamePattern>${log.path}/warn/log-warn-%d{yyyy-MM-dd}.%i.log</fileNamePattern>
  80.             <timeBasedFileNamingAndTriggeringPolicy class="ch.qos.logback.core.rolling.SizeAndTimeBasedFNATP">
  81.                 <maxFileSize>100MB</maxFileSize>
  82.             </timeBasedFileNamingAndTriggeringPolicy>
  83.             <!--日志文件保留天数-->
  84.             <maxHistory>15</maxHistory>
  85.         </rollingPolicy>
  86.     </appender>
  87.  
  88.     <appender name="ERROR_FILE" class="ch.qos.logback.core.rolling.RollingFileAppender">
  89.         <!-- 日志过滤器：此日志文件只记录ERROR级别的 -->
  90.         <filter class="ch.qos.logback.classic.filter.LevelFilter">
  91.             <level>ERROR</level>
  92.             <onMatch>ACCEPT</onMatch>
  93.             <onMismatch>DENY</onMismatch>
  94.         </filter>
  95.         <!-- 正在记录的日志文件的路径及文件名 -->
  96.         <file>${log.path}/log_error.log</file>
  97.         <encoder>
  98.             <pattern>${FILE_LOG_PATTERN}</pattern>
  99.             <charset>${ENCODING}</charset> <!-- 此处设置字符集 -->
  100.         </encoder>
  101.         <!-- 日志记录器的滚动策略，按日期，按大小记录 -->
  102.         <rollingPolicy class="ch.qos.logback.core.rolling.TimeBasedRollingPolicy">
  103.             <fileNamePattern>${log.path}/error/log-error-%d{yyyy-MM-dd}.%i.log</fileNamePattern>
  104.             <timeBasedFileNamingAndTriggeringPolicy class="ch.qos.logback.core.rolling.SizeAndTimeBasedFNATP">
  105.                 <maxFileSize>100MB</maxFileSize>
  106.             </timeBasedFileNamingAndTriggeringPolicy>
  107.             <!--日志文件保留天数-->
  108.             <maxHistory>15</maxHistory>
  109.         </rollingPolicy>
  110.     </appender>
  111.  
  112.     <!--开发环境-->
  113.     <springProfile name="dev">
  114.         <!--可以灵活设置此处，从而控制日志的输出-->
  115.         <root level="DEBUG">
  116.             <appender-ref ref="CONSOLE" />
  117.             <appender-ref ref="INFO_FILE" />
  118.             <appender-ref ref="WARN_FILE" />
  119.             <appender-ref ref="ERROR_FILE" />
  120.         </root>
  121.     </springProfile>
  122.  
  123.     <!--生产环境-->
  124.     <springProfile name="pro">
  125.         <root level="ERROR">
  126.             <appender-ref ref="ERROR_FILE" />
  127.         </root>
  128.     </springProfile>
  129.  
  130. </configuration>

创建util包 封装返回值

  1. package aoyi.sn.util;
  2.  
  3.  
  4. /**
  5.  *  
  6.  * @author LEOH
  7.  *
  8.  */
  9. public class BaseResult<T> {
  10. 	private String retMsg;
  11. 	private String retCode;
  12. 	private T data;
  13. 	public T getData() {
  14. 		return data;
  15. 	}
  16. 	public void setData(T data) {
  17. 		this.data = data;
  18. 	}
  19. 	public String getRetMsg() {
  20. 		return retMsg;
  21. 	}
  22. 	public void setRetMsg(String retMsg) {
  23. 		this.retMsg = retMsg;
  24. 	}
  25. 	public String getRetCode() {
  26. 		return retCode;
  27. 	}
  28. 	public void setRetCode(String retCode) {
  29. 		this.retCode = retCode;
  30. 	}
  31.  
  32. 	public BaseResult<T> buildOk(T t, String retMsg) {
  33. 		BaseResult<T> tBaseResult = new BaseResult<>();
  34. 		tBaseResult.data = t;
  35. 		tBaseResult.retCode = Constants.SuccessCode;
  36. 		tBaseResult.retMsg = retMsg;
  37. 		return tBaseResult;
  38. 	}
  39.  
  40. 	public BaseResult<T> buildFail(String retMsg){
  41. 		BaseResult<T> tBaseResult = new BaseResult<>();
  42. 		tBaseResult.retCode = Constants.FailCode;
  43. 		tBaseResult.retMsg = retMsg;
  44. 		return tBaseResult;
  45. 	}
  46.  
  47. }
  1. package aoyi.sn.util;
  2.  
  3. public class Constants {
  4.  
  5.  
  6. 	public static final String Query = "[查询]";
  7. 	public static final String Add = "[新增]";
  8. 	public static final String Update = "[更新]";
  9. 	public static final String Delete = "[删除]";
  10. 	public static final String Duplicate = "[重复]";
  11. 	public static String SplitChar = "_";
  12. 	/**
  13. 	 * 24*3600*10 10 days
  14. 	 */
  15. 	public static final long ExpireTime = 864000;
  16.  
  17. 	public static final String FailCode = "FAIL";
  18.  
  19. 	public static final String SuccessCode = "OKAY";
  20.  
  21. 	public static final int PageSize = 10;
  22.  
  23. }

select标签常用属性

parameterType   传入参数  支持map javaBean等值  resultMap 返回参数


Mapper增加

public List<AoyiSnCategory> selectAll(Map<String, Object> paras);

xml增加

  1.  <sql id="Base_Column_List">
  2.    id, create_by, create_time,
  3.       update_by, update_time, sn_category_id,
  4.       sn_category_name, sn_category_level, sn_category_parent_id
  5.   </sql>
  1.  <select id="selectAll" resultMap="BaseResultMap" >
  2.     select     <include refid="Base_Column_List" />
  3.     from aoyi_sn_category
  4.   </select>

创建service

  1. @Service
  2. public interface AoyiSnCategoryService {
  3.  
  4.  
  5.     public BaseResult<PageInfo<AoyiSnCategory>> getSnCategorys(Map<String, Object> paras);
  6. }

创建serviceimpl

  1.  
  2.  
  3. import java.util.*;
  4.  
  5. @Service
  6. @Transactional(rollbackFor = { RuntimeException.class, Exception.class })
  7. public class AoyiSnCategoryServiceImpl implements AoyiSnCategoryService {
  8.     private static final Logger logger = LoggerFactory.getLogger(AoyiSnCategoryService.class);
  9.     @Autowired
  10.     private AoyiSnCategoryMapper aoyiSnCategoryMapper;
  11.    
  12.  
  13.     @Override
  14.     public BaseResult<PageInfo<AoyiSnCategory>> getSnCategorys(Map<String, Object> paras) {
  15.         logger.info("查询类型列表");
  16.         BaseResult<PageInfo<AoyiSnCategory>> baseRet = new BaseResult<PageInfo<AoyiSnCategory>>();
  17.         baseRet.setRetCode(Constants.FailCode);
  18.         baseRet.setRetMsg(Constants.Query);
  19.         int pageNo = Integer.parseInt(String.valueOf(paras.get("pageNo")));
  20.         int pageSize = Integer.parseInt(String.valueOf(paras.get("pageSize")));
  21.         PageHelper.startPage(pageNo, pageSize);
  22.         List<AoyiSnCategory> list = aoyiSnCategoryMapper.selectAll(paras);
  23.         PageInfo<AoyiSnCategory> pageDataList = new PageInfo<AoyiSnCategory>(list);
  24.         baseRet.setData(pageDataList);
  25.         baseRet.setRetCode(Constants.SuccessCode);
  26.         return baseRet;
  27.     }
  28.  
  29.  
  30. }

controller

  1. @RestController
  2. @RequestMapping("/AoyiSnCategory")
  3. public class AoyiSnCategoryController {
  4.  
  5.     @Autowired
  6.     private AoyiSnCategoryService aoyiSnCategoryService;
  7.  
  8.     //查询
  9.     @RequestMapping(value = "getAoyiSnCategorys", method = RequestMethod.POST)
  10.     @ResponseBody
  11.     public BaseResult<PageInfo<AoyiSnCategory>> getDeviceTypeByParas(@RequestBody Map<String, Object> paras){
  12.         return aoyiSnCategoryService.getSnCategorys(paras);
  13.     }
  14.  
  15.  
  16. }

启动

测试查询    封装好了分页  查询2条 

配置了日志 打印sql 需下载mybatis Log 插件 

增加

 public Integer insertAoyiSnCategory(Map<String, Object>  paras);
  1. @Override
  2. public BaseResult<Integer> insertAoyiSnCategory(Map<String, Object> paras) {
  3.     BaseResult<Integer> baseRet = new BaseResult<Integer>();
  4.     baseRet.setRetCode(Constants.FailCode);
  5.     baseRet.setRetMsg(Constants.Add);
  6.     String createTime = DateUtil.formatYYYYMMDDHHMMSS(new Date());
  7.     paras.put("createTime", createTime);
  8.     paras.put("id", UUID.randomUUID().toString());
  9.     Integer integerBaseResult = aoyiSnCategoryMapper.insertAoyiSnCategory(paras);
  10.    baseRet.setData(integerBaseResult);
  11.     baseRet.setRetCode(Constants.SuccessCode);
  12.     return baseRet;
  13. }
  1.  <insert id="insertAoyiSnCategory"  parameterType="java.util.Map">
  2.  
  3. insert into aoyi_sn_category (id, create_by, create_time,
  4.      update_by, update_time, sn_category_id,
  5.      sn_category_name, sn_category_level, sn_category_parent_id
  6.      )
  7.    values (#{id,jdbcType=VARCHAR}, #{createBy,jdbcType=VARCHAR}, #{createTime,jdbcType=TIMESTAMP},
  8.      #{updateBy,jdbcType=VARCHAR}, #{updateTime,jdbcType=TIMESTAMP}, #{snCategoryId,jdbcType=VARCHAR},
  9.      #{snCategoryName,jdbcType=VARCHAR}, #{snCategoryLevel,jdbcType=VARCHAR}, #{snCategoryParentId,jdbcType=VARCHAR}
  10.      )
  11.    </insert>
  1.  //增加
  2.     @RequestMapping(value = "/insertAoyiSnCategorys", method = RequestMethod.POST)
  3.     @ResponseBody
  4.     public BaseResult<Integer> insertAoyiSnCategorys(@RequestBody Map<String, Object> paras){
  5.         return aoyiSnCategoryService.insertAoyiSnCategory(paras);
  6.     }

测试

修改

public int updateAoyiSnCategory(Map<String, Object> paras);

  1.   <update id="updateAoyiSnCategory"  parameterType="java.util.Map">
  2.   update aoyi_sn_category
  3.     <set>
  4.       <if test="snCategoryName != null and snCategoryName != ''">sn_category_name = #{snCategoryName}</if>
  5.     </set>
  6.     WHERE
  7.     id = #{id}
  8.   </update>
  1. @Override
  2. public BaseResult<Integer> updateAoyiSnCategory(Map<String, Object> paras) {
  3.     BaseResult<Integer> baseRet = new BaseResult<Integer>();
  4.     baseRet.setRetCode(Constants.FailCode);
  5.     baseRet.setRetMsg(Constants.Update);
  6.     int ret = aoyiSnCategoryMapper.updateAoyiSnCategory(paras);
  7.     baseRet.setData(ret);
  8.     baseRet.setRetCode(Constants.SuccessCode);
  9.     return baseRet;
  10. }
  1.   @RequestMapping(value = "/updateAoyiSnCategory", method = RequestMethod.POST)
  2.     @ResponseBody
  3.     public BaseResult<Integer> updateAoyiSnCategory(@RequestBody Map<String, Object> paras){
  4.         return aoyiSnCategoryService.updateAoyiSnCategory(paras);
  5.     }

测试

删除

public BaseResult<Integer> deleteDeviceType(int id);

  1.   @Override
  2.     public BaseResult<Integer> delectAoyiSnCategory(String id) {
  3.         BaseResult<Integer> baseRet = new BaseResult<Integer>();
  4.         baseRet.setRetCode(Constants.FailCode);
  5.         baseRet.setRetMsg(Constants.Delete);
  6.         int ret = aoyiSnCategoryMapper.deleteByPrimaryKey(id);
  7.         baseRet.setData(ret);
  8.         baseRet.setRetCode(Constants.SuccessCode);
  9.         return baseRet;
  10.     }
  1.   @RequestMapping(value = "/delectAoyiSnCategory", method = RequestMethod.POST)
  2.     @ResponseBody
  3.     public BaseResult<Integer> delectAoyiSnCategory(@RequestBody Map<String, Object> paras){
  4.         return aoyiSnCategoryService.delectAoyiSnCategory((String) paras.get("id"));
  5.     }

idea上传项目到gitee（码云）超详细 

(3条消息) idea上传项目到gitee（码云）超详细_『愚』的博客-CSDN博客_idea上传项目到gitee

剩下内容以后在加入

  1. package org.aoyi.sn.mqtt;
  2.  
  3. import com.rabbitmq.client.Channel;
  4. import com.rabbitmq.client.Connection;
  5. import com.rabbitmq.client.ConnectionFactory;
  6.  
  7. public class RabbitMqUtils {
  8. //得到一个连接的 channel
  9. public static Channel getChannel() throws Exception{
  10. //创建一个连接工厂
  11.  ConnectionFactory factory = new ConnectionFactory();
  12.  factory.setHost("192.168.1.125");
  13.  factory.setUsername("admin");
  14.  factory.setPassword("123");
  15. Connection connection = factory.newConnection();
  16. Channel channel = connection.createChannel();
  17. return channel;
  18. } }

声明：本文内容由网友自发贡献，不代表【wpsshop博客】立场，版权归原作者所有，本站不承担相应法律责任。如您发现有侵权的内容，请联系我们。转载请注明出处：https://www.wpsshop.cn/w/运维做开发/article/detail/810156
推荐阅读
相关标签

Copyright © 2003-2013 www.wpsshop.cn 版权所有，并保留所有权利。

  

闽ICP备14008679号