Accessing MYSQL Database Using Java in Eclipse IDE

[122017]

oh god so simple and so precise... why can't the world be like this :)

[rponcec]

This tutorial was useful, but i have done step by step and it is working so I have changed the local host into an ip address like getConnection(jdbc:mysql://192­.168.0.4/oe","root",""); but it doesnt work, if something I missed?. I tested my phpadmind and it works and i can access to my php appllication and works aswell. other point, if I change this into local host work normally. any comments?

[gpaluk]

Great tutorials, thank you... Sorry if this next bit is off topic, but what is the screen recording software that you are using? ^_^

[MrCrynickYT]

Hi!Thank you very much for this usefull video!

I have to do an application with java and database,with graphic interface.It is a project for my faculty.

And more,I have to add new values from that application!Do you think it is that hard for me??? :))

Have a nice day!

[iceman11a]

I just tryied your sample from your video and it works real good. The project I'm working is a Web Site. and I wanted to add some kind of edit page in java that can get values from a database and display them in a forum and then let the user make changes to it and then update the database. So far I haven't fount a sample even close to what I'm looking for.

[iceman11a]

Cool Video. Do you have plans for making a Video to show how to use forms in Java. and accessing a mysql database, I been looking for samples and haven't fount any thing that I can use.

[TheGydriy]

In the line: PreparedStatement statement = con.prepareStatement("select * from empl");

I've got type mismatch exception -

cannot convert from java.sql.PreparedStatement to com.mysql.jdbc.PreparedStateme­nt

What am I doing wrong?

[TheGydriy]

@TheGydriy Problem was in wrong importing of java.sql.*;

[MarkusGamers]

Now im getting this??

Code: ht tp://pastebin(.)com/Jm0H5cTm

Error: ht tp://pastebin(.)com/8stSW3Fg

Note: Remove () and space in the URL

[MarkusGamers]

Here is the code i get error on!

ht tp://pastebin(.)com/j82MW2tC

PLEASE HELP ME!!!

[MarkusGamers]

I get this:

Exception in thread "main" java.sql.SQLException: No suitable driver found for j-dbc:mysql://localhost:3306/L­ogin System at java.sql.DriverManager.getConn­ection(Unknown Source) at java.sql.DriverManager.getConn­ection(Unknown Source) at Main.main(Main.java:14)

PLEASE HELP!!!

I NEED HELP!!!

[1Pkor]

Excellent :)

[sheerqueer11]

Thanks a Tonne..

[BPBloodeye]

Having issues connecting to an DB on a server. I have replaced localhost:2082/ with my web address and port number, and added in my database, username and password and many errors are received. I just need to know if I'm attempting to connect correctly.

com.mysql.jdbc.exceptions.jdbc­4.CommunicationsException: Communications link failure

[Milaad]

@BPBloodeye I have the same problem, did you get what the problem is? I really need some help!

[Milaad]

@Milaad NVM, I got it, change to

Connection con = DriverManager.getConnection("j­dbc:mysql://localhost/testdb",­"root","");

Instead! Much easier!

[BPBloodeye]

@Milaad I did get mine working, can't really remember the issue precisely though. One thing I had to do was go to my CPanel and go to Remote Database Access Hosts, and enable the wildcard '%' which allows connections from any IP.

[Theprashanth549]

Thanks a lot.

[ado271ado]

This video helped me to,

thanks a lot,

nice job.

[da1gt]

well well man!

[carlisle21yaps]

okay i got it!!! it's the password thing that brought glitch to my prog! thanks so much!!!!!!!!!!!!!!!! this video helped me a lot!!!!!!!!!!!! omg to the max! you're the best!!

[carlisle21yaps]

this came out:

Exception in thread "main" java.sql.SQLException: Access denied for user 'root'@'localhost' (using password: YES)

and there is still some sub-problems in it like sqlerror.java:1073,

mysqlIO.java:3597....

help pls...

[mhra091992]

I run this but I got an error message:

Communications link failure.The last packet sent successfully to the server was 0 milliseconds ago. The driver has not received any packets from the server.

I've no idea how to troubleshoot this :(

[sharao111]

Thanks a lot..

[fatstylers89]

why while run its come on this thing?

