Myeclipse下搭建springboot+mybatis+alidruid数据源 war文件

1、创建一个maven project项目。注意：如果要编译为war运行在tomcat服务，则在Packaging处选择war。

2、双击pom.xml， 点击pom.xml选项卡，修改如下：

<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 http://maven.apache.org/xsd/maven-4.0.0.xsd">
  <modelVersion>4.0.0</modelVersion>
  <groupId>celerityspringboot</groupId>
  <artifactId>celerityspringboot</artifactId>
  <version>0.0.1-SNAPSHOT</version>
  <packaging>war</packaging>
  <properties>
  	<webVersion>3.0</webVersion>
  	<project.build.sourceEncoding>UTF-8</project.build.sourceEncoding>
	<project.reporting.outputEncoding>UTF-8</project.reporting.outputEncoding>
	<java.version>1.8</java.version>
  </properties>
  <!-- 1、设置Spring boot的parent:引入以后在声明其它dependency的时候就不需要version -->
  <parent>
	<groupId>org.springframework.boot</groupId>
	<artifactId>spring-boot-starter-parent</artifactId>
	<version>1.5.6.RELEASE</version>
  </parent>
  <!-- 2、导入Spring boot的web支持:spring官方解释spring-boot-starter-web包含了
	         spring webmvc和tomcat等web开发的特性。 -->
  <dependencies>
 	 <dependency>
		<groupId>org.springframework.boot</groupId>
		<artifactId>spring-boot-starter-web</artifactId>
	</dependency>
	<dependency>
	   <groupId>org.mybatis.spring.boot</groupId>
	   <artifactId>mybatis-spring-boot-starter</artifactId>
	   <version>1.3.1</version>
	</dependency>
	<dependency>
		<groupId>org.springframework.boot</groupId>
		<artifactId>spring-boot-devtools</artifactId>
		<optional>true</optional>
	</dependency> 
	<!-- springboot 的web支持 -->
	<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>
       <scope>provided</scope>
	</dependency>
	
	<dependency>
		<groupId>org.springframework.boot</groupId>
		<artifactId>spring-boot-starter-test</artifactId>
		<scope>test</scope>
	</dependency>
	<dependency>
        <groupId>org.springframework.boot</groupId>
        <artifactId>spring-boot-starter-jdbc</artifactId>
    </dependency>
    <dependency>
       <groupId>org.springframework.boot</groupId>
       <artifactId>spring-boot-starter-tomcat</artifactId>
       <scope>provided</scope>
   </dependency>	 
   <!-- mysql连接 -->    
     <dependency>    
         <groupId>mysql</groupId>    
         <artifactId>mysql-connector-java</artifactId>    
         <version>5.1.42</version>    
     </dependency> 
	<!-- mybatis逆向工程包 -->
    <dependency>  
        <groupId>org.mybatis.generator</groupId>  
        <artifactId>mybatis-generator-core</artifactId>  
        <version>1.3.5</version>  
    </dependency> 
    <!--json、基本包-->  
    <dependency>  
      <groupId>com.alibaba</groupId>  
      <artifactId>fastjson</artifactId>  
      <version>1.2.23</version>  
    </dependency>  
    <dependency>  
      <groupId>xml-apis</groupId>  
      <artifactId>xml-apis</artifactId>  
      <version>2.0.2</version>  
    </dependency>  
    <dependency>  
      <groupId>commons-net</groupId>  
      <artifactId>commons-net</artifactId>  
      <version>3.5</version>  
    </dependency>  
    <dependency>
	    <groupId>net.sf.json-lib</groupId>
	    <artifactId>json-lib</artifactId>
	    <version>2.4</version>
	    <classifier>jdk15</classifier><!--指定jdk版本-->  
	</dependency>
	 <!-- alibaba的druid数据库连接池 -->
    <dependency>
        <groupId>com.alibaba</groupId>
        <artifactId>druid-spring-boot-starter</artifactId>
        <version>1.1.0</version>
    </dependency>
  </dependencies>
  <build/>
</project>

