How to Get Data from Database to JTable in Java | Display MySQL Data into JTable

[@CSCORNERSunitaRai]

*_Got a question on the topic? Please share it in the comment section below and I will answer it for you._*

[@iamnel3141]

My codes didn't show anything 😢

[@sadokfkaier7703]

Same think happened @@iamnel3141

[@7_ajinkya]

so far the only video that shows how to work with JTable and ScrollPane! Thank you so much!!

[@CSCORNERSunitaRai]

Glad to know👍Keep watching

[@swanandlaghate5113]

Thanks a lot!!!! You have just cleared my 2.5 years long confussion!

[@CSCORNERSunitaRai]

You're welcome👍 please subscribe

[@preciousjumuad2958]

Thank you ma'am! You just saved me from being stuck in a bug for a whole week. May you continue helping programmers, kudos!

[@CSCORNERSunitaRai]

Glad it helped! Yes, I will.

[@adramshapath4720]

Madam Excellent Performance with great detail

[@dannydevelops]

You deserve a medal for this. Thanks

[@CSCORNERSunitaRai]

Thank you ☺😊please subscribe

[@SimplySuman]

So clearly explained ma'am 🙏

[@CSCORNERSunitaRai]

Thank you so much👍

[@MessiSwag10]

Thank you so much for the helpful video! I do have a question though. In your program, you knew the amount of columns before hand, so you were able to create the no, name, and makrs variables. Is there an alternate way to do this if you don't know what your column size will be?

[@CSCORNERSunitaRai]

Yes you can use ResultSetMetaData interface. It's having method through which you can get column count.

[@CSCORNERSunitaRai]

Refer my advanced java playlist. I have shown in one video

[@IonianWinds]

you are an absolute lifesaver!! Thank you so much for sharing this! Wish you very happy holidays and an amazing new year! 💞

[@CSCORNERSunitaRai]

That's great😊 keep watching and plz subscribe

[@definitelynotamexicanskele6913]

Thank you so much maam, you're a life saver!!!

[@CSCORNERSunitaRai]

Happy to help!plz subscribe

[@robmanda007]

Hi how are you, Thank you so much for the these tutorials. They are so helpful in my capstone project. May you please do lectures on how to create pie charts, bar graphs and line graphs fetching data from a database.

[@CSCORNERSunitaRai]

Glad my video helped you👍 I'll try

[@devisri7645]

Thank you for clear demo mam

[@CSCORNERSunitaRai]

You're welcome👍

[@joelmarkjmj]

OMG Mam you saved me!

[@CSCORNERSunitaRai]

You're welcome👍please subscribe😊

[@theamazingtutorial.9019]

Easy Explained. This video made my knowledge++. Thank you

[@CSCORNERSunitaRai]

Wowww that's great 👍😊🔥keep watching

[@amitdlh]

hello , please how can i solve this problem when I run i get : java.sql.SQLException: No value specified for parameter 1 ! thankyou .

[@CSCORNERSunitaRai]

Check out no, of? And r u providing value for all these ? Or not

[@festussibanda5886]

thank you so much, your video just helped me learn a new concept, keep up the good work

[@CSCORNERSunitaRai]

Glad to hear that! Keep watching and plz subscribe

[@AbdessamadBelm]

Great video , straight to the point. Thank you so much 👍

[@CSCORNERSunitaRai]

Glad you liked it👍☺plz subscribe

[@SHEIMANALEKZANDAR]

Hi ma'am May i know how do view table without clicking a button! Like an Example when i run the program automatically The records from the database should show

[@CSCORNERSunitaRai]

Write code in constructor

[@bonissocool4638]

Thank you so useful for my uni project!

[@CSCORNERSunitaRai]

Glad to know that👍 stay connected✅

[@zeronetechlearner1546]

Thanks a million, Madam.

[@CSCORNERSunitaRai]

You're welcome👍 Do explore my channel for such more contents

[@health.upgradedbyscience.7309]

Great tutorial, thanks a lot! It´s of tremendous help for what I´m working on right now..

