Package net.sourceforge.squirrel_sql.fw.sql

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

53
54
55
56
57
58
59
60
61
62
63
64
65
66
67
68
69
70
71
72
73
   *      nodes for the passed node.
   */
  public List<ObjectTreeNode> createChildren(ISession session, ObjectTreeNode parentNode)
  {
    final List<ObjectTreeNode> childNodes = new ArrayList<ObjectTreeNode>();
    final IDatabaseObjectInfo parentDbinfo = parentNode.getDatabaseObjectInfo();
    final SQLDatabaseMetaData md = session.getSQLConnection().getSQLMetaData();
    final String schemaName = parentDbinfo.getSchemaName();

    IDatabaseObjectInfo dbinfo = new TriggerParentInfo(parentDbinfo,
                      schemaName, md);
   
    ObjectTreeNode child = new ObjectTreeNode(session, dbinfo);
    childNodes.add(child);
   
    IDatabaseObjectInfo cstrinfo = new ConstraintParentInfo(parentDbinfo,
        schemaName, md);
   
    child = new ObjectTreeNode(session, cstrinfo);
    childNodes.add(child);
   
View Full Code Here
48
49
50
51
52
53
54
55
56
    * @return  A list of <TT>ObjectTreeNode</TT> objects representing the child
    *      nodes for the passed node.
    */
   public List<ObjectTreeNode> createChildren(ISession session, ObjectTreeNode parentNode)
   {
      final IDatabaseObjectInfo parentDbinfo = parentNode.getDatabaseObjectInfo();
      final String schemaName = parentDbinfo.getSchemaName();
      return createProcedureNodes(session, null, schemaName);
   }
View Full Code Here
45
46
47
48
49
50
51
52
53
54
   * @return  A list of <TT>ObjectTreeNode</TT> objects representing the child
   *      nodes for the passed node.
   */
  public List<ObjectTreeNode> createChildren(ISession session, ObjectTreeNode parentNode)
  {
    final IDatabaseObjectInfo parentDbinfo = parentNode.getDatabaseObjectInfo();
    final String schemaName = parentDbinfo.getSchemaName();
    final String packageName = parentDbinfo.getSimpleName();
    return createProcedureNodes(session, packageName, schemaName);
  }
View Full Code Here
79
80
81
82
83
84
85
86
87
88
89
    {
      pstmt = conn.prepareStatement(SQL);
      rs = pstmt.executeQuery();
      while (rs.next())
      {
        IDatabaseObjectInfo doi = new DatabaseObjectInfo(
           null, null, rs.getString(1), IObjectTypes.INSTANCE, md);
        // final Map map = new HashMap();
        // map.put("Instance Number", new Integer(rs.getInt(1)));
        // map.put("Name", rs.getString(2));
        // map.put("Host Name", rs.getString(3));
View Full Code Here
62
63
64
65
66
67
68
69
70
71
72
73
74
75
76
77
   */
  public List<ObjectTreeNode> createChildren(ISession session, ObjectTreeNode parentNode)
    throws SQLException
  {
    final List<ObjectTreeNode> childNodes = new ArrayList<ObjectTreeNode>();
    final IDatabaseObjectInfo parentDbinfo = parentNode.getDatabaseObjectInfo();
    final SQLDatabaseMetaData md = session.getSQLConnection().getSQLMetaData();
    final String schemaName = parentDbinfo.getSchemaName();

    // Add package node to contain standalone procedures.
    IDatabaseObjectInfo dbinfo = new DatabaseObjectInfo(null, schemaName,
                        "", IObjectTypes.PACKAGE, md);
    ObjectTreeNode child = new ObjectTreeNode(session, dbinfo);
    child.setUserObject("Standalone");
    childNodes.add(child);

View Full Code Here
78
79
80
81
82
83
84
85
86
87
88
   */
  public List<ObjectTreeNode> createChildren(ISession session, ObjectTreeNode parentNode)
    throws SQLException
  {
    final List<ObjectTreeNode> childNodes = new ArrayList<ObjectTreeNode>();
    final IDatabaseObjectInfo parentDbinfo = parentNode.getDatabaseObjectInfo();
    final String catalogName = parentDbinfo.getCatalogName();
    final String schemaName = parentDbinfo.getSchemaName();
    childNodes.addAll(createNodes(session, catalogName, schemaName));
    return childNodes;
  }
View Full Code Here
106
107
108
109
110
111
112
113
114
115
116
117
118
119
120
      ResultSet rs = pstmt.executeQuery();
      try
      {
        while (rs.next())
        {
          IDatabaseObjectInfo dbinfo = new DatabaseObjectInfo(catalogName,
                      schemaName, rs.getString(1),
                      _objectType._childDboType, md);

               if(filterMatcher.matches(dbinfo.getSimpleName()))
               {
                  childNodes.add(new ObjectTreeNode(session, dbinfo));
               }
            }
      }
View Full Code Here
29
30
31
32
33
34
35
36
37
38
  protected PreparedStatement createStatement() throws SQLException
  {
    ISession session = getSession();
    PreparedStatement pstmt = session.getSQLConnection().prepareStatement(SQL);
    IDatabaseObjectInfo doi = getDatabaseObjectInfo();
    pstmt.setString(1, doi.getSchemaName());
    pstmt.setString(2, doi.getSimpleName());
    return pstmt;
  }
View Full Code Here
73
74
75
76
77
78
79
80
81
   */
  protected PreparedStatement createStatement() throws SQLException
  {
    ISession session = getSession();
    PreparedStatement pstmt = session.getSQLConnection().prepareStatement(SQL);
    IDatabaseObjectInfo doi = getDatabaseObjectInfo();
    pstmt.setLong(1, Long.parseLong(doi.getSimpleName()));
    return pstmt;
  }
View Full Code Here
60
61
62
63
64
65
66
67
68
69
  protected PreparedStatement createStatement() throws SQLException
  {
    ISession session = getSession();
    PreparedStatement pstmt = session.getSQLConnection().prepareStatement(SQL);
    IDatabaseObjectInfo doi = getDatabaseObjectInfo();
    pstmt.setString(1, doi.getSchemaName());
    pstmt.setString(2, doi.getSimpleName());
    return pstmt;
  }
View Full Code Here
TOP

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

  • net.sourceforge.squirrel_sql.client.session.action.CopyObjectNameCommand
  • net.sourceforge.squirrel_sql.client.session.action.EditWhereColsAction
  • net.sourceforge.squirrel_sql.client.session.action.SQLFilterAction
  • net.sourceforge.squirrel_sql.client.session.mainpanel.objecttree.expanders.DatabaseExpander
  • net.sourceforge.squirrel_sql.client.session.mainpanel.objecttree.expanders.SchemaExpander
  • net.sourceforge.squirrel_sql.client.session.mainpanel.objecttree.expanders.TableWithChildNodesExpander
  • net.sourceforge.squirrel_sql.client.session.mainpanel.objecttree.expanders.TriggerParentExpander
  • net.sourceforge.squirrel_sql.client.session.mainpanel.objecttree.ObjectTree$TreeLoader
  • net.sourceforge.squirrel_sql.plugins.db2.tab.TableSourceTab
  • net.sourceforge.squirrel_sql.plugins.mssql.gui.GenerateSqlDialog
    • 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.