import java.sql.*;

public class TestConnect { public static void main(String [] args){

// Definitions for Microsoft (MS) SQL Server connection String uri = "jdbc:sqlserver://theodore.ist.rit.edu;databaseName=Jobs"; String driver = "com.microsoft.sqlserver.jdbc.SQLServerDriver"; String user = "330User"; String password= "330Password"; // Connection object to database Connection conn = null; // Load the database driver try { Class.forName( driver ); System.out.println("Driver loaded"); } catch( ClassNotFoundException cnfe ){ System.out.println("Cannot find or load driver "+driver); cnfe.printStackTrace(); System.exit(1); } // Open the database try{ conn = DriverManager.getConnection( uri, user, password ); System.out.println("Database open"); } catch(SQLException sqle){ System.out.println("Could not connect to DB: "+uri); sqle.printStackTrace(); System.exit(2); } // Close the database try{ conn.close(); System.out.println("Database closed"); } catch(SQLException sqle){ System.out.println("Could not close database"); sqle.printStackTrace(); System.exit(3); } } // end main } // end TestConnect

Just help me motify the code for step 1 and 3, and just only for java

This assignment is written in both Java and C#. All future assignments are in the one programming language of your choice. The databases being accessed are MySQL and SQL Server 1. Create a data layer class file named "SQLServerDatabase" The SQLServerDatabase class file should have attribut2es for each of the connection parameters. These parameters can be set in the constructor or when they are declared There should also be a "connection" attribute to hold the DB connection object. There should be a public "connect" method. This method will attempt to connect to the database. If successful, it should set the connection attribute and return true. If unsuccessful, it should return false Finally, there should be a "close" method that closes the connection and returns true or false depending on the success of the close a. b. c. d. 2. Create another class file named "MySQLDatabase" and repeat steps a-d for connecting to a MySQL database In another class, create a main" method that instantiates both the database classes, opens a connection, closes the connection, and reports the results to the user. This class is the only class that displays information to the user Do steps 1-3 in Java and C# 3. 4. For MS SqlServer, connect to the Jobs database on theodore.it.rit.edu. User id is "330User", password is "330Password" For MySQL, use the Travel database from PE 1 on your local machine