How to connect a java (JDBC) program to MySQL?

Question

I need help with finding out, which jar files I need to download and include in my java file to connect to MySQL. (MySQL is installed and setup correctly.)

Please list steps and links to the files I need to download.
Thanks!

I downloaded the driver unzipped it and included the following to my java file

import com.mysql.jdbc.ConnectionPropertiesTransform;
import com.mysql.jdbc.Driver;
import com.mysql.jdbc.NonRegisteringDriver;
import com.mysql.jdbc.SQLError;
import com.mysql.jdbc.StringUtils;
import com.mysql.jdbc.log.StandardLogger;

it compiled ok. but still can't connect to the database!

here's my code....
http://anosh.my-place.us/java/Connect.java

Answer 1

Just download the ODBC connector from mysql.com and it will act as an ODBC source that you can connect to.

Answer 2

Use the official JDBC driver! It's a native protocol driver (JDBC Type 4) pure Java driver implementation.

http://dev.mysql.com/usingmysql/java/

There is plenty of documentation at the dev.mysql.com site.

Answer 3

you won't be able to easily upload that document for your training.zip. i'm no longer particular what precisely that document is, because the call is truncated on your message. If it has .jar contained in the top, you want to characteristic it to the classpath - only append a ';' and the route to the document to the CLASSPATH after training.zip even if it isn't .jar, you are able to favor to do a touch added steps - it will be an archive, containing .jar interior, or it will be an installer application you are able to run etc...