I can't login after I click "Masuk" button, why?

  • (2 Pages)
  • +
  • 1
  • 2

20 Replies - 852 Views - Last Post: 16 August 2012 - 09:03 AM Rate Topic: -----

#1 tawilovejessicalawrent  Icon User is offline

  • D.I.C Head

Reputation: -11
  • View blog
  • Posts: 122
  • Joined: 08-April 12

I can't login after I click "Masuk" button, why?

Posted 06 August 2012 - 12:35 AM


/*
 * To change this template, choose Tools | Templates
 * and open the template in the editor.
 */
package programobatservertesistawi;

/**
 *
 * @author Tawi
 */
import java.awt.*;
import java.util.logging.Level;
import java.util.logging.Logger;
import javax.swing.*;
import javax.swing.JFrame;
import java.sql.*;
import javax.swing.table.*;

public class TesisSource extends JFrame
{
    JTextField nama = new JTextField(10);
    JPasswordField password = new JPasswordField(10);
    JTextField kriteriaHargaMyocardialInfarction = new JTextField(10);
    JTextField kriteriaEfekSampingMyocardialInfarction = new JTextField(10);
    JTextField kriteriaKualitasMyocardialInfarction = new JTextField(10);
    JTextField kriteriaKetersediaanMyocardialInfarction = new JTextField(10);
    JTextField alternatifUtamaKriteriaHargaMyocardialInfarction = new JTextField(10);
    JTextField alternatifUtamaKriteriaEfekSampingMyocardialInfarction = new JTextField(10);
    JTextField alternatifUtamaKriteriaKualitasMyocardialInfarction = new JTextField(10);
    JTextField alternatifUtamaKriteriaKetersediaanMyocardialInfarction = new JTextField(10);
    JTextField alternatif2KriteriaHargaMyocardialInfarction = new JTextField(10);
    JTextField alternatif2KriteriaEfekSampingMyocardialInfarction = new JTextField(10);
    JTextField alternatif2KriteriaKualitasMyocardialInfarction = new JTextField(10);
    JTextField alternatif2KriteriaKetersediaanMyocardialInfarction = new JTextField(10);
    JTextField alternatif3KriteriaHargaMyocardialInfarction = new JTextField(10);
    JTextField alternatif3KriteriaEfekSampingMyocardialInfarction = new JTextField(10);
    JTextField alternatif3KriteriaKualitasMyocardialInfarction = new JTextField(10);
    JTextField alternatif3KriteriaKetersediaanMyocardialInfarction = new JTextField(10);
    JTextField alternatif4KriteriaHargaMyocardialInfarction = new JTextField(10);
    JTextField alternatif4KriteriaEfekSampingMyocardialInfarction = new JTextField(10);
    JTextField alternatif4KriteriaKualitasMyocardialInfarction = new JTextField(10);
    JTextField alternatif4KriteriaKetersediaanMyocardialInfarction = new JTextField(10);
    JTextField alternatif5KriteriaHargaMyocardialInfarction = new JTextField(10);
    JTextField alternatif5KriteriaEfekSampingMyocardialInfarction = new JTextField(10);
    JTextField alternatif5KriteriaKualitasMyocardialInfarction = new JTextField(10);
    JTextField alternatif5KriteriaKetersediaanMyocardialInfarction = new JTextField(10);
    JTextField kriteriaHargaStroke = new JTextField(10);
    JTextField kriteriaEfekSampingStroke = new JTextField(10);
    JTextField kriteriaKualitasStroke = new JTextField(10);
    JTextField kriteriaKetersediaanStroke = new JTextField(10);
    JTextField alternatifUtamaKriteriaHargaStroke = new JTextField(10);
    JTextField alternatifUtamaKriteriaEfekSampingStroke = new JTextField(10);
    JTextField alternatifUtamaKriteriaKualitasStroke = new JTextField(10);
    JTextField alternatifUtamaKriteriaKetersediaanStroke = new JTextField(10);
    JTextField alternatif2KriteriaHargaStroke = new JTextField(10);
    JTextField alternatif2KriteriaEfekSampingStroke = new JTextField(10);
    JTextField alternatif2KriteriaKualitasStroke = new JTextField(10);
    JTextField alternatif2KriteriaKetersediaanStroke = new JTextField(10);
    JTextField alternatif3KriteriaHargaStroke = new JTextField(10);
    JTextField alternatif3KriteriaEfekSampingStroke = new JTextField(10);
    JTextField alternatif3KriteriaKualitasStroke = new JTextField(10);
    JTextField alternatif3KriteriaKetersediaanStroke = new JTextField(10);
    JTextField alternatif4KriteriaHargaStroke = new JTextField(10);
    JTextField alternatif4KriteriaEfekSampingStroke = new JTextField(10);
    JTextField alternatif4KriteriaKualitasStroke = new JTextField(10);
    JTextField alternatif4KriteriaKetersediaanStroke = new JTextField(10);
    JTextField alternatif5KriteriaHargaStroke = new JTextField(10);
    JTextField alternatif5KriteriaEfekSampingStroke = new JTextField(10);
    JTextField alternatif5KriteriaKualitasStroke = new JTextField(10);
    JTextField alternatif5KriteriaKetersediaanStroke = new JTextField(10);
    JButton hubungkanKePadukData = new JButton("Hubungkan ke Paduk Data");
    JButton batal = new JButton("Batal");
    JButton putuskanKoneksiKePadukData = new JButton("Ubah Paduk Data");
    JButton keluar = new JButton("Keluar");
    JLabel masuk = new JLabel("Sudah Terotentifikasi");
    JLabel koneksiStatus = new JLabel("Belum Terhubung ke Paduk Data");
    JButton tombolMasuk = new JButton("Masuk");
    JLabel statusPadukData = new JLabel("Paduk Data Belum Diubah");
    Connection connection;
    Statement statement;
    JComboBox driverDatabase = new JComboBox(new String[]{"sun.jdbc.odbc.JdbcOdbcDriver"});
    JComboBox url = new JComboBox(new String[]{"jdbc:odbc:DatabaseKlinik"});
    String namaTabel;
    JTextArea taruhHasil = new JTextArea(100,80);
    ResultSet grupHasil;
    DefaultTableModel modelTabel = new DefaultTableModel();
    DefaultListSelectionModel daftarModelPilih = new DefaultListSelectionModel();
    int hitungColumn;
    String[][] penyakit = new String[40][3];
    String[] sql = new String[80];
    String[][] instruksiPenyakit = new String[40][4];
    String[][] bobot1 = new String[4][1];
    private ResultSet[] kriteria = new ResultSet[80];
    ResultSet[][] hasilEksekusi = new ResultSet[20][4];
    private String[] bobot = new String[8];
    private String loginName;
    private String loginPassword;
    private ResultSet logName;
    private ResultSet logPassword;
    private String namaPengguna;
    private String passwordPengguna;
    int i = 0; 
    int j = 0; 
    int k = 0; 
    int l = 0; 
    int m = 0;
    
