Jsp - access

5 de maio de 2005 5 respostas

fbr2PJ 5 de maio de 2005

Galera!!
Preciso aprender jsp na marra...estou tentando fazer uma pagina de consulta a banco de dados.
Criei o DSN: locadora apontando pro BD: teste.mdb que tem uma tabela: filmes ...segue o código:

&lt;!DOCTYPE HTML PUBLIC &quot;-//W3C//DTD HTML 4.01 Transitional//EN&quot;&gt;
&lt;html&gt;
&lt;head&gt;
&lt;title&gt;Filmes&lt;/title&gt;
&lt;meta http-equiv=&quot;Content-Type&quot; content=&quot;text/html; charset=iso-8859-1&quot;&gt;
&lt;/head&gt;

&lt;body&gt;

&lt;%@ page import=&quot;java.sql.*&quot; %&gt;
&lt;%@ page import=&quot;java.io.*&quot; %&gt;
&lt;% 
Connection con1 = null;
try
&#123;
Class.forName&#40;&quot;sun.jdbc.odbc.JdbcOdbcDriver&quot;&#41;;
String url = &quot;jdbc&#58;odbc&#58;locadora&quot;;
Connection con1;
con1 = DriverManager.getConnection&#40;url, &quot;&quot;, &quot;&quot;&#41;;
&#125; catch &#40;Exception e&#41;
&#123;
out.println&#40;&quot;Exception&#58; &quot; + e.toString&#40;&#41;&#41;;
&#125; catch &#40;ClassNotFoundException e&#41;
&#123;
out.println&#40;&quot;ClassNotFoundException error&#58; &quot; + e.toString&#40;&#41;&#41;;
&#125;

try
&#123;
Statement stmt = con1.createStatement&#40;&#41;;
String sql = &quot;&quot;;
sql = &quot;SELECT * FROM filmes&quot;;
ResultSet rs = stmt.executeQuery&#40;sql&#41;;

%&gt;

&lt;table width=&quot;98%&quot; height=&quot;86&quot; border=&quot;0&quot; cellpadding=&quot;0&quot; cellspacing=&quot;0&quot;&gt;
  &lt;tr&gt; 
    &lt;td height=&quot;36&quot; colspan=&quot;5&quot;&gt; &lt;div align=&quot;center&quot;&gt;&lt;strong&gt;&lt;font size=&quot;+3&quot;&gt;Lista 
        de Filmes&lt;/font&gt;&lt;/strong&gt;&lt;/div&gt;&lt;/td&gt;
  &lt;/tr&gt;
  &lt;tr&gt; 
    &lt;td width=&quot;20%&quot; height=&quot;23&quot; bgcolor=&quot;#00CCFF&quot;&gt; &lt;div align=&quot;center&quot;&gt;&lt;strong&gt;&lt;font size=&quot;+1&quot;&gt;C&amp;oacute;digo&lt;/font&gt;&lt;/strong&gt;&lt;/div&gt;&lt;/td&gt;
    &lt;td width=&quot;20%&quot; bgcolor=&quot;#00CCFF&quot;&gt; &lt;div align=&quot;center&quot;&gt;&lt;strong&gt;&lt;font size=&quot;+1&quot;&gt;Nome&lt;/font&gt;&lt;/strong&gt;&lt;/div&gt;&lt;/td&gt;
    &lt;td width=&quot;21%&quot; bgcolor=&quot;#00CCFF&quot;&gt; &lt;div align=&quot;center&quot;&gt;&lt;strong&gt;&lt;font size=&quot;+1&quot;&gt;Descri&amp;ccedil;&amp;atilde;o&lt;/font&gt;&lt;/strong&gt;&lt;/div&gt;&lt;/td&gt;
    &lt;td width=&quot;17%&quot; bgcolor=&quot;#00CCFF&quot;&gt; &lt;div align=&quot;center&quot;&gt;&lt;strong&gt;&lt;font size=&quot;+1&quot;&gt;Cota&amp;ccedil;&amp;atilde;o&lt;/font&gt;&lt;/strong&gt;&lt;/div&gt;&lt;/td&gt;
    &lt;td width=&quot;22%&quot; bgcolor=&quot;#00CCFF&quot;&gt; &lt;div align=&quot;center&quot;&gt;&lt;strong&gt;&lt;font size=&quot;+1&quot;&gt;Capa&lt;/font&gt;&lt;/strong&gt;&lt;/div&gt;&lt;/td&gt;
  &lt;/tr&gt;
  &lt;% while&#40;rs.next&#40;&#41;&#41; &#123;%&gt;
  &lt;tr bgcolor=&quot;#00CCCC&quot;&gt; 
    &lt;td height=&quot;27&quot;&gt;&lt;%= rs.getInt&#40;&quot;codigo&quot;&#41;%&gt; 
      &lt;div align=&quot;center&quot;&gt;&lt;/div&gt;&lt;/td&gt;
    &lt;td&gt;&lt;%= rs.getString&#40;&quot;nome&quot;&#41;%&gt; 
      &lt;div align=&quot;center&quot;&gt;&lt;/div&gt;&lt;/td&gt;
    &lt;td&gt;&lt;%= rs.getString&#40;&quot;descricao&quot;&#41;%&gt; 
      &lt;div align=&quot;center&quot;&gt;&lt;/div&gt;&lt;/td&gt;
    &lt;td&gt;&lt;%= rs.getString&#40;&quot;cotacao&quot;&#41;%&gt; 
      &lt;div align=&quot;center&quot;&gt;&lt;/div&gt;&lt;/td&gt;
    &lt;td&gt;&lt;div align=&quot;center&quot;&gt;&lt;/div&gt;&lt;/td&gt;
  &lt;/tr&gt;
  &lt;% &#125;
  rs.close&#40;&#41;;
  stmt.close&#40;&#41;;
  con1.close&#40;&#41;;
 &#125; 
 catch &#40;Exception e&#41; &#123;
