Display data from SQL database into jtable in java

[@jazmincappo6625]

Look, I'm from Paraguay (a small Country between Argentina and Brasil in South America which majority speak spanish and "Guarani" Our native language from our ancients) I want to send my Congratulations because nowadays your videos still help people and let me just say an enormous THANK YOUUUUUUU

[@d0odle]

You have no idea how much this hepled me. Not only that I integrated this into my project but I also integrated it too the other classmates who were struggling with the table.

[@indrasubedi]

Glad to hear it helped.

[@alastorcodm159]

after looking for more than 5 hours, finally I found your video that helped me a lot, thx

[@indrasubedi]

Happy to hear from you.

[@angwei6221]

To anyone watching in 2021: this stuff works thanks bhai

[@சூ.பிரவின்குமார்]

Tanq today started with ur video and it made my day peaceful

[@indrasubedi]

Hello My Brothers and Sisters. My humble request to you, *Please* *Don't* *Forget* *To* *Subscribe* If you have any problem, Comment down. I will provide you solution as soon as possible.

[@mikejwarr]

Really good tutorial. Thank you Indra. Great video, Job well done.

[@TechProgrammingIdeas]

Welcome my java tutorials

[@_bahii5226]

Superb ......You Have Done Good Job Thank You so Much

[@buivanthinh4167]

Thank you bro , from VietNam with love

[@bemshimamichael5852]

Thanks a lots hope your coding Will takes us to the next level really appreciated

[@TechProgrammingIdeas]

Visit my java tutorials

[@arthurtan2088]

Hi Indra, can u show us some way to view the data? 1) a user may choose the keywords from a "text field". example when user key in keywords with "thur" in the "text field", all the data name with "thur" will show out such as Arthur Tan, Lexthur, Exthur and etc. 2) choosing to view name that ages with more 21 years old. 3) then a user may view the data by clicking it become ascending or descending.

[@indrasubedi]

Thanks. I will prepare and upload soon

[@LalGebi]

Million thanks... Pl. make a video on fetching data from Relational database( more than one table) and populating in JTable..

[@almariomiano8995]

Hi Indra! I became your student since I started programming (Java). The thing that hit me so bad is that "How I can display multiple Images from database to multiple jlabels?" I have followed all your steps and that is good. And I am now begging for your aid. please reply ASAP! :)

[@indrasubedi]

Watch my other video, i have done there to display single image. Watch it and you may get some idea

[@hythamtikka]

table.setModel(DbUtils.resultSetToTableModel(rs)); only one single command can save time. You can use import net.

[@ProSuddenAttack]

I have tried to retrieve data from database using this line. The data can be retrieved, however the column name will change to what is in my database column name.

[@ProSuddenAttack]

And this line cannot display the boolean checkbox.

[@MateusMeurer]

Indra this video is awesome, thank you!

[@indrasubedi]

Thabks for your feedback

[@katanaspaun7997]

thanks a lot.really helped me with our project

[@indrasubedi]

Thanks for your feedback

[@joaovitorsabino5610]

você é um anjo

[@vsevolodtsukanov7917]

Why in this video you use Statment insteed PreparedStatement ?

[@AllanBenABJ]

a very good one. I wanted to create the User class in another package but always encountered errors even when importing the package. Would you mind explaining how I can do that. Also, i needed to combine and display data from three different tables in my database. Will everything remain the same except the query and of course the rows declared in the code? Please help me get a general understanding or a link you have done that. thanks a lot.

[@vishaldevgiri]

"java.lang.unsupportedoperationexception not supported yet" i am getting this error can you plz tell me how to fix this?

[@sadammann2650]

Why do you store your objects inside an array list if you send it to the database? You can retrieve from the database any time, whereas all the data from an array list will disappear as soon as you close the program.

[@anghiaao444]

very good. Thank you very much for your support

[@williamgriffith2822]