    public TesisSource(){
        JPanel p1 = new JPanel();
        JPanel p2 = new JPanel();
        JPanel p3 = new JPanel();
        JPanel p4 = new JPanel();
        JPanel p5 = new JPanel();
        JPanel p6 = new JPanel();
        JPanel p7 = new JPanel();
        JPanel p8 = new JPanel();
        JPanel p9 = new JPanel();
        JPanel p10 = new JPanel();
        JPanel p11 = new JPanel();
        JPanel p12 = new JPanel();
        JPanel p13 = new JPanel();
        JPanel p14 = new JPanel();
        JPanel p15 = new JPanel();
        JPanel p16 = new JPanel();
        JPanel p17 = new JPanel();
        JPanel p18 = new JPanel();
        JPanel p19 = new JPanel();
        JPanel p20 = new JPanel();
        JPanel p21 = new JPanel();
        p1.setLayout(new GridLayout(1, 1, 2, 2));
        p2.setLayout(new GridLayout(1, 1, 2, 2));
        p3.setLayout(new GridLayout(1, 1, 2, 2));
        p4.setLayout(new GridLayout(1, 1, 2, 2));
        p5.setLayout(new GridLayout(1, 1, 2, 2));
        p6.setLayout(new GridLayout(1, 1, 2, 2));
        p7.setLayout(new GridLayout(1, 1, 2, 2));
        p8.setLayout(new GridLayout(1, 1, 2, 2));
        p9.setLayout(new GridLayout(1, 1, 2, 2));
        p10.setLayout(new GridLayout(1, 1, 2, 2));
        p11.setLayout(new GridLayout(1, 1, 2, 2));
        p12.setLayout(new GridLayout(1, 1, 2, 2));
        p13.setLayout(new GridLayout(1, 1, 2, 2));
        p14.setLayout(new GridLayout(1, 1, 2, 2));
        p15.setLayout(new GridLayout(1, 1, 2, 2));
        p16.setLayout(new GridLayout(1, 1, 2, 2));
        p17.setLayout(new GridLayout(1, 1, 2, 2));
        p18.setLayout(new GridLayout(1, 1, 2, 2));
        p19.setLayout(new GridLayout(1, 1, 2, 2));
        p20.setLayout(new GridLayout(1, 1, 2, 2));
        p21.setLayout(new GridLayout(1, 80, 2, 2));
        setLayout(new GridLayout(24, 80, 2, 2));
        p1.add(new JLabel("Nama"));
        p1.add(nama);
        p1.add(new JLabel("Kata Sandi"));
        p1.add(password);
        p1.add(tombolMasuk);
        p2.add(statusPadukData);
        p2.add(hubungkanKePadukData);
        p2.add(putuskanKoneksiKePadukData);
        p2.add(batal);
        p2.add(keluar);
        p3.add(koneksiStatus);
        tombolMasuk.addActionListener(new java.awt.event.ActionListener() {
            @Override
            public void actionPerformed(java.awt.event.ActionEvent evt) {
                masuk();
            }
        });
        putuskanKoneksiKePadukData.addActionListener(new java.awt.event.ActionListener() {
            @Override
            public void actionPerformed(java.awt.event.ActionEvent evt) {
                ubah();
            }
        });
        hubungkanKePadukData.setEnabled(false);
        batal.setEnabled(false);
        putuskanKoneksiKePadukData.setEnabled(false);
        taruhHasil.setEditable(false);
        p4.add(new JLabel("Myocardial Infarction"));
        p5.add(new JLabel("Kriteria"));
        p5.add(new JLabel("Alternatif"));
        p5.add(new JLabel(""));
        p5.add(new JLabel(""));
        p5.add(new JLabel(""));
        p6.add(new JLabel(""));
        p6.add(new JLabel("Harga"));
        p6.add(new JLabel("Efek Samping"));
        p6.add(new JLabel("Kualitas"));
        p6.add(new JLabel("Ketersediaan"));
        p7.add(new JLabel("Harga"));
        p7.add(kriteriaHargaMyocardialInfarction);
        p7.add(new JLabel("Alternatif Utama"));
        p7.add(alternatifUtamaKriteriaHargaMyocardialInfarction);
        p7.add(new JLabel("Alternatif Utama"));
        p7.add(alternatifUtamaKriteriaEfekSampingMyocardialInfarction);
        p7.add(new JLabel("Alternatif Utama"));
        p7.add(alternatifUtamaKriteriaKualitasMyocardialInfarction);
        p7.add(new JLabel("Alternatif Utama"));
        p7.add(alternatifUtamaKriteriaKetersediaanMyocardialInfarction);
        p8.add(new JLabel("Efek Samping"));
        p8.add(kriteriaEfekSampingMyocardialInfarction);
        p8.add(new JLabel("Alternatif 2"));
        p8.add(alternatif2KriteriaHargaMyocardialInfarction);
        p8.add(new JLabel("Alternatif 2"));
        p8.add(alternatif2KriteriaEfekSampingMyocardialInfarction);
        p8.add(new JLabel("Alternatif 2"));
        p8.add(alternatif2KriteriaKualitasMyocardialInfarction);
        p8.add(new JLabel("Alternatif 2"));
        p8.add(alternatif2KriteriaKetersediaanMyocardialInfarction);
        p9.add(new JLabel("Kualitas"));
        p9.add(kriteriaKualitasMyocardialInfarction);
        p9.add(new JLabel("Alternatif 3"));
        p9.add(alternatif3KriteriaHargaMyocardialInfarction);
        p9.add(new JLabel("Alternatif 3"));
        p9.add(alternatif3KriteriaEfekSampingMyocardialInfarction);
        p9.add(new JLabel("Alternatif 3"));
        p9.add(alternatif3KriteriaKualitasMyocardialInfarction);
        p9.add(new JLabel("Alternatif 3"));
        p9.add(alternatif3KriteriaKetersediaanMyocardialInfarction);
        p10.add(new JLabel("Ketersediaan"));
        p10.add(kriteriaKetersediaanMyocardialInfarction);
        p10.add(new JLabel("Alternatif 4"));
        p10.add(alternatif4KriteriaHargaMyocardialInfarction);
        p10.add(new JLabel("Alternatif 4"));
        p10.add(alternatif4KriteriaEfekSampingMyocardialInfarction);
        p10.add(new JLabel("Alternatif 4"));
        p10.add(alternatif4KriteriaKualitasMyocardialInfarction);
        p10.add(new JLabel("Alternatif 4"));
        p10.add(alternatif4KriteriaKetersediaanMyocardialInfarction);
        p11.add(new JLabel(""));
        p11.add(new JLabel(""));
        p11.add(new JLabel("Alternatif 5"));
        p11.add(alternatif5KriteriaHargaMyocardialInfarction);
        p11.add(new JLabel("Alternatif 5"));
        p11.add(alternatif5KriteriaEfekSampingMyocardialInfarction);
        p11.add(new JLabel("Alternatif 5"));
        p11.add(alternatif5KriteriaKualitasMyocardialInfarction);
        p11.add(new JLabel("Alternatif 5"));
        p11.add(alternatif5KriteriaKetersediaanMyocardialInfarction);
        p12.add(new JLabel(""));
        p13.add(new JLabel("Stroke"));
        p14.add(new JLabel("Kriteria"));
        p14.add(new JLabel("Alternatif"));
        p14.add(new JLabel(""));
        p14.add(new JLabel(""));
        p14.add(new JLabel(""));
        p15.add(new JLabel(""));
        p15.add(new JLabel("Harga"));
        p15.add(new JLabel("Efek Samping"));
        p15.add(new JLabel("Kualitas"));
        p15.add(new JLabel("Ketersediaan"));
        p16.add(new JLabel("Harga"));
        p16.add(kriteriaHargaStroke);
        p16.add(new JLabel("Alternatif Utama"));
        p16.add(alternatifUtamaKriteriaHargaStroke);
        p16.add(new JLabel("Alternatif Utama"));
        p16.add(alternatifUtamaKriteriaEfekSampingStroke);
        p16.add(new JLabel("Alternatif Utama"));
        p16.add(alternatifUtamaKriteriaKualitasStroke);
        p16.add(new JLabel("Alternatif Utama"));
        p16.add(alternatifUtamaKriteriaKetersediaanStroke);
        p17.add(new JLabel("Efek Samping"));
        p17.add(kriteriaEfekSampingStroke);
        p17.add(new JLabel("Alternatif 2"));
        p17.add(alternatif2KriteriaHargaStroke);
        p17.add(new JLabel("Alternatif 2"));
        p17.add(alternatif2KriteriaEfekSampingStroke);
        p17.add(new JLabel("Alternatif 2"));
        p17.add(alternatif2KriteriaKualitasStroke);
        p17.add(new JLabel("Alternatif 2"));
        p17.add(alternatif2KriteriaKetersediaanStroke);
        p18.add(new JLabel("Kualitas"));
        p18.add(kriteriaKualitasStroke);
        p18.add(new JLabel("Alternatif 3"));
        p18.add(alternatif3KriteriaHargaStroke);
        p18.add(new JLabel("Alternatif 3"));
        p18.add(alternatif3KriteriaEfekSampingStroke);
        p18.add(new JLabel("Alternatif 3"));
        p18.add(alternatif3KriteriaKualitasStroke);
        p18.add(new JLabel("Alternatif 3"));
        p18.add(alternatif3KriteriaKetersediaanStroke);
        p19.add(new JLabel("Ketersediaan"));
        p19.add(kriteriaKetersediaanStroke);
        p19.add(new JLabel("Alternatif 4"));
        p19.add(alternatif4KriteriaHargaStroke);
        p19.add(new JLabel("Alternatif 4"));
        p19.add(alternatif4KriteriaEfekSampingStroke);
        p19.add(new JLabel("Alternatif 4"));
        p19.add(alternatif4KriteriaKualitasStroke);
        p19.add(new JLabel("Alternatif 4"));
        p19.add(alternatif4KriteriaKetersediaanStroke);
        p20.add(new JLabel(""));
        p20.add(new JLabel(""));
        p20.add(new JLabel("Alternatif 5"));
        p20.add(alternatif5KriteriaHargaStroke);
        p20.add(new JLabel("Alternatif 5"));
        p20.add(alternatif5KriteriaEfekSampingStroke);
        p20.add(new JLabel("Alternatif 5"));
        p20.add(alternatif5KriteriaKualitasStroke);
        p20.add(new JLabel("Alternatif 5"));
        p20.add(alternatif5KriteriaKetersediaanStroke);
        p21.add(taruhHasil);
        add(p1, BorderLayout.WEST);
        add(p2, BorderLayout.WEST);
        add(p3, BorderLayout.WEST);
        add(p4, BorderLayout.WEST);
        add(p5, BorderLayout.WEST);
        add(p6, BorderLayout.WEST); 
        add(p7, BorderLayout.WEST);
        add(p8, BorderLayout.WEST);
        add(p9, BorderLayout.WEST);
        add(p10, BorderLayout.WEST);
        add(p11, BorderLayout.WEST);
        add(p12, BorderLayout.WEST); 
        add(p13, BorderLayout.WEST);
        add(p14, BorderLayout.WEST);
        add(p15, BorderLayout.WEST);
        add(p16, BorderLayout.WEST);
        add(p17, BorderLayout.WEST); 
        add(p18, BorderLayout.WEST);
        add(p19, BorderLayout.WEST);
        add(p20, BorderLayout.WEST);
        add(p21, BorderLayout.WEST);
        keluar.addActionListener(new java.awt.event.ActionListener() {
            @Override
            public void actionPerformed(java.awt.event.ActionEvent evt) {
                keluar();
            }
        });
        hubungkanKePadukData.addActionListener(new java.awt.event.ActionListener() {
            @Override
            public void actionPerformed(java.awt.event.ActionEvent evt) {
                connectToDB();
            }
        });
        batal.addActionListener(new java.awt.event.ActionListener() {
            @Override
            public void actionPerformed(java.awt.event.ActionEvent evt) {
                batal();
            }
        });
    }
    
private void keluar() {
    System.exit(0);
}
private void ubah() {
    instruksiPenyakit[0][0] = "insert into HasilObatAHPPrioritasUtamaKriteriaHarga(Nama_Obat) values ('+alternatifUtamaKriteriaHargaMyocardialInfarction.getText()+')"; 
    instruksiPenyakit[1][0] = "insert into HasilObatAHPPrioritasKeduaKriteriaHarga(Nama_Obat) values ('+alternatif2KriteriaHargaMyocardialInfarction.getText()+')";
    instruksiPenyakit[2][0] = "insert into HasilObatAHPPrioritasKetigaKriteriaHarga(Nama_Obat) values ('+alternatif3KriteriaHargaMyocardialInfarction.getText()+')";
    instruksiPenyakit[3][0] = "insert into HasilObatAHPPrioritasKeempatKriteriaHarga(Nama_Obat) values ('+alternatif4KriteriaHargaMyocardialInfarction.getText()+')";
    instruksiPenyakit[4][0] = "insert into HasilObatAHPPrioritasKelimaKriteriaHarga(Nama_Obat) values ('+alternatif5KriteriaHargaMyocardialInfarction.getText()+')"; 
    instruksiPenyakit[5][0] = "insert into HasilObatAHPPrioritasUtamaKriteriaEfekSamping(Nama_Obat) values ('+alternatifUtamaKriteriaEfekSampingMyocardialInfarction.getText()+')"; 
    instruksiPenyakit[6][0] = "insert into HasilObatAHPPrioritasKeduaKriteriaEfekSamping(Nama_Obat) values ('+alternatif2KriteriaEfekSampingMyocardialInfarction.getText()+')";
    instruksiPenyakit[7][0] = "insert into HasilObatAHPPrioritasKetigaKriteriaEfekSamping(Nama_Obat) values ('+alternatif3KriteriaEfekSampingMyocardialInfarction.getText()+')";
    instruksiPenyakit[8][0] = "insert into HasilObatAHPPrioritasKeempatKriteriaEfekSamping(Nama_Obat) values ('+alternatif4KriteriaEfekSampingMyocardialInfarction.getText()+')";
    instruksiPenyakit[9][0] = "insert into HasilObatAHPPrioritasKelimaKriteriaEfekSamping(Nama_Obat) values ('+alternatif5KriteriaEfekSampingMyocardialInfarction.getText()+')";
    instruksiPenyakit[10][0] = "insert into HasilObatAHPPrioritasUtamaKriteriaKualiatas(Nama_Obat) values ('+alternatifUtamaKriteriaKualitasMyocardialInfarction.getText()+')";
    instruksiPenyakit[11][0] = "insert into HasilObatAHPPrioritasKeduaKriteriaKualitas(Nama_Obat) values ('+alternatif2KriteriaKualitasMyocardialInfarction.getText()+')";
    instruksiPenyakit[12][0] = "insert into HasilObatAHPPrioritasKetigaKriteriaKualitas(Nama_Obat) values ('+alternatif3KriteriaKualitasMyocardialInfarction.getText()+')";
    instruksiPenyakit[13][0] = "insert into HasilObatAHPPrioritasKeempatKriteriaKualitas(Nama_Obat) values ('+alternatif4KriteriaKualitasMyocardialInfarction.getText()+')";
    instruksiPenyakit[14][0] = "insert into HasilObatAHPPrioritasKelimaKriteriaEfekSamping(Nama_Obat) values ('+alternatif5KriteriaEfekSampingMyocardialInfarction.getText()+')";
    instruksiPenyakit[15][0] = "insert into HasilObatAHPPrioritasUtamaKriteriaKetersediaan(Nama_Obat) values ('+alternatifUtamaKriteriaKetersediaanMyocardialInfarction.getText()+')";
    instruksiPenyakit[16][0] = "insert into HasilObatAHPPrioritasKeduaKriteriaKetersediaan(Nama_Obat) values ('+alternatif2KriteriaKetersediaanMyocardialInfarction.getText()+')";
    instruksiPenyakit[17][0] = "insert into HasilObatAHPPrioritasKetigaKriteriaKetersediaan(Nama_Obat) values ('+alternatif3KriteriaKetersediaanMyocardialInfarction.getText()+')";
    instruksiPenyakit[18][0] = "insert into HasilObatAHPPrioritasKeempatKriteriaKetersediaan(Nama_Obat) values ('+alternatif4KriteriaKetersediaanMyocardialInfarction.getText()+')";
    instruksiPenyakit[19][0] = "insert into HasilObatAHPPrioritasKelimaKriteriaKetersediaan(Nama_Obat) values ('+alternatif5KriteriaKetersediaanMyocardialInfarction.getText()+')";
    instruksiPenyakit[0][2] = "insert into HasilObatAHPPrioritasUtamaKriteriaHarga(Nama_Obat) values ('+alternatifUtamaKriteriaHargaStroke.getText()+')"; 
    instruksiPenyakit[1][2] = "insert into HasilObatAHPPrioritasKeduaKriteriaHarga(Nama_Obat) values ('+alternatif2KriteriaHargaStroke.getText()+')";
    instruksiPenyakit[2][2] = "insert into HasilObatAHPPrioritasKetigaKriteriaHarga(Nama_Obat) values ('+alternatif3KriteriaHargaStroke.getText()+')";
    instruksiPenyakit[3][2] = "insert into HasilObatAHPPrioritasKeempatKriteriaHarga(Nama_Obat) values ('+alternatif4KriteriaHargaStroke.getText()+')";
    instruksiPenyakit[4][2] = "insert into HasilObatAHPPrioritasKelimaKriteriaHarga(Nama_Obat) values ('+alternatif5KriteriaHargaStroke.getText()+')"; 
    instruksiPenyakit[5][2] = "insert into HasilObatAHPPrioritasUtamaKriteriaEfekSamping(Nama_Obat) values ('+alternatifUtamaKriteriaEfekSampingStroke.getText()+')"; 
    instruksiPenyakit[6][2] = "insert into HasilObatAHPPrioritasKeduaKriteriaEfekSamping(Nama_Obat) values ('+alternatif2KriteriaEfekSampingStroke.getText()+')";
    instruksiPenyakit[7][2] = "insert into HasilObatAHPPrioritasKetigaKriteriaEfekSamping(Nama_Obat) values ('+alternatif3KriteriaEfekSampingStroke.getText()+')";
    instruksiPenyakit[8][2] = "insert into HasilObatAHPPrioritasKeempatKriteriaEfekSamping(Nama_Obat) values ('+alternatif4KriteriaEfekSampingStroke.getText()+')";
    instruksiPenyakit[9][2] = "insert into HasilObatAHPPrioritasKelimaKriteriaEfekSamping(Nama_Obat) values ('+alternatif5KriteriaEfekSampingStroke.getText()+')";
    instruksiPenyakit[10][2] = "insert into HasilObatAHPPrioritasUtamaKriteriaKualiatas(Nama_Obat) values ('+alternatifUtamaKriteriaKualitasStroke.getText()+')";
    instruksiPenyakit[11][2] = "insert into HasilObatAHPPrioritasKeduaKriteriaKualitas(Nama_Obat) values ('+alternatif2KriteriaKualitasStroke.getText()+')";
    instruksiPenyakit[12][2] = "insert into HasilObatAHPPrioritasKetigaKriteriaKualitas(Nama_Obat) values ('+alternatif3KriteriaKualitasStroke.getText()+')";
    instruksiPenyakit[13][2] = "insert into HasilObatAHPPrioritasKeempatKriteriaKualitas(Nama_Obat) values ('+alternatif4KriteriaKualitasStroke.getText()+')";
    instruksiPenyakit[14][2] = "insert into HasilObatAHPPrioritasKelimaKriteriaEfekSamping(Nama_Obat) values ('+alternatif5KriteriaEfekSampingStroke.getText()+')";
    instruksiPenyakit[15][2] = "insert into HasilObatAHPPrioritasUtamaKriteriaKetersediaan(Nama_Obat) values ('+alternatifUtamaKriteriaKetersediaanStroke.getText()+')";
    instruksiPenyakit[16][2] = "insert into HasilObatAHPPrioritasKeduaKriteriaKetersediaan(Nama_Obat) values ('+alternatif2KriteriaKetersediaanStroke.getText()+')";
    instruksiPenyakit[17][2] = "insert into HasilObatAHPPrioritasKetigaKriteriaKetersediaan(Nama_Obat) values ('+alternatif3KriteriaKetersediaanStroke.getText()+')";
    instruksiPenyakit[18][2] = "insert into HasilObatAHPPrioritasKeempatKriteriaKetersediaan(Nama_Obat) values ('+alternatif4KriteriaKetersediaanStroke.getText()+')";
    instruksiPenyakit[19][2] = "insert into HasilObatAHPPrioritasKelimaKriteriaKetersediaan(Nama_Obat) values ('+alternatif5KriteriaKetersediaanStroke.getText()+')";
    instruksiPenyakit[0][1] = "insert into HasilObatAHPPrioritasPertamaKriteriaHarga(Nama_Penyakit) values ('Myocardial Infarction')";
    instruksiPenyakit[1][1] = "insert into HasilObatAHPPrioritasKeduaKriteriaHarga(Nama_Penyakit) values ('Myocardial Infarction')";
    instruksiPenyakit[2][1] = "insert into HasilObatAHPPrioritasKetigaKriteriaHarga(Nama_Penyakit) values ('Myocardial Infarction')";
    instruksiPenyakit[3][1] = "insert into HasilObatAHPPrioritasKeempatKriteriaHarga(Nama_Penyakit) values ('Myocardial Infarction')";
    instruksiPenyakit[4][1] = "insert into HasilObatAHPPrioritasKelimaKriteriaHarga(Nama_Penyakit) values ('Myocardial Infarction')";
    instruksiPenyakit[5][1] = "insert into HasilObatAHPPrioritasPertamaKriteriaEfekSamping(Nama_Penyakit) values ('Myocardial Infarction)'";
    instruksiPenyakit[6][1] = "insert into HasilObatAHPPrioritasKeduaKriteriaEfekSamping(Nama_Penyakit) values ('Myocardial Infarction)'";
    instruksiPenyakit[7][1] = "insert into HasilObatAHPPrioritasKetigaKriteriaEfekSamping(Nama_Penyakit) values ('Myocardial Infarction)'";
    instruksiPenyakit[8][1] = "insert into HasilObatAHPPrioritasKeempatKriteriaEfekSamping(Nama_Penyakit) values ('Myocardial Infarction)'";
    instruksiPenyakit[9][1] = "insert into HasilObatAHPPrioritasKelimaKriteriaEfekSamping(Nama_Penyakit) values ('Myocardial Infarction)'";
    instruksiPenyakit[10][1] = "insert into HasilObatAHPPrioritasPertamaKriteriaKualitas(Nama_Penyakit) values ('Myocardial Infarction)'";
    instruksiPenyakit[11][1] = "insert into HasilObatAHPPrioritasKeduaKriteriaKualitas(Nama_Penyakit) values ('Myocardial Infarction)'";
    instruksiPenyakit[12][1] = "insert into HasilObatAHPPrioritasKetigaKriteriaKualitas(Nama_Penyakit) values ('Myocardial Infarction)'";
    instruksiPenyakit[13][1] = "insert into HasilObatAHPPrioritasKeempatKriteriaKualitas(Nama_Penyakit) values ('Myocardial Infarction)'";
    instruksiPenyakit[14][1] = "insert into HasilObatAHPPrioritasKelimaKriteriaKualitas(Nama_Penyakit) values ('Myocardial Infarction)'";
    instruksiPenyakit[15][1] = "insert into HasilObatAHPPrioritasPertamaKriteriaKetersediaan(Nama_Penyakit) values ('Myocardial Infarction)'";
    instruksiPenyakit[16][1] = "insert into HasilObatAHPPrioritasKeduaKriteriaKetersediaan(Nama_Penyakit) values ('Myocardial Infarction)'";
    instruksiPenyakit[17][1] = "insert into HasilObatAHPPrioritasKetigaKriteriaKetersediaan(Nama_Penyakit) values ('Myocardial Infarction)'";
    instruksiPenyakit[18][1] = "insert into HasilObatAHPPrioritasKeempatKriteriaKetersediaan(Nama_Penyakit) values ('Myocardial Infarction)'";
    instruksiPenyakit[19][1] = "insert into HasilObatAHPPrioritasKelimaKriteriaKetersediaan(Nama_Penyakit) values ('Stroke)'";
    instruksiPenyakit[0][3] = "insert into HasilObatAHPPrioritasPertamaKriteriaHarga(Nama_Penyakit) values ('Stroke')";
    instruksiPenyakit[1][3] = "insert into HasilObatAHPPrioritasKeduaKriteriaHarga(Nama_Penyakit) values ('Stroke')";
    instruksiPenyakit[2][3] = "insert into HasilObatAHPPrioritasKetigaKriteriaHarga(Nama_Penyakit) values ('Stroke')";
    instruksiPenyakit[3][3] = "insert into HasilObatAHPPrioritasKeempatKriteriaHarga(Nama_Penyakit) values ('Stroke')";
    instruksiPenyakit[4][3] = "insert into HasilObatAHPPrioritasKelimaKriteriaHarga(Nama_Penyakit) values ('Stroke')";
    instruksiPenyakit[5][3] = "insert into HasilObatAHPPrioritasPertamaKriteriaEfekSamping(Nama_Penyakit) values ('Stroke)'";
    instruksiPenyakit[6][3] = "insert into HasilObatAHPPrioritasKeduaKriteriaEfekSamping(Nama_Penyakit) values ('Stroke)'";
    instruksiPenyakit[7][3] = "insert into HasilObatAHPPrioritasKetigaKriteriaEfekSamping(Nama_Penyakit) values ('Stroke)'";
    instruksiPenyakit[8][3] = "insert into HasilObatAHPPrioritasKeempatKriteriaEfekSamping(Nama_Penyakit) values ('Stroke)'";
    instruksiPenyakit[9][3] = "insert into HasilObatAHPPrioritasKelimaKriteriaEfekSamping(Nama_Penyakit) values ('Stroke)'";
    instruksiPenyakit[10][3] = "insert into HasilObatAHPPrioritasPertamaKriteriaKualitas(Nama_Penyakit) values ('Stroke)'";
    instruksiPenyakit[11][3] = "insert into HasilObatAHPPrioritasKeduaKriteriaKualitas(Nama_Penyakit) values ('Stroke)'";
    instruksiPenyakit[12][3] = "insert into HasilObatAHPPrioritasKetigaKriteriaKualitas(Nama_Penyakit) values ('Stroke)'";
    instruksiPenyakit[13][3] = "insert into HasilObatAHPPrioritasKeempatKriteriaKualitas(Nama_Penyakit) values ('Stroke)'";
    instruksiPenyakit[14][3] = "insert into HasilObatAHPPrioritasKelimaKriteriaKualitas(Nama_Penyakit) values ('Stroke)'";
    instruksiPenyakit[15][3] = "insert into HasilObatAHPPrioritasPertamaKriteriaKetersediaan(Nama_Penyakit) values ('Stroke)'";
    instruksiPenyakit[16][3] = "insert into HasilObatAHPPrioritasKeduaKriteriaKetersediaan(Nama_Penyakit) values ('Stroke)'";
    instruksiPenyakit[17][3] = "insert into HasilObatAHPPrioritasKetigaKriteriaKetersediaan(Nama_Penyakit) values ('Stroke)'";
    instruksiPenyakit[18][3] = "insert into HasilObatAHPPrioritasKeempatKriteriaKetersediaan(Nama_Penyakit) values ('Stroke)'";
    instruksiPenyakit[19][3] = "insert into HasilObatAHPPrioritasKelimaKriteriaKetersediaan(Nama_Penyakit) values ('Stroke)'";        
    sql[0] = "select Nama_Obat from HasilObatAHPPrioritasUtamaKriteriaHarga where Nama_Obat = '"+alternatifUtamaKriteriaHargaMyocardialInfarction.getText()+"'";
    sql[1] = "select Nama_Obat from HasilObatAHPPrioritasKeduaKriteriaHarga where Nama_Obat = '"+alternatif2KriteriaHargaMyocardialInfarction.getText()+"'";
    sql[2] = "select Nama_Obat from HasilObatAHPPrioritasKetigaKriteriaHarga where Nama_Obat = '"+alternatif3KriteriaHargaMyocardialInfarction.getText()+"'";
    sql[3] = "select Nama_Obat from HasilObatAHPPrioritasKeempatKriteriaHarga where Nama_Obat = '"+alternatif4KriteriaHargaMyocardialInfarction.getText()+"'";
    sql[4] = "select Nama_Obat from HasilObatAHPPrioritasKelimaKriteriaHarga where Nama_Obat = '"+alternatif5KriteriaHargaMyocardialInfarction.getText()+"'";
    sql[5] = "select Nama_Obat from HasilObatAHPPrioritasUtamaKriteriaEfekSamping where Nama_Obat = '"+alternatifUtamaKriteriaEfekSampingMyocardialInfarction.getText()+"'";
    sql[6] = "select Nama_Obat from HasilObatAHPPrioritasKeduaKriteriaEfekSamping where Nama_Obat = '"+alternatif2KriteriaEfekSampingMyocardialInfarction.getText()+"'";
    sql[7] = "select Nama_Obat from HasilObatAHPPrioritasKetigaKriteriaEfekSamping where Nama_Obat = '"+alternatif3KriteriaEfekSampingMyocardialInfarction.getText()+"'";
    sql[8] = "select Nama_Obat from HasilObatAHPPrioritasKeempatKriteriaEfekSamping where Nama_Obat = '"+alternatif4KriteriaEfekSampingMyocardialInfarction.getText()+"'";
    sql[9] = "select Nama_Obat from HasilObatAHPPrioritasKelimaKriteriaEfekSamping where Nama_Obat = '"+alternatif5KriteriaEfekSampingMyocardialInfarction.getText()+"'";
    sql[10] = "select Nama_Obat from HasilObatAHPPrioritasUtamaKriteriaKualitas where Nama_Obat = '"+alternatifUtamaKriteriaKualitasMyocardialInfarction.getText()+"'";
    sql[11] = "select Nama_Obat from HasilObatAHPPrioritasKeduaKriteriaKualitas where Nama_Obat = '"+alternatif2KriteriaKualitasMyocardialInfarction.getText()+"'";
    sql[12] = "select Nama_Obat from HasilObatAHPPrioritasKetigaKriteriaKualitas where Nama_Obat = '"+alternatif3KriteriaKualitasMyocardialInfarction.getText()+"'";
    sql[13] = "select Nama_Obat from HasilObatAHPPrioritasKeempatKriteriaKualitas where Nama_Obat = '"+alternatif4KriteriaKualitasMyocardialInfarction.getText()+"'";
    sql[14] = "select Nama_Obat from HasilObatAHPPrioritasKelimaKriteriaKualitas where Nama_Obat = '"+alternatif5KriteriaKualitasMyocardialInfarction.getText()+"'";
    sql[15] = "select Nama_Obat from HasilObatAHPPrioritasUtamaKriteriaKetersediaan where Nama_Obat = '"+alternatifUtamaKriteriaKetersediaanMyocardialInfarction.getText()+"'";
    sql[16] = "select Nama_Obat from HasilObatAHPPrioritasKeduaKriteriaKetersediaan where Nama_Obat = '"+alternatif2KriteriaKetersediaanMyocardialInfarction.getText()+"'";
    sql[17] = "select Nama_Obat from HasilObatAHPPrioritasKetigaKriteriaKetersediaan where Nama_Obat = '"+alternatif3KriteriaKetersediaanMyocardialInfarction.getText()+"'";
    sql[18] = "select Nama_Obat from HasilObatAHPPrioritasKeempatKriteriaketersediaan where Nama_Obat = '"+alternatif4KriteriaKetersediaanMyocardialInfarction.getText()+"'";
    sql[19] = "select Nama_Obat from HasilObatAHPPrioritasKelimaKriteriaKetersediaan where Nama_Obat = '"+alternatif5KriteriaKetersediaanMyocardialInfarction.getText()+"'";
    sql[20] = "select Nama_Obat from HasilObatAHPPrioritasUtamaKriteriaHarga where Nama_Obat = '"+alternatifUtamaKriteriaHargaStroke.getText()+"'";
    sql[21] = "select Nama_Obat from HasilObatAHPPrioritasKeduaKriteriaHarga where Nama_Obat = '"+alternatif2KriteriaHargaStroke.getText()+"'";
    sql[22] = "select Nama_Obat from HasilObatAHPPrioritasKetigaKriteriaHarga where Nama_Obat = '"+alternatif3KriteriaHargaStroke.getText()+"'";
    sql[23] = "select Nama_Obat from HasilObatAHPPrioritasKeempatKriteriaHarga where Nama_Obat = '"+alternatif4KriteriaHargaStroke.getText()+"'";
    sql[24] = "select Nama_Obat from HasilObatAHPPrioritasKelimaKriteriaHarga where Nama_Obat = '"+alternatif5KriteriaHargaStroke.getText()+"'";
    sql[25] = "select Nama_Obat from HasilObatAHPPrioritasUtamaKriteriaEfekSamping where Nama_Obat = '"+alternatifUtamaKriteriaEfekSampingStroke.getText()+"'";
    sql[26] = "select Nama_Obat from HasilObatAHPPrioritasKeduaKriteriaEfekSamping where Nama_Obat = '"+alternatif2KriteriaEfekSampingStroke.getText()+"'";
    sql[27] = "select Nama_Obat from HasilObatAHPPrioritasKetigaKriteriaEfekSamping where Nama_Obat = '"+alternatif3KriteriaEfekSampingStroke.getText()+"'";
    sql[28] = "select Nama_Obat from HasilObatAHPPrioritasKeempatKriteriaEfekSamping where Nama_Obat = '"+alternatif4KriteriaEfekSampingStroke.getText()+"'";
    sql[29] = "select Nama_Obat from HasilObatAHPPrioritasKelimaKriteriaEfekSamping where Nama_Obat = '"+alternatif5KriteriaEfekSampingStroke.getText()+"'";
    sql[30] = "select Nama_Obat from HasilObatAHPPrioritasUtamaKriteriaKualitas where Nama_Obat = '"+alternatifUtamaKriteriaKualitasStroke.getText()+"'";
    sql[31] = "select Nama_Obat from HasilObatAHPPrioritasKeduaKriteriaKualitas where Nama_Obat = '"+alternatif2KriteriaKualitasStroke.getText()+"'";
    sql[32] = "select Nama_Obat from HasilObatAHPPrioritasKetigaKriteriaKualitas where Nama_Obat = '"+alternatif3KriteriaKualitasStroke.getText()+"'";
    sql[33] = "select Nama_Obat from HasilObatAHPPrioritasKeempatKriteriaKualitas where Nama_Obat = '"+alternatif4KriteriaKualitasStroke.getText()+"'";
    sql[34] = "select Nama_Obat from HasilObatAHPPrioritasKelimaKriteriaKualitas where Nama_Obat = '"+alternatif5KriteriaKualitasStroke.getText()+"'";
    sql[35] = "select Nama_Obat from HasilObatAHPPrioritasUtamaKriteriaKetersediaan where Nama_Obat = '"+alternatifUtamaKriteriaKetersediaanStroke.getText()+"'";
    sql[36] = "select Nama_Obat from HasilObatAHPPrioritasKeduaKriteriaKetersediaan where Nama_Obat = '"+alternatif2KriteriaKetersediaanStroke.getText()+"'";
    sql[37] = "select Nama_Obat from HasilObatAHPPrioritasKetigaKriteriaKetersediaan where Nama_Obat = '"+alternatif3KriteriaKetersediaanStroke.getText()+"'";
    sql[38] = "select Nama_Obat from HasilObatAHPPrioritasKeempatKriteriaketersediaan where Nama_Obat = '"+alternatif4KriteriaKetersediaanStroke.getText()+"'";
    sql[39] = "select Nama_Obat from HasilObatAHPPrioritasKelimaKriteriaKetersediaan where Nama_Obat = '"+alternatif5KriteriaKetersediaanStroke.getText()+"'";
    sql[79] = "select Bobot_Kriteria from DaftarBobotKriteriaMyocardialInfarction where Bobot_Kriteria = '"+kriteriaHargaStroke.getText()+"'";
    sql[80] = "select Bobot_Kriteria from DaftarBobotKriteriaMyocardialInfarction where Bobot_Kriteria = '"+kriteriaEfekSampingStroke.getText()+"'";
    sql[81] = "select Bobot_Kriteria from DaftarBobotKriteriaMyocardialInfarction where Bobot_Kriteria = '"+kriteriaKualitasStroke.getText()+"'";
    sql[82] = "select Bobot_Kriteria from DaftarBobotKriteriaMyocardialInfarction where Bobot_Kriteria = '"+kriteriaKetersediaanStroke.getText()+"'";
    sql[83] = "select Bobot_Kriteria from DaftarBobotKriteriaStroke where Bobot_Kriteria = '"+kriteriaHargaStroke.getText()+"'";
    sql[84] = "select Bobot_Kriteria from DaftarBobotKriteriaStroke where Bobot_Kriteria = '"+kriteriaEfekSampingStroke.getText()+"'";
    sql[85] = "select Bobot_Kriteria from DaftarBobotKriteriaStroke where Bobot_Kriteria = '"+kriteriaKualitasStroke.getText()+"'";
    sql[86] = "select Bobot_Kriteria from DaftarBobotKriteriaStroke where Bobot_Kriteria = '"+kriteriaKetersediaanStroke.getText()+"'";
    sql[39] = "select Nama_Obat from HasilObatAHPPrioritasUtamaKriteriaHarga where Nama_Penyakit = 'Stroke'";
    sql[40] = "select Nama_Obat from HasilObatAHPPrioritasKeduaKriteriaHarga where Nama_Penyakit = 'Stroke'";
    sql[41] = "select Nama_Obat from HasilObatAHPPrioritasKetigaKriteriaHarga where Nama_Penyakit = 'Stroke'";
    sql[42] = "select Nama_Obat from HasilObatAHPPrioritasKeempatKriteriaHarga where Nama_Penyakit = 'Stroke'";
    sql[43] = "select Nama_Obat from HasilObatAHPPrioritasKelimaKriteriaHarga where Nama_Penyakit = 'Stroke'";
    sql[44] = "select Nama_Obat from HasilObatAHPPrioritasUtamaKriteriaEfekSamping where Nama_Penyakit = 'Stroke'";
    sql[45] = "select Nama_Obat from HasilObatAHPPrioritasKeduaKriteriaEfekSamping where Nama_Penyakit = 'Stroke'";
    sql[46] = "select Nama_Obat from HasilObatAHPPrioritasKetigaKriteriaEfekSamping where Nama_Penyakit = 'Stroke'";
    sql[47] = "select Nama_Obat from HasilObatAHPPrioritasKeempatKriteriaEfekSamping where Nama_Penyakit = 'Stroke'";
    sql[48] = "select Nama_Obat from HasilObatAHPPrioritasKelimaKriteriaEfekSamping where Nama_Penyakit = 'Stroke'";
    sql[49] = "select Nama_Obat from HasilObatAHPPrioritasUtamaKriteriaKualitas where Nama_Penyakit = 'Stroke'";
    sql[50] = "select Nama_Obat from HasilObatAHPPrioritasKeduaKriteriaKualitas where Nama_Penyakit = 'Stroke'";
    sql[51] = "select Nama_Obat from HasilObatAHPPrioritasKetigaKriteriaKualitas where Nama_Penyakit = 'Stroke'";
    sql[52] = "select Nama_Obat from HasilObatAHPPrioritasKeempatKriteriaKualitas where Nama_Penyakit = 'Stroke'";
    sql[53] = "select Nama_Obat from HasilObatAHPPrioritasKelimaKriteriaKualitas where Nama_Penyakit = 'Stroke'";
    sql[54] = "select Nama_Obat from HasilObatAHPPrioritasUtamaKriteriaKetersediaan where Nama_Penyakit = 'Stroke'";
    sql[55] = "select Nama_Obat from HasilObatAHPPrioritasKeduaKriteriaKetersediaan where Nama_Penyakit = 'Stroke'";
    sql[56] = "select Nama_Obat from HasilObatAHPPrioritasKetigaKriteriaKetersediaan where Nama_Penyakit = 'Stroke'";
    sql[57] = "select Nama_Obat from HasilObatAHPPrioritasKeempatKriteriaketersediaan where Nama_Penyakit = 'Stroke'";
    sql[58] = "select Nama_Obat from HasilObatAHPPrioritasKelimaKriteriaKetersediaan where Nama_Penyakit = 'Stroke'";
    sql[59] = "select Nama_Obat from HasilObatAHPPrioritasUtamaKriteriaHarga where Nama_Penyakit = 'Myocardial Infarction'";
    sql[60] = "select Nama_Obat from HasilObatAHPPrioritasKeduaKriteriaHarga where Nama_Penyakit = 'Myocardial Infarction'";
    sql[61] = "select Nama_Obat from HasilObatAHPPrioritasKetigaKriteriaHarga where Nama_Penyakit = 'Myocardial Infarction'";
    sql[62] = "select Nama_Obat from HasilObatAHPPrioritasKeempatKriteriaHarga where Nama_Penyakit = 'Myocardial Infarction'";
    sql[63] = "select Nama_Obat from HasilObatAHPPrioritasKelimaKriteriaHarga where Nama_Penyakit = 'Myocardial Infarction'";
    sql[64] = "select Nama_Obat from HasilObatAHPPrioritasUtamaKriteriaEfekSamping where Nama_Penyakit = 'Myocardial Infarction'";
    sql[65] = "select Nama_Obat from HasilObatAHPPrioritasKeduaKriteriaEfekSamping where Nama_Penyakit = 'Myocardial Infarction'";
    sql[66] = "select Nama_Obat from HasilObatAHPPrioritasKetigaKriteriaEfekSamping where Nama_Penyakit = 'Myocardial Infarction'";
    sql[67] = "select Nama_Obat from HasilObatAHPPrioritasKeempatKriteriaEfekSamping where Nama_Penyakit = 'Myocardial Infarction'";
    sql[68] = "select Nama_Obat from HasilObatAHPPrioritasKelimaKriteriaEfekSamping where Nama_Penyakit = 'Myocardial Infarction'";
    sql[69] = "select Nama_Obat from HasilObatAHPPrioritasUtamaKriteriaKualitas where Nama_Penyakit = 'Myocardial Infarction'";
    sql[70] = "select Nama_Obat from HasilObatAHPPrioritasKeduaKriteriaKualitas where Nama_Penyakit = 'Myocardial Infarction'";
    sql[71] = "select Nama_Obat from HasilObatAHPPrioritasKetigaKriteriaKualitas where Nama_Penyakit = 'Myocardial Infarction'";
    sql[72] = "select Nama_Obat from HasilObatAHPPrioritasKeempatKriteriaKualitas where Nama_Penyakit = 'Myocardial Infarction'";
    sql[73] = "select Nama_Obat from HasilObatAHPPrioritasKelimaKriteriaKualitas where Nama_Penyakit = 'Myocardial Infarction'";
    sql[74] = "select Nama_Obat from HasilObatAHPPrioritasUtamaKriteriaKetersediaan where Nama_Penyakit = 'Myocardial Infarction'";
    sql[75] = "select Nama_Obat from HasilObatAHPPrioritasKeduaKriteriaKetersediaan where Nama_Penyakit = 'Myocardial Infarction'";
    sql[76] = "select Nama_Obat from HasilObatAHPPrioritasKetigaKriteriaKetersediaan where Nama_Penyakit = 'Myocardial Infarction'";
    sql[77] = "select Nama_Obat from HasilObatAHPPrioritasKeempatKriteriaketersediaan where Nama_Penyakit = 'Myocardial Infarction'";
    sql[78] = "select Nama_Obat from HasilObatAHPPrioritasKelimaKriteriaKetersediaan where Nama_Penyakit = 'Myocardial Infarction'";
    try {
        statement = connection.createStatement();
        for (i = 0; i < 40; i++) 
        {
             kriteria[i] = statement.executeQuery(sql[i]);
             while (kriteria[i].next()) {
                  penyakit[i][0] = kriteria[i].getString("Nama_Obat");
             }
        }
        for (m = 0; m < 39; m++) 
        {
            j = m + 40; 
            kriteria[j] = statement.executeQuery(sql[j]);
            while (kriteria[j].next()) 
            {
                 penyakit[m][1] = kriteria[j].getString("Nama_Penyakit");
            }
        }
        for (k = 0;k < 8; k++) 
        {
            l = k + 79;
            kriteria[l] = statement.executeQuery(sql[l]);
             while (kriteria[l].next()) 
             {
                  bobot[k] = kriteria[l].getString("Bobot_Kriteria");
             }
        }
    }    
    catch (SQLException e) {
        taruhHasil.append(e.getMessage());
    }
    bobot1[0][0] = "insert into DaftarBobotKriteriaMyocardialInfarction(Bobot_Kriteria) values ('+kriteriaHargaMyocardialInfarction.getText()+')";
    bobot1[1][0] = "insert into DaftarBobotKriteriaMyocardialInfarction(Bobot_Kriteria) values ('+kriteriaEfekSampingMyocardialInfarction.getText()+')";
    bobot1[2][0] = "insert into DaftarBobotKriteriaMyocardialInfarction(Bobot_Kriteria) values ('+kriteriaKualitasMyocardialInfarction.getText()+')";
    bobot1[3][0] = "insert into DaftarBobotKriteriaMyocardialInfarction(Bobot_Kriteria) values ('+kriteriaKetersediaanMyocardialInfarction.getText()+')";
    bobot1[0][1] = "insert into DaftarBobotKriteriaStroke(Bobot_Kriteria) values ('+kriteriaHargaStroke.getText()+')";
    bobot1[1][1] = "insert into DaftarBobotKriteriaStroke(Bobot_Kriteria) values ('+kriteriaEfekSampingStroke.getText()+')";
    bobot1[2][1] = "insert into DaftarBobotKriteriaStroke(Bobot_Kriteria) values ('+kriteriaKualitasStroke.getText()+')";
    bobot1[3][1] = "insert into DaftarBobotKriteriaStroke(Bobot_Kriteria) values ('+kriteriaKetersediaanStroke.getText()+')";
      
    if ((!"".equals(alternatifUtamaKriteriaHargaMyocardialInfarction.getText())) && (!"".equals(alternatifUtamaKriteriaEfekSampingMyocardialInfarction.getText())) && (!"".equals(alternatifUtamaKriteriaKualitasMyocardialInfarction.getText())) && (!"".equals(alternatifUtamaKriteriaKetersediaanMyocardialInfarction.getText())) && (!"".equals(kriteriaHargaMyocardialInfarction.getText())) && (!"".equals(kriteriaEfekSampingMyocardialInfarction.getText())) && (!"".equals(kriteriaKualitasMyocardialInfarction.getText())) && (!"".equals(kriteriaKetersediaanMyocardialInfarction.getText())) && (!"".equals(kriteriaHargaStroke.getText())) && (!"".equals(kriteriaEfekSampingStroke.getText())) && (!"".equals(kriteriaKualitasStroke.getText())) && (!"".equals(kriteriaKetersediaanStroke.getText()))) 
    {
            if (("".equals(penyakit[0][1])) && ("".equals(penyakit[5][1])) && ("".equals(penyakit[10][1])) && ("".equals(penyakit[15][1]))) 
            {
                if (("".equals(penyakit[0][0])) && ("".equals(penyakit[5][0])) && ("".equals(penyakit[10][0])) && ("".equals(penyakit[15][0]))) 
                {
                    if (("".equals(bobot[0])) && ("".equals(bobot[1])) && ("".equals(bobot[2])) && ("".equals(bobot[3])))
                    {
                       lengkap();
                       prosedurBobot();
                    }
                }
                   else if (("".equals(bobot[0])) && ("".equals(bobot[1])) && ("".equals(bobot[2])))
                    {
                        lengkap();
                        prosedurBobot1();
                    }
                   else if (("".equals(bobot[0])) && ("".equals(bobot[1])) && ("".equals(bobot[3])))
                    {
                        lengkap();                        
                        prosedurBobot2();
                    }
                   else if (("".equals(bobot[0])) && ("".equals(bobot[2])) && ("".equals(bobot[3])))
                   {
                        lengkap();
                        prosedurBobot3();                        
                   }
                   else if (("".equals(bobot[1])) && ("".equals(bobot[2])) && ("".equals(bobot[3])))
                   {
                        lengkap();
                        prosedurBobot4();
                   }
                   else if (("".equals(bobot[0])) && ("".equals(bobot[1])))
                   {
                       lengkap();
                       prosedurBobot5();
                   }
                   else if (("".equals(bobot[0])) && ("".equals(bobot[2])))
                   {
                       lengkap();
                       prosedurBobot6();
                   }
                   else if (("".equals(bobot[0])) && ("".equals(bobot[3])))
                   {
                       lengkap();
                       prosedurBobot7();
                   }
                   else if (("".equals(bobot[0])))
                   {
                       lengkap();
                       prosedurBobot8();
                   }
                   else if (("".equals(bobot[1])))
                   {
                       lengkap();
                       prosedurBobot9();
                   }
                   else if (("".equals(bobot[2])))
                   {
                       lengkap();
                       prosedurBobot10();
                   }
                   else if (("".equals(bobot[3])))
                   {
                       lengkap();
                       prosedurBobot11();
                   }
                }
            if (("".equals(penyakit[0][0])) && ("".equals(penyakit[5][0])) && ("".equals(penyakit[10][0]))) 
                {
                    if (("".equals(bobot[0])) && ("".equals(bobot[1])) && ("".equals(bobot[2])) && ("".equals(bobot[3])))
                    {
                       tidakLengkap1();
                       prosedurBobot();
                    }
                }
                   else if (("".equals(bobot[0])) && ("".equals(bobot[1])) && ("".equals(bobot[2])))
                    {
                        tidakLengkap1();
                        prosedurBobot1();
                    }
                   else if (("".equals(bobot[0])) && ("".equals(bobot[1])) && ("".equals(bobot[3])))
                    {
                        tidakLengkap1();                        
                        prosedurBobot2();
                    }
                   else if (("".equals(bobot[0])) && ("".equals(bobot[2])) && ("".equals(bobot[3])))
                   {
                        tidakLengkap1();
                        prosedurBobot3();                        
                   }
                   else if (("".equals(bobot[1])) && ("".equals(bobot[2])) && ("".equals(bobot[3])))
                   {
                        tidakLengkap1();
                        prosedurBobot4();
                   }
                   else if (("".equals(bobot[0])) && ("".equals(bobot[1])))
                   {
                        tidakLengkap1();
                        prosedurBobot5();
                   }
                   else if (("".equals(bobot[0])) && ("".equals(bobot[2])))
                   {
                        tidakLengkap1();
                        prosedurBobot6();
                   }
                   else if (("".equals(bobot[0])) && ("".equals(bobot[3])))
                   {
                        tidakLengkap1();
                        prosedurBobot7();
                   }
                   else if (("".equals(bobot[0])))
                   {
                        tidakLengkap1();
                        prosedurBobot8();
                   }
                   else if (("".equals(bobot[1])))
                   {
                        tidakLengkap1();
                        prosedurBobot9();
                   }
                   else if (("".equals(bobot[2])))
                   {
                        tidakLengkap1();
                        prosedurBobot10();
                   }
                   else if (("".equals(bobot[3])))
                   {
                        tidakLengkap1();
                        prosedurBobot11();
                   }
            if (("".equals(penyakit[0][0])) && ("".equals(penyakit[5][0])) && ("".equals(penyakit[15][0]))) 
                {
                    if (("".equals(bobot[0])) && ("".equals(bobot[1])) && ("".equals(bobot[2])) && ("".equals(bobot[3])))
                    {
                       tidakLengkap2();
                       prosedurBobot();
                    }
                }
                   else if (("".equals(bobot[0])) && ("".equals(bobot[1])) && ("".equals(bobot[2])))
                    {
                        tidakLengkap2();
                        prosedurBobot1();
                    }
                   else if (("".equals(bobot[0])) && ("".equals(bobot[1])) && ("".equals(bobot[3])))
                    {
                        tidakLengkap2();                        
                        prosedurBobot2();
                    }
                   else if (("".equals(bobot[0])) && ("".equals(bobot[2])) && ("".equals(bobot[3])))
                   {
                        tidakLengkap2();
                        prosedurBobot3();                        
                   }
                   else if (("".equals(bobot[1])) && ("".equals(bobot[2])) && ("".equals(bobot[3])))
                   {
                        tidakLengkap2();
                        prosedurBobot4();
                   }
                   else if (("".equals(bobot[0])) && ("".equals(bobot[1])))
                   {
                        tidakLengkap2();
                        prosedurBobot5();
                   }
                   else if (("".equals(bobot[0])) && ("".equals(bobot[2])))
                   {
                        tidakLengkap2();
                        prosedurBobot6();
                   }
                   else if (("".equals(bobot[0])) && ("".equals(bobot[3])))
                   {
                        tidakLengkap2();
                        prosedurBobot7();
                   }
                   else if (("".equals(bobot[0])))
                   {
                        tidakLengkap2();
                        prosedurBobot8();
                   }
                   else if (("".equals(bobot[1])))
                   {
                        tidakLengkap2();
                        prosedurBobot9();
                   }
                   else if (("".equals(bobot[2])))
                   {
                        tidakLengkap2();
                        prosedurBobot10();
                   }
                   else if (("".equals(bobot[3])))
                   {
                        tidakLengkap2();
                        prosedurBobot11();
                   }
            if (("".equals(penyakit[0][0])) && ("".equals(penyakit[10][0])) && ("".equals(penyakit[15][0]))) 
                {
                    if (("".equals(bobot[0])) && ("".equals(bobot[1])) && ("".equals(bobot[2])) && ("".equals(bobot[3])))
                    {
                       tidakLengkap3();
                       prosedurBobot();
                    }
                }
                   else if (("".equals(bobot[0])) && ("".equals(bobot[1])) && ("".equals(bobot[2])))
                    {
                        tidakLengkap3();
                        prosedurBobot1();
                    }
                   else if (("".equals(bobot[0])) && ("".equals(bobot[1])) && ("".equals(bobot[3])))
                    {
                        tidakLengkap3();                        
                        prosedurBobot2();
                    }
                   else if (("".equals(bobot[0])) && ("".equals(bobot[2])) && ("".equals(bobot[3])))
                   {
                        tidakLengkap3();
                        prosedurBobot3();                        
                   }
                   else if (("".equals(bobot[1])) && ("".equals(bobot[2])) && ("".equals(bobot[3])))
                   {
                        tidakLengkap3();
                        prosedurBobot4();
                   }
                   else if (("".equals(bobot[0])) && ("".equals(bobot[1])))
                   {
                        tidakLengkap3();
                        prosedurBobot5();
                   }
                   else if (("".equals(bobot[0])) && ("".equals(bobot[2])))
                   {
                        tidakLengkap3();
                        prosedurBobot6();
                   }
                   else if (("".equals(bobot[0])) && ("".equals(bobot[3])))
                   {
                        tidakLengkap3();
                        prosedurBobot7();
                   }
                   else if (("".equals(bobot[0])))
                   {
                        tidakLengkap3();
                        prosedurBobot8();
                   }
                   else if (("".equals(bobot[1])))
                   {
                        tidakLengkap3();
                        prosedurBobot9();
                   }
                   else if (("".equals(bobot[2])))
                   {
                        tidakLengkap3();
                        prosedurBobot10();
                   }
                   else if (("".equals(bobot[3])))
                   {
                        tidakLengkap3();
                        prosedurBobot11();
                   }
            if (("".equals(penyakit[5][0])) && ("".equals(penyakit[10][0])) && ("".equals(penyakit[15][0]))) 
                {
                    if (("".equals(bobot[0])) && ("".equals(bobot[1])) && ("".equals(bobot[2])) && ("".equals(bobot[3])))
                    {
                       tidakLengkap4();
                       prosedurBobot();
                    }
                }
                   else if (("".equals(bobot[0])) && ("".equals(bobot[1])) && ("".equals(bobot[2])))
                    {
                        tidakLengkap4();
                        prosedurBobot1();
                    }
                   else if (("".equals(bobot[0])) && ("".equals(bobot[1])) && ("".equals(bobot[3])))
                    {
                        tidakLengkap4();                        
                        prosedurBobot2();
                    }
                   else if (("".equals(bobot[0])) && ("".equals(bobot[2])) && ("".equals(bobot[3])))
                   {
                        tidakLengkap4();
                        prosedurBobot3();                        
                   }
                   else if (("".equals(bobot[1])) && ("".equals(bobot[2])) && ("".equals(bobot[3])))
                   {
                        tidakLengkap4();
                        prosedurBobot4();
                   }
                   else if (("".equals(bobot[0])) && ("".equals(bobot[1])))
                   {
                        tidakLengkap4();
                        prosedurBobot5();
                   }
                   else if (("".equals(bobot[0])) && ("".equals(bobot[2])))
                   {
                        tidakLengkap4();
                        prosedurBobot6();
                   }
                   else if (("".equals(bobot[0])) && ("".equals(bobot[3])))
                   {
                        tidakLengkap4();
                        prosedurBobot7();
                   }
                   else if (("".equals(bobot[0])))
                   {
                        tidakLengkap4();
                        prosedurBobot8();
                   }
                   else if (("".equals(bobot[1])))
                   {
                        tidakLengkap4();
                        prosedurBobot9();
                   }
                   else if (("".equals(bobot[2])))
                   {
                        tidakLengkap4();
                        prosedurBobot10();
                   }
                   else if (("".equals(bobot[3])))
                   {
                        tidakLengkap4();
                        prosedurBobot11();
                   }
            if (("".equals(penyakit[0][0])) && ("".equals(penyakit[5][0]))) 
                {
                    if (("".equals(bobot[0])) && ("".equals(bobot[1])) && ("".equals(bobot[2])) && ("".equals(bobot[3])))
                    {
                       tidakLengkap5();
                       prosedurBobot();
                    }
                }
                   else if (("".equals(bobot[0])) && ("".equals(bobot[1])) && ("".equals(bobot[2])))
                    {
                        tidakLengkap5();
                        prosedurBobot1();
                    }
                   else if (("".equals(bobot[0])) && ("".equals(bobot[1])) && ("".equals(bobot[3])))
                    {
                        tidakLengkap5();                        
                        prosedurBobot2();
                    }
                   else if (("".equals(bobot[0])) && ("".equals(bobot[2])) && ("".equals(bobot[3])))
                   {
                        tidakLengkap5();
                        prosedurBobot3();                        
                   }
                   else if (("".equals(bobot[1])) && ("".equals(bobot[2])) && ("".equals(bobot[3])))
                   {
                        tidakLengkap5();
                        prosedurBobot4();
                   }
                   else if (("".equals(bobot[0])) && ("".equals(bobot[1])))
                   {
                        tidakLengkap5();
                        prosedurBobot5();
                   }
                   else if (("".equals(bobot[0])) && ("".equals(bobot[2])))
                   {
                        tidakLengkap5();
                        prosedurBobot6();
                   }
                   else if (("".equals(bobot[0])) && ("".equals(bobot[3])))
                   {
                        tidakLengkap5();
                        prosedurBobot7();
                   }
                   else if (("".equals(bobot[0])))
                   {
                        tidakLengkap5();
                        prosedurBobot8();
                   }
                   else if (("".equals(bobot[1])))
                   {
                        tidakLengkap5();
                        prosedurBobot9();
                   }
                   else if (("".equals(bobot[2])))
                   {
                        tidakLengkap5();
                        prosedurBobot10();
                   }
                   else if (("".equals(bobot[3])))
                   {
                        tidakLengkap5();
                        prosedurBobot11();
                   }
            if (("".equals(penyakit[0][0])) && ("".equals(penyakit[10][0]))) 
                {
                    if (("".equals(bobot[0])) && ("".equals(bobot[1])) && ("".equals(bobot[2])) && ("".equals(bobot[3])))
                    {
                       tidakLengkap6();
                       prosedurBobot();
                    }
                }
                   else if (("".equals(bobot[0])) && ("".equals(bobot[1])) && ("".equals(bobot[2])))
                    {
                        tidakLengkap6();
                        prosedurBobot1();
                    }
                   else if (("".equals(bobot[0])) && ("".equals(bobot[1])) && ("".equals(bobot[3])))
                    {
                        tidakLengkap6();                        
                        prosedurBobot2();
                    }
                   else if (("".equals(bobot[0])) && ("".equals(bobot[2])) && ("".equals(bobot[3])))
                   {
                        tidakLengkap6();
                        prosedurBobot3();                        
                   }
                   else if (("".equals(bobot[1])) && ("".equals(bobot[2])) && ("".equals(bobot[3])))
                   {
                        tidakLengkap6();
                        prosedurBobot4();
                   }
                   else if (("".equals(bobot[0])) && ("".equals(bobot[1])))
                   {
                        tidakLengkap6();
                        prosedurBobot5();
                   }
                   else if (("".equals(bobot[0])) && ("".equals(bobot[2])))
                   {
                        tidakLengkap6();
                        prosedurBobot6();
                   }
                   else if (("".equals(bobot[0])) && ("".equals(bobot[3])))
                   {
                        tidakLengkap6();
                        prosedurBobot7();
                   }
                   else if (("".equals(bobot[0])))
                   {
                        tidakLengkap6();
                        prosedurBobot8();
                   }
                   else if (("".equals(bobot[1])))
                   {
                        tidakLengkap6();
                        prosedurBobot9();
                   }
                   else if (("".equals(bobot[2])))
                   {
                        tidakLengkap6();
                        prosedurBobot10();
                   }
                   else if (("".equals(bobot[3])))
                   {
                        tidakLengkap6();
                        prosedurBobot11();
                   }
            if (("".equals(penyakit[0][0])) && ("".equals(penyakit[15][0]))) 
                {
                    if (("".equals(bobot[0])) && ("".equals(bobot[1])) && ("".equals(bobot[2])) && ("".equals(bobot[3])))
                    {
                       tidakLengkap7();
                       prosedurBobot();
                    }
                }
                   else if (("".equals(bobot[0])) && ("".equals(bobot[1])) && ("".equals(bobot[2])))
                    {
                        tidakLengkap7();
                        prosedurBobot1();
                    }
                   else if (("".equals(bobot[0])) && ("".equals(bobot[1])) && ("".equals(bobot[3])))
                    {
                        tidakLengkap7();                        
                        prosedurBobot2();
                    }
                   else if (("".equals(bobot[0])) && ("".equals(bobot[2])) && ("".equals(bobot[3])))
                   {
                        tidakLengkap7();
                        prosedurBobot3();                        
                   }
                   else if (("".equals(bobot[1])) && ("".equals(bobot[2])) && ("".equals(bobot[3])))
                   {
                        tidakLengkap7();
                        prosedurBobot4();
                   }
                   else if (("".equals(bobot[0])) && ("".equals(bobot[1])))
                   {
                        tidakLengkap7();
                        prosedurBobot5();
                   }
                   else if (("".equals(bobot[0])) && ("".equals(bobot[2])))
                   {
                        tidakLengkap7();
                        prosedurBobot6();
                   }
                   else if (("".equals(bobot[0])) && ("".equals(bobot[3])))
                   {
                        tidakLengkap7();
                        prosedurBobot7();
                   }
                   else if (("".equals(bobot[0])))
                   {
                        tidakLengkap7();
                        prosedurBobot8();
                   }
                   else if (("".equals(bobot[1])))
                   {
                        tidakLengkap7();
                        prosedurBobot9();
                   }
                   else if (("".equals(bobot[2])))
                   {
                        tidakLengkap7();
                        prosedurBobot10();
                   }
                   else if (("".equals(bobot[3])))
                   {
                        tidakLengkap7();
                        prosedurBobot11();
                   }
            if (("".equals(penyakit[5][0])) && ("".equals(penyakit[10][0]))) 
                {
                    if (("".equals(bobot[0])) && ("".equals(bobot[1])) && ("".equals(bobot[2])) && ("".equals(bobot[3])))
                    {
                       tidakLengkap8();
                       prosedurBobot();
                    }
                }
                   else if (("".equals(bobot[0])) && ("".equals(bobot[1])) && ("".equals(bobot[2])))
                    {
                        tidakLengkap8();
                        prosedurBobot1();
                    }
                   else if (("".equals(bobot[0])) && ("".equals(bobot[1])) && ("".equals(bobot[3])))
                    {
                        tidakLengkap8();                        
                        prosedurBobot2();
                    }
                   else if (("".equals(bobot[0])) && ("".equals(bobot[2])) && ("".equals(bobot[3])))
                   {
                        tidakLengkap8();
                        prosedurBobot3();                        
                   }
                   else if (("".equals(bobot[1])) && ("".equals(bobot[2])) && ("".equals(bobot[3])))
                   {
                        tidakLengkap8();
                        prosedurBobot4();
                   }
                   else if (("".equals(bobot[0])) && ("".equals(bobot[1])))
                   {
                        tidakLengkap8();
                        prosedurBobot5();
                   }
                   else if (("".equals(bobot[0])) && ("".equals(bobot[2])))
                   {
                        tidakLengkap8();
                        prosedurBobot6();
                   }
                   else if (("".equals(bobot[0])) && ("".equals(bobot[3])))
                   {
                        tidakLengkap8();
                        prosedurBobot7();
                   }
                   else if (("".equals(bobot[0])))
                   {
                        tidakLengkap8();
                        prosedurBobot8();
                   }
                   else if (("".equals(bobot[1])))
                   {
                        tidakLengkap8();
                        prosedurBobot9();
                   }
                   else if (("".equals(bobot[2])))
                   {
                        tidakLengkap8();
                        prosedurBobot10();
                   }
                   else if (("".equals(bobot[3])))
                   {
                        tidakLengkap8();
                        prosedurBobot11();
                   }
            if (("".equals(penyakit[5][0])) && ("".equals(penyakit[15][0]))) 
                {
                    if (("".equals(bobot[0])) && ("".equals(bobot[1])) && ("".equals(bobot[2])) && ("".equals(bobot[3])))
                    {
                       tidakLengkap9();
                       prosedurBobot();
                    }
                }
                   else if (("".equals(bobot[0])) && ("".equals(bobot[1])) && ("".equals(bobot[2])))
                    {
                        tidakLengkap9();
                        prosedurBobot1();
                    }
                   else if (("".equals(bobot[0])) && ("".equals(bobot[1])) && ("".equals(bobot[3])))
                    {
                        tidakLengkap9();                        
                        prosedurBobot2();
                    }
                   else if (("".equals(bobot[0])) && ("".equals(bobot[2])) && ("".equals(bobot[3])))
                   {
                        tidakLengkap9();
                        prosedurBobot3();                        
                   }
                   else if (("".equals(bobot[1])) && ("".equals(bobot[2])) && ("".equals(bobot[3])))
                   {
                        tidakLengkap9();
                        prosedurBobot4();
                   }
                   else if (("".equals(bobot[0])) && ("".equals(bobot[1])))
                   {
                        tidakLengkap9();
                        prosedurBobot5();
                   }
                   else if (("".equals(bobot[0])) && ("".equals(bobot[2])))
                   {
                        tidakLengkap9();
                        prosedurBobot6();
                   }
                   else if (("".equals(bobot[0])) && ("".equals(bobot[3])))
                   {
                        tidakLengkap9();
                        prosedurBobot7();
                   }
                   else if (("".equals(bobot[0])))
                   {
                        tidakLengkap9();
                        prosedurBobot8();
                   }
                   else if (("".equals(bobot[1])))
                   {
                        tidakLengkap9();
                        prosedurBobot9();
                   }
                   else if (("".equals(bobot[2])))
                   {
                        tidakLengkap9();
                        prosedurBobot10();
                   }
                   else if (("".equals(bobot[3])))
                   {
                        tidakLengkap9();
                        prosedurBobot11();
                   }
            if (("".equals(penyakit[10][0])) && ("".equals(penyakit[15][0]))) 
                {
                    if (("".equals(bobot[0])) && ("".equals(bobot[1])) && ("".equals(bobot[2])) && ("".equals(bobot[3])))
                    {
                       tidakLengkap10();
                       prosedurBobot();
                    }
                }
                   else if (("".equals(bobot[0])) && ("".equals(bobot[1])) && ("".equals(bobot[2])))
                    {
                        tidakLengkap10();
                        prosedurBobot1();
                    }
                   else if (("".equals(bobot[0])) && ("".equals(bobot[1])) && ("".equals(bobot[3])))
                    {
                        tidakLengkap10();                        
                        prosedurBobot2();
                    }
                   else if (("".equals(bobot[0])) && ("".equals(bobot[2])) && ("".equals(bobot[3])))
                   {
                        tidakLengkap10();
                        prosedurBobot3();                        
                   }
                   else if (("".equals(bobot[1])) && ("".equals(bobot[2])) && ("".equals(bobot[3])))
                   {
                        tidakLengkap10();
                        prosedurBobot4();
                   }
                   else if (("".equals(bobot[0])) && ("".equals(bobot[1])))
                   {
                        tidakLengkap10();
                        prosedurBobot5();
                   }
                   else if (("".equals(bobot[0])) && ("".equals(bobot[2])))
                   {
                        tidakLengkap10();
                        prosedurBobot6();
                   }
                   else if (("".equals(bobot[0])) && ("".equals(bobot[3])))
                   {
                        tidakLengkap10();
                        prosedurBobot7();
                   }
                   else if (("".equals(bobot[0])))
                   {
                        tidakLengkap10();
                        prosedurBobot8();
                   }
                   else if (("".equals(bobot[1])))
                   {
                        tidakLengkap10();
                        prosedurBobot9();
                   }
                   else if (("".equals(bobot[2])))
                   {
                        tidakLengkap10();
                        prosedurBobot10();
                   }
                   else if (("".equals(bobot[3])))
                   {
                        tidakLengkap10();
                        prosedurBobot11();
                   }
            if (("".equals(penyakit[0][0]))) 
                {
                    if (("".equals(bobot[0])) && ("".equals(bobot[1])) && ("".equals(bobot[2])) && ("".equals(bobot[3])))
                    {
                       tidakLengkap11();
                       prosedurBobot();
                    }
                }
                   else if (("".equals(bobot[0])) && ("".equals(bobot[1])) && ("".equals(bobot[2])))
                    {
                        tidakLengkap11();
                        prosedurBobot1();
                    }
                   else if (("".equals(bobot[0])) && ("".equals(bobot[1])) && ("".equals(bobot[3])))
                    {
                        tidakLengkap11();                        
                        prosedurBobot2();
                    }
                   else if (("".equals(bobot[0])) && ("".equals(bobot[2])) && ("".equals(bobot[3])))
                   {
                        tidakLengkap11();
                        prosedurBobot3();                        
                   }
                   else if (("".equals(bobot[1])) && ("".equals(bobot[2])) && ("".equals(bobot[3])))
                   {
                        tidakLengkap11();
                        prosedurBobot4();
                   }
                   else if (("".equals(bobot[0])) && ("".equals(bobot[1])))
                   {
                        tidakLengkap11();
                        prosedurBobot5();
                   }
                   else if (("".equals(bobot[0])) && ("".equals(bobot[2])))
                   {
                        tidakLengkap11();
                        prosedurBobot6();
                   }
                   else if (("".equals(bobot[0])) && ("".equals(bobot[3])))
                   {
                        tidakLengkap11();
                        prosedurBobot7();
                   }
                   else if (("".equals(bobot[0])))
                   {
                        tidakLengkap11();
                        prosedurBobot8();
                   }
                   else if (("".equals(bobot[1])))
                   {
                        tidakLengkap11();
                        prosedurBobot9();
                   }
                   else if (("".equals(bobot[2])))
                   {
                        tidakLengkap11();
                        prosedurBobot10();
                   }
                   else if (("".equals(bobot[3])))
                   {
                        tidakLengkap11();
                        prosedurBobot11();
                   }
            if (("".equals(penyakit[5][0]))) 
                {
                    if (("".equals(bobot[0])) && ("".equals(bobot[1])) && ("".equals(bobot[2])) && ("".equals(bobot[3])))
                    {
                       tidakLengkap12();
                       prosedurBobot();
                    }
                }
                   else if (("".equals(bobot[0])) && ("".equals(bobot[1])) && ("".equals(bobot[2])))
                    {
                        tidakLengkap12();
                        prosedurBobot1();
                    }
                   else if (("".equals(bobot[0])) && ("".equals(bobot[1])) && ("".equals(bobot[3])))
                    {
                        tidakLengkap12();                        
                        prosedurBobot2();
                    }
                   else if (("".equals(bobot[0])) && ("".equals(bobot[2])) && ("".equals(bobot[3])))
                   {
                        tidakLengkap12();
                        prosedurBobot3();                        
                   }
                   else if (("".equals(bobot[1])) && ("".equals(bobot[2])) && ("".equals(bobot[3])))
                   {
                        tidakLengkap12();
                        prosedurBobot4();
                   }
                   else if (("".equals(bobot[0])) && ("".equals(bobot[1])))
                   {
                        tidakLengkap12();
                        prosedurBobot5();
                   }
                   else if (("".equals(bobot[0])) && ("".equals(bobot[2])))
                   {
                        tidakLengkap12();
                        prosedurBobot6();
                   }
                   else if (("".equals(bobot[0])) && ("".equals(bobot[3])))
                   {
                        tidakLengkap12();
                        prosedurBobot7();
                   }
                   else if (("".equals(bobot[0])))
                   {
                        tidakLengkap12();
                        prosedurBobot8();
                   }
                   else if (("".equals(bobot[1])))
                   {
                        tidakLengkap12();
                        prosedurBobot9();
                   }
                   else if (("".equals(bobot[2])))
                   {
                        tidakLengkap12();
                        prosedurBobot10();
                   }
                   else if (("".equals(bobot[3])))
                   {
                        tidakLengkap12();
                        prosedurBobot11();
                   }
            if (("".equals(penyakit[10][0]))) 
                {
                    if (("".equals(bobot[0])) && ("".equals(bobot[1])) && ("".equals(bobot[2])) && ("".equals(bobot[3])))
                    {
                       tidakLengkap13();
                       prosedurBobot();
                    }
                }
                   else if (("".equals(bobot[0])) && ("".equals(bobot[1])) && ("".equals(bobot[2])))
                    {
                        tidakLengkap13();
                        prosedurBobot1();
                    }
                   else if (("".equals(bobot[0])) && ("".equals(bobot[1])) && ("".equals(bobot[3])))
                    {
                        tidakLengkap13();                        
                        prosedurBobot2();
                    }
                   else if (("".equals(bobot[0])) && ("".equals(bobot[2])) && ("".equals(bobot[3])))
                   {
                        tidakLengkap13();
                        prosedurBobot3();                        
                   }
                   else if (("".equals(bobot[1])) && ("".equals(bobot[2])) && ("".equals(bobot[3])))
                   {
                        tidakLengkap13();
                        prosedurBobot4();
                   }
                   else if (("".equals(bobot[0])) && ("".equals(bobot[1])))
                   {
                        tidakLengkap13();
                        prosedurBobot5();
                   }
                   else if (("".equals(bobot[0])) && ("".equals(bobot[2])))
                   {
                        tidakLengkap13();
                        prosedurBobot6();
                   }
                   else if (("".equals(bobot[0])) && ("".equals(bobot[3])))
                   {
                        tidakLengkap13();
                        prosedurBobot7();
                   }
                   else if (("".equals(bobot[0])))
                   {
                        tidakLengkap13();
                        prosedurBobot8();
                   }
                   else if (("".equals(bobot[1])))
                   {
                        tidakLengkap13();
                        prosedurBobot9();
                   }
                   else if (("".equals(bobot[2])))
                   {
                        tidakLengkap13();
                        prosedurBobot10();
                   }
                   else if (("".equals(bobot[3])))
                   {
                        tidakLengkap13();
                        prosedurBobot11();
                   }
            if (("".equals(penyakit[15][0]))) 
                {
                    if (("".equals(bobot[0])) && ("".equals(bobot[1])) && ("".equals(bobot[2])) && ("".equals(bobot[3])))
                    {
                       tidakLengkap14();
                       prosedurBobot();
                    }
                }
                   else if (("".equals(bobot[0])) && ("".equals(bobot[1])) && ("".equals(bobot[2])))
                    {
                        tidakLengkap14();
                        prosedurBobot1();
                    }
                   else if (("".equals(bobot[0])) && ("".equals(bobot[1])) && ("".equals(bobot[3])))
                    {
                        tidakLengkap14();                        
                        prosedurBobot2();
                    }
                   else if (("".equals(bobot[0])) && ("".equals(bobot[2])) && ("".equals(bobot[3])))
                   {
                        tidakLengkap14();
                        prosedurBobot3();                        
                   }
                   else if (("".equals(bobot[1])) && ("".equals(bobot[2])) && ("".equals(bobot[3])))
                   {
                        tidakLengkap14();
                        prosedurBobot4();
                   }
                   else if (("".equals(bobot[0])) && ("".equals(bobot[1])))
                   {
                        tidakLengkap14();
                        prosedurBobot5();
                   }
                   else if (("".equals(bobot[0])) && ("".equals(bobot[2])))
                   {
                        tidakLengkap14();
                        prosedurBobot6();
                   }
                   else if (("".equals(bobot[0])) && ("".equals(bobot[3])))
                   {
                        tidakLengkap14();
                        prosedurBobot7();
                   }
                   else if (("".equals(bobot[0])))
                   {
                        tidakLengkap14();
                        prosedurBobot8();
                   }
                   else if (("".equals(bobot[1])))
                   {
                        tidakLengkap14();
                        prosedurBobot9();
                   }
                   else if (("".equals(bobot[2])))
                   {
                        tidakLengkap14();
                        prosedurBobot10();
                   }
                   else if (("".equals(bobot[3])))
                   {
                        tidakLengkap14();
                        prosedurBobot11();
                   }
                }};

private void masuk() {
    
    String usrname = nama.getText().trim();
    String psswrd = new String(password.getPassword());
    loginName = "select Nama_Dokter from tblDokterNaraSumber where Nama_Dokter = '"+usrname+"'";
    loginPassword = "select Password from tblDokterNaraSumber where Nama_Dokter = '"+usrname+"'";
        try {
            statement = connection.createStatement();
            logName = statement.executeQuery(loginName);
            logPassword = statement.executeQuery(loginPassword);
            while (logName.next()) {
                namaPengguna = logName.getString("Nama_Dokter");
            }
            while (logPassword.next()) {
                passwordPengguna = logPassword.getString("Password");
            }
        } catch (SQLException ex) {
            Logger.getLogger(TesisSource.class.getName()).log(Level.SEVERE, null, ex);
        }
    if (("+usrname+".equals(namaPengguna)) && ("+psswrd+".equals(passwordPengguna))) {
        hubungkanKePadukData.setEnabled(true);
        batal.setEnabled(true);
        putuskanKoneksiKePadukData.setEnabled(true);
    }
    else
    {
        JOptionPane.showMessageDialog(null, "Nama Dokter atau Kata Sandi tidak Ditemukan", "Dokter atau Kata Sandi tidak Ada", JOptionPane.INFORMATION_MESSAGE);
    }           
}
private void connectToDB() {
                String driver = (String)driverDatabase.getSelectedItem();
                String uniRL =(String)url.getSelectedItem();
                String usrname = nama.getText().trim();
                String passwrd = new String(password.getPassword());
                try {
                    Class.forName(driver);
                    connection = DriverManager.getConnection(uniRL, usrname, passwrd);
                    koneksiStatus.setText("Terhubung ke Paduk Data");
                }
                catch (java.lang.Exception ex) {
                    koneksiStatus.setText("Gagal Terhubung ke Paduk Data");
                }
}
private void batal(){
                kriteriaHargaMyocardialInfarction.setText("");
                kriteriaEfekSampingMyocardialInfarction.setText("");
                kriteriaKualitasMyocardialInfarction.setText("");
                kriteriaKetersediaanMyocardialInfarction.setText("");
                alternatifUtamaKriteriaHargaMyocardialInfarction.setText("");
                alternatifUtamaKriteriaEfekSampingMyocardialInfarction.setText("");
                alternatifUtamaKriteriaKualitasMyocardialInfarction.setText("");
                alternatifUtamaKriteriaKetersediaanMyocardialInfarction.setText("");
                alternatif2KriteriaHargaMyocardialInfarction.setText("");
                alternatif2KriteriaEfekSampingMyocardialInfarction.setText("");
                alternatif2KriteriaKualitasMyocardialInfarction.setText("");
                alternatif2KriteriaKetersediaanMyocardialInfarction.setText("");
                alternatif3KriteriaHargaMyocardialInfarction.setText("");
                alternatif3KriteriaEfekSampingMyocardialInfarction.setText("");
                alternatif3KriteriaKualitasMyocardialInfarction.setText("");
                alternatif3KriteriaKetersediaanMyocardialInfarction.setText("");
                alternatif4KriteriaHargaMyocardialInfarction.setText("");
                alternatif4KriteriaEfekSampingMyocardialInfarction.setText("");
                alternatif4KriteriaKualitasMyocardialInfarction.setText("");
                alternatif4KriteriaKetersediaanMyocardialInfarction.setText("");
                alternatif5KriteriaHargaMyocardialInfarction.setText("");
                alternatif5KriteriaEfekSampingMyocardialInfarction.setText("");
                alternatif5KriteriaKualitasMyocardialInfarction.setText("");
                alternatif5KriteriaKetersediaanMyocardialInfarction.setText("");
                kriteriaHargaStroke.setText("");
                kriteriaEfekSampingStroke.setText("");
                kriteriaKualitasStroke.setText("");
                kriteriaKetersediaanStroke.setText("");
                alternatifUtamaKriteriaHargaStroke.setText("");
                alternatifUtamaKriteriaEfekSampingStroke.setText("");
                alternatifUtamaKriteriaKualitasStroke.setText("");
                alternatifUtamaKriteriaKetersediaanStroke.setText("");
                alternatif2KriteriaHargaStroke.setText("");
                alternatif2KriteriaEfekSampingStroke.setText("");
                alternatif2KriteriaKualitasStroke.setText("");
                alternatif2KriteriaKetersediaanStroke.setText("");
                alternatif3KriteriaHargaStroke.setText("");
                alternatif3KriteriaEfekSampingStroke.setText("");
                alternatif3KriteriaKualitasStroke.setText("");
                alternatif3KriteriaKetersediaanStroke.setText("");
                alternatif4KriteriaHargaStroke.setText("");
                alternatif4KriteriaEfekSampingStroke.setText("");
                alternatif4KriteriaKualitasStroke.setText("");
                alternatif4KriteriaKetersediaanStroke.setText("");
                alternatif5KriteriaHargaStroke.setText("");
                alternatif5KriteriaEfekSampingStroke.setText("");
                alternatif5KriteriaKualitasStroke.setText("");
                alternatif5KriteriaKetersediaanStroke.setText("");
}
        

public static void main(String[] args)
{
    TesisSource frame = new TesisSource();
    frame.setTitle("Program Pemilihan Obat dengan Cara Analytic Hierarchycal Process");
    frame.setLocationRelativeTo(null);
    frame.setDefaultCloseOperation(JFrame.EXIT_ON_CLOSE);
    frame.setSize(1024,768);
    frame.setVisible(true);
}

