mybatis+springboot中使用mysql的实例_java

    
        
            org.springframework.boot
            spring-boot-starter
        
        
            org.mybatis.spring.boot
            mybatis-spring-boot-starter
            2.0.1
        

        
            mysql
            mysql-connector-java
            runtime
        
        
            com.alibaba
            druid
            1.1.10
        

    

spring:
  datasource:
    type: com.alibaba.druid.pool.DruidDataSource
    url: jdbc:mysql://127.0.0.1:3306/sbac_master?autoRecOnnect=true&useUnicode=true&characterEncoding=utf-8&zeroDateTimeBehavior=convertToNull&allowMultiQueries=true
    username: root
    password: 1234
    driver-class-name: com.mysql.cj.jdbc.Driver

mybatis:
  config-location: classpath:mybatis-config.xml
  mapper-locations: classpath:com/lazycece/sbac/mysql/data/dao/*/mapper/*.xml

@Mapper
public interface UserDao {

    void insert(User user);

    User findByUsername(@Param("username") String username);
}

@SpringBootApplication
@MapperScan(basePackages = {"com.lazycece.sbac.mysql.data.dao"})
public class SpringbootAcMysqlSimpleApplication {

    public static void main(String[] args) {
        SpringApplication.run(SpringbootAcMysqlSimpleApplication.class, args);
    }

}

    
        id,create_time,update_time,username,password,telephone,status,editor
    

    
        INSERT  INTO
        user (create_time,update_time,username,password,telephone,status,editor)
        VALUE (#{createTime},#{updateTime},#{username},#{password},#{telephone},#{status},#{editor});
    

    
        SELECT
        
        FROM user
        WHERE username = #{username};
    

    
        
            
                src/main/java
                
                    com/lazycece/sbac/mysql/data/dao/*/mapper/*.xml