Question

***JAVA***

Connect to a database to extract the data. This does not need to be a real database. For this portion of your project, you are just writing the code to connect to a database. You are not actually connecting to any specific database. You must include all of the necessary code to read from and write to the database. Just be sure to comment out all of the code so you can still run your program.

Answer 1

Below is the Java code for connecting with the database and executing the query. testdatabse is a sample database name taken for demonstration, it could be changed with any other database name.

Code-

import java.sql.*;  
class MysqlCon{  
public static void main(String args[]){  
try{  
Class.forName("com.mysql.jdbc.Driver"); // Loaing the driver class file into the memory
Connection con=DriverManager.getConnection(  
"jdbc:mysql://localhost:3306/tesdatabase","root","root"); // establishing connection
//here testdatabase is database name, root is username and password  
Statement stmt=con.createStatement(); // interacting with database using createStatement()
ResultSet rs=stmt.executeQuery("select * from student"); // Executing the query. student is a dummy // table.

while(rs.next())  

System.out.println(rs.getInt(1)+" "+rs.getString(2)+" "+rs.getString(3)); // Fetching the records
con.close(); // Closing the connection
}catch(Exception e){ System.out.println(e);}  
}  
}  

Code screenshot-