    private void prosedurBobot() 
    {
        try {
          statement = connection.createStatement();
          statement.addBatch(bobot1[0][0]);
          statement.addBatch(bobot1[1][0]);
          statement.addBatch(bobot1[2][0]);
          statement.addBatch(bobot1[3][0]);
          int count[] = statement.executeBatch();
          taruhHasil.append("Tiap Bobot untuk Penyakit Myocardial Infarction sudah Diperbaharui");
        } catch (SQLException e) {
            Logger.getLogger(TesisSource.class.getName()).log(Level.SEVERE, null, e);
        }   
}

    private void prosedurBobot1() 
    {
        try 
        {
            statement = connection.createStatement();
            statement.addBatch(bobot1[0][0]);
            statement.addBatch(bobot1[1][0]);
            statement.addBatch(bobot1[2][0]);
            int count[] = statement.executeBatch();
            taruhHasil.append("Tiap Bobot Selain Bobot Kriteria Ketersediaan untuk Penyakit Myocardial Infarction sudah Diperbaharui");
        } catch (SQLException e) {
            Logger.getLogger(TesisSource.class.getName()).log(Level.SEVERE, null, e);
        }
    }

    private void prosedurBobot2() 
    {
        try 
        {
            statement = connection.createStatement();
            statement.addBatch(bobot1[0][0]);
            statement.addBatch(bobot1[1][0]);
            statement.addBatch(bobot1[3][0]);
            int count[] = statement.executeBatch();
            taruhHasil.append("Tiap Bobot Selain Bobot Kriteria Kualitas untuk Penyakit Myocardial infarction sudah Diperbaharui");
        }
        catch (SQLException e) {
            Logger.getLogger(TesisSource.class.getName()).log(Level.SEVERE, null, e);
        }
    }

