jdbc连接oracle

import java.sql.Connection;

import java.sql.DriverManager;

import java.sql.ResultSet;

import java.sql.SQLException;

import java.sql.Statement;

 

 

public class Test {

 

public static void main(String[] args) {  

 ResultSet rs = null;  

 Statement stmt = null;  

 Connection conn = null;  

 try {  

  Class.forName("oracle.jdbc.driver.OracleDriver");  

  //new oracle.jdbc.driver.OracleDriver();  

  conn = DriverManager.getConnection("jdbc:oracle:thin:@127.0.0.1:1521:orcl", "demo", "demo");  

  stmt = conn.createStatement();  

  rs = stmt.executeQuery("select * from tm_department");  

  while(rs.next()) {  

   System.out.println(rs.getString("DEPT_NAME"));  

   //System.out.println(rs.getInt("deptno"));  

  }  

 } catch (ClassNotFoundException e) {  

  e.printStackTrace();  

 } catch (SQLException e) {  

  e.printStackTrace();  

 } finally {  

  try {  

   if(rs != null) {  

    rs.close();  

    rs = null;  

   }  

   if(stmt != null) {  

    stmt.close();  

    stmt = null;  

   }  

   if(conn != null) {  

    conn.close();  

    conn = null;  

   }  

  } catch (SQLException e) {  

   e.printStackTrace();  

  }  

 }  

}  

}