Set Date Param in Mysql from Java

Question

I have jsp page view and in java and I am getting datepicker value in Java

Using this : LocalDate localDate = datePicker.getValue();

I am not able to set this value using query in Mysql database where type is date in my table of column date of birth

I think you might first convert the LocalDate to Date. https://stackoverflow.com/questions/33066904/localdate-to-java-util-date-and-vice-versa-simpliest-conversion — Alain-Michel Chomnoue N, Jul 18 '17 at 14:29
have another question with tags: jquery, javascript and java. This one is more related to "how to set a date field in mysql" — Gianluca Ghettini, Jul 18 '17 at 14:51

score 1 · Answer 1 · answered Jul 18 '17 at 14:29

1

Assuming you are using PreparedStatement, You just need to convert LocalDate into sql.date and set it in, e.g.:

LocalDate localDate = datePicker.getValue();
Date date = Date.from(localDate.atStartOfDay().toInstant(ZoneOffset.UTC));
PreparedStatement pStmt = //your preparedstatement
pStmt.setDate(1, new java.sql.Date(date.getTime()));

answered Jul 18 '17 at 14:29

Darshan Mehta

30,102
11
68
102

Also how to get datepicker from UI to Java – Kramer Jul 18 '17 at 14:31
what is *"from UI to Java"* supposed to mean? – specializt Jul 18 '17 at 14:47
@specializt I think he's trying to do something like this -> https://stackoverflow.com/questions/17746669/how-to-bind-jquery-datepicker-function-with-underlying-java-spring-form-java-uti – Gianluca Ghettini Jul 18 '17 at 14:49

Gianluca Ghettini · Answer 2 · 2017-07-18T14:44:53.227

0

The date format for mysql insert query is YYYY-MM-DD

example:

INSERT INTO table_name (date_column) VALUE ('YYYY-MM-DD');

so change your java code to generate such YYYY-MM-DD string

DateTimeFormatter formatter = DateTimeFormatter.ofPattern("yyyy-MM-dd");

// ...

LocalDate date = datePicker.getValue();
if (date != null) {
    display.setText(formatter.format(date));
} else {
    display.setText("");
}

edited Jul 18 '17 at 14:44

answered Jul 18 '17 at 14:38

Gianluca Ghettini

11,129
19
93
159

and how to recieve jquery datepicker in java – Kramer Jul 18 '17 at 14:40
not sure, have a look here -> https://stackoverflow.com/questions/17746669/how-to-bind-jquery-datepicker-function-with-underlying-java-spring-form-java-uti – Gianluca Ghettini Jul 18 '17 at 14:43
what is datepicker name of tag element input type date? – Kramer Jul 18 '17 at 14:43
whatever id you have assigned to the input div element – Gianluca Ghettini Jul 18 '17 at 14:46

Set Date Param in Mysql from Java

2 Answers2