注意：因为我们产生的文件是war文件，是运行再tomcat里，所有我们需要将springboot里原有的tomcat依赖移除，并添加新的依赖servlet-api。

3、在src/main/java下创建包“com.ds"，并在该包下创建App.java 和 SpringBootStartApplication.java：

package com.ds;

import org.mybatis.spring.annotation.MapperScan;
import org.springframework.boot.SpringApplication;
import org.springframework.boot.autoconfigure.SpringBootApplication;


@SpringBootApplication
@MapperScan("com.ds.dao")//加入mybatis需要的路径加入
public class App {

	public static void main(String[] args) {
		// TODO Auto-generated method stub
		 SpringApplication.run(App.class, args);
	}

}

package com.ds;

import org.springframework.boot.builder.SpringApplicationBuilder;
import org.springframework.boot.web.support.SpringBootServletInitializer;

public class SpringBootStartApplication extends SpringBootServletInitializer{
	@Override
    protected SpringApplicationBuilder configure(SpringApplicationBuilder builder) {
        // 注意这里要指向原先用main方法执行的Application启动类
        return builder.sources(App.class);
    }
}

SpringBootStartApplication.java的作用是用于类型web.xml的配置方式来启动springboot。特别注意：这两个类的包地址必须在你后面要写的功能类包的上一个目录。

4、在src/main/java下创建包“com.ds.controller"，并在该包下创建UserCtrls.java:

package com.ds.controller;

import java.util.Map;

import org.springframework.beans.factory.annotation.Autowired;
import org.springframework.web.bind.annotation.RequestMapping;
import org.springframework.web.bind.annotation.RestController;

import com.ds.service.UserService;

@RestController
public class UserCtrls {
	@Autowired
	UserService usersrv;
	
	@RequestMapping("/test")
	public Map test(){
		return usersrv.getaccount("祁大帅比");
	}
	
}

5、在src/main/java下创建包“com.ds.dao"，并在该包下创建UserMapper.java:

package com.ds.dao;

import java.util.Map;

public interface UserMapper {
	 Map selectUserByName(String username);
}

此类为接口。

6、在src/main/java下创建包“com.ds.service"，并在该包下创建UserService.java:

package com.ds.service;

import java.util.Map;

import org.springframework.beans.factory.annotation.Autowired;
import org.springframework.stereotype.Service;

import com.ds.dao.UserMapper;
@Service
public class UserService {
	@Autowired
	UserMapper usermapper;
	
	public Map getaccount(String str) {
		return usermapper.selectUserByName(str);
	}
}

7、在src/main/resources下创建文件夹“mybatis”,并在该文件夹下创建UserMapper.xml：

<?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.ds.dao.UserMapper" >
 
    <select id="selectUserByName"  resultType="Map">
        SELECT * FROM user WHERE username = #{username}
    </select>
 
</mapper>

8.在src/main/resources下创建“application.yml”：

server:
  port: 8080

spring:
    datasource:
        name: test
        url: jdbc:mysql://127.0.0.1:3606/qjcds?useSSL=false
        username: root
        password: root
        # 使用druid数据源
        type: com.alibaba.druid.pool.DruidDataSource
        driver-class-name: com.mysql.jdbc.Driver
        filters: stat
        maxActive: 20
        initialSize: 1
        maxWait: 60000
        minIdle: 1
        timeBetweenEvictionRunsMillis: 60000
        minEvictableIdleTimeMillis: 300000
        validationQuery: select 'x'
        testWhileIdle: true
        testOnBorrow: false
        testOnReturn: false
        poolPreparedStatements: true
        maxOpenPreparedStatements: 20
mybatis:
  mapper-locations: classpath:mapper/*.xml
  type-aliases-package: 

9、在MySQL数据库中创建库qjcds，表user，表结构：

CREATE TABLE `user` (
  `id` int(11) NOT NULL,
  `age` int(11) NOT NULL,
  `username` varchar(45) NOT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8;

10、将该项目发布至Tomcat，启动后按照http://127.0.0.1:8080/项目名称/.....

源码地址：https://download.csdn.net/download/qq_37847316/10712182