Spring MyBatis XML文件头 log4j.properties

一时失言乱红尘 2022-05-10 09:12 118阅读 0赞

## Spring ##

<?xml version="1.0" encoding="UTF-8"?> 
    <beans xmlns="http://www.springframework.org/schema/beans"
        xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance"
        xsi:schemaLocation="http://www.springframework.org/schema/beans
            http://www.springframework.org/schema/beans/spring-beans.xsd">               
            <bean >
            </bean>
    </beans>

## 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">
    <configuration>
    	<settings>
    		<setting  name="logImpl" value="LOG4J"/>
    	</settings>
    	<typeAliases>
    		<package name="com.bjsxt.pojo"/>
    	</typeAliases>
    	<environments default="default">
    		<environment id="default">
    			<transactionManager type="JDBC"></transactionManager>
    			<dataSource type="POOLED">
    				<property name="driver" value="com.mysql.jdbc.Driver"/>
    				<property name="url" value="jdbc:mysql://localhost:3306/ssm"/>
    				<property name="username" value="root"/>
    				<property name="password" value="123456"/>
    			</dataSource>
    		</environment>			
    	</environments>	
    	<mappers>
    		<mapper class="com.lee.mapper.TeacherMapper"/>	
    		<mapper class="com.lee.mapper.StudentMapper"/>			
    	</mappers>
    </configuration>

mapper.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.lee.mapper.TeacherMapper">
    	
    	<select id="selById" resultType="Teacher" parameterType="int">
    		select * from teacher where id=#{0}
    	</select>		
    
    </mapper>

## log4j ##

# Set root category priority to INFO and its only appender to CONSOLE.
    #log4j.rootCategory=DEBUG, CONSOLE
    log4j.rootCategory=	ERROR, CONSOLE
    log4j.logger.com.bjsxt.mapper.TeacherMapper=DEBUG
    # Set the enterprise logger category to FATAL and its only appender to CONSOLE.
    #log4j.logger.org.apache.axis.enterprise=FATAL, CONSOLE
    
    # CONSOLE is set to be a ConsoleAppender using a PatternLayout.
    log4j.appender.CONSOLE=org.apache.log4j.ConsoleAppender
    #log4j.appender.CONSOLE.Threshold=DEBUG
    log4j.appender.CONSOLE.layout=org.apache.log4j.PatternLayout
    log4j.appender.CONSOLE.layout.ConversionPattern=%p %d{YYYY-MM-dd hh:mm:ss} 第%L行 %m %n
    
    # LOGFILE is set to be a File appender using a PatternLayout.
    log4j.appender.LOGFILE=org.apache.log4j.FileAppender
    log4j.appender.LOGFILE.File=axis.log
    log4j.appender.LOGFILE.Append=true
    log4j.appender.LOGFILE.Threshold=INFO
    log4j.appender.LOGFILE.layout=org.apache.log4j.PatternLayout
    log4j.appender.LOGFILE.layout.ConversionPattern=%-4r [%t] %-5p %c %x - %m%n