Salax

arrumar?

Tenta fazer uma requisição para servlet, lá vc passa os parâmetros e ela faz a consulta retornando true ou false.

Ae tenta adaptar pra vc

index
<form name="forLogin" method="POST" action="ServletLogin">
<label>Usuário</label>&nbsp;<input type="text" name="j_username" size="15" maxlenght="15"/>
<label>Senha</label>&nbsp;<input type="password" name="j_password" size="15" maxlenght="15"/>
&nbsp;<input type="submit" name="btOk" value="Entrar"/>
</form>


ServletLogin

PrintWriter out = response.getWriter();
String login = request.getParameter("j_username");
String pwd = request.getParameter("j_password");
HttpSession sessao;
intt log = 0;
//conecta com o banco
Connection conexao = (Connection) new ConnectionFactory().getConnection();
String sql = "select login, password, id from users where login=? and password=?;";
PreparedStatement stmt = (PreparedStatement) conexao.prepareStatement(sql);
stmt.setString(1, login);
stmt.setString(2, pwd);
ResultSet rs = stmt.executeQuery();
while (rs.next()) {
log = rs.getInt("id");

}
RequestDispatcher rd = null;
if (log == 0) {
out.println("Usuário ou senha inválida");
sessao.invalidate();
} else {
rd = request.getRequestDispatcher("Home.jsp");
rd.forward(request, response);
}
}