java connect database

--reference JDBC API

http://www.oracle.com/technetwork/java/javase/jdbc/index.html

http://download.oracle.com/javase/1.5.0/docs/guide/jdbc/

//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();
  }
  
 }
}

来自 “ ITPUB博客 ” ，链接：http://blog.itpub.net/25951437/viewspace-700885/，如需转载，请注明出处，否则将追究法律责任。

转载于:http://blog.itpub.net/25951437/viewspace-700885/