Can anyone tell me whats involved with this question?
I have a mysql database running on localhost containing the employee table. I understand there will be an if statement creating a redirect but whats involved in connecting to the database, searching for the username / password and verifying.
Create a servlet that will check a user name and password entered
into Logon Web Page for the Food Traders web site. If the user
name and password exist in the employees table, direct the user to
a Welcome page displaying the userís full name. The welcome page
should be a Java Server Page
If the user name and password does not exist in the employees
table, direct the user back to the logon page.
Im familiar with basic Java but SQL with Java is new to me. So far i have a HTML login page that posts to a loginservlet.java
Update : Ive connected to the database through Netbeans test with says connection successful.
I have wrote a separate class called MySQLConnection and im not sure what to do next.
Possibly create a method to query the database for the username and password verification?