Bom Dia,
fiz um formulario para quando o usuario esquece a senha.
quando ele entra com o seu login e data de nascimento ele e direcionado para a pagina que supostamente teria que mostrar o resultado de sua consulta.
mas nao aparece a resposta!!!! aparece um outro erro.
segue os codigos!
se algum puder me ajudar, agradeco muito!!!
esquecer_senha_universitario.html<html>
<head>
<meta http-equiv="Content-Language" content="pt-br">
<title>Integração Universidade / Empresa - Login Universitário - Esqueceu Senha</title>
</head>
<body bgcolor="#CBD7DC" vlink="#FFFFFF" link="#FFFFFF" alink="#FFFFFF">
<div align="center">
<form action="esquecer_senha_universitario.jsp" method="post">
<table width="755" cellpadding="0" cellspacing="0">
<tr>
<td> <img src="imagens/banner.jpg" width="755" height="97"></td>
</tr>
</table>
<table width="755" bgcolor="#FFFFFF" bordercolor="#111111" cellpadding="0" cellspacing="0" height="1">
<tr>
<td align="left" style="text-indent: 0; margin-left: 0" height="1">
<p align="center"><a href="login_universitario.html">
<img src="imagens/btuniversitarios.jpg" width="161" height="124"></a></td>
<td align="left" style="text-indent: 0; margin-left: 0" height="1">
<p align="center">
<a href="login_empresa.html"><img src="imagens/btempresas.jpg" width="161" height="124"></a>
</td>
<td align="left" style="text-indent: 0; margin-left: 0" height="1">
<p align="center"><a href="login_instituicao.html"><img src="imagens/btinstituicoes.jpg" width="161" height="124"></a></td>
<td align="left" style="text-indent: 0; margin-left: 0" height="1">
<img src="imagens/btcontato.jpg" width="161" height="124" align="right"></td>
</tr>
<tr>
<td height="17" width="3544" colspan="4">
</td>
</tr>
<tr>
<td height="17" width="3544" colspan="4">
<img src="imagens/azul.jpg" width="755" height="17"></td>
</tr>
</table>
<table width="755" bgcolor="#FFFFFF" bordercolor="#111111" cellpadding="0" cellspacing="0" height="1" style="border-collapse: collapse">
<TR>
<TD width="1" height="1">
<a href="principal.html">
<img src="imagens/home_link.jpg" width="190" height="39"></a><table width="193" bgcolor="#FFFFFF" bordercolor="#111111" cellpadding="0" cellspacing="0" height="194" style="border-collapse: collapse">
<TR>
<TD width="1" height="16">
<img src="imagens/azul.jpg" width="192" height="17"></TD>
</TR>
<tr>
<td height="1" width="1">
<a href="link.html">
<img src="imagens/link_link.jpg" width="190" height="39"></a></td>
</tr>
<tr>
<td height="41" width="1">
<img src="imagens/azul.jpg" width="192" height="17"><a href="parceiros.html"><img src="imagens/parceiros_link.jpg" width="190" height="39"></a></td>
</tr>
<tr>
<td height="15" width="1">
<img src="imagens/azul.jpg" width="192" height="17"></td>
</tr>
<tr>
<td height="15" width="1">
<a href="downloads.html">
<img src="imagens/dowloads_link.jpg" width="190" height="39"></a></td>
</tr>
<tr>
<td height="18" width="1">
<img src="imagens/azul.jpg" width="192" height="17"></td>
</tr>
</table>
</TD>
<TD width="549" height="181">
<div align="center">
<center>
<table width="411" border="0" style="border-collapse: collapse" bordercolor="#111111" cellpadding="0" cellspacing="0" height="172">
<tr>
<td background="D8E1F2" width="102" bgcolor="D8E1F2" height="56">
<p align="center"><font color="#003366"><img src="imagens/msn.jpg" width="32" height="32">
</font>
<font face="Verdana" size="2" color="#003366">Login</font></td>
<td background="D8E1F2" width="242" bgcolor="D8E1F2" height="56"> </td>
<td background="D8E1F2" height="56" width="67" bgcolor="D8E1F2"> </td>
</tr>
<tr>
<td align="left" background="D8E1F2" width="102" bgcolor="D8E1F2" height="32"> </td>
<td align="right" background="D8E1F2" width="242" bgcolor="D8E1F2" height="32">
<p align="left"><font face="Verdana" color="#003366" size="2">Login:</font><font color="#003366" face="Tahoma">
<input type="text" name="id_ra" size="15" maxlenght="20"> </font> </td>
<td align="left" background="D8E1F2" height="32" width="67" bgcolor="D8E1F2"> </td>
</tr>
<tr>
<td align="center" background="D8E1F2" width="102" bgcolor="D8E1F2" height="30"> </td>
<td align="right" background="D8E1F2" width="242" bgcolor="D8E1F2" height="30">
<p align="left"><font face="Verdana" size="2" color="#003366">Data
Nacicmento</font><font face="Verdana"><font color="#003366" size="2">:</font><font color="#003366">
<input type="password" name="data_nasc" size="15" maxlenght="20"></font></font></td>
<td align="right" background="D8E1F2" height="30" width="67" bgcolor="D8E1F2">
</td>
</tr>
<tr>
<td align="center" background="D8E1F2" width="102" bgcolor="D8E1F2" height="54"> </td>
<td align="center" background="D8E1F2" width="242" bgcolor="D8E1F2" height="54">
<input name="I1" type="image" value="Enviar!" src="imagens/entrar.jpg" width="76" height="19"></td>
<td align="center" background="D8E1F2" height="54" width="67" bgcolor="D8E1F2">
</td>
</tr>
</table>
</center>
</div>
</TD>
</TR>
<tr>
<td height="32" width="1"> </td>
<td height="32" width="485">
<p align="center"> </td>
</tr>
<tr>
<td height="32" width="1"> </td>
<td height="32" width="485"> </td>
</tr>
<tr>
<td height="32" width="1"> </td>
<td height="32" width="485"> </td>
</tr>
<tr>
<td height="32" width="1"> </td>
<td height="32" width="485"> </td>
</tr>
<tr>
<td height="32" width="1"> </td>
<td height="32" width="485"> </td>
</tr>
<tr>
<td height="32" width="1"> </td>
<td height="32" width="485"> </td>
</tr>
<tr>
<td height="32" width="1"> </td>
<td height="32" width="485"> </td>
</tr>
<tr>
<td height="32" width="1"> </td>
<td height="32" width="485"> </td>
</tr>
</table>
<table width="755" bgcolor="#FFFFFF" bordercolor="#111111" cellpadding="0" cellspacing="0">
<tr>
<td background="0A1633" height="16" width="753" bgcolor="#808080">
<p align="center"><font color="#000033" size="2" class="verdana" >Copyright@2008 - Opção de Qualidade - Todos os direitos reservados</p>
</td>
</tr>
</table>
<table width="755" bgcolor="#FFFFFF" bordercolor="#111111" cellpadding="0" cellspacing="0">
<tr>
<td height="16" width="753">
<img src="imagens/azul.jpg" width="755" height="17"></td>
</tr>
</table>
</div>
<div align="center"></div>
</body>
</html>
<html>
<html>
<head>
<meta http-equiv="Content-Language" content="pt-br">
<title>Integração Universidade / Empresa - Login Universitário</title>
</head>
<body bgcolor="#CBD7DC" vlink="#FFFFFF" link="#FFFFFF" alink="#FFFFFF">
<div align="center">
<%@ page import="java.sql.*"%>
<table width="755" cellpadding="0" cellspacing="0">
<tr>
<td> <img src="imagens/banner.jpg" width="755" height="97"></td>
</tr>
</table>
<table width="755" bgcolor="#FFFFFF" bordercolor="#111111" cellpadding="0" cellspacing="0" height="1">
<tr>
<td align="left" style="text-indent: 0; margin-left: 0" height="1">
<p align="center"><a href="login_universitario.html">
<img src="imagens/btuniversitarios.jpg" width="161" height="124"></a></td>
<td align="left" style="text-indent: 0; margin-left: 0" height="1">
<p align="center">
<a href="login_empresa.html"><img src="imagens/btempresas.jpg" width="161" height="124"></a>
</td>
<td align="left" style="text-indent: 0; margin-left: 0" height="1">
<p align="center"><a href="login_instituicao.html"><img src="imagens/btinstituicoes.jpg" width="161" height="124"></a></td>
<td align="left" style="text-indent: 0; margin-left: 0" height="1">
<img src="imagens/btcontato.jpg" width="161" height="124" align="right"></td>
</tr>
<tr>
<td height="17" width="3544" colspan="4">
</td>
</tr>
<tr>
<td height="17" width="3544" colspan="4">
<img src="imagens/azul.jpg" width="755" height="17"></td>
</tr>
</table>
<table width="755" bgcolor="#FFFFFF" bordercolor="#111111" cellpadding="0" cellspacing="0" height="130" style="border-collapse: collapse">
<TR>
<TD width="1" height="122">
<table width="755" bgcolor="#FFFFFF" bordercolor="#111111" cellpadding="0" cellspacing="0" height="130" style="border-collapse: collapse">
<TR>
<TD width="1" height="122">
<a href="principal.html">
<img src="imagens/home_link.jpg" width="190" height="39"></a><table width="193" bgcolor="#FFFFFF" bordercolor="#111111" cellpadding="0" cellspacing="0" height="194" style="border-collapse: collapse">
<TR>
<TD width="1" height="16">
<img src="imagens/azul.jpg" width="192" height="17"></TD>
</TR>
<tr>
<td height="1" width="1">
<a href="link.html">
<img src="imagens/link_link.jpg" width="190" height="39"></a></td>
</tr>
<tr>
<td height="41" width="1">
<img src="imagens/azul.jpg" width="192" height="17"><a href="parceiros.html"><img src="imagens/parceiros_link.jpg" width="190" height="39"></a></td>
</tr>
<tr>
<td height="15" width="1">
<img src="imagens/azul.jpg" width="192" height="17"></td>
</tr>
<tr>
<td height="15" width="1">
<a href="downloads.html">
<img src="imagens/dowloads_link.jpg" width="190" height="39"></a></td>
</tr>
<tr>
<td height="18" width="1">
<img src="imagens/azul.jpg" width="192" height="17"></td>
</tr>
</table>
</TD>
</TD>
<TD width="551" height="122">
<table width="457" bgcolor="#FFFFFF" bordercolor="#111111" cellpadding="0" cellspacing="0" style="border-collapse: collapse" height="1">
<td align="left" style="text-indent: 0; margin-left: 0" width="1371" height="1" colspan="2">
<p align="center">
<%
String id_ra,data_nasc,senha;
String nom="";
String data="";
String sen="";
int cont=0;
id_ra=request.getParameter("id_ra");
data_nasc=request.getParameter("data_nasc");
senha=request.getParameter("senha");
try
{
//Passo1: Carregar o Driver JDBC
Class.forName("com.mysql.jdbc.Driver").newInstance();
//Passo2: Criar um objeto para Conexao
Connection con=DriverManager.getConnection("jdbc:mysql://localhost/integracao","root","");
//Passo3: Criar um objeto para execucao de consultas
Statement s=con.createStatement();
//Passo4: cadastrar aluno
ResultSet rs=s.executeQuery("select id_ra, data_nasc, senha from universitarios where id_ra like \""+id_ra+"%\"");
while(rs.next())
{
cont=cont+1;
nom=rs.getString(1);
data=rs.getString(2);
sen=rs.getString(3);
}
if(id_ra.equals(nom) && data_nasc.equals(data) && senha.equals(sen))
{
//Caso login e senha estejam corretos...
out.println("<center>Universitario Logado com sucesso!!!</center>"); //Mostra na tela que foi logado com sucesso
session.putValue("id_ra", id_ra); //Grava a session com o Login
session.putValue("senha", senha); //Grava a session com a Senha
out.println("<script>document.location.href='logado_universitario.jsp';</script>"); //Exibe um código javascript para redireionar ao painel
}
else
{
//Se estiverem incorretos...
out.println("<center>Login ou senha inválidos!</center>"); //Exibe na tela e pede para voltar
}
}
catch(ClassNotFoundException e1)
{
out.print("Usuário inválido");
}
%>
<p align="center">
<p align="center">
<a href="esquecer_senha_universitario.html">
<input name="I1" type="image" value="Enviar!" src="imagens/enviar.jpg" width="134" height="36"></a></td>
</tr>
<font size="1" face="Times New Roman" color="#003366">
</font>
<font size="1" face="Times New Roman" color="#003366">
</font>
<font size="1" face="Times New Roman" color="#003366">
</font>
<font size="1" face="Times New Roman" color="#003366">
</font>
<font size="1" face="Times New Roman" color="#003366">
</font>
</table>
</TD>
</TR>
</table>
<table width="755" bgcolor="#FFFFFF" bordercolor="#111111" cellpadding="0" cellspacing="0">
<tr>
<td background="0A1633" height="16" width="753" bgcolor="#808080">
<p align="center"><font color="#000033" size="2" class="verdana" >Copyright@2008 - Opção de Qualidade - Todos os direitos reservados</p>
</td>
</tr>
</table>
<table width="755" bgcolor="#FFFFFF" bordercolor="#111111" cellpadding="0" cellspacing="0">
<tr>
<td height="16" width="753">
<img src="imagens/azul.jpg" width="755" height="17"></td>
</tr>
</table>
</div>
<div align="center"></div>
</body>
</html>
<html>
type Exception report
message
description The server encountered an internal error () that prevented it from fulfilling this request.
exception
org.apache.jasper.JasperException
org.apache.jasper.servlet.JspServletWrapper.service(JspServletWrapper.java:372)
org.apache.jasper.servlet.JspServlet.serviceJspFile(JspServlet.java:292)
org.apache.jasper.servlet.JspServlet.service(JspServlet.java:236)
javax.servlet.http.HttpServlet.service(HttpServlet.java:802)
root cause
java.lang.NullPointerException
org.apache.jsp.esquecer_005fsenha_005funiversitario_jsp._jspService(esquecer_005fsenha_005funiversitario_jsp.java:181)
org.apache.jasper.runtime.HttpJspBase.service(HttpJspBase.java:94)
javax.servlet.http.HttpServlet.service(HttpServlet.java:802)
org.apache.jasper.servlet.JspServletWrapper.service(JspServletWrapper.java:324)
org.apache.jasper.servlet.JspServlet.serviceJspFile(JspServlet.java:292)
org.apache.jasper.servlet.JspServlet.service(JspServlet.java:236)
javax.servlet.http.HttpServlet.service(HttpServlet.java:802)
note The full stack trace of the root cause is available in the Apache Tomcat/5.0.28 logs.