public class Person {
private int id;
private String name;
private int age;
// Getters and setters...
@Override
public String toString() {
return "Person [id=" + id + ", name=" + name + ", age=" + age + "]";
}
}
<?xml version="1.0" encoding="UTF-8"?>
<!DOCTYPE ojb SYSTEM "http://db.apache.org/ojb/dtds/repository.dtd">
<ojb>
<jdbc-connection-descriptor
jcd-alias="testDb"
jcd-driver="org.hsqldb.jdbcDriver"
jcd-url="jdbc:hsqldb:mem:testdb"
jcd-username="sa"
jcd-password="">
</jdbc-connection-descriptor>
<class-descriptor
class="com.example.Person"
table="person">
<field-descriptor
name="id"
column="id"
primarykey="true"/>
<field-descriptor
name="name"
column="name"/>
<field-descriptor
name="age"
column="age"/>
</class-descriptor>
</ojb>
import org.apache.ojb.broker.PersistenceBroker;
import org.apache.ojb.broker.PersistenceBrokerFactory;
import org.apache.ojb.broker.query.Criteria;
import org.apache.ojb.broker.query.Query;
import org.apache.ojb.broker.query.QueryByCriteria;
public class Test {
public static void main(String[] args) {
PersistenceBroker broker = PersistenceBrokerFactory.defaultPersistenceBroker();
Criteria criteria = new Criteria();
criteria.addEqualTo("name", "Alice");
Query query = new QueryByCriteria(Person.class, criteria);
Person person = (Person) broker.getObjectByQuery(query);
System.out.println(person);
broker.close();
}
}
