koneksi

/*
* To change this license header, choose License Headers in Project Properties.
* To change this template file, choose Tools | Templates
* and open the template in the editor.
*/
package engine;

import com.mysql.jdbc.Connection;
import java.sql.DriverManager;
import java.sql.PreparedStatement;
import java.sql.SQLException;
import java.util.logging.Level;
import java.util.logging.Logger;
import javax.swing.JOptionPane;

/**
 *
 * @author root
 */
public class koneksi {
    private Connection conn;
    private ConfigDB config = new ConfigDB();
        /**
     * Function for message box information
     */

    private static void infoBox(String infoMessage){
        JOptionPane.showMessageDialog(null, infoMessage, "Informasi", JOptionPane.INFORMATION_MESSAGE);
    }

     /**
     * Function for message box warning
     */

    private static void warningBox(String infoMessage){
        JOptionPane.showMessageDialog(null, infoMessage, "Peringatan", JOptionPane.WARNING_MESSAGE);
    }

     /**
     * Function for message box information
     */

    private static void errorBox(String infoMessage){
        JOptionPane.showMessageDialog(null, infoMessage, "Kesalahan", JOptionPane.ERROR_MESSAGE);
    }
    public Connection getcon(){
        try {
            Class.forName("com.mysql.jdbc.Driver");//1. Load Driver
            String db = "jdbc:mysql://"+config.getServer()+":"+config.getPort()+"/"+config.getDB();//2. Memanggil alamat database
            String userdb = config.getUsername();//username default database
            String passdb = config.getPassword();//password default database
            conn = (Connection) DriverManager.getConnection(db,userdb,passdb);//3. Membuat Koneksi Database
        } catch (Exception e) {
            errorBox("Silakan cek koneksi database.");
        }
        return conn;
    }
}