Connect to MySQL database from Java application

[alindamondal007]

Many thanks mate! Mighty helpful...

[timvisee]

Hi, Great tutorial!

.. but I have a question. I want to connect to an external database on my website, whats the URL I need to use where you used jdbc:mysql://localhost:3307/te­st, I tried those three things but I think they doesn't work. htt p: // example . com:3307 example . com :3307 and jbdc:mysql:// example . com. What do I need to use?

[timvisee]

@timvisee (I added some spaces between the URL's I used otherwise I couldn't post the comment -facepalm -facedesk

[TheAmazingJelly]

Man, I hope you make more videos. You're awesome!

[mrityunjoy99]

@TheAmazingJelly thanks for your support.

[MegaOuja]

you are welcome

[InStars]

Thanks dude, I forgot to add port at 4:20

Adding the port solved my problems :)

[russel07crowe]

where Should I put the JDBC driver in the eclips??

I download it.. Then What?

[MegaOuja]

@russel07crowe hey russel....So y open your project libraries-->jre System library(jre(X=6 or7..))-->touch your right button

and select BUILD PATH-->configure build path-->add external jars.....that s all

[russel07crowe]

@MegaOuja Thanks.. it worked fine. wish all best bro.

[InStars]

@russel07crowe You should create a new folder called "lib" in your Project and then add that .jar there, also add it to your CLASSPATH (search "classpath") in Window -> Preferences.

Also I am not pro at this, but after some hours of searching internet I somehow managed to get it work.

[russel07crowe]

@InStars thank you very much.. I appreciate your comment. It worked fine with me.

[MarkusGamers]

I can't tell you how much i love u

[MrVijfhoek]

Wow, you got a shitload of URL checkers :P

[smithy2306]

Thanks, this area of Java really frustrates me, I can never find good examples or tutorials

[EPHRAIMDify]

how do I know my class.forname?

[prashen001]

@EPHRAIMDify dude its same for every 1 who r using MYSQL driveri.e (com.mysql.jdbc.Driver)

[EPHRAIMDify]

@prashen001 I also figured that out. what I forgot to do is add the .jar file to the library in Netbeans. Thanks.

[styler564]

are you from india? :D

[Ninjason1337]

WOW 18degrees? Fahrenheit or Celsius?

[36redsoxfan]

you couldve just did--- import java.sql.*;

[hellsing357]

Excellent.......

[mrityunjoy99]

@hellsing357 Thanks :)

[smruti88]

Thanks Mrityunjoy! its a nice post.hy i want to know how many ways are there to connect database.

[mrityunjoy99]

@smruti88 If you talk about Java then JDBC is the standard API to connect to different databases. Database vendors provide JDBC drivers for their databases. You have to choose a target database the suitable JDBC driver for it.

In other programming languages the concept is mostly same.

[arvesh9]

Great ACCENT !!!

[mrityunjoy99]

@arvesh9 thanks :)

[khunii]

Good vid!

[mrityunjoy99]

@khunii thank you :)

[alertjms]

nice instructive video