SpringBoot对JavaWeb项目的简单部署

SpringBoot对JavaWeb项目的简单部署

1.基础依赖导入(pom文件)

    
    
        org.mybatis.spring.boot
        mybatis-spring-boot-starter
        2.1.2
    
    
    
    
        mysql
        mysql-connector-java
    
    
    
    
        org.projectlombok
        lombok
    
    
    
    
        org.springframework.boot
        spring-boot-starter-web
    
    
    
    
        com.alibaba
        druid
        1.1.22
    

2.文件配置信息(yml文件)

#tomcat端口号
server:
  port: 8081

#连接数据库信息
spring:
  datasource:
    driver-class-name: com.mysql.cj.jdbc.Driver
    url: jdbc:mysql:///air?serverTimezone=UTC
    username: root
    password: 123456
    type: com.alibaba.druid.pool.DruidDataSource
    
#spring boot已经集成logback日志
logging:
  level:
    com.hk.firstspringboot.mapper: DEBUG #扫描这个包下,(可以扫描mapper包下的接口类,打印出Sql语句)
    
# mybatis配置
mybatis:
  # 扫描映射文件
  mapper-locations: classpath:mapper/*.xml
  # 配置别名扫描的包
 #type-aliases-package: com.hk.firstspringboot.entity
 #configuration:
    # 开启驼峰映射配置
   #map-underscore-to-camel-case: true

3.其它注意:

1.mapper 接口包要扫描:在启动类上加注解:@MapperScan(basePackages = "例子:com.hk.easycodetest.mapper")

4.SpringBoot开启使用事务

启动类注解:

@EnableTransactionManagement // 启注解事务管理，等同于xml配置方式的 

@Transactional(propagation=Propagation.REQUIRED) //默认等同于@Transactional

表示当前方法必须运行在事务中。如果当前事务存在，方法将会在该事务中运行。否则，会启动一个新的事务

5.mapping的XML文档格式

<?xml version="1.0" encoding="UTF-8"?>



    
        
        
    

    
    
        select
          id, name
        from air.district
        where id = #{id}
    

    
    
        select
          id, name
        from air.district
        limit #{offset}, #{limit}
    

    
    
        select
        id, name
        from air.district
        
            
                and id = #{id}
            
            
                and name = #{name}
            
        
    

    
    
        insert into air.district(name)
        values (#{name})
    

    
    
        update air.district
        
            
                name = #{name},
            
        
        where id = #{id}
    

    
    
        delete from air.district where id = #{id}