Win a copy of Murach's Python Programming this week in the Jython/Python forum!
  • Post Reply Bookmark Topic Watch Topic
  • New Topic

very urgent idea needed  RSS feed

 
vivek sivakumar
Ranch Hand
Posts: 187
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator
well i want ti do a demo jsp page which can connect to "Microsoft Access ". This page is a simple user authentication page where i have a username and password . In microsoft access i have a table with "username" and password and each having a valid user value and i want to authenticate that is through my jsp page , only if user enters correct name and password he should be taken to next page. how can i do it ?? i found examples only with sql but how can i do it with microsoft access. pls advice.
 
Dave Vick
Ranch Hand
Posts: 3244
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator
vivek
You'll need to change the driver to be the jdbcodbc bridge and the connection url to be the access database you're using. After that the SQL query should be the same, something like:
SELECT * FROM users WHERE username='username' AND password='password'. Then just test to see if you get a result set back from the query.
If you get stuck, post the code you've got and let us know exactly where you are stuck.
hope that helps
 
vivek sivakumar
Ranch Hand
Posts: 187
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator
What do u mean by connection url (is it just the data base name or what ???
 
  • Post Reply Bookmark Topic Watch Topic
  • New Topic
Boost this thread!