Friday, March 8, 2013

Java / Connect to MySQL


How connect to MySQL database using JDBC MySQL connector?
Download MySQL connector

Add connector to your Java project. It is simple - just click right mouse button on project and choose "Build Path" --> "Configure Build Path" --> "Java Build Path" and add connector *.jar library.

1. Here is simple, short example how to register and connect do MySQL via JDBC connector:
import java.sql.Connection;
import java.sql.DriverManager;
import java.sql.SQLException;

public class DBexample 
{   
 public static void main(String[] args) throws SQLException 
 {
  Connection conn = null;
  
  try 
  {   
   Class.forName("com.mysql.jdbc.Driver"); 
   
   try 
   {
    conn = DriverManager.getConnection("jdbc:mysql://localhost/", "root", "password");
   } 
   catch (SQLException e) 
   {
    System.out.println("Check DB link / user / password");
    e.printStackTrace();
   }
  }
  catch(ClassNotFoundException e) 
  {
   System.out.println("There is no connector");
   System.out.println(e.getMessage());
   System.exit(-1);
  }
  
  System.out.println("Connector registered");
  
  conn.close();
 }
}
That's all!

No comments: