How to get data in MySQL table into Java JTable?

Question

I'm working on Java project, and I need to load a particular set of data in to JTable. Can someone explain to me how to do this? These are my fields in the "mrnform" table in database called "order_processing".

`Date` varchar(10) NOT NULL,
`RegNo` int(11) NOT NULL,
`Description` varchar(50) NOT NULL,
`ItemNo` int(11) NOT NULL,
`Unit` varchar(10) NOT NULL,
`Quantity` int(11) NOT NULL,
`Delivery_Date` varchar(10) NOT NULL,
`Delivery_Address` varchar(10) NOT NULL,
`Site_Name` varchar(30) NOT NULL,

Query should be any thing such as "Select * from mrnform" etc. — SL_User
– SL_User, Commented Oct 1, 2011 at 15:37

mKorbel · Accepted Answer · 2011-10-01 13:37:48Z

7

1) construct JDBC Connection for MySql, examples here

2) load data to the JTable by using TableModel, examples here

3) if you'll reall question, post this question here in sscce from

answered Oct 1, 2011 at 13:37

mKorbel

110k20 gold badges138 silver badges331 bronze badges

Sign up to request clarification or add additional context in comments.

3 Comments

SL_User Over a year ago

How can I use it in net-beans I try to follow that guide line on NetBeans but it didn't work for me.

mKorbel Over a year ago

did you add MySql JDBC driver into your ClassPath, in Netbeans only add MySql JDBC driver to the libraries folder :-)

SL_User Over a year ago

Thanks for your resources. I have done that by following guide line on those reference. Thank you very much. :)

KV Prajapati · Accepted Answer · 2011-10-01 13:31:35Z

3

Pseudo code

Design the TableModel (or Vector)
Establish the db connection and retrieve result.
Store database result into TableModel object.
Construct the JTable(tableModel).

answered Oct 1, 2011 at 13:31

KV Prajapati

94.8k20 gold badges151 silver badges188 bronze badges

Comments

Headshota · Accepted Answer · 2011-10-01 13:30:54Z

2

Read the manual for the JTable:

http://download.oracle.com/javase/tutorial/uiswing/components/table.html

answered Oct 1, 2011 at 13:30

Headshota

21.4k13 gold badges63 silver badges82 bronze badges

Comments

V_Rajput · Accepted Answer · 2014-01-06 07:41:20Z

0

visit http://netshor.blog.com/2013/12/31/how-to-get-data-from-mysql-to-jtable/

'//initialize row of jTable int row=0; //start try-catch try{

//create connection with database //execute query //no start loop

while(rs.next()){jTable1.setValueAt(rs.getString(1), row, 0);

jTable1.setValueAt(rs.getString(2), row, 1);

jTable1.setValueAt(rs.getString(3), row, 2);

jTable1.setValueAt(rs.getString(4), row, 3);

jTable1.setValueAt(rs.getString(5), row, 4);

jTable1.setValueAt(rs.getString(6), row, 5);

jTable1.setValueAt(rs.getString(7), row, 6);

//increament in row of jtable. row++; } } catch(Exception e) {

}'

edited Jan 6, 2014 at 7:41

answered Jan 1, 2014 at 5:23

V_Rajput

212 bronze badges

Collectives™ on Stack Overflow

How to get data in MySQL table into Java JTable?

4 Answers 4

3 Comments

Comments

Comments

Comments

Your Answer

Linked

Hot Network Questions

Collectives™ on Stack Overflow

4 Answers 4

3 Comments

Comments

Comments

Comments

Your Answer

Sign up or log in

Post as a guest

Linked

Related