Insert date into MySql Database using JavaFX Datepicker

Question

I'm trying to insert date to mysql database from data-picker using javaFx. I am tired by submit this code.

@FXML
private DatePicker DPCurrentDate;//fx:id="DPCurrentDate"

// BrandAdded is a Method that i created for insert data into database

private void BrandAdded(){

    DBConnection newCon = new DBConnection();
    con = newCon.geConnection();

    try {
        pst = con.prepareStatement("insert into Brands values(?,?,?,?,?)");
        pst.setString(1, null);
        pst.setString(2, TFBrandName.getText());
        pst.setString(3, TABrandDecription.getText());
        pst.setString(4, lblUserName.getText());
        pst.setDate(5, DPCurrentDate.getValue());
        pst.executeUpdate();

    } catch (SQLException ex) {
        Logger.getLogger(AddBrandController.class.getName()).log(Level.SEVERE, null, ex);
    }
}

when i run my program it give me this error

error: incompatible types: LocalDate cannot be converted to Date
        pst.setDate(5, DPCurrentDate.getValue());

James_D · Accepted Answer · 2015-05-16 20:31:19Z

4

You need

java.util.Date date = 
    java.util.Date.from(dpCurrentDate.getValue().atStartOfDay(ZoneId.systemDefault()).toInstant());
java.sql.Date sqlDate = new java.sql.Date(date.getTime());
pst.setDate(5, sqlDate);

(using a java.sql.Date).

edited May 16, 2015 at 20:31

answered May 16, 2015 at 18:19

James_D

211k16 gold badges312 silver badges345 bronze badges

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

3 Comments

K M Rifat ul alom Over a year ago

how i get the dpCurrentDate where i have DPCurrentDate as Datapicker.

James_D Over a year ago

I meant the same thing... I was just correcting your variable name so that it matched standard naming conventions :). I had a bunch of other errors in there though (don't know what I was thinking when I put that together...). They are now fixed.

Tanzeel Over a year ago

I'm using this solution in year 2020 with JDK 8. It still works. Thank you so much.

HaveNoDisplayName · Accepted Answer · 2015-11-20 04:00:56Z

0

import java.sql.Date;
Date  DPCurrentDate1 =  Date.valueOf(DPCurrentDate);
pst.setDate(5, DPCurrentDate1);

This would do your work

edited Nov 20, 2015 at 4:00

HaveNoDisplayName

8,537106 gold badges41 silver badges50 bronze badges

answered Nov 20, 2015 at 3:43

Sreekanth

311 silver badge11 bronze badges

Comments

K.Dᴀᴠɪs · Accepted Answer · 2018-11-24 02:24:20Z

0

use this in your method save or whatever you named it.

dateTimePicker.valueProperty().get(),

Note. close it with ) if that is your last item to save.

edited Nov 24, 2018 at 2:24

K.Dᴀᴠɪs

10.1k13 gold badges36 silver badges46 bronze badges

answered Nov 24, 2018 at 1:58

Jonathan Tetteh

11

Comments

shafikshaon · Accepted Answer · 2019-01-27 13:48:09Z

0

You can try this:

pst.setDate(5, ((TextField)DPCurrentDate.getEditor()).getText());

edited Jan 27, 2019 at 13:48

shafikshaon

6,5025 gold badges36 silver badges54 bronze badges

answered Jan 27, 2019 at 8:18

Smmy Sa

6011 gold badge7 silver badges5 bronze badges

Collectives™ on Stack Overflow

Insert date into MySql Database using JavaFX Datepicker

4 Answers 4

3 Comments

Comments

Comments

Comments

Your Answer

Linked

Hot Network Questions

Collectives™ on Stack Overflow

4 Answers 4

3 Comments

Comments

Comments

Comments

Your Answer

Sign up or log in

Post as a guest

Linked

Related