mybatis基本增删改查、缓存，延迟加载以及别名的配置

青旅半醒 2022-06-11 02:11 97阅读 0赞

## **1. mybatis.xml/SqlMapConfig.xml 配置** ##

**jdbc.properties**

#mysql connection
    jdbc_driver=com.mysql.jdbc.Driver
    jdbc_url=jdbc:mysql://localhost:3306/mybatistest
    jdbc_user=root
    jdbc_password=123

**mybatis.xml/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>
            
            
    
            
            <package name="com.java.dao.pojo"/>
    
            
            <setting name="lazyLoadingEnabled" value="true" />
            
            <setting name="aggressiveLazyLoading" value="false" />
    
            
            <setting name="cacheEnabled" value="true"/>
        </typeAliases>
        
        <environments default="development">
            <environment id="development">
                <transactionManager type="JDBC" />
                <dataSource type="POOLED">
                    <property name="driver" value="${jdbc_driver}" />
                    <property name="url" value="${jdbc_url}" />
                    <property name="username" value="${jdbc_user}" />
                    <property name="password" value="${jdbc_password}" />
                </dataSource>
            </environment>
        </environments>
    
    <mappers>
        <mapper resource="com/java/dao/pojo/StudentMapper.xml"/>
    </mappers>
    </configuration>

## **2.基本增删改的mapper.xml配置** ##

**StudentMapper.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.java.dao.idao.IPlayerDao"> 
        
        <cache></cache>
    
        
        <select id="findById" parameterType="String" 
            resultType="com.java.dao.pojo.Student">
            select * from student where id=#{id}
        </select>
        <select id="findAll" resultType="com.java.dao.pojo.Student">
            select id,name,age from student;
        </select>
    
        
        <insert id="insert">
            insert into student(id,name,age) values(#{id},#{name},#{age});
        </insert>
        <delete id="delete" parameterType="String">
            delete from student where id=#{id}
        </delete>
        <update id="update" parameterType="com.java.dao.pojo.Student">
            update student set name=#{name},age=#{age} where id=#{id};
        </update>
    
    
    </mapper>