@@ -0,0 +1,1700 @@
+package QueryObjectFramework.QueryObjectDBStatements;%0A%0Aimport java.util.logging.Logger;%0A%0Aimport org.eclipse.jdt.annotation.NonNull;%0A%0Aimport QueryObjectFramework.CommonClasses.SqlQueryTypes;%0Aimport QueryObjectFramework.JdbcDatabaseConnection.JdbcDatabaseConnection;%0A%0A/**%0A * Query object class for DROP TABLE statement. The DROP TABLE statement is used%0A * to delete a existing SQL table.%0A *%0A * %3Cpre%3E%0A * DROP TABLE table_name;%0A * %3C/pre%3E%0A *%0A * TIPS: Be careful before dropping a table. Deleting a table will result in%0A * loss of complete information stored in the table!%0A *%0A * @author Bohui Axelsson%0A */%0Apublic class QueryObjectDropTable extends QueryObjectDBTableAbstract %7B%0A%09private static final Logger LOGGER = Logger.getLogger(QueryObjectDropTable.class.getName());%0A%0A%09/**%0A%09 * Create an DROP TABLE query object with Table names.%0A%09 *%0A%09 * @param jdbcDbConn%0A%09 * %09%09%09JDBC database connection%0A%09 * @param tableName%0A%09 * %09%09%09Table name%0A%09 */%0A%09public QueryObjectDropTable(@NonNull JdbcDatabaseConnection jdbcDbConn, @NonNull String tableName) %7B%0A%09%09super(SqlQueryTypes.DROP_TABLE, jdbcDbConn, tableName);%0A%09%7D%0A%0A%09/**%0A%09 * Drop a table.%0A%09 *%0A%09 * Scenario:%0A%09 *%0A%09 * %3Cpre%3E%0A%09 *  DROP TABLE table_name;%0A%09 * %3C/pre%3E%0A%09 *%0A%09 * NOTE: Only one table name can be associated to one%0A%09 * Query Object.%0A%09 *%0A%09 * NOTE: Be sure all data in the table have been considered, when%0A%09 * a table is dropped, all data in the table will be lost.%0A%09 */%0A%09public void dropDatabase() %7B%0A%09%09if (!validateTableNameNotNull()) %7B%0A%09%09%09return;%0A%09%09%7D%0A%0A%09%09LOGGER.info(%22Droping table %22 + fTableName);%0A%09%09String sql = fQueryObjectType.sqlQueryType() + %22 %22 + fTableName + %22;%22;%0A%09%09fJdbcDbConn.executeQueryObject(sql);%0A%09%09LOGGER.info(%22Table %22 + fTableName + %22is deleted.%22);%0A%09%7D%0A%7D%0A

Add QueryObjectDropTable class in pattern.