Java JDBC CRUD Tutorial (SQL Insert, Select, Update and Delete Examples)

[@khalidhossain3850]

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.

[@CodeJava]

Thanks and welcome! Come to watch my videos more often. Cheers!

[@ericmeric9879]

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.

[@CodeJava]

Glad it helped

[@aibeknazaraliev7000]

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

[@CodeJava]

Glad it helped!

[@anushasaruka7320]

Thank you, a very good tutorial with no additional crap and to-the-point content.

[@CodeJava]

Glad it was helpful!

[@maximmakai9327]

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!

[@spencerwinston43]

@Maxim Makai instablaster ;)

[@maximmakai9327]

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

[@maximmakai9327]

@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

[@princeprijwal8350]

Coding is very straight to the point. Loved it and keep it up

[@CodeJava]

Glad you loved it. Thanks for watching :)

[@honchan83]

Thank you. you explain better then my professor

[@CodeJava]

Wow, thanks!

[@ryanconway2371]

Very Straight forward and helpful tutorial. Thank you!

[@CodeJava]

You're welcome. Glad it helped.

[@LuizOtavio-zj9br]

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!

[@CodeJava]

Thanks for your contribution.

[@drewity]

Such a helpful tutorial. Many thanks!

[@CodeJava]

Glad it was helpful!

[@ShubhamKumar-dp6ip]

Awesome explanation . Completely understood

[@CodeJava]

Glad it helped

[@alishasharma880]

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?

[@CodeJava]

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

[@rj3937]

This is very helpful. Thanks. Keep the good work

[@CodeJava]

Glad it was helpful!

thanks for the clear explanation

[@CodeJava]

You are welcome!

[@mixxy4032]

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

[@CodeJava]

you mean you don't know writing SQL statements?

[@mixxy4032]

@@CodeJava yes

[@patpat__gaming2099]

thanks for vid..really helped me in my project👍

[@CodeJava]

Glad it helped!

[@aishwaryakamble4604]

Thank you very much... For such a wonderful tutorial 😊✨🙏

[@CodeJava]

you're welcome. Glad it helped.

[@huuquocdattran2877]

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 .

[@CodeJava]

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?

[@huuquocdattran2877]

@@CodeJava yes , we'll resolve in Database and I think it's safety .

[@dharan9203]

Can u create a new database in JDBC by using Oracle database ? it's possible?

[@CodeJava]

I think no. You must use Oracle tool to create the database.

[@carlosmorales8039]

Yes it's possible

[@eltirad0]

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

[@CodeJava]

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).

[@vijaykumar-wu9jc]

For recording voice which one u use , normal head phones ?

[@CodeJava]

I'm using a basic headphone. Nothing special.

[@vijaykumar-wu9jc]

Am using normal headphones but voice is not getting recorded

[@stellagabriella9085]

Awesome channel Keep posting!!

[@CodeJava]

Thank you, I will

[@rehnumafirdos8930]

very helpful tutorial.. thank you so much !!

[@CodeJava]

You're welcome!

[@sarvajith7915]

Thank u very much it was really useful

[@CodeJava]

Glad it helped

[@thomashughes8550]

Thank you! This really helped.

[@CodeJava]

I'm so glad! Subscribe to this channel.

[@amansheikh1801]

Thnak you sir, you are very helpful.

[@CodeJava]

Glad it helped

[@michaelaalquino7878]

Does this work on xampp too? I don't have workbench lol

[@CodeJava]

Yes, of course. As long as you have the proper JDBC driver for Xampp (MySQL Connector Java might work).

[@deepikabhogi6194]

Can u perform all the three SQL query operations in a single code.without changing it each time

[@CodeJava]

oh, it's impossible to execute all Insert, Select and Update in a single statement.

[@alternativeenergyresearch4857]

Can you provide Google script code or make video on to connect Google sheet to MySQL

[@CodeJava]

Hmm, let me study first.

[@alternativeenergyresearch4857]

@@CodeJava thankyou very much I need it happy all the best for your study

[@CodeJava]

@@alternativeenergyresearch4857 thanks.

[@akbarshaikh8448]

Sir How To Take Value From The User ? In this video you already given Value.

[@CodeJava]

check my answer in this video: kzbin.info/www/bejne/pHuXfqqBa9RoZ5I

[@piyasidey2117]

Thank you very much Sir.

[@CodeJava]

Welcome!

[@hippolytesama3817]

Simple and easy thanks a lot

[@CodeJava]

Keep watching

[@vijaykumar-wu9jc]

u have not loaded the mysql driver class is it ok

[@CodeJava]

No need to explicitly load driver class with new Java version (since 1.6)

[@amardeepvijay]

Loved it, thanks a lot

[@CodeJava]

Glad you liked it!

[@ammarbadri1150]

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 +")";

[@CodeJava]

variable names can't have whitespace. You should write bookName, pageNumber,...

[@alternativeenergyresearch4857]

Hey iam using wamp server php admi. MySQL finding difficult

[@CodeJava]

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.

[@rizaltaufiqhidayat3259]

Thanks sir, this tutor help me

[@azorynicodemas609]

superb tutorial. thanks much

[@leonardtoo985]

Nice and helpful tutorial. Thanks

[@nasrimarc7050]

Thank you so much, can you please do the same but with MVC or MVVM if you can do that it's really great

[@CodeJava]

I'll try!

[@nasrimarc7050]

@@CodeJava thank you so much

[@swathisivakumar6394]

Where can i found password pls help me

[@CodeJava]

Do you mean MySQL root password? It's the one you set when MySQL server is installed.

[@swathisivakumar6394]

I forget my password 😕

[@xanhbongcai7287]

hay qúa thầy ơi

[@CodeJava]

cảm ơn em.

[@fasihakausar9121]

Thank you so much

[@CodeJava]

You're most welcome

[@veerasakthivela1966]

localHost:3306???

[@CodeJava]

it is hostname and port number of MySQL database server

[@veerasakthivela1966]

@@CodeJava thanks 😊

[@vuthien9342]

Người Việt Nam chắc luôn :v

[@CodeJava]

chính xác rùi đó.

[@vuthien9342]

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

[@CodeJava]

@@vuthien9342 xem kênh anh thường xuyên hơn nhé (gần 260 video rồi).

[@levantai9918]

good

[@CodeJava]

Thanks for watching.

[@AdamThao92]

Could've used some work

[@CodeJava]

what do you mean?

[@datnguyen69468]

please VietNamese :))

[@progxmps6708]

Nice video

[@CodeJava]

Glad you enjoyed it