@Override
	public List<EmpresaBean> listar() {
		List<EmpresaBean> listBean = new ArrayList<EmpresaBean>();
		ResultSet rs = null;
		Statement st = null;
		try{
			st = conn.createStatement();
			String SQL = "SELECT * FROM Dig_Empresa emp INNER JOIN Dig_Horario_Funcionamento func"+
					" on emp.id_Empresa = func.id_empresa ORDER BY emp.razao_Social";
			rs = st.executeQuery(SQL);
			
			while(rs.next()){
				EmpresaBean bean = new EmpresaBean();
				bean.setIdEmpresa(rs.getLong("id_empresa"));
				bean.setRazaoSocial(rs.getString("razao_Social"));
				bean.setCnpj(rs.getString("cnpj"));
				bean.setTelefone(rs.getString("telefone"));
				bean.seteMail(rs.getString("email"));
				bean.setEndereco(rs.getString("endereco"));
				bean.setCidade(rs.getString("cidade"));
				bean.setEstado(rs.getString("estado"));
				bean.setHorarioDeSegSexta(rs.getTime("deSegSexta").toString());
				bean.setHorarioAteSegSexta(rs.getTime("ateSegSexta").toString());
				bean.setHorarioDeSabado(rs.getTime("deSabado").toString());
				bean.setHorarioAteSabado(rs.getTime("ateSabado").toString());
				bean.setHorarioDeDomingo(rs.getTime("deDomingo").toString());
				bean.setHorarioAteDomingo(rs.getTime("ateDomingo").toString());
				bean.setEmpresaStr(bean.getRazaoSocial()+" - " + bean.getEndereco()+" - " + bean.getCidade()+" - "+bean.getEstado());
				
				listBean.add(bean);					
			}
			
		}catch(SQLException sql){
			sql.printStackTrace();
		}catch(Exception e){
			e.printStackTrace();
			
		}finally{
			try {
				rs.close();
				st.close();
			} catch (SQLException e) {
				// TODO Auto-generated catch block
				e.printStackTrace();
			}
			fecharConexao();
		}		
		
		return listBean;
	}