package com.chapter11;

import java.sql.*;

//這個(gè)類(lèi)繼承自ConnectDB類(lèi)
public class ExecuteDB extends ConnectDB
{
	//數(shù)據(jù)庫(kù)連接對(duì)象
	private Connection dbConn;
	private Statement stmt;
	private ResultSet rs;	
    //error 描述 錯(cuò)誤信息
    private String errMes;
	
	//初始化操作
	public ExecuteDB()
	{
		dbConn = super.getConn();
		stmt = null;
		rs = null;	
		this.errMes = super.getErrMes();		
	}
	
	 //執(zhí)行sql 執(zhí)行語(yǔ)句，主要是執(zhí)行插入和刪除的SQL語(yǔ)句
	public boolean exeSql(String strSql)
	{
		boolean isSuc = false;		
		try
		{
   			stmt=dbConn.createStatement();
			stmt.executeUpdate(strSql);	
			stmt.close();	
			isSuc = true;            
		}
		catch(Exception e)
		{
			this.errMes = this.errMes + "<br>" +e.toString();			
		}			
		return isSuc;
	}
	
	//執(zhí)行sql查詢(xún)語(yǔ)句    
    public ResultSet exeQuery(String strSql)
	{		
		try
		{
   			stmt=dbConn.createStatement();
			rs =stmt.executeQuery(strSql);			            
		}
		catch(Exception e)
		{	
            this.errMes = this.errMes + "<br>" +e.toString();	
			rs = null;
		}	
		return rs;
	}
	
    //取得錯(cuò)誤信息
    public String getErrMes()
    {
        return errMes;
    }		
}