Java DatabaseType类代码示例

import com.j256.ormlite.db.DatabaseType; //导入依赖的package包/类
private static void appendWhereIds(DatabaseType paramDatabaseType, FieldType paramFieldType, StringBuilder paramStringBuilder, int paramInt, FieldType[] paramArrayOfFieldType)
{
  paramStringBuilder.append("WHERE ");
  paramDatabaseType.appendEscapedEntityName(paramStringBuilder, paramFieldType.getColumnName());
  paramStringBuilder.append(" IN (");
  int i = 1;
  for (int j = 0; j < paramInt; j++)
  {
    if (i != 0)
      i = 0;
    else
      paramStringBuilder.append(',');
    paramStringBuilder.append('?');
    if (paramArrayOfFieldType != null)
      paramArrayOfFieldType[j] = paramFieldType;
  }
  paramStringBuilder.append(") ");
}
 

import com.j256.ormlite.db.DatabaseType; //导入依赖的package包/类
public void appendSql(DatabaseType paramDatabaseType, String paramString, StringBuilder paramStringBuilder, List<ArgumentHolder> paramList)
{
  if ((this.comparison == null) && (this.exists == null))
    throw new IllegalStateException("Clause has not been set in NOT operation");
  if (this.comparison == null)
  {
    paramStringBuilder.append("(NOT ");
    this.exists.appendSql(paramDatabaseType, paramString, paramStringBuilder, paramList);
  }
  else
  {
    paramStringBuilder.append("(NOT ");
    if (paramString != null)
    {
      paramDatabaseType.appendEscapedEntityName(paramStringBuilder, paramString);
      paramStringBuilder.append('.');
    }
    paramDatabaseType.appendEscapedEntityName(paramStringBuilder, this.comparison.getColumnName());
    paramStringBuilder.append(' ');
    this.comparison.appendOperation(paramStringBuilder);
    this.comparison.appendValue(paramDatabaseType, paramStringBuilder, paramList);
  }
  paramStringBuilder.append(") ");
}
 

import com.j256.ormlite.db.DatabaseType; //导入依赖的package包/类
public void appendSql(DatabaseType paramDatabaseType, String paramString, StringBuilder paramStringBuilder, List<ArgumentHolder> paramList)
{
  paramStringBuilder.append("(");
  this.first.appendSql(paramDatabaseType, paramString, paramStringBuilder, paramList);
  if (this.second != null)
  {
    paramStringBuilder.append(this.operation);
    paramStringBuilder.append(' ');
    this.second.appendSql(paramDatabaseType, paramString, paramStringBuilder, paramList);
  }
  if (this.others != null)
    for (int i = this.startOthersAt; i < this.others.length; i++)
    {
      paramStringBuilder.append(this.operation);
      paramStringBuilder.append(' ');
      this.others[i].appendSql(paramDatabaseType, paramString, paramStringBuilder, paramList);
    }
  paramStringBuilder.append(") ");
}
 

import com.j256.ormlite.db.DatabaseType; //导入依赖的package包/类
public void appendValue(DatabaseType paramDatabaseType, StringBuilder paramStringBuilder, List<ArgumentHolder> paramList)
{
  paramStringBuilder.append('(');
  int i = 1;
  Iterator localIterator = this.objects.iterator();
  while (localIterator.hasNext())
  {
    Object localObject = localIterator.next();
    if (localObject == null)
      throw new IllegalArgumentException("one of the IN values for '" + this.columnName + "' is null");
    if (i != 0)
      i = 0;
    else
      paramStringBuilder.append(',');
    super.appendArgOrValue(paramDatabaseType, this.fieldType, paramStringBuilder, paramList, localObject);
  }
  paramStringBuilder.append(") ");
}
 

