mybatis——懒加载、添加log4j（六）

添加log4j

编写log4j.properties 文件

log4j.rootLogger=debug, Console  
log4j.logger.com.wocus.wine.dao=debug  
#Console
log4j.appender.Console=org.apache.log4j.ConsoleAppender  
log4j.appender.Console.layout=org.apache.log4j.PatternLayout  
log4j.appender.Console.layout.ConversionPattern=%d [%t] %-5p [%c] - %m%n 

开启log4j加载

<!--指定开启log4日志-->
<settings>
    <setting name="logImpl" value="LOG4J"/>
</settings>

懒加载

<settings>
    <!--指定开启log4日志-->
    <setting name="logImpl" value="LOG4J"/>
    <!--开启懒加载-->
    <setting name="lazyLoadingEnabled" value="true" />
    <!--关闭立即加载-->
    <setting name="aggressiveLazyLoading" value="false"/>
</settings>

classMapper:

<!--懒加载-->
<select id="queryStudentByIDLazyOnload" resultMap="lazyMap" >
    select c.* from class c
</select>
<resultMap id="lazyMap" type="Class">
     <id property="class_id" column="class_id" />
     <result property="class_name" column="class_name" />
    <!--通过column外键 来关联两个表的查询 select 是对方的方法路径-->
    <collection property="studentList" ofType="Student" select="com.xiaonuo.Interface.StudentMapper.queryStudentByClassIdLazyLoad" column="class_id">
    </collection>
</resultMap>

studentMapper:

<!--一对多懒加载-->
<select id="queryStudentByClassIdLazyLoad" resultType="Student" parameterType="int">
    select s.* from student s where class_id = #{class_id}
</select>