Examples of com.scooterframework.orm.sqldataexpress.object.TableData

Package com.scooterframework.orm.sqldataexpress.object

Examples of com.scooterframework.orm.sqldataexpress.object.TableData

com.scooterframework.orm.sqldataexpress.object.TableData
TableData class contains table data which consists of both header and body. The header, represented by RowInfo, is the meta data about the columns. The body is a list of RowData objects. @author (Fei) John Chen

     * @param sql       a SQL statement
     * @param inputs    a map of name and value pairs
     * @return a RowData object returned from the database.
     */
    public static RowData retrieveOneRowBySQL(String sql, Map<String, Object> inputs) {
        TableData td = retrieveTableDataBySQL(sql, inputs);
        if (td != null) return td.getFirstRow();
        return null;
    }

View Full Code Here

    
    private static Object processResult(OmniDTO returnTO, String name) {
        Object returnObj = null;
        
        if ( returnTO != null ) {
            TableData rt = returnTO.getTableData(name);
            if (rt != null) {
                returnObj = rt.getFirstObject();
            }
        }
        
        return returnObj;
    }

View Full Code Here

                    
                    Cursor cursor = sp.getCursor(p.getName(), rs);
                    int cursorWidth = cursor.getDimension();
                    
                    Set<String> allowedColumns = getAllowedColumns(outputFilter, cursor);
                    TableData rt = new TableData();
                    RowInfo newHeader = getFilteredHeaderInfo(allowedColumns, cursor);
                    rt.setHeader(newHeader);
                    returnTO.addTableData(p.getName(), rt);
                    
                    while(rs.next()) {
                        ArrayList<Object> cellValues = new ArrayList<Object>();
                        for (int i = 0; i < cursorWidth; i++) {
                            if (outputFilter.containsKey(cursor.getColumnName(i))) {
                                cellValues.add(dba.getObjectFromResultSetByType(rs, 
                                                                            cursor.getColumnJavaClassName(i), 
                                                                            cursor.getColumnSqlDataType(i),
                                                                            i+1));
                            }
                        }
                        
                        if (cellValues.size() > 0) 
                            rt.addRow(new RowData(newHeader, cellValues.toArray()));
                    }
                    rs.close();
                } 
                else {
                    if (outputFilter.containsKey(p.getName())) {

View Full Code Here

      String stName, OmniDTO returnTO, ResultSet rs, Map<String, ?> inputs)
    throws SQLException {
        Cursor cursor = jstat.getCursor(stName, rs);
        int cursorWidth = cursor.getDimension();
        
        TableData rt = new TableData();
        rt.setHeader(cursor);
        returnTO.addTableData(stName, rt);
        
        while(rs.next()) {
            Object[] cellValues = new Object[cursorWidth];
            for (int i = 0; i < cursorWidth; i++) {
        cellValues[i] = dba.getObjectFromResultSetByType(rs,
            cursor.getColumnJavaClassName(i),
            cursor.getColumnSqlDataType(i), i + 1);
            }
            rt.addRow(new RowData(cursor, cellValues));
        }
        rs.close();
    }

View Full Code Here

    throws SQLException {
        Cursor cursor = jstat.getCursor(stName, rs);
        int cursorWidth = cursor.getDimension();
        
        Set<String> allowedColumns = getAllowedColumns(outputs, cursor);
        TableData rt = new TableData();
        RowInfo newHeader = getFilteredHeaderInfo(allowedColumns, cursor);
        rt.setHeader(newHeader);
        returnTO.addTableData(stName, rt);
        
        while(rs.next()) {
            ArrayList<Object> cellValues = new ArrayList<Object>();
            for (int i = 0; i < cursorWidth; i++) {
                if (allowedColumns.contains(cursor.getColumnName(i))) {
          cellValues.add(dba.getObjectFromResultSetByType(rs,
              cursor.getColumnJavaClassName(i),
              cursor.getColumnSqlDataType(i), i + 1));
                }
            }
            
            if (cellValues.size() > 0) 
                rt.addRow(new RowData(newHeader, cellValues.toArray()));
        }
        rs.close();
    }

View Full Code Here

            
            OmniDTO returnTO = 
                getSqlService().execute(inputs, DataProcessorTypes.DIRECT_SQL_STATEMENT_PROCESSOR, findSQL);
            
            if ( returnTO != null ) {
                TableData rt = returnTO.getTableData(findSQL);
                if (rt != null) {
                    returnObj = rt.getFirstObject();
                }
            }
        }
        catch (Exception ex) {
            throw new RelationException(ex);

View Full Code Here

0 1 2

TOP

Related Classes of com.scooterframework.orm.sqldataexpress.object.TableData

com.scooterframework.builtin.databrowser.Record

com.scooterframework.builtin.databrowser.TableSqlPageListSource

com.scooterframework.orm.activerecord.AssociatedRecordsHM

com.scooterframework.orm.activerecord.TableGateway

com.scooterframework.orm.sqldataexpress.processor.JdbcStatementProcessor

com.scooterframework.orm.sqldataexpress.processor.StoredProcedureProcessor

com.scooterframework.orm.sqldataexpress.service.SqlServiceClient

com.scooterframework.orm.sqldataexpress.service.SqlServiceClientTest

com.scooterframework.orm.sqldataexpress.service.SqlServiceImpl

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.