package com.mingri.dbconn;

import java.sql.*;
import com.mingri.dbconn.DBConn;

public class DBResult
{
  private Connection con;
  public  DBResult(){
    this.con=DBConn.getConnection();
  }
  /**
   * 用于獲得執行SQL語句的ResultSet對象
   */
  public ResultSet getResult(String sql){
    try{
      Statement stmt=con.createStatement();
      ResultSet rs=stmt.executeQuery(sql);
      return rs;
    }
    catch(Exception e){}
    return null;
  }
  /**
   * 用于執行SQL語句沒有返回值
   */
  public void doExecute(String sql){
    try{
      Statement stmt=con.createStatement();
      stmt.executeQuery(sql);
    }catch(Exception e){}
  }
  /**
   * 用于獲得執行SQL語句的PreparedStatement(預處理)對象
   */
  public PreparedStatement getPreparedStatement(String sql){
    try{
      PreparedStatement pstmt=con.prepareStatement(sql);
      return pstmt;
    }
    catch(Exception e){}
    return null;
  }
  /**
   * 關閉連接
   */
  public void closeCon(){
    try{
      this.con.close();
    }catch(Exception e){
        e.printStackTrace();
    }
  }
}