I’ve been asked to make a Java JTable tutorial by many people. Today I’ll show you how to display database query results from my Sabermetrics Tutorial into a Java JTable.
I then cover most everything about Java JTables. How to display data into a JTable. How to change fonts in a JTable. How to change row height in a JTable. How to sort a JTable. How to align a JTable column and much more.
All of the code follows the tutorial and it has even more tricks.
If you like videos like this, please tell Google [googleplusone]
Code from the Video
Thanks again, we were waiting for this one, and after 5 days we have got this nice tutorial. Wish u have a nice day.
I’m glad you like it. I thought it would be fun to actually make a nice tool instead of just covering the API. I have a much bigger project planned. This tutorial series seems to be losing interest so I’m going to experiment with more tutorials like this one.
I kind of like it when a tutorial loses its audience. Can you tell that I don’t make tutorials just to make money 🙂
I never comment on tutorials but I had to comment on yours. THIS WAS A FANTASTIC TUTORIAL ON JTABLE!!!!! It answered most of my questions and I am truly greatful.
I’m very happy that I was able to explain this often confusing subject. I just made another video on Java JTables. It and part 38 will cover everything you can do with them. Thank you for taking the time to show your appreciation 🙂
I never expected there is something like your tutorials on the internet.
…..THANK YOU
You’re very welcome 🙂 I’m glad you found me because I don’t think many people know about my site
Why is there a table named “TOTBYR” on line 87 when there is no such table given in this database? Error that shows up on my console says: “Table ‘lahman591.totbyr’ doesn’t exist”.”
I downloaded the this sql database.
Any idea how to fix this? :-/
The reason why is because this tutorial was meant to be used in combination with my SQL review tutorial using sabermetrics. This is the tutorial in which I created TOTBYR Sabermetrics Video Tutorial. I have all the tutorials on this page Baseball Sabermetrics.
I decided to cover a real world topic while talking about SQL and Java. I hope that helps – Derek
Cool =) Looking forward to it =)
Dear Derek,
thanks for your awesome tutorials on JTable and SQL, I am a student who is trying to practise some SQL and java coding skills during the winter holiday, your tutorials have been extremely helpful. as you said in this video, this one is a good example for model view controler design. if you are making any totorials about MVC, I was wondering if you could use this JTable and SQL to illustrate MVC, please? (I asked you about MVC tutorial a few days ago) many thanks
You’re very welcome 🙂 Yes, I’m going to cover MVC in its on tutorial very soon. I’ll do my best to make it completely understandable so it can be used in any context. Thanks for the request
many thanks derek, happy new year!
Happy New year!
SIR kindly teach me how to make a download manager in java and how RMI works
plz sir………..
I will definitely cover those topics asap. Thank you for the request
This tutorials are THE BEST OF THE BEST – THANKS A LOT !!!
You’re very welcome 🙂
This tutorials are THE BEST OF THE BEST -THANKS A LOT !!!
Please, add the MVC version of this code in your MVC tutorial
I’ll be doing a great deal more with MVC in upcoming tutorials. I’m glad you like them 🙂
I have seen so many tutorial’s but urs is to the point i realy appreciate for your time hope you will have some new ones for other languages.
Thank you 🙂
Derek,
I have been looking at tutorials on different ways to process ResultSets into JTables for about the past 168 hours straight! I either just couldn’t understand or couldn’t get the other methods to work at all… 🙁
I found your tutorial today and within an hour I have a working program that processes my ResultSet into a JTable. You are awesome bro! Thank you for taking the time and effort to help people like me.
– James
p.s. Before I even saw your post about the e-cig I had been trying to quit smoking for about a week… I still smoke 3 or 4 real ones per day, but it is way better than my usual pack a day! So glad it worked for you, just don’t start again… Who will write these wonderful tuts if you aren’t here for us?
I’m very happy that I was able to help.
Yes I had quit smoking for a few weeks now and then over the years, but I could never eliminate them 100%. I quit a few months ago so I won’t go back. I’m pretty good at hypnosis, so with a bit of that and the E Cigs I’m good to go now. Keep at it and try a bunch of different devices. I’m still messing around with devices now, but the eGo Twist is pretty great
What do you hypnotize us to do?
Because it is quite unbeliveable
you create those quality tutorials
just for fun.
Just kidding of course. (Or am I?)
Anyway, many thanks from Poland.
(yes, we DO have computers here)
That’s funny 🙂 I receive an infinite amount of pleasure from helping so many people! I also get to talk to a ton of extremely nice people all over the world like yourself. Being pretty much a country boy, you can’t imagine how amazing that is to me.
Thank you for visiting my site
” Unknown column ‘t.playerID’ in ‘where clause’ ” thats what I get when I run the program….I copied your sql code I didnt add and remove anything from it
Nice tutorial but I get problem. ” Unknown column ‘t.playerID’ in ‘where clause’ ” thats what I get when I run the program….I copied your sql code I didnt add and remove anything from it
Thank you 🙂 There must be a typo some place. Sorry I can’t think of anything else
This makes creating JTables easy. I have been looking for something. Most of the tutorials I found make JTable sound and feel more complicated. Many thanks.
That is the best compliment I can get 🙂 I work very hard to find the simplest way to teach these topics. Thank you
Hi!
This is great. Thank you.
You’re very welcome 🙂
Hi Derek,
thank you very much for these works. It’s Perfekt.
Can you help me please? I get error while reading from database. Error is “SQLException: Table ‘lahman.Batting’ doesn’t exist
VendorError: 1146”
But i have the table. Do you know why is this Error? GUI is there without any results 🙁
Thank you.
Regards,
Jan
Hallo again,
sorry for bothering you. I found my fault. But i have another problem. I dont have the table TOTBYR. Where is this from?
Thank you.
Regards,
Jan
Hi Jan,
I created that table in my Sabermetrics tutorial. It was my idea to teach MySQL using a fun topic like baseball. You can find all the code and videos here Sabermetrics Tutorial.
Hello Derek,
Your teaching style is not making me gaining programming sense.
For example: For displaying data in JTable from Database, you involved many new concepts in this tutorial like overriding methods of parent class, Using syntax like ‘Object.class’, using keyword like ‘Class’.
So, Looks like i am feeling difficult to grab the purpose of such 3 concepts(above), as you are directly using it in this context.
It took me one day to understand after runtime debug to know, what is ‘Object.class’, because google also doesn’t show this.
Hello,
I basically require people to watch every video in order like you would in a college course. That is why I don’t give the specific java tutorials names other then just numbers. I can definitely understand why my videos would be hard for some people to grasp because I go very fast. I try to make up for that by recovering topics that people are struggling with.
For best results it helps to print out the code and take notes as you watch. Then if you have any questions you can pass them to me and then write out the answers in your own words.
Sorry the tutorials didn’t work for you.
Derek
Hello Derek,
I think your tutorial looks perfect for people who already played around with basic java concepts and i understand it would be too difficult for you to teach examples on each basic concept after you worked for 30 years in the industry. I would contradict myself with my point, when i talk about C tutorial where you teach all such basics, instead of going in depth ):
May be i will come to this tutorial after i go to another java tutorial which teaches all such building blocks separately.
I write my code according to yours, but it doesn’t work. Can you help me solve it?
public class View extends JFrame{
JFrame frame;
JTable table;
JButton makeAppointment;
public Login3Doctor( String[][] viewInfo,String[] columns){
DefaultTableModel dTableModel = new DefaultTableModel(viewInfo, columns){
public Class getColumnClass(int column) {
Class returnValue;
// Verifying that the column exists (index > 0 && index = 0) && (column < getColumnCount())) {
returnValue = getValueAt(0, column).getClass();
} else {
// Returns the class for the item in the column
returnValue = Object.class;
}
return returnValue;
}
};
frame=new JFrame();
frame.setDefaultCloseOperation(JFrame.EXIT_ON_CLOSE);
table=new JTable(dTableModel);
table.setFont(new Font("Serif", Font.PLAIN, 20));
table.setRowHeight(table.getRowHeight()+10);
table.setAutoCreateRowSorter(true);
table.setAutoResizeMode(JTable.AUTO_RESIZE_OFF);
TableColumn col1 = table.getColumnModel().getColumn(0);
col1.setPreferredWidth(200);
TableColumn col2 = table.getColumnModel().getColumn(1);
col2.setPreferredWidth(200);
TableColumn col3 = table.getColumnModel().getColumn(2);
col3.setPreferredWidth(200);
TableColumn col4 = table.getColumnModel().getColumn(2);
col3.setPreferredWidth(200);
JScrollPane scrollPane = new JScrollPane(table);
frame.add(scrollPane, BorderLayout.CENTER);
frame.setSize(800, 500);
//frame.setVisible(true);
}
public static void main(String[] args){
String[][] b={{"s","m","10","xixi","ha"},
{"h","a","1","a","e"},
{"a","b","2","4","3"}};
String[] c={"name","sex","age","lkj","4342"};
Login3Doctor v=new Login3Doctor(b,c);
v.setVisible(true);
}
What error are you getting?
Can we use text file instead of mysql database….
and we have to get same as now…
if so,pls help me for this code,
i’ve already written the code,but its not giving the contents of the file as columns,
soo,pls help me..
pls respond quickly…
I cover how to use files on this page in parts 31 – 33. I hope it helps 🙂
Hi Derek,
I just wanted to say thank you so much for all the effort you put in! I’m a first year CS student and I learn faster from you than my lecturers. I’m a long time subscriber, first time commenter though. hehe.
Thanks again! I just wish I could verbally express the extent of my gratitude.
-Mufhim
Hi Mufhim,
Thank you 🙂 I’m glad you are finding the videos useful. Many more are coming.
Hi Derek
Thanks for the great tutorials. Just one question please. I get an error on line 045.
returnValue = getValueAt(0, column).getClass();
-what does the 0 represent?
Thanks very much Derek for the series. They are great. I just have one question please.
Line 045 what does 0 represent in the statement
returnValue = getValueAt(0, column).getClass();