This VO provides an example of how LookupVO can be used. When you create your new VO ensure that it extends from com.oaframework.toolkit.poplist.server.LookupVO. Your VO will then inherit the three Attributes:
You will need to ensure that your SQL selects a value for each of these Attributes and provides corresponding column aliases. For the VO's Java, extend the VOImpl from com.oaframework.toolkit.poplist.server.LookupVOImpl and the VORowImpl from com.oaframework.toolkit.poplist.server.LookupVORowImpl and select to not generate Java classes.
Wiki: TkPoplistAMImpl
Wiki: com.oaframework.toolkit.common.poplist