project help

krapa · June 26th, 2008, 06:00 AM

hi,

i m trying to verify the user name and password entered by the user form the data stored in oracle database using jsp...but its not working...

code ....

<%@ page import="java.sql.*" %>
<%Class.forName("oracle.jdbc.driver.OracleDriver") ; %>

<html>
<head>
<tiltle>verification</title>
</head>
<body>
<%
            Connection con = DriverManager.getConnection("jdbc:oracle:thin:@loc alhost:1521:abc", "system", "abc");

            Statement s = con.createStatement();

            String pwd= request.getParameter("password");
            String user= request.getParameter("user");

            ResultSet r = s.executeQuery("select * from user_details where password = 'pwd' AND user='user'") ;

            if(!r.next())
{
                out.println("Sorry, No such user exists. " + "Please <A HREF='welcome.jsp'>try again</A>.");
            } else {
        %>
<jsp:forward page="welcome.jsp"/>
<%
}
%>
</body>
</html>

please help me with this!!

debasisdas · July 4th, 2008, 04:38 AM

you need to use COUNT with the username and corresponding password entered by the user to check for the existance of the same in the database. If count returns 1 allow to login else reprompt for the correct username and password.

Username must be a primary key field in the database table.

Regards
Debasis