package Glaz.Test2;

import java.io.File;
import com.db4o.*;
import com.db4o.query.Query;


public class Test2 {

    public static final String db_file="test.db4o";
   
    public static void main(String[] args) {
        ObjectContainer db=null;
        ObjectServer server=null;
       try{
       File file=new File(db_file);
       file.delete();
       server=Db4o.openServer(db_file,1080);
       server.grantAccess("SA","");
       db=Db4o.openClient("127.0.0.1",1080,"SA" ,"");
       runTest(db);
      
          
       }catch(Exception e){e.printStackTrace();}finally{
           if(db!=null)
            db.close();
           if(server!=null)
           server.close();
       }
    }
   
    public static void runTest(ObjectContainer db)throws Exception{
       
           Pilot pilot=null;
          
          
           pilot=new Pilot("Alexandr",30,5);
           db.set(pilot);
           
           pilot=new Pilot("Cris",30,5);
           db.set(pilot);
          
           pilot=new Pilot("Boris",30,5);
           db.set(pilot);

          
           pilot=new Pilot("Helen",25,5);
           db.set(pilot);

           pilot=new Pilot("Zeus",25,3);
           db.set(pilot);
          
           pilot=new Pilot("Alexsandra",25,3);
           db.set(pilot);
           
           pilot=new Pilot("Liza",25,4);
           db.set(pilot);
          
           pilot=new Pilot("Bred",25,4);
           db.set(pilot);
          
           pilot=new Pilot("Gregory",25,4);
           db.set(pilot);
                      
           db.commit();
          
           Query query=db.query();
           query.constrain(Pilot.class);
           query.descend("seniority").orderAscending();
           query.descend("age").orderAscending();
           query.descend("name").orderAscending();
                     
           ObjectSet result=query.execute();
           System.out.println("seniority age name");
               while(result.hasNext()){
                pilot=(Pilot)result.next();
                System.out.println(pilot.seniority+" "+pilot.age+" "+pilot.name);
             }
       
    }
}

//****************************************************************************************************

package Glaz.Test2;

public class Pilot {
 public String name;
 public int seniority;
 public int age;
 public Pilot(String name,int age, int seniority){
  this.name=name;
  this.age=age;
  this.seniority=seniority;
 }

   
}
//**********************************************************************************************

System.out:

seniority age name
3 25 Zeus
3 25 Alexsandra
4 25 Liza
4 25 Gregory
4 25 Bred
5 25 Helen
5 30 Cris
5 30 Boris
5 30 Alexandr

//********************************************************************