Good Day! Im working on a jsp simple application that a user needs to log-in first before he can check out the items on a cart. I have created a database in ms access and im getting errors like...
An error occurred at line: 8 in the jsp file: /user.jsp
Generated servlet error:
Duplicate local variable username
An error occurred at line: 8 in the jsp file: /user.jsp
Generated servlet error:
record cannot be resolved
An error occurred at line: 8 in the jsp file: /user.jsp
Generated servlet error:
Duplicate local variable password
An error occurred at line: 8 in the jsp file: /user.jsp
Generated servlet error:
record cannot be resolved
i have already changed the variables but to no avail..
This is my code...
<HTML>
<HEAD>
<BODY>
<%@ page import="java.sql.*" %>
<%
new sun.jdbc.odbc.JdbcOdbcDriver();
String username="";
String password="";
String dburl="jdbc:odbc:wencydb";
String sql=("SELECT TEXT FROM tboWency");
Connection cn=DriverManager.getConnection(dburl,username,password);
Statement stmt=cn.createStatement();
ResultSet rs=stmt.executeQuery(sql);
String user=request.getParameter("username");
String pass=request.getParameter("password");
String username=(String) record.elementAt(0);
String password=(String) record.elementAt(1);
if(user == "Username" && pass == "Password") {
out.println("You have successfully checked out your items..");
}
else {
out.println("Sorry invalid log-in please register");
}
%>
</BODY>
</HEAD>
</HTML>
Been working on these for a week searching for tutorials that could help.. Any enlightenment will be much appreciated.. Tnx much in advance..