[@CSCORNERSunitaRai]

Glad my video helped you👍 keep watching😍

[@arifhussain9676]

THanks for the video, every time i press show button, It makes duplicate and show it on table. Can we do something so that no duplicate record shows on table

[@CSCORNERSunitaRai]

Check addRow method. Did you wrote it twice?

[@arifhussain9676]

@@CSCORNERSunitaRai I wrote it one time but I press button twice or when you press button again and again, you get duplicate rows.

[@robert2001101]

Thank you for the helpful code tutorial. I'm having an issue with the column names not displaying properly though, they only show java.lang.String or java.lang.Integer. Could you help me with this please?

[@CSCORNERSunitaRai]

Check lines again given in my video

[@hoangngochieu17]

Could you tell me why I can't run JinternalFrame after extending it...

[@CSCORNERSunitaRai]

Do u hv main method?

[@Programyourmindset]

Very useful information thank you

[@CSCORNERSunitaRai]

You're welcome👍

[@harmonynamai3665]

Thanks a lot!! You saved my day.

[@CSCORNERSunitaRai]

Glad it helped you👍Do explore my channel for more stuffs✅

[@gladnn]

Would it be possible to make a custom column header instead metadata?

[@LostMellodies]

Amazing video, very helpful.

[@CSCORNERSunitaRai]

Glad you liked it👍 do explore my channel for more stuffs

[@mazedul1448]

Outstanding

[@CSCORNERSunitaRai]

Thanks

[@ranad2037]

Thanks a lot, you're the best

[@CSCORNERSunitaRai]

You're welcome!

[@eshaesha9100]

another question respected mam. How do i know which commands to use in the action Listener method. like you wrote so many command, database connectivity etc.. I mean is there any good guide for beginners?

[@CSCORNERSunitaRai]

This question is wrt to what ? If u r asking related to jdbc then depending on buttons we hv to write code

[@eshaesha9100]

@@CSCORNERSunitaRai yes mam, it is mainly related to jdbc

[@CSCORNERSunitaRai]

@@eshaesha9100 ok so when u click on add button write insert code, delete button write delete code and so on

[@moalnaim]

Thanks you really helped me with this

[@CSCORNERSunitaRai]

Glad I could help👍☺plz subscribe

[@jesty_internm-squared4867]

Really Useful one....

[@CSCORNERSunitaRai]

Glad it was helpful!

[@ruchankayastha3273]

thanks worked like a charm

[@CSCORNERSunitaRai]

Glad it worked👍

[@shaikhibnasazzad]

How to sort jtable data with the column?

[@SuhanasCreations]

Well explained 👍

[@CSCORNERSunitaRai]

Thank you so much👍

[@vijaykrishnagn]

Thank you for the video 😊👍

[@CSCORNERSunitaRai]

You're welcome👍

[@JoeCee789]

So i'm using NetBeans and i seem to have a problem with the tblData read the comments and couldn't find a working solution how do get the tblData to work

[@CSCORNERSunitaRai]

What error u r getting?

[@sarthakgupta096]

Thank you mam .

[@CSCORNERSunitaRai]

Most welcome 😊

[@S3Allinone]

Well explained

[@CSCORNERSunitaRai]

Thank you so much

[@natarajanparameswaran6752]

The code doesnt work if I want to retrieve from different tables

[@CSCORNERSunitaRai]

It works u need just modify according to your table design

[@natarajanparameswaran6752]

@@CSCORNERSunitaRai suppose I am having 2 tables one with 4 cols and other with 5 then for the second table the 5th col will be empty in jtable as we are reading only 4 columns

[@LeticiaGAlves]

THANK YOU SO MUUUUUCH!!

[@CSCORNERSunitaRai]

You're welcome👍 please subscribe

[@kartickmanna]

Hello, Mam. I want to display data in a table. The data are fetched from an excel.xlsx file stored in my local drive. How to do that preferably in IntellijIdea ?

[@pasha7748]

