org.apache.ibatis.session.SqlSessionFactory#openSession

Source File: MultipleCrossIncludeTest.java From mybatis with Apache License 2.0

6 votes

private void testCrossReference(SqlSessionFactory sqlSessionFactory) throws Exception {
  SqlSession sqlSession = sqlSessionFactory.openSession();
  try {
    MultipleCrossIncludePersonMapper personMapper = sqlSession.getMapper(MultipleCrossIncludePersonMapper.class);
    Person person = personMapper.select(1);
    assertEquals((Integer)1, person.getId());
    assertEquals(2, person.getPets().size());
    assertEquals((Integer)2, person.getPets().get(1).getId());

    Pet pet = personMapper.selectPet(1);
    assertEquals(Integer.valueOf(1), pet.getId());

    MultipleCrossIncludePetMapper petMapper = sqlSession.getMapper(MultipleCrossIncludePetMapper.class);
    Pet pet2 = petMapper.select(3);
    assertEquals((Integer)3, pet2.getId());
    assertEquals((Integer)2, pet2.getOwner().getId());
  } finally {
    sqlSession.close();
  }
}

Source File: InsertTest.java From mybatis with Apache License 2.0

6 votes

@Test
public void testInsertAnnotated() throws Exception {
  Reader reader = Resources.getResourceAsReader("org/apache/ibatis/submitted/keycolumn/MapperConfig.xml");
  SqlSessionFactory sqlSessionFactory = new SqlSessionFactoryBuilder().build(reader);
  SqlSession sqlSession = sqlSessionFactory.openSession();
  try {
    InsertMapper mapper = sqlSession.getMapper(InsertMapper.class);
    Name name = new Name();
    name.setFirstName("Fred");
    name.setLastName("Flintstone");

    int rows = mapper.insertNameAnnotated(name);

    assertNotNull(name.getId());
    assertEquals(1, rows);
  } finally {
    sqlSession.close();
  }
}

Source File: InsertTest.java From mybaties with Apache License 2.0

6 votes

@Ignore // Not supported yet in PostgreSQL
@Test
public void testInsertMappedBatch() throws Exception {
  Reader reader = Resources.getResourceAsReader("org/apache/ibatis/submitted/keycolumn/MapperConfig.xml");
  SqlSessionFactory sqlSessionFactory = new SqlSessionFactoryBuilder().build(reader);
  SqlSession sqlSession = sqlSessionFactory.openSession(ExecutorType.BATCH);
  try {
    InsertMapper mapper = sqlSession.getMapper(InsertMapper.class);
    Name name = new Name();
    name.setFirstName("Fred");
    name.setLastName("Flintstone");
    mapper.insertNameMapped(name);
    Name name2 = new Name();
    name2.setFirstName("Wilma");
    name2.setLastName("Flintstone");
    mapper.insertNameMapped(name2);
    List<BatchResult> batchResults = sqlSession.flushStatements();
    assertNotNull(name.getId());
    assertNotNull(name2.getId());
    assertEquals(1, batchResults.size());
  } finally {
    sqlSession.close();
  }
}

Source File: InsertTest.java From mybatis with Apache License 2.0

6 votes

@Test
public void testInsertMapped() throws Exception {
  Reader reader = Resources.getResourceAsReader("org/apache/ibatis/submitted/keycolumn/MapperConfig.xml");
  SqlSessionFactory sqlSessionFactory = new SqlSessionFactoryBuilder().build(reader);
  SqlSession sqlSession = sqlSessionFactory.openSession();
  try {
    InsertMapper mapper = sqlSession.getMapper(InsertMapper.class);
    Name name = new Name();
    name.setFirstName("Fred");
    name.setLastName("Flintstone");

    int rows = mapper.insertNameMapped(name);

    assertNotNull(name.getId());
    assertEquals(1, rows);
  } finally {
    sqlSession.close();
  }
}

Source File: BatchInsertMain.java From blog with BSD 2-Clause "Simplified" License

6 votes

public static void main(String[] args) throws Exception {
	String resource = "mybatis-config2.xml";
	InputStream inputStream = Resources.getResourceAsStream(resource);
	SqlSessionFactory sqlSessionFactory = new SqlSessionFactoryBuilder().build(inputStream);

	FileAnalysis fileAnalysis = new FileAnalysis();
	SqlSession session = sqlSessionFactory.openSession();
	try {
		FielAnalysisMapper mapper = session.getMapper(FielAnalysisMapper.class);
		fileAnalysis = mapper.selectFileAnalysis("01");
		session.commit();
	} finally {
		session.close();
	}

	FileAnalysisInsert fileAnalysisInsert = new FileAnalysisInsert(sqlSessionFactory);
	fileAnalysisInsert.batchInsertOrder(fileAnalysis);

}

Source File: InsertTest.java From mybatis with Apache License 2.0

