Executar Página JSP

Front-end
#1

Pessoal,

Preciso mostrar o resultado de uma consulta em uma página JSP.
Já fiz a página mas não aparece nada.
A consulta executa no Query Analizer direitinho.

O que pode estar errado.
Vejam abaixo:

<%@ page import=“java.sql.*” %>
<%@ page import=“java.lang.String” %>
<html>
<head>
<body>
<p align=“center”><font face=“Arial” size=“4”>CONTRATO</font></p>
<table border=“0”>
<%
String Fornecedor = request.getParameter(“cbContratado”);
String Objeto = request.getParameter(“cbObjeto”);

            Connection con = null;
Statement st = null;
ResultSet rs = null;

try{
Class.forName("sun.jdbc.odbc.JdbcOdbcDriver");
}
catch (Exception e){
       System.out.println("Erro" + e);
}
try{
   con = DriverManager.getConnection("jdbc:odbc:corporetemp","sysdba","masterkey");
}
catch(SQLException k){
      System.out.println("Erro" + k);
}
try{
        st = con.createStatement();
    
        //String query= "select * from ftb_contratos as con where CODCFO='"+ Fornecedor +"' and CON_OBJETO='"+ Objeto +"'";
        
        String consulta ="select distinct  con.con_codigo,con.CON_NUMCONTRATO,con.CODCCUSTOPGTO,con.CODCUSTOGESTOR,"+
                         "con.CODCFO,con.CON_OBJETO,con.CON_CONTRATANTE,con.CON_DTCADASTRO,val.val_valor,"+
                         "cla.cla_clausula,obs.obs_descricao,ini.ini_dtinicio,ter.ter_dttermino,"+
                         "vig.vig_vigencia,re.re_dtreajuste from ftb_contratos as con,"+
                         "ftb_valores as val,ftb_clausulas as cla,ftb_observacao as "+
                         "obs,ftb_inicios as ini,ftb_terminos as ter,ftb_vigencias as vig,ftb_reajustes as re "+
                         "where"+ 
                         "con.con_codigo = val.con_codigo and con.con_codigo = cla.con_codigo and "+
                         "con.con_codigo=obs.con_codigo and con.con_codigo = ini.con_codigo and "+
                         "con.con_codigo=ter.con_codigo and con.con_codigo=vig.con_codigo and "+
                         "con.con_codigo=re.con_codigo and "+
                         "con.codcfo='"+ Fornecedor +"'and con.con_objeto ='"+ Objeto +"'";
        //out.println(consulta);
        rs = st.executeQuery(consulta);
        out.println(rs);
        while (rs.next()){
%&gt;
    &lt;tr&gt;&lt;font face="Arial"&gt;&lt;td&gt;Código Contrato:&lt;/font&gt;&lt;/td&gt;&lt;td&gt;&lt;%= rs.getString("CON_CODIGO")%&gt;&amp;nbsp;&lt;/td&gt;&lt;/tr&gt;
    &lt;tr&gt;&lt;font face="Arial"&gt;&lt;td&gt;Número Contrato:&lt;/font&gt;&lt;/td&gt;&lt;td&gt;&lt;%=rs.getString("CON_NUMCONTRATO")%&gt;&amp;nbsp;&lt;/td&gt;&lt;/tr&gt;
    &lt;tr&gt;&lt;font face="Arial"&gt;&lt;td&gt;Setor Pagamento:&lt;/font&gt;&lt;/td&gt;&lt;td&gt;&lt;%=rs.getString("CODCCUSTOPGTO")%&gt;&amp;nbsp;&lt;/td&gt;&lt;/tr&gt;
    &lt;tr&gt;&lt;font face="Arial"&gt;&lt;td&gt;Setor Gestor:&lt;/font&gt;&lt;/td&gt;&lt;td&gt;&lt;%=rs.getString("CODCUSTOGESTOR")%&gt;&amp;nbsp;&lt;/td&gt;&lt;/tr&gt;
    &lt;tr&gt;&lt;font face="Arial"&gt;&lt;td&gt;Fornecedor:&lt;/font&gt;&lt;/td&gt;&lt;td&gt;&lt;%=rs.getString("CODCFO")%&gt;&amp;nbsp;&lt;/td&gt;&lt;/tr&gt;
    &lt;tr&gt;&lt;font face="Arial"&gt;&lt;td&gt;Assunto:&lt;/font&gt;&lt;/td&gt;&lt;td&gt;&lt;%=rs.getString("CON_OBJETO")%&gt;&amp;nbsp;&lt;/td&gt;&lt;/tr&gt;
    &lt;tr&gt;&lt;font face="Arial"&gt;&lt;td&gt;Contratante:&lt;/font&gt;&lt;/td&gt;&lt;td&gt;&lt;%=rs.getString("CON_CONTRATANTE")%&gt;&amp;nbsp;&lt;/td&gt;&lt;/tr&gt;
    &lt;tr&gt;&lt;font face="Arial"&gt;&lt;td&gt;Data Cadastro:&lt;/font&gt;&lt;/td&gt;&lt;td&gt;&lt;%=rs.getString("CON_DTCADASTRO")%&gt;&amp;nbsp;&lt;/td&gt;&lt;/tr&gt;
    &lt;tr&gt;&lt;font face="Arial"&gt;&lt;td&gt;Vigência:&lt;/font&gt;&lt;/td&gt;&lt;td&gt;&lt;%= rs.getString("VIG_VIGENCIA")%&gt;&amp;nbsp;&lt;/td&gt;&lt;/tr&gt;
    &lt;tr&gt;&lt;font face="Arial"&gt;&lt;td&gt;Valor:&lt;/font&gt;&lt;/td&gt;&lt;td&gt;&lt;%= rs.getString("VAL_VALOR")%&gt;&amp;nbsp;&lt;/td&gt;&lt;/tr&gt;
    &lt;tr&gt;&lt;font face="Arial"&gt;&lt;td&gt;Data Início:&lt;/font&gt;&lt;/td&gt;&lt;td&gt;&lt;%= rs.getString("INI_DTINICIO")%&gt;&amp;nbsp;&lt;/td&gt;&lt;/tr&gt;
    &lt;tr&gt;&lt;font face="Arial"&gt;&lt;td&gt;Data Término:&lt;/font&gt;&lt;/td&gt;&lt;td&gt;&lt;%= rs.getString("TER_DTTERMINO")%&gt;&amp;nbsp;&lt;/td&gt;&lt;/tr&gt;
    &lt;tr&gt;&lt;font face="Arial"&gt;&lt;td&gt;Data Reajuste:&lt;/font&gt;&lt;/td&gt;&lt;td&gt;&lt;%= rs.getString("RE_DTREAJUSTE")%&gt;&amp;nbsp;&lt;/td&gt;&lt;/tr&gt;
    &lt;tr&gt;&lt;font face="Arial"&gt;&lt;td&gt;Cláusula:&lt;/font&gt;&lt;/td&gt;&lt;td&gt;&lt;%= rs.getString("CLA_CLAUSULA")%&gt;&amp;nbsp;&lt;/td&gt;&lt;/tr&gt;
    &lt;tr&gt;&lt;font face="Arial"&gt;&lt;td&gt;Observação:&lt;/font&gt;&lt;/td&gt;&lt;td&gt;&lt;%= rs.getString("OBS_DESCRICAO")%&gt;&amp;nbsp;&lt;/td&gt;&lt;/tr&gt;

</table>
<table>
</tr>
<tr><td width=“917” height=“1” colspan=“6”>
<p align=“center”><a href=“alteraContratos.jsp”>
<font>Alterar Contrato</font></a>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;
<font><a href=“indexContratos.jsp”><font>Página Inicial</font></a></font></td></tr>
</tr>
</table>
<%
}

st.close();
con.close();

}catch(Exception s){

System.out.println("Erro:" + s);
}
finally{
  try{
  	if(st != null)
  		st.close();
  	 
  	 } catch (SQLException a){}
  	 try{
  	 	if(con!= null)
  	 	   con.close();
}catch(SQLException a){}

}
%>
</body>
</html>

#2

Salve,

já testou teu código sql??? Simule uma possível consulta em seu SGBD para depois passar para teu jsp, pelo que de para identificar, insira espaço em branco entre o final e o começo de uma nova instrução. Por exemplo:

sql = &quot;Select * from tbclients where idClient = &quot; + request.getParameter&#40;&quot;id&quot;&#41; + &quot; And idStatus = 1&quot;;

Nota: Verifique o (+ " And…)

:okok: :pensativo:

#3

Valeu…Obrigada!
Era falta de atenção com os + and

#4