Mensagem de erro

1 resposta
B

Bom dia pessoal estou com problema nesse programa pra celular alguém pode me ajudar será q alguma conexão com o banco ou no arquivo xml no servlets

esse é o erro

HTTP Status 500 -


type Exception report

message

description The server encountered an internal error () that prevented it from fulfilling this request.

exception

org.apache.jasper.JasperException: Exception accessing property logado for bean login: java.lang.NullPointerException

org.apache.jasper.servlet.JspServletWrapper.handleJspException(JspServletWrapper.java:510)

org.apache.jasper.servlet.JspServletWrapper.service(JspServletWrapper.java:375)

org.apache.jasper.servlet.JspServlet.serviceJspFile(JspServlet.java:314)

org.apache.jasper.servlet.JspServlet.service(JspServlet.java:264)

javax.servlet.http.HttpServlet.service(HttpServlet.java:802)

org.netbeans.modules.web.monitor.server.MonitorFilter.doFilter(MonitorFilter.java:368)

root cause

javax.servlet.ServletException: Exception accessing property logado for bean login: java.lang.NullPointerException

org.apache.jasper.runtime.PageContextImpl.doHandlePageException(PageContextImpl.java:858)

org.apache.jasper.runtime.PageContextImpl.handlePageException(PageContextImpl.java:791)

org.apache.jsp.index_jsp._jspService(index_jsp.java:100)

org.apache.jasper.runtime.HttpJspBase.service(HttpJspBase.java:97)

javax.servlet.http.HttpServlet.service(HttpServlet.java:802)

org.apache.jasper.servlet.JspServletWrapper.service(JspServletWrapper.java:332)

org.apache.jasper.servlet.JspServlet.serviceJspFile(JspServlet.java:314)

org.apache.jasper.servlet.JspServlet.service(JspServlet.java:264)

javax.servlet.http.HttpServlet.service(HttpServlet.java:802)

org.netbeans.modules.web.monitor.server.MonitorFilter.doFilter(MonitorFilter.java:368)

root cause

javax.servlet.jsp.JspException: Exception accessing property logado for bean login: java.lang.NullPointerException

org.apache.struts.taglib.logic.CompareTagBase.condition(CompareTagBase.java:189)

org.apache.struts.taglib.logic.NotEqualTag.condition(NotEqualTag.java:46)

org.apache.struts.taglib.logic.ConditionalTagBase.doStartTag(ConditionalTagBase.java:174)

org.apache.jsp.index_jsp._jspx_meth_logic_notEqual_0(index_jsp.java:118)

org.apache.jsp.index_jsp._jspService(index_jsp.java:83)

org.apache.jasper.runtime.HttpJspBase.service(HttpJspBase.java:97)

javax.servlet.http.HttpServlet.service(HttpServlet.java:802)

org.apache.jasper.servlet.JspServletWrapper.service(JspServletWrapper.java:332)

org.apache.jasper.servlet.JspServlet.serviceJspFile(JspServlet.java:314)

org.apache.jasper.servlet.JspServlet.service(JspServlet.java:264)

javax.servlet.http.HttpServlet.service(HttpServlet.java:802)

org.netbeans.modules.web.monitor.server.MonitorFilter.doFilter(MonitorFilter.java:368)

note The full stack trace of the root cause is available in the Apache Tomcat/5.5.17 logs.

Classe login

package cadastro;

import java.sql.*;

public class Login extends Conexao {

private String usuario="";

private String senha="";

private String logado="";

private String mensagem="";
public Login(){
	conecta();
}

public String getMensagem() {
	return mensagem;
}
public String getSenha() {
	return senha;
}

public void setSenha(String senha) {
	this.senha = senha;
}

public String getUsuario() {
	return usuario;
}

public void setUsuario(String usuario) {
	this.usuario = usuario;
}

public String getLogado() {
	// se ainda não validado o usuario como "OK"
	if (logado != "ok") {
		// procura no banco de dados
		try {
			
			PreparedStatement sql = conn
       			.prepareStatement("SELECT * FROM usuarios where nome = ?  and senha = ?");
			sql.setString(1, usuario);
			sql.setString(2, senha);
			//System.out.println(sql); // em caso de erro tire o comentario
			ResultSet rs = sql.executeQuery();
			if (rs.next()) {
				logado = "ok";
				mensagem = "Logado";
			} else {
				mensagem = "Usuário Errado";
			}
			rs.close();
		} catch (SQLException ex) {
			mensagem = "Erro Sql:" + ex.getMessage();
		}
	}
	return logado;
}

}

Classe Conexao

package cadastro;

import java.sql.*;

public class Conexao {

protected Connection conn;

protected String mensagem;
public final int TRUE_MYSQL=1;
public final int FALSE_MYSQL=0;
public void conecta() {

mensagem="";

try {

Class.forName(com.mysql.jdbc.Driver).newInstance();

}

catch (Exception ex) {

mensagem = Driver não carregado!;

System.out.println(erro:+mensagem);

}
try {
  conn = DriverManager.getConnection("jdbc:mysql://localhost/comercio",
                                        "root", "root");
}
catch (SQLException ex) {
  mensagem = ex.getMessage();
  System.out.println("erro:"+mensagem);
}

}

}