6 votes

@Ignore // Not supported yet in PostgreSQL
@Test
public void testInsertMappedBatch() throws Exception {
  Reader reader = Resources.getResourceAsReader("org/apache/ibatis/submitted/keycolumn/MapperConfig.xml");
  SqlSessionFactory sqlSessionFactory = new SqlSessionFactoryBuilder().build(reader);
  SqlSession sqlSession = sqlSessionFactory.openSession(ExecutorType.BATCH);
  try {
    InsertMapper mapper = sqlSession.getMapper(InsertMapper.class);
    Name name = new Name();
    name.setFirstName("Fred");
    name.setLastName("Flintstone");
    mapper.insertNameMapped(name);
    Name name2 = new Name();
    name2.setFirstName("Wilma");
    name2.setLastName("Flintstone");
    mapper.insertNameMapped(name2);
    List<BatchResult> batchResults = sqlSession.flushStatements();
    assertNotNull(name.getId());
    assertNotNull(name2.getId());
    assertEquals(1, batchResults.size());
  } finally {
    sqlSession.close();
  }
}

Source File: CmsCmProcessorTest.java From oneops with Apache License 2.0

6 votes

@BeforeClass
public static void setUp() throws Exception {
    System.out.println("Starting up CmsCmProcessor tests");
 String resource = "mybatis-config.xml";
 Reader reader = Resources.getResourceAsReader( resource );
 SqlSessionFactory sf = new SqlSessionFactoryBuilder().build(reader);
    session = sf.openSession();
 clazzMapper = session.getMapper(ClazzMapper.class);
    ciMapper = session.getMapper(CIMapper.class);
    mdValidator = new CmsMdValidator();
    cmValidator = new CmsCmValidator();
 mdProcessor = new CmsMdProcessor();
 mdProcessor.setClazzMapper( clazzMapper );
 mdProcessor.setMdValidator(mdValidator);
    cmProcessor = new CmsCmProcessor();
    cmProcessor.setCiMapper(ciMapper);
    cmProcessor.setMdProcessor(mdProcessor);
    cmProcessor.setCmValidator(cmValidator);
    RelationMapper relationMapper=session.getMapper(RelationMapper.class);
    mdProcessor.setRelationMapper(relationMapper);
    
}

Source File: XmlExternalRefTest.java From mybatis with Apache License 2.0

6 votes

private void testCrossReference(SqlSessionFactory sqlSessionFactory) throws Exception {
  SqlSession sqlSession = sqlSessionFactory.openSession();
  try {
    PersonMapper personMapper = sqlSession.getMapper(PersonMapper.class);
    Person person = personMapper.select(1);
    assertEquals((Integer)1, person.getId());
    assertEquals(2, person.getPets().size());
    assertEquals((Integer)2, person.getPets().get(1).getId());

    Pet pet = personMapper.selectPet(1);
    assertEquals(Integer.valueOf(1), pet.getId());

    PetMapper petMapper = sqlSession.getMapper(PetMapper.class);
    Pet pet2 = petMapper.select(3);
    assertEquals((Integer)3, pet2.getId());
    assertEquals((Integer)2, pet2.getOwner().getId());
  } finally {
    sqlSession.close();
  }
}

Source File: InsertTest.java From mybaties with Apache License 2.0

6 votes

@Test
public void testInsertAnnotated() throws Exception {
  Reader reader = Resources.getResourceAsReader("org/apache/ibatis/submitted/keycolumn/MapperConfig.xml");
  SqlSessionFactory sqlSessionFactory = new SqlSessionFactoryBuilder().build(reader);
  SqlSession sqlSession = sqlSessionFactory.openSession();
  try {
    InsertMapper mapper = sqlSession.getMapper(InsertMapper.class);
    Name name = new Name();
    name.setFirstName("Fred");
    name.setLastName("Flintstone");

    int rows = mapper.insertNameAnnotated(name);

    assertNotNull(name.getId());
    assertEquals(1, rows);
  } finally {
    sqlSession.close();
  }
}

Source File: XmlExternalRefTest.java From mybaties with Apache License 2.0

6 votes

private void testCrossReference(SqlSessionFactory sqlSessionFactory) throws Exception {
  SqlSession sqlSession = sqlSessionFactory.openSession();
  try {
    PersonMapper personMapper = sqlSession.getMapper(PersonMapper.class);
    Person person = personMapper.select(1);
    assertEquals((Integer)1, person.getId());
    assertEquals(2, person.getPets().size());
    assertEquals((Integer)2, person.getPets().get(1).getId());

    Pet pet = personMapper.selectPet(1);
    assertEquals(Integer.valueOf(1), pet.getId());

    PetMapper petMapper = sqlSession.getMapper(PetMapper.class);
    Pet pet2 = petMapper.select(3);
    assertEquals((Integer)3, pet2.getId());
    assertEquals((Integer)2, pet2.getOwner().getId());
  } finally {
    sqlSession.close();
  }
}

