|
O problema est� na chamada do
JavaBean. Use o nome do pacote tamb�m, veja:
<%@ page import="java.util.*;
Servlelts"
%>
Servlelts.BeanList item = new Servlelts.BeanList();
Lincolm
----- Original Message -----
Sent: Thursday, May 09, 2002 7:10
PM
Subject: [java-list] JSP + COMBO BOX +
BANCO DE DADOS
Quer ter seu pr�prio endere�o na
Internet?
Garanta j� o seu e ainda ganhe cinco e-mails
personalizados.
Dom�niosBOL - http://dominios.bol.com.br
Salve
galera do Java !!
Pessoal,
Gostaria de saber se algu�m pode me
dar alguma dica para que eu possa usar JSP e quem sabe JavaBeans ou alguma
outra tecnologia para poder "popular" um combo box de uma p�gina html (ou
p�gina *.jsp) com informa��es de uma tabela de um banco de dados.
�
preciso que quando a p�gina seja carregada no navegador o combo box dessa
p�gina seja populado com as informa��es atuais de uma determinada tabela de um
banco de dados DB2.
Tentei usar o c�digo a seguir em uma p�gina JSP,
mas n�o est� dando certo. O servidor (Tomcat) d� uma mensagem de erro dizendo
que n�o foi poss�vel compilar a p�gina
jsp.
---------------------------------------
<%@ page
import="java.util.* " %>
<jsp:useBean id="item"
class="Servlets.BeanList">
<%
ArrayList meuArray;
int
tamanho;
BeanList item = new BeanList();
meuArray =
item.buscarPais();
tamanho = meuArray.size();
<select
name="pais">
<option>Escolha sua opcao</option>
<% for
(int i = 0; i < tamanho; i++) { %>
<option value="<%= (String)
meuArray.get(i) %>">
</option>
<% }
%>
</select>
%>
</jsp:useBean>
---------------------------------------
Ps.:
A classe BeanList � a
seguinte:
---------------------------------------
package
Servlelts;
import java.util.*;
import java.sql.*;
public
class BeanList {
Connection
connection;
Statement statement;
ArrayList resultBusca;
String url;
String query;
public ArrayList buscarPais()
{
resultBusca = new
ArrayList();
query
=
"SELECT nm_pais FROM pais";
try {
Class.forName("COM.ibm.db2.jdbc.app.DB2Driver");
url = "jdbc:db2:banco";
connection = DriverManager.getConnection(url, "usuario",
"senha");
statement =
connection.createStatement();
ResultSet rs =
statement.executeQuery(query);
ResultSetMetaData rsmd =
rs.getMetaData();
rs.next();
for (int i = 1; i <= rsmd.getColumnCount(); i++)
{
resultBusca.add(rs.getString(i));
}
statement.close();
} catch
(Exception e)
{
System.err.println("Erro ao tentar buscar o
contato.");
e.printStackTrace();
}
return
resultBusca;
}
---------------------------------------
AS MENSAGENS DE ERRO S�O
AS SEGUINTES:
Error: 500
Location:
/JapiControle/Html/teste2.jsp
Internal Servlet
Error:
org.apache.jasper.JasperException: Unable to compile class for
JSP
at
org.apache.jasper.servlet.JspServlet.doLoadJSP(JspServlet.java:630)
at
org.apache.jasper.servlet.JasperLoader12.loadJSP(JasperLoader12.java:146)
at
org.apache.jasper.servlet.JspServlet.loadJSP(JspServlet.java:542)
at
org.apache.jasper.servlet.JspServlet$JspServletWrapper.loadIfNecessary(JspServlet.java:258)
at
org.apache.jasper.servlet.JspServlet$JspServletWrapper.service(JspServlet.java:268)
at
org.apache.jasper.servlet.JspServlet.serviceJspFile(JspServlet.java:429)
at
org.apache.jasper.servlet.JspServlet.service(JspServlet.java:500)
at
javax.servlet.http.HttpServlet.service(HttpServlet.java:853)
at
org.apache.tomcat.core.ServletWrapper.doService(ServletWrapper.java:405)
at
org.apache.tomcat.core.Handler.service(Handler.java:287)
at
org.apache.tomcat.core.ServletWrapper.service(ServletWrapper.java:372)
at
org.apache.tomcat.core.ContextManager.internalService(ContextManager.java:806)
at
org.apache.tomcat.core.ContextManager.service(ContextManager.java:752)
at
org.apache.tomcat.service.http.HttpConnectionHandler.processConnection(HttpConnectionHandler.java:213)
at
org.apache.tomcat.service.TcpWorkerThread.runIt(PoolTcpEndpoint.java:416)
at
org.apache.tomcat.util.ThreadPool$ControlRunnable.run(ThreadPool.java:501)
at
java.lang.Thread.run(Thread.java:484)
Root cause:
java.lang.NullPointerException
at
org.apache.jasper.compiler.GetPropertyGenerator.generate(GetPropertyGenerator.java:100)
at
org.apache.jasper.compiler.JspParseEventListener$GeneratorWrapper.generate(JspParseEventListener.java:771)
at
org.apache.jasper.compiler.JspParseEventListener.generateAll(JspParseEventListener.java:220)
at
org.apache.jasper.compiler.JspParseEventListener.endPageProcessing(JspParseEventListener.java:175)
at
org.apache.jasper.compiler.Compiler.compile(Compiler.java:210)
at
org.apache.jasper.servlet.JspServlet.doLoadJSP(JspServlet.java:612)
at
org.apache.jasper.servlet.JasperLoader12.loadJSP(JasperLoader12.java:146)
at
org.apache.jasper.servlet.JspServlet.loadJSP(JspServlet.java:542)
at
org.apache.jasper.servlet.JspServlet$JspServletWrapper.loadIfNecessary(JspServlet.java:258)
at
org.apache.jasper.servlet.JspServlet$JspServletWrapper.service(JspServlet.java:268)
at
org.apache.jasper.servlet.JspServlet.serviceJspFile(JspServlet.java:429)
at
org.apache.jasper.servlet.JspServlet.service(JspServlet.java:500)
at
javax.servlet.http.HttpServlet.service(HttpServlet.java:853)
at
org.apache.tomcat.core.ServletWrapper.doService(ServletWrapper.java:405)
at
org.apache.tomcat.core.Handler.service(Handler.java:287)
at
org.apache.tomcat.core.ServletWrapper.service(ServletWrapper.java:372)
at
org.apache.tomcat.core.ContextManager.internalService(ContextManager.java:806)
at
org.apache.tomcat.core.ContextManager.service(ContextManager.java:752)
at
org.apache.tomcat.service.http.HttpConnectionHandler.processConnection(HttpConnectionHandler.java:213)
at
org.apache.tomcat.service.TcpWorkerThread.runIt(PoolTcpEndpoint.java:416)
at
org.apache.tomcat.util.ThreadPool$ControlRunnable.run(ThreadPool.java:501)
at
java.lang.Thread.run(Thread.java:484)
---------------------------------------
E
MAIS ESSA:
org.apache.jasper.JasperException: Unable to compile class
for
JSPC:\jakarta-tomcat-3.2.4\webapps\JapiControle\WEB-INF\classes\Servlets\BeanList.java:1:
The source file encoding may be different with this platform encoding. Please
use -encoding option to adjust file encoding, or apply native2ascii utility to
make source file ASCII encoding.
error: File
C:\jakarta-tomcat-3.2.4\webapps\JapiControle\WEB-INF\classes\Servlets\BeanList.java
does not contain type Servlets.BeanList as expected. Please adjust the class
path so that the file does not appear in the package
Servlets.
C:\jakarta-tomcat-3.2.4\work\localhost_8080%2FJapiControle\_0002fHtml_0002f_00031_0002ejsp1_jsp_1.java:67:
Class Servlets.BeanList not
found.
Servlets.BeanList item =
null;
^
C:\jakarta-tomcat-3.2.4\work\localhost_8080%2FJapiControle\_0002fHtml_0002f_00031_0002ejsp1_jsp_1.java:70:
Class Servlets.BeanList not
found.
item=
(Servlets.BeanList)
^
C:\jakarta-tomcat-3.2.4\work\localhost_8080%2FJapiControle\_0002fHtml_0002f_00031_0002ejsp1_jsp_1.java:75:
Class Servlets.BeanList not
found.
item = (Servlets.BeanList) Beans.instantiate(this.getClass().getClassLoader(),
"Servlets.BeanList");
^
C:\jakarta-tomcat-3.2.4\work\localhost_8080%2FJapiControle\_0002fHtml_0002f_00031_0002ejsp1_jsp_1.java:91:
Class Html.BeanList not
found.
BeanList item = new
BeanList();
^
C:\jakarta-tomcat-3.2.4\work\localhost_8080%2FJapiControle\_0002fHtml_0002f_00031_0002ejsp1_jsp_1.java:91:
Variable 'item' is already defined in this
method.
BeanList item = new
BeanList();
^
C:\jakarta-tomcat-3.2.4\work\localhost_8080%2FJapiControle\_0002fHtml_0002f_00031_0002ejsp1_jsp_1.java:91:
Class Html.BeanList not
found.
BeanList item = new
BeanList();
^
8 errors
---------------------------------------
Agrade�o a
quem possa me ajudar.
Valeu !!!
------------------------------ LISTA
SOUJAVA ----------------------------
http://www.soujava.org.br -
Sociedade de Usu�rios Java da Sucesu-SP
d�vidas mais comuns: http://www.soujava.org.br/faq.htm
regras
da lista: http://www.soujava.org.br/regras.htm
historico:
http://www.mail-archive.com/java-list%40soujava.org.br
para
sair da lista: envie email para [EMAIL PROTECTED]
-------------------------------------------------------------------------
|
