Mybatis基本配置、日志文件(sql语句)打印

梦里梦外; 2024-02-18 16:24 60阅读 0赞

简单的增删查改：

config.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>
        <settings>    
            <setting name="logImpl" value="LOG4J" />      
        </settings>    
      <environments default="development">
        <environment id="development">
          <transactionManager type="JDBC"/>
          <dataSource type="POOLED">
            <property name="driver" value="com.mysql.jdbc.Driver"/>
            <property name="url" value="jdbc:mysql://127.0.0.1:3306/my1"/>
            <property name="username" value="root"/>
            <property name="password" value="root"/>
          </dataSource>
        </environment>
      </environments>
      <mappers>
        <mapper resource="com/dw/entity/userMapper.xml"/>
      </mappers>
      
    </configuration>

sql映射文件 userMapper.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.dw.entity.UserMapper">
      <select id="selectById" resultType="com.dw.entity.User" >
        select * from user where id = #{id}
      </select>
      
      <insert id="insertUser" parameterType="com.dw.entity.User">
         insert into user(username,password) values(#{username},#{password}); 
      </insert>
      
      <update id="updateUser" parameterType="com.dw.entity.User">
         update user u set u.username=#{username},u.password=#{password} where u.id=#{id}
      </update>
      
      <delete id="deleteUser" parameterType="com.dw.entity.User">
         delete from User where id=#{id} 
      </delete>
    </mapper>

测试：

@Test
      public void testInsert(){
    	  InputStream inputStream;
    	  SqlSessionFactory sqlSessionFactory;
    	try {
    		inputStream = Resources.getResourceAsStream("config.xml");
    		  sqlSessionFactory =  new SqlSessionFactoryBuilder().build(inputStream);	
    		  
    		  SqlSession session = sqlSessionFactory.openSession();
    		  User user = new User();
    		  user.setUsername("张翔");
    		  user.setPassword("123456");
              int count = session.insert("com.dw.entity.UserMapper.insertUser", user);
              System.out.println("count:"+count);
              session.commit();
    	} catch (IOException e) {
    		e.printStackTrace();
    	}
      }

如果需要在控制台打印日志文件或者sql语句：  
1、导入log4j.jar包（单独使用mybatis时只需这一个jar包即可）

2、配置log4j.xml或者log4j.properties文件：

log4j.rootLogger=INFO,Console
     
    log4j.appender.Console=org.apache.log4j.ConsoleAppender
    log4j.appender.Console.Target=System.out
    log4j.appender.Console.Threshold=DEBUG
    log4j.appender.Console.layout=org.apache.log4j.PatternLayout
    log4j.appender.Console.layout.ConversionPattern=[%d]%l%5p:%m%n
     
    log4j.appender.DebugFile=org.apache.log4j.RollingFileAppender
    log4j.appender.DebugFile.File=../log/debugFile.log
    #log4j.appender.DebugFile.File=debugFile.log
    log4j.appender.DebugFile.Append=true
    log4j.appender.DebugFile.Threshold=DEBUG
    log4j.appender.DebugFile.layout=org.apache.log4j.PatternLayout
    log4j.appender.DebugFile.layout.ConversionPattern=[%d]%l%5p:%m%n
    log4j.appender.DebugFile.MaxFileSize=20MB
    log4j.appender.DebugFile.MaxBackupIndex=10
     
    log4j.logger.com.ibatis=DEBUG
    log4j.logger.com.ibatis.common.jdbc.SimpleDataSource=DEBUG
    log4j.logger.com.ibatis.common.jdbc.ScriptRunner=DEBUG
    log4j.logger.com.ibatis.sqlmap.engine.impl.SqlMapClientDelegate=DEBUG
     
    log4j.logger.java.sql=DEBUG
    log4j.logger.java.sql.Connection = INFO
    log4j.logger.java.sql.Statement = DEBUG
    log4j.logger.java.sql.PreparedStatement = DEBUG
    log4j.logger.java.sql.ResultSet = DEBUG
     
    log4j.logger.com.dw=DEBUG