@Override public <T> T selectOne(String statement, Object parameter) { return session.selectOne(statement, parameter); }
@Override public <T> T selectOne(String statement) { return session.selectOne(statement); }
protected String getDbVersion() { String selectSchemaVersionStatement = dbSqlSessionFactory.mapStatement("selectDbSchemaVersion"); return (String) sqlSession.selectOne(selectSchemaVersionStatement); }
public Object selectOne(String statement, Object parameter) { statement = dbSqlSessionFactory.mapStatement(statement); Object result = sqlSession.selectOne(statement, parameter); if (result instanceof Entity) { Entity loadedObject = (Entity) result; result = cacheLoadOrStore(loadedObject); } return result; }
/** * 查询总数 * * @param queryWrapper 实体对象封装操作类(可以为 null) */ public Integer selectCount(Wrapper<T> queryWrapper) { Map<String, Object> map = new HashMap<>(1); map.put(Constants.WRAPPER, queryWrapper); SqlSession sqlSession = sqlSession(); try { return SqlHelper.retCount(sqlSession.<Integer>selectOne(sqlStatement(SqlMethod.SELECT_COUNT), map)); } finally { closeSqlSession(sqlSession); } }
/** * 根据 ID 查询 * * @param id 主键ID */ public T selectById(Serializable id) { SqlSession sqlSession = sqlSession(); try { return sqlSession.selectOne(sqlStatement(SqlMethod.SELECT_BY_ID), id); } finally { closeSqlSession(sqlSession); } }
@Override public int selectCount(String sql, Object... args) { SqlSession sqlSession = sqlSession(); try { return SqlHelper.retCount(sqlSession.<Integer>selectOne(COUNT, sqlMap(sql, args))); }finally { closeSqlSession(sqlSession); } }
@SuppressWarnings("unchecked") public <T extends Entity> T selectById(Class<T> entityClass, String id, boolean useCache) { T entity = null; if (useCache) { entity = entityCache.findInCache(entityClass, id); if (entity != null) { return entity; } } String selectStatement = dbSqlSessionFactory.getSelectStatement(entityClass); selectStatement = dbSqlSessionFactory.mapStatement(selectStatement); entity = (T) sqlSession.selectOne(selectStatement, id); if (entity == null) { return null; } entityCache.put(entity, true); // true -> store state so we can see later if it is updated later on return entity; }
@Override public <T> T selectOne(String statement, Object parameter) { return sqlSessionProxy.<T> selectOne(statement, parameter); }
@Override public <T> T selectOne(String statement) { return sqlSessionProxy.<T> selectOne(statement); }
@Override public <T> T selectOne(String statement, Object parameter) { return sqlSessionProxy.selectOne(statement, parameter); }
result = sqlSession.selectOne(command.getName(), param); if (method.returnsOptional() && (result == null || !method.getReturnType().equals(result.getClass()))) {
sqlSession -> when(sqlSession.selectOne(randomStatement)).thenReturn(randomObject), dbSession -> dbSession.selectOne(randomStatement), sqlSession -> { verify(sqlSession).selectOne(randomStatement); return randomObject; }); verifyDelegation( sqlSession -> when(sqlSession.selectOne(randomStatement, randomParameter)).thenReturn(randomObject), dbSession -> dbSession.selectOne(randomStatement, randomParameter), sqlSession -> { verify(sqlSessionMock).selectOne(randomStatement, randomParameter); return randomObject; });
@Override protected String getDbVersion() { String selectSchemaVersionStatement = dbSqlSessionFactory.mapStatement("selectDbSchemaVersion"); return (String) sqlSession.selectOne(selectSchemaVersionStatement); }
@Override protected String getDbVersion() { String selectSchemaVersionStatement = dbSqlSessionFactory.mapStatement("selectDbSchemaVersion"); return (String) sqlSession.selectOne(selectSchemaVersionStatement); }
public Object selectOne(String statement, Object parameter) { statement = dbSqlSessionFactory.mapStatement(statement); Object result = sqlSession.selectOne(statement, parameter); fireEntityLoaded(result); return result; }
public Object selectOne(String statement, Object parameter) { statement = dbSqlSessionFactory.mapStatement(statement); Object result = sqlSession.selectOne(statement, parameter); fireEntityLoaded(result); return result; }
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(); }
@SuppressWarnings("unchecked") public <T extends DbEntity> T selectById(Class<T> type, String id) { String selectStatement = dbSqlSessionFactory.getSelectStatement(type); selectStatement = dbSqlSessionFactory.mapStatement(selectStatement); ensureNotNull("no select statement for " + type + " in the ibatis mapping files", "selectStatement", selectStatement); Object result = sqlSession.selectOne(selectStatement, id); fireEntityLoaded(result); return (T) result; }
@SuppressWarnings("unchecked") public <T extends DbEntity> T selectById(Class<T> type, String id) { String selectStatement = dbSqlSessionFactory.getSelectStatement(type); selectStatement = dbSqlSessionFactory.mapStatement(selectStatement); ensureNotNull("no select statement for " + type + " in the ibatis mapping files", "selectStatement", selectStatement); Object result = sqlSession.selectOne(selectStatement, id); fireEntityLoaded(result); return (T) result; }