MySQL Connector for JDBC

When you want to use MySQL with JDBC, you will need to download mysql-connector-java-3.0.11-stable-bin.jar when developing servlets and JSP and install it in WEB-INF/lib.

And that mysql-connector-java-3.0.11 is JDBC type 4 driver so it’s sort of guranteed to perform really well.

When you use JDBC DriverManager, use “com.mysql.jdbc.Driver” as the class that implements java.sql.Driver.

Class.forName(”com.mysql.jdbc.Driver”).newInstance();

And here is the precedure for using Database with Java

1. Load a JDBC Database Driver
2. Create a Connection
3. Create a Statement
4. Create a ResultSet