@Override public <E> List<E> selectList(String statement, Object parameter, RowBounds rowBounds) { return session.selectList(statement, parameter, rowBounds); }
@Override public <E> List<E> selectList(String statement) { return session.selectList(statement); }
@Override public <E> List<E> selectList(String statement, Object parameter) { return session.selectList(statement, parameter); }
@SuppressWarnings({"rawtypes"}) public List selectListWithRawParameterWithoutFilter(String statement, Object parameter, int firstResult, int maxResults) { statement = dbSqlSessionFactory.mapStatement(statement); if (firstResult == -1 || maxResults == -1) { return Collections.EMPTY_LIST; } return sqlSession.selectList(statement, parameter); }
@Override public List<String> getDeploymentResourceNames(String deploymentId) { return getDbSqlSession().getSqlSession().selectList("selectResourceNamesByDeploymentId", deploymentId); }
/** * IPage 专用 */ private <E> List<E> executeForIPage(SqlSession sqlSession, Object[] args) { Object param = method.convertArgsToSqlCommandParam(args); return sqlSession.selectList(command.getName(), param); }
/** * 查询总记录数 * * @param queryWrapper 实体对象封装操作类(可以为 null) */ public List<T> selectList(Wrapper<T> queryWrapper) { Map<String, Object> map = new HashMap<>(1); map.put(Constants.WRAPPER, queryWrapper); SqlSession sqlSession = sqlSession(); try { return sqlSession.selectList(sqlStatement(SqlMethod.SELECT_LIST), map); } finally { closeSqlSession(sqlSession); } }
@SuppressWarnings({"rawtypes", "unchecked"}) public List selectListWithRawParameter(String statement, Object parameter, int firstResult, int maxResults, boolean useCache) { statement = dbSqlSessionFactory.mapStatement(statement); if (firstResult == -1 || maxResults == -1) { return Collections.EMPTY_LIST; } List loadedObjects = sqlSession.selectList(statement, parameter); if (useCache) { return cacheLoadOrStore(loadedObjects); } else { return loadedObjects; } }
/** * 翻页查询 * * @param page 翻页查询条件 * @param queryWrapper 实体对象封装操作类(可以为 null) */ public IPage<T> selectPage(IPage<T> page, Wrapper<T> queryWrapper) { Map<String, Object> map = new HashMap<>(2); map.put(Constants.WRAPPER, queryWrapper); map.put("page", page); SqlSession sqlSession = sqlSession(); try { page.setRecords(sqlSession.selectList(sqlStatement(SqlMethod.SELECT_PAGE), map)); } finally { closeSqlSession(sqlSession); } return page; }
/** * 查询所有 */ public List<T> selectAll() { SqlSession sqlSession = sqlSession(); try { return sqlSession.selectList(sqlStatement(SqlMethod.SELECT_LIST)); } finally { closeSqlSession(sqlSession); } }
/** * 根据sql查询一个字段值的结果集 * <p>注意:该方法只会返回一个字段的值, 如果需要多字段,请参考{@code selectList()}</p> * * @param sql sql语句,可添加参数,格式:{0},{1} * @param args 只接受String格式 * @return ignore */ @Override public List<Object> selectObjs(String sql, Object... args) { SqlSession sqlSession = sqlSession(); try { return sqlSession.selectList(SELECT_OBJS, sqlMap(sql, args)); }finally { closeSqlSession(sqlSession); } }
private <E> Object executeForMany(SqlSession sqlSession, Object[] args) { List<E> result; Object param = method.convertArgsToSqlCommandParam(args); if (method.hasRowBounds()) { RowBounds rowBounds = method.extractRowBounds(args); result = sqlSession.selectList(command.getName(), param, rowBounds); } else { result = sqlSession.selectList(command.getName(), param); } // issue #510 Collections & arrays support if (!method.getReturnType().isAssignableFrom(result.getClass())) { if (method.getReturnType().isArray()) { return convertToArray(result); } else { return convertToDeclaredCollection(sqlSession.getConfiguration(), result); } } return result; }
/** * 根据sql查询Map结果集 * <p>SqlRunner.db().selectList("select * from tbl_user where name={0}", "Caratacus")</p> * * @param sql sql语句,可添加参数,格式:{0},{1} * @param args 只接受String格式 * @return ignore */ @Override public List<Map<String, Object>> selectList(String sql, Object... args) { SqlSession sqlSession = sqlSession(); try { return sqlSession().selectList(SELECT_LIST, sqlMap(sql, args)); }finally { closeSqlSession(sqlSession); } }
@Override @SuppressWarnings("unchecked") public TablePage getTablePage(TablePageQueryImpl tablePageQuery, int firstResult, int maxResults) { TablePage tablePage = new TablePage(); @SuppressWarnings("rawtypes") List tableData = getDbSqlSession().getSqlSession().selectList("selectTableData", tablePageQuery, new RowBounds(firstResult, maxResults)); tablePage.setTableName(tablePageQuery.getTableName()); tablePage.setTotal(getTableCount(tablePageQuery.getTableName())); tablePage.setRows((List<Map<String, Object>>) tableData); tablePage.setFirstResult(firstResult); return tablePage; }
sqlSession -> when(sqlSession.selectList(randomStatement)).thenReturn(randomList), dbSession -> dbSession.selectList(randomStatement), sqlSession -> { verify(sqlSession).selectList(randomStatement); return randomList; }); verifyDelegation( sqlSession -> when(sqlSession.selectList(randomStatement, randomParameter)).thenReturn(randomList), dbSession -> dbSession.selectList(randomStatement, randomParameter), sqlSession -> { verify(sqlSessionMock).selectList(randomStatement, randomParameter); return randomList; }); verifyDelegation( sqlSession -> when(sqlSession.selectList(randomStatement, randomParameter, rowBounds)).thenReturn(randomList), dbSession -> dbSession.selectList(randomStatement, randomParameter, rowBounds), sqlSession -> { verify(sqlSessionMock).selectList(randomStatement, randomParameter, rowBounds); return randomList; });
@SuppressWarnings("unchecked") public List<String> findUserInfoKeysByUserIdAndType(String userId, String type) { Map<String, String> parameters = new HashMap<String, String>(); parameters.put("userId", userId); parameters.put("type", type); return (List) getDbSqlSession().getSqlSession().selectList("selectIdentityInfoKeysByUserIdAndType", parameters); }
public List<?> selectList(String statement, Object parameter){ statement = dbSqlSessionFactory.mapStatement(statement); List<Object> resultList = sqlSession.selectList(statement, parameter); for (Object object : resultList) { fireEntityLoaded(object); } return resultList; }
public List<?> selectList(String statement, Object parameter){ statement = dbSqlSessionFactory.mapStatement(statement); List<Object> resultList = sqlSession.selectList(statement, parameter); for (Object object : resultList) { fireEntityLoaded(object); } return resultList; }
@SuppressWarnings("unchecked") protected List<IdentityInfoEntity> findIdentityInfoDetails(String identityInfoId) { return Context .getCommandContext() .getDbSqlSession() .getSqlSession() .selectList("selectIdentityInfoDetails", identityInfoId); }
@SuppressWarnings("unchecked") protected List<IdentityInfoEntity> findIdentityInfoDetails(String identityInfoId) { return Context .getCommandContext() .getDbSqlSession() .getSqlSession() .selectList("selectIdentityInfoDetails", identityInfoId); }