Connecting to MySQL Database using Thin Driver

Connecting to MySQL Database using Thin Driver

To connect a Java application with MySQL database using Thin Driver. You need to follow the following steps

1. Load Driver Class: The Driver Class for MySQL database is com.mysql.jdbc.Driver and Class.forName("com.mysql.jdbc.Driver") method is used to load the driver class for MySQL database.
2. Create Connection: For creating a connection you will need a Connection URL. The Connection URL for MySQL is
   
   You will also require Username and Password of your MySQL Database Server for creating connection.
3. Loading jar file: To connect your java application with MySQL, you will also need to load mysql-connector.jar file. This file can be loaded into 2 ways.
   1. Copy the jar file into C:\Program Files\Java\jre7\lib\ext folder.
      or,
   2. Set it into classpath. For more detail see how to set classpath

Download mysql-connector.jar file

---

Example

Create a table in MySQL Database

create table Student(sid int(10),name varchar(20));

---

Insert some record into the table

insert into Student values(102,'adam');
insert into Student values(103,'abhi');

---

Accessing record from Student table in Java application

import java.sql.*;
class Test
{
public static void main(String []args)
{
try{
//Loading driver
Class.forName("com.mysql.jdbc.Driver");

//creating connection
Connection con = DriverManager.getConnection
                ("jdbc:mysql:/ /localhost:3306/test","username","password");

Statement s = con.createStatement(); //creating statement

ResultSet rs = s.executeQuery("select * from Student"); //executing statement

while(rs.next()){
System.out.println(rs.getInt(1)+" "+rs.getString(2));
}

con.close(); //closing connection
}catch(Exception e){
e.printStacktrace();
}
}
}

Output

102 adam
103 abhi

---

Inserting record into a table using java application

import java.sql.*;
class Test
{
public static void main(String []args)
{
try{
//Loading driver
Class.forName("com.mysql.jdbc.Driver");

//creating connection
Connection con = DriverManager.getConnection
                ("jdbc:mysql:/ /localhost:3306/test","username","password");

PreparedStatement pst=con.prepareStatement("insert into Student values(?,?)");
         
         pst.setInt(1,104);
         pst.setString(2,"Alex");
  pst.executeUpdate();

con.close(); //closing connection
}catch(Exception e){
e.printStacktrace();
}
}
}