Mybatis - 注解版

配置数据库连接

spring:
  profiles: dev
  datasource:
    url: jdbc:mysql://localhost:3306/test_1?useUnicode=true&characterEncoding=utf-8&useSSL=true&serverTimezone=UTC
    username: root
    password: 123456
    type: com.alibaba.druid.pool.DruidDataSource
    driver-class-name: com.mysql.cj.jdbc.Driver
    initialSize: 5
    minIdle: 5
    maxActive: 20
    maxWait: 60000
    timeBetweenEvictionRunsMillis: 60000
    minEvictableIdleTimeMillis: 300000
    validaionQuery: SELECT 1 FROM DUAL
    testWhileIdle: true
    testOnBorrow: false
    testOnReturn: false
    poolPreparedStatements: true

配置mapper类

// 使用 @Mapper 标注这个类
@Mapper
public interface MoneyMapper {
    @Insert("insert into money(id, money) values (#{userId}, #{money})")
    int createMoney(Money money);

    @Update("update money set money = #{money} where id = #{userId}")
    int updateMoney(Money money);

    @Select("select is_pitch, ratio from money_account where id = #{id}")
    MoneyAccount getMine(Integer id);

    @Delete("delete from money where id = #{id}")
    int deleteMoney(Integer id);

}

在启动类配置扫描mapper路径

@SpringBootApplication
@MapperScan(value = "com.example.demo.*.mapper")
public class GameApplication {
    public static void main(String[] args) {
        SpringApplication.run(DemoApplication.class, args);
    }
}

在这里注入后就可以直接调用

@Service
@Transactional
public class MoneyImpl implements MoneyService {

    @Autowired
    private MoneyMapper moneyMapper;

    public MoneyImpl(MoneyMapper moneyMapper) {
        this.moneyMapper = moneyMapper;
    }

    @Override
    public void inMoney(Money money) {
        moneyMapper.updateMoney(money);
    }

    @Override
    public void outMoney(Money money) {
        moneyMapper.updateMoney(money);
    }

}