Examples of org.springframework.jdbc.support.rowset.SqlRowSet

Package org.springframework.jdbc.support.rowset

Examples of org.springframework.jdbc.support.rowset.SqlRowSet

org.springframework.jdbc.support.rowset.SqlRowSet
Mirror interface for javax.sql.RowSet, representing disconnected java.sql.ResultSet data.
The main difference to the standard JDBC RowSet is that an SQLException is never thrown here. This allows a SqlRowSet to be used without having to deal with checked exceptions. A SqlRowSet will throw Spring's org.springframework.jdbc.InvalidResultSetAccessException instead (when appropriate).
Note: This interface extends the java.io.Serializable marker interface. Implementations, which typically hold disconnected data, are encouraged to be actually serializable (as far as possible). @author Thomas Risberg @author Juergen Hoeller @since 1.2 @see javax.sql.RowSet @see java.sql.ResultSet @see org.springframework.jdbc.InvalidResultSetAccessException @see org.springframework.jdbc.core.JdbcTemplate#queryForRowSet


    }


    @Override
    public List<LikelihoodData> retrieveAll(final String ppiName) {
        final SqlRowSet likelihood = this._getLikelihood(ppiName);


        List<LikelihoodData> likelihoodDatas = new ArrayList<>();


        while (likelihood.next()) {
            likelihoodDatas.add(new LikelihoodData(likelihood.getLong("id"), likelihood.getString("name"), likelihood.getString("code"),
                    likelihood.getLong("enabled")


            ));


        }

View Full Code Here


    }


    @Override
    public LikelihoodData retrieve(final Long likelihoodId) {
        final SqlRowSet likelihood = this._getLikelihood(likelihoodId);


        likelihood.first();


        return new LikelihoodData(likelihood.getLong("id"), likelihood.getString("name"), likelihood.getString("code"),
                likelihood.getLong("enabled")


        );


    }

View Full Code Here

    }


    @Override
    public PpiPovertyLineData retrieveAll(final String ppiName) {


        final SqlRowSet povertyLines = this._getPovertyLines(ppiName);


        final SqlRowSet likelihoods = this._getLikelihoods();


        List<LikeliHoodPovertyLineData> listOfLikeliHoodPovertyLineData = new ArrayList<>();


        while (likelihoods.next()) {
            final String codeName = likelihoods.getString("code");


            List<PovertyLineData> povertyLineDatas = new ArrayList<>();


            // create a new povertyLine object when ever it belong to the
            // current likelihood
            while (povertyLines.next()) {
                String likelihoodCode = povertyLines.getString("code");


                if (likelihoodCode.equals(codeName)) {
                    povertyLineDatas.add(new PovertyLineData(povertyLines.getLong("id"), povertyLines.getLong("score_from"), povertyLines
                            .getLong("score_to"), povertyLines.getDouble("poverty_line")));
                }
            }


            povertyLines.beforeFirst();


            // create the likelihood object with the list of povertyLine object
            // belonging to it


            LikeliHoodPovertyLineData likeliHoodPovertyLineData = new LikeliHoodPovertyLineData(likelihoods.getLong("id"),
                    povertyLineDatas, likelihoods.getString("name"), likelihoods.getString("code"), likelihoods.getLong("enabled"));


            listOfLikeliHoodPovertyLineData.add(likeliHoodPovertyLineData);


        }

View Full Code Here

    }


    @Override
    public LikeliHoodPovertyLineData retrieveForLikelihood(final String ppiName, final Long likelihoodId) {


        final SqlRowSet povertyLines = this._getPovertyLines(likelihoodId);


        List<PovertyLineData> povertyLineDatas = new ArrayList<>();


        while (povertyLines.next()) {


            povertyLineDatas.add(new PovertyLineData(povertyLines.getLong("id"), povertyLines.getLong("score_from"), povertyLines
                    .getLong("score_to"), povertyLines.getDouble("poverty_line")));
        }


        povertyLines.first();


        // create the likelihood object with the list of povertyLine object
        // belonging to it


        return new LikeliHoodPovertyLineData(povertyLines.getLong("likelihood_id"), povertyLineDatas, povertyLines.getString("name"),
                povertyLines.getString("code"), povertyLines.getLong("enabled"));


    }

View Full Code Here

                + " left join m_role_permission rp on rp.role_id = r.id" + " left join m_permission p on p.id = rp.permission_id"
                + " where ur.appuser_id = " + this.context.authenticatedUser().getId()
                + " and (p.code in ('ALL_FUNCTIONS', 'ALL_FUNCTIONS_READ') or p.code = concat('READ_', registered_table_name))) "
                + andClause + " order by application_table_name, registered_table_name";


        final SqlRowSet rs = this.jdbcTemplate.queryForRowSet(sql);


        final List<DatatableData> datatables = new ArrayList<>();
        while (rs.next()) {
            final String appTableName = rs.getString("application_table_name");
            final String registeredDatatableName = rs.getString("registered_table_name");
            final List<ResultsetColumnHeaderData> columnHeaderData = this.genericDataService
                    .fillResultsetColumnHeaders(registeredDatatableName);


            datatables.add(DatatableData.create(appTableName, registeredDatatableName, columnHeaderData));
        }

