Java Connect to Microsoft SQL Server Step by Step

Learn to write Java code that connects to Microsoft SQL Server. Understand how a Java program can connect to Microsoft SQL Server via JDBC (Java Database Connectivity).

Here's what you will learn in details:
- Create a table in Microsoft SQL Server Express using Microsoft SQL Server Management Studio (SSMS).
- Code the first Java project that connects to Microsoft SQL Server, and then insert a new row to a table. Download Microsoft JDBC driver for SQL Server.
- Understand database URL format for Microsoft SQL server.
- Code the second Java project using Microsoft JDBC driver with Maven. The program connects and get all rows from a table in Microsoft SQL Server database.

[RedDogByrd]

I'm 77 and retired at 57. Haven't done any coding in over 20 years. Got bored in this pandemic. Never programmed in Java. Liked the idea of write once run anywhere. I did this video and got everything working in eclipse, but could not connect the db with Intellij which I prefer, but both are outstanding. Just started back coding in April. Nam you are fantastic. Keep up the good work. Why couldn't I be 10 years old again and have all this great technology at my finger tips?

[achilleskocaeli]

Thanks mate. I can now connect to SQL server from Java. I am now immortal

[BRBearUSA]

I confess I watched it at 2X the speed, but some nice step by step demonstrations without skipping steps. Definitely a good video for someone with 0 knowledge of Java <-> SQL, wanting to see how it's accomplished. Thank you for the video.

[gamtran]

Thank you so much! It's very useful.

[manishmulchandani]

After so many videos found this a useful video, thumbs up (y)

[playyourway]

thank you so much, Very good explanation, and clear ...<3 100% recommend to watch

[ticanabecks]

Thank you for the video! Helped me a lot!

[iamaadityatiwari]

Thanks man,
It's been a long since I'm looking for this kind of Video, I was kinda getting bored because I was not getting something in the data base to play.

[vishalpatil]

thanks alot sir , it's very valuable for me :)

[alinovskii]

thank you so much, you really saved me!!

[NT]

thankyou so much, that 's very helpful .

[rishabtyagi]

Seriously, It's very useful vedio ...Thanks a lot...Little bit problem of accent😅 to understand ...I am from India.
But, apart from this it helped me a lot.

[vuongqtvn]

nhìn giong bạn là biết người việt rồi cảm ơn bạn nhiều

[KatRollo]

Connection String:

How to get server name and instance name in SSMS:
Object Explorer > Your Connected Server (right-click) > Properties > General > Name

[emirwertyukes]

i did everything you showed but in try block when compiler came to connect object the execution never ends, no output/no exception

[hmheveh]

I have many problem with that but u help me) But if u told about the SQL server auntification I'll make it faster (I m begginer)

[sihamjallabi]

Hi could you tell me how you manage the bug with special charset like a small a dieresis... JDBC did not like it hhh when you try to execute the dblink

[Raphael]

As I'm totally starting with Java, dumb question, is the JDK the same as Eclipse or do I need to download the latter separately? Thanks

[saivenkatkavali]

i have defined the dependency in pom and still not able to connect to sql database.im defining dependency in app-context.xml the bean isnot getting created. could not find dirver class exception

[nvs]

When I connect succeed and send full of file for other computers. How to they also run that program? (Connected sql)