Java连接Oracle实例

package com.isoftstone.jack.database;

import java.sql.Connection;
import java.sql.DriverManager;
import java.sql.ResultSet;
import java.sql.SQLException;
import java.sql.Statement;

public class TestJdbc
{
 public void createConnection()
 {
  Statement stmt = null;
  try
  {
   Class.forName("oracle.jdbc.driver.OracleDriver");
   String url = "jdbc:oracle:thin:@10.41.16.88:1521:ora";
   String username = "umcpmgt";
   String password = "icd";
   Connection con = DriverManager.getConnection(url, username, password);
   stmt = con.createStatement();
   
   ResultSet rs = stmt.executeQuery("select * from t_bss_accountinfo");
   while(rs.next())
   {
    System.out.println("userNo = " + rs.getString("AREA_CODE"));
   }

   
  }
  catch (SQLException e)
  {
   e.printStackTrace();
  }
  catch (ClassNotFoundException e)
  {
   System.out.println("ClassNotFoundException");
  }
  catch (Exception e)
  {
   System.out.println("Exception");
  }
  finally
  {
   try
   {
    stmt.close();
   }
   catch (SQLException e) {
    // TODO: handle exception
    System.out.println("stmt.close() SQLException");
   }

  }
  

 }

 /**
  * @param args
  */
 public static void main(String[] args)
 {

  TestJdbc tj = new TestJdbc();
  tj.createConnection();

 }

}