import com.j256.ormlite.db.DatabaseType; //导入依赖的package包/类
private static DatabaseFieldConfig fromForeignCollection(DatabaseType paramDatabaseType, Field paramField, ForeignCollectionField paramForeignCollectionField)
{
  DatabaseFieldConfig localDatabaseFieldConfig = new DatabaseFieldConfig();
  localDatabaseFieldConfig.fieldName = paramField.getName();
  if (paramForeignCollectionField.columnName().length() > 0)
    localDatabaseFieldConfig.columnName = paramForeignCollectionField.columnName();
  localDatabaseFieldConfig.foreignCollection = true;
  localDatabaseFieldConfig.foreignCollectionEager = paramForeignCollectionField.eager();
  int i = paramForeignCollectionField.maxEagerForeignCollectionLevel();
  if (i != 1)
    localDatabaseFieldConfig.foreignCollectionMaxEagerLevel = i;
  else
    localDatabaseFieldConfig.foreignCollectionMaxEagerLevel = paramForeignCollectionField.maxEagerLevel();
  localDatabaseFieldConfig.foreignCollectionOrderColumnName = valueIfNotBlank(paramForeignCollectionField.orderColumnName());
  localDatabaseFieldConfig.foreignCollectionOrderAscending = paramForeignCollectionField.orderAscending();
  localDatabaseFieldConfig.foreignCollectionColumnName = valueIfNotBlank(paramForeignCollectionField.columnName());
  String str = valueIfNotBlank(paramForeignCollectionField.foreignFieldName());
  if (str == null)
  {
    localDatabaseFieldConfig.foreignCollectionForeignFieldName = valueIfNotBlank(valueIfNotBlank(paramForeignCollectionField.foreignColumnName()));
    return localDatabaseFieldConfig;
  }
  localDatabaseFieldConfig.foreignCollectionForeignFieldName = str;
  return localDatabaseFieldConfig;
}
 

import com.j256.ormlite.db.DatabaseType; //导入依赖的package包/类
private static DatabaseFieldConfig configFromField(DatabaseType paramDatabaseType, String paramString, Field paramField)
{
  if (configFieldNums == null)
    return DatabaseFieldConfig.fromField(paramDatabaseType, paramString, paramField);
  DatabaseField localDatabaseField = (DatabaseField)paramField.getAnnotation(DatabaseField.class);
  DatabaseFieldConfig localDatabaseFieldConfig = null;
  if (localDatabaseField != null);
  try
  {
    localDatabaseFieldConfig = buildConfig(localDatabaseField, paramString, paramField);
  }
  catch (Exception localException)
  {
  }
  if (localDatabaseFieldConfig == null)
    return DatabaseFieldConfig.fromField(paramDatabaseType, paramString, paramField);
  workedC = 1 + workedC;
  return localDatabaseFieldConfig;
}
 

import com.j256.ormlite.db.DatabaseType; //导入依赖的package包/类
public static <T> DatabaseTableConfig<T> fromClass(ConnectionSource paramConnectionSource, Class<T> paramClass)
{
  DatabaseType localDatabaseType = paramConnectionSource.getDatabaseType();
  String str = DatabaseTableConfig.extractTableName(paramClass);
  ArrayList localArrayList = new ArrayList();
  for (Object localObject = paramClass; localObject != null; localObject = ((Class)localObject).getSuperclass())
  {
    Field[] arrayOfField = ((Class)localObject).getDeclaredFields();
    int i = arrayOfField.length;
    for (int j = 0; j < i; j++)
    {
      DatabaseFieldConfig localDatabaseFieldConfig = configFromField(localDatabaseType, str, arrayOfField[j]);
      if ((localDatabaseFieldConfig != null) && (localDatabaseFieldConfig.isPersisted()))
        localArrayList.add(localDatabaseFieldConfig);
    }
  }
  if (localArrayList.size() == 0)
    return null;
  return new DatabaseTableConfig(paramClass, str, localArrayList);
}
 