Exception in thread "main" java.sql.SQLException: Access denied for user 'root'@'localhost' (using password: YES) at com.mysql.jdbc.SQLError.create­SQLException(SQLError.java:107­3)

[MrVijfhoek]

@fatstylers89 You entered the wrong password in your code

[fatstylers89]

@MrVijfhoek YEAH! man.. i got it already.. thanks man.. :-)

[carlisle21yaps]

@fatstylers89 I have the same problem!

[fatstylers89]

@carlisle21yaps check this line :

Connection con = DriverManager.getConnection("j­dbc:mysql://localhost:3306/vis­itor","root","root");

you need to change to this:

Connection con = DriverManager.getConnection("j­dbc:mysql://localhost:3306/vis­itor","root","");

[carlisle21yaps]

@fatstylers89 thanks!!!!!! it worked already!!!!

[JayantiGopaloodoo]

Great tutorial!!

simple and great :)

[Jenrikforlife]

can you make a tutorial about how i write in the mysql database?

and thanks for awesome tutorial!

[SlidingDoorTrack]

I could have used this about two days ago when I was pulling my hair out.

[fazaal24]

Thanks A lot Bro! It cannot get better. Thanks Heaps :D

[bdb4269]

perfect!!! you rock!

[lennon1780]

Thanks man!!! good stuff

[zigizinga]

Thank you so much. Very clear and concise tutorial.

[TheArunsriramathi]

Thanks a lot for your tutorial...

[lordteeuwen]

you are awesome!

[firefly21111]

One thing people should know: the default log/pass for me is "root", "" and not "root", "root"

Thanks for this, for some reason no other online tutorials were taking me all the way through creating a new database, getting the connector to work, and then accessing everything within Eclipse, so thank you being the one who got everything working for me! Only thing I can say would be better is if you provided a link to the code to prevent all the retyping. Thanks again!

[tbjohns10]

This is great. Thanks a lot!

[NourElghamry7]

all i can say is you r a prince ;-)

thanks man

[justicefadingtoblack]

3306 works for everybody?

[maxepk]

Thanks a lot :)

[ash4elisha]

That was very informative thanks

[aka784]

Thnx!

[Wirwing]

Thanks, thats what i am looking for. One more question, what if i want to open myproject using another computer? Do i have to copy the database as well? And what about the driver, its safe to putting it inside the project folder? Thanks anyway. :)

[msadhika]

Thank You for the video.....its excellent.....clear explanation....

[mrdevi]

thanks a lottttttttttttttt!!!!!!!!!

[rahztee]

can you connect eclipse with MsSql do you have a tutorial?

[rapso9]

Thanks for this! it turned out to be so simple in the end lol

[yudish12345]

Very nice video.. Do you know how to transfer the data taken from the database from a bluetooth server(j2se) to a bluetooth client(j2me).??

[elchami743]

thnx a lot, everything worked perfect! I-m learning with these tutorials. I-d like to know if u have in any of your videos information on how to call another page when clicking on a button or a link

[karatistajoseph]

thanks a lot!!!

[aka784]

hey i wann to say tht THIS IS IT ALL I WANT!! simply superb n to the point..Thnx for posting this video tutorial.. i m a student yet so looking for more tutorials :D only the one thing i wann to ask you is tht in the following line

Connection con = DriverManager.getConnection ("jdbc:mysql://:localhost:3306­/test", "root", "root");

when i removed the colon (":") from the localhost after tht my program runs successfully.i m sure there would be some technical reason ..will you plz tell me tht? thnx!

[MrCoder101]

@aka784 Check at 9:25. He says to remove that colon.

[onlinerajan1]

Excellent video....

[elchami743]

GReat !!!

thnks very much

!!

[Simoyd]

I love you. This video contained exactly all the information I needed. Thank you.

[1dimapavlov]

the tutorial is really good!! I learned a lot thank you a lot!!

[amrithcoorg]

very very very helpful video............thanks a lot

[MisterAlexUk]

This is the most fantastic tutorial on using JDBC. Honestly, I am so grateful for you making this video. You are incredible!

I have been struggling for three days on using JDBC, and you fix it in less than ten minutes. I'd give you one million thumbs up if I could, but I can't. Just, thank you so much.