JDBC工具类

package com.zw.tool;

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

public class Tool {

 private static Connection conn=null;
 private static Statement st=null;
 private static ResultSet rs=null;
 
 public static Connection getConnection(){
  try {
   Class.forName("oracle.jdbc.driver.OracleDriver");
   String url="jdbc:oracle:thin:@localhost:1521:orcl";
   conn=DriverManager.getConnection(url,"scott","tiger");
  } catch (ClassNotFoundException e) {
   // TODO Auto-generated catch block
   e.printStackTrace();
  } catch (SQLException e) {
   // TODO Auto-generated catch block
   e.printStackTrace();
  }
  
  return conn;
  
 }
 
 public static void close(Connection conn,Statement ps,ResultSet rs){
  try {
   if(rs!=null)
   rs.close();
  } catch (SQLException e) {
   e.printStackTrace();
  }finally{
   try {
    if(ps!=null)
     ps.close();
   } catch (SQLException e) {
    // TODO Auto-generated catch block
    e.printStackTrace();
   }finally{
    try {
     if(conn!=null)
     conn.close();
    } catch (SQLException e) {
     // TODO Auto-generated catch block
     e.printStackTrace();
    }
   }
  }
  
  
 }
}