Spring Boot - Why Use a Domain Model with JDBC Templates?
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 '18 at 19:42
Leo ScaranoLeo Scarano
398
add a comment |
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 '18 at 19:42
Leo ScaranoLeo Scarano
398
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 '18 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 '18 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 '18 at 22:01
add a comment |
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 '18 at 19:42
Leo ScaranoLeo Scarano
398
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 '18 at 19:42
Leo ScaranoLeo Scarano
398
asked Nov 21 '18 at 19:42
Leo ScaranoLeo Scarano
398
asked Nov 21 '18 at 19:42
Leo ScaranoLeo Scarano
398
asked Nov 21 '18 at 19:42
Leo ScaranoLeo Scarano
398
asked Nov 21 '18 at 19:42
Leo ScaranoLeo Scarano
398
398
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 '18 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 '18 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 '18 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 '18 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 '18 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 '18 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 '18 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 '18 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 '18 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 '18 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 '18 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 '18 at 22:01
add a comment |
0
active
oldest
votes
Your Answer
StackExchange.ifUsing("editor", function () {
StackExchange.using("externalEditor", function () {
StackExchange.using("snippets", function () {
StackExchange.snippets.init();
});
});
}, "code-snippets");
StackExchange.ready(function() {
var channelOptions = {
tags: "".split(" "),
id: "1"
};
initTagRenderer("".split(" "), "".split(" "), channelOptions);
StackExchange.using("externalEditor", function() {
// Have to fire editor after snippets, if snippets enabled
if (StackExchange.settings.snippets.snippetsEnabled) {
StackExchange.using("snippets", function() {
createEditor();
});
}
else {
createEditor();
}
});
function createEditor() {
StackExchange.prepareEditor({
heartbeatType: 'answer',
autoActivateHeartbeat: false,
convertImagesToLinks: true,
noModals: true,
showLowRepImageUploadWarning: true,
reputationToPostImages: 10,
bindNavPrevention: true,
postfix: "",
imageUploader: {
brandingHtml: "Powered by u003ca class="icon-imgur-white" href="https://imgur.com/"u003eu003c/au003e",
contentPolicyHtml: "User contributions licensed under u003ca href="https://creativecommons.org/licenses/by-sa/3.0/"u003ecc by-sa 3.0 with attribution requiredu003c/au003e u003ca href="https://stackoverflow.com/legal/content-policy"u003e(content policy)u003c/au003e",
allowUrls: true
},
onDemand: true,
discardSelector: ".discard-answer"
,immediatelyShowMarkdownHelp:true
});
}
});
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
0
active
oldest
votes
0
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 '18 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 '18 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 '18 at 22:01