Java netbeans Jtable binding with database using the where clause

1.1k views Asked by At

So I have created an application featuring a table that is bound to a database. However I can not figure out how to add a where clause (So that you will only find transactions that are currently going on, any transactions that are finished are not supposed to be shown. I essentially want to make it show the rows only when "Transactionstate='ongoing'" So i want to sort the rows so I won't see any rows that fit this criteria.

Here is a picture of my application with the table netbeans binded to my database.

An image of the application with the table

The table I am using is a JTable from the drag and drop menu in Netbeans design.

enter image description here

I did see that it is possible to manually create a table that can do what I am doing. But is there any other way to do this with Netbeans ? Or is there something I could download like the JCalendar ?

Please forgive me if this was an easy question...I am learning Java atm.

Sincerly..

//Orville Nordström

0

There are 0 answers