JSP with MS-Access

casimirrex's Avatar, Join Date: Sep 2006
Newbie Member
Hi
In JSP client validation i've included the Javascript ,but it is not working any one bear my hand to me and the any tell me How to connect to JSP with MS-access
pls give with an example
thanks in advance
regards
rex
0
pradeep's Avatar, Join Date: Apr 2005
Team Leader
The example below demonstrates how to connect to MS Access DB using JSP.

Code: JSP
<%@page import ="java.io.*"%>
 <%@page import ="javax.servlet.*"%>
 <%@page import ="javax.servlet.http.*"%>
 <%@page import ="java.sql.*"%>
 <%!
 Connection conn=null;
 Statement st;
 ResultSet rs;
 String login,password;
 String pass,logg;
 String sql;
 String database = "e:\trashmagic\login.mdb";
 String url = "jdbc:odbc:Driver={Microsoft Access Driver (*.mdb)};DBQ=" + database + ";DriverID=22;READONLY=false"; public void jspInit()
 {
     try
     {
         Class.forName("sun.jdbc.odbc.JdbcOdbcDriver");
         conn = DriverManager.getConnection(url);
     }
     catch(Exception ex)
     {
         ex.printStackTrace();
     }
 }
 %>