Dae Pessoal! Estou com um problema meio estranho, Faço uma consulta no banco de dados atraves de um servlet pego essas informaçoes e atribuo ao seu objeto (classe de modelo Cliente) e redireciono para uma pagina JSP q…

Mostar dados no JSP

M

matheusPJ 22 de jun. de 2005

vamos ao código

N

nadoPJ 22 de jun. de 2005

Vamos lá!

O servlet que busca as informações.

esponse.setContentType&#40;"text/html"&#41;;
         String cpf=request.getParameter&#40;"cpf"&#41;;
         String query="select * from cliente where clCPF='"+cpf+"'";
         ResultSet rs=null;
         rs=Conectar.getResultSet&#40;query&#41;;
         rs.next&#40;&#41;;
         BeanCliente cli = new BeanCliente&#40;&#41;;
         cli.setCodigo&#40;rs.getString&#40;"clCodigo"&#41;&#41;;
         cli.setNome&#40;rs.getString&#40;"clNome"&#41;&#41;; cli.setDataNascimento&#40;rs.getString&#40;"clDataNascimento"&#41;&#41;;
         cli.setCNH&#40;rs.getString&#40;"clCNH"&#41;&#41;; cli.setCPF&#40;rs.getString&#40;"clCPF"&#41;&#41;; cli.setEndereco&#40;rs.getString&#40;"clEndereco"&#41;&#41;;
         cli.setCidade&#40;rs.getString&#40;"clCidade"&#41;&#41;; cli.setBairro&#40;rs.getString&#40;"clBairro"&#41;&#41;; cli.setCEP&#40;rs.getString&#40;"clCEP"&#41;&#41;;
         cli.setEstado&#40;rs.getString&#40;"clEstado"&#41;&#41;; cli.setEmail&#40;rs.getString&#40;"clEmail"&#41;&#41;; cli.setTelefone&#40;rs.getString&#40;"clTelefone"&#41;&#41;;
         HttpSession session = request.getSession&#40;true&#41;;
         session.setAttribute&#40;"cli", cli&#41;;
         RequestDispatcher rd=request.getRequestDispatcher&#40;"/exibePesquisa.jsp"&#41;;
         rd.forward&#40;request, response&#41;;
         //response.sendRedirect&#40;"/exibePesquisa.jsp"&#41;;
    &#125;

O JSP que exibe a pesquisa