Hi, could you please tell me, where i can find the Table control name (in your case tblData)? Because when i use tblData and declare it in class, there is an error, which says: cannot invoke javax.swing.jtable.getmodel() because tblData is null... I dont know how to fix this. Could you please help me?

[@CSCORNERSunitaRai]

It's available in toolbox where u can see available controls just drag and drop

[@eshaesha9100]

respected mam, do we need any extension for the JFrame and the design view in Eclipse?

[@CSCORNERSunitaRai]

If u want to use eclipse u need to add window builder

[@CSCORNERSunitaRai]

Detailed tutorial on how to create swing in eclipse available on my channel under advanced java tutorial playlist

[@eshaesha9100]

@@CSCORNERSunitaRai yes mam, i just watched that tutorial. You are legend mam

[@CSCORNERSunitaRai]

@@eshaesha9100 thank you so much dear👍please share

[@francescalabonte4346]

Great video

[@CSCORNERSunitaRai]

Thank you so much👍

[@amithagolla6907]

very useful video...

[@CSCORNERSunitaRai]

Thank you so much

[@marshyadav7885]

model.setColumnIdentifiers() method is not displaying names of columns, no errors. Any solution?

[@CSCORNERSunitaRai]

Did you placed ur jtable control properly? Follow the way I have shown. Delete and place again

[@manohartimothy5825]

Hallo Sunita , I must say that you are a very good teacher and you explained it very well....Thanking you.. I will deffinatly follow you with your more vidios....Manohar

[@CSCORNERSunitaRai]

Thank you so for your kind words👍 Your comments motivates me for creating videos. Stay connected✅ God bless you

[@Tacoburger22]

Thank you so much!

[@CSCORNERSunitaRai]

You're welcome👍

[@hplat-vku]

thank u very muchhhhhh, u helped me

[@endmysuffering6847]

Hello, the first row ( the topmost ) is not showing up on the table how can I fix?

[@CSCORNERSunitaRai]

Ok I'll check.. When I tried it was working

[@endmysuffering6847]

@@CSCORNERSunitaRai I can send you my code because mine is alittle different from yours. Great vid btw!

[@CSCORNERSunitaRai]

@@endmysuffering6847 ok u can share on my telegram @cscorner

[@endmysuffering6847]

@@CSCORNERSunitaRai I was able to fix it I had to add the table to a jscrollpane. Thank you for responding still :)

[@saronaraphaelv.5878]

Hello maam can you help me mine says no sutiable driver found

[@CSCORNERSunitaRai]

Join my telegram and Please share screenshots of error. I will try to fix it

[@samoli02]

How to do it with date ?

[@CSCORNERSunitaRai]

U want to display date datatype?

[@rajapandey773]

I am getting this issue... Unable to parse source. WindowBuilder was not able to parse source private javax.swing.JTextField textField;.

[@CSCORNERSunitaRai]

Declare this variable in class not in constructor. Only Initialization in constructor

[@abusolo_3255]

if i want to display only 1 row, how i can do that?

[@CSCORNERSunitaRai]

You can use following method: jTable1.getModel().setValueAt(daya,row_index,col_index)

[@abusolo_3255]

@@CSCORNERSunitaRai can you please tell me where exactly to put this line ?

[@akashbro3786]

Mem addrow is not found. What i can do?

[@CSCORNERSunitaRai]

Hmmm, check my video again

[@jobinninan4481]

Thank you

[@CSCORNERSunitaRai]

You're welcome👍 please subscribe

[@developernilesh]

Thanks a lot, v nice👍

[@CSCORNERSunitaRai]

Glad you liked it👍Do explore my channel for more stuff

[@abunaseribrahimimani]

Madam, please can I request for a demo on adding pagination on Jtable using eclips

[@CSCORNERSunitaRai]

I'll try

[@reizsax]

Please help, my ‘rs.getMetaData()’ is error. It suggests that I add cast to ‘ResultSetMetaData’ or change type of ‘rsmd’ to ‘ResultSetMetaData’. And even though I followed the suggestions, the table data still doesn’t show.

[@CSCORNERSunitaRai]

Check your import. All jdbc related import should be from java.sql only

