搭建SpringBoot+Mybaties0配置

依赖：

<dependency>
        <groupId>org.mybatis</groupId>
        <artifactId>mybatis-spring</artifactId>
        <version>1.3.2</version>
</dependency>
<dependency>
       <groupId>org.springframework.boot</groupId>
       <artifactId>spring-boot-starter-jdbc</artifactId>
       <version>2.1.2.RELEASE</version>
</dependency>

        <!-- https://mvnrepository.com/artifact/org.mybatis.spring.boot/mybatis-spring-boot-starter -->
        <dependency>
            <groupId>org.mybatis.spring.boot</groupId>
            <artifactId>mybatis-spring-boot-starter</artifactId>
            <version>1.3.2</version>
        </dependency>

        <!-- https://mvnrepository.com/artifact/mysql/mysql-connector-java -->
        <dependency>
            <groupId>mysql</groupId>
            <artifactId>mysql-connector-java</artifactId>
            <version>8.0.15</version>
        </dependency>

这里需要注意的是
对应的数据库版本一定要和依赖对应上
比如

image

和

image
两个的版本要对应上

然后在配置类中

@Configuration
@MapperScan("com.***.****.dao")
public class MyWebMVCConfig implements WebMvcConfigurer {

    @Bean("dataSource")
    public DataSource dataSource(){
        DriverManagerDataSource driverManagerDataSource = new DriverManagerDataSource();
        driverManagerDataSource.setDriverClassName("com.mysql.jdbc.Driver");
        driverManagerDataSource.setUrl("jdbc:mysql://IP地址:3306/数据库名字?useSSL=false&serverTimezone=Asia/Shanghai");
        driverManagerDataSource.setUsername("root");
        driverManagerDataSource.setPassword("密码");
        return driverManagerDataSource;
    }

    @Bean("sqlSessionFactory")
    public SqlSessionFactory sqlSessionFactoryBean() throws Exception {

        SqlSessionFactoryBean sqlSessionFactoryBean = new SqlSessionFactoryBean();
        sqlSessionFactoryBean.setDataSource(dataSource());

        PathMatchingResourcePatternResolver resolver = new PathMatchingResourcePatternResolver();
        return sqlSessionFactoryBean.getObject();
    }

}

创建Mapper

这里创建的类名规范应该是Lxy_visitMapper，应该注意。

@Mapper
public interface Lxy_visitDao {

    @Insert("INSERT INTO lxy_visit VALUES(#{id},#{ipAddress},#{visTime},#{orders},#{address},#{content_address}," +
            "#{city},#{city_code},#{district},#{province},#{province_code},#{street},#{street_number},#{point_x},#{point_y})")
    @SelectKey(keyProperty = "id", resultType = String.class, before = true,
            statement = "select replace(uuid(), '-', '') as id from dual")
    int saveLxy_visit(Lxy_visit lxy_visit);

    @Select("SELECT orders FROM lxy_visit ORDER BY orders DESC LIMIT 1")
    Integer getLxy_visitOrders();

}

然后就完成了！