cannot convert java.util.Date to java.sql.Date with JXDatePicker

Question

i am using a JXDatepicker here. i dont know what to do with the error please help me. i tried a lot but failed. enter image description here

i tried to print what cause this error and it prints this message. i want the format to be yyyy/MM/dd cause i want it to insert into the database.

AddProductGUI.java

txtExpiration = new JXDatePicker();                     txtExpiration.setName("Expiration");
txtExpiration.setBorder(null);
txtExpiration.setFormats(new SimpleDateFormat("yyyy.MM.dd"));

AddProduct.java

public java.util.Date returnDate(JXDatePicker txtExpiration, Boolean isExpiring) {
        if (isExpiring) {
            return txtExpiration.getDate();
        } else {
            return null;
        }
    }

ActionToDatabase.java

if (!DatabaseValidator
                            .isExistingData(
                                    "select ProductID from tblIndividualProduct where ProductID =?",
                                    product.getProductID())) {

                        sql = "insert into tblIndividualProduct (ProductId,Code,Expiration,Note,UpdatedPrice,PriceChanged) Values(?,?,?,?,?,?)";

                        connection
                                .setPreparedStatement((PreparedStatement) connection
                                        .getConnection().prepareStatement(sql));
                        connection.getPreparedStatement().setString(1,
                                product.getProductID());
                        connection.getPreparedStatement().setString(2,
                                product.getCode());

                        //connection.getPreparedStatement().setDate(3, new java.sql.Date(product.getExpiration().getTime()));
                        **connection.getPreparedStatement().setDate(3, (java.sql.Date)product.getExpiration());**

                        connection.getPreparedStatement().setString(4,
                                product.getNote());
                        connection.getPreparedStatement().setDouble(5,
                                product.getPrice());
                        connection.getPreparedStatement().setBoolean(6,
                                product.getPriceChanged());
                        connection.getPreparedStatement().executeUpdate();
                        System.out
                                .println("Successfully added individual product ("
                                        + product.getProductID()
                                        + ") to the database");

enter image description here

MadProgrammer · Accepted Answer · 2014-03-12 01:28:37Z

1

Create a new instance of a java.sql.Date using the java.util.Date as the base value, for example

connection.getPreparedStatement().setDate(3, 
    (product.getExpiration() == null ? 
        null : 
        new java.sql.Date(product.getExpiration().getTime())));

It would be possible to pass a java.sql.Date to JXDatePicker as java.sql.Date extends from java.util.Date, but it won't work the other way around (you can't cast a java.util.Date to a java.sql.Date without first knowing that the object is acutally a java.sql.Date masquerading as a java.util.Date

edited Mar 12, 2014 at 1:28

answered Mar 12, 2014 at 1:06

MadProgrammer

348k22 gold badges243 silver badges379 bronze badges

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

3 Comments

Rohan21 Over a year ago

i already tried that new jaba.sql.Date(product.getExpiration().getTime()) but i get a nullpointer because i also want to return null when its the product is not expiring.

MadProgrammer Over a year ago

Sorry my bad, you could use a tri operator to detect the null from the produce and set the column value accordingly - see update...

Rohan21 Over a year ago

thanks sir you save me everytime. i owe you a lot. :D

Collectives™ on Stack Overflow

cannot convert java.util.Date to java.sql.Date with JXDatePicker

1 Answer 1

3 Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

3 Comments

Your Answer

Sign up or log in

Post as a guest

Related