Please come to Brazil, we love you so much. Hugs and kisses from Cuiabá- MT. Bruno lindão

[@harvinderlaliya2023]

Thanks a lot,easy to follow tutorial and awesome implementation!

[@manishshrestha9176]

thanks a lot for this amazing tutorial. It is really very useful.

[@zimongo9777]

Thank you your video really helps a lot

[@zaishu3247]

Thanks, you save my life

[@nouredineyoussouf4843]

Thank you so much Indra

[@akhtarrnd4012]

Thank you for such a working code

[@IllegalAlien51]

Indra, I'm having issues the way it's displaying the data in the jTable, it's not ordered correctly, the first 4 rows are empty (All the data are displayed below it), why? It's not the same in my Sql server database, they are ordered correctly. I remember adding and deleting records, is that the problem?

[@indrasubedi]

Please check the code below the for loop.Its due to settext improperly

[@IllegalAlien51]

No it's the same, but I still fixed it by adding "model.setRowCount(0)" before the for Loop.

[@priyanshisolanki8650]

Can u please share ur code?? I am having problem in adding JScrollPane

[@IllegalAlien51]

I already mentioned it. That's all I changed.

[@nuzzy_nuz]

like he has showed in the video, u should remove the 4 empty rows right click on jtable > properties > rows tab > make the rows count 0

[@signalsandsolutions618]

Can u explain about userList() method where it has been called before.?

[@lloydtatendachimanga1424]

Vee Eee Technologies im stuck there as well, did you find a solution?

[@ikosimisimo3363]

I've put a JTable into a JScrollPane and executed my query into it (the code is 100% correct). The problem is that it only shows n-1 results!!! If there's only one line to select the table remains empty!!!!! Any help?

[@arthurtan2088]

