mybatis使用log4j

最新推荐文章于 2024-07-26 21:37:59 发布

起飞的蛤蟆

最新推荐文章于 2024-07-26 21:37:59 发布

阅读量130

点赞数

分类专栏： mybatis学习

本文链接：https://blog.csdn.net/zhaojialu888/article/details/105339601

版权

mybatis学习专栏收录该内容

15 篇文章 0 订阅

订阅专栏

代码

testMybatis.java

package com.mybatis;

import java.io.IOException;
import java.io.InputStream;
import java.util.List;
import org.apache.ibatis.io.Resources;
import org.apache.ibatis.session.SqlSession;
import org.apache.ibatis.session.SqlSessionFactory;
import org.apache.ibatis.session.SqlSessionFactoryBuilder;

import com.mybatis.mapper.OrderMapper;
import com.mybatis.pojo.*;

public class testMybatis {
	public static void main(String[] args) throws IOException {
        String resource = "mybatis-config.xml"; //获取全局配置信息
        InputStream inputStream = Resources.getResourceAsStream(resource); //全局配置信息装入输入流
        SqlSessionFactory sqlSessionFactory = new SqlSessionFactoryBuilder().build(inputStream); //建立sql会话工厂，将输入流装入
        SqlSession session=sqlSessionFactory.openSession(); //开启一个会话
        
        //CategoryMapper categorymapper=session.getMapper(CategoryMapper.class);
        OrderMapper ordermapper=session.getMapper(OrderMapper.class);
        
        listAll(ordermapper);
     
              
        session.commit();  //更新到数据库
        session.close();  
    }
	
	private static void listAll(OrderMapper mapper) {
		List<Order> os=mapper.listOrder();
		for(Order o:os) {
			System.out.println(o.getCode());
			List<OrderItem> ois=o.getOrderitems();
			if(null!=ois) {
				for(OrderItem oi:ois) {
					System.out.format("\t%s\t%f\t%d%n", oi.getProduct().getName(),oi.getProduct().getPrice(),oi.getNumber());
				}
			}
		}
		
	}

	 
		
}

log4j.properties

# Global logging configuration
log4j.rootLogger=ERROR, stdout

# MyBatis logging configuration...
log4j.logger.com.mybatis=TRACE

# Console output...
log4j.appender.stdout=org.apache.log4j.ConsoleAppender
log4j.appender.stdout.layout=org.apache.log4j.PatternLayout
log4j.appender.stdout.layout.ConversionPattern=%5p [%t] - %m%n