JavaFX не добовляет в таблицу
Не добавляет в таблицу
Подскажите что не так?
Ошибка
июл. 25, 2020 2:00:23 PM javafx.scene.control.cell.PropertyValueFactory getCellDataReflectively WARNING: Can not retrieve property 'name_dolg' in PropertyValueFactory: javafx.scene.control.cell.PropertyValueFactory@680d2eaa with provided class type: class sample.User java.lang.IllegalStateException: Cannot read from unreadable property name_dolg
private ObservableList<User> usersData = FXCollections.observableArrayList();
@FXML
private ResourceBundle resources;
@FXML
private URL location;
@FXML
private Tab TableRepair;
@FXML
private TableView repair;
@FXML
private TableColumn repairNum_KO;
@FXML
private TableColumn repairSKNO;
@FXML
private TableColumn repairDate;
@FXML
private TableColumn repairUser;
@FXML
private TableColumn repairYNP;
@FXML
private Tab TableUser;
@FXML
private TableView<User> user;
@FXML
private TableColumn<User,String> userName;
@FXML
private TableColumn<User, String> userDol;
@FXML
private TextField EditUserName;
@FXML
private TextField EditUserDol;
@FXML
private Button ButtonUserSearch;
@FXML
private Tab TableDol;
@FXML
private TableView dol;
@FXML
private TableColumn dolName;
@FXML
private TextField EditDol;
@FXML
private Button ButtonDolSearch;
@FXML
private Tab TableBase;
@FXML
private TableView base;
@FXML
private TableColumn baseNum_KO;
@FXML
private TableColumn baseDate_pod;
@FXML
private TableColumn baseYNP;
@FXML
private TableColumn baseName_SPD;
@FXML
private TableColumn baseNum_SPD;
@FXML
private TableColumn baseTO;
@FXML
private Button ButtonBaseSearch;
@FXML
private TextField editNum_KO;
@FXML
private TextField editYNP;
@FXML
private TextField editName_SPD;
@FXML
private TextField editNum_SPD;
@FXML
private TextField idetTO;
@FXML
private DatePicker editDate_pod;
@FXML
void initialize() {
ViewTable();
userName.setCellValueFactory(new PropertyValueFactory<User,String>(Const.USER_NAME));
userDol.setCellValueFactory(new PropertyValueFactory<User,String>(Const.DOL_NAME));
user.setItems(usersData);
}
private void ViewTable(){
try{
String query = "SELECT " + Const.USER_NAME +","+ Const.DOL_NAME+ " FROM " + Const.USER_TABLE + " INNER JOIN " +Const.DOL_TABLE+ " ON "
+Const.USER_TABLE+"."+Const.USER_ID_DOL+"="+Const.DOL_TABLE+"."+Const.DOL_ID;
PreparedStatement prST = new DatabaseHandler().getDbConnection().prepareStatement(query);
ResultSet rs = prST.executeQuery();
while (rs.next()){
System.out.println(rs.getString(Const.USER_NAME)+","+ rs.getString(Const.DOL_NAME));
usersData.add(new User(rs.getString(Const.USER_NAME), rs.getString(Const.DOL_NAME)));
}
prST.close();
rs.close();
} catch (SQLException ex) {
Logger.getLogger(Authorization.class.getName()).log(Level.SEVERE, null, ex);
} catch (ClassNotFoundException e) {
e.printStackTrace();
}
}
}