Skip to main content

how to connect mysql database in java using jdbc

The following code illustrate how to connect mysql database using jdbc . It is very simple go through it and nothing fancy in it!!!
package basics.in.java.blogspot.in;
import java.sql.Connection;
import java.sql.DriverManager;
import java.sql.SQLException;

public class Main {
 
 private static final String USERNAME="root";
 private static final String PASSWORD="";
 private static final String CONN_STRING="jdbc:mysql://localhost/basicsinjavablogspot";
 

 public static void main(String[] args) throws ClassNotFoundException, SQLException {
  Class.forName("com.mysql.jdbc.Driver");
  Connection conn=null;
  try {
   conn= DriverManager.getConnection(CONN_STRING, USERNAME, PASSWORD);
            System.out.println("database connection successful");   
  } catch (SQLException e) {
   System.err.println("something went wrong in database connection");
   e.printStackTrace();
  }
  
  finally{
   if(conn!=null){
    conn.close();
   }
  }
  

 }

}

Comments

Post a Comment