View Full Code Here

                + " left join m_role_permission rp on rp.role_id = r.id" + " left join m_permission p on p.id = rp.permission_id"
                + " where ur.appuser_id = " + this.context.authenticatedUser().getId() + " and registered_table_name='" + datatable + "'"
                + " and (p.code in ('ALL_FUNCTIONS', 'ALL_FUNCTIONS_READ') or p.code = concat('READ_', registered_table_name))) "
                + " order by application_table_name, registered_table_name";


        final SqlRowSet rs = this.jdbcTemplate.queryForRowSet(sql);


        DatatableData datatableData = null;
        while (rs.next()) {
            final String appTableName = rs.getString("application_table_name");
            final String registeredDatatableName = rs.getString("registered_table_name");
            final List<ResultsetColumnHeaderData> columnHeaderData = this.genericDataService
                    .fillResultsetColumnHeaders(registeredDatatableName);


            datatableData = DatatableData.create(appTableName, registeredDatatableName, columnHeaderData);
        }

View Full Code Here


    private CommandProcessingResult checkMainResourceExistsWithinScope(final String appTable, final Long appTableId) {


        final String sql = dataScopedSQL(appTable, appTableId);
        logger.info("data scoped sql: " + sql);
        final SqlRowSet rs = this.jdbcTemplate.queryForRowSet(sql);


        if (!rs.next()) { throw new DatatableNotFoundException(appTable, appTableId); }


        final Long officeId = getLongSqlRowSet(rs, "officeId");
        final Long groupId = getLongSqlRowSet(rs, "groupId");
        final Long clientId = getLongSqlRowSet(rs, "clientId");
        final Long savingsId = getLongSqlRowSet(rs, "savingsId");
        final Long LoanId = getLongSqlRowSet(rs, "loanId");
        final Long entityId = getLongSqlRowSet(rs, "entityId");


        if (rs.next()) { throw new DatatableSystemErrorException("System Error: More than one row returned from data scoping query"); }


        return new CommandProcessingResultBuilder() //
                .withOfficeId(officeId) //
                .withGroupId(groupId) //
                .withClientId(clientId) //

View Full Code Here

        return appTable;
    }


    private List<ResultsetRowData> fillDatatableResultSetDataRows(final String sql) {


        final SqlRowSet rs = this.jdbcTemplate.queryForRowSet(sql);


        final List<ResultsetRowData> resultsetDataRows = new ArrayList<>();


        final SqlRowSetMetaData rsmd = rs.getMetaData();


        while (rs.next()) {
            final List<String> columnValues = new ArrayList<>();
            for (int i = 0; i < rsmd.getColumnCount(); i++) {
                final String columnName = rsmd.getColumnName(i + 1);
                final String columnValue = rs.getString(columnName);
                columnValues.add(columnValue);
            }


            final ResultsetRowData resultsetDataRow = ResultsetRowData.create(columnValues);
            resultsetDataRows.add(resultsetDataRow);

View Full Code Here

    }


    private String queryForApplicationTableName(final String datatable) {
        final String sql = "SELECT application_table_name FROM x_registered_table where registered_table_name = '" + datatable + "'";


        final SqlRowSet rs = this.jdbcTemplate.queryForRowSet(sql);


        String applicationTableName = null;
        if (rs.next()) {
            applicationTableName = rs.getString("application_table_name");
        } else {
            throw new DatatableNotFoundException(datatable);
        }


        return applicationTableName;

View Full Code Here

    }


    private void setupBalanceMap(final String sql) {
        if (this.accountBalanceMap == null) {
            this.accountBalanceMap = new HashMap<>();
            final SqlRowSet rs = this.jdbcTemplate.queryForRowSet(sql);
            while (rs.next()) {
                this.accountBalanceMap.put(rs.getString("glcode"), rs.getBigDecimal("balance"));
            }
        }
    }

View Full Code Here

0 1 2 3 4 5 6

TOP

Related Classes of org.springframework.jdbc.support.rowset.SqlRowSet

cn.org.rapid_framework.spring.beans.factory.config.JdbcPlaceholderConfigurer

com.jeecms.cms.dao.assist.impl.CmsDataBackDaoImpl

com.jeecms.cms.dao.assist.impl.CmsDataDaoImpl

com.jverstry.Controller.MyController

com.salesforce.dataloader.dao.database.DatabaseTestUtil

com.services.otg.db.TrackingTemplate

it.pdor.gestionePratica.dao.jdbc.GestionePraticaDaoJdbcImpl

org.beangle.ems.avatar.service.DataBaseAvatarBase

org.beangle.webapp.avatar.service.DataBaseAvatarBase

org.geoserver.jdbcconfig.internal.DbMappings

All source code are property of their respective owners. Java is a trademark of Sun Microsystems, Inc and owned by ORACLE Inc. Contact coftware#gmail.com.