/*
 * To change this template, choose Tools | Templates
 * and open the template in the editor.
 */
package com.bestray.transtracking.views;

import com.bestray.transporttracking.DataSourceObject;
import java.sql.Connection;
import java.sql.ResultSet;
import java.sql.Statement;
import java.util.Properties;
import javax.sql.DataSource;

/**
 *
 * @author user2
 */
public class Backup {
    
    private static ResultSet res;
    private static Connection con;
    private Statement st;
    private DataSource ds;
    public String getMysqlBinPath() {
        
        try {
            ds=DataSourceObject.getDataSourceObject();
            con = ds.getConnection();
            st = con.createStatement(ResultSet.TYPE_SCROLL_INSENSITIVE, ResultSet.CONCUR_UPDATABLE);

        } catch (Exception e) {

            e.printStackTrace();
        }

        String a = "";
        try {
            res = st.executeQuery("select @@datadir");
            while (res.next()) {
                a = res.getString(1);
            }
        } catch (Exception eee) {
            eee.printStackTrace();
        }
        a = a.substring(0, a.length() - 5);
        
        a = a.replace("Data", "Files");
        //System.out.println("Mysql path is :" + a);
        return a;

    }
    
}