I did the same thng, but want to display numeric fields.It is displayig but the allignment is left. Numeric field,allignment shud be right. Is there any way to mke it right alligned
Could u please tell me how to type for a particular data in the text field and search its details from the database and display it in the jtable in front end
Manmeet Kaur you can easily do... tht u just hv to store d data in ur database... using text fields and jbutton... thn u can fetch it data .... from ur database...
Manmeet Kaur you can easily do... tht u just hv to store d data in ur database... using text fields and jbutton... thn u can fetch it data .... from ur database...
Hlo sir ..sir jab mai where clause use karta hu select statement k sath to data fetch nhi hota ..agar mai where clause k sath koi int type ki value rkta hu jaise (id,age,salary) to data fetch ho jata hai .matlab problem hai Characters k sath
@@GSoftknowledge select * from employee where job ='Manager' ; Or Select * from employee where age =34 ye perfect chlta hai Sir mai ek project bna rha hu usme ye problem aa rhi hai
sir i made project whic is about calculator .In design all things(label,button,flex area etc) which is hide but their source is left can you tell me how is it fix?
Please solve my problem it will give me Null pointer exception.I checked all my database table there is no any empty column and also there is no connection problem why this problem is happening.Please Help Me Its Urgent.
Its my problem i have database problem my sql server get crash so after restarting xampp it fixed thank you so much for you help and for your useful video. Sorry but I ask you one thing i am working on my third year project so if i got some problem can i contact you on your fb page.
@@GSoftknowledge Thanks for telling me bro. i think i should complete this project but i will refer it to my friends.Thanks For Your Support. This is first channel who help me and response to my query. Hats off you bro.and very very thanks
u hv set both jtable n jbutton as public... from the properties option in code window... then u hv to call jtable as.. ex: jframeName.jtable1.set...... and so on..
I have created a GUI which can display inputs in jtable instantly. I would like to let the user a "save as" file option and save it in anywhere on the computer and open this saved file in GUI anytime. Just like saving a file with Microsoft Office Excel and opening it anytime later, make addition and removes. I would like the user to be able to open and save many files on request. Is it possible in Netbeans? Watching your video, it seems I have to create a table in SQLite manager each time I wish to save a different file. Your help and advice will be greatly appreciated. Thanks
Thank you very much for your reply. Have you got a link for this? I have only just managed a code for this it compiles but I cannot open it or redisplay it on jtable again. My code is: private void saveBtnActionPerformed(java.awt.event.ActionEvent evt) { try { FileOutputStream fos = new FileOutputStream("Details.data"); ObjectOutputStream oos = new ObjectOutputStream(fos); oos.writeObject(this); } catch (Exception ex) { System.out.println("Problem storing state of Details"); System.exit(1); } Opening this file with notepad I can only view some code type text, not my table or the data entered in it. I appreciate very much for a help. Thanks
In public main(), there is one statement con=sql_connect.CennecrDb(). What is this?? And I have add rs2xml jar in library but still doen't show data in JTable. How to solve it?
@@GSoftknowledge I followed the steps on your video, the exactly same, no errors at first but when I run it, my login page is fine but my menu page, when I click the button calculations which will lead to my J Table for database, it can't. And then my output project said Exception in thread "AWT-EventQue-0" java.lang.UnspportedOperationException : Not supported yet.
i want to add a button column in jtable is it possible to add and what i have to do populate it in jtable in every row entry.. and i also have to perform action on that button but i haven,t taken that button column in database but i want it in my jtable so that so that i can perform action event from that button i wiil be highly thankful if you help me out.....
I want one more column in jtable in which there should be a login button for every records so that on clicking login button we can redirect to the next frame
is isnt working for me? For the save button what is the code? Also could you send me the source code for the whole thing or just the part where the data is added into the database as I do not know where I am going wrong. HOW TO FIX Dbutils?? Also fetching the data is not working for me although it shows no error and I have followed each and every step correctly.
here's my code can't figure out what's wrong with this I want to insert data without the need of typing the ID coz that should be auto increment, right? try { String sql="insert into inventory_tbl values(?,?,?,?,?)"; pst=conn.prepareStatement(sql);
Hi there Gsoft thx i was being an idiot i forgot to add that jar file ...spent like 2 hours finding and alternative but when i went back to look i noticed i hadnt added it lol ...thanks so much for ur help the videos u uploaded are really helping me alloot
![JAVA - How To Add Row To JTable From Another JFrame In Java NetBeans [ With Source Code ]](http://i.ytimg.com/vi/XWpxl1aCOyU/mqdefault.jpg)
![JAVA - How To Add Row To JTable From Another JFrame In Java NetBeans [ With Source Code ]](/img/tr.png)
Very helpful video brother 👍👌
Keep supporting.!!!
Thanks man ur helping us UK people
an error to do with DbUtils
I did the same thng, but want to display numeric fields.It is displayig but the allignment is left. Numeric field,allignment shud be right. Is there any way to mke it right alligned
Could you please tell me where can i watch all the videos of this project
please help me, what app you use to get a Table name?? thankyouu
You can get the table name from the propertirs of the table..
one more question sir, what is pst=con.prepareStatement(q);? because I try your code sir and I see errors thankyou somuch sir
@@darwincarawana9898 con is the connection thn u prepare the statement in q variable for execution...
thankyouuuu so much sir, What is DbUtils?
Thank You so much its helps me in 2021🥰🥰
Keep supporting ❤️
the last part where you fetch(); does not work like on the video pls help!
I have created a function with the name fetch.
Check the full video...
@@GSoftknowledge nvm bro its fixed now.. thank you for the video
❤️❤️❤️
@@glockt3ch968 keep supporting ❤️
Could u please tell me how to type for a particular data in the text field and search its details from the database and display it in the jtable in front end
I have created a seperate video for search option.
th-cam.com/video/N9ZXYk2hVaM/w-d-xo.html
Check this
What is DBUtils?
what if i want to show the data into the table according to the data entered in the textfields in the previous jFrame. how to do that?
Manmeet Kaur you can easily do... tht u just hv to store d data in ur database... using text fields and jbutton... thn u can fetch it data .... from ur database...
Manmeet Kaur you can easily do... tht u just hv to store d data in ur database... using text fields and jbutton... thn u can fetch it data .... from ur database...
okay. Thanks!
I keep on getting the nullpointerexception what might be the problem
Check ur connection and database path.
same here
Sir make same data fetch procedure in Ms access
Thanks ... Pl. make a video on fetching data from Relational database( more than one table) and populate JTable
great video buddy, helped me a lot with a project i was building, thank you!
Tommy X. Gomez Garcia thanks for your support...
Really really thank you...
Keep supporting ♥️
Can you help me, ..
refreshing jTable automatically in this jFrame..
From another Form.
Yes I have created a video for the same!!
@@GSoftknowledge I cannot find it Sir.
From another frame is possible... Okay I'll create a video on this...
You will have to inherit the table. Then u can update or refresh the table from other frame.
Hlo sir ..sir jab mai where clause use karta hu select statement k sath to data fetch nhi hota ..agar mai where clause k sath koi int type ki value rkta hu jaise (id,age,salary) to data fetch ho jata hai .matlab problem hai Characters k sath
Sql query kya bana rhe ho yha bhejo?
@@GSoftknowledge select * from employee where job ='Manager' ;
Or
Select * from employee where age =34 ye perfect chlta hai
Sir mai ek project bna rha hu usme ye problem aa rhi hai
Error kya aarahi h?
@@GSoftknowledge koi error koi exception nhi hai frame bhi aata but data fetch nhi hota ..jab where clause k sath character use krta hu
Go to ur DBMS and check the value stored in job column I think there is space in the character
Very simple and very nice👏
Thanks for ur support...
which package I have to import for DbUtils to work , I added rs2xml Jar file to library but program fails at DbUtils.resultSet....
Samiksha Argade rs2xml jar file... That's it.. what's the error
friend i input rs2xml file to library, still DbUtils showing error...
sir i made project whic is about calculator .In design all things(label,button,flex area etc) which is hide but their source is left can you tell me how is it fix?
Check on navigator window..
Please solve my problem it will give me Null pointer exception.I checked all my database table there is no any empty column and also there is no connection problem why this problem is happening.Please Help Me Its Urgent.
Share the code screen shot on my FB page..
Its my problem i have database problem my sql server get crash so after restarting xampp it fixed thank you so much for you help and for your useful video. Sorry but I ask you one thing i am working on my third year project so if i got some problem can i contact you on your fb page.
Readymade project is also available .. if u need let me know
@@GSoftknowledge Thanks for telling me bro. i think i should complete this project but i will refer it to my friends.Thanks For Your Support. This is first channel who help me and response to my query. Hats off you bro.and very very thanks
Keep supporting brother!! ❤️
Is it possible to program it so that when you click one of the table entries, it brings its data back to the jtextfields?
TheLKStar ya it possible check out this video.. th-cam.com/video/qX0yf60ZeC4/w-d-xo.html
my windows defender is showing this rs2xml.jar file as harmful. so can it be added in computer
Shubhashish Das disable it windows defender..
hi guys! where can i download rs2xml.jar for free? i can't find it.
null pointer exception message what to do my database connection is right
Share the code screenshot with me.. on my fb page
How to fetch selected data on jtable and fetch it on jasper report?
I have created a video for the same.. please check my channel
Im getting this error java.lang.NullPointerException
can you help me with this one?
Your SQL is returning empty column or data. That's y.
GSoft Knowledge I can’t understand why
@@alexandruiuras5145 share screen shot on of your code on my FB page.
GSoft Knowledge I send you a private message
Hi , how to display only certain data from database n display it in jtable ? Im currently doing point of sales system .
fatin shafiqa you have to use limit code in SQL command.. to show limited data.
i'm getting problem in updating data...i'm not getting Dbutils statement..i have oracle database
mangesh khedekar I hv created a video on how to update data... chck it out.
Thank you so much..... it works for me
Thanks fr ur support..!! 💓
I need to populate the table present in first Jframe from database on the click of button present in second Jframe.how to do this??please help..
u hv set both jtable n jbutton as public... from the properties option in code window... then u hv to call jtable as.. ex: jframeName.jtable1.set...... and so on..
Thanks a lot..it worked for me
rahul mishra pleasures all mine.... thanks for ur support...
Hey man can you tell me how to fetch the data from the into the database ??
I have shown this in the video... Any problem ur facing with it?
@@GSoftknowledge oops.. I meant like I want to insert the table data into the database is that possible?
@@amalsathyan5530 Yes of course
@@GSoftknowledge same code you've shown or something different?
@@amalsathyan5530check this it will help you
th-cam.com/video/xRSSdT2dP58/w-d-xo.html
I have created a GUI which can display inputs in jtable instantly. I would like to let the user a "save as" file option and save it in anywhere on the computer and open this saved file in GUI anytime. Just like saving a file with Microsoft Office Excel and opening it anytime later, make addition and removes. I would like the user to be able to open and save many files on request. Is it possible in Netbeans? Watching your video, it seems I have to create a table in SQLite manager each time I wish to save a different file. Your help and advice will be greatly appreciated. Thanks
yes it is possible you can use only text file like notepad..
Thank you very much for your reply. Have you got a link for this? I have only just managed a code for this it compiles but I cannot open it or redisplay it on jtable again. My code is:
private void saveBtnActionPerformed(java.awt.event.ActionEvent evt) {
try
{
FileOutputStream fos = new FileOutputStream("Details.data");
ObjectOutputStream oos = new ObjectOutputStream(fos);
oos.writeObject(this);
}
catch (Exception ex)
{
System.out.println("Problem storing state of Details");
System.exit(1);
}
Opening this file with notepad I can only view some code type text, not my table or the data entered in it.
I appreciate very much for a help.
Thanks
Leman Rex don't worry send me the code screenshot on my FB page...
I'm getting error at initComponents()
and table name
Please share a screenshot of the error.. you must have missed some bracket to close..
I have an error "java.lang.NullPointerException" Please help
me2,did you found a solution?
why im facing the problem of prepared statement has been finalized whenever i try to add something in the database
Mahar Hassan send me d screenshot of the error on my Facebook page
GSoft whts ur fb page?
Mahar Hassan check d link in the description... of the video
facebook.com/grvtechy/
i got column Names but no index. Thnx a lot.
I an getting error in sql_connect.... Can u tell me how to solve this plzzzzzz
What's the error?
Red line is coming under sql_connect
@@Saloni_-qo4jf check this video
th-cam.com/video/HFYdjfRRQtA/w-d-xo.html
In public main(), there is one statement con=sql_connect.CennecrDb(). What is this??
And I have add rs2xml jar in library but still doen't show data in JTable. How to solve it?
con=sql_connect.CennecrDb();
this statement is used to call your database connection.
write the code correctly it will surely work..
I have tried it but in sql_connect, it shows error. It says cannot find symbol. How to solve it?? It is stuck in this one only.
priya rajkumari send me the screenshot of the error n code on my Facebook page
I have send it... And even there is more problems I need to ask about my project so I think you help me out. Thank you so much for precious reply
hey what ended up being your issue because im having the same issue
I can't move to the next screen, how to do it?
What Please explain, what problem ur facing.
@@GSoftknowledge I have no errors but when I run it, when I click the button, it didn't move to table screen.
@@muhdimran7613 What code u have written...?
@@GSoftknowledge I followed the steps on your video, the exactly same, no errors at first but when I run it, my login page is fine but my menu page, when I click the button calculations which will lead to my J Table for database, it can't. And then my output project said Exception in thread "AWT-EventQue-0" java.lang.UnspportedOperationException : Not supported yet.
i'm getting problem in my con=sql_connect.ConnecrDB(), they tell me if cannot find symbol method ConnecrDB(). PLease help me out. thanks
immanuel warae u have to add the jar file which I hv showed in d video....
i already add it sir but it still error.
immanuel warae send d screenshot of the code and error too.. on my FB page.
i want to add a button column in jtable is it possible to add and what i have to do populate it in jtable in every row entry.. and i also have to perform action on that button but i haven,t taken that button column in database but i want it in my jtable so that so that i can perform action event from that button
i wiil be highly thankful if you help me out.....
lucky singh wht u want to store... I mean I don't get you properly.
I want one more column in jtable in which there should be a login button for every records so that on clicking login button we can redirect to the next frame
sir if u don't get me please reply me I will send u the image and explain my problem more clearly to you
lucky singh ya it is possible
lucky singh send d image on my Facebook page.... I will surely help... u
its very helpful
Why my DbUtils isnt working even i already import the jar file?
Tengku Nurtasha whts d error coming??
it says cannot find symbol
Tengku Nurtasha you have to import d sqlite function.. in source code window
can you give me the sqlite function? Sorry im a beginner
will this work for mysql worbench as a server?
jishnu moorthy yes.
is isnt working for me? For the save button what is the code? Also could you send me the source code for the whole thing or just the part where the data is added into the database as I do not know where I am going wrong.
HOW TO FIX Dbutils??
Also fetching the data is not working for me although it shows no error and I have followed each and every step correctly.
how to populate jTable with int type date from sqlite database
how to fetch data in java from sql server management studio
hi guys! where can i download rs2xml.jar for free? i can't find it. please help me.
how to do the login frame that leads to main frame?
Calvin Tee easily it can b done check my other video I have shown. it.
how to set the jtextfield when you select a row?
I have made a video for the same plz check.
@@GSoftknowledge i checked it sir thank you for the knowledge
@@SugoikGaming problem solved??
@@GSoftknowledge yes sir finally last night
Last thing sir is that what if i selected a row and double clicked it i want to show that data to another jframe.
thank you so much, it's working like a charm!!!
Farras Shiddiq thanks fr ur support
can u please tell me how may i show the information from database for a particular user by clicking a button
this is emergency
Yes very easy I have uploaded a video on same topic...
ashraful hoque miraj th-cam.com/video/N9ZXYk2hVaM/w-d-xo.html
TnQ very much 😍
what is DbUtils it is showing error in my code.Plz reply fast.
wht error u r getting? have you imported all the required files????? and specially that JAR file... rstoxml
Rs2xml is added but showing error in dbutils
Adarsh S import all the required files...
I can save data into mysql but i can't show in jtable.. please help me😢
What's the error?
@@GSoftknowledge error is unable to display data in jtable after importing data. What could be the error here?
how do you remove rowid?
Can this coding works for java eclipse ?
Qing Ahqing ya surely it will work..
Okay Thanks! :)
Thanks bhai
could you please post the video for fetching date from database...
it is the same bro.... in this video I have shown the process of fetching data from database
it is the same bro.... in this video I have shown the process of fetching data from database
i tried but it is not fetching date... its showing 1970-01-01...
what u want to fetch from database.
same problem did u solve it?
how about with primary key in the database?
Yes any issues?
It shows the error "java.lang.NumberFormat Exception: For input string"
here's my code
can't figure out what's wrong with this
I want to insert data without the need of typing the ID coz that should be auto increment, right?
try {
String sql="insert into inventory_tbl values(?,?,?,?,?)";
pst=conn.prepareStatement(sql);
pst.setInt(1, Integer.parseInt(txtId.getText()));
pst.setString(2, txtName.getText());
pst.setString(3, txtType.getText());
pst.setInt(4, Integer.parseInt(txtPrice.getText()));
pst.setInt(5, Integer.parseInt(txtQuantity.getText()));
pst.executeQuery();
JOptionPane.showMessageDialog(null,"New Item Added.");
}catch (HeadlessException | NumberFormatException | SQLException e) {
JOptionPane.showMessageDialog(null,e);
}
fetch();
}
@@angelinesalazar4300 for this u can use auto increment attributes while making tables in database....
@@angelinesalazar4300 parse all the value in variables... And then use those variable for setString or setInt
what if u put wrong email and password
Where? While login?
Thanks a lot bro!
kindly show the same working in sqlite.
thanks bro it's working......
how do i get your whole code i need this pls help me out
sanjay kanojia chck out d video... And use tht code...
not properly getting that code in video and i need your whole code of yours dude pls help me out
sanjay kanojia ok msg me on FB... I will send u d code there on my FB page...
app ka naam kya hai fb pe
from where can i find this library net.proteanit.sql.DbUtils;
zain hasan u ha e to download a jar file... rx2xml jar just import this jar file...
Could you provide the script?
Mera jtable hi nahi show hora
What's the issue please explain..
my DbUtils isnt working?
VexXster y?? have you added the rs2xml jar file in the library??? if it's showing error.. send me the screenshot on my Facebook page..
Hi there Gsoft thx i was being an idiot i forgot to add that jar file ...spent like 2 hours finding and alternative but when i went back to look i noticed i hadnt added it lol ...thanks so much for ur help the videos u uploaded are really helping me alloot
VexXster thanks for your support... 😊😊
hi how about phpadmin mysql , whats the alternative code for DbUtils ?
How To Filter Data From sqlite Using JComboboxes And Show It In JTable in java netbeans
none none you have to use jcombobox.getSelectedItem(); to fetch data...
Thanks alot
Its shows null pointer Exception while fetching the data
do you solve it?
thanks dude it its working 💜
thanks a lot !
how to display whole table by entering only 1 field in java netbeans
sunny nuri dint get you? Why you trying to say?
Here what do you mean by only 1 field? Please elaborate
Thanks a lot man
Nikesh Sapkota thanks for your support
Thankx
Sir I'm getting error in jar file..
Whats the error?
@@GSoftknowledge now it's not giving any error but not adding data into table
@@seemakadam787 you are running the application through jar file or from NetBeans ?
@@GSoftknowledge from eclipse in jar file
@@seemakadam787 share screenshot with me.
Thanxx bro..!
thank you very much! ^_^
thanks for your support.... :)
its work..
thank you
Akshay Kondilkar thanks for your support....
Love you bro!!
Emmanuel Rebaño thanks for your support
omg thanks
very perfect
thanks a lot
pleasure's all mine.... nd thnks fr ur support..
thanks for use ntbeans, like sub + bell
Subscribed
It would be much better if u also give the code.
anand sen yeah sure
I have an error
what error?
Thanks a lot
Keep supporting
hi guys! where can i download rs2xml.jar for free? i can't find it. please help me.
U can directly search on Google and download the jar file.. n it's available freely...
hi guys! where can i download rs2xml.jar for free? i can't find it. please help me.