Steps to Connect with Database 🔥🔥 | Explained in Detail (Java Database Connectivity) - JDBC #3

What are the steps that are required to connect with the database in JDBC.
I have explained in brief what are the steps to follow to connect with database and perform operations with the database.
Steps to Connect with Database , explained in Detail (Java Database Connectivity) - JDBC #3
how to connect java program with database
1) load the driver:
Class.forName("com.mysql.jdbc.Driver")//
2)Create a Connection:
Connection con=DriverManager.getConnection("jdbc:mysql://127.0.0.1:3306/dbname","root","root");
3)Create query, Statement , PreparedStatement , CallableStatement
eg
String q="select * from students";
Statement stmt=con.createStatement();
ResultSet set=stmt.executeQuery(q);
4)Process the data :
while(set.next())
{
int id=set.getInt("studentID");
String name=set.getString("studentName");
System.out.println(id);
System.out.println(name);
}
5) Close the connection:
con.close();

[@niharikakumar1533]

Thank you sir 😌😌
You provided me with a strong foundation of JDBC.

[@rohan8758]

great explanation!

[@NikhilSingh-ox9pc]

21:10 kaun kehta hai Java Difficult hai...
Difficult tha ab nhi hai, THANK YOU soo much sir :)

[@SagarSinghAwesome]

Awesome video with great explaination.👌👌

[@ashwindev1090]

Seriously sir mujhe bohat dar lag raha for this topic and u helped me out , hats off to you. Expecting more videos on java for java developers

[@sounaksaha1455]

Kaun kehta hai Java difficult hai, thanks for your immense inputs bro!

[@afreenbegum1238]

Zabardast padhaheh bhai

[@nasibsingh3594]

TopClass And InDeapth Teaching

[@shankar7435]

Super❤❤❤

[@rizvicomputercodes3968]

The unmost unrated channel but acha video bana te ho

[@mdhasnainansari3051]

Excellent sir g

[@SantoshKamble-zk3fn]

If my class teacher tech this type wow u r osm sir love you sir

[@Anand-ol7jy]

Great 👌

[@bobbybhatta9957]

hii sir thanks lot for this oswm playlist. sir please we need java projects

[@yashwantkaki5072]

Perfect🔥

[@sagardhankar1449]

bhai aap jo bhi batate ho sab samajh aa jata h😀

[@anujsharma1265]

Thanks bhaii👍👍

[@abhinegi4977]

great video

[@kotitechycommunity2766]

great one

[@renukapatil4213]

Great😃

[@RaushanKumar-qb3de]

Mast sir. Thanks... ❤️❤️❤️

[@pushkargoyal4278]

nyc explanation

[@Have-attitude]

thanks sir
you are great 🙏

[@jojven7514]

awesome vdo

[@samarthdeshpande3794]

Sat sat pranam apko🙏

[@kumarsamyak513]

demo of JDBC should also be on command prompt using java program

[@skofficial387]

❤❤❤❤❤ thank you 😊😊😊😊

[@bhavikthanki8821]

👏👏👏👏

[@shekhar1497]

thank you.

[@JAY9896864656]

Good

[@_sarthak_.2]

simply we can use BufferReader also to fetch data

[@NasirAnsari-kd2vp]

❤

[@vivekanandpandey4114]

Hare Krishna Hare Krishna Krishna Krishna Hare Hare
Hare Rama Hare Rama Rama Rama Hare Hare ❤❤
Raadhe Raadhe ❤❤
Jai Shree Ram ❤❤❤

[@sachinsonone1823]

Please make videos on exceptions handling

[@himanshuupadhayay7843]

Yes sir please

[@pratibhanevhare2757]

sir I face this issue while connectivity java.sql.SQLSyntaxErrorException: ORA-00942: table or view does not exist please solve this problem

[@AnuragSingh-dg2jc]

exactly same issue

[@wolontong]

i didnt see you put any sketchy jar file from untrusted link into your library folder like other youtuber told us to.

[@hemantvishwakarma6568]

Sir should i get Driver link...we were not get the driver proper from google.

[@flyingbomber]

sir pls work on audio .its very low

[@srschool4298]

but its clear atleast

[@Tarun36876]

Which OS you are using ?

[@aniruddhachunne3011]

sublime text editor

[@Ramdut369]

Sir latest NetBeans IDE KA JDBC with my SQL dalo na......kisi ne bhi nahi dala video iske upar.....new version me library ka option nahi hai

[@prathamvora1349]

how to find fully classified classname of oracle jdbc jar file??? please help

[@SalmanMaqbool-tu9id]

if all these are interfaces how we are creating object

[@RaxpperGaming]

sir an error genreted , javap is not recognized

[@kotitechycommunity2766]

add class path in advance system settings

[@arjunchaurasiya6709]

Voice is very slow sir in this video

[@mihirshirgaonkar7832]

Ky bolte ho bhai
Mazha atta hai sunne me😅

[@srschool4298]

EXACTLY LMAO

[@susheel.1212]

mac book mai sql connector install kesa kren

[@aniruddhachunne3011]

editor konsa hai ye

[@kumarsamyak513]

sir where to load the driver?

[@mindbehaviour9195]

😵

[@shameem-32-evening95]

javap' is not recognized as an internal or external command,
operable program or batch file.
How to solve this error???????

[@rushi5709]

Step 1: Locate JDK Installation Directory
Locate the directory where you have installed the Java Development Kit (JDK). For example, if you installed JDK 17, the path might be something like C:\Program Files\Java\jdk-17.
Step 2: Set JAVA_HOME
Right-click on "This PC" or "Computer" on your desktop or in File Explorer.
Select "Properties."
Click on "Advanced system settings" on the left.
Click the "Environment Variables" button.
Under "System variables," click "New."
Enter JAVA_HOME as the variable name and the path to your JDK installation as the variable value (e.g., C:\Program Files\Java\jdk-17).
Step 3: Update PATH
In the "Environment Variables" window, find the "Path" variable under "System variables" and click "Edit."
Click "New" and add %JAVA_HOME%\bin to the list.
Step 4: Restart Command Prompt
Close any open Command Prompt windows and open a new one to ensure that the changes to the environment variables take effect.
Step 5: Verify Java Tools
Open a new Command Prompt and type the following commands:
Now, you should be able to use Java tools such as javap without encountering the "not recognized" error. If the issue persists, double-check the steps to ensure there are no typos or errors in the environment variable settings.
Hope this helps.

[@sheenabisht8629]

Sir I'm facing an error in MySQL command line client, everytime I enter password it crashes. What should I do? Please let me know.

[@subhu143]

Enter correct password.. Bro

[@pratikshakheme]

Same happens with me, Im entering correct password, plz reply sir

[@srschool4298]

@@pratikshakheme if you will enter wrong it will close automatically without any error

[@pratikshakheme]

@@srschool4298 yes, solved sir

[@saurabhtapkir433]

No suitable driver found for Url error

[@TechcodeBoy]

Mera ak error a raha hai kaha pe chat karke puche

[@yashupadhyay1023]

mko kuch samajh ku nhi aya

[@AshutoshKumar-es8xy]

com.mysql.cj.jdbc.Driver is the new class