001: /*
002: * DO NOT ALTER OR REMOVE COPYRIGHT NOTICES OR THIS HEADER.
003: *
004: * Copyright 1997-2007 Sun Microsystems, Inc. All rights reserved.
005: *
006: * The contents of this file are subject to the terms of either the GNU
007: * General Public License Version 2 only ("GPL") or the Common
008: * Development and Distribution License("CDDL") (collectively, the
009: * "License"). You may not use this file except in compliance with the
010: * License. You can obtain a copy of the License at
011: * http://www.netbeans.org/cddl-gplv2.html
012: * or nbbuild/licenses/CDDL-GPL-2-CP. See the License for the
013: * specific language governing permissions and limitations under the
014: * License. When distributing the software, include this License Header
015: * Notice in each file and include the License file at
016: * nbbuild/licenses/CDDL-GPL-2-CP. Sun designates this
017: * particular file as subject to the "Classpath" exception as provided
018: * by Sun in the GPL Version 2 section of the License file that
019: * accompanied this code. If applicable, add the following below the
020: * License Header, with the fields enclosed by brackets [] replaced by
021: * your own identifying information:
022: * "Portions Copyrighted [year] [name of copyright owner]"
023: *
024: * Contributor(s):
025: *
026: * The Original Software is NetBeans. The Initial Developer of the Original
027: * Software is Sun Microsystems, Inc. Portions Copyright 1997-2006 Sun
028: * Microsystems, Inc. All Rights Reserved.
029: *
030: * If you wish your version of this file to be governed by only the CDDL
031: * or only the GPL Version 2, indicate your decision by adding
032: * "[Contributor] elects to include this software in this distribution
033: * under the [CDDL or GPL Version 2] license." If you do not indicate a
034: * single choice of license, a recipient has the option to distribute
035: * your version of this file under either the CDDL, the GPL Version 2 or
036: * to extend the choice of license to its licensees as provided above.
037: * However, if you add GPL Version 2 code and therefore, elected the GPL
038: * Version 2 license, then the option applies only if the new code is
039: * made subject to such option by the copyright holder.
040: */
041:
042: package org.netbeans.modules.db.explorer.infos;
043:
044: import java.io.IOException;
045: import java.sql.ResultSet;
046: import java.util.Vector;
047: import org.netbeans.api.db.explorer.DatabaseException;
048: import org.netbeans.lib.ddl.impl.AbstractCommand;
049: import org.netbeans.lib.ddl.impl.DriverSpecification;
050: import org.netbeans.lib.ddl.impl.Specification;
051: import org.netbeans.modules.db.explorer.nodes.DatabaseNode;
052:
053: public class ViewNodeInfo extends DatabaseNodeInfo {
054: static final long serialVersionUID = 8370676447530973161L;
055:
056: public void initChildren(Vector children) throws DatabaseException {
057: try {
058: String view = (String) get(DatabaseNode.VIEW);
059:
060: // Columns
061: DriverSpecification drvSpec = getDriverSpecification();
062: drvSpec.getColumns(view, "%");
063:
064: ResultSet rs = drvSpec.getResultSet();
065: if (rs != null) {
066: DatabaseNodeInfo nfo;
067: while (rs.next()) {
068: nfo = DatabaseNodeInfo.createNodeInfo(this ,
069: DatabaseNode.VIEWCOLUMN, drvSpec.getRow());
070: if (nfo != null)
071: children.add(nfo);
072: }
073: rs.close();
074: }
075: } catch (Exception e) {
076: throw new DatabaseException(e.getMessage());
077: }
078: }
079:
080: public void setProperty(String key, Object obj) {
081: try {
082: if (key.equals("remarks"))
083: setRemarks((String) obj); //NOI18N
084: put(key, obj);
085: } catch (Exception ex) {
086: ex.printStackTrace();
087: }
088: }
089:
090: public void setRemarks(String rem) throws DatabaseException {
091: String viewname = (String) get(DatabaseNode.VIEW);
092: Specification spec = (Specification) getSpecification();
093: try {
094: AbstractCommand cmd = spec.createCommandCommentView(
095: viewname, rem);
096: cmd.setObjectOwner((String) get(DatabaseNodeInfo.SCHEMA));
097: cmd.execute();
098: } catch (Exception e) {
099: throw new DatabaseException(e.getMessage());
100: }
101: }
102:
103: public void delete() throws IOException {
104: try {
105: DDLHelper.deleteView((Specification) getSpecification(),
106: (String) get(DatabaseNodeInfo.SCHEMA), getName());
107: } catch (Exception e) {
108: throw new IOException(e.getMessage());
109: }
110: }
111: }
|