I need a help in creating a observable list with the result set?

Asked May 22 '19 at 00:19

Active May 22 '19 at 05:39

Viewed 131 times

I am sorry I am newbie and I have this doubt... following is my query.

Select id,item_table.item_name,quantity,
total from Sales
inner join item_table on item_code=id

I take values from two different tables and I need to create an ObservableList with the ResultSet to load into TableView with columns id, name, quantity, sales?

I have two classes:

sales with field id,quantity and total sales
item with item_name

Can I do that?

edited May 22 '19 at 05:39

Jamith NImantha

1,999
2
20
27

asked May 22 '19 at 00:19

Divya Dharshini

Are you asking, if it's possible to create a `TableView` with 4 columns and fill it with data? Of course! – fabian May 22 '19 at 01:12
I want to fill the table column with the resultset from the query I mentioned. – Divya Dharshini May 22 '19 at 03:03
See if [this](https://github.com/sedj601/SQLitePersonTableViewExample) helps. – SedJ601 May 22 '19 at 14:01

I need a help in creating a observable list with the result set?

0 Answers0