    private void prosedurBobot3() 
    {
        try {
          statement = connection.createStatement();
          statement.addBatch(bobot1[0][0]);
          statement.addBatch(bobot1[2][0]);
          statement.addBatch(bobot1[3][0]);
          int count[] = statement.executeBatch();
          taruhHasil.append("Tiap Bobot Selain Bobot Kriteria Efek Samping untuk Penyakit Myocardial Infarction sudah Diperbaharui");
        } catch (SQLException e) {
            Logger.getLogger(TesisSource.class.getName()).log(Level.SEVERE, null, e);
        }
    }

    private void lengkap() 
    {
        try
          {
            statement = connection.createStatement();
            statement.addBatch(instruksiPenyakit[0][0]);
            statement.addBatch(instruksiPenyakit[0][1]);
            statement.addBatch(instruksiPenyakit[5][0]);
            statement.addBatch(instruksiPenyakit[5][1]);
            statement.addBatch(instruksiPenyakit[10][0]);
            statement.addBatch(instruksiPenyakit[10][1]);
            statement.addBatch(instruksiPenyakit[15][0]);
            statement.addBatch(instruksiPenyakit[15][1]);
            int count[] = statement.executeBatch();
            taruhHasil.append("Ok, Tiap Nama Penyakit Prioritas Utama untuk Penyakit Myocardial Infarction sudah Diperbaharui, dan Tiap Nama Obat Alternatif Utama untuk Penyakit Myocardial Infarction sudah Diperbaharui");
          }
        catch (SQLException e)
          {
           taruhHasil.append(e.getMessage());
          }
    }

