Go4Expert - JSP with MS-Access

Go4Expert (http://www.go4expert.com/)

- JSP (http://www.go4expert.com/forumdisplay.php?f=28)

- - JSP with MS-Access (http://www.go4expert.com/showthread.php?t=1370)

JSP with MS-Access

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

Re: JSP with MS-Access

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(); 
     } 
 } 
 %>