Hello , To get to know the concept can anyone answer my questions in detail along with an example.
first step: Have to create a Loginpage.jsp in JSP with LOGIN id and Password. second step: I am using MS Access as my present database which stores name and password. Third step: Please explain to me how connection is made between Access and My Loginpage.jsp and what needs to be done in control panel(i donno that too).
Fourth step: This loginpage.jsp shld validate user id and password and if they are correct shld , send it to the next page through session. [ September 16, 2008: Message edited by: Bear Bibeault ]
i )In order to use the MS Access DB, you need to add a Data Source through Ctrl Panel-> Administrative Tools -> Data Sources(ODBC). ii)Under User DSN, click on Add, select the driver ( in your case, it would be Microsoft Access Driver(*.mdb). iii) Click on Finish iv) Provide DataSource name on next screen. v) Then under Database: click Create and create the DB somewhere on your local system. vi) For setting password to the DB, click on Advanced button and provide the user name and password. Click on Finish and you should be all set.
The url for accessing would be String url = "jdbc:odbc:DataSourceNameYouProvided";
For Step 1, you can a lot of example pages and code in google.