Member Avatar for Doogledude123

Hey, I'm looking for decent MySQL tutorials for connecting a Database in Java. I'm using Java 8 so preferably would like tutorials that correspond with newest code.

Thanks!

  • 4 Contributors
  • 8 Replies
  • 373 Views
  • 1 Day Discussion Span
  • Latest Post Latest Post by JamesCherrill
Member Avatar for milil

Code is always the same because Java take care of backward compatibility.
Here you have tutorial about connection to database.
They explain every line of code what is made for.
Read that and I think you will not have any problems in future.
Kind regards, Mike.

Member Avatar for stultuske

my advice: learn to write your persistency code in such a way that it's not db dependent. it's much easier to work if on changing a db, all you need to do is change one single property, and not your actual code.

Member Avatar for JamesCherrill

^ like he said.
For learning, unles you are already a MySQL admin fiend, I can recommend using the JavaDB that came with your JDK, and NetBeans which has support for JavaDB burned in to its "services" tab. Setting up a database server isn't trivial unless you already know how how to do it. Using NetBeans/JavaDB will enable you to concentrate on your Java. Later you can change the connect statement to work with MySQL or whatever - the rest of the Java SQL support is database-independent.

Member Avatar for JamesCherrill

Just saw milil's post -
Beware that tutorial if you want current info. It starts with classForName, which became obsolete in 2006 (if not earlier).
Telling you to use classForName is a dead give-away for a tutorial that's not been updated for years and years.

Member Avatar for Doogledude123

I figured I would use the Oracle tutorials as that would be the most official, and probably up to date tutorial.

I already have a MySQL server running a database and tables set up. I appreciate the advice however.

Member Avatar for Doogledude123

Do I still need to download the JDBC Connector in order to connect to a MySQL database?

Member Avatar for JamesCherrill

For MySQL I think you need to download their JDBC connector, latest version here

Be a part of the DaniWeb community

We're a friendly, industry-focused community of developers, IT pros, digital marketers, and technology enthusiasts meeting, networking, learning, and sharing knowledge.