Part 1. JDBC Programming. Consider the following table Part (from SSBM schema benchmark https://www.cs.umb.edu/~poneil/StarSchemaB.PDF)

create table part (

p_partkey integer not null,

p_name varchar(22) not null,

p_mfgr varchar(6) not null,

p_category varchar(7) not null,

p_brand1 varchar(9) not null,

p_color varchar(11) not null,

p_type varchar(25) not null,

p_size integer not null,

p_container varchar(10) not null

);

alter table part

add primary key (p_partkey);

*

*

RAW DATA BELOW:

import java.util.Scanner;

public class Main{

public static void main(String args[]){

System.out.println("Hello World!");

Scanner reader = new Scanner(System.in);

System.out.println("Enter a number: ");

int n = reader.nextInt();

System.out.println("The number is "+n);

}

}

*

*

C) Write Java code that will accept an SQL query as user input, execute the query and time it, printing both the runtime and the output the query produced to the screen.