    private void prosedurBobot4() 
    {
        try {
          statement = connection.createStatement();
          statement.addBatch(bobot1[1][0]);
          statement.addBatch(bobot1[2][0]);
          statement.addBatch(bobot1[3][0]);
          int count[] = statement.executeBatch();
          taruhHasil.append("Tiap Bobot Selain Bobot Kriteria Harga untuk Penyakit Myocardial Infarction sudah Diperbaharui");
        } catch (SQLException e) {
            Logger.getLogger(TesisSource.class.getName()).log(Level.SEVERE, null, e);
        }
    }

    private void prosedurBobot5() 
    {
        try {
          statement = connection.createStatement();
          statement.addBatch(bobot1[0][0]);
          statement.addBatch(bobot1[1][0]);
          int count[] = statement.executeBatch();
          taruhHasil.append("Tiap Bobot Selain Bobot Kriteria Kualitas dan Kriteria Ketersediaan untuk Penyakit Myocardial Infarction sudah Diperbaharui");
        } catch (SQLException e) {
            Logger.getLogger(TesisSource.class.getName()).log(Level.SEVERE, null, e);
        }   
    }

    private void prosedurBobot6() 
    {
        try {
          statement = connection.createStatement();
          statement.addBatch(bobot1[0][0]);
          statement.addBatch(bobot1[2][0]);
          int count[] = statement.executeBatch();
          taruhHasil.append("Tiap Bobot Selain Bobot Kriteria Efek Samping dan Kriteria Ketersediaan untuk Penyakit Myocardial Infarction sudah Diperbaharui");
        } catch (SQLException e) {
            Logger.getLogger(TesisSource.class.getName()).log(Level.SEVERE, null, e);
        }   
    }

