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

[@_bahii5226]

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

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

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

[@mikejwarr]

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

[@TechProgrammingIdeas]

Welcome my java tutorials

[@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.

[@bemshimamichael5852]

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

[@TechProgrammingIdeas]

Visit my java tutorials

[@buivanthinh4167]

Thank you bro , from VietNam with love

[@MateusMeurer]

Indra this video is awesome, thank you!

[@indrasubedi]

Thabks for your feedback

[@harvinderlaliya2023]

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

[@zimongo9777]

Thank you your video really helps a lot

[@anghiaao444]

very good. Thank you very much for your support

[@katanaspaun7997]

thanks a lot.really helped me with our project

[@indrasubedi]

Thanks for your feedback

[@manishshrestha9176]

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

[@williamgriffith2822]

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

[@akhtarrnd4012]

Thank you for such a working code

[@zaishu3247]

Thanks, you save my life

[@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

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

Awesome tutorial , really helpful!!

[@khoanguyen7878]

It's that Good ! Thanks you very much

[@nouredineyoussouf4843]

Thank you so much Indra

[@LalGebi]

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

[@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.

[@RezaZen]

really helps, thanks a lot man, appreciated

[@Kei-iq6gn]

it worked, thank you so much :))

[@TechProgrammingIdeas]

Hello welcome my java tutorials

[@andododo]

That was a great tutorial my dude. Thanks!

[@TechProgrammingIdeas]

Welcome my tutorials

[@simoyland]

thank you helped me a lot!

[@joaovitorsabino5610]

você é um anjo

[@bishalshiwa4316]

helped me a lot :)

[@indrasubedi]

Thanks Man

[@MrLipelarizzatti]

thx budy! nice video btw!

[@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

[@vishaldevgiri]

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

[@lifeissoft]

Good work, keep going.

[@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

[@NamNguyen-fn5td]

thanks for your video !!

[@medonnaparker7294]

Nice work

[@indrasubedi]

Thank you

[@mootunzych4236]

thank for help

[@TechProgrammingIdeas]

Yes Visit my java tutorials

[@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

[@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.

[@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?

[@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

[@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!

[@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()

[@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.

[@felex_benjamin]

thanks a lot for this

[@musharraffaheem3778]

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

[@indrasubedi]

Please check the sql query.

[@vsevolodtsukanov7917]

Why in this video you use Statment insteed PreparedStatement ?

[@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.

[@UVizGaming]

Great. Thanks bro.

[@khadakbdrbudha3450]

Nice videos.

[@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

[@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

[@shubhamscreation9154]

In which class are you ?

[@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?

[@aaronjay300]

Thanks bro.

[@indrasubedi]

Thanks for your feedback.

[@shahidmehboob8862]

great video

[@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!

[@thecatwithoutatail5420]

Can I use this with MySQL?

[@yodahezerihunkassa160]

Thank You man!

[@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

[@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.

[@seanpaulo6761]

Thank you so much!

[@TechProgrammingIdeas]

Welcome my tutorials

[@ajithraj1206]

Thank You bro , love You();

[@TechProgrammingIdeas]

Visit my tutorials jaava

[@princealbaloshi5125]

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

[@lakshmisheshadri6263]

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

[@jamespui9302]

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

[@bryansie1047]

is this the onylyway to do it?..

[@herbertmarumbu9517]

Good love it

[@charlespakpahan6469]

nice video dude

[@prashiksahare789]

Will you upload your code in the description?

[@indrasubedi]

Go to the link : goo.gl/N9U38E

[@jiysea]

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

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

Thank You

[@kamilorado6979]

Great! Thanks bro

[@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

[@Engmays-bj9gr]

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

[@oanaghicajanucristina]

I LOVE YU THANK YOU SO MUCHHHHHHHHHHHHH

[@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

[@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

[@tomaslopez9999]

Thank you!

[@kansyakar12]

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

[@sayuogiwara632]

Thank you:3

[@gunjanjha9123]

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

[@jayamadhukachandramal4328]

thanks

[@HausToys]

please add a date option

[@lloydtatendachimanga1424]

Haus Toys instead of string or int just type date.

[@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

[@_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?

[@rachellemejia9723]

THANKS!

[@indrasubedi]

Thank you for feedback

[@lloydtatendachimanga1424]

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

[@farrukhhussain8211]

Good

[@jeromevalencia29]

How to show only same data in jtable?

[@tranvanngoan2780]

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

[@amit_kaushal5701]

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

[@kashiking7936]

I am getting error getModel in DefaultTableModel.

[@-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

[@sethayous7917]

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

[@TechProgrammingIdeas]

Welcome my java tutorials

[@ma.roderenequiambao4916]

My columns are not showing :(