private  JdbcRowSetXImpl getDataSource()
    {
         try 
        {
             Class .forName(DRIVER_CLASS).newInstance();
            JdbcRowSetXImpl jrs =  new  JdbcRowSetXImpl();
            jrs.setCommand("SELECT TOP 10 * FROM tblGuest ORDER BY date DESC;");
            jrs.setUrl(DB_HOST);        
            jrs.setUsername(DB_USER);
            jrs.setPassword(DB_PASSWORD);
            jrs.execute();
             return  jrs;        
        }
         catch (Exception e)
        {
             return   null ;
        }
    }     

    public  getData  throws  SQLException(){
      try {
          Class .forName(DRIVER_CLASS);
         Connection con = DriverManager.getConnection(DB_HOST, DB_USER, DB_PASSWORD);
	 Statement statement = con.createStatement();
         String sql ="SELECT * FROM Customers";
         ResultSet rs = statement.executeQuery(sql);
          while  (rs.next()) {
         Customer customer =  new  Customer(); 
         customer.id = rs.getInt( 1 ); 
         customer.name = rs.getString( 2 ); 
            } 
      rs.close(); 
      statement.close(); 
      con.close(); 
          
             } catch (SQLException se){
                 System.out.println("error");
                 }
  }