public void close() { sqlSession.close(); }
@Override public void close() { session.close(); }
public void close() { wrappedSession.close(); }
public void close() { sqlSession.close(); }
public void close() { sqlSession.close(); }
}); verifyDelegation(DbSessionImpl::close, s -> verify(s).close());
/** * Function : 关闭sqlSession */ public void closeBatchSession() { SqlSession session = threadLocal.get(); if (session != null) { if(logger.isDebugEnabled()) { logger.debug("销毁"); } session.close(); threadLocal.set(null); } }
@Override public void close() { final SqlSession sqlSession = localSqlSession.get(); if (sqlSession == null) { throw new SqlSessionException("Error: Cannot close. No managed session is started."); } try { sqlSession.close(); } finally { localSqlSession.set(null); } }
@Override public void close() { final SqlSession sqlSession = localSqlSession.get(); if (sqlSession == null) { throw new SqlSessionException("Error: Cannot close. No managed session is started."); } try { sqlSession.close(); } finally { localSqlSession.set(null); } }
public static void main(String[] args) throws Exception { ClassLoader classLoader = Thread.currentThread().getContextClassLoader(); InputStream inputStream = classLoader.getResourceAsStream("mybatis/mybatis-config.xml"); Reader reader = new InputStreamReader(inputStream, "UTF-8"); SqlSessionFactoryBuilder builder = new SqlSessionFactoryBuilder(); SqlSessionFactory sqlSessionFactory = builder.build(reader, "dev", new Properties()); SqlSession sqlSession = sqlSessionFactory.openSession(); UserMapper userMapper = sqlSession.getMapper(UserMapper.class); User user = userMapper.selectUser(145); System.out.println(user); sqlSession.close(); }
public void updateRecords(final List<GisObject> objectsToUpdate) { final SqlSession sqlSession = MyBatisUtils.getSqlSessionFactory().openSession(ExecutorType.BATCH); try { final GisObjectMapper mapper = sqlSession.getMapper(GisObjectMapper.class); for (final GisObject gisObject : objectsToUpdate) { mapper.updateRecord(gisObject); } sqlSession.commit(); } finally { sqlSession.close(); } }
public static void main(String[] args) throws Exception { System.out.println(System.getProperty("user.dir")); ResourceLoader resourceLoader = new DefaultResourceLoader(); Resource resource = resourceLoader.getResource("classpath:/mybatis/mybatis-config.xml"); EncodedResource encodedResource = new EncodedResource(resource, "UTF-8"); Reader reader = encodedResource.getReader(); SqlSessionFactoryBuilder builder = new SqlSessionFactoryBuilder(); SqlSessionFactory sqlSessionFactory = builder.build(reader, "dev", new Properties()); SqlSession sqlSession = sqlSessionFactory.openSession(); User user = sqlSession.selectOne("com.segmentfault.springbootlesson7.mapper.UserMapper.selectOneUser", 145); System.out.println(user); sqlSession.close(); }
public static void main(String[] args) throws Exception { ClassLoader classLoader = Thread.currentThread().getContextClassLoader(); InputStream inputStream = classLoader.getResourceAsStream("mybatis/mybatis-config.xml"); Reader reader = new InputStreamReader(inputStream, "UTF-8"); SqlSessionFactoryBuilder builder = new SqlSessionFactoryBuilder(); SqlSessionFactory sqlSessionFactory = builder.build(reader, "dev", new Properties()); SqlSession sqlSession = sqlSessionFactory.openSession(); UserMapper userMapper = sqlSession.getMapper(UserMapper.class); UserExample userExample = new UserExample(); UserExample.Criteria criteria = userExample.createCriteria(); criteria.andIdEqualTo(145); List<User> users = userMapper.selectByExample(userExample); User user = users.get(0); System.out.println(user); sqlSession.close(); }
@Override public Object invoke(Object proxy, Method method, Object[] args) throws Throwable { final SqlSession sqlSession = SqlSessionManager.this.localSqlSession.get(); if (sqlSession != null) { try { return method.invoke(sqlSession, args); } catch (Throwable t) { throw ExceptionUtil.unwrapThrowable(t); } } else { final SqlSession autoSqlSession = openSession(); try { final Object result = method.invoke(autoSqlSession, args); autoSqlSession.commit(); return result; } catch (Throwable t) { autoSqlSession.rollback(); throw ExceptionUtil.unwrapThrowable(t); } finally { autoSqlSession.close(); } } } }
public static void main(String[] args) throws IOException { UnpooledDataSource dataSource = new UnpooledDataSource( "com.mysql.jdbc.Driver", "jdbc:mysql://localhost:3306/mybatis", "root", ""); TransactionFactory transactionFactory = new JdbcTransactionFactory(); Environment environment = new Environment("Java", transactionFactory, dataSource); Configuration configuration = new Configuration(environment); configuration.getTypeAliasRegistry().registerAliases("tk.mybatis.simple.model"); configuration.setLogImpl(Log4jImpl.class); InputStream inputStream = Resources.getResourceAsStream("tk/mybatis/simple/mapper/CountryMapper.xml"); XMLMapperBuilder mapperParser = new XMLMapperBuilder(inputStream, configuration, "tk/mybatis/simple/mapper/CountryMapper.xml", configuration.getSqlFragments()); mapperParser.parse(); SqlSessionFactory sqlSessionFactory = new SqlSessionFactoryBuilder().build(configuration); SqlSession sqlSession = sqlSessionFactory.openSession(); try { List<Country> countryList = sqlSession.selectList("selectAll"); printCountryList(countryList); } finally { sqlSession.close(); } }
@Override public Integer getTotalCallDetailRecords(CallDetailRecordFilter filter) { final SqlSession session = sessions.openSession(); try { final Integer total = session.selectOne(namespace + "getTotalCallDetailRecordByUsingFilters", filter); return total; } finally { session.close(); } }
@Override public void removeGateway(final Sid sid) { final SqlSession session = sessions.openSession(); try { session.delete(namespace + "removeGateway", sid.toString()); session.commit(); } finally { session.close(); } }
@Override public void addCookie(final Sid sid, final Cookie cookie) { final SqlSession session = sessions.openSession(); try { session.insert(namespace + "addCookie", toMap(sid, cookie)); session.commit(); } finally { session.close(); } }
@Override public void updateCookie(final Sid sid, final Cookie cookie) { final SqlSession session = sessions.openSession(); try { session.update(namespace + "updateCookie", toMap(sid, cookie)); session.commit(); } finally { session.close(); } }
@Override public void addAnnouncement(Announcement announcement) { final SqlSession session = sessions.openSession(); try { session.insert(namespace + "addAnnouncement", toMap(announcement)); session.commit(); } finally { session.close(); } }