For this assignment, you will create Java™ code that accesses a relational database, requests data, and then analyzes and displays a portion of that data. Imagine a MySQL relational database schema na

/********************************************************************** *Program: PRG282Week5CodeAssignment_startercode.java * Purpose: Starter code to access two tables via JDBC.

* Programmer: YOUR NAME GOES HERE * Class: PRG/421r13, Java Programming II * Instructor: YOUR INSTRUCTOR'S NAME GOES HERE * Creation Date: TODAY'S DATE GOES HERE * * CommentS: The purpose of this code is to access a relational * database (MySQL), query two joined tables, and * process the results of the query. For this assignment, * no heavy-duty processing is required; we will simply * examine the returned data and display a selected * portion of it on the console. ***********************************************************************/ package SQLcommand; import java.sql.Connection; import java.sql.DriverManager; import java.sql.SQLException; public class SQLstarter { public static void main (String[ ] args) { try { // start of the try/catch block of code String host = " "; // This value is provided in the instructions for this assignment. String uName = " "; // This value is provided in the instructions for this assignment. String uPass = " "; // This value is provided in the instructions for this assignment. Connection conn = DriverManager.getConnection(host, uName, uPass); Statement stmt = con.createStatement(); // Select values from the tables String sql = "select Emp id, FName, LName, Addr, City, State, Zip from Employee_table, Union, select Paysch, 401k, Spouse from Payroll-table;"; ResultSet rs = stsmt.executeQuery (sql); // cursor pointing to its current row of data System.out.println ("Displaying student information: "); // display values from the tables String Emp id = rset.getString("Emp id"); String FName = rset.getString("FName "); String LName = rset.getString("LName "); String Addr = rset.getString("Addr "); String Zip = rset.getString("Zip"); String Paysch = rset.getString("Paysch "); String 401k = rset.getString("401k"); String Spouse = rset.getString("Spous ); // System.out.println (Stu_id + ", " +Stu_Name ); System.out.println (Emp id + ", " +FName + , +LName + , +Add + , +Zip + , +Paysch , +401k + , +Spouse); } catch ( SQLException err ) { System.out.println( err.getMessage( ) ); } } }