JDBC_2

//Connecting to sql database server and printing the database table

import java.sql.*;
import java.util.*;

class Second_JDBC
{
    public static void main(String a[])
    {
        //Creating the connection
        String url = "jdbc:mysql://sqldatabase.cecptglr57pt.us-east-1.rds.amazonaws.com:3306/firstdb";
        String user = "admin";
        String pass = "admin12345";

        Connection con=null;
		Statement st=null;

	try
        { 
            Class.forName("com.mysql.jdbc.Driver");
  
            //Reference to connection interface 
            con = DriverManager.getConnection(url,user,pass); 
		      System.out.println("connection successfull!");
			
			st = con.createStatement();

	//query 
			 String sql = "SELECT * FROM EMPLOYEE";
			 
			 //getting query result  from the table
			  System.out.println("getting query result  from the table...");
			 ResultSet rs = st.executeQuery(sql);

	//printing the table
			  System.out.println("\n\n");
			  System.out.println("id  Name  Age  Dept salary");
              while(rs.next()){  
             System.out.println(rs.getString(1)+"  "+rs.getString(2)+"  "+rs.getString(3)+"  "+rs.getString(4)+"  "+rs.getString(5));
			  }

		System.out.println("\nclosing connection...");
		   con.close();
        }

	catch(SQLException se){

			 se.printStackTrace();
		}
	        catch(Exception ex) 
        { 
            System.err.println(ex); 
			System.out.println("connection error");
        }
         finally{
			  
		 }		
		
    } 
}