Java criteria for setting and getting

Question

I am setting up criteria for database calls and am having trouble getting understanding how to set up my code. I have put my criteria in and now need to know how I make sure I populate the variables right. This is what I have.

Public class Key extends abstractDAO<key>{
Public List<Key> getKeyValues(){
Criteria c = createCriteria();
c.add(Restrictions.lt("id", 3)).addOrder(Order.asc("id")).list();
return c.list();

Now the table has 2 rows. One is current and the second is a new request row. The database has 3 columns. Column 1 is the I'd, column two is the key, and 3 is a timestamp. I need to populate all the variables in order. I am not sure how to go about this in my key.java file

Key.java

@column(name="id")
private int actualID;

@column(name="key")
private Boolean actualKey;

@column (name="actualTime")
private Date actualTime;

Then repeats with requested, requestKey, and requestTime. Then I have public get and sets for each. Have not added any parameters to any method yet either. I am not sure how to set this file up so the list actually sets the variables when the DAO request the rows of the database.

Answer 1

try the following:

public List<Key> getKeyValues()
{
    return createCriteria()
        .add( Restrictions.lt( "actualID", 3 ) )
        .addOrder( Order.asc( "actualID" ) )
        .list();
}

Provided that the rest of the mapping and the implementation of createCriteria() are correct, it should return a list of Key's objects whose ids are less than 3, ordered by id.