Due

Assignment

• Write a .sql file that creates a single table (include your name in the table name) with at least 3 columns, one of which must be a NUMBER. Make the first column the primary key. Then load at least 10 tuples. Then execute the .sql file in SQL*Plus. You will use this table for the remaining assignment.
• Write 4 Java programs, each using embedded SQL. Each should be carefully formatted and include both introductory and in-line commentary. In each case, have the user input the username and password for the connect statement.
1. Program 1 This program should select a single record using a primary key value inputted by the user. It should print the tuple in a nicely formatted way.
2. Program 2 This program should print the entire table (again in a nicely formatted way).
3. Program 3 This program should select and print all tuples from the table that have a non-key field value equal to the input by the user.
4. Program 4 This program should update an attribute of all tuples that satisfy come condition. The user should input the value for the condition and the new value. Afterwards, the program should print the entire table.

All of your code may appear in main if you wish. Be sure each program has sufficient in-line documentation to explain what is being doen at each step. .

Submit

1. A printed version of each .java and .sql file
2. Copy an electronic version of the same files to my directory. Make sure that your name or initials are included in each file name.

Java Refresher

• The file name must be the same name as the class name.
• The signature for main is
  public static void main(String [] args)
• For user input, use the method String JOptionPane.showInputDialog(String msg) where msg is the promt for the user and a String is returned containing the characters the user entered. Use the statement import javax.swing.*; before beginning the class definition. If you aren't running your program from a computer that can create additional windows, put the JOptionPane.java file in the directory with the rest of your code. This class will direct input to the console.
• If you need to convert the a String to a number use one of the following methods:
  • int Integer.parseInt(String s) where s is a String that contains only digits.
  • double Double.parseDounble(String s) where s is a String that contains only digits and possibly a decimal.
• For output use System.out.println(String msg) or System.out.print(String msg) where msg is the text you wish to appear in the console.
• Use String addition to put multiple strings together. Remeber you may add a String and an int and the result is a String. Example:
  

   
  int numStu = 8;
  String msg = "Number of students is " + numStu;
  

• If you have any other questions about java, you may look in the Java 1.4.2 documentation or send me email.