    private void prosedurBobot7() 
    {
        try 
        {
            statement = connection.createStatement();
            statement.addBatch(bobot1[0][0]);
            statement.addBatch(bobot1[3][0]);
            int count[] = statement.executeBatch();
            taruhHasil.append("Tiap Bobot Selain Bobot Kriteria Efek Samping dan Kriteria Kualitas untuk Penyakit Myocardial infarction sudah Diperbaharui");
        }
        catch (SQLException e) {
            Logger.getLogger(TesisSource.class.getName()).log(Level.SEVERE, null, e);
        }
    }

    private void prosedurBobot8() 
    {
        try 
        {
            statement = connection.createStatement();
            statement.addBatch(bobot1[0][0]);
            int count[] = statement.executeBatch();
            taruhHasil.append("Tiap Bobot Selain Bobot Kriteria Harga untuk Penyakit Myocardial infarction tidak Diperbaharui");
        }
        catch (SQLException e) {
            Logger.getLogger(TesisSource.class.getName()).log(Level.SEVERE, null, e);
        }
    }

    private void prosedurBobot9() 
    {
        try 
        {
            statement = connection.createStatement();
            statement.addBatch(bobot1[1][0]);
            int count[] = statement.executeBatch();
            taruhHasil.append("Tiap Bobot Selain Bobot Kriteria Efek Samping untuk Penyakit Myocardial infarction tidak Diperbaharui");
        }
        catch (SQLException e) {
            Logger.getLogger(TesisSource.class.getName()).log(Level.SEVERE, null, e);
        }
    }

