JDBC

"Program to implement JDBC in Java"
import java.sql.*; 
import java.util.*; 
class First_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();

				//create table query
			 String sql = "CREATE TABLE EMPLOYEE " +
                   "(id INTEGER not NULL, " +
                   " Name VARCHAR(255), " + 
                   " Age INTEGER, " + 
				   " DEPT VARCHAR(255), " +
				   " SALARY INTEGER, " +
                   " PRIMARY KEY ( id ))"; 
		    
		    			
			System.out.println("creating table in a database...");
			st.executeUpdate(sql);

						//insering data into table
			System.out.println("insering data into table");

			 sql = "INSERT INTO EMPLOYEE " +
                   "VALUES (1, 'Sam',25,'Sales',80000)";
                st.executeUpdate(sql);
			 sql = "INSERT INTO EMPLOYEE " +
                   "VALUES (2, 'emily',24,'Management',850000)";
                st.executeUpdate(sql);
			sql = "INSERT INTO EMPLOYEE " +
                   "VALUES (3, 'joe',22,'IT',780000)";
                st.executeUpdate(sql);
			sql = "INSERT INTO EMPLOYEE " +
                   "VALUES (4, 'doe',20,'Logistics',700000)";
                st.executeUpdate(sql);
			sql = "INSERT INTO EMPLOYEE " +
                   "VALUES (5, 'nina',26,'Public Relations',750000)";
                st.executeUpdate(sql);




           System.out.println("closing connection...");
		   con.close();

		           }catch(SQLException se){

			 se.printStackTrace();
		}

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

		 }

    }
}