Hello, I have tried your video up until parameters data creation and it worked. Thank you so much. Tomorrow I will continue the rest of your video. Thank you so much.
this video saved me a lot of time, thank you sooo much. Everything was so clear. I cant remember when i was doing everything without errors and with the first try, but today is the day
sorry to be so off topic but does any of you know a tool to get back into an Instagram account..? I was dumb lost the login password. I love any assistance you can offer me!
@Spencer Winston i really appreciate your reply. I found the site thru google and I'm trying it out atm. I see it takes a while so I will get back to you later with my results.
TIME ZONE ERROR (SOLVED) In my case there was an error with my time zone. To solve it, I went back to Mysql, right-clicked on our "users" table, clicked on "select rows" and typed the command: SET GLOBAL time_zone = '+4: 00'; Then I went back to the eclipse and it worked!
Hey, so most of the tutorials have website connect to database via php. I am creating a bookstore html website, can i connect it like your tutorial to be able to perform CRUD operations or do i need PHP?
yes, you can connect using Java. In a webapp, you need to create Java servlet which uses JDBC to work with database. Check out this tutorial: www.codejava.net/coding/jsp-servlet-jdbc-mysql-create-read-update-delete-crud-example
I am a begginer and I have a Java prog to use CRUD with MySQL but I don't know how to use SQL will I be able to understand this video and use CRUD as shown in the video to be used in my Java program
Do you consider a good practice in the Update to send all the fields, including those that were not changed in the form? I've always had this doubt, or send to update individually only those were changed in the form
I prefer updating all the fields even some are not changed. If you want to update only fields that have changed, then you will have to code some logic to check values are changed or not, which could increase the complexity of the code unnecessarily (think about the logic to detect changes of a group of 3 checkboxes, for example).
Hello Mr Nam Ha Minh . I 've bg in this exercise. when i add a querry like INSERT INTO duplicate value in sql, in sql table it still shows sql value. How to check the value is already in the sql table and How to resolve this bug .
you can set unique = true for the column that should not have duplicate values. Then it will throw an exception if you're trying to insert the same value. Then you catch this exception and handle it properly. Make sense?
sir how can i solve this error: ';' expected String sql = " insert into Book values(" + book name + ",'" + book id + "'," + page number +")"; ^ Book.java:19: error: not a statement String sql = " insert into Book values(" + book name + ",'" + book id + "'," + page number +")"; ^ error: not a statement String sql = " insert into Book values(" + book name + ",'" + book id + "'," + page number +")"; ^ error String sql = " insert into Book values(" + book name + ",'" + book id + "'," + page number +")";
you are the most understandable teacher for java jdbc. When i saw your vedio , I understand it first time ......
you are best teacher for JDBC.
Thanks and welcome! Come to watch my videos more often. Cheers!
Hello, I have tried your video up until parameters data creation and it worked. Thank you so much. Tomorrow I will continue the rest of your video. Thank you so much.
Glad it helped
this video saved me a lot of time, thank you sooo much. Everything was so clear. I cant remember when i was doing everything without errors and with the first try, but today is the day
Glad it helped!
Coding is very straight to the point. Loved it and keep it up
Glad you loved it. Thanks for watching :)
Thank you, a very good tutorial with no additional crap and to-the-point content.
Glad it was helpful!
sorry to be so off topic but does any of you know a tool to get back into an Instagram account..?
I was dumb lost the login password. I love any assistance you can offer me!
@Maxim Makai instablaster ;)
@Spencer Winston i really appreciate your reply. I found the site thru google and I'm trying it out atm.
I see it takes a while so I will get back to you later with my results.
@Spencer Winston it worked and I actually got access to my account again. I'm so happy!
Thanks so much, you saved my account :D
Thank you. you explain better then my professor
Wow, thanks!
TIME ZONE ERROR (SOLVED)
In my case there was an error with my time zone.
To solve it, I went back to Mysql, right-clicked on our "users" table, clicked on "select rows" and typed the command:
SET GLOBAL time_zone = '+4: 00';
Then I went back to the eclipse and it worked!
Thanks for your contribution.
Awesome explanation . Completely understood
Glad it helped
Such a helpful tutorial. Many thanks!
Glad it was helpful!
Very Straight forward and helpful tutorial. Thank you!
You're welcome. Glad it helped.
thanks for the clear explanation
You are welcome!
thanks for vid..really helped me in my project👍
Glad it helped!
Thank you very much... For such a wonderful tutorial 😊✨🙏
you're welcome. Glad it helped.
Hey, so most of the tutorials have website connect to database via php. I am creating a bookstore html website, can i connect it like your tutorial to be able to perform CRUD operations or do i need PHP?
yes, you can connect using Java. In a webapp, you need to create Java servlet which uses JDBC to work with database. Check out this tutorial: www.codejava.net/coding/jsp-servlet-jdbc-mysql-create-read-update-delete-crud-example
Thank you very much Sir.
Welcome!
Sir How To Take Value From The User ? In this video you already given Value.
check my answer in this video: ua-cam.com/video/nJ4MwK6o510/v-deo.html
For recording voice which one u use , normal head phones ?
I'm using a basic headphone. Nothing special.
Am using normal headphones but voice is not getting recorded
I am a begginer and I have a Java prog to use CRUD with MySQL but I don't know how to use SQL will I be able to understand this video and use CRUD as shown in the video to be used in my Java program
you mean you don't know writing SQL statements?
@@CodeJava yes
Thnak you sir, you are very helpful.
Glad it helped
very helpful tutorial.. thank you so much !!
You're welcome!
This is very helpful. Thanks. Keep the good work
Glad it was helpful!
Do you consider a good practice in the Update to send all the fields, including those that were not changed in the form? I've always had this doubt, or send to update individually only those were changed in the form
I prefer updating all the fields even some are not changed. If you want to update only fields that have changed, then you will have to code some logic to check values are changed or not, which could increase the complexity of the code unnecessarily (think about the logic to detect changes of a group of 3 checkboxes, for example).
Thank u very much it was really useful
Glad it helped
Can u perform all the three SQL query operations in a single code.without changing it each time
oh, it's impossible to execute all Insert, Select and Update in a single statement.
Can u create a new database in JDBC by using Oracle database ? it's possible?
I think no. You must use Oracle tool to create the database.
Yes it's possible
Can you provide Google script code or make video on to connect Google sheet to MySQL
Hmm, let me study first.
@@CodeJava thankyou very much I need it happy all the best for your study
@@alternativeenergyresearch4857 thanks.
Hello Mr Nam Ha Minh . I 've bg in this exercise.
when i add a querry like INSERT INTO duplicate value in sql, in sql table it still shows sql value.
How to check the value is already in the sql table and How to resolve this bug .
you can set unique = true for the column that should not have duplicate values. Then it will throw an exception if you're trying to insert the same value. Then you catch this exception and handle it properly. Make sense?
@@CodeJava yes , we'll resolve in Database and I think it's safety .
Awesome channel
Keep posting!!
Thank you, I will
Simple and easy thanks a lot
Keep watching
Thank you so much, can you please do the same but with MVC or MVVM if you can do that it's really great
I'll try!
@@CodeJava thank you so much
Does this work on xampp too? I don't have workbench lol
Yes, of course. As long as you have the proper JDBC driver for Xampp (MySQL Connector Java might work).
Loved it, thanks a lot
Glad you liked it!
Thank you! This really helped.
I'm so glad! Subscribe to this channel.
u have not loaded the mysql driver class is it ok
No need to explicitly load driver class with new Java version (since 1.6)
Thank you so much
You're most welcome
hay qúa thầy ơi
cảm ơn em.
superb tutorial. thanks much
Thanks sir, this tutor help me
Hey iam using wamp server php admi. MySQL finding difficult
I understand, phpmyadmin is super easy to use. With MySQL server you can use MySQL Workbench - a GUI tool that helps manage MySQL database easily.
Nice and helpful tutorial. Thanks
good
Thanks for watching.
sir how can i solve this
error: ';' expected
String sql = " insert into Book values(" + book name + ",'" + book id + "'," + page number +")";
^
Book.java:19: error: not a statement
String sql = " insert into Book values(" + book name + ",'" + book id + "'," + page number +")";
^
error: not a statement
String sql = " insert into Book values(" + book name + ",'" + book id + "'," + page number +")";
^
error String sql = " insert into Book values(" + book name + ",'" + book id + "'," + page number +")";
variable names can't have whitespace. You should write bookName, pageNumber,...
Where can i found password pls help me
Do you mean MySQL root password? It's the one you set when MySQL server is installed.
I forget my password 😕
Người Việt Nam chắc luôn :v
chính xác rùi đó.
@@CodeJava e đang học java để làm backend web thì vô tình gặp a...cảm ơn a vì những video hữu ích
@@vuthien9342 xem kênh anh thường xuyên hơn nhé (gần 260 video rồi).
localHost:3306???
it is hostname and port number of MySQL database server
@@CodeJava thanks 😊
Could've used some work
what do you mean?
please VietNamese :))
Nice video
Glad you enjoyed it