orlacle

import java.sql.*;
public class TestJDBC {

 public static void main(String[] args)  {
     
   Connection conn = null;
   Statement stmt = null;
   ResultSet rs  = null;
 try {
       Class.forName("oracle.jdbc.driver.OracleDriver");
       // new orcle.jdbc.driber.OracleDriver();
           conn =  DriverManager.getConnection("jdbc:oracle:thin:@10.40.8.105:1521:orcl", "scott", "tubiaosong");
           stmt= conn.createStatement();
           // ResultSet rs =executeQuery("select * from dept");
            stmt.executeQuery("select * from dept");
           rs = stmt.getResultSet();
           while (rs.next()){
            System.out.println(rs.getString("deptno"));
           }
        }catch (ClassNotFoundException e){
        e.printStackTrace();
        }catch (SQLException e) {
        e.printStackTrace();
        }finally {
       
         try {
          if(rs !=null){
           rs.close();
          }
    if(stmt !=null){
              stmt.close();
            }
           if(conn !=null){
           conn.close();
            } 
   } catch (SQLException e) {
    e.printStackTrace();
   }      
         
       }
 }

}