Hi indra, For un-fill in data in the "JTextField" is using ~ boolean function with (name_vri.getText().isEmpty() ~ may i know if untick and unchoosing the "JRadioButton", "JCheckBox" and "JComboBox" are what coding? please.

[@arthurtan2088]

thanks for showing us the "validate form in java" in ur latest video.

[@shubhamscreation9154]

In which class are you ?

[@mrsylla9533]

you have done a great job. But i want to know how can i do to use a java program without sql. my problem is to have an exportable database to be able to use the program in another computer without having to instal xamp or any other server. thank you so much!

[@theishingkhuishimray1892]

i also have same problem. but seeing that this comment is 3 years old. do you have a soln

[@ferhatd6415]

​@@theishingkhuishimray1892 h2 database where you can save your sql database in a file instead of using a sql database server

[@priyanshisolanki8650]

While running the code a pop up message is shown "Result set has no current row" when i click ok then no data is displayed in JTable ... Code has no errors and data is also getting stored in database but not getting displayed in JTable... Please help!

[@illyriaks]

Hi Indra, please can you tell me which is the code to see data on table not to update or edit, only code which call data from db example table users.

[@indrasubedi]

Ka Speri show_user()

[@bokiesylaphet2248]

good guy and thank you so much for you shared, hope you'll release new video asap!

[@indrasubedi]

You can find latest videos in my channel

[@ahmedabdul-razak4701]

hello, indra. i have a problem with after while user=new user(rs.getInt("id") i finished these but showing error "no suitable method found for getstring"? could u help me pleass?

[@indrasubedi]

Have you create the user class constructor and place all the variables in that constructor? and its user = new User(rs.getInt("id") if you cannot solve it again. send the screenshot of the code at [e-mail]

[@ahmedabdul-razak4701]

check your email please thank you

[@alex_kq]

give source code please, man

[@thecatwithoutatail5420]

Can I use this with MySQL?

[@bryansie1047]

is this the onylyway to do it?..

[@mrsylla9533]

gréât videos. i still have a question. how can.i do to compile and use a java project with the database inside. i've tryed to see whether i could use derby but it didn't work. what i want to do is to be able to use this project on another computer without having to instal an sql server. thanks!

[@jamespui9302]

what if i want to display blob image from database into the table ??

[@astiginko]

How do you open 2 data from the database into jtable with just one jtable? example one data has 5 columns and the other has 10 columnns, how will the jtable adjust to that?

[@TechProgrammingIdeas]

Hai Welcome my java tutorials

[@jeromevalencia29]

How to show only same data in jtable?

[@jiysea]

Can u teach us how to insert row with boolean values?

[@mootunzych4236]

thank for help

[@TechProgrammingIdeas]

Yes Visit my java tutorials

[@arthurtan2088]

Hi Indra , does the "JComboBox" able to insert an image? Can u show us some please.

[@indrasubedi]

I haven't gone through it. But i have used jlabel to insert an image. You can find it on; kzbin.info/www/bejne/pam3Y3pqnN2mrsU

[@arthurtan2088]

ok.t.q

[@ma.roderenequiambao4916]

My columns are not showing :(

[@tranvanngoan2780]

Thanks, but how i can do if i only used awt? ( sorry but ít’s my homework:

[@khaledrashad6921]

please can you help me i have an error with this String url="jdbc:derby://localhost:1527;databaseName=registration;user=khaled;password=123"; it says it is not properly formed, i'm using netbaens database. i followed you step by step

[@prashiksahare789]

Will you upload your code in the description?

[@indrasubedi]

Go to the link : goo.gl/N9U38E

[@lloydtatendachimanga1424]

Where did userList() come from, its giving error...

[@khoanguyen7878]

It's that Good ! Thanks you very much

[@princealbaloshi5125]

hi indra help me how to i update my sql data using netbeans

[@kroloth]

Thanks for the video Indra!! When I put: ArrayList list = userList(); I get an error cannot find symbol userList. Any help with that?

[@TechProgrammingIdeas]

Welcome my tutorials

[@-indeed8285]

great video.. help me please. I'm Ubuntu user but i want work on SQL database. problem is I can't understand which software I should use ? #1 ( oracle sql developer) or #2 (oracle sql database 11g) . {Note: I have installed Java8}

[@indrasubedi]

If ubuntu supports these database, you can use any one of them which you feel easy. Coding is same, you only need to change the database connection code while working using other database

[@zeynep8152]

Exception in thread "AWT-EventQueue-0" java.security.PrivilegedActionException: java.security.PrivilegedActionException: java.sql.SQLException: Invalid operation at current cursor position. it says that error

[@Engmays-bj9gr]

هل يوجد فكرة Master-Details بالجافا؟؟

[@andododo]

That was a great tutorial my dude. Thanks!

[@TechProgrammingIdeas]

Welcome my tutorials

[@saritalad8923]

can you tell how to give path of image in swing to display image on JFrame?

[@indrasubedi]

I have displayed image in jlabel. You can find the video in my playlist.

[@mukulsharma5624]

First Create JFrame. then create a Panel from Palette. now right click on newly created panel then click Set Layout then Null Layout. Increase the size of created panel by drag. then create a lable from Palette. Increase the size of created lable by drag. (Note that the size of Jframe, panel and lable are coinside each other or same size. ) now final step Right click on your created Lable then select properties In properties window click on icon, and browse any picture and then ok.

[@sarthaksourav5753]

can you tell me how to use the same program but using button...

[@indrasubedi]

Just place the code in the mouse button action performed event

[@sarthaksourav5753]

I have tried bt I face errors

[@sarthaksourav5753]

there is no syntax or runtime error bt data is not getting placed in jtable

[@gunjanjha9123]

i am getting StackOverflow error while using this code will you pls help me.

[@saritalad8923]

good but voice is very low

[@indrasubedi]

Thanks for feedback. I will manage in the comming videos

[@_imatto8719]

bro how to do like if i login with indra as an example i see some content, but if i login with admin i see whole content?

[@rahulkumar-ds7pi]

Hello sir I am working on an application where I want to move a row data from one table to another table using a button. Please guide me

[@kashiking7936]

I am getting error getModel in DefaultTableModel.

[@HausToys]

please add a date option

[@lloydtatendachimanga1424]

Haus Toys instead of string or int just type date.

[@medonnaparker7294]

Nice work

[@indrasubedi]

Thank you

[@ΠαναγιώτηςΚαμπάνης-υ4ξ]

Awesome tutorial , really helpful!!

[@lakshmisheshadri6263]

Bro need your help I need to display data in subsequent j frames how to do

[@kansyakar12]

sir mujhe SQL table ko eclipse table me data ko dekhana hai to kya kren?

[@kansyakar12]

sir aaplog keval netbeen pr video banate hain . eclipse pr bhi bnaya kijiye. eclipse jatable and sql ka eak video banayiye sir please

[@indrasubedi]

Thanks for your feedback. I will try to manage soon

[@simoyland]

thank you helped me a lot!

[@ปิยะวัฒน์ขนานขาว]

Thank You

[@herbertmarumbu9517]

Good love it

[@jayamadhukachandramal4328]

thanks

[@NamNguyen-fn5td]

thanks for your video !!

[@amit_kaushal5701]

Bhai null pointer exception AA Raha hai....database connect Nahe ho Raha hai

[@bassirisawadogo8101]

incompatible type int cannot be converted to org.omg.CORBA.Objet the row table reports a compatibility problem.

[@dogthatlooksattaxevaders6325]

my array list is not working help

[@khadakbdrbudha3450]

Nice videos.

[@musharraffaheem3778]

At 18:50 , I have an error of incompatible conversion : String cannot be convert to Object

[@indrasubedi]

Please check the sql query.

[@RachanaPadmanabhan]

Am having error has strings cannot be converted into int

[@RachanaPadmanabhan]

The error is in the line user=new User.....

[@indrasubedi]

@@RachanaPadmanabhan Did you create the user class?

[@RachanaPadmanabhan]

@@indrasubedi yeah I have done...thanks fr the video

[@yodahezerihunkassa160]

Thank You man!

[@aaronjay300]

Thanks bro.

[@indrasubedi]

Thanks for your feedback.

[@kansyakar12]

mai eclipse se values ko SQL me insert kr le rha hun lekin use apne eclipse me us SQL record ko nhi dekh pa rha hun please help sir

[@seanpaulo6761]

Thank you so much!

[@TechProgrammingIdeas]

Welcome my tutorials

[@farrukhhussain8211]

Good

[@felex_benjamin]

thanks a lot for this

[@tomaslopez9999]

Thank you!

[@UVizGaming]

Great. Thanks bro.

[@sethayous7917]

I got error on public void show_user(){ ArrayList list = new userList(); } Please help

[@TechProgrammingIdeas]

Welcome my java tutorials

[@krishnachaitanya2522]

hello im getting an error like this javax.swing.JCheckBox.awt.EventQueue.invokeLater

[@krishnachaitanya2522]

can u help me with that

[@indrasubedi]

You have got the error on checkbox.please be sure that you have done as like that of mine

[@krishnachaitanya2522]

Ya ok thank u I got it but everything is inserted but sno is not inserting

[@indrasubedi]

no need to insert sno manually. just auto increment it from database.

[@krishnachaitanya2522]

Ok thanks

[@festivo2420]

where did you get jTable_Display_User.getModel();

[@indrasubedi]

jTable_Display_User is the name of jtable and getModel() is used by a JTable when no table model is specifically defined by the programmer

[@festivo2420]

thank you brother

[@tubagusputra5788]

I got an error!!

[@lifeissoft]

Good work, keep going.

[@oanaghicajanucristina]

I LOVE YU THANK YOU SO MUCHHHHHHHHHHHHH

[@shahidmehboob8862]

great video