JDBC CONNECTIVITY DYNAMIC SMALL PROJECT || ADVANCE JAVA VIDEO 2

YOU PEOPLE MAY ALSO RUN THE PROGRFAM BY USING COMMAND PROMPT THERE IS NO ISSUE ...
ANY DOUT WRITE IN COMMENT SCTION
package com.das;

import java.sql.Connection;
import java.sql.DriverManager;
import java.sql.SQLException;
import java.sql.Statement;
import java.util.Scanner;

public class Test {

public static void main(String[] args) throws ClassNotFoundException, SQLException {
// TODO Auto-generated method stub
Class.forName("oracle.jdbc.driver.OracleDriver");
System.out.println("Deriver loaded...");
Connection con=DriverManager.getConnection("jdbc:oracle:thin:@localhost:1521:xe","system","pradeep");
System.out.println("connection created.........");
Statement st=con.createStatement();

Scanner sc=new Scanner(System.in);
//there are only 40 seat at Utkal for pg in computer science
while(true)
{
System.out.println("Enter the eid");
int eid=sc.nextInt();
System.out.println("Enter the ename");
String ename=sc.next();
System.out.println("Enter the esal");
double esal=sc.nextDouble();
String q1="insert into emp values("+eid+",'"+ename+"',"+esal+")";
System.out.println(q1);
st.executeUpdate(q1);
System.out.println("one record sucessfully update...Do you want one more(yes/no)");
String option=sc.next();
if(option.equals("no"))
break;
}
st.close();
con.close();
sc.close();
System.out.println("connection closed sucessfully");



}

}