Remote DB connection in jsp

<%

Connection con1=DriverManager.getConnection("jdbc:odbc:DRIVER={Microsoft Access Driver (*.mdb)};DBQ="+dbPath1+";",username1,password1);////Establishing Connection with database

Class.forName(DB);//loading driver

String queryD = "delete from user where username='"+request.getParameter("id")+"'";

String query = "select * from user";

Statement stm1 = con1.createStatement();

stm1.execute(queryD);

PreparedStatement pstmt = con1.prepareStatement(query);//fire a query

System.out.println("..."+query);

ResultSet rs = pstmt.executeQuery();

%.

Message was edited by:

3biren

3birena at 2007-7-12 15:17:48 >