学习笔记——mybatis的sql拼接与log4j调试

来源：互联网发布：电脑屏幕直播软件免费编辑：程序博客网时间：2024/06/07 16:05

接上篇内容：

<?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="Book">    <resultMap type="com.lijie.bean.Book" id="BookResult">        <id column="ID" jdbcType="INTEGER" property="id"/>        <result column="NAME" jdbcType="VARCHAR" property="name"/>    </resultMap>    <select id="queryBookList" parameterType="com.lijie.bean.Book" resultMap="BookResult">        select id,name from book        <where>            <if test="id !=null">                and ID=#{id}            </if>        </where>    </select></mapper>

log4j中properties配置如下
log4j.properties:

log4j.rootLogger=DEBUG,Consolelog4j.appender.Console=org.apache.log4j.ConsoleAppenderlog4j.appender.Console.layout=org.apache.log4j.PatternLayoutlog4j.appender.Console.layout.ConversionPattern=%d [%t] %-5p [%c] - %m%nlog4j.logger.org.apache=INFO

0 0