type Exception report
message
description The server encountered an internal error () that prevented it from fulfilling this request.
exception
java.lang.NullPointerException
at br.com.leo.web.Pass.doPost(Pass.java:25)
at javax.servlet.http.HttpServlet.service(HttpServlet.java:760)
"" "" ""
"" "" "" ""
<%@ page import="java.util.Calendar" %>
<%@ page language="java"%>
<html>
<head>
<title> - Sistema interno de controle de horas</title>
</head>
<body>
<font color="GREY" size=3 face="verdana">
&nbsp;Sistema interno de controle de horas<br></FONT><br>
<font color="GREY" size=1 face="verdana">
Faça seu login abaixo:</font>
<table border="0" cellpadding="5" cellspacing="5">
<form method="POST" action=/servlets/pass >
<tr>
<td><font color="GREY" size=0 face="verdana">Login: </td> <td>
<input type="text" name="login" maxlength="8"></font></td>
</tr>
<tr>
<td><font color="GREY" size=0 face="verdana">Password:</td> <td>
<input type="password" name="password" maxlength="8"></font></td>
</tr>
<tr>
<td><input type="submit" value="OK"></td>
</tr>
</form>
</table>
</body>
import javax.servlet.*;
import javax.servlet.http.*;
import java.io.*;
import java.sql.SQLException;
import java.sql.Connection;
import java.sql.ResultSet;
import java.sql.Statement;
public class Pass extends HttpServlet
{
public void doPost(HttpServletRequest request,HttpServletResponse response)
throws ServletException, IOException
{
String login = request.getParameter("login");
String password = request.getParameter("password");
Connection con = null;
Statement stmt =null;
ResultSet rs = null;
try
{
con = Banco.getConnection();
stmt = con.createStatement();
rs = stmt.executeQuery("select * from tts_user");
try
{
while(rs.next())
{
String name= rs.getString("usr_login_nm");
//aqui faço um if para validar o acesso rediricionando
// a pagina usando response.sendRedirect("XXX");
}
}
catch(Exception e){}
}
catch(SQLException e){}
finally
{
try{
rs.close();
con.close();
}
catch(Exception e){}
}
}
}
package br.com.leo.web;
import javax.servlet.http.*;
import java.sql.Connection;
import java.sql.SQLException;
import java.sql.DriverManager;
public class Banco extends HttpServlet
{
public static Connection getConnection()
{
try
{
Class.forName("oracle.jdbc.driver.OracleDriver");
return DriverManager.getConnection("jdbc:oracle:thin:@oracle:XXXXX:AAAA", "BBBB", "CCCCC");
}
catch (ClassNotFoundException e)
{
e.printStackTrace();
System.out.println("erro 1111");
}
catch (SQLException e1)
{
e1.printStackTrace();
}
return null;
}
}
eu rodo e dá aquele msg de erro lá em cima.....e no console eu tentei ver aonde estava aparecendo um errro, ele imprimia o erro da exception ClassNotFoundException ............
Tentei fazer varias tipos de tratamento.....inicializar os objetos sem"valor" e nada......
por favor, me ajudem a resolver isto.
obrigado!!
