2 replies to this topic

[manutd112]

hey i am new to this forum and i have a question regarding Jtables, panels and mysql..

i am working on a school project where i am making a netbank.. i have come across problem i cant solve.

i want to show information about a customers account in a Jtable, but not by using a Jframe, rather i jpanel, as i am going to run it all via a japplet.

i can do this without a jtable, but i have to do it with a jtable...

my sql quiry looks like this...

the parameter custID is the customers ID....

String SQLQUERY = "SELECT accounts.Account_Name, accounts.Saldo, " +
"useraccounts.Account_NR" +
" from Accounts " +
"INNER JOIN useraccounts on accounts.Account_NR=useraccounts.Account_NR" +
" AND useraccounts.Cust_id=" + custID+";";


I HAVE ATTACHED 3 files, the DBProgram class which handles db connections..

the custFunk class which handles customer functions, its here i want the method show account info to be.

and a customer GUI class which is the gui for the customers. in there i want to push a button and account info is showen...

please help  CustGui.java   8.74K   63 downloads

Attached Files

•  CustFunk.java   4.18K   60 downloads
•  DBProgram.java   1.71K   62 downloads

[wim DC]

Take a look at post #3 on this forum, I think he does what you want there
How to Extract records from Mysql database using JTable - Software Development

[manutd112]

thank you, but i need the method to be in a seperat class, and the jtable to be in a panel i can call from the main gui....