28.mybatis核心配置文件

最新推荐文章于 2023-09-15 10:31:00 发布

苏七qaq

最新推荐文章于 2023-09-15 10:31:00 发布

阅读量1.3k

点赞数

分类专栏： spring 文章标签： 1024程序员节

本文链接：https://blog.csdn.net/weixin_45974277/article/details/120931360

版权

spring 专栏收录该内容

38 篇文章 0 订阅

订阅专栏

这篇博客介绍了MyBatis的配置文件，包括数据源设置、事务管理及Mapper映射文件的加载。同时展示了UserMapper.xml中对用户数据的CRUD操作，包括查询、插入、更新和删除的XML标签使用方法。

摘要由CSDN通过智能技术生成

<?xml version="1.0" encoding="UTF-8"?>
<!DOCTYPE configuration PUBLIC "-//mybatis.org//DTD Config 3.0//EN" "http://mybatis.org/dtd/mybatis-3-config.dtd">

<configuration>

    <properties resource="jdbc.properties"></properties>

    <!--数据源环境-->
    <environments default="development">
        <environment id="development">
            <transactionManager type="JDBC"></transactionManager>
            <dataSource type="POOLED">
                <property name="driver" value="${jdbc.driver}"></property>
                <property name="url" value="${jdbc.url}"></property>
                <property name="username" value="${jdbc.username}"></property>
                <property name="password" value="${jdbc.password}"></property>
            </dataSource>
        </environment>
    </environments>

    <!--加载映射文件-->
    <mappers>
        <mapper resource="UserMapper.xml"></mapper>
    </mappers>
</configuration>

sqlMapConfig.xml:

<?xml version="1.0" encoding="UTF-8"?>
<!DOCTYPE configuration PUBLIC "-//mybatis.org//DTD Config 3.0//EN" "http://mybatis.org/dtd/mybatis-3-config.dtd">

<configuration>

    <properties resource="jdbc.properties"></properties>

    <!--自定义别名-->
    <typeAliases>
        <typeAlias type="entity.User" alias="user"></typeAlias>
    </typeAliases>

    <!--数据源环境-->
    <environments default="development">
        <environment id="development">
            <transactionManager type="JDBC"></transactionManager>
            <dataSource type="POOLED">
                <property name="driver" value="${jdbc.driver}"></property>
                <property name="url" value="${jdbc.url}"></property>
                <property name="username" value="${jdbc.username}"></property>
                <property name="password" value="${jdbc.password}"></property>
            </dataSource>
        </environment>
    </environments>

    <!--加载映射文件-->
    <mappers>
        <mapper resource="UserMapper.xml"></mapper>
    </mappers>

</configuration>

UserMapper.xml:

<?xml version="1.0" encoding="UTF-8"?>
<!DOCTYPE mapper PUBLIC "-//mybatis.org//DTD Config 3.0//EN" "http://mybatis.org/dtd/mybatis-3-mapper.dtd">



<mapper namespace="userMapper">
    <!--查询-->
    <select id="findAll" resultType="user">
        select * from user
    </select>

    <!--插入操作-->
    <insert id="insert" parameterType="user">/*传递过来的参数类型*/
        insert into user values(#{username},#{password},#{id})/*参数对应的成员变量*/
    </insert>

    <!--修改数据-->
    <update id="update" parameterType="user">
        update user set username=#{username},password=#{password} where id=#{id}
    </update>

    <!--删除数据-->
    <delete id="delete" parameterType="int">
        delete from user where id=#{id}
    </delete>
</mapper>