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.sql.execute;
043:
044: import java.sql.DatabaseMetaData;
045: import java.sql.ResultSet;
046: import java.sql.SQLException;
047: import java.sql.Statement;
048:
049: /**
050: * Encapsulates the result of the execution of a single SQL statement.
051: *
052: * @author Andrei Badea
053: */
054: public class SQLExecutionResult {
055:
056: /**
057: * The info about the executed statement.
058: */
059: private final StatementInfo statementInfo;
060:
061: /**
062: * The executed statement.
063: */
064: private final Statement statement;
065:
066: /**
067: * The ResultSet returned by the statement execution.
068: */
069: private final ResultSet resultSet;
070:
071: /**
072: * The exception (if any) which occurred while executing the statement.
073: */
074: private final SQLException exception;
075:
076: /**
077: * The execution time in milliseconds.
078: */
079: private final long executionTime;
080:
081: /**
082: * The number of the rows affected by the statement execution.
083: */
084: private final int rowCount;
085:
086: public SQLExecutionResult(StatementInfo info, Statement statement,
087: ResultSet resultSet, long executionTime) {
088: this (info, statement, resultSet, -1, null, executionTime);
089: }
090:
091: public SQLExecutionResult(StatementInfo info, Statement statement,
092: int rowCount, long executionTime) {
093: this (info, statement, null, rowCount, null, executionTime);
094: }
095:
096: public SQLExecutionResult(StatementInfo info, Statement statement,
097: SQLException exception) {
098: this (info, statement, null, -1, exception, 0);
099: }
100:
101: private SQLExecutionResult(StatementInfo info, Statement statement,
102: ResultSet resultSet, int rowCount, SQLException exception,
103: long executionTime) {
104: this .statementInfo = info;
105: this .statement = statement;
106: this .resultSet = resultSet;
107: this .rowCount = rowCount;
108: this .exception = exception;
109: this .executionTime = executionTime;
110: }
111:
112: public StatementInfo getStatementInfo() {
113: return statementInfo;
114: }
115:
116: public ResultSet getResultSet() {
117: return resultSet;
118: }
119:
120: public int getRowCount() {
121: return rowCount;
122: }
123:
124: public SQLException getException() {
125: return exception;
126: }
127:
128: public long getExecutionTime() {
129: return executionTime;
130: }
131:
132: public DatabaseMetaData getDatabaseMetaData() throws SQLException {
133: return statement.getConnection().getMetaData();
134: }
135:
136: public void close() throws SQLException {
137: try {
138: if (resultSet != null) {
139: resultSet.close();
140: }
141: } finally {
142: if (statement != null) {
143: statement.close();
144: }
145: }
146: }
147:
148: public String toString() {
149: return "SQLExecutionResult[resultSet=" + resultSet
150: + ",rowCount=" + rowCount + ",exception=" + exception
151: + ",executionTime=" + executionTime + "]";
152: }
153: }
|