package bean;

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

import persistence.DataBaseConnection;

public class Bean {
    public void  executeUpdate(String sql){
    	DataBaseConnection dbc=new DataBaseConnection();
    	dbc.createConnection();
    	dbc.executeUpdate(sql);
    	dbc.commit();
    	dbc.closeDBConnection();
    }
    public List executeQuery(String sql){
    	List list=null;
    	DataBaseConnection dbc=new DataBaseConnection();
    	dbc.createConnection();
    	try {
			list=dbc.executeQueryForList(sql);
		} catch (SQLException e) {
			// TODO 自動生成 catch 塊
			e.printStackTrace();
		}
    	dbc.commit();
    	dbc.closeDBConnection();
		return list;
    }	
    
}