Pessoal!!
Estou tentando puxar uns dados de umm banco de dados access.
Segue o código e o erro que ocorre!!..se alguem puder me ajudar!!..agradeço!!
<html>
<head>
<title>Filmes</title>
</head>
<%@ page import="java.io.*" %>
<%@ page import="java.sql.*" %>
<%
Connection con1 = null;
try
{
Class.forName("sun.jdbc.odbc.JdbcOdbcDriver");
String url = "jdbc:odbc:locadora";
con1 = DriverManager.getConnection(url);
} catch (Exception e)
{
out.println("Exception: " + e.toString());
}
try
{
Statement stmt = con1.createStatement();
String sql = "";
sql = "SELECT * FROM filmes";
ResultSet rs = stmt.executeQuery(sql);
%>
<body bgcolor="#000000">
<p>&nbsp;</p><table width="98%" height="86" border="0" cellpadding="0" cellspacing="0">
<tr>
<td height="36" colspan="5"> <div align="center"><strong><font color="#CC9900" size="+3">Consulta</font></strong></div></td>
</tr>
<tr>
<td width="20%" height="23" bgcolor="#CC9900"> <div align="center"><strong><font size="+1">C&oacute;digo</font></strong></div></td>
<td width="20%" bgcolor="#CC9900"> <div align="center"><strong><font size="+1">Nome</font></strong></div></td>
<td width="21%" bgcolor="#CC9900"> <div align="center"><strong><font size="+1">Descri&ccedil;&atilde;o</font></strong></div></td>
<td width="17%" bgcolor="#CC9900"> <div align="center"><strong><font size="+1">Cota&ccedil;&atilde;o</font></strong></div></td>
<td width="22%" bgcolor="#CC9900"> <div align="center"><strong><font size="+1">Capa</font></strong></div></td>
</tr>
<% while(rs.next()) {%>
<tr>
<td height="27"><div align="center"><font color="#FFFFFF"><%= rs.getInt("codigo")%>
</font></div>
<td> <div align="center"><font color="#FFFFFF"><%= rs.getString("nome")%></font></div></td>
<td><div align="center"><font color="#FFFFFF"><%= rs.getString("descricao")%></font></div></td>
<td><div align="center"><font color="#FFFFFF"><%= rs.getString("cotacao")%></font></div></td>
<td><div align="center"><font color="#FFFFFF"><img src="<%= rs.getString("imagem")%>"></font></div></td>
</tr>
<% }
if (rs != null) rs.close();
if (stmt!= null) stmt.close();
if (con1!= null) con1.close();
}
catch (Exception e) {
out.println("Erro: " + e.toString());
}
%>
</table>
</body>
</html>
Erro:
É um código bem simples, só de teste!!
obrgado,