ii

package com.neusoft.dao;

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

public class DbUtils
{
 private DbUtils(){}
 private static Connection conn;
 public static Connection getConnection()
 {
  try
  {
   DriverManager.registerDriver(new oracle.jdbc.driver.OracleDriver());
   //2.连接数据库，获取数据库连接对象
   String url="jdbc:oracle:thin:@zhangyahui:1521:oracle";
   String user="scott";
   String password="0000";
   conn=DriverManager.getConnection(url,user,password);
  } catch (SQLException e)
  {
   // TODO Auto-generated catch block
   e.printStackTrace();
  }
  return conn;
  }
 public static  void closeConnection()
 {
  try {
   if(conn!=null)
   {
    conn.close();
   }
  } catch (SQLException e) {
   // TODO Auto-generated catch block
   e.printStackTrace();
  } 
 }
 public static void closeStatement(Statement stmt)
 {
  try {
   if(stmt!=null)
   {
    stmt.close();
   }
  } catch (SQLException e) {
   // TODO Auto-generated catch block
   e.printStackTrace();
  }
  }
 public static void closeResultSet(ResultSet rs)
 {
  //4.关闭数据库
  try {
   if(rs!=null)
   {
    rs.close();
   }
  } catch (SQLException e) {
   // TODO Auto-generated catch block
   e.printStackTrace();
  }
  }
}