    private void prosedurBobot10() 
    {
        try 
        {
            statement = connection.createStatement();
            statement.addBatch(bobot1[2][0]);
            int count[] = statement.executeBatch();
            taruhHasil.append("Tiap Bobot Selain Bobot Kriteria Efek Samping untuk Penyakit Myocardial infarction tidak Diperbaharui");
        }
        catch (SQLException e) {
            Logger.getLogger(TesisSource.class.getName()).log(Level.SEVERE, null, e);
        }
    }

    private void prosedurBobot11() 
    {
        try 
        {
            statement = connection.createStatement();
            statement.addBatch(bobot1[3][0]);
            int count[] = statement.executeBatch();
            taruhHasil.append("Tiap Bobot Selain Bobot Kriteria Ketersediaan untuk Penyakit Myocardial infarction sudah Diperbaharui");
        }
        catch (SQLException e) {
            Logger.getLogger(TesisSource.class.getName()).log(Level.SEVERE, null, e);
        }
    }

    private void tidakLengkap1() 
    {
        try
          {
            statement = connection.createStatement();
            statement.addBatch(instruksiPenyakit[0][0]);
            statement.addBatch(instruksiPenyakit[0][1]);
            statement.addBatch(instruksiPenyakit[5][0]);
            statement.addBatch(instruksiPenyakit[5][1]);
            statement.addBatch(instruksiPenyakit[10][0]);
            statement.addBatch(instruksiPenyakit[10][1]);
            statement.addBatch(instruksiPenyakit[15][1]);
            int count[] = statement.executeBatch();
            taruhHasil.append("Ok, Tiap Nama Penyakit Prioritas Utama untuk Penyakit Myocardial Infarction sudah Diperbaharui, dan Tiap Nama Obat Alternatif Utama Selain yang Kriteria Ketersediaan untuk Penyakit Myocardial Infarction sudah Diperbaharui");
          }
        catch (SQLException e)
          {
           taruhHasil.append(e.getMessage());
          }
    }

    private void tidakLengkap2() 
    {
        try
          {
            statement = connection.createStatement();
            statement.addBatch(instruksiPenyakit[0][0]);
            statement.addBatch(instruksiPenyakit[0][1]);
            statement.addBatch(instruksiPenyakit[5][0]);
            statement.addBatch(instruksiPenyakit[5][1]);
            statement.addBatch(instruksiPenyakit[10][1]);
            statement.addBatch(instruksiPenyakit[15][0]);
            statement.addBatch(instruksiPenyakit[15][1]);
            int count[] = statement.executeBatch();
            taruhHasil.append("Ok, Tiap Nama Penyakit Prioritas Utama untuk Penyakit Myocardial Infarction sudah Diperbaharui, dan Tiap Nama Obat Alternatif Utama Selain yang Kriteria Kualitas untuk Penyakit Myocardial Infarction sudah Diperbaharui");
          }
        catch (SQLException e)
          {
           taruhHasil.append(e.getMessage());
          }
    }

    private void tidakLengkap3() 
    {
        try
          {
            statement = connection.createStatement();
            statement.addBatch(instruksiPenyakit[0][0]);
            statement.addBatch(instruksiPenyakit[0][1]);
            statement.addBatch(instruksiPenyakit[5][1]);
            statement.addBatch(instruksiPenyakit[10][0]);
            statement.addBatch(instruksiPenyakit[10][1]);
            statement.addBatch(instruksiPenyakit[15][0]);
            statement.addBatch(instruksiPenyakit[15][1]);
            int count[] = statement.executeBatch();
            taruhHasil.append("Ok, Tiap Nama Penyakit Prioritas Utama untuk Penyakit Myocardial Infarction sudah Diperbaharui, dan Tiap Nama Obat Alternatif Utama Selain yang Kriteria Efek Samping untuk Penyakit Myocardial Infarction sudah Diperbaharui");
          }
        catch (SQLException e)
          {
           taruhHasil.append(e.getMessage());
          }
    }

    private void tidakLengkap4() 
    {
        try
          {
            statement = connection.createStatement();
            statement.addBatch(instruksiPenyakit[0][1]);
            statement.addBatch(instruksiPenyakit[5][0]);
            statement.addBatch(instruksiPenyakit[5][1]);
            statement.addBatch(instruksiPenyakit[10][0]);
            statement.addBatch(instruksiPenyakit[10][1]);
            statement.addBatch(instruksiPenyakit[15][0]);
            statement.addBatch(instruksiPenyakit[15][1]);
            int count[] = statement.executeBatch();
            taruhHasil.append("Ok, Tiap Nama Penyakit Prioritas Utama untuk Penyakit Myocardial Infarction sudah Diperbaharui, dan Tiap Nama Obat Alternatif Utama Selain yang Kriteria Harga untuk Penyakit Myocardial Infarction sudah Diperbaharui");
          }
        catch (SQLException e)
          {
           taruhHasil.append(e.getMessage());
          }
    }

    private void tidakLengkap5() {
        try
          {
            statement = connection.createStatement();
            statement.addBatch(instruksiPenyakit[0][0]);
            statement.addBatch(instruksiPenyakit[0][1]);
            statement.addBatch(instruksiPenyakit[5][0]);
            statement.addBatch(instruksiPenyakit[5][1]);
            statement.addBatch(instruksiPenyakit[10][1]);
            statement.addBatch(instruksiPenyakit[15][1]);
            int count[] = statement.executeBatch();
            taruhHasil.append("Ok, Tiap Nama Penyakit Prioritas Utama untuk Penyakit Myocardial Infarction sudah Diperbaharui, dan Tiap Nama Obat Alternatif Utama Selain Kriteria Kualitas dan Kriteria Ketersediaan untuk Penyakit Myocardial Infarction sudah Diperbaharui");
          }
        catch (SQLException e)
          {
           taruhHasil.append(e.getMessage());
          }
    }

    private void tidakLengkap6() {
        try
          {
            statement = connection.createStatement();
            statement.addBatch(instruksiPenyakit[0][0]);
            statement.addBatch(instruksiPenyakit[0][1]);
            statement.addBatch(instruksiPenyakit[5][1]);
            statement.addBatch(instruksiPenyakit[10][0]);
            statement.addBatch(instruksiPenyakit[10][1]);
            statement.addBatch(instruksiPenyakit[15][1]);
            int count[] = statement.executeBatch();
            taruhHasil.append("Ok, Tiap Nama Penyakit Prioritas Utama untuk Penyakit Myocardial Infarction sudah Diperbaharui, dan Tiap Nama Obat Alternatif Utama Selain yang Kriteria Efek Samping dan Ketersediaan untuk Penyakit Myocardial Infarction sudah Diperbaharui");
          }
        catch (SQLException e)
          {
           taruhHasil.append(e.getMessage());
          }
    }

    private void tidakLengkap7() {
        try
          {
            statement = connection.createStatement();
            statement.addBatch(instruksiPenyakit[0][0]);
            statement.addBatch(instruksiPenyakit[0][1]);
            statement.addBatch(instruksiPenyakit[5][1]);
            statement.addBatch(instruksiPenyakit[10][1]);
            statement.addBatch(instruksiPenyakit[15][0]);
            statement.addBatch(instruksiPenyakit[15][1]);
            int count[] = statement.executeBatch();
            taruhHasil.append("Ok, Tiap Nama Penyakit Prioritas Utama untuk Penyakit Myocardial Infarction sudah Diperbaharui, dan Tiap Nama Obat Alternatif Utama Selain yang Kriteria Efek Samping dan Kriteria Kualitas untuk Penyakit Myocardial Infarction sudah Diperbaharui");
          }
        catch (SQLException e)
          {
           taruhHasil.append(e.getMessage());
          }
    }

    private void tidakLengkap8() {
        try
          {
            statement = connection.createStatement();
            statement.addBatch(instruksiPenyakit[0][1]);
            statement.addBatch(instruksiPenyakit[5][0]);
            statement.addBatch(instruksiPenyakit[5][1]);
            statement.addBatch(instruksiPenyakit[10][0]);
            statement.addBatch(instruksiPenyakit[10][1]);
            statement.addBatch(instruksiPenyakit[15][1]);
            int count[] = statement.executeBatch();
            taruhHasil.append("Ok, Tiap Nama Penyakit Prioritas Utama untuk Penyakit Myocardial Infarction sudah Diperbaharui, dan Tiap Nama Obat Alternatif Utama Selain yang Kriteria Harga dan Kriteria Ketersediaan untuk Penyakit Myocardial Infarction sudah Diperbaharui");
          }
        catch (SQLException e)
          {
           taruhHasil.append(e.getMessage());
          }
    }

    private void tidakLengkap9() {
        try
          {
            statement = connection.createStatement();
            statement.addBatch(instruksiPenyakit[0][1]);
            statement.addBatch(instruksiPenyakit[5][0]);
            statement.addBatch(instruksiPenyakit[5][1]);
            statement.addBatch(instruksiPenyakit[10][1]);
            statement.addBatch(instruksiPenyakit[15][0]);
            statement.addBatch(instruksiPenyakit[15][1]);
            int count[] = statement.executeBatch();
            taruhHasil.append("Ok, Tiap Nama Penyakit Prioritas Utama untuk Penyakit Myocardial Infarction sudah Diperbaharui, dan Tiap Nama Obat Alternatif Utama Selain yang Kriteria Harga dan Kriteria Kualitas untuk Penyakit Myocardial Infarction sudah Diperbaharui");
          }
        catch (SQLException e)
          {
           taruhHasil.append(e.getMessage());
          }
    }

    private void tidakLengkap10() {
        try
          {
            statement = connection.createStatement();
            statement.addBatch(instruksiPenyakit[0][1]);
            statement.addBatch(instruksiPenyakit[5][1]);
            statement.addBatch(instruksiPenyakit[10][0]);
            statement.addBatch(instruksiPenyakit[10][1]);
            statement.addBatch(instruksiPenyakit[15][0]);
            statement.addBatch(instruksiPenyakit[15][1]);
            int count[] = statement.executeBatch();
            taruhHasil.append("Ok, Tiap Nama Penyakit Prioritas Utama untuk Penyakit Myocardial Infarction sudah Diperbaharui, dan Tiap Nama Obat Alternatif Utama Selain yang Kriteria Harga dan Kriteria Efek Samping untuk Penyakit Myocardial Infarction sudah Diperbaharui");
          }
        catch (SQLException e)
          {
           taruhHasil.append(e.getMessage());
          }
    }

    private void tidakLengkap11() {
        try
          {
            statement = connection.createStatement();
            statement.addBatch(instruksiPenyakit[0][0]);
            statement.addBatch(instruksiPenyakit[0][1]);
            statement.addBatch(instruksiPenyakit[5][1]);
            statement.addBatch(instruksiPenyakit[10][1]);
            statement.addBatch(instruksiPenyakit[15][1]);
            int count[] = statement.executeBatch();
            taruhHasil.append("Ok, Tiap Nama Penyakit Prioritas Utama untuk Penyakit Myocardial Infarction sudah Diperbaharui, dan Tiap Nama Obat Alternatif Utama Selain yang Kriteria Harga untuk Penyakit Myocardial Infarction tidak Diperbaharui");
          }
        catch (SQLException e)
          {
           taruhHasil.append(e.getMessage());
          }
    }

    private void tidakLengkap12() {
        try
          {
            statement = connection.createStatement();
            statement.addBatch(instruksiPenyakit[0][1]);
            statement.addBatch(instruksiPenyakit[5][0]);
            statement.addBatch(instruksiPenyakit[5][1]);
            statement.addBatch(instruksiPenyakit[10][1]);
            statement.addBatch(instruksiPenyakit[15][1]);
            int count[] = statement.executeBatch();
            taruhHasil.append("Ok, Tiap Nama Penyakit Prioritas Utama untuk Penyakit Myocardial Infarction sudah Diperbaharui, dan Tiap Nama Obat Alternatif Utama Selain yang Kriteria Efek Samping untuk Penyakit Myocardial Infarction tidak Diperbaharui");
          }
        catch (SQLException e)
          {
           taruhHasil.append(e.getMessage());
          }
    }

