MybatisPlus，springboot之整合mybatis

第一次搞，真的是花了老大的經歷了，各種字段敲錯了。

記錄一下過程：

首先添加依賴：

		<dependency><groupId>org.mybatis.spring.boot</groupId><artifactId>mybatis-spring-boot-starter</artifactId><version>2.1.1</version></dependency><dependency><groupId>mysql</groupId><artifactId>mysql-connector-java</artifactId><version>5.1.26</version><scope>compile</scope></dependency><dependency><groupId>org.projectlombok</groupId><artifactId>lombok</artifactId><version>1.16.22</version></dependency><dependency><groupId>com.alibaba</groupId><artifactId>druid-spring-boot-starter</artifactId><version>${druid.version}</version></dependency>

MybatisPlus？添加數據庫的連接屬性：

spring:datasource:type: com.alibaba.druid.pool.DruidDataSourcedriverClassName: com.mysql.jdbc.Driverurl: jdbc:mysql://127.0.0.1:3306/test?characterEncoding=utf-8&autoReconnect=true&failOverReadOnly=false&useSSL=trueusername: rootpassword: sa

然后新建一個類與具體的表對應

@Data
public class user {long id;String name;int age;}

再新建一個mapper的接口

@Mapper
@Repository
public interface usermapper {List<user> queryUserList();
}

再定義一個xml，寫sql語句

<?xml version="1.0" encoding="UTF-8" ?>
<!DOCTYPE mapperPUBLIC "-//mybatis.org//DTD Mapper 3.0//EN""http://mybatis.org/dtd/mybatis-3-mapper.dtd">
<mapper namespace="com.my.mapper.usermapper"><select id="queryUserList" resultType = "user" >SELECT  * FROM  USER</select>
</mapper>

springmvc原理，?再添加配置文件，第一個是掃描的xml 的路徑，第二個是實例類的路徑。

mybatis:mapper-locations: classpath:mapper/*.xmltype-aliases-package: com.my.entity

最后寫一個api進行調用

@RestController
public class usercontroller {@Autowiredusermapper  usermapper;@Value("${spring.datasource.url}")String Url;@GetMapping("/query")public List<user> query(){try{return usermapper.queryUserList();}catch (Exception ex){System.out.println(ex.getMessage());}return  null;}
}

測試結果如下：過程簡單，但是結果出來好難。

Mybatis。?***************************20201013************************

增加一個插入數據庫的例子

    <insert  id="saveEngComponentInfo" parameterType="com.example.demo.dto.EngComponentInfoDto">insert into eng_componentinfo (code,name,type,level,parentCode,lng,lat,axisX,axisY,axisZ)values (#{code},#{name},#{type},#{level},#{parentCode},#{lng},#{lat},#{axisX},#{axisY},#{axisZ})</insert >

mapper文件這么寫：

package com.example.demo.mapper;import com.example.demo.dto.EngComponentInfoDto;
import org.apache.ibatis.annotations.Mapper;import java.util.List;
import java.util.Map;@Mapper
public interface TreeShowMapper {List<EngComponentInfoDto> selectListByNode(Map<String, Object> params);void saveEngComponentInfo(EngComponentInfoDto engComponentInfoDto);
}

?