I can’t seem to figure it out i have this code which i took from a button for reloading a page
[CODE]window.location.reload()
But i cant seem to incorporate it within my Login Script’s IF statement.
[CODE]<%
Class.forName(“sun.jdbc.odbc.JdbcOdbcDriver”).newInstance();
Connection conn = DriverManager.getConnection(“jdbc:odbc:Driver={Microsoft Access Driver (*.mdb, *.accdb)};DBQ=C:/Program Files/Apache Software Foundation/Tomcat 6.0/webapps/2009-sem2/cs205189/Final/javaDatabase.accdb;”);
Statement statement = conn.createStatement();
String usernameParam = request.getParameter(“usernameField”);
String passwordParam = request.getParameter(“passwordField”);
ResultSet columns = statement.executeQuery(“SELECT * FROM Users WHERE Username='” +
usernameParam + “‘ AND Pass='” + passwordParam + “‘;”);
String sUserName=null;
String sUserPassword;
if(columns.next())
{
sUserName = columns.getString(“Username”);
sUserPassword = columns.getString(“Pass”);
}
%>
<% if (sUserName != null) {
session.setAttribute(“Successful login”,sUserName); %>
<h3> Your login has succeeded </h3>
<% out.print(sUserName); %>
<% } else { %>
<h3> Login Failed </h3>
window.location.reload()
<% } %>
Basically ive done it so if you type the wrong info it says login failed, yet after that i want it to reload the Login Page.
Any help greatly Appreciated ?
Liam