function orang gila

/*
* 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 java.sql.Connection;
import java.sql.PreparedStatement;
import java.sql.ResultSet;
import java.sql.SQLException;
import java.sql.Statement;

/**
 *
 * @author root
 */
public class Query {
    private koneksi koneksi = new koneksi();


     private void dbg(Object data){
        System.out.println("Query : "+data);
    }

    /**
     *
     * @param field
     * @param table
     * @param condition
     */
    public ResultSet loadData(String field, String table, String condition, String[] data) throws SQLException{
        Connection con = koneksi.getcon();
        String sql = "SELECT "+ field +" FROM "+ table + " WHERE " + condition;
        PreparedStatement prep = con.prepareStatement(sql);
        int i = 1;
        for(String dt : data){
//            dbg(dt);
            prep.setString(i, dt);
            i++;
        }
//        dbg(sql);
        return prep.executeQuery();
    }
    /**
     *
     * @param field
     * @param table
     * @return
     */
    public ResultSet loadData(String field, String table) throws SQLException{
        Connection con = koneksi.getcon();
        Statement stat = con.createStatement();
        String sql = "SELECT "+ field + " FROM "+ table;
        return stat.executeQuery(sql);
    }

    public PreparedStatement deleteData(String field, String triger, String data) throws SQLException{
        Connection con = koneksi.getcon();
        String sql = "DELETE FROM "+ field + " WHERE " + triger + " = ?";
        return con.prepareStatement(sql);
    }

    public ResultSet getEnum(String table, String field) throws SQLException{
        Connection con = koneksi.getcon();
        String sql = "SHOW COLUMNS FROM `"+ table + "` WHERE Field = '"+field+"'";
        Statement stat = con.createStatement();
        return stat.executeQuery(sql);
    }
}