Anyone could help me how can i create a login page by jsp....
it need to check username = password from database
 if u forget password it remind you your secret question and answer...THANKS

<%
String username=request.getParameter("username");
String userpass=request.getParameter("userpass");
String DBDriver="jdbc:odbc:driver={Micosoft Access Driver(*.mdb)";
try{
    Connection conn=null;
    Class.forName("sun.jdbc.odbc.JdbcOdbcDriver");
    conn=DriverManager.getConnection(DBDriver);
    Statement comm=conn.createStatement();
    String strSQL = "select * from member where username='"+username+"' and userpass='"+userpass+"'";
    ResultSet Res=comm.executeQuery();
    if(!Res.next()){
        out.println("<script>alert('error information');</script>");
    }else{
        out.println("welcome"+username+"!");
    }
}catch(Exception ex){
    out.println("Error:"+ex.getMessage());
}finally{
    Res.close();
    conn.close();
}
%>

Hello You are right on the way.
Except following is the little mistake i noticed in the piece of code you prepared.
For reference your statement is :
      ResultSet Res=comm.executeQuery();
You need to pass the parameter which is a SQL query(String) to the executeQuery() method.

so the statement would become as :
     ResultSet Res=comm.executeQuery(strSQL);


Regards
Dadasaheb T. Honde

i have modify the code that peter huang wrote and try to run .. but erro occur .. can anyone helps me?

[u]admin_login.jsp</u>
<%@ page import="java.sql.*" %>

<%
    String adminId = request.getParameter("admin_id");
    String adminPassword = request.getParameter("admin_password");
    String driver = "jdbc:mysql.jdbc.Driver";
    String url = "jdbc:mysql://localhost:3306/sers";
    String username = "root";
    String password = "123";
    String query = "SELECT admin_id,admin_password FROM admin WHERE admin_id = '"+adminId+"' AND admin_password = '"+adminPassword+"'";
    Connection con = null;
    Statement statement = null;
    ResultSet rs = null;

    try
    {
        Class.forName(driver);
        con = DriverManager.getConnection(url,username,password) ;
        statement = con.createStatement();
        rs = statement.executeQuery(query);
        if(!rs.next())
        {
            out.println("<h1>Login Fail</h2>");
        }
        else
        {
            out.println("<h1>welcome" + "!</h1>");
        }
    }
    catch(Exception ex)
    {
        out.println("Error: " + ex.getMessage());
    }
    finally
    {
        rs.close();
        con.close();
    }
%>