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
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(@Param("id") Integer id);

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

在/resources/mapper下 创建 money.xml

<!DOCTYPE mapper
        PUBLIC "-//mybatis.org//DTD Mapper 3.0//EN"
        "http://mybatis.org/dtd/mybatis-3-mapper.dtd">
<!-- namespce : 指到刚才创建的Mapper类上-->
<mapper namespace="com.example.demo.game.mapper.MoneyMapper">
    <insert id="createMoney" parameterType="com.example.demo.game.bean.Money">
        insert into money(id, money) values (#{userId}, #{money}
    </insert>
    <update id="updateMoney" parameterType="com.example.demo.game.bean.Money" >
        update money set money = #{money} where id = #{userId}
    </update>
    <select id="getMine" resultType="com.example.demo.game.bean.MoneyAccount" parameterType="java.lang.Integer">
        select is_pitch, ratio from money_account where id = #{id}
    </select>
    <delete id="deleteMoney" parameterType="java.lang.Integer">
        delete from money where id = #{id}
    </delete>
</mapper>

配置xml 扫描

mybatis:
# 配置 xml 扫描
  mapper-locations: classpath:mapper/*.xml
# 配置 xml 使用的 实体bean 的扫描
  type-aliases-package: com.example.demo.game.bean
# 实现驼峰
  configuration:
    map-underscore-to-camel-case: true

这样配置版也可以完美运行

不过你也可以是用代码生成工具来生成这些东西

点击下方从百度云即可获取

链接: https://pan.baidu.com/s/12fSicymBbuXdNIyAwXmyYw 提取码: hqny