import java.io.IOException;
import java.io.InputStream;
import java.util.Collection;
import java.util.Iterator;
import java.util.Properties;

import javax.jdo.Extent;
import javax.jdo.JDOHelper;
import javax.jdo.PersistenceManager;
import javax.jdo.PersistenceManagerFactory;
import javax.jdo.Query;

import de.jeckle.jdotest.Employee;
public class JDOQuery {
	public static void main(String args[]) {
		Properties props = new Properties();
		try {
			InputStream is =
				ClassLoader.getSystemResourceAsStream("jdo.properties");
			props.load(is);
		} catch (IOException ioe) {
			System.out.println("Error loading properties");
			System.exit(1);
		}
		PersistenceManagerFactory pmf =
			JDOHelper.getPersistenceManagerFactory(props);
		PersistenceManager pm = pmf.getPersistenceManager();
	
		Extent ext = pm.getExtent(Employee.class, false);
		String filter = "department == \"B042\"";
		Query qry = pm.newQuery(ext, filter);
		qry.setOrdering("name ascending");
		qry.compile();
		Collection c = (Collection) qry.execute();

		Iterator i = c.iterator();
		while (i.hasNext()) {
			System.out.println(i.next());
		}
	}

}