Connecting to MySQL Database using Thin Driver in java

Connecting to MySQL Database using Thin Driver in java
java programming and c, c++, Matlab, Python, HTML, CSS programming language, and new techniques news and any history.

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 methodClass.forName("com.mysql.jdbc.Driver") are 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 a connection.

3-Loading jar file: To connect your Java application with MySQL, you will also need to load a filemysql-connector.jar. This file can be loaded into 2 ways.

1. 1. Copy the jar file into the folderC:\Program Files\Java\jre7\lib\ext.
      or,
   2. Set it into classpath. For more detail see how to set a classpath

Download MySQL-connector.jar file

 example:- creates a table in my SQL 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 a 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();
}
}
}