springboot整合mybatis中的问题及出现的一些问题小结

spring:
 datasource:
  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
  
  name: test
  url: jdbc:mysql://localhost:3306/mama-bike?useUnicode=true&characterEncoding=UTF-8&zeroDateTimeBehavior=convertToNull
  username: root
  password: root

mybatis:
 #告诉spring你的mapper的位置。
 mapper-locations: classpath:com/coder520/mamabike/**/**. 
 #告诉spring你的实体类的位置
 type-aliases-package: classpath:com.coder520.mamabike.**.entity

logging:
 config: classpath:logback. 

public interface UserMapper {
 int insert(User record);
}

<?  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.coder520.mamabike.user.dao.UserMapper\" >
 <resultMap id=\" ResultMap\" type=\"com.coder520.mamabike.user.entity.User\" >
 <id column=\"id\" property=\"id\" jdbcType=\"BIGINT\" />
 <result column=\"nickname\" property=\"nickname\" jdbcType=\"VARCHAR\" />
 <result column=\"enable_flag\" property=\"enableFlag\" jdbcType=\"TINYINT\" />
 <result column=\"verify_flag\" property=\"verifyFlag\" jdbcType=\"TINYINT\" />
 <result column=\"head_img\" property=\"headImg\" jdbcType=\"VARCHAR\" />
 <result column=\"mobile\" property=\"mobile\" jdbcType=\"VARCHAR\" />
 </resultMap>
 <sql id=\" _Column_List\" >
 id, nickname, enable_flag, verify_flag, head_img, mobile
 </sql>
 <insert id=\"insert\" parameterType=\"com.coder520.mamabike.user.entity.User\" >
 insert into user (id, nickname, enable_flag, 
  verify_flag, head_img, mobile
  )
 values (#{id,jdbcType=BIGINT}, #{nickname,jdbcType=VARCHAR}, #{enableFlag,jdbcType=TINYINT}, 
  #{verifyFlag,jdbcType=TINYINT}, #{headImg,jdbcType=VARCHAR}, #{mobile,jdbcType=VARCHAR}
  )
 </insert>
</mapper>

@SpringBootApplication
@ComponentScan( Packages={\"com.coder520.mamabike\"})
@MapperScan( Packages=\"com.demo.user.mapper\")
public class MamaBikeApplication {
 public static void main(String[] args) {
  SpringApplication.run(MamaBikeApplication.class, args);
 }
}