How do I populate database values into an existing object model?

Question

I have a model instance already, it's a basic POJO, how can I populate it (by issuing a SELECT) with the values using dbutils by calling the setters which are named to match the table column names?

So BasicRowProcessor should match, I just don't find the appropiate class/method to call with the object as parameter.

There is only one instance I want to set, not an array.

score 1 · Accepted Answer · answered Jan 15 '12 at 15:00

1

I'm not sure I understand your question. Some source code would help.

There are lots of libraries that perform ORM. See source forge for some ORM projects. One of them is sormula which I created. For the simplest use of it, see POJO zero-config example.

answered Jan 15 '12 at 15:00

Jeff Miller

1,424
1
10
19

I was looking for something like (to the example you've linked) `inventoryTable.selectInto(partNumber, inventory);` - inventory being the already existing POJO, I want to just populate it with data. – Flavius Jan 16 '12 at 19:38

score 0 · Answer 2 · answered Jan 13 '12 at 16:04

All you can do is

YourObject result = new BasicRowProcessor().toBean(yourResultSet,YourObject.class);

It will create the instance though. This API is not designed to allow you to modify an already existing object.

If you really need to update the existing object you might implement a YourObject.copy(YourObject obj) method and call it with the result from BasicRowProcessor.toBean but it looks quite ugly.

An other (also ugly) solution would be to implement the BeanProcessor class, implement the BeanProcessor.newInstance(Class) method to return your object, then pass your implementation instance to the BasicRowProcessor instance.

Are there any other alternative libraries which DO allow me to do this? — Flavius, Jan 13 '12 at 16:15

How do I populate database values into an existing object model?

2 Answers2