import java.sql.Connection; import java.sql.DriverManager; import java.sql.ResultSet; import java.sql.SQLException; import java.sql.Statement; import java.util.Scanner; public class Emp{ public static void main(String[] args) { System.out.println("Getting Employee Details Using resultset metadata: "); Connection con = null; String url = "jdbc:oracle:thin:@172.24.137.30:1521:ORA10G";; String driver = "oracle.jdbc.driver.OracleDriver"; String user = "e206227"; String pass = "VeuFmodax"; try{ Class.forName(driver); con = DriverManager.getConnection(url, user, pass); try{ Emp e=new Emp(); Scanner sc=new Scanner(System.in); int ch=sc.nextInt(); switch(ch) { case 1: e.viewDetails(con); break; case 2: e.addDetails(con); break; } } catch (Exception s){ System.out.println("SQL statement is not executed!"); } } catch (Exception e){ e.printStackTrace(); } } public void viewDetails(Connection con) { try{ Statement st = con.createStatement(); ResultSet rs = st.executeQuery("SELECT * FROM employee"); while(rs.next()) { System.out.print("\t"+rs.getString(1)); System.out.print("\t"+rs.getString(2)); System.out.print("\t"+rs.getString(3)); System.out.print("\t"+rs.getString(4)); System.out.println("\t"+rs.getString(5)); } } catch(Exception e) { e.printStackTrace(); } } public void addDetails(Connection con) { try { Statement st = con.createStatement(); ResultSet rs = st.executeQuery("insert into employee values('emp005','rakesh',23000,7418767778,'[email protected] xyz.com')"); } catch(Exception e) { e.printStackTrace(); } } }
Ads