mybais-plus

官网相关介绍与快速开始demo​

idea 安装跳转xml文件插件：MybatisX

上篇文章有代码自动生成工具类（大概架构与相关数据库表文件）

yml文件相关配置

mybatis-plus:
  mapper-locations: classpath*:mapper/*.xml
  configuration:
    log-impl: org.apache.ibatis.logging.stdout.StdOutImpl # mybatisplus sql日志输出

依赖包导入：

        <dependency>
            <groupId>com.baomidou</groupId>
            <artifactId>mybatis-plus-boot-starter</artifactId>
        </dependency>
        <dependency>
            <groupId>com.baomidou</groupId>
            <artifactId>mybatis-plus-generator</artifactId>
        </dependency>
        <dependency>
            <groupId>org.projectlombok</groupId>
            <artifactId>lombok</artifactId>
        </dependency>
        <!-- 数据库驱动 -->
        <dependency>
            <groupId>mysql</groupId>
            <artifactId>mysql-connector-java</artifactId>
        </dependency>

驱动包没有指定版本，自动引入的版本

启动类：

@SpringBootApplication
@MapperScan("com.formiss.order.mapper")
public class OrderApplication {
    public static void main(String[] args) {
        SpringApplication.run(OrderApplication.class, args);
    }
}

@Service
public class TUserServiceImpl implements TUserService {

    @Autowired
    TUserMapper tUserMapper;

    public List<TUser> selectList(String nickname) {
        QueryWrapper wrapper = new QueryWrapper();
        wrapper.eq("nick_name",nickname);
        return tUserMapper.selectList(wrapper); // 继承BaseMapper 自动查询
    }

    /**
     * 自定义xml文件中的sql语句
     */
    public List<TUser> findUserByPwd(String pwd) {
        return tUserMapper.findUserByPwd(pwd);
    }
}

/**
 * <p>
 *  Mapper 接口
 * </p>
 *
 * @author SJW
 * @since 2022-07-28
 */
@Mapper
public interface TUserMapper extends BaseMapper<TUser> {

    List<TUser> findUserByPwd(String pwd);
}

TUserMapper.xml： 

<?xml version="1.0" encoding="UTF-8"?>
<!DOCTYPE mapper PUBLIC "-//mybatis.org//DTD Mapper 3.0//EN" "http://mybatis.org/dtd/mybatis-3-mapper.dtd">
<mapper namespace="com.formssi.order.mapper.TUserMapper">

    <resultMap id="UserInfoMap" type="com.formssi.order.entity.TUser"><!--可用于两张或多张表查询的结果集-->
        <result column="id" property="id"/>
        <result column="nick_name" property="nickName"/>
        <result column="pass_word" property="passWord"/>
        <result column="sex" property="sex"/>
        <result column="birthday" property="birthday"/>
    </resultMap>
    <select id="findByPwd" resultMap="UserInfoMap">
        select * from t_user u
        where u.pass_word = #{pwd}
    </select>

    <select id="findUserByPwd" resultType="com.formssi.order.entity.TUser">
        select * from t_user u
        where u.pass_word = #{pwd}
    </select>
</mapper>