Java MySQL API that populates results as per structure defined with a class

Question

I've seen something to this effect in the past but I failed to find how I would do this so I will give pseudocode to demonstrate something I remember seeing this.

Table entries would be defined with a class, something to the following effect.

class Person {
    @ (an annotation that specified what SQL type to use for below field)
    String name;
    @ ...
    int age;
}

One would make SQL calls but the

Person[] persons = sqlconn.select("SELECT * FROM table_name", Person.class)

or something to this effect.

Not exactly prepare statements because these calls populate the objects.

i think you are looking for JPA and NativeQueries

quartzde
– quartzde

2012-10-29 17:04:11 +00:00
Commented Oct 29, 2012 at 17:04 — quartzde
– quartzde, Commented Oct 29, 2012 at 17:04

Community · Accepted Answer · 2017-05-23 12:12:23Z

3

Hibernate will do this for you, but it has a fairly steep learning curve.

There are other JPA implementations to consider, some of which are explored here.

A simple alternative is to use Spring's jdbcTemplate as detailed here.

edited May 23, 2017 at 12:12

CommunityBot

11 silver badge

answered Dec 2, 2012 at 1:20

cmbaron

2481 silver badge9 bronze badges

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

Collectives™ on Stack Overflow

Java MySQL API that populates results as per structure defined with a class

1 Answer 1

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

Comments

Your Answer

Sign up or log in

Post as a guest

Related