<?xml version="1.0" encoding="UTF-8"?>
<project xmlns="http://maven.apache.org/POM/4.0.0" xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance"
         xsi:schemaLocation="http://maven.apache.org/POM/4.0.0 https://maven.apache.org/xsd/maven-4.0.0.xsd">
    <modelVersion>4.0.0</modelVersion>
    <parent>
        <groupId>org.springframework.boot</groupId>
        <artifactId>spring-boot-starter-parent</artifactId>
        <version>2.1.17.RELEASE</version>
        <relativePath/> <!-- lookup parent from repository -->
    </parent>
    <groupId>com.Jules</groupId>
    <artifactId>springBoot01</artifactId>
    <version>0.0.1-SNAPSHOT</version>
    <name>springBoot01</name>
    <description>springBoot01</description>
    <properties>
        <java.version>1.8</java.version>
        <project.build.sourceEncoding>UTF-8</project.build.sourceEncoding>
        <project.reporting.outputEncoding>UTF-8</project.reporting.outputEncoding>
        <spring-boot.version>2.1.17.RELEASE</spring-boot.version>
    </properties>
    <dependencies>    
	    <!-- spring-boot-starter-web會(huì)自動(dòng)幫我們引入開發(fā)過程中所需要的web模塊jar包，
	    如包含了spring-web和spring-webmvc的依賴，好處就是我們不需要逐個(gè)的去導(dǎo)入，
	    只需要導(dǎo)入一個(gè)就可以，這樣可以避免遺漏或者版本問題。 -->
        <dependency>
            <groupId>org.springframework.boot</groupId>
            <artifactId>spring-boot-starter-web</artifactId>
        </dependency>
        <dependency>
            <groupId>org.springframework.boot</groupId>
            <artifactId>spring-boot-starter-test</artifactId>
            <scope>test</scope>
        </dependency>
    </dependencies>
    <dependencyManagement>
        <dependencies>
            <dependency>
                <groupId>org.springframework.boot</groupId>
                <artifactId>spring-boot-dependencies</artifactId>
                <version>${spring-boot.version}</version>
                <type>pom</type>
                <scope>import</scope>
            </dependency>
        </dependencies>
    </dependencyManagement>
<!-- 自己的插件配置，我自己的插件生成的，省略了，不重要 -->
    <build>
        <plugins>
            <plugin>
                …………
            </plugin>
            …………
        </plugins>
    </build>
</project>

    <parent>
        <groupId>org.springframework.boot</groupId>
        <artifactId>spring-boot-starter-parent</artifactId>
        <version>2.1.17.RELEASE</version>
        <relativePath/> <!-- lookup parent from repository -->
    </parent>

<!--mysql驅(qū)動(dòng)-->
    <dependency>
        <groupId>mysql</groupId>
        <artifactId>mysql-connector-java</artifactId>
        <version>5.1.44</version>
    </dependency>
<!--數(shù)據(jù)庫連接-->
    <dependency>
        <groupId>org.springframework.boot</groupId>
        <artifactId>spring-boot-starter-jdbc</artifactId>
    </dependency>
<!--實(shí)體類注解包-->      
    <dependency>
         <groupId>org.projectlombok</groupId>
         <artifactId>lombok</artifactId>
     </dependency>
<!--mybatis的包支持sqpeingboot-->
     <dependency>
         <groupId>org.mybatis.spring.boot</groupId>
         <artifactId>mybatis-spring-boot-starter</artifactId>
         <version>2.1.3</version>
     </dependency>

@SpringBootApplication /*核心注解*/
public class SpringBoot01Application {
    public static void main(String[] args) {
        SpringApplication.run(SpringBoot01Application.class, args);
    }
}

//dao層接口、service層接口
//@Repository  //dao接口注解，如果不要在service的實(shí)現(xiàn)層會(huì)有一個(gè)報(bào)紅，但不會(huì)影響項(xiàng)目執(zhí)行
public interface ProviderMapper {
    /**
     *
     * @param proName
     * @param pyl  偏移量
     * @param limit  頁面容量
     * @return
     */
    public List<Provider> providerInfoList(
            @Param("proName") String proName,
            @Param("pyl") Integer pyl,
            @Param("limit") Integer limit
    );
}

