how to database connectivity between mysql and eclipse java

Question

how to database connectivity between mysql and eclipse java? plz tell me hw it can be done?

Answer 1

Lots of ways:

• Hibernate
• EJB (make sure you go with version 3!)
• Roll your own solution with JDO/JDBC

And I'm sure there are plenty of other ways to do it as well.

Answer 2

You need a JDBC driver for MySQL in your application classpath which then registers automatically with DriverManager.

You can then use the techniques described in http://java.sun.com/docs/books/tutorial/jdbc/basics/connecting.html except you need to have the connection string (starting with jdbc:...) adapted to your precise scenario. That is described in the documentation for the JDBC driver you choose to use.

Answer 3

There are plenty of jdbc tutorials if you want to build your own solution. MYsql has a Using MySQL With Java page that has links to tutorials, presentations, blogs etc. The first tutorial looks like it covers everything from installing the database to accessing it from the java program.