Source File: MybatisHelper.java From cjs_ssms with GNU General Public License v2.0

5 votes

/**
 * 根据mybatis配置获取SqlSession,这个方法在测试Mapper时候不是很靠谱,需检测
 *
 * 此方法未设定mapper一些必要设定的属性,执行会报错 不要使用
 *
 * @return
 * @throws IOException
 */
@Deprecated
public static SqlSession session() throws IOException {
  String resource = "database/mybatis-config-javaapi.xml";
  InputStream inputStream = Resources.getResourceAsStream(resource);
  SqlSessionFactory sqlSessionFactory = (new SqlSessionFactoryBuilder()).build(inputStream);
  SqlSession sqlSession = sqlSessionFactory.openSession();
  return sqlSession;
}

Source File: MybatisCRUDTest.java From code with Apache License 2.0

5 votes

/**
 * mybatis数据源
 *  PooledDataSource中找到popConnection()方法
 */
@Test
public void testSql() throws Exception {
    InputStream in = Resources.getResourceAsStream("SqlMapConfig.xml");
    SqlSessionFactory factory = new SqlSessionFactoryBuilder().build(in);
    SqlSession sqlSession = factory.openSession();
    UserMapper userMapper = sqlSession.getMapper(UserMapper.class);
    User user = userMapper.findUserById(42);
    System.out.println(user);

    // 释放资源
    sqlSession.close();
    in.close();
}

Source File: UserMain.java From blog with BSD 2-Clause "Simplified" License

5 votes

public static void main(String[] args) throws IOException {
	String resource = "mybatis-config.xml";
	InputStream inputStream = Resources.getResourceAsStream(resource);
	SqlSessionFactory sqlSessionFactory = new SqlSessionFactoryBuilder().build(inputStream);

	// 方式一
	SqlSession session1 = sqlSessionFactory.openSession();
	User user = new User();
	user.setId(102);
	user.setSex(Sex.FEMALE);
	user.setName("zhaohui");
	try {
		session1.insert("insertUser", user);
		session1.commit();
	} finally {
		session1.close();
	}

	SqlSession session2 = sqlSessionFactory.openSession();
	try {
		UserMapper userMapper = session2.getMapper(UserMapper.class);
		User user2 = userMapper.getUser(102);
		System.out.println(user2.toString());
	} finally {
		session2.close();
	}

}

Source File: MybatisTester.java From J2Cache with Apache License 2.0

5 votes

public static void main(String[] args) {

        String resource = "/mybatis.xml";
        InputStream inputStream = MybatisTester.class.getResourceAsStream(resource);
        SqlSessionFactory sqlSessionFactory = new SqlSessionFactoryBuilder().build(inputStream);
        SqlSession session = sqlSessionFactory.openSession();
        try {
            System.out.println("mybatis init.");
            /*
            Blog blog = new Blog();
            blog.setId(100);
            blog.setTitle("博客标题1");
            blog.setBody("博客内容1");
            session.insert("new", blog);

            System.out.println("blog inserted");
            */
            for(int i=0;i<10;i++) {
                Blog db = session.selectOne("read", 100);
                System.out.printf("id=%d,title=%s,body=%s%n", db.getId(), db.getTitle(), db.getBody());
                session.commit();
            }

        } catch (Exception e) {
            e.printStackTrace();
        } finally {
            session.close();
            System.exit(0);
        }

    }

Source File: PeopleServiceImpl.java From Project with Apache License 2.0

5 votes

public List<People> selectAll() throws IOException {
    // MyBatis 默认不加载配置文件，因此需要先加载配置文件，返回整个配置文件的流对象
    // 在数据访问层处理异常和在控制器中处理异常，一般在 service 中只抛出异常；
    InputStream inputStream = Resources.getResourceAsStream("MyBatis.xml");
    // 前面是工厂       实例化工厂对象时使用的是构建者设计模式   它的名称标志:后面有Builder
    // 构建者设计模式意义: 简化对象实例化过程
    SqlSessionFactory factory = new SqlSessionFactoryBuilder().build(inputStream);
    // 整个 sqlsession 就是 MyBatis 中 API 封装的对象,增删改查都在里面
    SqlSession session = factory.openSession();
    List<People> list = session.selectList("com.gjxaiou.mapper.PeopleMapper.selAll");
    session.close();
    return list;
}

Source File: TestBatisXML.java From java-course-ee with MIT License

5 votes

