How do I use interact with MySQL using Java?

Question

I'm assuming I need to use Connector\J and JDBC to achieve this, but I can't seem to 'install' Connector\J using the CLASSPATH thing. How do I do that ? I use the IntelliJ IDE if thats relevant.

I'm looking for a way to talk to a mysql database and execute and print out a few basic queries but I'm not getting anywhere because I can't even talk to the database.

Any help is appreciated.

Don Branson · Accepted Answer · 2009-02-18 20:49:42Z

7

You might follow an example such as this one:

http://www.kitebird.com/articles/jdbc.html

But, you might want to consider using Hibernate unless you're doing only a couple basic queries.

answered Feb 18, 2009 at 20:49

Don Branson

13.7k10 gold badges62 silver badges103 bronze badges

Sign up to request clarification or add additional context in comments.

Comments

Michael Myers · Accepted Answer · 2009-06-23 15:54:40Z

4

See Using MySQL with Java -- the first link from Google.

edited Jun 23, 2009 at 15:54

Michael Myers♦

193k47 gold badges301 silver badges297 bronze badges

answered Feb 18, 2009 at 20:53

Bombe

84.4k20 gold badges127 silver badges127 bronze badges

2 Comments

Michael Myers Over a year ago

Rich B is eliminating all lmgtfy posts. I have no problem with that, but I'd like there to be at least some content (not that there was any to start with, but people did upvote some of those answers).

blank Over a year ago

Isn't it down to other users to downvote such answers rather than have RichB edit the answer into nonsense?

Bill the Lizard · Accepted Answer · 2009-02-18 21:21:37Z

3

I like this tutorial because it's very detailed and thorough. Pretty much every step from downloading and installing MySQL and Connector/J to writing and running queries is covered.

answered Feb 18, 2009 at 21:21

Bill the Lizard

407k213 gold badges579 silver badges892 bronze badges

Comments

duffymo · Accepted Answer · 2009-02-18 20:59:16Z

1

Which version of IntelliJ?

You need to add the MySQL Connector-J JAR to your project dependencies.

Open your IntelliJ settings (the "wrench" in the top menu bar), go to "Libraries", click on "Attach Classes", and add the MySQL Connector-J JAR that you downloaded above. That puts it in your CLASSPATH.

If you still have problems, it means you don't have the driver class name right. It should be com.mysql.jdbc.Driver.

answered Feb 18, 2009 at 20:59

duffymo

310k46 gold badges376 silver badges570 bronze badges

Collectives™ on Stack Overflow

How do I use interact with MySQL using Java?

4 Answers 4

Comments

2 Comments

Comments

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

4 Answers 4

Comments

2 Comments

Comments

Comments

Your Answer

Sign up or log in

Post as a guest

Related