public SqlMapClientTemplate(GoCache goCache, SystemEnvironment systemEnvironment, Database database, SqlSessionFactory sqlSessionFactory) { this.goCache = goCache; this.delegate = new org.mybatis.spring.SqlSessionTemplate(sqlSessionFactory); this.systemEnvironment = systemEnvironment; this.database = database; }
public List queryForList(String statementName, Object parameter) { return delegate.selectList(translateStatementName(statementName), parameter); }
public Object queryForObject(String statementName, Object parameter) { return delegate.selectOne(translateStatementName(statementName), parameter); }
public void rw() { Students students = (Students)sqlSessionTemplate.selectOne("selectByPrimaryKey", 1L); System.out.println(students.getName()); students.setName("rw"); sqlSessionTemplate.update("updateByPrimaryKeySelective", students); studentsMapper.updateByPrimaryKeySelective(students); students.setId(2L); studentsMapper.updateByPrimaryKeySelective(students); students = studentsMapper.selectByPrimaryKey(2L); System.out.println(students.getName()); // throw new RuntimeException(); }
public IDBMapper<T> getTemplateMapper(T entity) { DbMapper mapper = entity.getClass().getAnnotation(DbMapper.class); return (IDBMapper<T>) sqlSessionTemplate.getMapper(mapper.mapper()); }
private String translateStatementName(String statementName) { return translatedStatementNames.computeIfAbsent(statementName, statementName1 -> { if (systemEnvironment.isDefaultDbProvider()) { return statementName1; } String forExternalDb = String.format("%s-%s", statementName1, database.getType()); MappedStatement statement; try { statement = delegate.getConfiguration().getMappedStatement(forExternalDb); } catch (Exception e) { statement = null; } return statement != null ? forExternalDb : statementName1; }); }
public List<Spitter> findAllSpitters() { SpitterMapper spitterMapper = sqlSessionTemplate.getMapper(SpitterMapper.class); return spitterMapper.findAllSpitters(); } }
public MybatisRepositoryFactory(SqlSessionTemplate sqlSessionTemplate, MappingContext<?, ?> mappingContext) { Assert.notNull(sqlSessionTemplate, "SqlSessionTemplate must not be null!"); this.sqlSessionTemplate = sqlSessionTemplate; addRepositoryProxyPostProcessor(new MybatisMapperBuildProcessor( sqlSessionTemplate.getConfiguration(), mappingContext)); addQueryCreationListener(new MybatisQueryCreationListener( sqlSessionTemplate.getConfiguration(), mappingContext)); }
@Bean(name = "test1SqlSessionTemplate") @Primary public SqlSessionTemplate testSqlSessionTemplate(@Qualifier("test1SqlSessionFactory") SqlSessionFactory sqlSessionFactory) throws Exception { return new SqlSessionTemplate(sqlSessionFactory); }
public List queryForList(String statementName) { return delegate.selectList(translateStatementName(statementName)); }
@RequestMapping("/user/{id}") public User user(@PathVariable int id) { User user = sqlSessionTemplate.selectOne("com.segmentfault.springbootlesson7.mapper.UserMapper.selectOneUser", id); return user; }
public List<Spitter> findAllSpitters() { try{ SpitterMapper spitterMapper = sqlSessionTemplate.getMapper(SpitterMapper.class); return spitterMapper.findAllSpitters(); }catch (Exception e){ System.out.println("----------------------------"); System.out.println(e.getCause()); System.out.println("+++++++++++++++++++++++++++++"); } return null; } }
@Override public void afterPropertiesSet() throws Exception { this.sqlSessionTemplate.getConfiguration() .addInterceptor(new AuditingInterceptor(this)); }
@Bean(name = "test2SqlSessionTemplate") public SqlSessionTemplate testSqlSessionTemplate(@Qualifier("test2SqlSessionFactory") SqlSessionFactory sqlSessionFactory) throws Exception { return new SqlSessionTemplate(sqlSessionFactory); }
@SuppressWarnings("unchecked") @Override protected List<AppliedPatchEntity> getAppliedPatchEntities() { return template.selectList(SELECT_ALL_APPLIED_PATCH); } }
@Override protected Long selectMinUnusedTxnCommitTime() { return template.selectOne(SELECT_TXN_UNUSED_MIN_COMMIT_TIME); }
@Override public Object execute(Object[] parameters) { return ReflectionUtils .invokeMethod(queryMethod.getMethod(), sessionTemplate.getMapper(queryMethod.getRepositoryInterface()), parameters); }
@Bean(name = "test2SqlSessionTemplate") public SqlSessionTemplate testSqlSessionTemplate(@Qualifier("test2SqlSessionFactory") SqlSessionFactory sqlSessionFactory) throws Exception { return new SqlSessionTemplate(sqlSessionFactory); }
@Override protected List<StoreEntity> selectAllStores() { return template.selectList(SELECT_STORE_ALL); }
@Override protected Long selectMaxTxnId() { return template.selectOne(SELECT_TXN_MAX_ID); }