1、引入maven依赖
<dependency>
<groupId>mysql</groupId>
<artifactId>mysql-connector-java</artifactId>
<!-- 修改jdbc版本 -->
<version>${mysql.driver.version}</version>
<scope>runtime</scope>
</dependency>
<!-- 引入druid连接池 -->
<dependency>
<groupId>com.alibaba</groupId>
<artifactId>druid</artifactId>
<version>1.1.12</version>
</dependency>
<!-- 引入MybatisPlus的启动器 -->
<dependency>
<groupId>com.baomidou</groupId>
<artifactId>mybatis-plus-boot-starter</artifactId>
<version>3.4.0</version>
</dependency>
<dependency>
<groupId>org.mybatis.spring.boot</groupId>
<artifactId>mybatis-spring-boot-starter</artifactId>
<version>2.0.1</version>
</dependency>
2、写service model文件
public interface PayOrderService {
int insertSelective(TPayOrder payOrder);
}
@Service
public class PayOrderServiceImpl extends ServiceImpl<PayOrderMapper, TPayOrder> implements PayOrderService {
@Autowired
private PayOrderMapper payOrderMapper;
@Override
public int insertSelective(TPayOrder payOrder) {
return payOrderMapper.insert(payOrder);
}
}
@Mapper
public interface PayOrderMapper extends BaseMapper<TPayOrder> {
int updateByPrimaryKey(TPayOrder record);
}
3、用插件自动生成xml
4、配置连接池
#数据库参数
spring.datasource.driver-class-name=com.mysql.jdbc.Driver
spring.datasource.url=jdbc:mysql://ip/数据库?useUnicode=true&characterEncoding=utf8&autoReconnect=true&allowMultiQueries=true
spring.datasource.username = 用户名
spring.datasource.password = 密码
# 指定连接池的类型
spring.datasource.type=com.alibaba.druid.pool.DruidDataSource
# 显示SQL语句
mybatis-plus.configuration.log-impl=org.apache.ibatis.logging.stdout.StdOutImpl
mybatis-plus.configuration.map-underscore-to-camel-case = true
mybatis-plus.mapper-locations = classpath*:mapper/*.xml 扫描xml文件
mybatis-plus.type-aliases-package = dao文件路径
mybatis.configuration.call-setters-on-nulls = true
mybatis-plus.global-config.db-config.logic-delete-field = flag
mybatis-plus.global-config.db-config.logic-delete-value = 1
mybatis-plus.global-config.db-config.logic-not-delete-value = 0
mybatis-plus.global-config.db-config.id-type = assign_uuid
5、springboot启动类配置扫描路径
@MapperScan(value = "dao路径")
遇到问题:从网上获取依赖包时出错,后面改成从私服获取可以
注意:要配置mysql连接池,mybatis扫描