Java code to connect Oracle database using JDBC driver

Making JDBC Query to database using code

 Connection conn=null;

 ResultSet rs1=null;

try

{

 PreparedStatement ps1=null;

Class.forName("oracle.jdbc.driver.OracleDriver");

conn = DriverManager.getConnection( "jdbc:oracle:thin:@127.0.0.1:1521:XE", "system", "manager");

Statement stmt = conn.createStatement();

rs1= stmt.executeQuery("select SUBJECT from HR.SUBJECT ");

}

catch(SQLException e)

{

while((e = e.getNextException()) != null) out.println(e.getMessage() + "");

  }

catch(ClassNotFoundException e)

{

 }

Reading the ResultSet

 try{
while(rs1.next()){
String ComboBoxValue1=rs1.getString("SUBJECT")  ; 
 }
                 catch(Exception exp){
 out.println("exception in populating subjects");
 }

Share

Tweet

.