import com.j256.ormlite.db.DatabaseType; //导入依赖的package包/类
private static <T, ID> void addDropIndexStatements(DatabaseType paramDatabaseType, TableInfo<T, ID> paramTableInfo, List<String> paramList)
{
  HashSet localHashSet = new HashSet();
  for (FieldType localFieldType : paramTableInfo.getFieldTypes())
  {
    String str2 = localFieldType.getIndexName();
    if (str2 != null)
      localHashSet.add(str2);
    String str3 = localFieldType.getUniqueIndexName();
    if (str3 != null)
      localHashSet.add(str3);
  }
  StringBuilder localStringBuilder = new StringBuilder(48);
  Iterator localIterator = localHashSet.iterator();
  while (localIterator.hasNext())
  {
    String str1 = (String)localIterator.next();
    logger.info("dropping index '{}' for table '{}", str1, paramTableInfo.getTableName());
    localStringBuilder.append("DROP INDEX ");
    paramDatabaseType.appendEscapedEntityName(localStringBuilder, str1);
    paramList.add(localStringBuilder.toString());
    localStringBuilder.setLength(0);
  }
}
 

import com.j256.ormlite.db.DatabaseType; //导入依赖的package包/类
private static <T, ID> void addDropTableStatements(DatabaseType paramDatabaseType, TableInfo<T, ID> paramTableInfo, List<String> paramList)
{
  ArrayList localArrayList1 = new ArrayList();
  ArrayList localArrayList2 = new ArrayList();
  FieldType[] arrayOfFieldType = paramTableInfo.getFieldTypes();
  int i = arrayOfFieldType.length;
  for (int j = 0; j < i; j++)
    paramDatabaseType.dropColumnArg(arrayOfFieldType[j], localArrayList1, localArrayList2);
  StringBuilder localStringBuilder = new StringBuilder(64);
  localStringBuilder.append("DROP TABLE ");
  paramDatabaseType.appendEscapedEntityName(localStringBuilder, paramTableInfo.getTableName());
  localStringBuilder.append(' ');
  paramList.addAll(localArrayList1);
  paramList.add(localStringBuilder.toString());
  paramList.addAll(localArrayList2);
}
 

import com.j256.ormlite.db.DatabaseType; //导入依赖的package包/类
private static <T, ID> int doCreateTable(ConnectionSource paramConnectionSource, TableInfo<T, ID> paramTableInfo, boolean paramBoolean)
{
  DatabaseType localDatabaseType = paramConnectionSource.getDatabaseType();
  logger.info("creating table '{}'", paramTableInfo.getTableName());
  ArrayList localArrayList1 = new ArrayList();
  ArrayList localArrayList2 = new ArrayList();
  addCreateTableStatements(localDatabaseType, paramTableInfo, localArrayList1, localArrayList2, paramBoolean);
  DatabaseConnection localDatabaseConnection = paramConnectionSource.getReadWriteConnection();
  try
  {
    int i = doStatements(localDatabaseConnection, "create", localArrayList1, false, localDatabaseType.isCreateTableReturnsNegative(), localDatabaseType.isCreateTableReturnsZero()) + doCreateTestQueries(localDatabaseConnection, localDatabaseType, localArrayList2);
    return i;
  }
  finally
  {
    paramConnectionSource.releaseConnection(localDatabaseConnection);
  }
}
 

import com.j256.ormlite.db.DatabaseType; //导入依赖的package包/类
private static <T, ID> int doDropTable(DatabaseType paramDatabaseType, ConnectionSource paramConnectionSource, TableInfo<T, ID> paramTableInfo, boolean paramBoolean)
{
  logger.info("dropping table '{}'", paramTableInfo.getTableName());
  ArrayList localArrayList = new ArrayList();
  addDropIndexStatements(paramDatabaseType, paramTableInfo, localArrayList);
  addDropTableStatements(paramDatabaseType, paramTableInfo, localArrayList);
  DatabaseConnection localDatabaseConnection = paramConnectionSource.getReadWriteConnection();
  try
  {
    int i = doStatements(localDatabaseConnection, "drop", localArrayList, paramBoolean, paramDatabaseType.isCreateTableReturnsNegative(), false);
    return i;
  }
  finally
  {
    paramConnectionSource.releaseConnection(localDatabaseConnection);
  }
}
 

