Fórum Excluindo apenas um registro com JDBC #560201

//Excluindo apenas um registro com JDBC
public boolean deletarItem(Item item) {
         try {
             Statement stmt = con.createStatement();  
           
             String sql = "DELETE FROM item WHERE cod_id='a int'";  
           
             int deleteCount = stmt.executeUpdate(sql);  

             sql = "DELETE FROM item WHERE cod_id=?";  
             PreparedStatement pstmt = con.prepareStatement(sql);  

             pstmt.setInt(1, item.getCod_id());

             deleteCount = pstmt.executeUpdate();
             return true;
     } catch (SQLException e) {
    	 return false;
         } 
    }

<p:dataTable var="item" value="#{itemMB.items}" rows="8"
			paginator="true" paginatorPosition="bottom">

			<p:column style="width: 40px">
				<h:outputText value="#{item.cod_id}" />
			</p:column>

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

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

			<p:column headerText="Vendedor" style="width: 80px; ">
				<h:outputLink id="vend" value="#">
					<h:outputText value="#{item.vendedor}" />
				</h:outputLink>
				<p:tooltip id="toolTipGrow" for="vend"
					value="Clique para ver o contato do vendedor" showEffect="clip"
					hideEffect="explode" position="top" />

			</p:column>

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

			<p:column headerText="D.registro" style="width: 70px">
				<h:outputText value="#{item.dataCadastro}" />
			</p:column>

			<p:column style="width: 25px">
				<p:commandButton id="selectButton" update=":cadastrados:display"
					onclick="PF('dlgx').show();" icon="ui-icon-trash" title="Cancelar Venda">
					<f:setPropertyActionListener value="#"
						target="#{itemMB.selecionarItem}" />
				</p:commandButton>
			</p:column>


		</p:dataTable>

		<p:dialog header="Cancelar Venda" widgetVar="dlgx" resizable="false"
			showEffect="fade" hideEffect="explode" modal="true">
			<h:panelGrid id="display" columns="1" cellpadding="4"
				style="margin:0 auto; font-family: Nunito; font-size: 14px;">
				<h:outputText value="Tem certeza que deseja cancelar a venda do item?"/>
				<h:outputText value="#{itemMB.selecionarItem.nome_item} (#{itemMB.selecionarItem.cod_id})"/>
				</h:panelGrid>
				<p:commandButton id="remover" value="Sim" styleClass="botaoMedio"
					action="#{itemMB.deletarItem}" update="cadastrados" />

				<p:commandButton value="Não"
					styleClass="botaoMedio" style="margin-left: 10px"
					onclick="PF('dlgx').hide()" />
			
		</p:dialog>
	</h:form>