Problema com org.gjt.mm.mysql.Driver

Galera estou com o seguinte problema:

tenho a pagina principal:

<?xml version='1.0' encoding='UTF-8' ?>
<!DOCTYPE html PUBLIC "-//W3C//DTD XHTML 1.0 Transitional//EN" "http://www.w3.org/TR/xhtml1/DTD/xhtml1-transitional.dtd">
<html xmlns="http://www.w3.org/1999/xhtml"
      xmlns:h="http://java.sun.com/jsf/html">
    <h:head>
        <title>Pesquisa</title>
    </h:head>
    
<frameset rows="10%,*" frameborder="1" framespacing="2">
<frame src="top.xhtml" name="top" noresize="NO"></frame>
<frame src="bot.xhtml" name="bot" marginwidth="2" marginheight="3" noresize ="YES"></frame>
</frameset>
    
</html>

Pagina top.xhtml

<?xml version='1.0' encoding='UTF-8' ?>
<!DOCTYPE html PUBLIC "-//W3C//DTD XHTML 1.0 Transitional//EN" "http://www.w3.org/TR/xhtml1/DTD/xhtml1-transitional.dtd">
<html xmlns="http://www.w3.org/1999/xhtml"
      xmlns:h="http://java.sun.com/jsf/html">
    <h:head>
        <title>Pesquisa</title>
    </h:head>

    <h:body>

        <center>
            <table border="1" bgcolor='black'>
                <tr bgcolor='white'>
                    <td>&nbsp;&nbsp; <a href="oquee.xhtml" target="bot">O que é?&nbsp;&nbsp; </a> </td> 
                    <td>&nbsp;&nbsp; <a href="objetivos.xhtml">Objetivos?&nbsp;&nbsp; </a> </td> 
                    <td>&nbsp;&nbsp; <a href="participar.xhtml">Como Participar?&nbsp;&nbsp; </a> </td> 
                    <td>&nbsp;&nbsp; <a href="contato.xhtml">Contato&nbsp;&nbsp; </a> </td> 
                    <td></td>
                    <td></td>
                    <td></td>
                    <form action="PreCorrecao" method="POST" target="_blank">
                        <td>

                            &nbsp;&nbsp;Usuário:  
                            <input type="text" name="usuario" size="8" value="Usuario"></input>

                            &nbsp;Senha: 
                            <input type="password" name="senha" size="8"></input> 

                            <input type="submit" value = "Logar"> </input>
                        </td>
                    </form>
                </tr>
            </table> 
        </center>

    </h:body>
</html>

e a PreCorrecao

/* * To change this template, choose Tools | Templates * and open the template in the editor. */
import java.io.IOException;
import java.io.PrintWriter;
import java.sql.Connection;
import java.sql.DriverManager;
import java.sql.ResultSet;
import java.sql.SQLException;
import java.sql.Statement;
import java.util.logging.Level;
import java.util.logging.Logger;
import javax.servlet.ServletException;
import javax.servlet.annotation.WebServlet;
import javax.servlet.http.HttpServlet;
import javax.servlet.http.HttpServletRequest;
import javax.servlet.http.HttpServletResponse;

//
/**
*
* @author Rodrigo Marqui Garcia
*/
@WebServlet(name = "PreCorrecao", urlPatterns = {"/PreCorrecao"})
public class PreCorrecao extends HttpServlet {

/**
* Processes requests for both HTTP
* GET and
* POST methods.
*
* @param request servlet request
* @param response servlet response
* @throws ServletException if a servlet-specific error occurs
* @throws IOException if an I/O error occurs
*/
protected void processRequest(HttpServletRequest request, HttpServletResponse response)
throws ServletException, IOException, SQLException, ClassNotFoundException {
response.setContentType("text/html;charset=UTF-8");
PrintWriter out = response.getWriter();

String txtNome = request.getParameter("usuario");
String txtSenha = request.getParameter("senha");
boolean result = false;

out.println(" out.println("xmlns:h=\"http://java.sun.com/jsf/html\">");
out.println("");
out.println("WebWisc");
out.println("");
out.println("");
out.println("
");
out.println("

");
out.println("

");

Class.forName("org.gjt.mm.mysql.Driver");
Connection con = null;

con = DriverManager.getConnection("jdbc:mysql://site.com.br:3306/aplicacao", "usuario", "senha");
Statement stm = con.createStatement();
String SQL = "SELECT * FROM TabelaLogar WHERE usuario='" + txtNome + "' AND senha='" + txtSenha + "'";
ResultSet rs = stm.executeQuery(SQL);

while (rs.next()) {
result = true;

}

if (result = true) {

out.println("
Por favor Escolha a Idade do avaliando:

");

out.println("
");
out.println("");
out.println("
");

out.println("
");
out.println("");
out.println("
");

out.println("
");
out.println("");
out.println("
");

out.println("
");
out.println("");
out.println("
");

out.println("
");
out.println("");
out.println("
");

out.println("
");
out.println("");
out.println("
");

} else {

out.println("
Usuário Invalido ou Senha Incorreta
");
}

out.println("
");
out.println("");
out.println("");

}

/**
* Handles the HTTP
* GET method.
*
* @param request servlet request
* @param response servlet response
* @throws ServletException if a servlet-specific error occurs
* @throws IOException if an I/O error occurs
*/
@Override
protected void doGet(HttpServletRequest request, HttpServletResponse response)
throws ServletException, IOException {
//processRequest(request, response);
}

/**
* Handles the HTTP
* POST method.
*
* @param request servlet request
* @param response servlet response
* @throws ServletException if a servlet-specific error occurs
* @throws IOException if an I/O error occurs
*/
@Override
protected void doPost(HttpServletRequest request, HttpServletResponse response)
throws ServletException, IOException {
System.out.println("POST");
try {
processRequest(request, response);
} catch (SQLException ex) {
Logger.getLogger(PreCorrecao.class.getName()).log(Level.SEVERE, null, ex);
} catch (ClassNotFoundException ex) {
Logger.getLogger(PreCorrecao.class.getName()).log(Level.SEVERE, null, ex);
}
}

/**
* Returns a short description of the servlet.
*
* @return a String containing servlet description
*/
@Override
public String getServletInfo() {
return "Short description";
}//
}

O problema é.... quando eu deixo a tela PreCorrecao sem a conexao com o banco de dados..... ele carrega certinho! quando ele fica com a verificacao do BD ai ele abre a pagina em branco

qual, o problema?

Por favor Escolha a Idade do avaliando:

3 Respostas

Topicos relacionados