ssdatabasemetadata.java

這是一個油Java實作的資料庫系統 是個入門的好材料

	
	
    public boolean supportsOuterJoins() {
    	return true;
    }
	
	
    public boolean supportsFullOuterJoins() {
    	return true;
    }
	
	
    public boolean supportsLimitedOuterJoins() {
    	return true;
    }
	
	
    public String getSchemaTerm() {
    	return "owner";
    }
	
	
    public String getProcedureTerm() {
    	return "procedure";
    }
	
	
    public String getCatalogTerm() {
    	return "database";
    }
	
	
    public boolean isCatalogAtStart() {
    	return true;
    }
	
	
    public String getCatalogSeparator() {
    	return ".";
    }
	
	
    public boolean supportsSchemasInDataManipulation() {
    	return false;
    }
	
	
    public boolean supportsSchemasInProcedureCalls() {
    	return false;
    }
	
	
    public boolean supportsSchemasInTableDefinitions() {
    	return false;
    }
	
	
    public boolean supportsSchemasInIndexDefinitions() {
    	return false;
    }
	
	
    public boolean supportsSchemasInPrivilegeDefinitions() {
    	return false;
    }
	
	
    public boolean supportsCatalogsInDataManipulation() {
		return true;
    }
	
	
    public boolean supportsCatalogsInProcedureCalls() {
    	return true;
    }
	
	
    public boolean supportsCatalogsInTableDefinitions() {
    	return true;
    }
	
	
    public boolean supportsCatalogsInIndexDefinitions() {
		return true;
    }
	
	
    public boolean supportsCatalogsInPrivilegeDefinitions() {
		return true;
    }
	
	
    public boolean supportsPositionedDelete() {
    	return true;
    }
	
	
    public boolean supportsPositionedUpdate() {
		return true;
    }
	
	
    public boolean supportsSelectForUpdate() {
		return true;
    }
	
	
    public boolean supportsStoredProcedures() {
    	return false;
    }
	
	
    public boolean supportsSubqueriesInComparisons() {
		return true;
    }
	
	
    public boolean supportsSubqueriesInExists() {
		return true;
    }
	
	
    public boolean supportsSubqueriesInIns() {
		return true;
    }
	
	
    public boolean supportsSubqueriesInQuantifieds() {
		return true;
    }
	
	
    public boolean supportsCorrelatedSubqueries() {
		return true;
    }
	
	
    public boolean supportsUnion() {
		return true;
    }
	
	
    public boolean supportsUnionAll() {
		return true;
    }
	
	
    public boolean supportsOpenCursorsAcrossCommit() {
    	return true;
    }
	
	
    public boolean supportsOpenCursorsAcrossRollback() {
    	return true;
    }
	
	
    public boolean supportsOpenStatementsAcrossCommit() {
    	return true;
    }
	
	
    public boolean supportsOpenStatementsAcrossRollback() {
    	return true;
    }
	
	
    public int getMaxBinaryLiteralLength() {
    	return 0;
    }
	
	
    public int getMaxCharLiteralLength() {
    	return 0;
    }
	
	
    public int getMaxColumnNameLength() {
    	return 255;
    }
	
	
    public int getMaxColumnsInGroupBy() {
    	return 0;
    }
	
	
    public int getMaxColumnsInIndex() {
    	return 0;
    }
	
	
    public int getMaxColumnsInOrderBy() {
    	return 0;
    }
	
	
    public int getMaxColumnsInSelect() {
    	return 0;
    }
	
	
    public int getMaxColumnsInTable() {
    	return 0;
    }
	
	
    public int getMaxConnections() {
    	return 0;
    }
	
	
    public int getMaxCursorNameLength() {
    	return 0;
    }
	
	
    public int getMaxIndexLength() {
    	return 0;
    }
	
	
    public int getMaxSchemaNameLength() {
    	return 255;
    }
	
	
    public int getMaxProcedureNameLength() {
    	return 255;
    }
	
	
    public int getMaxCatalogNameLength() {
    	return 255;
    }
	
	
    public int getMaxRowSize() {
    	return 0;
    }
	
	
    public boolean doesMaxRowSizeIncludeBlobs() {
    	return false;
    }
	
	
    public int getMaxStatementLength() {
    	return 0;
    }
	
	
    public int getMaxStatements() {
    	return 0;
    }
	
	
    public int getMaxTableNameLength() {
    	return 255;
    }
	
	
    public int getMaxTablesInSelect() {
    	return 0;
    }
	
	
    public int getMaxUserNameLength() {
    	return 0;
    }
	
	
    public int getDefaultTransactionIsolation() {
    	return Connection.TRANSACTION_READ_COMMITTED;
    }
	
	
    public boolean supportsTransactions() {
    	return true;
    }
	
	
    public boolean supportsTransactionIsolationLevel(int level) {
    	switch(level){
			case Connection.TRANSACTION_NONE:
			case Connection.TRANSACTION_READ_UNCOMMITTED:
    		case Connection.TRANSACTION_READ_COMMITTED:
			case Connection.TRANSACTION_REPEATABLE_READ:
			case Connection.TRANSACTION_SERIALIZABLE:
				return true;
    	}
    	return false;
    }
	
	
    public boolean supportsDataDefinitionAndDataManipulationTransactions() {
    	return true;
    }
	
	
    public boolean supportsDataManipulationTransactionsOnly() {
    	return false;
    }
	
	
    public boolean dataDefinitionCausesTransactionCommit() {
    	return false;
    }
	
	
    public boolean dataDefinitionIgnoredInTransactions() {
    	return false;
    }
	
	
    public ResultSet getProcedures(String catalog, String schemaPattern, String procedureNamePattern) throws SQLException {
		String[] colNames = {"PROCEDURE_CAT", "PROCEDURE_SCHEM", "PROCEDURE_NAME", "", "", "", "REMARKS", "PROCEDURE_TYPE"};  
		Object[][] data   = new Object[0][];
		return new SSResultSet( st, Utils.createMemoryCommandSelect( con, colNames, data));
    }
	
	
    public ResultSet getProcedureColumns(String catalog, String schemaPattern, String procedureNamePattern, String columnNamePattern) throws SQLException {
		String[] colNames = {"PROCEDURE_CAT", "PROCEDURE_SCHEM", "PROCEDURE_NAME", "COLUMN_NAME", "COLUMN_TYPE", "DATA_TYPE", "TYPE_NAME", "PRECISION", "LENGTH", "SCALE", "RADIX", "NULLABLE", "REMARKS" };
		Object[][] data   = new Object[0][];
		return new SSResultSet( st, Utils.createMemoryCommandSelect( con, colNames, data));
    }
	
	
    public ResultSet getTables(String catalog, String schemaPattern, String tableNamePattern, String[] types) throws SQLException {
		String[] colNames = {"TABLE_CAT","TABLE_SCHEM","TABLE_NAME","TABLE_TYPE","REMARKS","TYPE_CAT","TYPE_SCHEM","TYPE_NAME","SELF_REFERENCING_COL_NAME","REF_GENERATION"};
		Database database;
		if(catalog == null){ 
			database = con.getDatabase(true);
			if(database != null)
				catalog = database.getName();
    	}else{
			database = Database.getDatabase(catalog, con, false);
    	}
		ArrayList rows = new ArrayList();
		boolean isTypeTable = types == null;
		boolean isTypeView = types == null;
		for(int i=0; types != null && i<types.length; i++){
			if("TABLE".equalsIgnoreCase(types[i])) isTypeTable = true;
			if("VIEW" .equalsIgnoreCase(types[i])) isTypeView  = true;
		}