Mixing
How to save Selected Radio Button out of Toggle group to MySQL Database JavaFx
I need to save the user's selected gender out of a gender Toggle group with the options 'M' and 'F' to a localhost phpmyadmin database. I have created the Radio Buttons in Scenebuilder, but the Sql commands to retrieve the user's selected Radiobutton are not working.
I've tried using the .getSelectedToggle() method to retrieve the user's choice from the toggle group, but it isn't working. The entire run fails because of this problem.
PreparedStatement ps = con.prepareStatement("insert into"
+ "alumni(aFirstName,aLastName,aGender,aBirthDate,aGradYear,aIndustry,"
+ "aProfession,aEmail,aLiveInGhana,aMailAddress)"
+ "values('"+firstName.getText()+"','"+lastName.getText()+
"','"+gender.getSelectedToggle()+"','"+
"','"+birthdate.getValue()+"','"+
"','"+gradyear.getValue()+"','" +industry.getText()+
"','"+profession.getText()+"','"+email.getText()+
"','"+liveInGh.g()+"','"+mailAdd.getText()+"')");
When the user saves their information, the selected toggle from toggle group 'gender' should be saved to the 'aGender' field in the alumni table.
java mysql javafx phpmyadmin radio-button
asked Jan 1 at 23:48
Anthea TawiahAnthea Tawiah
1
add a comment |
I need to save the user's selected gender out of a gender Toggle group with the options 'M' and 'F' to a localhost phpmyadmin database. I have created the Radio Buttons in Scenebuilder, but the Sql commands to retrieve the user's selected Radiobutton are not working.
I've tried using the .getSelectedToggle() method to retrieve the user's choice from the toggle group, but it isn't working. The entire run fails because of this problem.
PreparedStatement ps = con.prepareStatement("insert into"
+ "alumni(aFirstName,aLastName,aGender,aBirthDate,aGradYear,aIndustry,"
+ "aProfession,aEmail,aLiveInGhana,aMailAddress)"
+ "values('"+firstName.getText()+"','"+lastName.getText()+
"','"+gender.getSelectedToggle()+"','"+
"','"+birthdate.getValue()+"','"+
"','"+gradyear.getValue()+"','" +industry.getText()+
"','"+profession.getText()+"','"+email.getText()+
"','"+liveInGh.g()+"','"+mailAdd.getText()+"')");
When the user saves their information, the selected toggle from toggle group 'gender' should be saved to the 'aGender' field in the alumni table.
java mysql javafx phpmyadmin radio-button
asked Jan 1 at 23:48
Anthea TawiahAnthea Tawiah
1
2
You're usingPreparedStatementbut are still concatenating the parameters into the SQL. You should put placeholders (?) in the SQL query, such asselect * from users where id = ?. You then call the appropriatesetXXXmethods on thePreparedStatementto set the parameters. See Using Prepared Statements.
– Slaw
Jan 2 at 0:02
try to provide the code creating the toggle group and the error message so we can define the problem if you are using scene builder provide the fxml code
– Ahmed Emad
Jan 2 at 13:55
@AhmedEmad the only code for creating the toggle group is from the controller skeleton code made in Scenebuilder ;private ToggleGroup gender
– Anthea Tawiah
Jan 3 at 0:00
add a comment |
I need to save the user's selected gender out of a gender Toggle group with the options 'M' and 'F' to a localhost phpmyadmin database. I have created the Radio Buttons in Scenebuilder, but the Sql commands to retrieve the user's selected Radiobutton are not working.
I've tried using the .getSelectedToggle() method to retrieve the user's choice from the toggle group, but it isn't working. The entire run fails because of this problem.
PreparedStatement ps = con.prepareStatement("insert into"
+ "alumni(aFirstName,aLastName,aGender,aBirthDate,aGradYear,aIndustry,"
+ "aProfession,aEmail,aLiveInGhana,aMailAddress)"
+ "values('"+firstName.getText()+"','"+lastName.getText()+
"','"+gender.getSelectedToggle()+"','"+
"','"+birthdate.getValue()+"','"+
"','"+gradyear.getValue()+"','" +industry.getText()+
"','"+profession.getText()+"','"+email.getText()+
"','"+liveInGh.g()+"','"+mailAdd.getText()+"')");
When the user saves their information, the selected toggle from toggle group 'gender' should be saved to the 'aGender' field in the alumni table.
java mysql javafx phpmyadmin radio-button
asked Jan 1 at 23:48
Anthea TawiahAnthea Tawiah
1
I need to save the user's selected gender out of a gender Toggle group with the options 'M' and 'F' to a localhost phpmyadmin database. I have created the Radio Buttons in Scenebuilder, but the Sql commands to retrieve the user's selected Radiobutton are not working.
I've tried using the .getSelectedToggle() method to retrieve the user's choice from the toggle group, but it isn't working. The entire run fails because of this problem.
PreparedStatement ps = con.prepareStatement("insert into"
+ "alumni(aFirstName,aLastName,aGender,aBirthDate,aGradYear,aIndustry,"
+ "aProfession,aEmail,aLiveInGhana,aMailAddress)"
+ "values('"+firstName.getText()+"','"+lastName.getText()+
"','"+gender.getSelectedToggle()+"','"+
"','"+birthdate.getValue()+"','"+
"','"+gradyear.getValue()+"','" +industry.getText()+
"','"+profession.getText()+"','"+email.getText()+
"','"+liveInGh.g()+"','"+mailAdd.getText()+"')");
When the user saves their information, the selected toggle from toggle group 'gender' should be saved to the 'aGender' field in the alumni table.
java mysql javafx phpmyadmin radio-button
java mysql javafx phpmyadmin radio-button
asked Jan 1 at 23:48
Anthea TawiahAnthea Tawiah
1
asked Jan 1 at 23:48
Anthea TawiahAnthea Tawiah
1
asked Jan 1 at 23:48
Anthea TawiahAnthea Tawiah
1
asked Jan 1 at 23:48
Anthea TawiahAnthea Tawiah
1
asked Jan 1 at 23:48
Anthea TawiahAnthea Tawiah
1
1
2
You're usingPreparedStatementbut are still concatenating the parameters into the SQL. You should put placeholders (?) in the SQL query, such asselect * from users where id = ?. You then call the appropriatesetXXXmethods on thePreparedStatementto set the parameters. See Using Prepared Statements.
– Slaw
Jan 2 at 0:02
try to provide the code creating the toggle group and the error message so we can define the problem if you are using scene builder provide the fxml code
– Ahmed Emad
Jan 2 at 13:55
@AhmedEmad the only code for creating the toggle group is from the controller skeleton code made in Scenebuilder ;private ToggleGroup gender
– Anthea Tawiah
Jan 3 at 0:00
add a comment |
2
You're usingPreparedStatementbut are still concatenating the parameters into the SQL. You should put placeholders (?) in the SQL query, such asselect * from users where id = ?. You then call the appropriatesetXXXmethods on thePreparedStatementto set the parameters. See Using Prepared Statements.
– Slaw
Jan 2 at 0:02
try to provide the code creating the toggle group and the error message so we can define the problem if you are using scene builder provide the fxml code
– Ahmed Emad
Jan 2 at 13:55
@AhmedEmad the only code for creating the toggle group is from the controller skeleton code made in Scenebuilder ;private ToggleGroup gender
– Anthea Tawiah
Jan 3 at 0:00
2
2
You're using
PreparedStatement but are still concatenating the parameters into the SQL. You should put placeholders (?) in the SQL query, such as select * from users where id = ?. You then call the appropriate setXXX methods on the PreparedStatement to set the parameters. See Using Prepared Statements.– Slaw
Jan 2 at 0:02
You're using
PreparedStatement but are still concatenating the parameters into the SQL. You should put placeholders (?) in the SQL query, such as select * from users where id = ?. You then call the appropriate setXXX methods on the PreparedStatement to set the parameters. See Using Prepared Statements.– Slaw
Jan 2 at 0:02
try to provide the code creating the toggle group and the error message so we can define the problem if you are using scene builder provide the fxml code
– Ahmed Emad
Jan 2 at 13:55
try to provide the code creating the toggle group and the error message so we can define the problem if you are using scene builder provide the fxml code
– Ahmed Emad
Jan 2 at 13:55
@AhmedEmad the only code for creating the toggle group is from the controller skeleton code made in Scenebuilder ;
private ToggleGroup gender– Anthea Tawiah
Jan 3 at 0:00
@AhmedEmad the only code for creating the toggle group is from the controller skeleton code made in Scenebuilder ;
private ToggleGroup gender– Anthea Tawiah
Jan 3 at 0:00
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%2f53999831%2fhow-to-save-selected-radio-button-out-of-toggle-group-to-mysql-database-javafx%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.
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%2f53999831%2fhow-to-save-selected-radio-button-out-of-toggle-group-to-mysql-database-javafx%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
2
You're using
PreparedStatementbut are still concatenating the parameters into the SQL. You should put placeholders (?) in the SQL query, such asselect * from users where id = ?. You then call the appropriatesetXXXmethods on thePreparedStatementto set the parameters. See Using Prepared Statements.– Slaw
Jan 2 at 0:02
try to provide the code creating the toggle group and the error message so we can define the problem if you are using scene builder provide the fxml code
– Ahmed Emad
Jan 2 at 13:55
@AhmedEmad the only code for creating the toggle group is from the controller skeleton code made in Scenebuilder ;
private ToggleGroup gender– Anthea Tawiah
Jan 3 at 0:00