public HorarioFuncionamentoBean buscarHorarioFuncionamento(String data,
			String diaSemana, Long idEmpresa) {
		
		HorarioFuncionamentoBean bean = new HorarioFuncionamentoBean();
		
		ResultSet rs = null;
		//Statement st = null;
		PreparedStatement ps = null;
		try{
			//st = conn.createStatement();
			String SQL = "SELECT de"+diaSemana+", ate"+diaSemana+" FROM dig_horario_funcionamento " +
					"WHERE id_empresa = "+idEmpresa;
			ps = conn.prepareStatement(SQL);
	
			rs = ps.executeQuery();
			
			if(rs.next()){
				bean.setDe(rs.getTime(1).toString().substring(0, 5));
				bean.setAte(rs.getTime(2).toString().substring(0, 5));				
			}
			bean.setDiasSemana(data);			
		}catch(SQLException sql){
			sql.printStackTrace();
		}catch(Exception e){
			e.printStackTrace();
			
		}finally{
			try {
				rs.close();
				ps.close();
			} catch (SQLException e) {
				e.printStackTrace();
			}
			fecharConexao();
		}		
		return bean;
	}