package com.acccp.fan.db;

import java.sql.PreparedStatement;
import java.sql.SQLException;
import java.util.List;

import javax.naming.Context;
import javax.naming.InitialContext;
import javax.naming.NamingException;
import javax.sql.DataSource;

import org.apache.commons.dbutils.QueryRunner;
import org.apache.commons.dbutils.ResultSetHandler;

public  class Basedao {
	
	private static DataSource ds=null;
	//private Connection conn=null;
	public Basedao() {	
	}
	
	//一加載類時 靜態塊就會執行
	static {
		try {
			Context context=new InitialContext();
			ds=(DataSource) context.lookup("java:comp/env/jdbc/addressBook");
			
		} catch (NamingException e) {
			// TODO Auto-generated catch block
			e.printStackTrace();
		}	
	}
	
	//全查 無參
	public List getAllNoteBook(String sql,ResultSetHandler rsh) throws SQLException{
		QueryRunner qr=new QueryRunner(ds);
		List list=(List) qr.query(sql, rsh);
		return list;		
	}
	
	
	//帶參數查詢
	protected List getNoteBookById(String sql,Object [] args,ResultSetHandler rsh) throws SQLException{
		QueryRunner qr=new QueryRunner(ds);
		List list=(List) qr.query(sql, args, rsh);
		return list;
	}
	
	//增刪改
	protected void execute(String sql,Object []args , ResultSetHandler rsh) throws SQLException{
		PreparedStatement ps=ds.getConnection().prepareStatement(sql);
		for(int i=0;i<args.length;i++){
			ps.setObject(i+1,args[i] );
		}
		ps.executeUpdate();
	}
	
}