Spring Boot出来很久了，也用了很久了，虽然用的时候也用的挺方便的，但毕竟那个框架不是自己搭的，再怎么运用也不如自己搭建个，在搭的过程中，还是踩了些小坑，下面则是搭建的过程：

　　打开idea，File--> New--> Project -->Maven -->Next --> Next -->Finish

 

 

 

 

 

建立项目之后，按照下面的目录依次搭建：

 

 pom.xml文件如下：

     
         
     
      4.0.0
          
     
      com.test.demo
          
     
      demo002
          
     
      1.0-SNAPSHOT
          
              
      
       org.springframework.boot
               
               
      
       spring-boot-starter-parent
               
      
       1.3.3.RELEASE
               
       
           
          
              
      
       1.8
           
          
              
               
                   
       
        org.springframework.boot
                    
       
        spring-boot-starter-data-jpa
                
               
               
                   
       
        org.springframework.boot
                    
       
        spring-boot-starter-web
                
               
               
                   
       
        mysql
                    
       
        mysql-connector-java
                
           
          
          
              
                   
       
        dev
                    
                        
        
         true
                     
                    
                        
        
         dev
                     
                
               
                   
       
        product
                    
                        
        
         product
                     
                
           
          
              
                   
       
        config_filters/filter-${active.profile}.properties
                
               
                   
                        
        
         src/main/resources
                         
        
         true
                     
                
               
                   
                        
        
         org.apache.maven.plugins
                         
        
         maven-compiler-plugin
                         
        
         3.2
                         
                             
         1.8                     
         
          1.8
                              
         
          utf-8
                          
                     
                    
                        
        
         org.springframework.boot
                         
        
         spring-boot-maven-plugin
                     
                
           
      
    

 

 

application.properties 文件如下：

server.port=8025 spring.datasource.max-idle=10 spring.datasource.max-wait=10000 spring.datasource.min-idle=1 spring.datasource.initial-size=1 spring.datasource.validation-query=SELECT 1 spring.datasource.test-on-borrow=false spring.datasource.test-while-idle=true spring.datasource.time-between-eviction-runs-millis=18800 spring.datasource.url=@db.dyh2020.url@ spring.datasource.username=@db.dyh2020.username@ spring.datasource.password=@db.dyh2020.password@ spring.datasource.driver-class-name=com.mysql.jdbc.Driver spring.jpa.database=MYSQL # 显示后台处理的SQL语句 spring.jpa.show-sql=true # 自动检查实体和数据库表是否一致，如果不一致则会进行更新数据库表 spring.jpa.hibernate.ddl-auto=none Main.java文件如下：

package com.test.demo; import org.springframework.boot.SpringApplication; import org.springframework.boot.autoconfigure.EnableAutoConfiguration; import org.springframework.context.annotation.ComponentScan; @EnableAutoConfiguration @ComponentScan(basePackages = "/com.test.demo") public class Main {
       public static void main(String[] args){
           SpringApplication.run(Main.class, args);     } }

DemoController.java文件：

package com.test.demo.controllers; import com.test.demo.domain.entities.Address; import com.test.demo.domain.entities.AddressRepository; import com.test.demo.services.DemoService; import org.springframework.beans.factory.annotation.Autowired; import org.springframework.web.bind.annotation.RequestMapping; import org.springframework.web.bind.annotation.RequestParam; import org.springframework.web.bind.annotation.RestController; import java.util.List; @RestController @RequestMapping("/hello") public class DemoController {
       @Autowired     private DemoService demoService;     @Autowired     private AddressRepository addressRepository;     /**      * RequestParam 参数里面的name和value的效果是一样的      * RequestMapping 参数里面就只能是value了，      * @param name      * @return      */     @RequestMapping(value = "/demo")     public String demo(@RequestParam(name = "name")String name, @RequestParam(value = "id")int id){
           return "hello "+ name+"\t"+id;     }     /**      * RequestParam 参数里面的name和value的效果是一样的      * RequestMapping 参数里面就只能是value了，      * @param name      * @return      */     @RequestMapping(value = "/queryaddress")     public String demo(@RequestParam(name = "name")String name){
           List
 addressList = demoService.queryAddress("%"+name+"%");         List
 addressList2 = addressRepository.queryListByName("%"+name+"%");         System.out.println(addressList.toString());         System.out.println(addressList2.toString());         return addressList.toString(); //        return "wolaile";     }     /**      * 查找      * @param id      * @return      */     @RequestMapping("/query")     public String query(@RequestParam(name = "id")int id){
           Address a =  demoService.findById(id);         return a==null?"没有符合查找的东西":a.toString();     }     /**      * 查找      * @param id      * @return      */     @RequestMapping("/update")     public String query(@RequestParam(name = "id")int id,@RequestParam(name = "address")String address){
           Address a =  demoService.updateName(id,address);         return  a==null?"什么也没有":a.toString();     } }

DemoService.java文件如下：

package com.test.demo.services;