&lt;form action='http&#58;//localhost&#58;8084/locadora/ControleCliente' method=POST&gt;
		&lt;br&gt;
			&lt;table width="93%" border="0" cellpadding="0" cellspacing="1"&gt;
				&lt;tr&gt;    &lt;jsp&#58;getProperty name="cli"  property="codigo"/&gt; 
					&lt;td width="20%" align="center" class="fonteAzul"&gt; Cliente&#58; &lt;/td&gt;
					&lt;td&gt;&lt;input name="nome" type="text" value=&lt;jsp&#58;getProperty name="cli"  property="nome"/&gt; size="50"&gt;&lt;/td&gt;
				&lt;/tr&gt;
				&lt;tr&gt; 
					&lt;td width="20%" align="center" class="fonteAzul"&gt;Data de Nascimento&#58;&lt;/td&gt;
					&lt;td&gt;&lt;input name="data_nascimento" type="text" value=&lt;jsp&#58;getProperty name="cli"  property="dataNascimento"/&gt; size="10"&gt; 
					&lt;/td&gt;
				&lt;/tr&gt;
				&lt;tr&gt; 
					&lt;td width="20%" align="center" class="fonteAzul"&gt;CNH&#58;&lt;/td&gt;
					&lt;td &gt;&lt;input name="cnh" type="text" value=&lt;jsp&#58;getProperty name="cli"  property="CNH"/&gt; size="50""&gt;&lt;/td&gt;
				&lt;/tr&gt;
				&lt;tr&gt; 
					&lt;td width="20%" align="center" class="fonteAzul"&gt;CPF&#58;&lt;/td&gt;
					&lt;td &gt;&lt;input name="cpf" type="text" value=&lt;jsp&#58;getProperty name="cli"  property="CPF"/&gt; size="16"&gt;&lt;/td&gt;
				&lt;/tr&gt;
				&lt;tr&gt; 
					&lt;td width="20%" align="center" class="fonteAzul"&gt;Endere&amp;ccedil;o&#58;&lt;/td&gt;
					&lt;td &gt;&lt;input name="endereco" type="text" value=&lt;jsp&#58;getProperty name="cli"  property="endereco"/&gt; size="50"&gt;&lt;/td&gt;
				&lt;/tr&gt;
				&lt;tr&gt; 
					&lt;td width="20%" align="center" class="fonteAzul"&gt;Cidade&#58;&lt;/td&gt;
					&lt;td&gt;&lt;input name="cidade" type="text" value=&lt;jsp&#58;getProperty name="cli"  property="cidade"/&gt; size="50"&gt;&lt;/td&gt;
				&lt;/tr&gt;
				&lt;tr&gt; 
					&lt;td width="20%" align="center" class="fonteAzul"&gt;Bairro&#58;&lt;/td&gt;
					&lt;td &gt;&lt;input name="bairro" type="text" value=&lt;jsp&#58;getProperty name="cli"  property="bairro"/&gt; size="50"&gt;&lt;/td&gt;
				&lt;/tr&gt;
				&lt;tr&gt; 
					&lt;td width="20%" align="center" class="fonteAzul"&gt;Cep&#58;&lt;/td&gt;
					&lt;td&gt;&lt;input name="cep" type="text" value=&lt;jsp&#58;getProperty name="cli"  property="CEP"/&gt; size="10"&gt;&lt;/td&gt;
				&lt;/tr&gt;
				&lt;tr&gt; 
					&lt;td width="20%" align="center" class="fonteAzul"&gt;Estado&#58;&lt;/td&gt;
					&lt;td &gt;&lt;input name="estado" type="text" value=&lt;jsp&#58;getProperty name="cli"  property="estado"/&gt; size="50"&gt;&lt;/td&gt;
				&lt;/tr&gt;
				&lt;tr&gt;
					&lt;td width="20%" align="center" class="fonteAzul"&gt;E-mail&#58;&lt;/td&gt;
					&lt;td&gt;&lt;input name="email" type="text" value=&lt;jsp&#58;getProperty name="cli"  property="email"/&gt; size="50"&gt;&lt;/td&gt;
				&lt;/tr&gt;
				&lt;tr&gt; 
					&lt;td width="20%" align="center" class="fonteAzul"&gt;Telefone&#58;&lt;/td&gt;
					&lt;td&gt;&lt;input name="telefone" type="text" value=&lt;jsp&#58;getProperty name="cli"  property="telefone"/&gt; size="10"&gt;&lt;/td&gt;
				&lt;/tr&gt;
				&lt;tr align="center"&gt; 
					 &amp;nbsp;  
					 		  
					&lt;/td&gt;
				&lt;/tr&gt;
			&lt;/table&gt;
			&lt;center&gt;&lt;input type="submit" value="Alterar" name="comando" class="txtcinza"&gt;
                        &lt;input type="submit" value="Ver Reservas" name="comando" class="txtcinza"&gt;&lt;/center&gt;

Tai o maldito :twisted:

M

matheusPJ 22 de jun. de 2005

q estranho, se tu trocar

&lt;jsp&#58;getProperty name="cli"  property="nome"/&gt;

por

cli.getNome&#40;&#41;

no teu jsp mesmo, funciona? Ja testou?

N

nadoPJ 22 de jun. de 2005

Só testei no Servlet com out.println no JSP nunca!

Eu que pergunto será q. funciona???

M

matheusPJ 22 de jun. de 2005

“nado”:
Só testei no Servlet com out.println no JSP nunca!

Eu que pergunto será q. funciona???

meu… testa pra gente ir afunilando o problema. :???:

N

nadoPJ 22 de jun. de 2005

Pior que agora nao dá! só final da tarde.
Valeu.

B

bejetoPJ 22 de jun. de 2005

qual o codigo da sua jsp q exibe isso?

N

nadoPJ 22 de jun. de 2005

Esse ai

&gt;&lt;input name="nome" type="text" value=&lt;jsp&#58;getProperty name="cli"  property="nome"/&gt; size="50"&gt;

A

andre_marrentoPJ 22 de jun. de 2005

O que está faltando são as aspas (") no value do input… mude o seu código para

value="<jsp:getProperty name=“cli” property=“nome”/>"

T+

9 Respostas

Topicos relacionados