java连接oracle

 

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

public class DBTools1 {
 public static Connection getConnection(){
  Connection conn=null;
  String driver="oracle.jdbc.driver.OracleDriver";
  String url="jdbc:oracle:thin:@localhost:1521:orcl";
  String userName="jack";
  String Passeword="qwe123";
  try {
   Class.forName(driver);
   conn = DriverManager.getConnection(
     url, userName, Passeword);
  } catch (Exception e) {
   // TODO Auto-generated catch block
   e.printStackTrace();
  }
  return conn;
  
 }
 public static void closeConnection(Connection conn){
  try {
   if(null!=conn){
   conn.close();
   }
  } catch (SQLException e) {
   // TODO Auto-generated catch block
   e.printStackTrace();
  }
  }
 public static void closeStatement(Statement state){
  if(null!=state){
  try {
   state.close();
  } catch (SQLException e) {
   // TODO Auto-generated catch block
   e.printStackTrace();
  }
 }
 }
 public static void closeResultSet(ResultSet rs){
  if(null!=rs){
   try {
    rs.close();
   } catch (SQLException e) {
    // TODO Auto-generated catch block
    e.printStackTrace();
   }
  }
  }
}