Java Code Examples for org.apache.ibatis.session.SqlSessionFactory#openSession()
The following examples show how to use
org.apache.ibatis.session.SqlSessionFactory#openSession() .
You can vote up the ones you like or vote down the ones you don't like,
and go to the original project or source file by following the links above each example. You may check out the related API usage on the sidebar.
Example 1
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(); } }
Example 2
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(); } }
Example 3
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(); } }
Example 4
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(); } }
Example 5
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); }
Example 6
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(); } }
Example 7
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); }
Example 8
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(); } }
Example 9
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(); } }
Example 10
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(); } }
Example 11
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; }
Example 12
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(); }
Example 13
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(); } }
Example 14
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); } }
Example 15
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; }
Example 16
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(); } }
Example 17
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(); } }
Example 18
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); }
Example 19
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(); } }
Example 20
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(); } }