1 import java.sql.Connection; 2 import java.sql.DriverManager; 3 import java.sql.PReparedStatement; 4 import java.sql.ResultSet; 5 import java.sql.SQLException; 6  7 /** 8  * oracle數據庫驅動類     封裝 9  * @author Administrator10  *11  */12 public class Oracle {13     14     final String Driver="oracle.jdbc.driver.OracleDriver";  //oracle驅動　　　15     final String url="jdbc:oracle:thin:@localhost:1521:orcl";  //1521：端口    orcl:數據庫名16     final String username="News";  //oracle數據庫用戶名17     final String passWord="197520";  //oracle數據庫密碼18     19     /*20      * 封裝連接21      */22     public Connection getConnection(){23         Connection cn=null;  //聲明驅動24         25         try {26             27             Class.forName(Driver);//加載驅動28             29             cn=DriverManager.getConnection(url,username,password);//建立連接30             31         } catch (ClassNotFoundException e) {32             // TODO Auto-generated catch block33             e.printStackTrace();34         } catch (SQLException e) {35             // TODO Auto-generated catch block36             e.printStackTrace();37         }38         return cn;39     }40     41     /*42      * 關閉結果集，操作，連接43      */44     45     public void Close(ResultSet rs,PreparedStatement ps,Connection cn){46         try{47             //判定是否為空值48             if(rs!=null){49                 rs.close();50             }51             if(ps!=null){52                 ps.close();53             }54             if(cn!=null){55                 cn.close();56             }57         }catch(SQLException e){58             e.printStackTrace();59         }60     }61     62 }