import com.test.demo.domain.entities.Address; import com.test.demo.domain.entities.AddressRepository; import org.springframework.beans.factory.annotation.Autowired; import org.springframework.stereotype.Service; import java.util.List; @Service public class DemoService {
        @Autowired     private AddressRepository addressRepository;     /**      * 根据名称查找地区      * @param name      * @return      */     public List
 queryAddress(String name){
            return addressRepository.queryListByName(name);     }     public Address findById(int id){
            return addressRepository.findOne(id);     }     public Address updateName(int id, String address){
            Address a = addressRepository.findOne(id);         if (a!=null){
                a.setAddress(address);             addressRepository.save(a);             return a;         }else             return null;     } }

Address.java实体如下：

package com.test.demo.domain.entities; import javax.persistence.Column; import javax.persistence.Entity; import javax.persistence.Id; import javax.persistence.Table; import java.util.Date; @Entity @Table(name = "address") public class Address {
       /**      * 主键      */     @Id     private Integer id;     /**      * 省      */     @Column(name = "province", nullable = false)     private String province;     /**      * 市      */     @Column(name = "city", nullable = false)     private String city;     /**      * address      */     @Column(name = "address", nullable = false)     private String address;     /**      * 创建时间      */     @Column(name = "create_time", nullable = false)     private Date createTime;     /**      * 创建时间      */     @Column(name = "update_time", nullable = false)     private Date updateTime;     /**      * contact      */     @Column(name = "contact", nullable = false)     private String contact;     /**      * appellation      */     @Column(name = "appellation", nullable = false)     private String appellation;     /**      * deleted      */     @Column(name = "deleted", nullable = false)     private Boolean deleted;     /**      * deleted      */     @Column(name = "mobile", nullable = false)     private String mobile;     /**      * status      */     @Column(name = "status", nullable = false )     private Integer status;     /**      * user_id      */     @Column(name = "user_id", nullable = false )     private Integer userId;     /**      * province_id      */     @Column(name = "province_id", nullable = false )     private Integer provinceId;      /**      * city_id      */     @Column(name = "city_id", nullable = false )     private Integer cityId;     /**      * area_id      */     @Column(name = "area_id", nullable = false )     private Integer areaId;     public Integer getId() {
           return id;     }     public void setId(Integer id) {
           this.id = id;     }     public String getProvince() {
           return province;     }     public void setProvince(String province) {
           this.province = province;     }     public String getCity() {
           return city;     }     public void setCity(String city) {
           this.city = city;     }     public String getAddress() {
           return address;     }     public void setAddress(String address) {
           this.address = address;     }     public Date getCreateTime() {
           return createTime;     }     public void setCreateTime(Date createTime) {
           this.createTime = createTime;     }     public Date getUpdateTime() {
           return updateTime;     }     public void setUpdateTime(Date updateTime) {
           this.updateTime = updateTime;     }     public String getContact() {
           return contact;     }     public void setContact(String contact) {
           this.contact = contact;     }     public String getAppellation() {
           return appellation;     }     public void setAppellation(String appellation) {
           this.appellation = appellation;     }     public Boolean getDeleted() {
           return deleted;     }     public void setDeleted(Boolean deleted) {
           this.deleted = deleted;     }     public String getMobile() {
           return mobile;     }     public void setMobile(String mobile) {
           this.mobile = mobile;     }     public Integer getStatus() {
           return status;     }     public void setStatus(Integer status) {
           this.status = status;     }     public Integer getUserId() {
           return userId;     }     public void setUserId(Integer userId) {
           this.userId = userId;     }     public Integer getProvinceId() {
           return provinceId;     }     public void setProvinceId(Integer provinceId) {
           this.provinceId = provinceId;     }     public Integer getCityId() {
           return cityId;     }     public void setCityId(Integer cityId) {
           this.cityId = cityId;     }     public Integer getAreaId() {
           return areaId;     }     public void setAreaId(Integer areaId) {
           this.areaId = areaId;     }     @Override     public String toString() {
           return "Address{" +                 "id=" + id +                 ", province='" + province + '\'' +                 ", city='" + city + '\'' +                 ", address='" + address + '\'' +                 ", createTime=" + createTime +                 ", updateTime=" + updateTime +                 ", contact='" + contact + '\'' +                 ", appellation='" + appellation + '\'' +                 ", deleted=" + deleted +                 ", mobile='" + mobile + '\'' +                 ", status=" + status +                 ", userId=" + userId +                 ", provinceId=" + provinceId +                 ", cityId=" + cityId +                 ", areaId=" + areaId +                 '}';     } }

AddressRepository.java 文件如下：

package com.test.demo.domain.entities; import org.springframework.data.jpa.repository.JpaRepository; import org.springframework.data.jpa.repository.Query; import java.util.List; public interface AddressRepository extends JpaRepository
    
     {
       @Query(value = "select * from address where address like ?",nativeQuery = true)     List
     
 queryListByName(String name); } 数据库连接文件eg：filter-dev.properties文件
    

# 数据库连接 db.dyh2020.url=jdbc:mysql://127.0.0.1:3306/dyh_test?characterEncoding=utf8&useSSL=false&useOldAliasMetadataBehavior=true&autoReconnect=true db.dyh2020.username=root db.dyh2020.password=admin #日志级别 #logging.level.root=ERROR

发布之后：

 

发布之后在浏览器访问：http://localhost:8025/hello/query?id=5

git地址：https://github.com/DYH2020/springBootDemo/tree/master/demo002