public interface Array { Object getArray() throws SQLException;
Object getArray(Map map) throws SQLException;
Object getArray(long index, int count)
throws SQLException;
Object getArray(long index, int count, Map map)
throws SQLException;
int getBaseType() throws SQLException;
String getBaseTypeName() throws SQLException;
ResultSet getResultSet() throws SQLException;
ResultSet getResultSet(Map map) throws SQLException;
ResultSet getResultSet(long index, int count)
throws SQLException;
ResultSet getResultSet(long index, int count, Map map) throws SQLException
}
public interface Blob {
InputStream getBinaryStream()
throws SQLException;
byte[] getBytes(long pos, int count)
throws SQLException;
long length() throws SQLException;
long position(byte[] pattern, long start)
throws SQLException;
long position(Blob pattern, long start)
throws SQLException; }
public interface Clob {
InputStream getAsciiStream()
throws SQLException;
Reader getCharacterStream()
throws SQLException;
String getSubStringdong pos, int count)
throws SQLException;
long length()
throws SQLException;
long position(String pattern, long start)
throws SQLException;
long position(Clob pattern, long start)
throws SQLException; }
public interface Connection {
static public final int TRANSACTION_NONE;
static public final int TRANSACTION_READ_UNCOMMITTED;
static public final int TRANSACTION_READ_COMMITTED;
static public final int TRANSACTION_REPEATABLE_READ;
static public final int TRANSACTION_SERIALIZABLE;
void clearWarnings() throws SQLException;
void close() throws SQLException;
void commit() throws SQLException;
Statement createStatement() throws SQLException;
Statement createStatement(int type, int concur)
throws SQLException;
boolean getAutoCommit() throws SQLException;
String getCatalog() throws SQLException;
Map gettypeMap() throws SQLException;
DatabaseMetaData getMetaData() throws SQLException;
int getTransactionIsolation() throws SQLException;
SQLWarning getWarnings() throws SQLException;
boolean isClosed() throws SQLException;
boolean isReadOnly() throws SQLException;
String nativeSQL(String sql) throws SQLException;
CallableStatement prepareCall(String sql)
throws SQLException;
CallableStatement prepareCall(String sql, int type,
int concur)
throws SQLException;
PreparedStatement prepareStatement(String sql)
throws SQLException;
PreparedStatement prepareStatement(String sql,
int type, int concur)
throws SQLException;
void rollback() throws SQLException;
void setAutoCommit(boolean ac) throws SQLException;
void setCatalog(String catalog) throws SQLException;
void setReadOnly(boolean ro) throws SQLException;
void setTransactionIsolation(int level)
throws SQLException;
void setTypeMap(Map map) throws SQLException; }
public interface DatabaseMetaData {
static public final int bestRowTemporary;
static public final int bestRowTransaction;
static public final int bestRowSession;
static public final int bestRowUnknown;
static public final int bestRowNotPseudo;
static public final int bestRowPseudo;
static public final int columnNoNulls;
static public final int columnNullable;
static public final int columnNullablellnknown;
static public final int importedKeyCascade;
static public final int importedKeyRestrict;
static public final int importedKeySetNull;
static public final int importedKeyNoAction;
static public final int importedKeySetDefault;
static public final int importedKeylnitiallyDeferred;
static public final int importedKeylnitiallylmmediate;
static public final int importedKeyNotDeferrable;
static public final int procedureResultUnknown;
static public final int procedureNoResult;
static public final int procedureReturnsResult;
static public final int procedureColumnUnknown;
static public final int procedureColumnln;
static public final int procedureColumnOut;
static public final int procedureColumnReturn;
static public final int procedureColumnResult;
static public final int procedureNoNulls;
static public final int procedureNullable;
static public final int procedureNullableUnknown;
static public final short tablelndexStatistic;
static public final short tablelndexClustered;
static public final short tablelndexHashech;
static public final short tablelndexOther;
static public final int typeNoNulls;
static public final int typeNullable;
static public final int typeNullablellnknown;
static public final int typePredHet;
static public final int typePredChar;
static public final int typePredBasic;
static public final int typeSearchable;
static public final int versionColumnUnknown;
static public final int versionColumnNotPseudo;
static public final int versionColumnPseudo;
boolean allProceduresAreCallable()
throws SQLException;
boolean allTablesAreSelectable() throws SOLException;
boolean dataDefinitionCausesTransactionCommit()
throws SQLException;
boolean dataDefinitionIgnoredlnlransactions()
throws SQLException;
ResultSet getBestRowIdentifier(String catalog,
String schema, String table, int scope,
boolean nullable)
throws SQLException;
ResultSet getCatalogs() throws SQLException;
String getCatalogSeparator() throws SQLException;
String getCatalogTerm() throws SQLException;
ResultSet getColumnPriveleges(String catalog, String spat. String table, String cpat) throws SQLException;
ResultSet getColumns(String catalog, String spat. String tpat, String cpat) throws SQLException;
ResultSet getCrossReference(String primaryCatalog, String primarySchema, String primaryTable, String foreignCatalog, String foreignSchema, String foreignTable) throws SQLException;
String getDatabaseProductName() throws SQLException;
String getDatabaseProductVersion()throws SQLException;
int getDefaultTransactionIsolation()throws SQLException;
int getDriverMajorVersion();
int getDriverMinorVersion();
String getDriverName() throws SQLException;
String getDriverVersion() throws SQLException;
ResultSet getExportedKeys(String catalog,String schema, String .table)throws SQLException;
String getExtraNameCharacters() throws SQLException;
String getldentifierQuoteString() throws SQLException;
ResultSet getImportedKeys(String catalog,String schema, String table) throws SQLException;
ResultSet getIndex!nfo(String catalog,String schema, String table, boolean unique,boolean approximate) throws SQLException;
int getMaxBinaryLiteralLength() throws SQLException;
int getMaxCatalogNameLength() throws SQLException;
int getMaxCharLiteralLengthO throws SQLException;
int getMaxcnameLength() throws SQLException;
int getMaxColumnsInGroupBy() throws SQLException;
int getMaxColumnsInIndex() throws SQLException;
int getMaxColumns!nOrderBy() throws SQLException;
int getMaxColumnsInSelect() throws SQLException;
int getMaxColumnsInTable() throws SQLException;
int getMaxConnections() throws SQLException;
int getMaxIndexLength() throws SQLException;
int getMaxProcedureNameLength()
throws SQLException;
int getMaxRowSize() throws SQLException;
int getMaxRowSizelncludeBlobs()
throws SQLException;
int getMaxSchemaNameLength() throws SQLException;
int getMaxStatementLength() throws SQLException;
int getMaxStatements() throws SQLException;
int getMaxTableNameLength() throws SQLException;
int getMaxTablesInSelect() throws SQLException;
int getMaxUserNameLength() throws SQLException;
String getNumericFunctions() throws SQLException;
ResultSet getPrimaryKeys(String catalog,String schema, String table) throws SQLException;
ResultSet getProcedureColumns(String catalog,String schemePattern, String procedureNamePattern,String cnamePattern) throws SQLException;
String getProcedureTerm() throws SQLException;
ResultSet getProcedures(String catalog,String schemaPattern, String procedureNamePattern)throws SQLException;
public abstract ResultSet getSchemas() throws SQLException;
public abstract String getSchemaTern() throws SQLException;
String getSearchStringEscape() throws SQLException;
String getSQLKeywords() throws SQLException;
String getStringFunctions() throws SQLException;
String getSystemFunctions() throws SQLException;
ResultSet getTablePriveleges(String catalog,String schemaPattern, String tableNamePattern)throws SQLException;
ResultSet getTableTypes() throws SQLException;
ResultSet getTables(String catalog,String schemaPattern, String tableNamePattern,String types[]) throws SQLException;
String getTimeDateFunctions() throws SQLException;
ResultSet getTypelnfo() throws SQLException;
String getURL() throws SQLException;
String getUserName() throws SQLException;
ResultSet getVersionColumns(String catalog,String schema, String-table) throws SQLException;
boolean isCatalogAtStart() throws SQLException;
boolean isReadOnly() throws SQLException;
boolean nullPlusNonNullIsNull() throws SQLException;
boolean nullsAreSortedHigh() throws SQLException;
boolean nullsAreSortedLow() throws SQLException;
boolean nullsAreSortedAtStart() throws SQLException;
boolean nullsAreSortedAtEnd() throws SQLException;
boolean storesLowerCaseIdentifiers()throws SQLException;
boolean storesLowerCaseQuotedIdentifiers()throws SQLException;
boolean storesMixedCaseldentifiers()throws SQLException;
boolean storesMixedCaseQuotedldentifiers()throws SQLException;
boolean storesUpperCaseldentifiers()throws SQLException;
boolean storesUpperCaseQuotedldentifiers()throws SQLException;
boolean supportsAlterTableWithAddColumn()throws SQLException;
boolean supportsAlterTableWlthDropColumn()throws SQLException;
boolean supportsANSI92FullSQL() throws SQLException;
boolean supportsANSI92IntermediateSQL()throws SQLException;
boolean supportsCatalogsInDataManipulation()throws SQLException;
boolean suppportsCatalogsInIndexDefinitions()throws SQLException;
boolean supportsCatalogsInPrivelegeDefinitions()throws SQLException;
boolean supportsCatalogsInProcedureCalls()throws SQLException;
boolean supportsCatalogsInTableDefinitions()throws SQLException;
boolean supportsColumnAliasing() throws SQLException;
boolean supportsConvert() throws SQLException;
boolean supportsConvert(int fromType, int toType)throws SQLException;
boolean supportsCoreSQLGrammar() throws SQLException;
boolean supportsCorrelatedSubqueries()throws SQLException;
boolean supportsDataDefinitionAndDataManipulationTransactions()
throws SQLException; boolean supportsDataManipulationTransactionsOnly()
throws SQLException; boolean supportsDifferentTableCorrelationNames()
throws SQLException; boolean supportsExpressions!nOrderBy()
throws SQLException; boolean supportsExtendedSQLGrammar()
throws SQLException;
boolean supportsFullOuterJoins() throws SQLException;
boolean supportsGroupBy() throws SQLException;
boolean supportsGroupByBeyondSelect()
throws SQLException; boolean supportsGroupByUnrelated()
throws SQLException; boolean supports!ntegrityEnhancementFacility()
throws SQLException; boolean supportsLikeEscapeClause()
throws SQLException; boolean supportsLimitedOuterJoins()
throws SQLException; boolean supportsMinimumSQLGrammar()
throws SQLException; boolean supportsMixedCaseldentifiers()
throws SQLException; boolean supportsMixedCaseQuotedldenfitiers()
throws SQLException; boolean supportsMultipleResultSets()
throws SQLLxception; boolean supportsMultipleTransactions()
throws SQLException; boolean supportsNonNullableColumns()
throws SQLException; boolean supportsOpenCursorsAcrossCommit()
throws SQLException; boolean supportsOpenCursorsAcrossRollback()
throws SQLException; boolean supportsOpenStatementsAcrossCommit()
throws SQLException; boolean supportsOpenStatementsAcrossRollback()
throws SQLException; boolean supportsOrderByUnrelated()
throws SQLException;
boolean supportsOuterJoins() throws SQLException;
boolean supportsPositionedDelete()
throws SQLException; boolean supportsPositionedUpdate()
throws SQLException; boolean supportsSchemasInDataManipulation()
throws SQLException; boolean supportsSchemasInlndexDefinitions()
throws SQLException; boolean supportsSchemasInPrivelegeOefinitions()
throws SQLException; boolean supportsSchemasInProcedureCalls()
throws SQLException; boolean supportsSchemasInTableDefinitions()
throws SQLException; boolean supportsSelectForllpdate()
throws SQLException; boolean supportsStoredProcedures()
throws SQLException; boolean supportsSubqueriesInComparisons()
throws SQLException; boolean supportsSubqueriesInExists()
throws SQLException; boolean supportsSubqueriesIn!ns()
throws SQLException; boolean supportsSubqueriesInQuantifieds()
throws SQLException; boolean supportsTableCorrelationNames()
throws SQLException; boolean supportsTransactionIsolationLevel(int level)
throws SQLException;
boolean supportsTransactions() throws SQLException;
boolean supportsUnion() throws SQLException;
boolean supportsUnionAll() throws SQLException;
boolean usesLocalFilePerTable() throws SQLException;
boolean usesLocalFiles() throws SQLException; }
Date
Краткий обзор
Имя класса: java.sql.Date Надкласс: java.util.Date Непосредственные подклассы: нет Реализованные интерфейсы: нет Доступность: JDK 1.1
public interface Driver {
boolean acceptsURL(String url) throws SQLException;
Connection connect(String url, Properties info)
throws SQLException;
int getMajorVersion();
int getMinorVersion();
DriverPropertyInfo[] getProperty!nfo(String url,
Properties info) throws SQLException;
boolean jdbcCompliant(); }
public class DriverManager { static void deregisterDriver(Driver driver)
throws SQLException;
static public synchronized Connection getConnection(String url, Properties info) throws SQLException;
static public synchronized Connection getConnection(String url, String user, String password) throws SQLException;
static public synchronized Connection getConnection(String url) throws SQLException;
static public Driver getDriver(String url) throws SQLException;
static public Enumeration getDrivers();
static public int getLoginTimeout();
#static public PrintStrean getLogStream();
static public PrintWriter getLogWriter();
static public void println(String message);
static public synchronized void registerDriver(Driver driver)
throws SQLException;
#static public void setl_ogStream(PrintStream out);
static public void setl_ogWriter(PrintWriter out);
public class DriverPropertyInfo {
public String[] choices;
public String description;
public String name;
public boolean required;
public String value;
public DriverPropertyInfo(String name, String value); }
public interface PreparedStatement extends Statement {
void addBatch() throws SQLException;
void clearParameters() throws SQLException;
boolean execute() throws SQLException;
ResultSet executeQuery() throws SQLException;
int executeUpdate() throws SQLException;
ResultSetMetaData getMetaData() throws SQLException;
void setArray(int index, Array arr)throws SQLException;
void setAsciiStream(int index, InputStream is,int length) throws SQLException;
void setBigDecimal(int index, BigDecimal d)throws SQLException;
void setBinaryStream(int index, InputStream is,int length) throws SQLException;
void setBlob(int index, Blob b) throws SQLException; void setBoolean(int index, boolean b)throws SQLException;
void setByte(int index, byte b) throws SQLException; void setBytes(int index, byte[] bts)throws SQLException;
void setCharacterStream(int index, Reader rdr,int length) throws SQLException;
void setClob(int index, Clob c) throws SQLException;
void setDate(int index, Date d) throws SQLException;
void setDate(int index, Date d, Calendar cal)throws SQLException; void setDouble(int index, double x)throws SQLException;
void setFloat(int index, float f) throws SQLException;
void setlnt(int index, int x) throws SQLException;
void setLong(int index, long x) throws SQLException;
void setNull(int index, int type) throws SQLException;
void setNull(int index, int type, String tname)throws SQLException;
void setObject(int index, Object ob)throws SQLException;
void setObject(int index, Object ob, int type)throws SQLException;
void setObject(int index, Object ob, int type,
int scale) throws SQLException;
void setRef(int index, Ref ref) throws SQLException;
void setShort(int index, short s) throws SQLException;
void setString(int index, String str)throws SQLException;
void setTime(int index, Time t) throws SQLException;
void setTime(int index, Time t, Calendar cal)throws SQLException;
void setTimestamp(int index, Timestamp ts)throws SQLException;
void setTimestamp(int index, Timestamp ts, Calendar cal)throws SQLException;
void setUnicodeStream(int index, InputStream is,int length) throws SQLException; }
public interface Ref {
String getBaseTypeName() throws SQLException; }