Hi,

I have 2 tables in my database,

Shop Product
id id
name name
shop_id

I have this information in a text file, I am able to parse text file and get column and values from it.
When I parse product file, I need to automatically insert entry in shop table also with given shop_id.

I can think of solution that populate pojo's with these column and value information, but I dont know how to get the setter from column name.

any help is appreciated, if someone can give any other efficient solution that will be really helpful.