Win a copy of The Java Performance Companion this week in the Performance forum!
  • Post Reply
  • Bookmark Topic Watch Topic
  • New Topic

how to connect to MS-Access from jsp

 
Venkatesh Manohar
Greenhorn
Posts: 12
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator
I have created a table named login which is in c:/db1 using MS-Access.It has two fields username and password.i want to know how make connection to this tabl from jsp.
 
Ulf Dittmer
Rancher
Posts: 42968
73
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator
Welcome to JavaRanch.

Do you have experience with JDBC (the Java database access API)? If not, start with the Sun JDBC tutorial.

To make a Connection to Access, you;d use the JDBC/ODBC bridge driver; it's described here.

Lastly, it's generally considered bad design to do any DB stuff directly in a JSP. Consider using a servlet or a backing bean instead.
 
Rao Raghu
Ranch Hand
Posts: 100
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator
You can make use of JDBC for this purpose. Following is a sample code:


Hope you got an idea.
 
Venkatesh Manohar
Greenhorn
Posts: 12
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator
Thank You.
 
  • Post Reply
  • Bookmark Topic Watch Topic
  • New Topic