Alguém tem algum exemplo de conexão com um BD MySQL via JSP?
Gostaria de fazer apenas uma consulta do tipo Select campo1,campo2 from tabela, e listar no brownser do cliente.
Desde já agradeço.
JSP+MySQL
E
3 Respostas
R
eduardo10,
Acho que o código abaixo vai te ajudar.
//Tag diretiva, indica o tipo da página e importa o pacote java.sql
<%page contentType="text/html; charset=ISO-8859-1" language="java" import="java.sql.*"%>
//Faz a conexão com o DB
<%
Class.forName("org.gjt.mm.mysql.Driver");
Connection con = DriverManager.getConnection("jdbc:mysql://localhost:3306/Local_Do_DB", "usuário","senha");
Statement stm = con.createStatement();
%>
//Faz a consulta
<%
ResultSet res=stm.executequery("select CAMPO from TABELA");
while (res.next()){
out.println("<tr>");
out.println("<td>" + res.getString("CAMPO") + "</td>");
out.println("</tr>");
%>
Até mais,
Ricardo Serra
www.open.org.br
E
org.apache.jasper.JasperException: Unable to compile class for JSP
An error occurred at line: 1 in the jsp file: /mysql.jsp
Generated servlet error:
[javac] Compiling 1 source file
C:\Arquivos de programas\Apache Group\Tomcat 4.1\work\Standalone\localhost_\mysql_jsp.java:42: ‘;’ expected
page contentType=“text/html; charset=ISO-8859-1” language=“java” import=“java.sql.*”
^
An error occurred at line: 1 in the jsp file: /mysql.jsp
Generated servlet error:
C:\Arquivos de programas\Apache Group\Tomcat 4.1\work\Standalone\localhost_\mysql_jsp.java:61: ‘catch’ without ‘try’
} catch (Throwable t) {
^
C:\Arquivos de programas\Apache Group\Tomcat 4.1\work\Standalone\localhost_\mysql_jsp.java:30: ‘try’ without ‘catch’ or ‘finally’
try {
^
C:\Arquivos de programas\Apache Group\Tomcat 4.1\work\Standalone\localhost_\mysql_jsp.java:70: ‘}’ expected
}
^
C:\Arquivos de programas\Apache Group\Tomcat 4.1\work\Standalone\localhost_\mysql_jsp.java:42: cannot resolve symbol
symbol : class page
location: class org.apache.jsp.mysql_jsp
page contentType=“text/html; charset=ISO-8859-1” language=“java” import=“java.sql.*”
^
An error occurred at line: 4 in the jsp file: /mysql.jsp
Generated servlet error:
C:\Arquivos de programas\Apache Group\Tomcat 4.1\work\Standalone\localhost_\mysql_jsp.java:46: cannot resolve symbol
symbol : class Connection
location: class org.apache.jsp.mysql_jsp
An error occurred at line: 4 in the jsp file: /mysql.jsp
Generated servlet error:
Connection con = DriverManager.getConnection(“jdbc:mysql://localhost:3306/dbexemplo”, “”,"");
^
An error occurred at line: 4 in the jsp file: /mysql.jsp
Generated servlet error:
C:\Arquivos de programas\Apache Group\Tomcat 4.1\work\Standalone\localhost_\mysql_jsp.java:46: cannot resolve symbol
symbol : variable DriverManager
location: class org.apache.jsp.mysql_jsp
An error occurred at line: 4 in the jsp file: /mysql.jsp
Generated servlet error:
Connection con = DriverManager.getConnection(“jdbc:mysql://localhost:3306/dbexemplo”, “”,"");
^
An error occurred at line: 4 in the jsp file: /mysql.jsp
Generated servlet error:
C:\Arquivos de programas\Apache Group\Tomcat 4.1\work\Standalone\localhost_\mysql_jsp.java:47: cannot resolve symbol
symbol : class Statement
location: class org.apache.jsp.mysql_jsp
Statement stm = con.createStatement();
^
An error occurred at line: 11 in the jsp file: /mysql.jsp
Generated servlet error:
C:\Arquivos de programas\Apache Group\Tomcat 4.1\work\Standalone\localhost_\mysql_jsp.java:51: cannot resolve symbol
symbol : class ResultSet
location: class org.apache.jsp.mysql_jsp
ResultSet res=stm.executequery(“select * from cliente”);
^
9 errors
at org.apache.jasper.compiler.DefaultErrorHandler.javacError(DefaultErrorHandler.java:130)
at org.apache.jasper.compiler.ErrorDispatcher.javacError(ErrorDispatcher.java:293)
at org.apache.jasper.compiler.Compiler.generateClass(Compiler.java:353)
at org.apache.jasper.compiler.Compiler.compile(Compiler.java:370)
at org.apache.jasper.JspCompilationContext.compile(JspCompilationContext.java:473)
at org.apache.jasper.servlet.JspServletWrapper.service(JspServletWrapper.java:190)
at org.apache.jasper.servlet.JspServlet.serviceJspFile(JspServlet.java:295)
at org.apache.jasper.servlet.JspServlet.service(JspServlet.java:241)
at javax.servlet.http.HttpServlet.service(HttpServlet.java:853)
at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:247)
at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:193)
at org.apache.catalina.core.StandardWrapperValve.invoke(StandardWrapperValve.java:256)
at org.apache.catalina.core.StandardPipeline$StandardPipelineValveContext.invokeNext(StandardPipeline.java:643)
at org.apache.catalina.core.StandardPipeline.invoke(StandardPipeline.java:480)
at org.apache.catalina.core.ContainerBase.invoke(ContainerBase.java:995)
at org.apache.catalina.core.StandardContextValve.invoke(StandardContextValve.java:191)
at org.apache.catalina.core.StandardPipeline$StandardPipelineValveContext.invokeNext(StandardPipeline.java:643)
at org.apache.catalina.core.StandardPipeline.invoke(StandardPipeline.java:480)
at org.apache.catalina.core.ContainerBase.invoke(ContainerBase.java:995)
at org.apache.catalina.core.StandardContext.invoke(StandardContext.java:2416)
at org.apache.catalina.core.StandardHostValve.invoke(StandardHostValve.java:180)
at org.apache.catalina.core.StandardPipeline$StandardPipelineValveContext.invokeNext(StandardPipeline.java:643)
at org.apache.catalina.valves.ErrorDispatcherValve.invoke(ErrorDispatcherValve.java:171)
at org.apache.catalina.core.StandardPipeline$StandardPipelineValveContext.invokeNext(StandardPipeline.java:641)
at org.apache.catalina.valves.ErrorReportValve.invoke(ErrorReportValve.java:172)
at org.apache.catalina.core.StandardPipeline$StandardPipelineValveContext.invokeNext(StandardPipeline.java:641)
at org.apache.catalina.core.StandardPipeline.invoke(StandardPipeline.java:480)
at org.apache.catalina.core.ContainerBase.invoke(ContainerBase.java:995)
at org.apache.catalina.core.StandardEngineValve.invoke(StandardEngineValve.java:174)
at org.apache.catalina.core.StandardPipeline$StandardPipelineValveContext.invokeNext(StandardPipeline.java:643)
at org.apache.catalina.core.StandardPipeline.invoke(StandardPipeline.java:480)
at org.apache.catalina.core.ContainerBase.invoke(ContainerBase.java:995)
at org.apache.coyote.tomcat4.CoyoteAdapter.service(CoyoteAdapter.java:223)
at org.apache.coyote.http11.Http11Processor.process(Http11Processor.java:601)
at org.apache.coyote.http11.Http11Protocol$Http11ConnectionHandler.processConnection(Http11Protocol.java:392)
at org.apache.tomcat.util.net.TcpWorkerThread.runIt(PoolTcpEndpoint.java:565)
at org.apache.tomcat.util.threads.ThreadPool$ControlRunnable.run(ThreadPool.java:619)
at java.lang.Thread.run(Thread.java:536)
R
eduardo10,
Você instalou o o drive JDBC do MYSQL? O código que te passei eu era apenas um exemplo, para vc adaptar a sua aplicação.
Bem tem um tutorial aqui no PJ, dê uma olhada.
http://www.portaljava.com/home/modules.php?name=News&sid=93&mode=&order=0&thold=0&file=article
A lembrei tem outro link (Javaranch)!
http://www.javaranch.com/drive/jdbc/index.jsp
Caso não dê certo me avise que lhe enviou uma página jsp minha que faz este tipo de select.
Até mais,
Ricardo Serra
www.open.org.br
Criado 18 de agosto de 2003
Ultima resposta 21 de ago. de 2003
Respostas 3
Participantes 2