    private void tidakLengkap13() {
        try
          {
            statement = connection.createStatement();
            statement.addBatch(instruksiPenyakit[0][1]);
            statement.addBatch(instruksiPenyakit[5][1]);
            statement.addBatch(instruksiPenyakit[10][0]);
            statement.addBatch(instruksiPenyakit[10][1]);
            statement.addBatch(instruksiPenyakit[15][1]);
            int count[] = statement.executeBatch();
            taruhHasil.append("Ok, Tiap Nama Penyakit Prioritas Utama untuk Penyakit Myocardial Infarction sudah Diperbaharui, dan Tiap Nama Obat Alternatif Utama Selain yang Kriteria Kualitas untuk Penyakit Myocardial Infarction tidak Diperbaharui");
          }
        catch (SQLException e)
          {
           taruhHasil.append(e.getMessage());
          }
    }

    private void tidakLengkap14() {
        try
          {
            statement = connection.createStatement();
            statement.addBatch(instruksiPenyakit[0][1]);
            statement.addBatch(instruksiPenyakit[5][1]);
            statement.addBatch(instruksiPenyakit[10][1]);
            statement.addBatch(instruksiPenyakit[15][0]);
            statement.addBatch(instruksiPenyakit[15][1]);
            int count[] = statement.executeBatch();
            taruhHasil.append("Ok, Tiap Nama Penyakit Prioritas Utama untuk Penyakit Myocardial Infarction sudah Diperbaharui, dan Tiap Nama Obat Alternatif Utama Selain yang Kriteria Ketersediaan untuk Penyakit Myocardial Infarction sudah Diperbaharui");
          }
        catch (SQLException e)
          {
           taruhHasil.append(e.getMessage());
          }
    }
}



Folks, what is happening? Why can't I enable "Hubungkan ke Paduk Data", "Batal", and "Ubah Paduk Data" button? What is wrong with my codes? Please help me because I don't know what is wrong with this. I revise almost all of the codes and these are almost the final codes.

This post has been edited by tawilovejessicalawrent: 06 August 2012 - 12:37 AM


Is This A Good Question/Topic? 0
  • +

Replies To: I can't login after I click "Masuk" button, why?

#2 pbl  Icon User is offline

  • There is nothing you can't do with a JTable
  • member icon

Reputation: 8019
  • View blog
  • Posts: 31,126
  • Joined: 06-March 08

Re: I can't login after I click "Masuk" button, why?

Posted 06 August 2012 - 05:17 AM

     if (("+usrname+".equals(namaPengguna)) && ("+psswrd+".equals(passwordPengguna))) {


you are looking for the String "+username+" et "+psswrd+"
but you selected where Nama_Dokter = 'usrname';
where usrname = what ever was in nama.getText().trim()
you mean the user entered "+usrname+" in the JTextField ?
Was This Post Helpful? 1
  • +
  • -

#3 tawilovejessicalawrent  Icon User is offline

  • D.I.C Head

Reputation: -11
  • View blog
  • Posts: 122
  • Joined: 08-April 12

Re: I can't login after I click "Masuk" button, why?

Posted 06 August 2012 - 08:04 AM

No, I mean if user enter a username and password, the program compare the username and password entered with the entry in database. If the program find the same username and password in the database, program let user to login and enable the button mentioned in the question. If the program failed to find in the database, the program would exit. How should I change my codes?
Was This Post Helpful? 0
  • +
  • -

#4 macosxnerd101  Icon User is offline

  • Self-Trained Economist
  • member icon




Reputation: 9029
  • View blog
  • Posts: 33,490
  • Joined: 27-December 08

Re: I can't login after I click "Masuk" button, why?

Posted 06 August 2012 - 09:10 AM

Seriously if you cannot figure out how to use arrays, working with the Java GUI is beyond what you should be tackling. You really need to sit down and refactor/restructure your code. I think pbl's advice is spot on, as well. You want to get the username and password from the database, not compare String literals.

Big hint- if you use a WHERE clause in your query, you can check if the username and password exist in the database. If they don't, no rows will be returned.
Was This Post Helpful? 0
  • +
  • -

#5 tawilovejessicalawrent  Icon User is offline

  • D.I.C Head

Reputation: -11
  • View blog
  • Posts: 122
  • Joined: 08-April 12

Re: I can't login after I click "Masuk" button, why?

Posted 06 August 2012 - 09:17 AM

Well, I have another problem now, my program do not run. NetBeans said that no main class found, how can this become like this? You can look at line 1603, there is a main class, isn't it? One more, how can I optimize the processor speed because after this program is working, I want to run it with huge databases? That is the reason I need the code to use the maximum speed of the processor to avoid slow search.

This post has been edited by tawilovejessicalawrent: 06 August 2012 - 09:27 AM

Was This Post Helpful? 0
  • +
  • -

#6 macosxnerd101  Icon User is offline

  • Self-Trained Economist
  • member icon




Reputation: 9029
  • View blog
  • Posts: 33,490
  • Joined: 27-December 08

Re: I can't login after I click "Masuk" button, why?

Posted 06 August 2012 - 09:27 AM

You can run the file instead of running the project.

Quote

One more, how can I optimize the processor speed because after this program is working, I want to run it with huge databases?

Start by refactoring your code so it is clean, readable, and adherent to proper programming conventions. Start with arrays and loops. If you can't figure out arrays and loops, any further attempts at optimizations are pointless. You really need a stronger grasp on the basics before attempting more advanced tasks.
Was This Post Helpful? 0
  • +
  • -

#7 tawilovejessicalawrent  Icon User is offline

  • D.I.C Head

Reputation: -11
  • View blog
  • Posts: 122
  • Joined: 08-April 12

Re: I can't login after I click "Masuk" button, why?

Posted 06 August 2012 - 09:39 AM

Well, I did it. I run the file but NetBeans still say that no main class. What should I do? What part of my codes do you think is necessary to get optimized any ways?
Was This Post Helpful? -1
  • +
  • -

#8 macosxnerd101  Icon User is offline

  • Self-Trained Economist
  • member icon




Reputation: 9029
  • View blog
  • Posts: 33,490
  • Joined: 27-December 08

Re: I can't login after I click "Masuk" button, why?

Posted 06 August 2012 - 09:40 AM

I already told you what you need to do to optimize. In your past threads, we have pointed out the same things. Please make sure you read our posts.
Was This Post Helpful? 1
  • +
  • -

#9 tawilovejessicalawrent  Icon User is offline

  • D.I.C Head

Reputation: -11
  • View blog
  • Posts: 122
  • Joined: 08-April 12

Re: I can't login after I click "Masuk" button, why?

Posted 06 August 2012 - 09:44 AM

I revised almost all of my codes. I put plenty of arrarys and loops, what else do you think is necessary for me to change?
Was This Post Helpful? 0
  • +
  • -

#10 macosxnerd101  Icon User is offline

  • Self-Trained Economist
  • member icon




Reputation: 9029
  • View blog
  • Posts: 33,490
  • Joined: 27-December 08

Re: I can't login after I click "Masuk" button, why?

Posted 06 August 2012 - 09:45 AM

Post your revised code.
Was This Post Helpful? 0
  • +
  • -

#11 tawilovejessicalawrent  Icon User is offline

  • D.I.C Head

Reputation: -11
  • View blog
  • Posts: 122
  • Joined: 08-April 12

Re: I can't login after I click "Masuk" button, why?

Posted 06 August 2012 - 09:06 PM

Above codes are modified codes. Don't you see that I put plenty of arrays, plenty of loops, I even call methods from a methods, what do you mean I did not change them? So what else do you think I must change?
Was This Post Helpful? 0
  • +
  • -

#12 pbl  Icon User is offline

  • There is nothing you can't do with a JTable
  • member icon

Reputation: 8019
  • View blog
  • Posts: 31,126
  • Joined: 06-March 08

Re: I can't login after I click "Masuk" button, why?

Posted 07 August 2012 - 05:02 PM

This is an example of very bad code

        else if (("".equals(Nama_Obat)) && (("".equals(Nama_Obat11))) && (("".equals(Nama_Obat16))))  
        {
          ....
        }
        else if (("".equals(Nama_Obat)) && (("".equals(Nama_Obat6))) && (("".equals(Nama_Obat16)))) 
        {


you shouldn't repeat the test on Nama_Obat and even better Nma_Obat16

    else if("".equals(Nama_Obat)) {
       if("".equals(Nama_Obat16)) {
          if("".equals(Nama_Obat11) {
             ....
          }
          else if("".equals(Nama_Obat6)) {
             ....
          }


an array of boolean for all the ones equals("") would also be a better approach

These should be arrays:
    private String namaObatStroke1;
    private String namaObatStroke2;
    private String namaObatStroke3;


    private String Nama_Obat21;
    private String Nama_Obat22;
    private String Nama_Obat23;
    private String Nama_Obat24;
    private String Nama_Obat25;


    private String namaPenyakitMyocardialInfarct1;
    private String namaPenyakitMyocardialInfarct2;
    private String namaPenyakitMyocardialInfarct3;
    private String namaPenyakitMyocardialInfarct4;


        JPanel p1 = new JPanel();
        JPanel p2 = new JPanel();
        JPanel p3 = new JPanel();
        JPanel p4 = new JPanel();
        JPanel p5 = new JPanel();


Imagine
JPanel[] p = new JPanel[21];
for(int i = 0; i < p.length; ++i) {
   p[i] = new JPanel(new GridLayout(1,1,2,2);
   add(p[i], BorderLayout....



and so on

I admire your patience typing all that stuff but you really waste your energy at the wrong place
Was This Post Helpful? 3
  • +
  • -

#13 tawilovejessicalawrent  Icon User is offline

  • D.I.C Head

Reputation: -11
  • View blog
  • Posts: 122
  • Joined: 08-April 12

Re: I can't login after I click "Masuk" button, why?

Posted 08 August 2012 - 02:07 AM

JTextField[] alternatifKriteriaHargaMyocardialInfarction = new JTextField[5](10);



Thank you very much sensei, I have another question. Do you see above code? Why was that wrong? How to make JTextField to be an array, determine the number of arrays, and assign its length simultaneuosly?

for (r = 0; r < 5; r++)
    { 
        sql[r][0] = "select Nama_Obat from HasilObatAHPPrioritasUtamaKriteriaHarga'+[q}+' where Nama_Obat = '"+alternatifKriteriaHargaMyocardialInfarction[r].getText()+"'";
        sql[r][2] = "select Nama_Obat from HasilObatAHPPrioritasUtamaKriteriaEfekSamping'+[q]+' where Nama_Obat = '"+alternatifKriteriaEfekSampingMyocardialInfarction[r].getText()+"'";
        sql[r][4] = "select Nama_Obat from HasilObatAHPPrioritasUtamaKriteriaKualitas'+[q]+' where Nama_Obat = '"+alternatifKriteriaKualitasMyocardialInfarction[r].getText()+"'";
        sql[r][6] = "select Nama_Obat from HasilObatAHPPrioritasUtamaKriteriaKetersediaan'+[q]+' where Nama_Obat = '"+alternatifKriteriaKetersediaanMyocardialInfarction[r].getText()+"'";
        sql[r][8] = "select Nama_Obat from HasilObatAHPPrioritasUtamaKriteriaHarga'+[q]+' where Nama_Obat = '"+alternatifKriteriaHargaStroke[r].getText()+"'";
        sql[r][10] = "select Nama_Obat from HasilObatAHPPrioritasUtamaKriteriaEfekSamping'+[q]+' where Nama_Obat = '"+alternatifKriteriaEfekSampingStroke[r].getText()+"'";
        sql[r][12] = "select Nama_Obat from HasilObatAHPPrioritasUtamaKriteriaKualitas'+[q]+' where Nama_Obat = '"+alternatifKriteriaHargaKualitasStroke[r].getText()+"'";
        sql[r][14] = "select Nama_Obat from HasilObatAHPPrioritasUtamaKriteriaKetersediaan'+[q]+' where Nama_Obat = '"+alternatifKriteriaKetersediaanStroke[r].getText()+"'";
        sql[r][1] = "select Nama_Obat from HasilObatAHPPrioritasUtamaKriteriaHarga'+[q]+' where Nama_Penyakit = 'Myocardial Infarction'";
        sql[r][3] = "select Nama_Obat from HasilObatAHPPrioritasUtamaKriteriaEfekSamping'+[q]+' where Nama_Penyakit = 'Myocardial Infarction'";
        sql[r][5] = "select Nama_Obat from HasilObatAHPPrioritasUtamaKriteriaKualitas'+[q]+' where Nama_Penyakit = 'Myocardial Infarction'";
        sql[r][7] = "select Nama_Obat from HasilObatAHPPrioritasUtamaKriteriaKetersediaan'+[q]+' where Nama_Penyakit = 'Myocardial Infarction'";
        sql[r][9] = "select Nama_Obat from HasilObatAHPPrioritasUtamaKriteriaHarga'+[q]+' where Nama_Penyakit = 'Stroke'";
        sql[r][11] = "select Nama_Obat from HasilObatAHPPrioritasUtamaKriteriaEfekSamping'+[q]+' where Nama_Penyakit = 'Stroke'";
        sql[r][13] = "select Nama_Obat from HasilObatAHPPrioritasUtamaKriteriaKualitas'+[q]+' where Nama_Penyakit = 'Stroke'";
        sql[r][15] = "select Nama_Obat from HasilObatAHPPrioritasUtamaKriteriaKetersediaan'+[q]+' where Nama_Penyakit = 'Stroke'";
    }



The other codes are these codes, will these works?

This post has been edited by tawilovejessicalawrent: 08 August 2012 - 03:21 AM

Was This Post Helpful? 0
  • +
  • -

#14 pbl  Icon User is offline

  • There is nothing you can't do with a JTable
  • member icon

Reputation: 8019
  • View blog
  • Posts: 31,126
  • Joined: 06-March 08

Re: I can't login after I click "Masuk" button, why?

Posted 08 August 2012 - 03:20 AM

You can's assign all the elements of an array while creating the array. You need two distinct operations. That would work
JTextField[] alternatifKriteriaHargaMyocardialInfarction = new JTextField[5];
for(int i = 0; i < alternatifKriteriaHargaMyocardialInfarction.length; ++i)
     alternatifKriteriaHargaMyocardialInfarction[i] = new JTextField(10);



P.S. you really like to type long variable name. I guess that tfAlterMyocardInfarction would have do the job and the "tf" prefix shows immediatly that it is a JTextField
Was This Post Helpful? 1
  • +
  • -

#15 tawilovejessicalawrent  Icon User is offline

  • D.I.C Head

Reputation: -11
  • View blog
  • Posts: 122
  • Joined: 08-April 12

Re: I can't login after I click "Masuk" button, why?

Posted 08 August 2012 - 04:21 AM

View Postpbl, on 08 August 2012 - 03:20 AM, said:

You can's assign all the elements of an array while creating the array. You need two distinct operations. That would work
JTextField[] alternatifKriteriaHargaMyocardialInfarction = new JTextField[5];
for(int i = 0; i < alternatifKriteriaHargaMyocardialInfarction.length; ++i)
     alternatifKriteriaHargaMyocardialInfarction[i] = new JTextField(10);



P.S. you really like to type long variable name. I guess that tfAlterMyocardInfarction would have do the job and the "tf" prefix shows immediatly that it is a JTextField


Can I put the for statemen just the same position with your post? About codes to access database, are my codes correct? What will be the correct codes if my codes are wrong?

This post has been edited by tawilovejessicalawrent: 08 August 2012 - 04:27 AM

Was This Post Helpful? 0
  • +
  • -

  • (2 Pages)
  • +
  • 1
  • 2