1-) Java - JAVAFX DATEPİCKER GETTİME YAPMA VE SQL İLE KARŞILAŞTIRMA

@FXML

private DatePicker ara_tarih_bas;

@FXML

private DatePicker ara_tarih_bit;

@FXML

public void tarih_sorgula() throws ParseException {

String bass = ara_tarih_bas.getValue().toString();

String bitt = ara_tarih_bit.getValue().toString();

System.out.println("bas = " + bass + "\n bit = " + bitt);

java.util.Date date4 = java.util.Date.from(ara_tarih_bas.getValue().atStartOfDay(ZoneId.systemDefault()).toInstant());

java.util.Date date5 = java.util.Date.from(ara_tarih_bit.getValue().atStartOfDay(ZoneId.systemDefault()).toInstant());

java.sql.Date bas1 = new java.sql.Date(date4.getTime());

java.sql.Date bit1 = new java.sql.Date(date5.getTime());

try {

Connection con = GetConnection();

String sql = "select * from kampanya_kayit";

Statement stmt = con.createStatement();

ResultSet rs = stmt.executeQuery(sql);

while (rs.next()) {

Date veri_bas = rs.getDate("bas_tarihi");

Date veri_bit = rs.getDate("bit_tarihi");

if (veri_bas.getTime() > bas1.getTime()&&bit1.getTime()>veri_bit.getTime()) {

System.out.println(veri_bas+"-------"+veri_bit);

} else { } } }

catch (SQLException ex) {

Logger.getLogger(DashboardController.class.getName()).log(Level.SEVERE, null, ex); } }