how to connect to MS-Access from jsp

[Venkatesh Manohar]

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]

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]

You can make use of JDBC for this purpose. Following is a sample code:

  
import java.sql.*;
import java.io.*;
public class Example{
Class.forName("The driver for your database goes here");
Connection con=DriverManager.getConnection("URL of your db/name of your db");
Statement st=con.createStatement("your SQL statement here");
 ResultSet rs=st.executeQuery() or executeUpdate();
 
}
 
  

Hope you got an idea.

[Venkatesh Manohar]

Thank You.