public static void main(String[] args) throws IOException {
    String resource = "Configuration.xml";
    Reader reader = Resources.getResourceAsReader(resource);
    SqlSessionFactory sqlSessionFactory = new SqlSessionFactoryBuilder().build(reader);

    SqlSession session = sqlSessionFactory.openSession();
    try {
        Region region = new Region();
        region.setRegionName("12345");

        session.insert("ibatis.RegionMapper.insertRegion", region);
        session.commit();

        System.out.println("Region ID: " + region.getRegionId());

        findAndGet(session);

        region.setRegionName("54321");
        session.update("ibatis.RegionMapper.updateRegion", region);
        session.commit();
        findAndGet(session);

        session.delete("ibatis.RegionMapper.deleteRegion", region.getRegionId());
        session.commit();
        findAndGet(session);

    } catch (Exception e) {
        e.printStackTrace();
    } finally {
        session.close();
    }

}

Source File: MultipleReverseIncludeTest.java From mybaties with Apache License 2.0

5 votes

private void testMultipleReverseIncludes(SqlSessionFactory sqlSessionFactory) throws Exception {
  SqlSession sqlSession = sqlSessionFactory.openSession();
  try {
    MultipleReverseIncludePersonMapper personMapper = sqlSession.getMapper(MultipleReverseIncludePersonMapper.class);
    Person person = personMapper.select(1);
    assertEquals((Integer)1, person.getId());
    assertEquals("John", person.getName());

  } finally {
    sqlSession.close();
  }
}

Source File: MybatisSelectTest.java From code with Apache License 2.0

5 votes

@Before//在测试方法执行之前执行
public void init() throws Exception {
    //1.读取配置文件
    in = Resources.getResourceAsStream("SqlMapConfig.xml");
    //2.创建构建者对象
    SqlSessionFactoryBuilder builder = new SqlSessionFactoryBuilder();
    //3.创建 SqlSession 工厂对象
    SqlSessionFactory factory = builder.build(in);
    //4.创建 SqlSession 对象
    session = factory.openSession();
    //5.创建 Dao 的代理对象
    userMapper = session.getMapper(UserMapper.class);
}

Source File: DefaultResultHandlerTypeTest.java From mybaties with Apache License 2.0

5 votes

@Test
public void testSelectList() throws Exception {
  String xmlConfig = "org/apache/ibatis/submitted/result_handler_type/MapperConfig.xml";
  SqlSessionFactory sqlSessionFactory = getSqlSessionFactoryXmlConfig(xmlConfig);
  SqlSession sqlSession = sqlSessionFactory.openSession();
  try {
    List<Person> list = sqlSession
        .selectList("org.apache.ibatis.submitted.result_handler_type.PersonMapper.doSelect");
    assertEquals(list.size(), 2);
    assertEquals("java.util.LinkedList", list.getClass().getCanonicalName());
  } finally {
    sqlSession.close();
  }
}

Source File: CmsTest.java From oneops with Apache License 2.0

4 votes

/**
 * @param args
 * @throws IOException 
 * @throws SQLException 
 */
public static void _main(String[] args) throws IOException, SQLException {
	String resource = "mybatis-config.xml";
	Reader reader = Resources.getResourceAsReader(resource);
	SqlSessionFactory sqlsf = new SqlSessionFactoryBuilder().build(reader);

	SqlSession session = sqlsf.openSession();
	CIMapper ciMapper = session.getMapper(CIMapper.class);
	ClazzMapper clMapper = session.getMapper(ClazzMapper.class);
	NSMapper nsMapper = session.getMapper(NSMapper.class);
	RelationMapper rlMapper = session.getMapper(RelationMapper.class);
	CmsCmProcessor cmProcessor = new CmsCmProcessor();
	
	cmProcessor.setCiMapper(ciMapper);
	cmProcessor.setCmValidator(cmValidator);
	cmProcessor.setCmsNsProcessor(nsMan);
	
	cmValidator.setCmsMdProcessor(mdMan);
	cmValidator.setCmsNsProcessor(nsMan);
	
	nsMan.setNsMapper(nsMapper);
	
	CmsMdProcessor mdProcessor = new CmsMdProcessor();
	mdProcessor.setClazzMapper(clMapper);
	mdProcessor.setRelationMapper(rlMapper);
	
	
	
	try {
		testQueryAttrs(ciMapper);
		//testState(sqlsf);
		//testClazzes(sqlsf);
		//testCreateOrg();
		//testCreateAssembly();
		//testCreatPlatform(sqlsf);
		//int newRelId = testCreateRelation(sqlsf, 1048, 1052);
		//testGetRelation(sqlsf, newRelId);
		//testGetToFromRelation(sqlsf, 1048);
		//testUpdateCI(sqlsf);
		//testDeleteCi(sqlsf);
		//testGetCiById(sqlsf);
		//testGetCi(sqlsf);
		//testCreateClazz(sqlsf);
		//testGetClazz(sqlsf);
		session.commit();
	} finally {
		session.close();
	}
}

Java Code Examples for org.apache.ibatis.session.SqlSessionFactory#openSession()