I am experiencing problems in displaying specific details from a Microsoft Access Database to my JSP page.

What kinda codes shld i put in to display them specificly in to my JSP page....

i have seen many sample coding... for example like this :

import java.io.*;
import java.sql.*;

public class TableCols {
public static void main(String [] args) {

Connection con;
Statement stt;
ResultSet rs;
ResultSetMetaData rsmd;
int cols;
try {

Class.forName("sun.jdbc.odbc.JdbcOdbcDriver").newI nstance();
try {
conStud = DriverManager.getConnection("YourDataSource", "YourID", "YourPass");
} catch (Exception ex) {throw new Exception(ex.getMessage());}

stt = con.createStatement();

rs = stt.executeQuery("select * from YourTable");

rsmd = rs.getMetaData();
cols = rsmd.getColumnCount();

for(int i=1; i<cols; i++)


catch (ClassNotFoundException ex) {
System.out.println("CNFE : "+ex.getMessage());
catch (SQLException ex) {
System.out.println("SQL : "+ex.getMessage());
catch (Exception ex) {
System.out.println("Exception : "+ex.getMessage());


How does i retrieve individual information of user from the MS access database when he/she log into the web? (individually) instead of showing all the information.

pls kindly help thanks