ID Verification using JSP

hi friends,plz read the method
authenticate as validate.

The jspin.com newsletter said that:
This script uses JSP pages to validate a user ID and password from a MS Access database.

The article did not show how to retrieve any thing from a MS Access database.

Since I know of no open source Type 4 jdbc drivers for the MS Access database,
connecting to a MS Access database is prevented from a java server side jsp.

I was hoping to see if you knew something that a lot of developers are wondering about.

Also, your script sends password in the open on an http connection. This is not a good idea. It might be more secure to send a secure hash of the username and pasword combination. Otherwise the history in a users browser is vulnaerable to expose the passwords. Look for urls which contain a string password="ceab". A secure hash of the passord and user name cannot be reverse engineered to get their values.

this article does not need to show how
to retrive any thing from database.
it shows the sql statements needed
to check the userid and password from
a database.abt security,it can be
incorporated.


public boolean authenticate(String username2,
String password2) {
String query="select * from Registration;";
String DbUserName="";
String DbPassword="";
String finalUser="";
try {
Class.forName("sun.jdbc.odbc.JdbcOdbcDriver");
Connection
con=DriverManager.getConnection("jdbc:odbc:register");
Statement stat=con.createStatement();
ResultSet rst=stat.executeQuery(query);
while(rst.next())

{
DbUserName=rst.getString("UserName");

DbPassword=rst.getString("password");

This coding is nice,but what i want to know for a New user. and in this article Retry.jsp and success.jsp are missing. How to connect DB2 Database.
Aslam.

Doesn't the call to authenticate() in process2.jsp require that you pass the user and pass?

hello
i am using oracle http server powered by apache.
i am using your code but getting the following error.

oracle.jsp.pars.JspParsaException: Line # 1, Error: Unable to find class for bean: idHandler defined by tag with class: beans.Login

Please help me solve this problem.
i am using oracle database not the access

regards
Laila

Erm.. Jason,
You are right, i felt the same way too.
But do you know how to debug it?
Don't mind showing me?

Anyone?

Thanks alot!

Please could someone sort this error Excellent code otherwise An error occurred between lines: 6 and 8 in the jsp file: /jsp/process2.jsp

Generated servlet error:
C:\tomcat\work\Standalone\localhost\examples\jsp\process2$jsp.java:100: Method validate() not found in class foo.Login.
if (idHandler.validate()) {
^
1 error, 1 warning

How do you allow different users to enter the site and enter there different details in a JSP platform?

Friends,plz use read the validate
method as authenticate or vice versa.
this is a mistake on my part while
submitting.there is only one method
either use authenticate or validate.

i am getting error as follows:

org.apache.jasper.JasperException: Unable to compile class for JSPNote: sun.tools.javac.Main has been deprecated.


An error occurred between lines: 6 and 8 in the jsp file: /jsp/process2.jsp

Generated servlet error:
C:\Apache Tomcat 4.0\work\Standalone\localhost\examples\jsp\process2$jsp.java:100: Method validate() not found in class foo.Login.
if (idHandler.validate()) {
^
1 error, 1 warning

anybody got a clue on how to fix this
i am runnig tomcat 4.0 on windows 2000
the login page loads up and then when i press submit, i get this error.

Excellent piece of coding. Could you post up or email me the code for retry.jsp and success.jsp plaese?

Thanks,
Niall

Excellent article
Only thing is I cant seem to see where to put the Access table ?
I know you say to register it with ODBC Data Source Administrator in the control panel which would presumably take care of this only I dont see that anywhere in the control panel, what are the options on getting around this or what do I need to do to be able to get the data source administrator?

Cheers
Justin

I am getting this error
org.apache.jasper.JasperException: /login1.jsp(4,0) SetProperty: Mandatory attribute name missing
at org.apache.jasper.compiler.DefaultErrorHandler.jspError(DefaultErrorHandler.java:94 etc etc

hi friends!!
for a very long time i was having this doubt,
how do we determine the database URL?
i was just wonderin if someone could help me!
thanks
chuk

nice to visit this website!
this is my 1st time to post msg.

i would like to ask where i put the MS ACCESS databas "registration" for the above examples?

And i want to ask how i need to configure with the datasource in the admin?

Thank you very much

For Neill Magner

friend they r just simple html/jsp pages
with the msg u want the user to read when they see the page.

did you know if you right click on the page and view source you could get the password and username...?
well just letting you know,

so what if u can see the user id and pass if u check the source code,the user
has already been authenticated.this code was never meant to be 100 percent
fool proof.it was just a simple exercide
on which further advancements can be made.
feel free to make any changed and let me know.iam a student just like u guys.

This is a great example of a password authentication System.
It looks to be secure from anyone but a hacker who can sniff passwords.
I would like to see someone add password encryption to this to make it
even more secure.

this code is nice but think if i pass the sql query as

String sql="select * from registeration where id='"+username2+"' and password='"+password2+"';
and then check if database had returned any record and we just check thatif it had returned a record then user is correct else uer is fake.

will it be fast or not
pls reply

In windows 2k it ODCB Manager is hidden unless you specificaly Enable it. It is how ever in the Adminstrative Tools called "Data Sources (OCDB)"

Or you can simply enable it in the control pannle like the rest of us.

And I got the code to work fine. Although its not what I would use, it does work. Check for Copy Paste Errors, and make sure you are saving them in the correct directories, with the correct names. You May wish to consider that when you copy some one elses code - make it work before you modify it :)

sallam:
Excellent work
i have geting a error
"method authenticate(boolean)is no found"
this error cme on both method validate()/ autheticate.
plz give the solution

Please help me..
I got this error

process2.jsp Line 4: Unable to load class "foo.Login" for useBean id "idHandler"

i am getting this message
"No method matching validate() found in class foo.login.if (idHandler.validate()) {"
^
can some body pls help me to solve the problem.I already change the "public boolean authenticate(***)" to "public boolean validate(***)" but i still getting the same error.

Hi Nouman,
I wrote my own jsp for logging in. I connect to MySQL database and verify the username and password. The problem I have is that you can manually type in the file name of the following pages in url and get to the page with out logging in.

Do you know how to implement cookies, i.e. when you enter username and password it verifies them with the database and stores a cookie, so any othere pages you try to acess it checks to ensure that you have logged in and if you have not it diverts you to the login page.

Would this be done in java script or jsp and have you implemented any thing similar before or have you an idea of how to implement it.

Thanks,
Khalass.

I am wondering how can i make connectivity of Access database from JSP

I will appreciate you help!!

MJ

How do I validate password on the client-side?

why do i have this type of error when i used this code :-

C:\Program Files\Apache Group\Tomcat 4.1\work\Standalone\localhost\examples\jsp\process2_jsp.java:62: cannot resolve symbol
symbol : method validate ()location: class foo.Login
if (idHandler.validate()) {
^

could someone plz help me

org.apache.jasper.JasperException: Unable to compile class for JSPNote: sun.tools.javac.Main has been deprecated.

why do i recieved this error. i user j2ee server, what should i do?

Goood One!!!
Only if it is understood properly..!!

please give me the code to find an authorised user from mysql database.using jsp as front end

This is a good read for beginners, although I wouldn't recommend using this method to protect anything sensitive....

Also, MS Access? I wasn't aware you could connect to Access with java unless there is some new third party driver out there somewhere I don't know about, which I would definitely like to know about, as using an Access DB would be quite convienent.

Anyway, thanks for the contribution.

Question:

The login is fine using the above method, but does it also stop people from accessing the closed pages directly?

I.e. could you go directly to success.jsp if entered the complete address in the browser or does the user have to be validated?

Thanks for comments ...

I compiled the login.java fine and apache finds the foo.login class but insists there is no method called validate. The process2.jsp file is calling the validate method from the login class file but the error says there is no such class file. I already made sure the methods were named correctly in both files. Can you help me?

Salam
I need jsp sources code to be able to connect to an Oracle Data Base
Thanks

thanks for your providing these codes,Nouman Rashid.

I have changed authenticate to validate in class, I use Linux+JSDK+RESIN+MYSQL,
=======================================
500 Servlet Exception
Note: sun.tools.javac.Main has been deprecated.
/plaza/process2.jsp:8: No method matching validate() found in class store.Login.
if (idHandler.validate()) {
^
1 error, 1 warning
--------------------------------------------------------------------------------
Resin 2.1.10 (built Wed Jun 18 09:16:53 PDT 2003)
=====================================
Joseph

why do i have this type of error when i used this code :-

C:\Program Files\Apache Group\Tomcat 4.1\work\Standalone\localhost\examples\jsp\process2_jsp.java:62: cannot resolve symbol
symbol : method validate ()location: class foo.Login
if (idHandler.validate()) {
^

Please help.....

Hi,
I am making a webpage that will end up on a free angelfire.com page and I am using Microsoft Front Page 2002 to make it. I need to have a secure page with at least 30 different user names. I am not good at JAVA, but HTML works fine for me. Is there anyway that you could help? I don't have this MS Access thing that you are talking about, at least I don't think so.

Please reply to jandtrabbits@hotmail.com

Thanks,
~Jessica

ihave used read the validate
method as authenticate or vice versa
but i got this
C:\Apache Tomcat 4.0\work\Standalone\localhost\examples\jsp\process2$jsp.java:100: No method matching validate() found in class foo.Login.
if (idHandler.validate()) {
^
1 error
plz can someone helpe me to resolve this!

The code is haphazardly thrown together, with typos, poor naming, poor spacing, variables that are defined but never used.

Hi can anybody help me..?
Is it possible to war the files together and get it to work together as a whole instead of putting the files in a foo folder and the rest in the webapps\examples\jsp folder? i am taught to put the war file in the webapps folder and restart tomcat..
Can anybody help?

Thanks

You people are amazing. You ask the same stupid questions without reading the comments! Yes, this code works in theory but he left out the coding part. Nothing is passed and the boolean authenticate takes 2 arguments (did you forget about arguments?). Meanwhile nothing is passed and you'll never get logged in anyway. Also, this is largely overkill, I can accomplish the same code in 10 lines right in my jsp page and never leave the page. Leave the beans for the farting business layer.

Generated servlet error:
[javac] Since fork is true, ignoring compiler setting.
[javac] Compiling 1 source file
[javac] Since fork is true, ignoring compiler setting.
[javac] C:\Program Files\Apache Group\Tomcat 4.1\work\Standalone\localhost\examples\jsp\LIYUAN\process2_jsp.java:62: cannot resolve symbol
[javac] symbol : method validate ()
[javac] location: class foo.Login
[javac] if (idHandler.validate()) {
[javac] ^
[javac] 1 error


i got this problem
how to change it??
i use JSP+Mysql+Tomcat

I have this error
Internal Servlet Error
C:\tomcat\work\Standalone\localhost\examples\jsp\process2$jsp.java:100: Method validate() not found in class foo.Login.
if (idHandler.validate()) {
^
1 error,
Please reply me how to correct this error

my problem is can i have the code to login with the username and password using JSP and JavaBean/Servlets from mySQL database.When the user enters the username and password in the login page then it will go to the requested site.How to do it

I have tried the above code using jsp ,jrun,mysql and getting the following error

archiving/jsp/process2.jsp:

Compilation error occured:
Found 1 errors in JSP file:
C:\\JRun\\servers\\default\\archiving\\jsp\\process2.jsp:7: Error: No match was found for method "validate()".

allaire.jrun.scripting.DefaultCFE:
Errors reported by compiler:C:/JRun/servers/default/archiving/WEB-INF/jsp/jrun__jsp__process22ejsp11.java:59:5:59:24: Error: No match was found for method "validate()".

please send the cure







where is the solution tothe above mentioned question can any body mail me the solution at abhinav@acslink.net.au

hello there i am currently suffering from the following error
Internal Servlet Error
C:\tomcat\work\Standalone\localhost\examples\jsp\process2$jsp.java:100: Method validate() not found in class foo.Login.
if (idHandler.validate()) {
^
i was wondering if any could b of assistance to me please, it is essential

If any1 manages to get past this error could u b much obliged to email me at owendodd@eircom.net

Hello
I'm getting error that said can't find folder class foo package.
Could you tell me how can I add the class foo file?
Also, if you have retry.jsp and success.jsp, could send them to me?

Thanks

Currently doing the validate now.But currently i m doing just a simple login.My problem now is i m not connectingg to the database.I just want to validate.Done this exactly the same way.Since this jsp and java is new to me it is giving me an error.My method to validate i think it is the problem.It is not returning the value.Plz help!

org.apache.jasper.JasperException: Unable to compile class for JSP

An error occurred at line: 5 in the jsp file: /process2.jsp

Generated servlet error:
[javac] Compiling 1 source file

C:\Program Files\Apache Group\Tomcat 4.1\work\Standalone\localhost\jsp\process2_jsp.java:62: cannot resolve symbol
symbol : method validate ()
location: class foo.Login
if (idHandler.validate()) {
^
1 error

_____________________________________________________________________________________

Please help me ...i got the same error as most of the people here have....somebody help me....

hi ppl can anyone show me how to verify user particulars and then retrieve everything about the user and display it out in jsp page. err will be using it on mvc model using jsp, servlet and bean. thanks.

better code:
public boolean authenticate(String username2,
String password2) {
String query="select * from Registration";
String DbUserName="";
String DbPassword="";
String finalUser="";
try {
Class.forName("sun.jdbc.odbc.JdbcOdbcDriver");
Connection
con=DriverManager.getConnection("jdbc:odbc:register");
Statement stat=con.createStatement();
///////////////////////////
query += " where UserName = '"+DbUserName+"' and password = '"+dbPassword+"'";
///////////////////////////
ResultSet rst=stat.executeQuery(query);
if (rst.next()){
return true;
}
return false;
}catch(Exception e){

e.printStackTrace();
}
}

i am getting error.


C:\Program Files\Apache Group\Tomcat 4.1\work\Standalone\localhost\jsp\process2_jsp.java:62: cannot resolve symbol
symbol : method validate ()
location: class foo.Login
if (idHandler.validate()) {
^
1 error


plzz help me fast

I'm making an eforum myself in jsp & servlets..i want email support for my members so that i can send newletters to them..can i get code to it...
Also i've a FAQ section in it where in i've various topics listed..clicking on anyone of the topic would take me to another jsp page which has faq's related to that topic & answers along with them...How do i do the database connectivity,my database is MS Access...do i need to hardcode questions & answers into the database or is there any other method..how do i display then data from my database on my jsp page.server that i'm using is Apache Tomcat 5.0..please help me fast...

Change process2.jsp to read ...

<%
// get the username and password strings passed to this page

String username = request.getParameter("username");
String password = request.getParameter("password");

// use the javabean to validate the user. If authenticated
// pass control to success.jsp
if (idHandler.authenticate(username, password))

this code will pass the username and password entered in
main.jsp to the Login javabean.

The script is too good. but I'm getting a error.






org.apache.jasper.JasperException: Unable to compile class for JSP

An error occurred at line: 6 in the jsp file: /process2.jsp
Generated servlet error:
C:\jboss-3.2.5\server\default\work\jboss.web\localhost\manish\org\apache\jsp\process2_jsp.java:61: cannot find symbol
symbol : method validate()
location: class foo.Login
if (idHandler.validate()) {
^
1 error




plz help me to find out this error.and Also, if you have retry.jsp and success.jsp, could send them to me?

THANKS

hi all,

i wat the remedy!!!!!
we can get values viewed but..
Wat should i do if i want to get values from tables(MSaccess) in to a jsp page on a select/listbox/textarea. i dont get it right.
thank u all
kindly solve me

hi,i am getting error: idHandler.validate() method not found in foo.Login. I changed the method name authenticate to validate but it didnt work.
Can you please help me?

Look at the example code provided. The idHandler method you are trying to call (validate) has to match the class method listed in the foo package (authenticate). The names don't match, do they? That is why you are getting the "method not found" error. Either change your code in process2.jsp from "if (idHandler.validate())" to "if (idHandler.authenticate())" or change the code in Login.java from "public boolean authenticate(String username2, String password2)" to "public boolean validate(String username2, String password2)" and recompile. You will need to make some small, addtional modifications to the code to get things to work, but the framework for login validation using this method is sound.

hi jsp_dude,
i made the changes but still i am getting error. my database is in MSAccess. plz reply in sidd_bhushan@indiatimes.com

I have the validate method in the Login.java file, so I am not getting "cannot find symbol" eror message, but instead i am getting this " authenticate in foo.Login cannot be applied to () if(idHandler.authenticate() ) ) { "

can someone please shed light on this...as I need to use this urgently...

thanks alot!!!

regards
java_jspman