<%@ page import="java.sql.*" %>
<%@ page import="java.sql.Connection" %>
<%@ page import="java.sql.DriverManager" %>
<%@ page import="java.sql.SQLException" %>
<%@ page import="java.io.*" %>
<%
    String username=request.getParameter("username");
    String password=request.getParameter("password");
    out.println(password);
    String connectionURL = "jdbc:mysql://localhost:3306/jsplogin?user=root;password=";
    Connection connection = null;
    Statement statement = null;
    ResultSet rs = null;
    Class.forName("com.mysql.jdbc.Driver").newInstance ();
    connection = DriverManager.getConnection(connectionURL, "", "");
    statement = connection.createStatement();
    rs = statement.executeQuery("SELECT * FROM jsplogin WHERE username='"+username+"'");
    rs.first();
    String temp=rs.getString("password");
    out.println(temp==password);
    if (temp==password) {
        response.sendRedirect("correct.htm");
    }else
    {
    }
    rs.close();


%>

To simulate a simple login, i need to open a database connection, then connect to database, and compare wheather the user name and password match. Now the problem is, the executed statement whenever compared to the password post from a form, it returns a false value, which will never be authenticated, why, any solution??

Replace "==" comparision with equals() method. Since when "==" operator is used for comparing two objects. It will compare the references of those objects and not actual content in those objects(since Strings are also objects). To compare the actual value in those String objects we need to use equals() method (of Object class) which is overridden in String class to meet this purpose.

prasanth.c

what if there's 5 users and they have different positions.

what's the code for login if every user has corresponding page to go to..?