JAVA 鏈接oracle 數據庫簡單例子

 publi class jdbc
{
   public static void main(String[] args) 
  {
   String ora="oracle.jdbc.driver.OracleDriver";
  Connection conn=null;
  Statement stmt=null;
  ResultSet rs=null;
  System.out.println("臱笆竟更Θ ");
  String url="jdbc:oracle:thin:@192.168.3.5:1521:test";
  String user="test";
  String pass="test";
  String sql="select * from table_name";

  try{
      Class.forName(ora);
   conn=DriverManager.getConnection(url,user,pass);
   stmt=conn.createStatement();
   rs=stmt.executeQuery(sql);
   while(rs.next){
       System.out.print("璹虫"+ rs.getString(1)+"る "+rs.getString(2));
   }
   rs.close();
   stmt.close();
   conn.close();
  }
  catch(ClassNotFoundException ex){
      throw ex;
  }
  catch(SQLException sqlex){
      System.out.print(sqlex.getMessage());
  }
  catch(Exception ex){
      System.out.print(ex.getMessage());
  }
  finally {
             if(stmt!=null) stmt.close();
    if(conn!=null) conn.close();
  }
 }
}