<?xml version="1.0" encoding="UTF-8" ?>
<!DOCTYPE mapper
        PUBLIC "-//mybatis.org//DTD Mapper 3.0//EN"
        "http://mybatis.org/dtd/mybatis-3-mapper.dtd">
<mapper namespace="com.jules.springboot01.mapper.ProviderMapper">
    <select id="providerInfoList" resultType="com.jules.springboot01.pojo.Provider">
        select * from smbms_provider
        <where>
            <if test="proName != null and proName != ''">
                and proName like concat('%',#{proName},'%')
            </if>
        </where>
        order by id desc limit #{pyl},#{limit}
    </select>
</mapper>

//service層實(shí)現(xiàn)
@Service
public class ProviderServiceImpl implements ProviderService {
    @Autowired
    private ProviderMapper providerMapper;  //前面說的報(bào)紅就是這里，不影響
    public List<Provider> providerInfoList(String proName,Integer page, Integer limit) {
        //計(jì)算偏移量
        int pyl = (page-1)*limit;
        return providerMapper.providerInfoList(proName,pyl,limit);
    }
}

//controller層
@Controller
@ResponseBody
@RequestMapping("/xxx")
public class ProviderController {
    @Autowired
    private ProviderService providerService;
    @RequestMapping(value = "/providerInfoList",method = RequestMethod.GET)
    @ResponseBody
    public List<Provider> providerInfoList(String proName,Integer page, Integer limit){
        System.out.println("proName=="+proName);
        List<Provider> providers = providerService.providerInfoList(proName,1,10);
        return providers;
    }
}

@SpringBootApplication
@MapperScan("com.jules.springboot01.mapper")
public class SpringBoot01Application {
    public static void main(String[] args) {
        SpringApplication.run(SpringBoot01Application.class, args);
    }
}

#配置相關(guān)配置，格式如下
#項(xiàng)目名
spring.application.name: springBoot01
#端口號(hào)
service.port: 8080

#數(shù)據(jù)庫連接(導(dǎo)jar包)
spring:
  datasource:
    url: jdbc:mysql://localhost:3306/數(shù)據(jù)庫名稱?useUnicode=true&characterEncoding=utf8&useSSL=false
    driver-class-name: com.mysql.jdbc.Driver
    username: xxxx
    password: xxxx
# 端口號(hào)
server:
  port: 8080
namevo: 朱爾斯
# mybatis相關(guān)配置
mybatis:
  mapper-locations: classpath:mapper/*.xml  #掃描mapper(dao層)
  type-aliases-package: com.jules.springboot01.pojo    #別名
  configuration:
    log-impl: org.apache.ibatis.logging.stdout.StdOutImpl #SQL控制臺(tái)打印

spring: 
	resources: 
		static-locations: classpath:/templates,classpath:/static/,file:D://

@Configuration //容器啟動(dòng)時(shí)加載
//@ConfigurationProperties("application.yml")
public class AppConfig {
	@Value("${namevo}")
	private String namevo;
	//創(chuàng)建bean實(shí)例 別名為stu
	@Bean(name = "stu")
	public Student getStudent(){
		Student stu = new Student();
		stu.setStudentName("Jules");
		return stu;
	}
}

<dependency>
	<groupId>org.springframework.boot</groupId>
	<artifactId>spring-boot-starter-web</artifactId>
	<!--移除tomcat-->
	<exclusions>
		<exclusion>
		<groupId>org.springframework.boot</groupId>
		<artifactId>spring-boot-starter-tomcat</artifactId>
		</exclusion>
	</exclusions>
</dependency>
<dependency>
	<groupId>javax.servlet</groupId>
	<artifactId>javax.servlet-api</artifactId>
	<version>4.0.1</version>
	<scope>provided</scope>
</dependency>

//使啟動(dòng)類繼承 SpringBootServletInitializer 類，并覆蓋 configure 方法
@SpringBootApplication
public class SpringbootCSApplication extends SpringBootServletInitializer {
	//覆蓋configure方法
	protected SpringApplicationBuilder configure(SpringApplicationBuilder builder) {
		return builder.sources(SpringbootCS.class);
	}
	public static void main(String[] args) {
		SpringApplication.run(SpringbootCS.class, args);
	}
}

# application.properties文件
namevo: 朱爾斯

# application.yml文件
namevo: Jules