@@ -0,0 +1,1758 @@
+/*Programmer: Kristoffer Larson%0A *Date: April 27, 2014%0A *%0A *Description: Connect to a DB and drop a table if it exists.%0A *%0A */%0A%0Aimport java.sql.*;%0A%0Apublic class DBDropTable%0A%7B%0A   Connection c = null;%0A   public DBDropTable()%0A   %7B%0A      //Connection c = null;%0A      try %0A      %7B%0A         Class.forName(%22org.sqlite.JDBC%22);%0A         c = DriverManager.getConnection(%22jdbc:sqlite:test.db%22);%0A      %7D %0A      catch ( Exception e ) %0A      %7B%0A         System.err.println( e.getClass().getName() + %22: %22 + e.getMessage() );%0A         System.exit(0);%0A      %7D%0A      System.out.println(%22Opened database successfully%22);%0A      table();%0A   %7D%0A   %0A   public void table()%0A   %7B%0A      //Connection c = null;%0A      Statement stmt = null;%0A      try %7B%0A         //Class.forName(%22org.sqlite.JDBC%22);%0A         //c = DriverManager.getConnection(%22jdbc:sqlite:test.db%22);%0A         stmt = c.createStatement();%0A         %0A         String sql = %22drop table if exists COMPANY%22;%0A         stmt.executeUpdate(sql);%0A         System.out.println(%22Dropped table successfully%22);%0A         %0A         %0A         sql = %22CREATE TABLE COMPANY %22 +%0A                   %22(ID INT PRIMARY KEY     NOT NULL,%22 +%0A                   %22 NAME           TEXT    NOT NULL, %22 + %0A                   %22 AGE            INT     NOT NULL, %22 + %0A                   %22 ADDRESS        CHAR(50), %22 + %0A                   %22 SALARY         REAL)%22; %0A         stmt.executeUpdate(sql);%0A         stmt.close();%0A         c.close();%0A      %7D %0A      catch ( Exception e ) %7B%0A         System.err.println( e.getClass().getName() + %22: %22 + e.getMessage() );%0A         System.exit(0);%0A      %7D%0A      System.out.println(%22Table created successfully%22);%0A   %7D%0A   %0A   public static void main(String%5B%5D args)%0A   %7B%0A      %0A      DBDropTable app = new DBDropTable();%0A   %7D%0A%0A%7D%0A

Create DBDropTable.java