Fórum Executando consultas ao MySQL com java e datatable Primefaces #562628

<div
	style="width: 500px; float: left; margin-top: 150px; margin-left: 50px">
	<h:form>
		<p:panel id="panel" header="Campo de pesquisa"
			style="margin-bottom:10px;">
			<p:messages id="messages" />
			<h:panelGrid columns="4" cellpadding="5">
				<h:outputLabel for="txt1" value="Nome: " />
				<p:inputText id="txt1" value="#{itemMB.item.nome_item}"
					required="true" />
				<p:commandButton value="Pesquisar" id="botaoBusca"
					icon="ui-icon-arrowreturnthick-1-n" iconPos="right"
					actionListener="#{itemMB.pesquisar}" update="@form formComprarItem"
					styleClass="botaoMedio" />
			</h:panelGrid>
		</p:panel>
	</h:form>
</div>
<div>
<p:dataTable var="item" value="#{itemMB.listItems}" rows="15"
			paginator="true" paginatorPosition="bottom" selectionMode="single"
			selection="#{itemMB.item}" rowKey="#{item.cod_id}"
			emptyMessage="Lista vazia" scrollable="true" scrollHeight="456">

			<p:column style="width: 40px">
				<h:graphicImage
					value="resources/images/equipamentos/#{item.cod_icone}.png" />
			</p:column>

			<p:column headerText="Nome">
				<h:outputText value="#{item.nome_item}" />
			</p:column>

			<p:column headerText="Servidor" style="width: 50px">
				<h:outputText value="#{item.servidor}" />
			</p:column>

			<p:column headerText="Ref" style="width: 25px">
				<h:outputText value="#{item.refinacao}" />
			</p:column>

			<p:column headerText="Decrição" style="width: 100px">
				<h:outputText value="#{item.descricao}" />
			</p:column>

		</p:dataTable>
</div>