OlahData

import java.sql.Connection;
import java.sql.DriverManager;
import java.sql.ResultSet;
import java.sql.SQLException;
import java.sql.Statement;
import java.util.Vector;
import javax.swing.table.DefaultTableModel;

/*
 * 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.
 */

/**
 *
 * @author Faiz Noeris
 */
public class OlahData {
    private String user,pwd,host,db;
    private Connection conn;

    public String Koneksi(String user,String pwd,String host,String db){
        this.user = user;
        this.pwd = pwd;
        this.host = host;
        this.db = db;

        String urlvalue = "jdbc:mysql://" + host + ":3306/" + db;
        String kelas = "com.mysql.jdbc.Driver";
        try{
            Class.forName(kelas);
            conn = DriverManager.getConnection(urlvalue, user, pwd);
            return "Berhasil";
        }catch(Exception e){
            return("Koneksi gagal" + e.toString());
        }
    }

    public String simpan(String namatabel,String daftarfield,String nilaiisianfield){
        try{
            if(conn.isClosed()){
                throw new Exception("Koneksi belum terbuka");
            }else{
                Statement st = conn.createStatement();
                st.executeUpdate("insert into " + namatabel + " (" + daftarfield + ") values (" + nilaiisianfield + ")");
                return "Berhasil";
            }
        }catch(SQLException ex){
            return "Terjadi kesalahan " + ex.getMessage();
        }catch(Exception e){
            return "Terjadi kesalahan " + e.getMessage();
        }
    }

    public String update(String namatabel,String dataupdate,String kondisi){
        try{
            if(conn.isClosed()){
                throw new Exception("Koneksi belum terbuka");
            }else{
                Statement st = conn.createStatement();
                st.executeUpdate("update " + namatabel + " set " + dataupdate + " where " + kondisi);
            }
            return "Berhasil";
        }catch(SQLException ex){
            return "Terjadi kesalahan " + ex.getMessage();
        }catch(Exception e){
            return "Terjadi kesalahan " + e.getMessage();
        }
    }

    public String hapus(String namatabel,String Kondisi){
        try{
            if(conn.isClosed()){
                throw new Exception("Koneksi belum terbuka");
            }else{
                Statement st = conn.createStatement();
                if(Kondisi.isEmpty()){
                    st.executeUpdate("delete from " + namatabel);
                }else{
                    st.executeUpdate("delete from " + namatabel + " where " + Kondisi);
                }
                return "Berhasil";
            }
        }catch(SQLException ex){
            return "Terjadi kesalahan " + ex.getMessage();
        }catch(Exception e){
            return "Terjadi kesalahan " + e.getMessage();
        }
    }

    public ResultSet Select(String namatabel,String DaftarField,String Kondisi){
        try{
            ResultSet rs = null;
            Statement st = conn.createStatement(rs.TYPE_SCROLL_SENSITIVE,rs.CONCUR_UPDATABLE);
            if(conn.isClosed()){
                throw new Exception("Koneksi belum terbuka");
            }else{
                if(DaftarField.isEmpty()){
                    if(Kondisi.isEmpty()){
                        rs = st.executeQuery("select * from " + namatabel);
                    }else{
                        rs = st.executeQuery("select * from " + namatabel + " where " + Kondisi);
                    }
                }else{
                    if(Kondisi.isEmpty()){
                        rs = st.executeQuery("select " + DaftarField + " from " + namatabel);
                    }else{
                        rs = st.executeQuery("select " + DaftarField + " from " + namatabel + " where " + Kondisi);
                    }
                }
                return rs;
            }
        }catch(SQLException ex){
            return null;
        }catch(Exception e){
            return null;
        }
    }

    public DefaultTableModel isitabel(String namatabel,String daftarfield[],String judulkolom[],String kondisi){
        ResultSet rs = null;
        if(!kondisi.isEmpty()){
            rs = Select(namatabel,"",kondisi);
        }else{
            rs = Select(namatabel, "", "");
        }

        DefaultTableModel tablemodel = new DefaultTableModel(judulkolom, 0);
        try{
            while(rs.next()){
                Vector data = new Vector();
                for(int i = 0;i < daftarfield.length; i++){
                    data.addElement(rs.getString(daftarfield[i]));
                }
                tablemodel.addRow(data);
            }
            return tablemodel;
        }catch(SQLException ex){
            return null;
        }
    }

    public boolean Cari(String nim,String kondisi){
        ResultSet rs = null;

        try{
            rs = Select("tblujianfaiz", "", kondisi);
            if(!rs.next()){
                return false;
            }else{
                return true;
            }
        }catch(SQLException ex){
                return false;
        }
    }
}