java - map database tables into class

Question

When retrieving data from the database in Java, how can I get a instance of an class for each database row dynamically?

Example: I've got two tables (Table1: id, name, Table2: id, name, age) and two classes with the same properties. For every row in Table1 I want an List-item (or something related) for this row.

Is there a class/default method to do this in Java?

Use Hibernate. What you're looking for is an ORM.

christopher
– christopher

2014-05-07 09:14:19 +00:00
Commented May 7, 2014 at 9:14 — christopher
– christopher, Commented May 7, 2014 at 9:14

Community · Accepted Answer · 2017-05-23 10:26:08Z

2

While you could implement your own mapper, Hibernate (and the other JPA implementations) will solve your problem quite thoroughly out of the box. If properly configured, loading records from Table1 will automatically materialise your @OneToMany relationship with Table2

edited May 23, 2017 at 10:26

CommunityBot

11 silver badge

answered May 7, 2014 at 9:18

Lukas Eder

223k138 gold badges731 silver badges1.6k bronze badges

Sign up to request clarification or add additional context in comments.

Comments

Rupesh · Accepted Answer · 2014-05-07 09:21:56Z

0

you can use Hibernate or study droidpersistence library's source, (the lib is written for android though)

answered May 7, 2014 at 9:21

Rupesh

3,5053 gold badges28 silver badges30 bronze badges

Comments

BetaRide · Accepted Answer · 2014-05-07 09:24:12Z

0

Use JPA. A popular implementation of JPA is Hibernate. There are plenty of tutorials to get you started.

answered May 7, 2014 at 9:24

BetaRide

16.9k32 gold badges108 silver badges192 bronze badges

Collectives™ on Stack Overflow

java - map database tables into class

3 Answers 3

Comments

Comments

Comments

Your Answer

Linked

Hot Network Questions

Collectives™ on Stack Overflow

3 Answers 3

Comments

Comments

Comments

Your Answer

Sign up or log in

Post as a guest

Linked

Related