springboot+mybatis

maven项目springboot+mybatis框架搭建心得
https://blog.youkuaiyun.com/a78270528/article/details/77532781
https://blog.youkuaiyun.com/a78270528/article/details/77573818
这两个连接是关于如何创建maven项目和搭建springboot框架，此处直接粘贴给大家，个人觉得写的比较详细，在集成mybatis框架的时候，在网上搜了很多文档，但都有问题，可能是配置文件或jar包的版本号不对，对于刚学习搭建框架的童鞋可以在application.xml配置文件里只配置mysql和mybatis，pom.xml文件也尽量简洁，框架搭起来后需要时再添加!
代码结构如下：
(https://img-blog.youkuaiyun.com/20180828171128141?watermark/2/text/aHR0cHM6Ly9ibG9nLmNzZG4ubmV0L2NoZW55aF9jc2Ru/font/5a6L5L2T/fontsize/400/fill/I0JBQkFCMA==/dissolve/70)
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/maven-v4_0_0.xsd">
  <modelVersion>4.0.0</modelVersion>
  <groupId>com.springboot</groupId>
  <artifactId>Chenyh</artifactId>
  <packaging>war</packaging>
  <version>0.0.1-SNAPSHOT</version>
  <name>Chenyh Maven Webapp</name>
  <url>http://maven.apache.org</url>
  <properties>
      <springboot.version>2.0.4.RELEASE</springboot.version>
      <jackson.version>2.9.4</jackson.version>
  </properties>
  <parent>
      <groupId>org.springframework.boot</groupId>
      <artifactId>spring-boot-starter-parent</artifactId>
      <version>2.0.4.RELEASE</version>
  </parent>
  <dependencies>
  <!-- mysql -->
    <dependency>
        <groupId>mysql</groupId>
        <artifactId>mysql-connector-java</artifactId>
        <version>5.1.39</version>
    </dependency>
    <!-- mybatis -->
    <dependency>
        <groupId>org.mybatis.spring.boot</groupId>
        <artifactId>mybatis-spring-boot-starter</artifactId>
        <version>1.1.1</version>
    </dependency>
    <dependency>
      <groupId>junit</groupId>
      <artifactId>junit</artifactId>
      <version>3.8.1</version>
      <scope>test</scope>
    </dependency>
    <dependency>
        <groupId>org.springframework.integration</groupId>
        <artifactId>spring-integration-http</artifactId>
    </dependency>
    <dependency>
        <groupId>org.springframework.boot</groupId>
        <artifactId>spring-boot-starter-web</artifactId>
    </dependency>
  </dependencies>
  <build>
    <finalName>Chenyh</finalName>
  </build>
</project>

application.xml文件：

#MySql
spring.datasource.driver-class-name=com.mysql.jdbc.Driver
spring.datasource.url=jdbc:mysql://97.64.122.16:3306/cyh?useUnicode=true&characterEncoding=utf-8&autoReconnect=true
spring.datasource.username=root
spring.datasource.password=123456

#Mybatis
mybatis.mapper-locations = classpath:mapping/*.xml
mybatis.type-aliases-package=com.springboot.bean

mapper文件：

<?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.springboot.mapper.UserMapper">
    <resultMap id="userMap" type="com.springboot.bean.User">
        <id column="id" property="id" jdbcType="INTEGER"/>
        <result column="username" property="username" jdbcType="VARCHAR"/>
        <result column="userage" property="userage" jdbcType="INTEGER"/>
    </resultMap>
     <sql id="User_Column_List" >
        id, username, userage
    </sql>
    <insert id="addUser" parameterType="com.springboot.bean.User" useGeneratedKeys="true" keyProperty="id">
        INSERT INTO user(username, userage) VALUES (#{username},#{userage})
    </insert>

    <select id="findAll" resultMap="userMap">
        select * from user
    </select>

    <delete id="deleteUser" parameterType="int">
        delete from user where id = #{id}
    </delete>
</mapper>

搭建过程中遇到的问题：
1.springboot文件位置：要放在和接口包的同级目录下，我开始随便放的，启动会报错
2.配置文件问题：反正就是框架报错，查了好多文档都解决不了，就从头开始，配置文件尽量简洁，能实现基础功能就行，就是我上面的配置，框架搭好了
3.数据库表字段（主键）自增：建表的时候勾选上