Thank you so much respected Sir , i am very thankful to you, before watching your video I had this error " java.sql.SQLException: Could not retrieve transation read-only status server " but after watching your video it worked .. thanks a ton..
Hi, Great work clearing the concept. Can you tell how to create n number of duplicate row in jtable and insert those newly duplicated/copies to the dabatabase, with different primary key. And one more thing, how to edit a particular column in the jtable for those copies/duplicate rows data.
hi I'm getting this message when trying to run the project, could you help on this please? "Unable to connect to the MySQL server: org.netbeans.api.db.explorer.DatabaseException: org.netbeans.api.db.explorer.DatabaseException: java.sql.SQLException: The server time zone value 'unknown' is unrecognized or represents more than one time zone. You must configure either the server or JDBC driver (via the serverTimezone configuration property) to use a more specifc time zone value if you want to utilize time zone support.. The server may not be running or your MySQL connection properties may not be set correctly. Do you want to edit your MySQL connection properties?"
you can write the insert by yourself it's very simple INSERT INTO table_name VALUES() inside the parenthesis you can pass the value. But if you don't like to write the code by yourself and want to copy from phpmyadmin then go to database then expand your database go to the table and from there you will see the SQL tab and click on that tab after clicking that tab you will see various tabs like SELECT UPDATE INSERT etc. you click on that tab and there may appear the SQL Query for the particular operation as you select the tab then copy that code and edit by yourself just watching this video.
If i want to insert String and int data both what need to be write in "" try{ String sql = "INSERT INTO add_clips" +"(Cname, Cduration, Ctype, Cadd,Cgenre)" +"VALUES (?,?,?,?,?,?,?)"; """ ?? please answer
this is called the connection string:) we need to connect our program with the database before performing the database operation from our program on that database so for this task we need to register JDBC Driver in our program. I am using MySQL database so i need to get connection with the MySQL (watch this video for this ua-cam.com/video/yVeJy05D8ls/v-deo.html which shows how to connect your program with the MySQL DB) and the line 165 is to connect my database with my program and if you want to connect your SQL Server with your application you need to write different connection string (watch this video for this ua-cam.com/video/85VE_kubnsI/v-deo.html). jdbc means java database connectivity. jdbc:mysql://localhost/idusjavanew","root",""); The jdbc:mysql is the default connection string to connect MySQL db, jdbc:mysql://Your_Server_Name/Your_Database_Name","Database_Application_Username","Database_Application_Password");
when i used this code to insert data into mysql using this code it shows this error "com.mysql.jdbc.exceptions.jdbc4.MYSQLSyntexErrorException; You have error in your sql syntex. chk the manual that corresponds to your mysql server version for the right syntex to use near'add)VALUES('ahmed','raza','londen')'at line 1 can to tell me your mysql version?
first download "mysql-connector-java-5.1.40-bin" from www.mysql.com. if you don't know how to download and add this jar file watch ua-cam.com/video/yVeJy05D8ls/v-deo.html this video first then you will understand. and then check your insert query.
watch part 2 in 720p (i.e HD) and use earphone you will understand each and everything. if you listen i the loudspeaker i.e. laptop or desktop default sound without using the speaker sound may not be clear.
![Java And MySQL - How To Insert Update Delete And Display Data In jTable?[Part-2] [With Source Code]](http://i.ytimg.com/vi/NgRSW7ZOjLs/mqdefault.jpg)
![Java And MySQL - How To Insert Update Delete And Display Data In jTable?[Part-2] [With Source Code]](/img/tr.png)
![Java And MySQL - How To Insert Update Delete And Search Data [ With Source Code ]](/img/n.gif)
finally i successfully insert delete update data into mysql and retrive it into jtable
with the help of this useful code
thank u sir
you always welcome!
You're a master of machine prayers! Bless of Omnissia and Emperor upon you!
sir i am not able to do db but after this vdo easily did it thank you sirrrrrrrrrrrr
i am a software engineer very important video for my projects
You have allowed me to pass my coursework good sir
We are pleased that it helps you 😊
Thank you for this video. The functions of my project is workin thank you sirrrrrrrrrrrrrrrrrrrr
Your explanation is so simple 🔥🔥
His work gave me a 10/10👏🏽
Wish to see more videos like these in the future. Well done brother! You just got another subscriber and a like
Thank you for this video. The functions of my project is working
Thanks for completing my project ❤️❤️❤️❤️
can i contact you please ?
You are a Lifesaver
you saved my project bro thanks a ton!
MINE TOOO!!
Can you send code ?
Thank you so much respected Sir , i am very thankful to you, before watching your video I had this error " java.sql.SQLException: Could not retrieve transation read-only status server " but after watching your video it worked .. thanks a ton..
Glad it helped!
Do you have a video like this sir but it not required to use mysql? Like making Jtable directly without importing mysql
YOU SAVE MY FINAL APRESENTATION A.K.A PAP
Thank u so much Sir
sir, if I use jdatechooser then how should i write it to add the date in add button?
is it pst.setDate (2, Payment_Date.getDate()); ?
Yes!
error occured at pst = con.prepareStatement(sql);
did you use the object oriented design ?
NOPE!
in the new version of eclipse i cant drag and drop a button , it sets me like north center west.....
whats the solution to drag and drop freely
you can, use netbeans IDE!
@@RunCodes is there any video using object oriened design ??
is there is code for update or not??
Hi,
Great work clearing the concept. Can you tell how to create n number of duplicate row in jtable and insert those newly duplicated/copies to the dabatabase, with different primary key. And one more thing, how to edit a particular column in the jtable for those copies/duplicate rows data.
im getting an error at the "DriverManager.getConnection" part, the DriverManager is highlighted red
Click alt+enter to add the library!
hi I'm getting this message when trying to run the project, could you help on this please?
"Unable to connect to the MySQL server:
org.netbeans.api.db.explorer.DatabaseException: org.netbeans.api.db.explorer.DatabaseException: java.sql.SQLException: The server time zone value 'unknown' is unrecognized or represents more than one time zone. You must configure either the server or JDBC driver (via the serverTimezone configuration property) to use a more specifc time zone value if you want to utilize time zone support..
The server may not be running or your MySQL connection properties may not be set correctly. Do you want to edit your MySQL connection properties?"
update your computer time!
YOU MAN YOU ARE THE BESSSSSTTTTTTTTTT
THANK YOOOOOOUUUUUUUUUUUUUU
if I dont use rs2xml.jar, how could I do button view? to show database in jtable
sr my bad English
I have to idea about it!
Hey...i have only 4 parameters but it is showing that doesnt give value for 5th parameter while updating process...pls help
Have a look at your query, may be you forget commas, parentheses
Thanks! nice tutorial
i have a problem about the sql queries where can i find INSERT queries in Phpmy admin database i can't find there please reply
you can write the insert by yourself it's very simple INSERT INTO table_name VALUES() inside the parenthesis you can pass the value. But if you don't like to write the code by yourself and want to copy from phpmyadmin then go to database then expand your database go to the table and from there you will see the SQL tab and click on that tab after clicking that tab you will see various tabs like SELECT UPDATE INSERT etc. you click on that tab and there may appear the SQL Query for the particular operation as you select the tab then copy that code and edit by yourself just watching this video.
I am wait for mor
Sir please help what to do if user enter same rollno and same name how to validate the data and how to show it that the duplicate data found
Use primary key for rollno in database so that the rollno will not be same!
thnx for giving the nice tutorial
Sir can you help me this?
java.sql.SQLExcepton:Field'ID'Doesn't Have a default value
U don't have ID as primary key thats why u get such error make ID as primary key in your database
hello where is that video for downloading a connector
See description section of video!
If i want to insert String and int data both what need to be write in "" try{
String sql = "INSERT INTO add_clips"
+"(Cname, Cduration, Ctype, Cadd,Cgenre)"
+"VALUES (?,?,?,?,?,?,?)"; """ ??
please answer
for int you can use pst.setInt
i have this error" java.sql.SQLException: Can not issue data manipulation statements with executeQuery()"
Contact us at facebook.com/TechSupportNep
i have a problem on 12:17 line 165. what is jdbc? what are the things that you entered i dont understand bro can you help me?
this is called the connection string:) we need to connect our program with the database before performing the database operation from our program on that database so for this task we need to register JDBC Driver in our program. I am using MySQL database so i need to get connection with the MySQL (watch this video for this ua-cam.com/video/yVeJy05D8ls/v-deo.html which shows how to connect your program with the MySQL DB) and the line 165 is to connect my database with my program and if you want to connect your SQL Server with your application you need to write different connection string (watch this video for this ua-cam.com/video/85VE_kubnsI/v-deo.html). jdbc means java database connectivity. jdbc:mysql://localhost/idusjavanew","root",""); The jdbc:mysql is the default connection string to connect MySQL db, jdbc:mysql://Your_Server_Name/Your_Database_Name","Database_Application_Username","Database_Application_Password");
when i used this code to insert data into mysql using this code it shows this error
"com.mysql.jdbc.exceptions.jdbc4.MYSQLSyntexErrorException; You have error in your sql syntex. chk the manual that corresponds to your mysql server version for the right syntex to use near'add)VALUES('ahmed','raza','londen')'at line 1
can to tell me your mysql version?
first download "mysql-connector-java-5.1.40-bin" from www.mysql.com. if
you don't know how to download and add this jar file watch
ua-cam.com/video/yVeJy05D8ls/v-deo.html this video first then you will understand.
and then check your insert query.
Thanks
getting error at setString method the error is can not find symbol
import it first. import java.sql.PreparedStatement;
Import all needed libraries
Welcome to my channel
com.mysql.jdbc.exceptions.jdbc4.mysqlsyntaxerrorexception: table doesn't exist.
What to do in this situation?
+Aditi Battulwar enter your table name that you have created in your database! For more contact us at facebook.com/TechSupportNep
what about this?
java.sql.SQLException: Parameter index out of rang(1> number of parameters which is 0.
Bro were you able to sort that out? I am having exactly the same problem
Im getting erros for my "pst.setString()" codelines can anyone plese help me?
did u find the solutions ? bcus i dont get it. please help me .
Contact us at facebook.com/TechSupportNep
Pls answer this. I'm having a problem also in this line:(
@@jeffbaldovino7664 i face also same problem pst.setString(1,fname.getText()); this line fname does not work did u find solution?
In 20:23 pls help where I could find that in the libraries pls..
What do you mean?
Vist my channel
Really great! Unfortunatley when I run the it shows "java.lang.UnsupportedOperationException: Not supported yet. Please help Sir
Contact us at facebook.com/TechSupportNep
Import MySQL and jar file in the package. By adding it to a library
wow, thankyouu, give source code please
how to solve syntex error problm of sql version?
what type of problem do you face?
can you guide how to use search bar in this panel
i will make video on that stay connected!
okay thanks
how i insert data for jcombobox please reply
+SAGAR BANIK here is the video tutorial 😊 watch this video ua-cam.com/video/z-hyQizHrs0/v-deo.html
Source code or not given
I want to generate bill using these tools, can you help me? plzzzzz
+Ahmed Raza use simple arithmetic operator bro. you can do it by yourself.
okay im trying thanx
Ahmed pls I don't have clue on how to solve this Arithematic
The Error stopped on it's own without reason why. Now My DbUtils is giving big probs
how to chk parameter index of our textfield?
you can check parameter index from your mysql database. the first column have the parameter index 0 second column will be 1 and so on
thanx
done?
yop done. now im updating there is still a problem
Hey, thanks.
Visit my channel
Help! I keep getting java.lang.NullPointerException in my program, I can't add a data.
+Zeus Palisoc you may not add the jar file! Contact us at facebook.com/TechSupportNep
@@RunCodes what is the solution?
For which error?
@@RunCodes java. Lang. Null pointer exception
Where i can download mysql connection
Check the description section! There is link!
BRO AM NOT USING PHPADMIN DATABASE ITS MYSQL MANAGMENT STODIO AND THERE IS NO ROOT SO HOW I CONNECT TO MYSQL .. PLEASE HELP
mysql or sql??
TechSupportNep microsoft sql server 2014
Watch this video you will understand ua-cam.com/video/85VE_kubnsI/v-deo.html
tnxxxxxx💓💓💓💓
do you like our work?
does this tutorial help you?
if so, you can support us at www.patreon.com/RunCodes
Can I use xampp
sure
i need help in populate jtable but your video is not clear. plzz make it clear
watch part 2 you will able to populate jtable.
but data is not clear.
watch part 2 in 720p (i.e HD) and use earphone you will understand each
and everything. if you listen i the loudspeaker i.e. laptop or desktop
default sound without using the speaker sound may not be clear.
Am having prblm in update method....
+Aditi Battulwar contacts us at facebook.com/TechSupportNep
I got error on jdbc:mysql:
Watch video carefully
Odia hai kya
i dont know why but i get so many error on line 167 and after
+Krishna Manuaba what is your error??
hi . can'i have a source code pls !
Goto website!
Scam at 8:36 It didnt show me the list
🤔 watch the full tutorial first! We still have to write code!
@@RunCodes My only problem is how to make a search bar