[1]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>
  6.     <!--[1]工程继承spring-boot-starter-parent -->
  7.     <parent>
  8.         <groupId>org.springframework.boot</groupId>
  9.         <artifactId>spring-boot-starter-parent</artifactId>
  10.         <version>2.3.5.RELEASE</version>
  11.     </parent>
  13.     <groupId>com.st</groupId>
  14.     <artifactId>mis-springboot</artifactId>
  15.     <version>0.0.1-SNAPSHOT</version>
  18.     <properties>
  19.         <java.version>1.8</java.version>
  20.     </properties>
  22.     <dependencies>
  23.         <dependency>
  24.             <groupId>org.springframework.boot</groupId>
  25.             <artifactId>spring-boot-starter-web</artifactId>
  26.         </dependency>
  28.         <!-- mybatis的场景启动器 -->
  29.         <dependency>
  30.             <groupId>org.mybatis.spring.boot</groupId>
  31.             <artifactId>mybatis-spring-boot-starter</artifactId>
  32.             <version>2.1.3</version>
  33.         </dependency>
  35.         <!-- 测试的场景启动器 -->
  36.         <dependency>
  37.             <groupId>org.springframework.boot</groupId>
  38.             <artifactId>spring-boot-starter-test</artifactId>
  39.             <scope>test</scope>
  40.         </dependency>
  42.         <!--thymeleaf场景启动器 -->
  43.         <dependency>
  44.             <groupId>org.springframework.boot</groupId>
  45.             <artifactId>spring-boot-starter-thymeleaf</artifactId>
  46.         </dependency>
  49.         <!-- druid连接池 -->
  50.         <dependency>
  51.             <groupId>com.alibaba</groupId>
  52.             <artifactId>druid</artifactId>
  53.             <version>1.1.10</version>
  54.         </dependency>
  56.         <!-- mysql驱动 -->
  57.         <dependency>
  58.             <groupId>mysql</groupId>
  59.             <artifactId>mysql-connector-java</artifactId>
  60.             <version>5.1.38</version>
  61.             <exclusions>
  62.                 <exclusion>
  63.                     <groupId>com.google.protobuf</groupId>
  64.                     <artifactId>protobuf-java</artifactId>
  65.                 </exclusion>
  66.             </exclusions>
  67.         </dependency>
  68.     </dependencies>
  70.     <build>
  71.         <!-- 资源文件的位置 -->
  72.         <resources>
  73.             <resource>
  74.                 <directory>src/main/java</directory>
  75.                 <includes>
  76.                     <include>**/*.xml</include>
  77.                     <include>**/*.properties</include>
  78.                     <include>**/*.yml</include>
  79.                 </includes>
  80.                 <filtering>true</filtering>
  81.             </resource>
  82.             <resource>
  83.                 <directory>src/main/resources/</directory>
  84.                 <includes>
  85.                     <include>**/*.xml</include>
  86.                     <include>**/*.properties</include>
  87.                     <include>**/*.yml</include>
  88.                     <include>**/*.html</include>
  89.                 </includes>
  90.                 <filtering>true</filtering>
  91.             </resource>
  92.         </resources>
  94.         <plugins>
  95.             <plugin>
  96.                 <groupId>org.springframework.boot</groupId>
  97.                 <artifactId>spring-boot-maven-plugin</artifactId>
  98.             </plugin>
  99.         </plugins>
  100.     </build>
  101. </project>

[2]快速生成pojo,mapper,service

[3]添加注解

Mapper接口上添加@Mapper注解

Service实现类上添加@Service注解

Config类上面添加

/**
 * @author:Cherry
 * @createTime:2021-03-30
 */
@Configuration
public class DruidConfig {
    @Bean
    @ConfigurationProperties("druid")
    public DataSource druid(){
        DataSource dataSource = new DruidDataSource();
        return dataSource;
    }
}

[4]主配置文件添加druid配置

#druid配置#
druid:
  driverClassName: com.mysql.jdbc.Driver
  url: jdbc:mysql://192.168.2.181:3306/mis?useUnicode=true&characterEncoding=UTF-8
  username: root
  password: root

[5]Controller类

/**
 * @author:Cherry
 * @createTime:2021-03-30
 */
@Controller
public class QuestionController {

    @Autowired
    private QuestionService questionService;

    @RequestMapping("/question/{id}")
    @ResponseBody
    public Question queryById(@PathVariable Long id){
        return questionService.queryById(id);
    }

    @RequestMapping("/questionList")
    public String queryAllByLimit(Model model){
        List<Question> questions = questionService.queryAllByLimit(0, 10);
        model.addAttribute("questions",questions);
        return "question-list";
    }
}

[6]事务的配置

1.在主应用类上添加注解：

 @EnableTransactionManagement(proxyTargetClass = false)

@EnableTransactionManagement:开启事务管理
属性proxyTargetClass配置代理方式，默认为false，spring会自动选择代理方式，如果配置为true则表示强制使用CGLib代理方式.

@SpringBootApplication
@EnableTransactionManagement(proxyTargetClass = false)
public class MisApplication {
    public static void main(String[] args) {
        SpringApplication.run(MisApplication.class, args);
    }
}

2.在service接口或者类添加配置

@Transactional(isolation = Isolation.DEFAULT,
        propagation = Propagation.REQUIRED,
        timeout = -1)
public interface QuestionService {

    /**
     * 通过ID查询单条数据
     *
     * @param questionid 主键
     * @return 实例对象
     */
    @Transactional(isolation = Isolation.DEFAULT,
        propagation = Propagation.REQUIRED,
        timeout = -1)
    Question queryById(Long questionid);
}

注：如果方法上面添加配置，那么方法上的配置会覆盖接口上放的配置
如果在实现类上面添加配置，在类上方的注解会覆盖接口中的事务注解配置