SpringBoot - Mybatis创建_sprint boot mybatis 创建-优快云博客

本文链接：https://blog.youkuaiyun.com/weixin_49859373/article/details/122959898

本文详细介绍了如何在Spring Boot应用中配置数据源，包括连接MySQL数据库的URL、用户名和密码。同时，展示了MyBatis的XML映射文件，包括UserMapper接口的定义、ResultMap的配置以及插入和查询操作的SQL语句。通过这些配置，开发者可以实现对用户数据的增删查改操作。

摘要生成于 C知道，由 DeepSeek-R1 满血版支持，前往体验 >

启动器配置

spring.datasource.url=jdbc:mysql://localhost:3306/store?useUnicode=true&characterEncoding=utf-8&serverTimezone=Asia/Shanghai
spring.datasource.username=root
spring.datasource.password=123456
mybatis.mapper-locations=classpath:mapper/*.xml

Mapper.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.lc.shangcheng.mapper.UserMapper">

    <!-- 映射字段 由于java与mysql命名规范问题  主键必须在   -->
    <resultMap id="UserEntityMap" type="com.lc.shangcheng.entity.User">
        <id column="uid" property="uid"/>
        <result column="is_delete" property="isDelete"/>
        <result column="created_user" property="createdUser"/>
        <result column="created_time" property="createdTime"/>
        <result column="modified_user" property="modifiedUser"/>
        <result column="modified_time" property="modifiedTime"/>
    </resultMap>


    <insert id="insert" useGeneratedKeys="true" keyProperty="uid">
        INSERT INTO
            t_user (username, password, salt, phone, email, gender, avatar, is_delete, created_user, created_time, modified_user, modified_time)
        VALUES
        (#{username}, #{password}, #{salt}, #{phone}, #{email}, #{gender}, #{avatar}, #{isDelete}, #{createdUser}, #{createdTime}, #{modifiedUser}, #{modifiedTime})
    </insert>


    <select id="findByUsername" resultMap="UserEntityMap">
        SELECT
            *
        FROM
            t_user
        WHERE
            username = #{username}
    </select>
    

</mapper>