最简单的Java连接Oracle工具类

import java.sql.Connection;  
import java.sql.DriverManager;  
import java.sql.ResultSet;  
import java.sql.SQLException;  
import java.sql.Statement;  
/*
  * admin：lisong
  */
public class OracleConnectionMgr {  
 
    public static Connection getConnection() {  
        Connection con = null;  
        try {  
           Class.forName("oracle.jdbc.driver.OracleDriver");  
           String username = "scott";  
           String password = "tiger";  
           String url = "jdbc:oracle:thin:@127.0.0.1:1521:orcl";  
           con = DriverManager.getConnection(url, username, password);  
            } catch (Exception e) {  
            e.printStackTrace();  
        }  
        return con;  
    }  
 
    public static void closeResource(Connection con, Statement sm, ResultSet rs) {  
        try {  
           if (rs != null) {  
               rs.close();  
              
              }  
            if (sm != null) {  
                sm.close();               }  
            if (con != null) {  
                con.close();  
            }             
              
     } catch (SQLException se) {  
      se.printStackTrace();  
     }  
    }  
 
} 

//复制过去 把类名，userName，password，url 就可以了....