out.println&#40;&quot;Erro&#58; &quot; + e.toString&#40;&#41;&#41;;
&#125;
 
  %&gt;
&lt;/table&gt;


&lt;/body&gt;
&lt;/html&gt;

Quando coloco pra rodar o jsp, ápresenta o seguinte erro:

org.apache.jasper.JasperException: Unable to compile class for JSP

An error occurred at line: 11 in the jsp file: /lista_geral.jsp

Generated servlet error:
[javac] Compiling 1 source file

C:\tomcat\work\Standalone\localhost\Webdesv\lista_geral_jsp.java:59: con1 is already defined in _jspService(javax.servlet.http.HttpServletRequest,javax.servlet.http.HttpServletResponse)
Connection con1;
^
1 error

at org.apache.jasper.compiler.DefaultErrorHandler.javacError(DefaultErrorHandler.java:85)
at org.apache.jasper.compiler.ErrorDispatcher.javacError(ErrorDispatcher.java:248)
at org.apache.jasper.compiler.Compiler.generateClass(Compiler.java:315)
at org.apache.jasper.compiler.Compiler.compile(Compiler.java:328)
at org.apache.jasper.JspCompilationContext.compile(JspCompilationContext.java:427)
at org.apache.jasper.servlet.JspServletWrapper.service(JspServletWrapper.java:142)
at org.apache.jasper.servlet.JspServlet.serviceJspFile(JspServlet.java:240)
at org.apache.jasper.servlet.JspServlet.service(JspServlet.java:187)
at javax.servlet.http.HttpServlet.service(HttpServlet.java:809)

E mais um milhão de linhas!!!. Desculpe inha ignorância..mas ja pesquisei diversos tipos de conexão a banco de dadfos e não estou conseguindo!!

Se alguem puder me ajudar..Agradeço!!

Fábio

5 Respostas

rcmsjPJ 5 de mai. de 2005

C:\tomcat\work\Standalone\localhost\Webdesv\lista_geral_jsp.java:59: con1 is already defined in _jspService(javax.servlet.http.HttpServletRequest,javax.servlet.http.HttpServletResponse) Connection con1;

vc declarou o con1 duas vezes …

Connection con1 = null;

depois …

Connection con1;

fbr2PJ 6 de mai. de 2005

Valeu pela dica!!

eu removi akela linha…mas agora esta com esse erro, que por minha ignorância to tentando resolver até agora…e resolvi apelar vendo se vc ou alguem pode me ajudar!!..segue:

Generated servlet error:
[javac] Compiling 1 source file

C:\tomcat\work\Standalone\localhost\Webdesv\lista_geral_jsp.java:69: cannot find symbol
symbol : variable con1
location: class org.apache.jsp.lista_geral_jsp
Statement stmt = con1.createStatement();
^

An error occurred at line: 59 in the jsp file: /lista_geral.jsp

Generated servlet error:
C:\tomcat\work\Standalone\localhost\Webdesv\lista_geral_jsp.java:162: cannot find symbol
symbol : variable con1
location: class org.apache.jsp.lista_geral_jsp
con1.close();
^
2 errors

fbr2PJ 7 de mai. de 2005

Alguem poderia me ajudar…ainda não esta rodando…nem a pau!!!

diego_umpierrePJ 7 de mai. de 2005

Qual dos dois con1 q tu deletou ???
…
<title>Filmes</title>
<meta http-equiv=“Content-Type” content=“text/html; charset=iso-8859-1”>
</head>

<body>

<%@ page import=“java.sql.<em>" %>

<%@ page import="<a href="http://java.io">java.io</a>.</em>” %>

<%

Connection con1 = null;  // <==== ESSE AQUI FICA

try

{

Class.forName(“sun.jdbc.odbc.JdbcOdbcDriver”);

String url = “jdbc:odbc:locadora”;

Connection con1;  //<== ESSE AQUI SAI

con1 = DriverManager.getConnection(url, “”, “”);

} catch (Exception e)

{

…

Assim quando tu tentar dar o creatStatement a var con1 vai existir no contexto se caso tu tenha deixado apenas a que esta dentro do try ela nao vai ser enxergada fora do try.

Outra coisa uma boa prática (pelo menos eu sempre faço assim) é antes de fechar :

rs.close();

stmt.close();

con1.close();

testar se eles são diferentes de null assim:

if (rs != null) rs.close();

if (stmt!= null) stmt.close();

if (con1!= null) con1.close();

isso evita que de um null pointer exception.

fbr2PJ 9 de mai. de 2005

Brigadão Diego , era isso mesmo…agora ta redondinho…valeu pela ajuda epelas dicas!!

Abraõs,

Fábio

Criado 5 de maio de 2005

Ultima resposta 9 de mai. de 2005

Respostas 5

Participantes 3

5 Respostas

Topicos relacionados