package database;

import java.sql.*;

public class ConnectDataBase {

 public ConnectDataBase(){
  
 }
 //使用oracle(ojdbc14.jar)
 private static String driver="oracle.jdbc.driver.OracleDriver";
 private static String url="jdbc:oracle:thin:@127.0.0.1:1521:moyq";
 private static String username="sjzx";
 private static String password="sjzx";
 
 /*
  * 創(chuàng)建數(shù)據(jù)庫連接
  */
 public static Connection createConn(){
  Connection conn=null;
  try {
   //如果是sql server連接 ,使用oracle(sqljdbc.jar)
//   driver="com.microsoft.sqlserver.jdbc.SQLServerDriver";
//   url="jdbc:sqlserver://127.0.0.1:1433;DatabaseName=dsn";
//   username="sa";
//   password="123456";
   Class.forName(driver);
   System.out.println("驅動成功");
   System.out.println(driver);
   conn=DriverManager.getConnection(url, username, password);
   System.out.println("connection連接成功");
  } catch (Exception e) {
   // TODO: handle exception
   System.out.println("connection出現(xiàn)異常");
   e.printStackTrace();
  }
  return conn;
 }
 /*
  * 關閉數(shù)據(jù)庫連接
  */
 public static void Close(ResultSet rs,PreparedStatement ps,Connection conn){
  try {
   if(rs!=null)rs.close();
   if(ps!=null)ps.close();
   if(conn!=null)conn.close();
  } catch (Exception e) {
   // TODO: handle exception
   System.out.println("關閉連接出錯，含有ResultSet");
   e.printStackTrace();
  }
 }
 
 public static void Close(ResultSet rs,Statement stat,Connection conn){
  try {
   if(rs!=null)rs.close();
   if(stat!=null)stat.close();
   if(conn!=null)conn.close();
  } catch (Exception e) {
   // TODO: handle exception
   System.out.println("關閉連接出錯，含有ResultSet");
   e.printStackTrace();
  }
 }
 public static void Close(PreparedStatement ps,Connection conn){
  try {
   
   if(ps!=null)ps.close();
   if(conn!=null)conn.close();
  } catch (Exception e) {
   // TODO: handle exception
   System.out.println("關閉連接出錯，沒有ResultSet");
   e.printStackTrace();
  }
 }
 /**
  * @param args
  */
 public static void main(String[] args){
  ConnectDataBase.createConn();
 }

}