import com.j256.ormlite.db.DatabaseType; //导入依赖的package包/类
public static int clearTable(ConnectionSource connectionSource, String tableName) throws SQLException {
    FieldType[] noFieldTypes = new FieldType[0];
    DatabaseType databaseType = connectionSource.getDatabaseType();
    StringBuilder sb = new StringBuilder(48);
    if (databaseType.isTruncateSupported()) {
        sb.append("TRUNCATE TABLE ");
    } else {
        sb.append("DELETE FROM ");
    }
    databaseType.appendEscapedEntityName(sb, tableName);
    String statement = sb.toString();
    Log.i("DatabaseHelper", "clearing table '" + tableName + "' with '" + statement + "'");
    CompiledStatement compiledStmt = null;
    DatabaseConnection connection = connectionSource.getReadWriteConnection();
    try {
        compiledStmt =
                connection.compileStatement(statement, StatementBuilder.StatementType.EXECUTE, noFieldTypes,
                        DatabaseConnection.DEFAULT_RESULT_FLAGS);
        return compiledStmt.runExecute();
    } finally {
        if (compiledStmt != null) {
            compiledStmt.close();
        }
        connectionSource.releaseConnection(connection);
    }
}
 

import com.j256.ormlite.db.DatabaseType; //导入依赖的package包/类
/**
 * Build our list table config from a class using some annotation fu around.
 */
public static <T> DatabaseTableConfig<T> fromClass(ConnectionSource connectionSource, Class<T> clazz)
		throws SQLException {
	DatabaseType databaseType = connectionSource.getDatabaseType();
	String tableName = DatabaseTableConfig.extractTableName(clazz);
	List<DatabaseFieldConfig> fieldConfigs = new ArrayList<DatabaseFieldConfig>();
	for (Class<?> classWalk = clazz; classWalk != null; classWalk = classWalk.getSuperclass()) {
		for (Field field : classWalk.getDeclaredFields()) {
			DatabaseFieldConfig config = configFromField(databaseType, tableName, field);
			if (config != null && config.isPersisted()) {
				fieldConfigs.add(config);
			}
		}
	}
	if (fieldConfigs.size() == 0) {
		return null;
	} else {
		return new DatabaseTableConfig<T>(clazz, tableName, fieldConfigs);
	}
}
 

import com.j256.ormlite.db.DatabaseType; //导入依赖的package包/类
@Test
public void testConstructors() throws Exception {
	JdbcPooledConnectionSource pooled = new JdbcPooledConnectionSource(DEFAULT_DATABASE_URL);
	assertEquals(DEFAULT_DATABASE_URL, pooled.getUrl());
	pooled.close();

	pooled = new JdbcPooledConnectionSource(DEFAULT_DATABASE_URL, null, null);
	assertEquals(DEFAULT_DATABASE_URL, pooled.getUrl());
	pooled.close();

	DatabaseType databaseType = DatabaseTypeUtils.createDatabaseType(DEFAULT_DATABASE_URL);
	pooled = new JdbcPooledConnectionSource(DEFAULT_DATABASE_URL, databaseType);
	assertEquals(DEFAULT_DATABASE_URL, pooled.getUrl());
	assertSame(databaseType, pooled.getDatabaseType());
	pooled.close();

	pooled = new JdbcPooledConnectionSource(DEFAULT_DATABASE_URL, null, null, databaseType);
	assertEquals(DEFAULT_DATABASE_URL, pooled.getUrl());
	assertSame(databaseType, pooled.getDatabaseType());
	pooled.close();
}
 

import com.j256.ormlite.db.DatabaseType; //导入依赖的package包/类
private static boolean isFieldCreatable(DatabaseType databaseType, FieldType fieldType) {
	// we don't insert anything if it is a collection
	if (fieldType.isForeignCollection()) {
		// skip foreign collections
		return false;
	} else if (fieldType.isReadOnly()) {
		// ignore read-only fields
		return false;
	} else if (databaseType.isIdSequenceNeeded() && databaseType.isSelectSequenceBeforeInsert()) {
		// we need to query for the next value from the sequence and the idField is inserted afterwards
		return true;
	} else if (fieldType.isGeneratedId() && !fieldType.isSelfGeneratedId() && !fieldType.isAllowGeneratedIdInsert()) {
		// skip generated-id fields because they will be auto-inserted
		return false;
	} else {
		return true;
	}
}