MS Access Database problem - No data found [Resolved]

[nebulom]

Should be something like this.

import java.sql.*;
 
public class test{
    public static void main(String[] args){
        Connection cn=null;
        try{
            Class.forName("sun.jdbc.odbc.JdbcOdbcDriver");
            cn=DriverManager.getConnection("jdbc:[b][/b]odbc:test","","");
        }
        catch(Exception ex){
            System.out.println(ex.getMessage());
        }
 
        employee e=new employee(cn);
        System.out.println(e.count());
        e.displayEmployees();
    }
}
 
class employee{
    Connection cn;
    public employee(Connection cn){
        this.cn=cn;
    }
 
    public void displayEmployees(){
        try{
            Statement s=cn.createStatement();
            ResultSet rs=s.executeQuery("select * from emp");
            while(rs.next()){
                System.out.println(rs.getString(1));
                System.out.println(rs.getString(2));
                System.out.println(rs.getDate(3)+"\n");
            }
        }
        catch(Exception ex){
            System.out.println(ex.getMessage());
        }
    }
 
    public int count(){
        int n=0;
        try{
            Statement s=cn.createStatement();
            ResultSet rs=s.executeQuery("select count(*) from emp");
            rs.next();
            n=Integer.parseInt(rs.getString(1).toString());
        }
        catch(Exception ex){
            System.out.println(ex.getMessage());
        }
        return n;
    }
}