Página JSP

Me ajudem a descobrir porque essa página JSP não está funcionando.
Na linha:

NÃO APARECE O VALOR DA VARIÁVEL CODIGO!!!

Segue abaixo:

&lt;%@ page import=&quot;java.sql.*&quot; %&gt;
&lt;%@ page import=&quot;java.lang.String&quot; %&gt;
&lt;html&gt;
&lt;body&gt;
&lt;%
    Connection con = null;
    Statement st = null;

    try&#123;
       Class.forName&#40;&quot;sun.jdbc.odbc.JdbcOdbcDriver&quot;&#41;;
    &#125;
    catch &#40;Exception e&#41;&#123;
          System.out.println&#40;&quot;Erro&quot; + e&#41;;
    &#125;
    try&#123;
	con = DriverManager.getConnection&#40;&quot;jdbc&#58;odbc&#58;Controle_Contratos&quot;,&quot;&quot;,&quot;&quot;&#41;;
    &#125;
    catch&#40;SQLException k&#41;&#123;
          System.out.println&#40;&quot;Erro&quot; + k&#41;;
    &#125;
    try&#123;
	st = con.createStatement&#40;&#41;;
        
        int codigo;

        ResultSet rs = st.executeQuery&#40;&quot;select max&#40;codContrato&#41;as codigo from tbContratos&quot;&#41;;

        codigo = rs.getInt&#40;&quot;codigo&quot;&#41;+1;

            st.close&#40;&#41;;
            con.close&#40;&#41;;
        
	&#125;catch&#40;Exception s&#41;&#123;
	
	System.out.println&#40;&quot;Erro&#58;&quot; + s&#41;;
	&#125;
	finally&#123;
	  try&#123;
	  	if&#40;st != null&#41;
	  	   st.close&#40;&#41;;
	  	 
	  	 &#125; catch &#40;SQLException a&#41;&#123;&#125;
	  	 try&#123;
	  	 	if&#40;con!= null&#41;
	  	 	   con.close&#40;&#41;;
	&#125;catch&#40;SQLException a&#41;&#123;&#125;
      
&#125;%&gt;

&lt;form method=&quot;POST&quot; action=&quot;incluirContrato.jsp&quot;&gt;
  &lt;table&gt;
  &lt;tr&gt;
      &lt;td width=&quot;16%&quot;&gt;Código Contrato&#58;&lt;/td&gt;
      &lt;td width=&quot;84%&quot;&gt;&lt;input type=&quot;text&quot; name=&quot;tfcodContrato&quot; size=&quot;20&quot; value=&quot;&lt;%= codigo %&gt;&quot;&gt;&lt;/td&gt;
  &lt;/tr&gt;
 &lt;tr&gt;
      &lt;td width=&quot;16%&quot;&gt;Número Contrato&#58;&lt;/td&gt;
      &lt;td width=&quot;84%&quot;&gt;&lt;input type=&quot;text&quot; name=&quot;tfNumContrato&quot; size=&quot;20&quot;&gt;&lt;/td&gt;
  &lt;/tr&gt;
  &lt;tr&gt;
      &lt;td width=&quot;16%&quot;&gt;Fornecedor&#58;&lt;/td&gt;
      &lt;td width=&quot;84%&quot;&gt;&lt;input type=&quot;text&quot; name=&quot;tfFornecedor&quot; size=&quot;20&quot;&gt;&lt;/td&gt;
  &lt;/tr&gt;
  &lt;tr&gt;
      &lt;td&gt;Assunto&lt;/td&gt;
      &lt;td&gt;&lt;input type=&quot;text&quot; name=&quot;tfAssunto&quot; size=&quot;20&quot;&gt;&lt;/td&gt;
  &lt;/tr&gt;
  &lt;/table&gt;
  &lt;p&gt;&lt;input type=&quot;submit&quot; value=&quot;Enviar&quot; name=&quot;btEnviar&quot;&gt;&lt;input type=&quot;reset&quot; value=&quot;Limpar&quot; name=&quot;btLimpar&quot;&gt;&lt;/p&gt;
&lt;/form&gt;
&lt;/body&gt;
&lt;/html&gt;

Obrigada

[color="#009900"]Alterado para conter o BBCode - CODE[/color]

3 Respostas

jeveauxPJ 10 de abr. de 2005

Thais, bom, o mais provável é o seu select não estar trazendo resultado mesmo…

Quando vc roda isso direto no banco

select max&#40;codContrato&#41;as codigo from tbContratos

Vem alguma coisa?

T+

Guilherme_MelloPJ 10 de abr. de 2005

Thais, como o jeve disse verifique se a chave primaria da sua tabela é realmente codContrato…

teste seu sql em algum cliente que tenha o seu DB…

marceloedreiPJ 10 de abr. de 2005

Tente fazer assim:

value="&lt;%out.print&#40;codigo&#41; %&gt;"&gt;

Ate mais!!!

3 Respostas

Topicos relacionados