java.sql.Date error how to avoid it? Inserting a date into my database

Question

I want to insert "ID, Benutzername, Passwort, Name, Vorname, Geburtsdatum, IstWirt" into my database, but I have an error in this code:

connect.UpdateUser(Integer.parseInt(textFieldId.getText()), 
    textFieldBenutzername.getText(),
    textFieldPasswort.getText(),
    textFieldName.getText(),
    textFieldVorname.getText(),
    new java.sql.Date (GeburtsdatumDate),
    IstWirtBoolean);

Error Message:

"the constructor Date(Date) in undefined"

I know that I need to have "java.sql.Date" in this request but I really do not have any clue how to avoid the error. I already tried to insert the "textFieldGeburtsdatum.getText()" instead of "GeburtsdatumDate" but with no success.

boolean IstWirtBoolean;
if (textFieldWirt.getText() == "1") {
    IstWirtBoolean = true;
}
if (textFieldWirt.getText() == "0") {
    IstWirtBoolean = false;
}

Date GeburtsdatumDate = new SimpleDateFormat("dd/MM/yyyy").parse(textFieldGeburtsdatum.getText());
connect.UpdateUser(Integer.parseInt(textFieldId.getText()),textFieldBenutzername.getText(),textFieldPasswort.getText(),textFieldName.getText(),textFieldVorname.getText(),
        new java.sql.Date (GeburtsdatumDate),IstWirtBoolean);

database code:

public void UpdateUser(int ID,String Benutzername, String Passwort, String Name,
    String Vorname, Date Geburtsdatum, Boolean IstWirt) throws SQLException { 
        try {
            String query = "Insert into user (ID,Benutzername,Passwort,Name,Vorname,Geburtsdatum,IstWirt) Values (?,?,?,?,?,?,?)";
            PreparedStatement stmt = con.prepareStatement(query);
            stmt.setInt(1, ID);
            stmt.setString(2, Benutzername);
            stmt.setString(3, Passwort);
            stmt.setString(4, Name);
            stmt.setString(5, Vorname);
            stmt.setDate(6, Geburtsdatum);
            stmt.setBoolean(7, IstWirt);
            stmt.executeUpdate();

        }
        catch(Exception e) {
            System.out.println(e);
        }

    }

Edit:

    Date GeburtsdatumDate = new SimpleDateFormat("dd/MM/yyyy").parse(textFieldGeburtsdatum.getText());


connect.UpdateUser(Integer.parseInt(textFieldId.getText()),textFieldBenutzername.getText(),textFieldPasswort.getText(),textFieldName.getText(),textFieldVorname.getText(),new java.util.Date (GeburtsdatumDate),IstWirtBoolean);

here i get the same error message.

The method UpdateUser(int, String, String, String, String, Date, Boolean) in the type DBConnect is not applicable for the arguments (int, String, String, String, String, Date, boolean)
    The constructor Date(Date) is undefined

You are comparing strings with == which is not what you should be doing. Use equals to compare strings. — TT.
– TT., Commented Nov 24, 2019 at 22:45

Andreas · Accepted Answer · 2019-11-24 22:30:15Z

3

new java.sql.Date (GeburtsdatumDate) causes "the constructor Date(Date) is undefined"

Either GeburtsdatumDate is already a java.sql.Date, in which case you just use it, but that is likely not the case, so it must be some other type of Date, likely a java.util.Date.

To convert a java.util.Date to a java.sql.Date, call the getTime() method:

new java.sql.Date(GeburtsdatumDate.getTime())

answered Nov 24, 2019 at 22:30

Andreas

160k13 gold badges164 silver badges262 bronze badges

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

Comments

Susheel Dwivedi · Accepted Answer · 2019-11-24 17:36:52Z

0

There is no such constructor defined inside of java.sql.Date class. You should try with Java.util.Date. Date GeburtsdatumDate = new SimpleDateFormat("dd/MM/yyyy").parse(textFieldGeburtsdatum.getText()); also return java Date type not sql date type.

answered Nov 24, 2019 at 17:36

Susheel Dwivedi

945 bronze badges

1 Comment

gandaaflf Over a year ago

I get the same error message when I do this. I will edit it to my question for a better view

Collectives™ on Stack Overflow

java.sql.Date error how to avoid it? Inserting a date into my database

2 Answers 2

Comments

1 Comment

Your Answer

Linked

Hot Network Questions

Collectives™ on Stack Overflow

2 Answers 2

Comments

1 Comment

Your Answer

Sign up or log in

Post as a guest

Linked

Related