Tableview bring date, mysql database

Question

I have a Table View, which receives the data of a table in my Database, until then I was able to bring the data normally, but the date is different from the one registered in the database, always behind 1 day before.

For example:

In the bank: 2018-09-06 In my Tableview returns: 2018-09-05

What could be causing this mistake?

Some data on how I am declaring the date:

import java.util.Date;

private Date datavisita;

public Date getDatavisita() {
return datavisita;
}

public void setDatavisita(Date datavisita) {
this.datavisita = datavisita;
}

//metodo para filtrar a data:

v.setDatavisita(rs.getDate(“datavisita”));

//declaração da coluna data
@FXML
TableColumn<VW_Visitas_Sonho, Date> colData;

// configurar as colunas de acordo com o objeto VW_Visitas_Sonho

colData.setCellValueFactory(new PropertyValueFactory<>(“datavisita”));

Answer 1

I believe it is a problem when converting dates. I will suggest that you use the new Java 8 Date API Localdate/Localdatetime. Java.sql.Date comes with a method called toLocalDate() that you can use.

private LocalDate datavisita;

public Date getDatavisita() {
    return datavisita;
}

public void setDatavisita(LocalDate datavisita) {
    this.datavisita = datavisita;
}

Here we will use the toLocalDate method().

System.out.println(rs.getDate(“datavisita”).toLocalDate()); // Verifique antes
v.setDatavisita(rs.getDate(“datavisita”).toLocalDate());

Change the declaration of your Column table:

TableColumn<VW_Visitas_Sonho, LocalDate> colData;

// [...] A configuração está correta
colDate = new TableColumn<>("Data");
colData.setCellValueFactory(new PropertyValueFactory<>(“datavisita”));

If the problem persists for some reason you can easily add a day to Localdate using the plusDays method();

v.setDatavisita(rs.getDate(“datavisita”).toLocalDate().plusDays(1));

If you have problems formatting the date see this article: https://code.makery.ch/blog/javafx-8-tableview-cell-renderer/

Note: Also check if there are no time zone problems, in which case use Zonedlocaldate and beware of null.