[@abusolo_3255]

7:52 you said "tblData" is your table name, but isn't your table name is "student"?

[@CSCORNERSunitaRai]

I mean JTable control name. Thanks

[@abusolo_3255]

@@CSCORNERSunitaRai where can i find my JTable control name?

[@abusolo_3255]

@@CSCORNERSunitaRai it shows me error in this line (under the "tblData" exactly ) DefaultTableModel model=(DefaultTableModel) tblData.getModel();

[@abusolo_3255]

and one of the solutions the program tell me to create local variable to "tblData"

[@abusolo_3255]

never mind, it work fine now, thanks, i just replaced "tblData" to "table" and it worked haha

[@r_nikolov1]

Thank you so much! =)

[@CSCORNERSunitaRai]

You're welcome👍 stay connected

[@jayanspaliwal5907]

Actually, I have another function in a different package that does the fetching part using a class in another package, How can I display data using that function, here are the functions: public ArrayList findAllStudent() { ArrayList al=new ArrayList(); conn=ConnectionPool.connectDB(); String query="select * from student"; try { Statement stmt=conn.createStatement(); ResultSet rs=stmt.executeQuery(query); while(rs.next()) { StudentBean sb=new StudentBean(); sb.setEnrollmentno(rs.getString("Enrollment")); sb.setName(rs.getString("Name")); sb.setAddress(rs.getString("Address")); sb.setBranch(rs.getString("Branch")); sb.setCollege(rs.getString("College")); sb.setSemester(rs.getInt("Semester")); sb.setGender(rs.getString("Gender")); sb.setSubject1(rs.getFloat("Subject1")); sb.setSubject2(rs.getFloat("Subject2")); sb.setSubject3(rs.getFloat("Subject3")); sb.setSubject4(rs.getFloat("Subject4")); sb.setGrade(rs.getString("Grade")); al.add(sb); } conn.close(); } catch (SQLException e) { e.printStackTrace(); } return al; } The connectionpool class: public class ConnectionPool { static Connection conn; public static Connection connectDB(){ try{ // register driver Class.forName("com.mysql.cj.jdbc.Driver"); // create the connection conn=DriverManager.getConnection("jdbc:mysql://localhost:3306/studentdb","root","space"); System.out.println("Database connected"); } catch (ClassNotFoundException ex){ ex.printStackTrace(); } catch (SQLException e) { e.printStackTrace(); } return conn; } }

[@prasannaj384]

What is this eclipse ide version mam? Send the comment box that link

[@prasannaj384]

Because that swing set that package not available mam in my ide

[@CSCORNERSunitaRai]

Eclipse IDE for Java Developers - 2021-06

[@CSCORNERSunitaRai]

If you want to get swing related stuffs you need to add WindowsBuilder. Refer this video :kzbin.info/www/bejne/opTXi2CEdryaerc

[@GT-cv3xu]

thanks♥

[@CSCORNERSunitaRai]

You're welcome👍

[@hirunishamalka3283]

how to get data from database to JTable in selected one column

[@AshishKalgutkar]

mam pura code dekha diya hota toh kya ho jaat ?

[@CSCORNERSunitaRai]

Iski full video hai channel par. Chk karo

[@leandrolara7450]

Damaste or Thanks or Graciassssssssssss : ,}

[@CSCORNERSunitaRai]

You're welcome👍 keep watching

[@WitleRose]

@Eduardoo sai do fake caraio

[@prernaparwani3074]

Java.awt . eventdispatchthread exception occurred

[@babyph65]

getModel() is not working on me

[@CSCORNERSunitaRai]

Is it showing any error

[@babyph65]

@@CSCORNERSunitaRai my compiler has some error so I re- installed it, its fine now. Thanks ♥️

[@CSCORNERSunitaRai]

@@babyph65 yes

[@Nishantkumar-sr2bu]

maam i got a problem with tbldata.getModel() its showing that it can't be resolved please help

[@CSCORNERSunitaRai]

Declare tblData inside class. It's not able to find variable tblData