já pensei nisso… e estou vendo com o pessoal do provedor…
a servlet é essa, se puder me ajudar?? tenta passar o usuário e senha com qq banco… muito estranho…vou fazer uma page html chamando no action a servlet pra ver se passa o Post…
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 javax.servlet.RequestDispatcher;
import javax.servlet.ServletException;
import javax.servlet.http.HttpServlet;
import javax.servlet.http.HttpServletRequest;
import javax.servlet.http.HttpServletResponse;
public class LoginServlet extends HttpServlet {
public void doGet(HttpServletRequest request, HttpServletResponse response)
throws ServletException, IOException {
sendLoginForm(response, false);
}
private void sendLoginForm(
HttpServletResponse response,
boolean withErrorMessage)
throws ServletException, IOException {
response.setContentType("text/html");
PrintWriter out = response.getWriter();
out.println("<HTML>");
out.println("<HEAD>");
out.println("<TITLE>Login</TITLE>");
out.println("</HEAD>");
out.println("<BODY>");
out.println("<CENTER>");
if (withErrorMessage)
out.println("Falha de login, tente novamente.<BR>");
out.println("<BR>");
out.println("<BR><H2>Página de Login</H2>");
out.println("<BR>");
out.println("<BR>Entre com o nome de usuário e senha.");
out.println("<BR>");
out.println("<BR><FORM METHOD=POST>");
out.println("<TABLE>");
out.println("<TR>");
out.println("<TD>Nome:</TD>");
out.println("<TD><INPUT TYPE=TEXT NAME=Vnome></TD>");
out.println("</TR>");
out.println("<TR>");
out.println("<TD>Senha:</TD>");
out.println("<TD><INPUT TYPE=PASSWORD NAME=Vsenha></TD>");
out.println("</TR>");
out.println("<TR>");
out.println("<TD ALIGN=RIGHT COLSPAN=2>");
out.println("<INPUT TYPE=SUBMIT VALUE=Login></TD>");
out.println("</TR>");
out.println("</TABLE>");
out.println("</FORM>");
out.println("</CENTER>");
out.println("</BODY>");
out.println("</HTML>");
}
public void doPost(HttpServletRequest request, HttpServletResponse response)
throws ServletException, IOException {
String Vnome = request.getParameter("Vnome");
String Vsenha = request.getParameter("Vsenha");
if (login(Vnome, Vsenha)) {
RequestDispatcher rd =
request.getRequestDispatcher("TestingServlet");
rd.forward(request, response);
} else {
sendLoginForm(response, true);
}
}
boolean login(String Vnome, String Vsenha) {
try {
Class.forName("com.jnetdirect.jsql.JSQLDriver");
Connection con = DriverManager.getConnection(
"jdbc:JSQLConnect://IPsqlserver/login", "login", "senha");
Statement s = con.createStatement();
String sql =
"SELECT V_nome FROM Users"
+ " WHERE V_nome='"
+ Vnome
+ "'"
+ " AND V_senha='"
+ Vsenha
+ "'";
ResultSet rs = s.executeQuery(sql);
if (rs.next()) {
rs.close();
s.close();
con.close();
return true;
}
rs.close();
s.close();
con.close();
} catch (ClassNotFoundException e) {
System.out.println(e.toString());
} catch (SQLException e) {
System.out.println(e.toString());
} catch (Exception e) {
System.out.println(e.toString());
}
return false;
}
}