index

<%@ page contentType=text/vnd.wap.wml%>

<%@taglib uri="/WEB-INF/struts-logic.tld" prefix=logic%>

<jsp:useBean id=“login” scope=“session” class=“cadastro.Login”/>

<?xml version=“1.0” encoding=“ISO-8859-1”?>

<!DOCTYPE wml PUBLIC “-//WAPFORUM//DTD WML 1.1//EN” “<a href="http://www.wapforum.org/DTD/wml_1.1.xml">http://www.wapforum.org/DTD/wml_1.1.xml</a>”>

<wml>

<head>

<meta http-equiv=“Cache-Control” content=“must-revalidate”/>

<meta http-equiv=“Expires” content=“Tue, 01 Jan 1980 1:00:00 GMT”/>

<meta http-equiv=“Cache-Control” content=“max-age=0”/>

</head>

<card id=“login” title=“Mobile”>

<p>

<jsp:getProperty name=“login” property=“mensagem” /> <br/>

<logic:notEqual name=“login” property=“logado” value=“ok”>

Usuario: <input name=“usuario” title=“usuario”/>

Senha: <input name=“senha” type=“password” title=“senha”/>

<anchor>Login

<go href="./produto.jsp" method=“post”>

<postfield name=“usuario” value="$usuario"/>

<postfield name=“senha” value="$senha"/>

</go>

</anchor>

</logic:notEqual>

<logic:equal name=“login” property=“logado” value=“ok”>

<br>usuario: <jsp:getProperty name=“login” property=“usuario” /><br>

<anchor>Encerrar Sessão

<go href="./encerra.jsp">

</go>

</anchor>

</logic:equal>

</p>

</card>

</wml>
XML

<?xml version=“1.0” encoding=“UTF-8”?>

<web-app version=“2.4” xmlns=“<a href="http://java.sun.com/xml/ns/j2ee">http://java.sun.com/xml/ns/j2ee</a> xmlns:xsi=“<a href="http://www.w3.org/2001/XMLSchema-instance">http://www.w3.org/2001/XMLSchema-instance</a> xsi:schemaLocation=“<a href="http://java.sun.com/xml/ns/j2ee">http://java.sun.com/xml/ns/j2ee</a> <a href="http://java.sun.com/xml/ns/j2ee/web-app_2_4.xsd">http://java.sun.com/xml/ns/j2ee/web-app_2_4.xsd</a>”>

<context-param>

<param-name>com.sun.faces.verifyObjects</param-name>

<param-value>false</param-value>

</context-param>

<context-param>

<param-name>com.sun.faces.validateXml</param-name>

<param-value>true</param-value>

</context-param>

<context-param>

<param-name>javax.faces.STATE_SAVING_METHOD</param-name>

<param-value>client</param-value>

</context-param>

<servlet>

<servlet-name>Faces Servlet</servlet-name>

<servlet-class>javax.faces.webapp.FacesServlet</servlet-class>

<load-on-startup>1</load-on-startup>

</servlet>

<servlet>

<servlet-name>action</servlet-name>

<servlet-class>org.apache.struts.action.ActionServlet</servlet-class>

<init-param>

<param-name>config</param-name>

<param-value>/WEB-INF/struts-config.xml</param-value>

</init-param>

<init-param>

<param-name>debug</param-name>

<param-value>2</param-value>

</init-param>

<init-param>

<param-name>detail</param-name>

<param-value>2</param-value>

</init-param>

<load-on-startup>2</load-on-startup>

</servlet>

<servlet-mapping>

<servlet-name>Faces Servlet</servlet-name>

<url-pattern>/faces/<em></url-pattern>

</servlet-mapping>

<servlet-mapping>

<servlet-name>action</servlet-name>

<url-pattern></em>.do</url-pattern>

</servlet-mapping>

<session-config>

<session-timeout>

30

</session-timeout>

</session-config>

<welcome-file-list>

<welcome-file>

index.jsp

</welcome-file>

</welcome-file-list>

<jsp-config>

<taglib>

<taglib-uri>/WEB-INF/struts-bean.tld</taglib-uri>

<taglib-location>/WEB-INF/struts-bean.tld</taglib-location>

</taglib>

<taglib>

<taglib-uri>/WEB-INF/struts-html.tld</taglib-uri>

<taglib-location>/WEB-INF/struts-html.tld</taglib-location>

</taglib>

<taglib>

<taglib-uri>/WEB-INF/struts-logic.tld</taglib-uri>

<taglib-location>/WEB-INF/struts-logic.tld</taglib-location>

</taglib>

<taglib>

<taglib-uri>/WEB-INF/struts-nested.tld</taglib-uri>

<taglib-location>/WEB-INF/struts-nested.tld</taglib-location>

</taglib>

<taglib>

<taglib-uri>/WEB-INF/struts-tiles.tld</taglib-uri>

<taglib-location>/WEB-INF/struts-tiles.tld</taglib-location>

</taglib>

</jsp-config>

</web-app>

1 Resposta

B

Consegui fazer funcionar era a biblioteca do mysql que não estava adicionada na projeto.

Valeu .

Criado 31 de outubro de 2007
Ultima resposta 1 de nov. de 2007
Respostas 1
Participantes 1