Package net.sourceforge.squirrel_sql.fw.datasetviewer

Examples of net.sourceforge.squirrel_sql.fw.datasetviewer.ResultSetDataSet

1634
1635
1636
1637
1638
1639
1640
1641
1642
1643
1644
1645
    ResultSet rs = null;
    try
    {
      DatabaseMetaData md = privateGetJDBCMetaData();
      rs = md.getTablePrivileges(ti.getCatalogName(), ti.getSchemaName(), ti.getSimpleName());
      ResultSetDataSet rsds = new ResultSetDataSet();
      rsds.setResultSet(rs, columnIndices, computeWidths, DialectFactory.getDialectType(this));
      return rsds;
    }
    catch (SQLException e)
    {
      throw new DataSetException(e);
View Full Code Here
1671
1672
1673
1674
1675
1676
1677
1678
1679
1680
1681
1682
    ResultSet rs = null;
    try
    {
      DatabaseMetaData md = privateGetJDBCMetaData();
      rs = md.getVersionColumns(ti.getCatalogName(), ti.getSchemaName(), ti.getSimpleName());
      ResultSetDataSet rsds = new ResultSetDataSet();
      rsds.setResultSet(rs, DialectFactory.getDialectType(this));
      return rsds;
    }
    catch (SQLException e)
    {
      throw new DataSetException(e);
View Full Code Here
1703
1704
1705
1706
1707
1708
1709
1710
1711
1712
1713
1714
    IDataSet result = null;
    ResultSet rs = null;
    try
    {
      rs = getColumns(ti);
      ResultSetDataSet rsds = new ResultSetDataSet();
      rsds.setResultSet(rs, columnIndices, computeWidths, DialectFactory.getDialectType(this));
      result = rsds;
    }
    catch (SQLException e)
    {
      throw new DataSetException(e);
View Full Code Here
391
392
393
394
395
396
397
398
399
400
401
402
403
404
405
       
        ISQLConnection conn = _session.getSQLConnection();
        SQLDatabaseMetaData metaData = conn.getSQLMetaData();
       
        try {
            ResultSetDataSet rsds =
                metaData.getIndexInfo(tableInfo, indexColumnIndices, false);
            String indexName = "";
            while (rsds.next(null)) {
                String thisIndexName = (String)rsds.get(0);
                if (thisIndexName != null) {
                    if (!indexName.equals(thisIndexName)) {
                        listener.indexSpotted(tableInfo,thisIndexName);
                        indexName = thisIndexName;
                    }
View Full Code Here
60
61
62
63
64
65
66
67
68
69
70
71
        try
        {
            ISQLConnection con = session.getSQLConnection();
            Statement stmt = con.createStatement();
            ResultSet rs = stmt.executeQuery(QUERY);
            ResultSetDataSet rsds = new ResultSetDataSet();
            rsds.setResultSet(rs, DialectType.POSTGRES);
            return rsds;
        }
        catch (SQLException ex)
        {
            throw new DataSetException(ex);
View Full Code Here
342
343
344
345
346
347
348
349
350
351
352
353
    public void sqlResultSetAvailable(ResultSet rs, SQLExecutionInfo info,
      IDataSetUpdateableTableModel model) throws DataSetException
    {

      ResultSetDataSet rsds = new ResultSetDataSet();
      rsds.setResultSet(rs, _dialectType);

      if (_tabToReplace != null)
      {
        _tabToReplace.reInit(rsds, info, model);
      } else
View Full Code Here
125
126
127
128
129
130
131
132
133
134
135
136
137
138
      if (!_haveSession) {
        try {
           _conn = this.getSession().getSQLConnection().getConnection();

           _whoStmt = _conn.prepareCall("{ call sp_who }");
           _whoDataSet = new ResultSetDataSet();

           _perfStmt = _conn.prepareStatement("SELECT * FROM master.dbo.sysperfinfo");
           _perfDataSet = new ResultSetDataSet();

           _monitorStmt = _conn.prepareCall("{ call sp_monitor }");

           _haveSession = true;
        }
View Full Code Here
149
150
151
152
153
154
155
156
157
158
159
160
161
162
163
164
165
166
167
168
169
170
171
172
  protected abstract String getSQL() throws SQLException;

  protected IDataSet createDataSetFromResultSet(ResultSet rs)
    throws DataSetException
  {
    final ResultSetDataSet rsds = new ResultSetDataSet();
    rsds.setResultSet(rs, DialectType.MYSQL);
    if (!_firstRowOnly)
    {
      return rsds;
    }

    final int columnCount = rsds.getColumnCount();
    final ColumnDisplayDefinition[] colDefs = rsds.getDataSetDefinition().getColumnDefinitions();
    final Map<String, Object> data = new HashMap<String, Object>();
    if (rsds.next(null))
    {
      for (int i = 0; i < columnCount; ++i)
      {
        data.put(colDefs[i].getColumnName(), rsds.get(i));
      }
    }
    return new MapDataSet(data);
  }
View Full Code Here
TOP

Related Classes of net.sourceforge.squirrel_sql.fw.datasetviewer.ResultSetDataSet

  • net.sourceforge.squirrel_sql.client.session.mainpanel.objecttree.tabs.BasePreparedStatementTab
  • net.sourceforge.squirrel_sql.client.session.mainpanel.objecttree.tabs.table.ContentsTab
  • net.sourceforge.squirrel_sql.client.session.mainpanel.objecttree.tabs.table.IndexesTab
  • net.sourceforge.squirrel_sql.client.session.mainpanel.objecttree.tabs.table.RowCountTab
  • net.sourceforge.squirrel_sql.fw.sql.ResultSetReader
  • net.sourceforge.squirrel_sql.fw.sql.SQLDatabaseMetaData
  • net.sourceforge.squirrel_sql.plugins.mssql.gui.MonitorPanel
  • net.sourceforge.squirrel_sql.plugins.mssql.MssqlPlugin
  • net.sourceforge.squirrel_sql.plugins.mysql.tab.BaseSQLTab
  • net.sourceforge.squirrel_sql.plugins.postgres.explain.ExplainExecuterPanel$SQLExecutionHandler
    • 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.