java connect()_java connect database

--reference JDBC API

//package ansir.sql.java;

import java.sql.*;

public class test{

public static void main(String args[]){

// load the driver

String col1;

String query="select cif_id from tbaadm.gam where cif_id is not null and rownum<10";

try{

//load the jdbc driver

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

Connection con=DriverManager.getConnection("jdbc:oracle:thin:@qcno009z.unix.anz:1521:ACEFI32T","custom","custom123");

Statement stmt=con.createStatement();

ResultSet rs=stmt.executeQuery(query);

while(rs.next()){

col1=rs.getString("cif_id");

System.out.println("cif_id:"+col1);

}

con.close();

}

catch(ClassNotFoundException e){

e.printStackTrace();

}

catch(SQLException e){

e.printStackTrace();

}

}

}