Mybatis用Spring的Bean管理对象-----Mybatis框架

布满荆棘的人生 2024-03-24 20:24 35阅读 0赞

>     package com.powernode.mybatis.test;
>     
>     import com.powernode.mybatis.Spring6Config;
>     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 org.junit.Test;
>     import org.slf4j.Logger;
>     import org.slf4j.LoggerFactory;
>     import org.springframework.context.annotation.AnnotationConfigApplicationContext;
>     
>     public class CarMapperTest
>     {
>         private static final Logger logger = LoggerFactory.getLogger(CarMapperTest.class);
>         @Test
>         public void TestInsertCar()
>         {
>             SqlSession sqlSession = null;
>             //编写mybatis程序
>             try
>             {
>                 AnnotationConfigApplicationContext context = new AnnotationConfigApplicationContext(Spring6Config.class);
>                 SqlSessionFactoryBuilder sqlSessionFactoryBuilder = context.getBean("sqlSessionFactoryBuilder", SqlSessionFactoryBuilder.class);
>                 SqlSessionFactory build = sqlSessionFactoryBuilder.build(Resources.getResourceAsStream("mybatis-config.xml"));
>                 sqlSession = build.openSession();
>                 int insertCar = sqlSession.insert("insertCar");
>                 logger.info("" + insertCar);
>                 sqlSession.commit();
>             }
>             catch (Exception e)
>             {
>                 if (sqlSession != null)
>                 {
>                     sqlSession.rollback();
>                 }
>                 e.printStackTrace();
>             }
>             finally
>             {
>                 if (sqlSession != null)
>                 {
>                     sqlSession.close();
>                 }
>             }
>         }
>     }
> 
> package com.powernode.mybatis.test;  
>   
> import com.powernode.mybatis.Spring6Config;  
> 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 org.junit.Test;  
> import org.slf4j.Logger;  
> import org.slf4j.LoggerFactory;  
> import org.springframework.context.annotation.AnnotationConfigApplicationContext;  
>   
> public class CarMapperTest  
> \{  
> private static final Logger logger = LoggerFactory.getLogger(CarMapperTest.class);  
> @Test  
> public void TestInsertCar()  
> \{  
> SqlSession sqlSession = null;  
> //编写mybatis程序  
> try  
> \{  
> AnnotationConfigApplicationContext context = new AnnotationConfigApplicationContext(Spring6Config.class);  
> SqlSessionFactoryBuilder sqlSessionFactoryBuilder = context.getBean("sqlSessionFactoryBuilder", SqlSessionFactoryBuilder.class);  
> SqlSessionFactory build = sqlSessionFactoryBuilder.build(Resources.getResourceAsStream("mybatis-config.xml"));  
> sqlSession = build.openSession();  
> int insertCar = sqlSession.insert("insertCar");  
> logger.info("" + insertCar);  
> sqlSession.commit();  
> \}  
> catch (Exception e)  
> \{  
> if (sqlSession != null)  
> \{  
> sqlSession.rollback();  
> \}  
> e.printStackTrace();  
> \}  
> finally  
> \{  
> if (sqlSession != null)  
> \{  
> sqlSession.close();  
> \}  
> \}  
> \}  
> \}

>     package com.powernode.mybatis;
>     
>     import org.apache.ibatis.session.SqlSessionFactoryBuilder;
>     import org.springframework.context.annotation.Bean;
>     import org.springframework.context.annotation.ComponentScan;
>     import org.springframework.context.annotation.Configuration;
>     
>     @Configuration
>     @ComponentScan
>     public class Spring6Config
>     {
>         @Bean(name = "sqlSessionFactoryBuilder")
>         public SqlSessionFactoryBuilder getSqlSessionFactoryBuilder()
>         {
>             SqlSessionFactoryBuilder sqlSessionFactoryBuilder = new SqlSessionFactoryBuilder();
>             return sqlSessionFactoryBuilder;
>         }
>     }
> 
> package com.powernode.mybatis;  
>   
> import org.apache.ibatis.session.SqlSessionFactoryBuilder;  
> import org.springframework.context.annotation.Bean;  
> import org.springframework.context.annotation.ComponentScan;  
> import org.springframework.context.annotation.Configuration;  
>   
> @Configuration  
> @ComponentScan  
> public class Spring6Config  
> \{  
> @Bean(name = "sqlSessionFactoryBuilder")  
> public SqlSessionFactoryBuilder getSqlSessionFactoryBuilder()  
> \{  
> SqlSessionFactoryBuilder sqlSessionFactoryBuilder = new SqlSessionFactoryBuilder();  
> return sqlSessionFactoryBuilder;  
> \}  
> \}