Top Most Database Connection With Type 4 Driver in Java

Step 1) First get mysql-connector-java-5.0.5.jar from jar finder website and put this on your class path. If you are using eclipse then configure this jar in your project as :
Right Click On Your Project-> Build Path->Configure Build Path->Libraries Tab-->Add External Jar choose your jar location and then jar and then Click on Open Then  Click on Open

Step 2) Create Table as below Query and Fire Some inserts as follows

--
-- Definition of table `employee`
--

DROP TABLE IF EXISTS `employee`;
CREATE TABLE `employee` (
  `id` int(10) unsigned NOT NULL AUTO_INCREMENT,
  `name` varchar(45) NOT NULL,
  `type` varchar(45) NOT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=5 DEFAULT CHARSET=latin1;

--
-- Dumping data for table `employee`
--

/*!40000 ALTER TABLE `employee` DISABLE KEYS */;
INSERT INTO `employee` (`id`,`name`,`type`) VALUES
 (1,'sidd','manager'),
 (2,'mamta','Engineer'),
 (3,'savita','Engineer'),
 (4,'Some','manager');

Step 3) Now execute your Java Code as below


package test.myapp.jdbc;

import java.sql.Connection;
import java.sql.DriverManager;
import java.sql.PreparedStatement;
import java.sql.ResultSet;
import java.sql.SQLException;

public class JdbcType4Connection {

public static void main(String[] args) {
Connection con = null;
String dbtime;
String dbUrl = "jdbc:mysql://localhost:3306/testdb";
String dbClass = "com.mysql.jdbc.Driver";
String query = "Select * FROM Employee";

String placeHolderQuery = "Select * FROM Employee where id=? and name=?";

try {

Class.forName("com.mysql.jdbc.Driver");
                       //change your password according to your database configuration
con = DriverManager.getConnection(dbUrl, "root", "root");
// Statement stmt = con.createStatement(query);//with statement
PreparedStatement pstmt = con.prepareStatement(placeHolderQuery);
                      // with  prepared statement. you can use any one statement or prepared statement
pstmt.setInt(1, 1);

pstmt.setString(2, "sidd");

ResultSet rs = pstmt.executeQuery();

while (rs.next()) {

System.out.println(rs.getString(1) + " " + rs.getString(2)
+ " " + rs.getString(3));
} // end while
rs.close();
// stmt.close();
pstmt.close();
con.close();
} // end try

catch (ClassNotFoundException e) {
e.printStackTrace();
}

catch (SQLException e) {
e.printStackTrace();
} finally {
con = null;

}

}
}