Examples of GenericDBMS.ResultSetHelper

GenericDBMS.ResultSetHelper
This class provide Forte like semantics on a result set. This includes the following responsibilities:
- Translating SQLExceptions into DataAccessExceptions via Spring
- Providing methods to be able to read values into data value sub-classes, including setting the NULL flag on nullable types when the type read from the database is null
- Trimming spaces from the end of the text values returned. Note that Forte did not trim trailing whitespaces in all cases, it seems to be only when the type of the column defined in the database was of type CHAR. This logic is reproduced here.

        RowCountCallbackHandler qq_RowCounter = new RowCountCallbackHandler() {
            protected void processRow(ResultSet pResultSet, int pRow) throws SQLException {
                if (pRow >= 1) {
                    throw new IncorrectResultSizeDataAccessException(1, pRow+1);
                }
                ResultSetHelper helper = new ResultSetHelper(pResultSet);
                qqh_title1.setObject(helper.getString(1));
                qqh_numCustomers.setInt(helper.getInt(2));
                qqh_title2.setObject(helper.getTextData(3));
                qqh_numStocks.setObject(helper.getIntegerData(4));
                qqh_title3.setObject(helper.getTextNullable(5));
                qqh_totalValue.setDouble(helper.getDouble(6));
            }
        };
        dBConnection.getTemplate().query(qq_SQL, qq_RowCounter);
        title1 = (String)qqh_title1.getObject();
        numCustomers = qqh_numCustomers.getInt();

View Full Code Here

            //         on session DBConnection 
            // -- ============================================
            qq_SQL = "select StockName from Stock ";
            qq_cmd = dBConnection.getPreparedStatement(qq_SQL);
            qq_rs = qq_cmd.executeQuery();
            ResultSetHelper qq_rsHelper = new ResultSetHelper(qq_rs);
            while (qq_rsHelper.next()) {
                TextData temp = qq_rsHelper.getTextData(1);
                ListElement row = new ListElement();
                row.getTextValue().setValue( temp.getValue() );
                this.stockNameList.add(row);
            }
        }

View Full Code Here

            //         on session DBConnection 
            // -- ============================================
            qq_SQL = "select StockName from Stock ";
            qq_cmd = dBConnection.getPreparedStatement(qq_SQL);
            qq_rs = qq_cmd.executeQuery();
            ResultSetHelper qq_rsHelper = new ResultSetHelper(qq_rs);
            while (qq_rsHelper.next()) {
                TextData temp = qq_rsHelper.getTextData(1);
                ListElement row = new ListElement();
                row.getTextValue().setValue( temp.getValue() );
                this.stockNameList.add(row);
            }
        }

View Full Code Here

TOP

Related Classes of GenericDBMS.ResultSetHelper

Framework.BinaryData

Framework.BinaryNullable

Framework.BooleanData

Framework.BooleanNullable

Framework.DataValue

Framework.DateTimeData

Framework.DateTimeNullable

Framework.DecimalData

Framework.DecimalNullable

Framework.DoubleData

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.