msyql connector

import java.sql.*;
//inside your function/or event
Connection con=null;
Statement stat;
ResultSet res;
PreparedStatement prestat; //for updating, inserting, deleting
    try{
        Class.forName("com.mysql.jdbc.Driver");
        con = DriverManager.getConnection("jdbc:mysql://localhost:3306/name_of_database", "root", "");
        stat = con.createStatement();
        String query = "YOUR SQL QUERY HERE";
        res = stat.executeQuery(query);
        //or for updating, inserting, deleting use
        prestat = con.prepareStatement(query);
        while(res.next()){
            //statements
        }
}catch(Exception e){
}