netbeans gui sql query

Vote count:

0

I am sure this has been asked a million times and it's my google search thats letting me down or I just cannot see the wood for the trees.

I have built a form in Netbeans that has the following elements

FromDateText - Which a user can populate ToDateText - which a user can populate

I have a SQL query which is simply

select(sum(cast(quantity as float)) as 'totalbuys' from orders where menunum in ('211', '215') and reversalflag = 'n' and orderdate between xxxxxx and xxxxx

Now the order date is what I need to link to the FromDateText and ToDateText fields (cannot work this out) and feel very foolish because of it!

The result of this query in this instance lets say it 100.1234

I wish to have populate in another text box within the GUI

TotalBuysText

which will be done with setText code (again I presume) I just cannot work out how to get all the dots to connect.

Help massively appreciated!

Regards

R

asked 47 secs ago

user2999482

9

netbeans gui sql query