Spring Boot - Why Use a Domain Model with JDBC Templates?
up vote
0
down vote
favorite
I'm figuring out my simple MySQL schema implementation for my front end and made the decision to use JDBC Templates since I love doing as much "thinking" as I can directly in SQL, however I'm seeing that most JDBC Template implementations wind up creating their own object-entity model anyway (similar to JPA/Hibernate).
I simply want to output my tables on my front end and be able to insert/update/delete. Is their no way to avoid mapping my entities to objects, no matter which implementation I choose? Although my model is simple, I have 15+ tables and mapping them all to objects seems a bit redundant if all I want to do is display tables in HTML and do basic CRUD.
java mysql sql spring-mvc spring-boot
asked Nov 21 at 19:42
Leo Scarano
367
add a comment |
up vote
0
down vote
favorite
I'm figuring out my simple MySQL schema implementation for my front end and made the decision to use JDBC Templates since I love doing as much "thinking" as I can directly in SQL, however I'm seeing that most JDBC Template implementations wind up creating their own object-entity model anyway (similar to JPA/Hibernate).
I simply want to output my tables on my front end and be able to insert/update/delete. Is their no way to avoid mapping my entities to objects, no matter which implementation I choose? Although my model is simple, I have 15+ tables and mapping them all to objects seems a bit redundant if all I want to do is display tables in HTML and do basic CRUD.
java mysql sql spring-mvc spring-boot
asked Nov 21 at 19:42
Leo Scarano
367
1
Have you ever had a look at jOOQ: docs.spring.io/spring-boot/docs/current/reference/html/… this would exactly fit you requirements.
– Simon Martinelli
Nov 21 at 19:45
@SimonMartinelli This looks very promising. I had no idea this existed. I'm going to take a look at this now.
– Leo Scarano
Nov 21 at 19:50
@SimonMartinelli It seems I have to re-create the structure of my db in order to generate the java code. I made so many changes in mysql workbench, so my schema is drastically different from when I started typing commands. I was hoping for it to just take my schema and generate the class structure but I'll just suck it up and create the class structure.
– Leo Scarano
Nov 21 at 22:01
add a comment |
up vote
0
down vote
favorite
up vote
0
down vote
favorite
I'm figuring out my simple MySQL schema implementation for my front end and made the decision to use JDBC Templates since I love doing as much "thinking" as I can directly in SQL, however I'm seeing that most JDBC Template implementations wind up creating their own object-entity model anyway (similar to JPA/Hibernate).
I simply want to output my tables on my front end and be able to insert/update/delete. Is their no way to avoid mapping my entities to objects, no matter which implementation I choose? Although my model is simple, I have 15+ tables and mapping them all to objects seems a bit redundant if all I want to do is display tables in HTML and do basic CRUD.
java mysql sql spring-mvc spring-boot
asked Nov 21 at 19:42
Leo Scarano
367
I'm figuring out my simple MySQL schema implementation for my front end and made the decision to use JDBC Templates since I love doing as much "thinking" as I can directly in SQL, however I'm seeing that most JDBC Template implementations wind up creating their own object-entity model anyway (similar to JPA/Hibernate).
I simply want to output my tables on my front end and be able to insert/update/delete. Is their no way to avoid mapping my entities to objects, no matter which implementation I choose? Although my model is simple, I have 15+ tables and mapping them all to objects seems a bit redundant if all I want to do is display tables in HTML and do basic CRUD.
java mysql sql spring-mvc spring-boot
java mysql sql spring-mvc spring-boot
asked Nov 21 at 19:42
Leo Scarano
367
asked Nov 21 at 19:42
Leo Scarano
367
asked Nov 21 at 19:42
Leo Scarano
367
asked Nov 21 at 19:42
Leo Scarano
367
asked Nov 21 at 19:42
Leo Scarano
367
367
1
Have you ever had a look at jOOQ: docs.spring.io/spring-boot/docs/current/reference/html/… this would exactly fit you requirements.
– Simon Martinelli
Nov 21 at 19:45
@SimonMartinelli This looks very promising. I had no idea this existed. I'm going to take a look at this now.
– Leo Scarano
Nov 21 at 19:50
@SimonMartinelli It seems I have to re-create the structure of my db in order to generate the java code. I made so many changes in mysql workbench, so my schema is drastically different from when I started typing commands. I was hoping for it to just take my schema and generate the class structure but I'll just suck it up and create the class structure.
– Leo Scarano
Nov 21 at 22:01
add a comment |
1
Have you ever had a look at jOOQ: docs.spring.io/spring-boot/docs/current/reference/html/… this would exactly fit you requirements.
– Simon Martinelli
Nov 21 at 19:45
@SimonMartinelli This looks very promising. I had no idea this existed. I'm going to take a look at this now.
– Leo Scarano
Nov 21 at 19:50
@SimonMartinelli It seems I have to re-create the structure of my db in order to generate the java code. I made so many changes in mysql workbench, so my schema is drastically different from when I started typing commands. I was hoping for it to just take my schema and generate the class structure but I'll just suck it up and create the class structure.
– Leo Scarano
Nov 21 at 22:01
1
1
Have you ever had a look at jOOQ: docs.spring.io/spring-boot/docs/current/reference/html/… this would exactly fit you requirements.
– Simon Martinelli
Nov 21 at 19:45
Have you ever had a look at jOOQ: docs.spring.io/spring-boot/docs/current/reference/html/… this would exactly fit you requirements.
– Simon Martinelli
Nov 21 at 19:45
@SimonMartinelli This looks very promising. I had no idea this existed. I'm going to take a look at this now.
– Leo Scarano
Nov 21 at 19:50
@SimonMartinelli This looks very promising. I had no idea this existed. I'm going to take a look at this now.
– Leo Scarano
Nov 21 at 19:50
@SimonMartinelli It seems I have to re-create the structure of my db in order to generate the java code. I made so many changes in mysql workbench, so my schema is drastically different from when I started typing commands. I was hoping for it to just take my schema and generate the class structure but I'll just suck it up and create the class structure.
– Leo Scarano
Nov 21 at 22:01
@SimonMartinelli It seems I have to re-create the structure of my db in order to generate the java code. I made so many changes in mysql workbench, so my schema is drastically different from when I started typing commands. I was hoping for it to just take my schema and generate the class structure but I'll just suck it up and create the class structure.
– Leo Scarano
Nov 21 at 22:01
add a comment |
active
oldest
votes
active
oldest
votes
active
oldest
votes
active
oldest
votes
active
oldest
votes
Thanks for contributing an answer to Stack Overflow!
- Please be sure to answer the question. Provide details and share your research!
But avoid …
- Asking for help, clarification, or responding to other answers.
- Making statements based on opinion; back them up with references or personal experience.
To learn more, see our tips on writing great answers.
Some of your past answers have not been well-received, and you're in danger of being blocked from answering.
Please pay close attention to the following guidance:
- Please be sure to answer the question. Provide details and share your research!
But avoid …
- Asking for help, clarification, or responding to other answers.
- Making statements based on opinion; back them up with references or personal experience.
To learn more, see our tips on writing great answers.
Sign up or log in
StackExchange.ready(function () {
StackExchange.helpers.onClickDraftSave('#login-link');
});
Sign up using Google
Sign up using Facebook
Sign up using Email and Password
Post as a guest
Required, but never shown
StackExchange.ready(
function () {
StackExchange.openid.initPostLogin('.new-post-login', 'https%3a%2f%2fstackoverflow.com%2fquestions%2f53419456%2fspring-boot-why-use-a-domain-model-with-jdbc-templates%23new-answer', 'question_page');
}
);
Post as a guest
Required, but never shown
Sign up or log in
StackExchange.ready(function () {
StackExchange.helpers.onClickDraftSave('#login-link');
});
Sign up using Google
Sign up using Facebook
Sign up using Email and Password
Post as a guest
Required, but never shown
Sign up or log in
StackExchange.ready(function () {
StackExchange.helpers.onClickDraftSave('#login-link');
});
Sign up using Google
Sign up using Facebook
Sign up using Email and Password
Post as a guest
Required, but never shown
Sign up or log in
StackExchange.ready(function () {
StackExchange.helpers.onClickDraftSave('#login-link');
});
Sign up using Google
Sign up using Facebook
Sign up using Email and Password
Sign up using Google
Sign up using Facebook
Sign up using Email and Password
Post as a guest
Required, but never shown
Required, but never shown
Required, but never shown
Required, but never shown
Required, but never shown
Required, but never shown
Required, but never shown
Required, but never shown
Required, but never shown
1
Have you ever had a look at jOOQ: docs.spring.io/spring-boot/docs/current/reference/html/… this would exactly fit you requirements.
– Simon Martinelli
Nov 21 at 19:45
@SimonMartinelli This looks very promising. I had no idea this existed. I'm going to take a look at this now.
– Leo Scarano
Nov 21 at 19:50
@SimonMartinelli It seems I have to re-create the structure of my db in order to generate the java code. I made so many changes in mysql workbench, so my schema is drastically different from when I started typing commands. I was hoping for it to just take my schema and generate the class structure but I'll just suck it up and create the class structure.
– Leo Scarano
Nov 21 at 22:01