For this assignment, you will need to use a Netbeans

CST367467-Homework2Setup/src/main/java/com/mycompany/cst367467/homework2setup/InitDB.java

CST367467-Homework2Setup/src/main/java/com/mycompany/cst367467/homework2setup/InitDB.java

/*
 * Click nbfs://nbhost/SystemFileSystem/Templates/Licenses/license-default.txt to change this license
 * Click nbfs://nbhost/SystemFileSystem/Templates/Classes/Main.java to edit this template
 */
package  com . mycompany . cst367467 . homework2setup ;


import  java . sql . Connection ;
import  java . sql . DriverManager ;

/**
 * I actually just renamed SetupDB (MySQLTest) to InitDB
 * 
 * and changed the table/column names...
 *  @author  mruth
 */
public   class   InitDB   {

     /**
     *  @param  args the command line arguments
     */
     public   static   void  main ( String []  args )   {
        
         try   {
             Connection  conn  =   DriverManager . getConnection  (
             "jdbc:mysql://localhost:3306/database" ,
             "user" ,   "user" );
            
             //jdbc:mysql://localhost/db?useUnicode=true&useJDBCCompliantTimezoneShift=true&useLegacyDatetimeCode=false&serverTimezone=UTC
             System . out . println ( "If Table Exists... drop it like it's hot" );
             try   {
                
                 String  sql  =   "DROP TABLE PRODUCTS" ;
            
                conn . createStatement (). execute ( sql );
            
                 System . out . println ( "Table Dropped!" );
             }   catch   ( Exception  e )   {
                 System . out . println ( "Table Didn't Exist" );
             }
             try   {
                
                 String  sql  =   "DROP TABLE SELLERS" ;
            
                conn . createStatement (). execute ( sql );
            
                 System . out . println ( "Table Dropped!" );
             }   catch   ( Exception  e )   {
                 System . out . println ( "Table Didn't Exist" );
             }
            
             String  sql  =   "CREATE TABLE SELLERS (" ;
            sql  =  sql  +   " SID INTEGER PRIMARY KEY," ;
            sql  =  sql  +   " NAME VARCHAR(50)," ;
            sql  =  sql  +   " CITY VARCHAR(50)," ;
            sql  =  sql  +   " STATE VARCHAR(2))" ;
           
            conn . createStatement (). execute ( sql );
            
             System . out . println ( "Table SELLERS created!" );
            
            sql  =   "CREATE TABLE PRODUCTS (" ;
            sql  =  sql  +   " SKU INTEGER PRIMARY KEY," ;
            sql  =  sql  +   " NAME VARCHAR(50)," ;
            sql  =  sql  +   " DESCRIPTION VARCHAR(200)," ;
            sql  =  sql  +   " CATEGORY VARCHAR(50)," ;     
            sql  =  sql  +   " SID INTEGER," ;
            sql  =  sql  +   " PRICE DOUBLE ," ;
            sql  =  sql  +   " FOREIGN KEY (SID) REFERENCES SELLERS(SID))" ;
                    
            
            conn . createStatement (). execute ( sql );
            
            
             System . out . println ( "Table PRODUCTS created!" );
             System . out . println ( "DB Complete!" );
            conn . close ();
            
         }   catch   ( Exception  e )   {
             System . out . println ( e );
         }
     }
    
}