java connect database

最新推荐文章于 2022-09-16 08:48:17 发布

clkj12345

最新推荐文章于 2022-09-16 08:48:17 发布

阅读量203

点赞数

文章标签： java 数据库

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

}
}