Olá
Pessoal nesse meu formulário quando eu faço submit dos dados ele grava na base sujeira.
Exemplo:
Digito no campo ramo de atividade: ação ele grava na base oracle ação
Alguem saberia me dizer o que esta rolando?
segue o formulario.
Att.
Silva
<?xml version="1.0" encoding='UTF-8' ?>
<!DOCTYPE html PUBLIC "-//W3C//DTD XHTML 1.0 Transitional//EN" "http://www.w3.org/TR/xhtml1/DTD/xhtml1-transitional.dtd">
<html xmlns="http://www.w3.org/1999/xhtml"
xmlns:h="http://java.sun.com/jsf/html"
xmlns:ui="http://java.sun.com/jsf/facelets"
xmlns:f="http://java.sun.com/jsf/core"
xmlns:c="http://java.sun.com/jsp/jstl/core"
xmlns:p="http://primefaces.prime.com.tr/ui">
<h:head>
</h:head>
<h:body>
<h:form prependId="false" id="formConsulta" acceptcharset="ISO-8859-1">
<f:view contentType="text/html" >
<br />
<br />
<table border="0" cellspacing="0" cellpadding="0" align="center">
<tr>
<td style="height: 47px width: 10px">
<p:panel style="border:0; width: 950px;">
<p:messages id="msCadastrar" showDetail="true" autoUpdate="true" />
<div style="z-index: 9999;" >
<table border="0" cellspacing="0" cellpadding="0" align="center">
<tr>
<td style="height: 53px width: 10px">
<p:panel id="cadCliente" header="DADOS DO CONTRATANTE" >
<p:panel style="border:none;" >
<table id="fundoCinza" >
<tr>
<td>
<!-- Primeira Coluna -->
<h:outputLabel value="CNPJ:" class="textoAzulLabel" />
</td>
<td class="dif" >
<!-- Segunda Coluna -->
<p:autoComplete disabled="true" rendered="#{not empty cotadorBean.CNPJDesabled}" maxlength="18" size="40" id="acCNPJCli"
value="#{cotadorBean.memento.idCNPJClienteHidden}"
style="float:left"
selectListener="#{cotadorBean.handleSelect}"
completeMethod="#{cotadorBean.completeCNPJ}" >
</p:autoComplete>
<p:autoComplete styleclass="tooltip" rendered="#{empty cotadorBean.CNPJDesabled}" maxlength="18" size="40" id="acCNPJClidesabled"
value="#{cotadorBean.memento.idCNPJClienteHidden}"
style="float:left"
selectListener="#{cotadorBean.handleSelect}"
completeMethod="#{cotadorBean.completeCNPJ}" onkeyup="numerico(this);" >
</p:autoComplete>
</td>
<td class="dif" >
<p:commandButton value="Pesquisar" image="ui-icon ui-icon-search" update="cadCliente acCNPJCli acCNPJClidesabled ih" action="#{cotadorBean.consultarCliente}" />
</td>
</tr>
<!-- Segunda Linha -->
<tr>
<td>
<h:outputLabel value="Razão Social:" class="textoAzulLabel" />
</td>
<td class="dif" >
<p:autoComplete size="40" id="acRazSocCli"
value="#{cotadorBean.memento.idClienteHidden}"
selectListener="#{cotadorBean.handleSelect}" maxlength="99"
completeMethod="#{cotadorBean.complete}">
</p:autoComplete>
</td>
<td class="dif" >
<p:commandButton value="Pesquisar" image="ui-icon ui-icon-search" update="cadCliente acCNPJCli acCNPJClidesabled ih" action="#{cotadorBean.consultarCliente}" />
</td>
</tr>
<!-- Terceira Linha -->
<tr>
<td>
<h:outputLabel value="Nome Fantasia:" class="textoAzulLabel" />
</td>
<td class="dif" >
<p:inputText id="nomeFantasia" value="#{cotadorBean.clienteVO.nomeFantasia}" size="40" style="float:left;" maxlength="99">
</p:inputText>
</td>
</tr>
<!-- Quarta Linha -->
<tr>
<td>
<h:outputLabel value="Ramo de Atividade:" class="textoAzulLabel" />
</td>
<td class="dif" >
<p:inputText value="#{cotadorBean.clienteVO.ramoAtividade}" size="40" style="float:left;" maxlength="29" />
</td>
<td>
<h:outputLabel value="Inscr. Municipal:" class="textoAzulLabel" />
</td>
<td class="dif" >
<p:inputText value="#{cotadorBean.clienteVO.inscricaoMunicipal}" size="40" style="float:left;" maxlength="29" />
</td>
</tr>
</table>
</p:panel>
<p:panel style="float:center; border:none;" >
<p:column>
<p:commandButton style="float:center;" update="msCadastrar" value="Salvar" action="#{cotadorBean.cadastroAlteracaoCliente}" />
</p:column>
<p:column>
<p:commandButton style="float:center;" image="ui-icon ui-icon-close" value="Fechar" onclick="fechar()" actionListener="#{cotadorBean.limparFormCadastroCliente}" />
</p:column>
<p:column>
<p:commandButton style="float:center;" image="ui-icon ui-icon-search" update="cadCliente msCadastrar acCNPJCli" value="Limpar formulário" action="#{cotadorBean.limparFormCadastroCliente}" />
</p:column>
</p:panel>
</p:panel>
</td>
</tr>
</table>
</div>
</p:panel>
</td>
</tr>
</table>
</f:view>
</h:form>
</h:body>
</html>
