Package java.sql

Examples of java.sql.ResultSetMetaData

2295
2296
2297
2298
2299
2300
2301
2302
2303
2304
2305
            schemaPattern = PERCENT;
        }
        // list which represent records containing schema info
        List records = new ArrayList ();

        ResultSetMetaData rmetadata = null;
        ResultSetImpl results = null;
        PreparedStatementImpl prepareQuery = null;
        try {
            prepareQuery = driverConnection.prepareStatement(QUERY_SCHEMAS);
            prepareQuery.setObject(1, catalog.toUpperCase());
View Full Code Here
275
276
277
278
279
280
281
282
283
284
285
286
  private Vector executeQuery(String query, ArrayList bindObjects) throws Exception
  {
    try {
      prepareQuery(query, bindObjects);
      ResultSet resultSet = dataAccessLayer.executeQueryNonParsed();
      ResultSetMetaData metaData = resultSet.getMetaData();
      int size = metaData.getColumnCount();
      Vector result = new Vector();
      ArrayList resultItem = null;
      while (resultSet.next()) {
        resultItem = new ArrayList();
        for (int i = 0; i < size; ++i) {
View Full Code Here
379
380
381
382
383
384
385
386
387
388
389
390
391
392
393
394
395
396
397
398
399
      try {
        String query = getQueryForResultReport(userId, reportId, search, dataAccessLayer);

        dataAccessLayer.setSqlQuery(query);
        resultSet = dataAccessLayer.executeQueryNonParsed();
        ResultSetMetaData metaData = resultSet.getMetaData();
        int cols = metaData.getColumnCount();
        int i = 0;
        boolean exclude = false;
        boolean[] isDate = new boolean[cols + 1];
        for (i = 1; i <= cols; i++) {
          isDate[i] = false;
        }
        for (i = 1; i <= cols; i++) {
          if ((Types.DATE == metaData.getColumnType(i) || Types.TIMESTAMP == metaData.getColumnType(i))
              && !metaData.getColumnName(i).equalsIgnoreCase("Modified") && !metaData.getColumnName(i).equalsIgnoreCase("Created")) {
            isDate[i] = true;
          }
        } // end for ( i = 1; i <= cols; i++)

        while (resultSet.next()) {
View Full Code Here
92
93
94
95
96
97
98
99
100
101
102
103
104
105
106
107
108
109
110
111
112
113
114
115
116
117
118
119
120
121
122
123
124
125
126
127
128
129
130
131
132
133
134
135
136
137
138
   */
  private String getDisplayableResultSetRow() {
    StringBuffer displayableResultSetRow = new StringBuffer();

    try {
      ResultSetMetaData md = real.getMetaData();
      for ( int i = 1; i <= md.getColumnCount(); i++) {
        displayableResultSetRow.append(md.getColumnName(i))
          .append('=');
        switch ( md.getColumnType(i)) {
          case Types.ARRAY:
          case Types.BLOB:
          case Types.CHAR:
          case Types.CLOB:
          case Types.DATALINK:
          case Types.DATE:
          case Types.JAVA_OBJECT:
          case Types.LONGVARBINARY:
          case Types.LONGVARCHAR:
          case Types.REF:
          case Types.TIME:
          case Types.TIMESTAMP:
          case Types.VARBINARY:
          case Types.VARCHAR:      if ( real.getString(i)!=null) {
                          displayableResultSetRow.append('\'').append(real.getString(i)).append('\'');
                        } else {
                          displayableResultSetRow.append("NULL");
                        }
                        break;
          case Types.NULL:      displayableResultSetRow.append("NULL");
                        break;
          default:          if ( real.getString(i)!=null) {
                          displayableResultSetRow.append(real.getString(i));
                        } else {
                          displayableResultSetRow.append("NULL");
                        }
                        break;
        }

        displayableResultSetRow.append(',');
      }
      if ( md.getColumnCount() >= 1) {
        displayableResultSetRow.deleteCharAt(displayableResultSetRow.length()-1);
      }
    } catch ( SQLException e) {
      if ( log.isErrorEnabled()) log.error(getId()+":unable to display resultset row",e);
    }
View Full Code Here
371
372
373
374
375
376
377
378
379
380
381
382
383
    // We run the query to get meta-information about the columns.
    @SuppressWarnings("unused") Class<?> jdbcDriver = Class.forName( jsapResult.getString( "jdbcDriver" ) );
    Connection connection = DriverManager.getConnection( jsapResult.getString( "dburi" ) );
    Statement s = connection.createStatement();
    ResultSet rs = s.executeQuery( "SELECT " + jsapResult.getString( "select" ) );
    ResultSetMetaData metaData = rs.getMetaData();   
    String[] column = new String[ metaData.getColumnCount() - 2 ];
    for( int i = 3; i <= metaData.getColumnCount(); i++ ) column[ i - 3 ] = metaData.getColumnName( i );
    rs.close();
    s.close();
    connection.close();
   
    final DocumentFactory[] factory = new DocumentFactory[ column.length ];
View Full Code Here
312
313
314
315
316
317
318
319
320
321
322
323
324
325
326
327
328
329
330
331
332
333
334
335
336
      (final ResultSet rs, final boolean labelMapping)
      throws SQLException
  {
    try
    {
      final ResultSetMetaData rsmd = rs.getMetaData();
      final int colcount = rsmd.getColumnCount();
      final Object[] header = new Object[colcount];
      final Class[] colTypes = TypeMapper.mapTypes(rsmd);
      final DefaultTableMetaData metaData = new DefaultTableMetaData(colcount);
      for (int i = 0; i < colcount; i++)
      {
        if (labelMapping)
        {
          final String name = rsmd.getColumnLabel(i + 1);
          header[i] = name;
        }
        else
        {
          final String name = rsmd.getColumnName(i + 1);
          header[i] = name;
        }

        ResultSetTableModelFactory.updateMetaData(rsmd, metaData, i);
      }
View Full Code Here
93
94
95
96
97
98
99
100
101
102
103
104
105
106
    }
    return results;
  }

  protected void saveMetaData(ResultSet rs) throws SQLException {
    ResultSetMetaData metadata = rs.getMetaData();
    columnCount = metadata.getColumnCount();
    columnNames = new String[columnCount];
    columnTypes = new int[columnCount];
    for (int col = 1; col <= columnCount; ++col) {
      columnNames[col - 1] = metadata.getColumnName(col);
      columnTypes[col - 1] = metadata.getColumnType(col);
    }
  }
View Full Code Here
162
163
164
165
166
167
168
169
170
171
172
173
174
175
176
177
            if (module.isAbstract()) continue;
           
            try {
                String sql = "select top 1 * from " + module.getTableName();
                ResultSet rs = DatabaseManager.executeSQL(sql);
                ResultSetMetaData md = rs.getMetaData();
               
                String columnName;
                boolean remove;
                for (int i = 1; i < md.getColumnCount() + 1; i++) {
                  columnName = md.getColumnName(i);
                  remove = false;
                 
                    if (!columnName.startsWith("_KEEP_")) {
                        for (DcField field : module.getFields()) {
                            if (columnName.equalsIgnoreCase(field.getDatabaseFieldName()))
View Full Code Here
298
299
300
301
302
303
304
305
306
307
308
309
310
311
312
313
314
315
316
317
318
319
320
321
322
323
324
325
326
327
328
329
330
331
332
333
334
335
336
337
338
339
340
341
342
343
344
345
346
347
348
349
350
351
352
353
354
355
356
357
358
359
360
361
362
363
364
365
366
367
368
369
370
371
372
373
374
375
376
                if (p == null) {
                    sendErrorResponse("Portal not found: " + name);
                } else {
                    PreparedStatement prep = p.prep.prep;
                    try {
                        ResultSetMetaData meta = prep.getMetaData();
                        sendRowDescription(meta);
                    } catch (Exception e) {
                        sendErrorResponse(e);
                    }
                }
            } else {
                server.trace("expected S or P, got " + type);
                sendErrorResponse("expected S or P");
            }
            break;
        }
        case 'E': {
            String name = readString();
            server.trace("Execute");
            Portal p = portals.get(name);
            if (p == null) {
                sendErrorResponse("Portal not found: " + name);
                break;
            }
            int maxRows = readShort();
            Prepared prepared = p.prep;
            JdbcPreparedStatement prep = prepared.prep;
            server.trace(prepared.sql);
            try {
                prep.setMaxRows(maxRows);
                boolean result = prep.execute();
                if (result) {
                    try {
                        ResultSet rs = prep.getResultSet();
                        ResultSetMetaData meta = rs.getMetaData();
                        sendRowDescription(meta);
                        while (rs.next()) {
                            sendDataRow(rs);
                        }
                        sendCommandComplete(prep, 0);
                    } catch (Exception e) {
                        sendErrorResponse(e);
                    }
                } else {
                    sendCommandComplete(prep, prep.getUpdateCount());
                }
            } catch (Exception e) {
                sendErrorResponse(e);
            }
            break;
        }
        case 'S': {
            server.trace("Sync");
            sendReadyForQuery();
            break;
        }
        case 'Q': {
            server.trace("Query");
            String query = readString();
            ScriptReader reader = new ScriptReader(new StringReader(query));
            while (true) {
                JdbcStatement stat = null;
                try {
                    String s = reader.readStatement();
                    if (s == null) {
                        break;
                    }
                    s = getSQL(s);
                    stat = (JdbcStatement) conn.createStatement();
                    boolean result = stat.execute(s);
                    if (result) {
                        ResultSet rs = stat.getResultSet();
                        ResultSetMetaData meta = rs.getMetaData();
                        try {
                            sendRowDescription(meta);
                            while (rs.next()) {
                                sendDataRow(rs);
                            }
View Full Code Here
82
83
84
85
86
87
88
89
90
91
92
93
94
95
96
97
        return new Csv();
    }

    private int writeResultSet(ResultSet rs) throws SQLException {
        try {
            ResultSetMetaData meta = rs.getMetaData();
            int rows = 0;
            int columnCount = meta.getColumnCount();
            String[] row = new String[columnCount];
            for (int i = 0; i < columnCount; i++) {
                row[i] = meta.getColumnLabel(i + 1);
            }
            writeRow(row);
            while (rs.next()) {
                for (int i = 0; i < columnCount; i++) {
                    row[i] = rs.getString(i + 1);
View Full Code Here
TOP

Related Classes of java.sql.ResultSetMetaData

  • au.com.bytecode.opencsv_voltpatches.ResultSetHelperService
  • ca.carleton.gcrc.contributions.Contributions
  • cn.org.rapid_framework.generator.provider.db.table.TableFactory
  • com.alibaba.druid.filter.encoding.EncodingConvertFilter
  • com.alibaba.druid.filter.logging.LogFilter
  • com.alibaba.druid.filter.trace.TraceFilter
  • com.alibaba.druid.util.JdbcUtils
  • com.alibaba.wasp.jdbc.TestJdbcBase
  • com.alibaba.wasp.jdbc.TestJdbcResultSet
  • com.bleujin.framework.db.bean.BasicRowProcessor
    • Copyright © 2018 www.massapicom. All rights reserved.
    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.