SSM11.3【Mybatis：Mybatis核心配置文件概述】

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

<?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">

<!--The content of element type "configuration" must match
"(properties?,settings?,typeAliases?,typeHandlers?,objectFactory?,
objectWrapperFactory?,reflectorFactory?,plugins?,environments?,databaseIdProvider?,mappers?)".-->

<configuration>

    <!--加载外部properties文件-->
    <properties resource="jdbc.properties"></properties>

    <!--自定义别名(必须放在settings配置之后，typeHandlers配置之前，不然xml报错)-->
    <typeAliases>
        <typeAlias type="com.haifei.domain.User" alias="user" />
    </typeAliases>


    <environments default="development">  <!--environments下可以定义多个environment，default值为所指定的默认environment的id-->
        <!--配置数据源环境-->
        <environment id="development"> <!--id值自定义-->
            <transactionManager type="JDBC"></transactionManager> <!--指定事务管理器为JDBC类型-->
            <dataSource type="POOLED">  <!--指定数据源类型POOLED池-->
                <property name="driver" value="${jdbc.driver}"/>
                <property name="url" value="${jdbc.url}"/>
                <property name="username" value="${jdbc.username}"/>
                <property name="password" value="${jdbc.password}"/>
            </dataSource>
        </environment>
    </environments>

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

</configuration>

<?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="userMapper">

    <!--查询操作-->
    <!--<select id="findAll" resultType="com.haifei.domain.User">-->
    <select id="findAll" resultType="user">  /*在sqlMapConfig.xml中配置自定义别名*/
        select * from user
    </select>
    
    <!--插入操作-->
    <!--<insert id="save" parameterType="com.haifei.domain.User">-->
    <insert id="save" parameterType="user">
        insert into user values(#{id},#{username},#{password})
    </insert>

    <!--修改操作-->
    <!--<update id="update" parameterType="com.haifei.domain.User">-->
    <update id="update" parameterType="user">
        update user set username=#{username},password=#{password} where id=#{id}
    </update>

    <!--删除操作-->
    <!--<delete id="del" parameterType="java.lang.Integer">-->
    <delete id="del" parameterType="int">  /*int是java.lang.Integer的别名，mybatis默认设置好了*/
        delete from user where id=#{id} /*这个输入变量写啥都行，习惯上也跟属性名一致*/
    </delete>

</mapper>