Package net.sourceforge.squirrel_sql.fw.sql

Examples of net.sourceforge.squirrel_sql.fw.sql.ISQLConnection

65
66
67
68
69
70
71
72
73
74
75
76
77
78
79
80
81
82
83
84
   */
  public List<ObjectTreeNode> createChildren(ISession session, ObjectTreeNode parentNode)
    throws SQLException
  {
    final List<ObjectTreeNode> childNodes = new ArrayList<ObjectTreeNode>();
    final ISQLConnection conn = session.getSQLConnection();
    final SQLDatabaseMetaData md = session.getSQLConnection().getSQLMetaData();
    final IDatabaseObjectInfo parentDbinfo = parentNode.getDatabaseObjectInfo();
    final String schemaName = parentDbinfo.getSchemaName();

    PreparedStatement pstmt = null;
    ResultSet rs = null;
    try
    {
      pstmt = conn.prepareStatement(SQL);
      rs = pstmt.executeQuery();
      while (rs.next())
      {
        // There is a reason that we don't want to use DatabaseObjectType.SESSION here.  The "session"
        // nodes that this expander is creating should not be confused with the SQuirreL session.  These
View Full Code Here
81
82
83
84
85
86
87
88
89
90
91
92
  public String[] getColumnNames()
  {
    String[] columnNames = null;
    try
    {
      final ISQLConnection conn = _session.getSQLConnection();
      Statement stmt = conn.createStatement();
      ResultSet rs =
        stmt.executeQuery("SELECT * FROM " + getTableInfo() + ";");
      ResultSetMetaData md = rs.getMetaData();
      columnNames = new String[md.getColumnCount()];
      for (int i = 0; i < columnNames.length; i++)
View Full Code Here
105
106
107
108
109
110
111
112
113
114
115
116
  {
    String[] dataTypes = null;

    try
    {
      final ISQLConnection conn = _session.getSQLConnection();
      Statement stmt = conn.createStatement();
      ResultSet rs =
        stmt.executeQuery("SELECT * FROM " + getTableInfo() + ";");
      ResultSetMetaData md = rs.getMetaData();

      dataTypes = new String[md.getColumnCount()];
View Full Code Here
129
130
131
132
133
134
135
136
137
138
139
140
  public void execute(String SQLQuery)
  {
    try
    {

      ISQLConnection conn = _session.getSQLConnection();
      Statement stmt = conn.createStatement();
      stmt.execute(SQLQuery);
    }
    catch (SQLException ex)
    {
      _session.showErrorMessage(ex);
View Full Code Here
146
147
148
149
150
151
152
153
154
155
156
157
  {

    Vector<String> dataTypes = new Vector<String>();
    try
    {
      final ISQLConnection conn = _session.getSQLConnection();
      SQLDatabaseMetaData dmd = conn.getSQLMetaData();
      DataTypeInfo[] infos = dmd.getDataTypes();
            for (int i = 0; i < infos.length; i++) {
                dataTypes.add(infos[i].getSimpleName());
            }
    }
View Full Code Here
166
167
168
169
170
171
172
173
174
175
176
177
  {

    String primaryKey = "";
    try
    {
      ISQLConnection con = _session.getSQLConnection();
      SQLDatabaseMetaData db = con.getSQLMetaData();
            PrimaryKeyInfo[] infos = db.getPrimaryKey(getTableInfo());
            for (int i=0; i < infos.length; i++) {
                primaryKey = infos[i].getColumnName();
            }
    }
View Full Code Here
418
419
420
421
422
423
424
425
426
427
428
429
430
431
432
433
  }

  private void btCreateTableActionPerformed(java.awt.event.ActionEvent evt)
  {
    ISQLConnection con = _session.getSQLConnection();
    String query = getQuery();
    Statement stmt = null;
    try
    {
      stmt = con.createStatement();
      stmt.execute(query);
      _session.getSessionInternalFrame().getObjectTreeAPI().refreshTree();
      jd.setVisible(false);
      jd.dispose();
      JOptionPane.showMessageDialog(null,
View Full Code Here
65
66
67
68
69
70
71
72
73
74
75
76
77
78
  public List<ObjectTreeNode> createChildren(ISession session, ObjectTreeNode parentNode)
    throws SQLException
  {
    final List<ObjectTreeNode> childNodes = new ArrayList<ObjectTreeNode>();
    final IDatabaseObjectInfo parentDbinfo = parentNode.getDatabaseObjectInfo();
    final ISQLConnection conn = session.getSQLConnection();
    final SQLDatabaseMetaData md = session.getSQLConnection().getSQLMetaData();
    final IDatabaseObjectInfo tableInfo = ((TriggerParentInfo)parentDbinfo).getTableInfo();
    final PreparedStatement pstmt = conn.prepareStatement(SQL);
    try
    {
      pstmt.setString(1, tableInfo.getSchemaName());
      pstmt.setString(2, tableInfo.getSimpleName());
      ResultSet rs = pstmt.executeQuery();
View Full Code Here
71
72
73
74
75
76
77
78
79
80
81
    {
      s_log.debug("Running SQL: " + SQL);
      s_log.debug("Trigger Name=" + doi.getSimpleName());
      s_log.debug("Schema Name=" + doi.getSchemaName());
    }
    ISQLConnection conn = session.getSQLConnection();
    PreparedStatement pstmt = conn.prepareStatement(SQL);
    pstmt.setString(1, doi.getSimpleName());
    pstmt.setString(2, doi.getSchemaName());
    return pstmt;
  }
View Full Code Here
198
199
200
201
202
203
204
205
206
207
208
    throws SQLException
  {
    _dataTypesByTypeName = new HashMap<String, DataTypeInfo>();
    _mediator = new ControlMediator();

    final ISQLConnection conn = session.getSQLConnection();

    _columnsCmb = new ColumnsComboBox(conn, ti);

    _dataTypesCmb = new DataTypesComboBox(conn);
    for (int i = 0, limit = _dataTypesCmb.getItemCount(); i < limit; ++i)
View Full Code Here
TOP

Related Classes of net.sourceforge.squirrel_sql.fw.sql.ISQLConnection

  • net.sourceforge.squirrel_sql.client.AppTestUtil
  • net.sourceforge.squirrel_sql.client.gui.session.CatalogsPanel
  • net.sourceforge.squirrel_sql.client.session.action.DumpSessionCommand
  • net.sourceforge.squirrel_sql.client.session.DataSetUpdateableTableModelImpl
  • net.sourceforge.squirrel_sql.client.session.mainpanel.objecttree.expanders.DatabaseExpander
  • net.sourceforge.squirrel_sql.client.session.mainpanel.objecttree.expanders.IndexParentExpander
  • net.sourceforge.squirrel_sql.client.session.mainpanel.objecttree.expanders.SequenceParentExpander
  • net.sourceforge.squirrel_sql.client.session.mainpanel.objecttree.expanders.TableTypeExpander
  • net.sourceforge.squirrel_sql.client.session.mainpanel.objecttree.expanders.TriggerParentExpander
  • net.sourceforge.squirrel_sql.client.session.mainpanel.objecttree.expanders.UDTTypeExpander
    • 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.