Page 8 of 24 First ... 67891018 ... Last
  • Jump to page:
  1. No Profile Picture
    Permanently Banned
    Devshed Newbie (0 - 499 posts)

    Join Date
    Apr 2013
    Posts
    257
    Rep Power
    0
    Originally Posted by NormR
    What is the state of the Connection object used for the createStatement() method on line 131? Is it open?

    See posts #99 and #101
    I open the connection to database everytime the user clicks the masuk button. You can see it, can't you? Should I get out of listener first? You can look at the masuk button's action listener. Every time the user clicks it, the code lead the program to open the database first, doesn't it?
    Last edited by Tawijakarta; June 9th, 2013 at 06:54 AM.
  2. Contributing User
    Devshed Expert (3500 - 3999 posts)

    Join Date
    Aug 2010
    Location
    Eastern Florida
    Posts
    3,696
    Rep Power
    347
    Is the connection open when the createStatement() method is called? To see if it is, print out the value returned by the Connection class's isClosed() method before calling the createStatement() method.
    Code:
                               System.out.println("con="+connection.isClosed());

    When is the following statement executed:
    Code:
                                   connection.close();
    Last edited by NormR; June 9th, 2013 at 07:16 AM.
  3. No Profile Picture
    Permanently Banned
    Devshed Newbie (0 - 499 posts)

    Join Date
    Apr 2013
    Posts
    257
    Rep Power
    0
    Originally Posted by NormR
    Is the connection open when the createStatement() method is called? To see if it is, print out the value returned by the Connection class's isClosed() method before calling the createStatement() method.
    Code:
                               System.out.println("con="+connection.isClosed());

    When is the following statement executed:
    Code:
                                   connection.close();
    I know that the connection is closed and the result is con = false but I open the database everytime the user clicks the masuk button. How will Java execute the code? How should I change the code to make the code show the error message every time some things are wrong? Is that mean that the connection is open? I closed the connection. How could the connection still open?
    Last edited by Tawijakarta; June 10th, 2013 at 10:21 AM.
  4. Contributing User
    Devshed Expert (3500 - 3999 posts)

    Join Date
    Aug 2010
    Location
    Eastern Florida
    Posts
    3,696
    Rep Power
    347
    I closed the connection
    That is the reason for the error shown in post #105 when the createStatement() method is called.
    A new Connection must be created after the old one is closed if you want to call the createStatement() method.
    Or the old connection should be left open (not closed) if you want to use the connection to call the createStatement() method.

    the result is con = false
    That means the connection is NOT closed when isCLosed() returns false.

    I open the database everytime
    What statement(s) "open the database"?
    There is an if statement that controls what methods are called:
    Code:
                      if (connection == null)  
                      {  
                          masuk.setEnabled(false);  
                          connectToDB();  
                          entryPrg();  
                      }  
                      else {
                          entryPrg();  
                      }
    How will Java execute the code?
    Add some println() statements to see how java is executing the code. They will show you what the values of variables are when the code executes and where the code is executing.
    Last edited by NormR; June 10th, 2013 at 04:28 PM.
  5. No Profile Picture
    Permanently Banned
    Devshed Newbie (0 - 499 posts)

    Join Date
    Apr 2013
    Posts
    257
    Rep Power
    0
    Originally Posted by NormR
    That is the reason for the error shown in post #105 when the createStatement() method is called.
    A new Connection must be created after the old one is closed if you want to call the createStatement() method.
    Or the old connection should be left open (not closed) if you want to use the connection to call the createStatement() method.

    That means the connection is NOT closed when isCLosed() returns false.


    What statement(s) "open the database"?
    There is an if statement that controls what methods are called:
    Code:
                      if (connection == null)  
                      {  
                          masuk.setEnabled(false);  
                          connectToDB();  
                          entryPrg();  
                      }  
                      else {
                          entryPrg();  
                      }

    Add some println() statements to see how java is executing the code. They will show you what the values of variables are when the code executes and where the code is executing.
    If the connection is open, what kind of problem will I have? Why do I have this problem? How to solve this problem?

    See this code:

    Code:
    masuk.addActionListener(new java.awt.event.ActionListener() {  
                String loginName;  
                String loginPassword;    
                String passwrd;
                @Override  
                public void actionPerformed(java.awt.event.ActionEvent evt) {  
                    usrname = txtNama.getText().trim();  
                    psswrd = new String(sandiKata.getPassword());
                    try {  
                        masuklah();  
                    }   
                    catch (SQLException ex) {
                        ex.printStackTrace();
                        Logger.getLogger(ProgramTesisBaru.class.getName()).log(Level.SEVERE, null, ex);  
                    }  
                }  
      
                private void masuklah() throws SQLException {  
                      if (connection == null)  
                      {  
                          masuk.setEnabled(false);  
                          connectToDB();  
                          entryPrg();  
                      }  
                      else {
                          entryPrg();  
                      }  
                }  
      
                public void connectToDB() {  
                    String uniRL = (String)jcboURL.getSelectedItem();  
                    String driver = (String) jcboDriver.getSelectedItem();  
                    //URL uniRL = (URL)jcboURL.getSelectedItem();  
                    try {  
                        Class.forName(driver);  
                        connection = DriverManager.getConnection(uniRL, usrname, psswrd);  
                        //rowSet.setURL(uniRL);  
                        statusKoneksi.setText("Terhubung ke Paduk Data");  
                    }  
                    catch (java.lang.Exception ex) { 
                        ex.printStackTrace();
                        statusKoneksi.setText("Gagal Terhubung ke Paduk Data");  
                    }  
                }  
      
                private void entryPrg() {  
                          try {
                          statement = connection.createStatement();
                          loginName = "select Nama_Dokter from tblDokterAhli where Nama_Dokter = '"+usrname+"' and Kata_Kunci = '"+psswrd+"'";  
                          //loginPassword = "select Kata_Kunci from tblDokterAhli where Nama_Dokter = '"+usrname+"'";
                          ResultSet logName = statement.executeQuery(loginName);  
                          //ResultSet logPassword = statement.executeQuery(loginPassword);
                          while (logName.next()) 
                               {  
                               namaPengguna1 = logName.getString("Nama_Dokter");  
                               }  
                          //while (logPassword.next()) 
                               //{  
                               //passwordPengguna1 = logPassword.getString("Kata_Kunci");  
                               //}  
                          if (("".equals(usrname)) && ("".equals(psswrd)))   
                                 {  
                                   tombolHubungkankePadukData.setEnabled(false);  
                                   putuskanKoneksiKePadukData.setEnabled(false);  
                                   tombolUbahPadukData.setEnabled(false);  
                                   tombolBatal.setEnabled(false);  
                                   masuk.setEnabled(true);
                                   statusKoneksi.setText("Tidak Ada Koneksi ke Paduk Data");
                                   connection.close();
                                   keluar.setEnabled(true);  
                                   putuskanKoneksiKePadukData.setEnabled(false);  
                                   JOptionPane.showMessageDialog(null, gx, ix, JOptionPane.INFORMATION_MESSAGE);  
                                 }  
                        else if ((!"".equals(usrname)) && (!"".equals(psswrd)))  
                           {  
                             if ((!"".equals(namaPengguna1)))   
                                {  
                                   tombolHubungkankePadukData.setEnabled(true);  
                                   putuskanKoneksiKePadukData.setEnabled(true);  
                                   tombolUbahPadukData.setEnabled(true);  
                                   tombolBatal.setEnabled(true);  
                                   masuk.setEnabled(false);
                                   statusKoneksi.setText("Terhubung ke Paduk Data");
                                   keluar.setEnabled(true);  
                                   putuskanKoneksiKePadukData.setEnabled(true);  
                                   connection.close();  
                                }  
                             else if (("".equals(namaPengguna1)))  
                                {  
                                   tombolHubungkankePadukData.setEnabled(false);  
                                   putuskanKoneksiKePadukData.setEnabled(false);  
                                   tombolUbahPadukData.setEnabled(false);  
                                   tombolBatal.setEnabled(false);  
                                   keluar.setEnabled(true);
                                   masuk.setEnabled(true);
                                   statusKoneksi.setText("Tidak Ada Koneksi ke Paduk Data");
                                   putuskanKoneksiKePadukData.setEnabled(false);  
                                   JOptionPane.showMessageDialog(null, gx, ix, JOptionPane.INFORMATION_MESSAGE);  
                                   connection.close();  
                               }  
                            /*else if ((!"".equals(passwordPengguna1)))  
                               {  
                                   tombolHubungkankePadukData.setEnabled(false);  
                                   putuskanKoneksiKePadukData.setEnabled(false);  
                                   tombolUbahPadukData.setEnabled(false);  
                                   tombolBatal.setEnabled(false);
                                   masuk.setEnabled(true);
                                   statusKoneksi.setText("Tidak Ada Koneksi ke Paduk Data");
                                   keluar.setEnabled(true);  
                                   putuskanKoneksiKePadukData.setEnabled(false);  
                                   JOptionPane.showMessageDialog(null, ex, bx, JOptionPane.INFORMATION_MESSAGE);  
                                   connection.close();  
                               }*/  
        }  
        else if ((!"".equals(usrname)) && ("".equals(psswrd)))
        {  
            if (("".equals(namaPengguna1)))   
            {  
            JOptionPane.showMessageDialog(null, cx, ix, JOptionPane.INFORMATION_MESSAGE);  
              tombolHubungkankePadukData.setEnabled(false);  
              putuskanKoneksiKePadukData.setEnabled(false);  
              tombolUbahPadukData.setEnabled(false);  
              tombolBatal.setEnabled(false); 
              masuk.setEnabled(true);
              statusKoneksi.setText("Tidak Ada Koneksi ke Paduk Data");
              keluar.setEnabled(true);  
              putuskanKoneksiKePadukData.setEnabled(false);  
              connection.close();                          
            }  
            /*else if (("".equals(namaPengguna1)))  
            {  
              tombolHubungkankePadukData.setEnabled(false);  
              putuskanKoneksiKePadukData.setEnabled(false);  
              tombolUbahPadukData.setEnabled(false);  
              tombolBatal.setEnabled(false);
              masuk.setEnabled(true);
              statusKoneksi.setText("Tidak Ada Koneksi ke Paduk Data");
              keluar.setEnabled(true);  
              putuskanKoneksiKePadukData.setEnabled(false);  
              JOptionPane.showMessageDialog(null, cx, bx, JOptionPane.INFORMATION_MESSAGE);                
              connection.close();                          
            }*/  
          /*else if (("".equals(passwordPengguna1)))  
          {  
            tombolHubungkankePadukData.setEnabled(false);  
            putuskanKoneksiKePadukData.setEnabled(false);  
            tombolUbahPadukData.setEnabled(false);  
            tombolBatal.setEnabled(false); 
            masuk.setEnabled(true);
            statusKoneksi.setText("Tidak Ada Koneksi ke Paduk Data");
            keluar.setEnabled(true);  
            putuskanKoneksiKePadukData.setEnabled(false);  
            JOptionPane.showMessageDialog(null, cx, bx, JOptionPane.INFORMATION_MESSAGE);                          
            connection.close();                          
          }*/  
        }  
        else if ((("".equals(usrname)) && (!"".equals(psswrd))))  
        {  
            /*if (("".equals(namaPengguna1)) && ("".equals(passwordPengguna1)))   
          {  
            JOptionPane.showMessageDialog(null, dx, bx, JOptionPane.INFORMATION_MESSAGE);  
            tombolHubungkankePadukData.setEnabled(false);  
            putuskanKoneksiKePadukData.setEnabled(false);  
            tombolUbahPadukData.setEnabled(false);  
            tombolBatal.setEnabled(false);  
            keluar.setEnabled(true);  
            masuk.setEnabled(true);
            statusKoneksi.setText("Tidak Ada Koneksi ke Paduk Data");
            putuskanKoneksiKePadukData.setEnabled(false);                          
            connection.close();                          
          } */ 
        if (("".equals(namaPengguna1)))  
          {  
            tombolHubungkankePadukData.setEnabled(false);  
            putuskanKoneksiKePadukData.setEnabled(false);  
            tombolUbahPadukData.setEnabled(false);  
            tombolBatal.setEnabled(false);  
            keluar.setEnabled(true);  
            masuk.setEnabled(true);
            statusKoneksi.setText("Tidak Ada Koneksi ke Paduk Data");
            putuskanKoneksiKePadukData.setEnabled(false);  
            JOptionPane.showMessageDialog(null, dx, ix, JOptionPane.INFORMATION_MESSAGE);                          
            connection.close();                          
          }  
          /*else if (("".equals(passwordPengguna1)))  
          {  
            tombolHubungkankePadukData.setEnabled(false);  
            putuskanKoneksiKePadukData.setEnabled(false);  
            tombolUbahPadukData.setEnabled(false);  
            tombolBatal.setEnabled(false);  
            keluar.setEnabled(true); 
            masuk.setEnabled(true);
            statusKoneksi.setText("Tidak Ada Koneksi ke Paduk Data");
            putuskanKoneksiKePadukData.setEnabled(false);  
            JOptionPane.showMessageDialog(null, dx, bx, JOptionPane.INFORMATION_MESSAGE);                          
            connection.close();                          
          }  */
        }     
                          }  
                          catch (java.lang.Exception ex){ 
                              ex.printStackTrace();
                              statusMasuk.setText("Gagal Masuk");  
                          }
                }});
    In the if part, I always enabled the masuk button if the user enter a wrong username or a password. If the user is clicking the masuk button, the user will be directed to open the database first before he or she continue to the if part. How will I solve this if the code that is used me is not correct?
    Last edited by Tawijakarta; June 13th, 2013 at 12:53 PM.
  6. Contributing User
    Devshed Expert (3500 - 3999 posts)

    Join Date
    Aug 2010
    Location
    Eastern Florida
    Posts
    3,696
    Rep Power
    347
    Is the connection in the closed state every time that the createStatement() is called?
    There are several calls to the Connection close() method.
    After the close() method is called, does the code then get a new connection?
  7. No Profile Picture
    Permanently Banned
    Devshed Newbie (0 - 499 posts)

    Join Date
    Apr 2013
    Posts
    257
    Rep Power
    0
    Originally Posted by NormR
    Is the connection in the closed state every time that the createStatement() is called?
    There are several calls to the Connection close() method.
    After the close() method is called, does the code then get a new connection?
    After the connection is closed, if the user is reclicking the masuk button, the code should call the masuk button action listener, shouldn't it? After the code calls the masuk button action listener, the code always being directed by me to open the database first, look at the code. The fact is after I use the command that you want me to use, it is showing that con=false which mean that the database is open, so what should I do?
    Last edited by Tawijakarta; June 14th, 2013 at 10:54 AM.
  8. Contributing User
    Devshed Expert (3500 - 3999 posts)

    Join Date
    Aug 2010
    Location
    Eastern Florida
    Posts
    3,696
    Rep Power
    347
    the code always being directed by me to open the database
    What does the code do if the connection is closed and the connection variable is not null?
    I assume that "to open the database" means to create a connection to the database using the getConnection() method. Will the getConnection() method be called if the connection is closed and the connection variable is NOT null?


    it is showing that con=false which mean that the database is open
    Please copy all of the program's output that shows where the code is being executed and what the values of the variables are as the code executes.

    Where is the println() statement that prints con=false?
    I do NOT see it in the posted code.
    Last edited by NormR; June 13th, 2013 at 01:15 PM.
  9. No Profile Picture
    Permanently Banned
    Devshed Newbie (0 - 499 posts)

    Join Date
    Apr 2013
    Posts
    257
    Rep Power
    0
    Originally Posted by NormR
    What does the code do if the connection is closed and the connection variable is not null?
    I assume that "to open the database" means to create a connection to the database using the getConnection() method. Will the getConnection() method be called if the connection is closed and the connection variable is NOT null?



    Please copy all of the program's output that shows where the code is being executed and what the values of the variables are as the code executes.

    Where is the println() statement that prints con=false?
    I do NOT see it in the posted code.
    I already remove it. Please just tell me what to do because I don't know where to put the println. Some of your advices are not working. I need to solve it as soon as possible or they will drop me out ok?
  10. Contributing User
    Devshed Expert (3500 - 3999 posts)

    Join Date
    Aug 2010
    Location
    Eastern Florida
    Posts
    3,696
    Rep Power
    347
    I already remove it.
    Why???
    You need to print the values of lots of things in the program so that you can understand what the code is doing.

    If you are unable to correct the problems in the program using the suggestions I have given, then I don't know what else to suggest.

    The error shown in post#104 will happen when the connection is closed.
    What happens if you do NOT close the connection?
    Last edited by NormR; June 14th, 2013 at 11:39 AM.
  11. No Profile Picture
    Permanently Banned
    Devshed Newbie (0 - 499 posts)

    Join Date
    Apr 2013
    Posts
    257
    Rep Power
    0
    Originally Posted by NormR
    Why???
    You need to print the values of lots of things in the program so that you can understand what the code is doing.

    If you are unable to correct the problems in the program using the suggestions I have given, then I don't know what else to suggest.

    The error shown in post#104 will happen when the connection is closed.
    What happens if you do NOT close the connection?
    Just explain where the code will go after the user enter the things that are not matching the database ok? Why did the code not start from masuk button action listener after the inputs are not entering the things that match the database?
  12. Contributing User
    Devshed Expert (3500 - 3999 posts)

    Join Date
    Aug 2010
    Location
    Eastern Florida
    Posts
    3,696
    Rep Power
    347
    What happens if you do NOT close the connection?

    Try commenting out these statements:
    Code:
    //  connection.close();

    Why did the code not start from masuk button action listener
    Where does the code execute? Add some println statements that will print messages that show where the code executes.
    Add a println after each statement if needed to show where the code executes and what the values of the variables are as the code executes.
    Last edited by NormR; June 15th, 2013 at 07:11 AM.
  13. No Profile Picture
    Permanently Banned
    Devshed Newbie (0 - 499 posts)

    Join Date
    Apr 2013
    Posts
    257
    Rep Power
    0
    Originally Posted by NormR
    What happens if you do NOT close the connection?

    Try commenting out these statements:
    Code:
    //  connection.close();


    Where does the code execute? Add some println statements that will print messages that show where the code executes.
    Add a println after each statement if needed to show where the code executes and what the values of the variables are as the code executes.
    It should not try connect to the database any more. It should continue to entryPrg(); shouldn't it? So please just answer my question directly and stop asking me to add a println because I do not know where to put that ok?

    Beside, how to access a method in an action listener from other action listeners?

    I get another question, why don't the connection to the database close after the user click the putuskanKoneksiKePadukData button?

    Here is the completed code:

    Code:
    package programtesisbaru;  
      
      
    import java.awt.*;  
    import java.sql.*;  
    import java.util.logging.Level;  
    import java.util.logging.Logger;  
    import javax.swing.*;
    
    /** 
    * 
    * @author Tawi 
    */  
    public class ProgramTesisBaru extends FrameBaru {  
    Container konten = getContentPane();  
    JLabel lblNama = new JLabel("Nama : ");  
    JTextField txtNama = new JTextField();  
    JLabel kataSandi = new JLabel("Kata Sandi : ");  
    JPasswordField sandiKata = new JPasswordField();  
    JButton masuk = new JButton("Masuk");  
    JButton keluar = new JButton("Keluar");  
    int i;  
    JButton tombolHubungkankePadukData = new JButton("Hubungkan ke Paduk Data");  
    JButton putuskanKoneksiKePadukData = new JButton("Putuskan Koneksi ke Paduk Data");  
    JButton tombolUbahPadukData = new JButton("Ubah Paduk Data");  
    JButton tombolBatal = new JButton("Batal");  
    JButton lanjut = new JButton("Lanjut");  
    JComboBox jcboURL = new JComboBox (new String[] {"jdbc:odbc:DatabaseKlinik"});  
    JComboBox jcboDriver = new JComboBox (new String[] {"sun.jdbc.odbc.JdbcOdbcDriver"});  
    Connection connection;  
    Statement statement;  
    JLabel statusKoneksi = new JLabel("Tidak ada Koneksi ke Paduk Data");  
    JLabel padukData = new JLabel("Paduk Data Belum Diubah");  
    String namaPengguna1 = new String();  
    String passwordPengguna1 = new String();  
    JLabel myocardialInfarction = new JLabel("Myocardial Infarction");  
    JLabel stroke = new JLabel("Stroke");  
    JLabel[][] kriteria = new JLabel[4][2];  
    JLabel[][] alternatif = new JLabel[5][2];  
    JTextField[][]jawabKriteria = new JTextField [4][2];  
    JTextField[][] jawabAlternatif = new JTextField[5][2];  
    JLabel statusMasuk = new JLabel("Belum Masuk");  
    String ax = "Nama Dokter Belum Dimasukkan";   
    String bx = "Dokter atau Kata Sandi tidak Ada";  
    String cx = "Kata Sandi Belum Dimasukkan";  
    String dx = "Nama Dokter Belum Dimasukkan";  
    String ex = "Dokter tidak Dikenal";  
    String fx = "Kata Kunci tidak Benar";  
    String gx = "Nama Pengguna dan Kata Kunci tidak Benar";  
    String hx = "Nama Dokter dan Kata Sandi tidak Ada";  
    String ix = "Kesalahan";
    String usrname = new String();
    String psswrd = new String();
    String uniRL = (String)jcboURL.getSelectedItem();  
    String driver = (String) jcboDriver.getSelectedItem(); 
      
    public ProgramTesisBaru()  
    {   
    konten.setLayout(null); 
    usrname = txtNama.getText().trim();  
    psswrd = new String(sandiKata.getPassword());
    // Atur letak beberapa komponen  
    
    for (int tlo = 0; tlo < 2; tlo++)  
    {  
        kriteria[0][tlo] = new JLabel("Kriteria 1");  
        kriteria[1][tlo] = new JLabel("Kriteria 2");  
        kriteria[2][tlo] = new JLabel("Kriteria 3");  
        kriteria[3][tlo] = new JLabel("Kriteria 4");  
        alternatif[0][tlo] = new JLabel("Alternatif 1");  
        alternatif[1][tlo] = new JLabel("Alternatif 2");  
        alternatif[2][tlo] = new JLabel("Alternatif 3");  
        alternatif[3][tlo] = new JLabel("Alternatif 4");  
        alternatif[4][tlo] = new JLabel("Alternatif 5");  
    }    
    lblNama.setBounds(0,10,100,25);  
    konten.add(lblNama);  
    txtNama.setBounds(130,10,200,25);  
    konten.add(txtNama);  
    kataSandi.setBounds(330,10,100,25);  
    konten.add(kataSandi);  
    sandiKata.setBounds(410,10,200,25);  
    konten.add(sandiKata);  
    masuk.setBounds(600,10,100,25);  
    konten.add(masuk);  
    keluar.setBounds(700,10,100,25);  
    konten.add(keluar);  
    tombolHubungkankePadukData.setBounds(0,50,250,25);  
    konten.add(tombolHubungkankePadukData);  
    putuskanKoneksiKePadukData.setBounds(250,50,250,25);  
    konten.add(putuskanKoneksiKePadukData);  
    tombolUbahPadukData.setBounds(480,50,250,25);  
    konten.add(tombolUbahPadukData);  
    tombolBatal.setBounds(730,50,250,25);  
    konten.add(tombolBatal);  
    statusKoneksi.setBounds(800,10,200,25);  
    konten.add(statusKoneksi);  
    padukData.setBounds(0,70,200,25);  
    statusMasuk.setBounds(160,70,200,25);  
    myocardialInfarction.setBounds(0,120,200,25);  
    konten.add(myocardialInfarction);  
    konten.add(padukData);  
    tombolHubungkankePadukData.setEnabled(false);  
    tombolBatal.setEnabled(false);  
    tombolUbahPadukData.setEnabled(false);  
    putuskanKoneksiKePadukData.setEnabled(false);  
    for (int jwbKri = 0; jwbKri < 4; jwbKri++)  
    {  
        jawabKriteria[jwbKri][0] = new JTextField(10);  
        jawabKriteria[jwbKri][1] = new JTextField(10);  
    }  
    for (int jwbAlt = 0; jwbAlt < 5; jwbAlt++)  
    {  
        jawabAlternatif[jwbAlt][0] = new JTextField(10);  
        jawabAlternatif[jwbAlt][1] = new JTextField(10);  
    }  
    for (int jwbKrif = 0; jwbKrif < 4; jwbKrif++)  
    {  
        jawabKriteria[jwbKrif][0].setVisible(false);  
        jawabKriteria[jwbKrif][1].setVisible(false);  
    }  
    for (int jwbAlt = 0; jwbAlt < 5; jwbAlt++)  
    {  
        jawabAlternatif[jwbAlt][0].setVisible(false);  
        jawabAlternatif[jwbAlt][1].setVisible(false);  
    }  
    lblNama.setVisible(true);  
    txtNama.setVisible(true);  
    kataSandi.setVisible(true);  
    sandiKata.setVisible(true);  
    masuk.setVisible(true);  
    keluar.setVisible(true);  
    tombolHubungkankePadukData.setVisible(true);  
    putuskanKoneksiKePadukData.setVisible(true);  
    tombolUbahPadukData.setVisible(true);  
    tombolBatal.setVisible(true);  
    lanjut.setVisible(false);  
    jcboURL.setVisible(true);  
    jcboDriver.setVisible(true);  
    statusKoneksi.setVisible(true);  
    padukData.setVisible(true);  
    myocardialInfarction.setVisible(false);  
    stroke.setVisible(false);  
    for (int hklma = 0; hklma < kriteria.length; hklma++) {    
        {    
            kriteria[hklma][0].setVisible(false);    
            kriteria[hklma][1].setVisible(false);
        }    
    }  
     for (int hklma = 0; hklma < alternatif.length; hklma++) {    
        {    
            alternatif[hklma][0].setVisible(false);    
            alternatif[hklma][1].setVisible(false);
        }    
    }  
         statusMasuk.setVisible(true);  
         labelPerhitunganKriteria.setVisible(false);  
         tampilKriteria.setVisible(false);  
         tampilKriteria1.setVisible(false);  
         ubah.setVisible(false);  
         kembali.setVisible(false);  
         lanjutlah.setVisible(false);  
         lanjutlah1.setVisible(false);  
         perhitunganKriteria.setVisible(false);  
         perhitunganKriteria1.setVisible(false);  
         kmbl.setVisible(false);  
         kmbl1.setVisible(false);  
         update.setVisible(false);  
         update1.setVisible(false);  
         myocardInfarc.setVisible(false);  
         stroke1.setVisible(false);  
        for (int hklma = 0; hklma < jawabKriteria1.length; hklma++) {    
        for (int nyola = 0; nyola < jawabKriteria1[hklma].length; nyola++) {    
            jawabKriteria1[hklma][nyola].setVisible(false);    
        }    
    }  
        for (int hklma = 0; hklma < jawabAlternatif1.length; hklma++) {    
        for (int nyola = 0; nyola < jawabAlternatif1[hklma].length; nyola++) {    
            jawabAlternatif1[hklma][nyola].setVisible(false);    
        }    
    }  
         for (int hklma = 0; hklma < labelLuarKriteria.length; hklma++) {    
        for (int nyola = 0; nyola < labelLuarKriteria[hklma].length; nyola++) {    
            labelLuarKriteria[hklma][nyola].setVisible(false);    
        }    
    }  
         for (int hklma = 0; hklma < labelLuarAlternatif.length; hklma++) {    
        for (int nyola = 0; nyola < labelLuarAlternatif[hklma].length; nyola++) {    
            labelLuarAlternatif[hklma][nyola].setVisible(false);    
        }    
    }  
         for (int hklma = 0; hklma < labelLuarAlternatif1.length; hklma++) {    
        for (int nyola = 0; nyola < labelLuarAlternatif1[hklma].length; nyola++) {    
            labelLuarAlternatif1[hklma][nyola].setVisible(false);    
        }    
    }  
         for (int hklm = 0; hklm < labelLuarKriteria1.length; hklm++) {    
        for (int nyol = 0; nyol < labelLuarKriteria1[hklm].length; nyol++) {    
            labelLuarKriteria1[hklm][nyol].setVisible(false);    
        }    
    }  
         kriteriaLanjut.setVisible(false);  
         kriteriaLanjut1.setVisible(false);
    lanjut.addActionListener(new java.awt.event.ActionListener() {  
    @Override  
    public void actionPerformed(java.awt.event.ActionEvent evt) {  
    kontinu();  
    }  
    private void kontinu() {  
    String[][] passCriteriaVariables = new String[4][2];  
    String[][] passAlternativeVariables = new String[5][2];  
    for (int ijkl = 0; ijkl < passCriteriaVariables.length; ijkl++) {    
        for (int ikjl = 0; ikjl < passCriteriaVariables[ijkl].length; ikjl++) {    
            passCriteriaVariables[ijkl][ikjl] = new String();    
        }    
    }  
    for (int aijkl = 0; aijkl < passCriteriaVariables.length; aijkl++) {    
        for (int aikjl = 0; aikjl < passCriteriaVariables[aijkl].length; aikjl++) {    
            passCriteriaVariables[aijkl][aikjl] = jawabKriteria[aijkl][aikjl].getText();    
        }    
    }  
    for (int laijkl = 0; laijkl < passAlternativeVariables.length; laijkl++) {    
        for (int laikjl = 0; laikjl < passAlternativeVariables[laijkl].length; laikjl++) {    
            passAlternativeVariables[laijkl][laikjl] = new String();    
        }    
    }  
    for (int lijkl = 0; lijkl < passAlternativeVariables.length; lijkl++) {    
        for (int likjl = 0; likjl < passAlternativeVariables[lijkl].length; likjl++) {    
            passAlternativeVariables[lijkl][likjl] = jawabAlternatif[lijkl][likjl].getText();    
        }    
    }  
    lblKriteria = passCriteriaVariables;  
    lblAlternatif = passAlternativeVariables;  
    lblNama.setVisible(false);  
    txtNama.setVisible(false);  
    kataSandi.setVisible(false);  
    sandiKata.setVisible(false);  
     masuk.setVisible(false);  
     keluar.setVisible(false);  
     tombolHubungkankePadukData.setVisible(false);  
     putuskanKoneksiKePadukData.setVisible(false);  
     tombolUbahPadukData.setVisible(false);  
     tombolBatal.setVisible(false);  
     lanjut.setVisible(false);  
     jcboURL.setVisible(false);  
     jcboDriver.setVisible(false);  
     statusKoneksi.setVisible(false);  
     padukData.setVisible(false);  
     myocardialInfarction.setVisible(true);  
     stroke.setVisible(true);  
     for (int hklma = 0; hklma < kriteria.length; hklma++) {    
        for (int nyola = 0; nyola < kriteria[hklma].length; nyola++) {    
            kriteria[hklma][nyola].setVisible(false);    
        }    
    }  
     for (int hklmaf = 0; hklmaf < jawabAlternatif1.length; hklmaf++) {    
        for (int nyolaf = 0; nyolaf < jawabAlternatif1[hklmaf].length; nyolaf++) {    
            jawabAlternatif1[hklmaf][nyolaf].setVisible(false);    
        }    
    }  
     for (int hklma = 0; hklma < alternatif.length; hklma++) {    
        for (int nyola = 0; nyola < alternatif[hklma].length; nyola++) {    
            alternatif[hklma][nyola].setVisible(false);    
        }    
    }  
     statusMasuk.setVisible(false);  
    labelPerhitunganKriteria.setVisible(true);  
         tampilKriteria.setVisible(true);  
         tampilKriteria1.setVisible(true);  
         ubah.setVisible(true);  
         kembali.setVisible(true);  
         lanjutlah.setVisible(true);  
         lanjutlah1.setVisible(true);  
         perhitunganKriteria.setVisible(true);  
         perhitunganKriteria1.setVisible(true);  
         kmbl.setVisible(true);  
         kmbl1.setVisible(true);  
         update.setVisible(true);  
         update1.setVisible(true);  
         myocardInfarc.setVisible(true);  
         stroke1.setVisible(true);  
        for (int hklma = 0; hklma < jawabKriteria1.length; hklma++) {    
            jawabKriteria1[hklma][0].setVisible(true);
            jawabKriteria1[hklma][1].setVisible(true);
        }    
         for (int hklma = 0; hklma < labelLuarKriteria.length; hklma++) {    
        for (int nyola = 0; nyola < labelLuarKriteria[hklma].length; nyola++) {    
            labelLuarKriteria[hklma][nyola].setVisible(true);    
        }    
    }  
         for (int hklma = 0; hklma < labelLuarAlternatif.length; hklma++) {    
        for (int nyola = 0; nyola < labelLuarAlternatif[hklma].length; nyola++) {    
            labelLuarAlternatif[hklma][nyola].setVisible(true);    
        }    
    }  
         for (int hklma = 0; hklma < labelLuarAlternatif1.length; hklma++) {    
        for (int nyola = 0; nyola < labelLuarAlternatif1[hklma].length; nyola++) {    
            labelLuarAlternatif1[hklma][nyola].setVisible(true);    
        }    
    }  
         for (int hklm = 0; hklm < labelLuarKriteria1.length; hklm++) {    
        for (int nyol = 0; nyol < labelLuarKriteria1[hklm].length; nyol++) {    
            labelLuarKriteria1[hklm][nyol].setVisible(true);    
        }    
    }  
         for (int hklmg = 0; hklmg < jawabKriteria.length; hklmg++) {    
        for (int nyolg = 0; nyolg < jawabKriteria[hklmg].length; nyolg++) {    
            jawabKriteria[hklmg][nyolg].setVisible(false);    
        }    
    }  
         for (int hklmga = 0; hklmga < jawabAlternatif.length; hklmga++) {    
        for (int nyolga = 0; nyolga < jawabAlternatif[hklmga].length; nyolga++) {    
            jawabAlternatif[hklmga][nyolga].setVisible(false);    
        }    
    }  
         kriteriaLanjut.setVisible(true);  
         kriteriaLanjut1.setVisible(true);  
    //FrameBaru baru = new FrameBaru(passCriteriaVariables, passAlternativeVariables); // I want to make a class that is named FrameBaru to be visible  
      
    }  
    });  
    tombolUbahPadukData.addActionListener(new java.awt.event.ActionListener() {  
    @Override  
    public void actionPerformed(java.awt.event.ActionEvent evt) {  
    ubah();  
    }  
      
    private void ubah() {  
        if (connection == null)
        {
            JOptionPane.showMessageDialog(null, "Hubungkan Dahulu ke Paduk Data", "Tidak Ada Koneksi", JOptionPane.INFORMATION_MESSAGE);
        }
        else 
        {
            for (int lmo = 0; lmo < 4; lmo++)  
                       {  
                            jawabKriteria[lmo][0].setEditable(true);
                            jawabKriteria[lmo][0].setVisible(true);
                            jawabKriteria[lmo][1].setEditable(true);  
                            jawabKriteria[lmo][1].setVisible(true);
                            kriteria[lmo][0].setVisible(true);
                            kriteria[lmo][1].setVisible(true);
                       }  
    for (int mlo = 0; mlo < 5; mlo++)  
              {  
               jawabAlternatif[mlo][0].setEditable(true);  
               jawabAlternatif[mlo][0].setVisible(true);
               jawabAlternatif[mlo][1].setEditable(true);  
               jawabAlternatif[mlo][1].setVisible(true);
               alternatif[mlo][0].setVisible(true);
               alternatif[mlo][1].setVisible(true);
              }  
                    lanjut.setEnabled(true); 
                    lanjut.setVisible(true);
                    myocardialInfarction.setVisible(true);
                    stroke.setVisible(true);
                }  
        }
            });  
    putuskanKoneksiKePadukData.addActionListener(new java.awt.event.ActionListener() {  
                @Override  
                public void actionPerformed(java.awt.event.ActionEvent evt) {  
                    putuskan();    
                }  
      
                private void putuskan() {  
                    try {
                    if (connection == null)  
                    {  
                        statusKoneksi.setText("Tidak ada Koneksi ke Paduk Data");  
                        myocardialInfarction.setVisible(false);
                        stroke.setVisible(false);
                    for (int ltu = 0; ltu < 4; ltu++)  
                       {  
                            kriteria[ltu][0].setVisible(false);
                            kriteria[ltu][1].setVisible(false);
                            jawabKriteria[ltu][0].setEditable(false);  
                            jawabKriteria[ltu][1].setEditable(false); 
                            jawabKriteria[ltu][0].setVisible(false);  
                            jawabKriteria[ltu][1].setVisible(false);  
                       }  
                    for (int tlu = 0; tlu < 5; tlu++)  
                    {  
                            jawabAlternatif[tlu][0].setEditable(false);  
                            jawabAlternatif[tlu][1].setEditable(false);  
                            jawabAlternatif[tlu][0].setVisible(false);  
                            jawabAlternatif[tlu][1].setVisible(false);
                            alternatif[tlu][1].setVisible(false);
                            alternatif[tlu][0].setVisible(false);
                       }  
                    }  
                    else   
                    {  
                    statusKoneksi.setText("Koneksi ke Paduk Data sudah Terputus");  
                    for (int lko = 0; lko < 4; lko++)  
                       {  
                            kriteria[lko][0].setVisible(false);
                            kriteria[lko][1].setVisible(false);
                            jawabKriteria[lko][0].setEditable(false);  
                            jawabKriteria[lko][1].setEditable(false); 
                            jawabKriteria[lko][0].setVisible(false);  
                            jawabKriteria[lko][1].setVisible(false);  
                       }  
                    for (int lok = 0; lok < 5; lok++)  
                    {  
                            alternatif[lok][0].setVisible(false);
                            alternatif[lok][1].setVisible(false);
                            jawabAlternatif[lok][0].setEditable(false);  
                            jawabAlternatif[lok][1].setEditable(false); 
                            jawabAlternatif[lok][0].setVisible(false);  
                            jawabAlternatif[lok][1].setVisible(false);
                       }                  
                    }  
                    connection.close();
                    statement.close();
                    myocardialInfarction.setVisible(false);
                    stroke.setVisible(false);
                }
                catch (SQLException ex) {
                    ex.printStackTrace();
                }
            }});  
    masuk.addActionListener(new java.awt.event.ActionListener() {  
                String loginName;  
                String loginPassword;    
                String passwrd;
                @Override  
                public void actionPerformed(java.awt.event.ActionEvent evt) {  
                    usrname = txtNama.getText().trim();  
                    psswrd = new String(sandiKata.getPassword());
                    try {  
                        masuklah();  
                    }   
                    catch (SQLException ex) {
                        ex.printStackTrace();
                        Logger.getLogger(ProgramTesisBaru.class.getName()).log(Level.SEVERE, null, ex);  
                    }  
                }  
      
                private void masuklah() throws SQLException {  
                      if (connection == null)  
                      {  
                          masuk.setEnabled(false);  
                          entryPrg();  
                      }  
                      else {
                          entryPrg();  
                      }  
                }  
      
                public void connectToDB() {  
                    //String uniRL = (String)jcboURL.getSelectedItem();  
                    //String driver = (String) jcboDriver.getSelectedItem();  
                    //URL uniRL = (URL)jcboURL.getSelectedItem();  
                    try {  
                        Class.forName(driver);  
                        connection = DriverManager.getConnection(uniRL, usrname, psswrd);  
                        //rowSet.setURL(uniRL);  
                        statusKoneksi.setText("Terhubung ke Paduk Data"); 
                        //statement = connection.createStatement();
                    }  
                    catch (java.lang.Exception ex) { 
                        ex.printStackTrace();
                        statusKoneksi.setText("Gagal Terhubung ke Paduk Data");  
                    }  
                }  
      
                private void entryPrg() {  
                          connectToDB();
                          try {
                          /*//System.out.println("con="+connection.isClosed());
                          Class.forName(driver);  
                          connection = DriverManager.getConnection(uniRL, usrname, psswrd);  
                          //rowSet.setURL(uniRL);  
                          statusKoneksi.setText("Terhubung ke Paduk Data"); 
                          //statement = connection.createStatement();*/
                          statement = connection.createStatement();
                          loginName = "select Nama_Dokter from tblDokterAhli where Nama_Dokter = '"+usrname+"' and Kata_Kunci = '"+psswrd+"'";  
                          //System.out.println(loginName);
                          //loginPassword = "select Kata_Kunci from tblDokterAhli where Nama_Dokter = '"+usrname+"'";
                          ResultSet logName = statement.executeQuery(loginName);  
                          //System.out.println(logName);
                          //ResultSet logPassword = statement.executeQuery(loginPassword);
                          while (logName.next()) 
                               {  
                               namaPengguna1 = logName.getString("Nama_Dokter");  
                               }  
                          //while (logPassword.next()) 
                               //{  
                               //passwordPengguna1 = logPassword.getString("Kata_Kunci");  
                               //}  
                          if (("".equals(usrname)) && ("".equals(psswrd)))   
                                 {  
                                   tombolHubungkankePadukData.setEnabled(false);  
                                   putuskanKoneksiKePadukData.setEnabled(false);  
                                   tombolUbahPadukData.setEnabled(false);  
                                   tombolBatal.setEnabled(false);  
                                   masuk.setEnabled(true);
                                   statusKoneksi.setText("Tidak Ada Koneksi ke Paduk Data");
                                   connection.close();
  14. No Profile Picture
    Permanently Banned
    Devshed Newbie (0 - 499 posts)

    Join Date
    Apr 2013
    Posts
    257
    Rep Power
    0
    Here is the last part of the code:

    Code:
                       putuskanKoneksiKePadukData.setEnabled(false); 
                                   statement.close();;
                                   JOptionPane.showMessageDialog(null, gx, ix, JOptionPane.INFORMATION_MESSAGE);  
                                 }  
                        else if ((!"".equals(usrname)) && (!"".equals(psswrd)))  
                           {  
                             if ((!"".equals(namaPengguna1)))   
                                {  
                                   tombolHubungkankePadukData.setEnabled(true);  
                                   putuskanKoneksiKePadukData.setEnabled(true);  
                                   tombolUbahPadukData.setEnabled(true);  
                                   tombolBatal.setEnabled(true);  
                                   masuk.setEnabled(false);
                                   statusKoneksi.setText("Terhubung ke Paduk Data");
                                   keluar.setEnabled(true);  
                                   putuskanKoneksiKePadukData.setEnabled(true);  
                                   statement.close();
                                   connection.close();  
                                }  
                             else if (("".equals(namaPengguna1)))  
                                {  
                                   tombolHubungkankePadukData.setEnabled(false);  
                                   putuskanKoneksiKePadukData.setEnabled(false);  
                                   tombolUbahPadukData.setEnabled(false);  
                                   tombolBatal.setEnabled(false);  
                                   keluar.setEnabled(true);
                                   masuk.setEnabled(true);
                                   statusKoneksi.setText("Tidak Ada Koneksi ke Paduk Data");
                                   putuskanKoneksiKePadukData.setEnabled(false);  
                                   JOptionPane.showMessageDialog(null, gx, ix, JOptionPane.INFORMATION_MESSAGE);  
                                   connection.close();
                                   statement.close();
                               }  
                            /*else if ((!"".equals(passwordPengguna1)))  
                               {  
                                   tombolHubungkankePadukData.setEnabled(false);  
                                   putuskanKoneksiKePadukData.setEnabled(false);  
                                   tombolUbahPadukData.setEnabled(false);  
                                   tombolBatal.setEnabled(false);
                                   masuk.setEnabled(true);
                                   statusKoneksi.setText("Tidak Ada Koneksi ke Paduk Data");
                                   keluar.setEnabled(true);  
                                   putuskanKoneksiKePadukData.setEnabled(false);  
                                   JOptionPane.showMessageDialog(null, ex, bx, JOptionPane.INFORMATION_MESSAGE);  
                                   connection.close();  
                               }*/  
        }  
        else if ((!"".equals(usrname)) && ("".equals(psswrd)))
        {  
            if (("".equals(namaPengguna1)))   
            {  
            JOptionPane.showMessageDialog(null, cx, ix, JOptionPane.INFORMATION_MESSAGE);  
              tombolHubungkankePadukData.setEnabled(false);  
              putuskanKoneksiKePadukData.setEnabled(false);  
              tombolUbahPadukData.setEnabled(false);  
              tombolBatal.setEnabled(false); 
              masuk.setEnabled(true);
              statusKoneksi.setText("Tidak Ada Koneksi ke Paduk Data");
              keluar.setEnabled(true);  
              putuskanKoneksiKePadukData.setEnabled(false);  
              connection.close();                    
              statement.close();
            }  
            /*else if (("".equals(namaPengguna1)))  
            {  
              tombolHubungkankePadukData.setEnabled(false);  
              putuskanKoneksiKePadukData.setEnabled(false);  
              tombolUbahPadukData.setEnabled(false);  
              tombolBatal.setEnabled(false);
              masuk.setEnabled(true);
              statusKoneksi.setText("Tidak Ada Koneksi ke Paduk Data");
              keluar.setEnabled(true);  
              putuskanKoneksiKePadukData.setEnabled(false);  
              JOptionPane.showMessageDialog(null, cx, bx, JOptionPane.INFORMATION_MESSAGE);                
              connection.close();                          
            }*/  
          /*else if (("".equals(passwordPengguna1)))  
          {  
            tombolHubungkankePadukData.setEnabled(false);  
            putuskanKoneksiKePadukData.setEnabled(false);  
            tombolUbahPadukData.setEnabled(false);  
            tombolBatal.setEnabled(false); 
            masuk.setEnabled(true);
            statusKoneksi.setText("Tidak Ada Koneksi ke Paduk Data");
            keluar.setEnabled(true);  
            putuskanKoneksiKePadukData.setEnabled(false);  
            JOptionPane.showMessageDialog(null, cx, bx, JOptionPane.INFORMATION_MESSAGE);                          
            connection.close();                          
          }*/  
        }  
        else if ((("".equals(usrname)) && (!"".equals(psswrd))))  
        {  
            /*if (("".equals(namaPengguna1)) && ("".equals(passwordPengguna1)))   
          {  
            JOptionPane.showMessageDialog(null, dx, bx, JOptionPane.INFORMATION_MESSAGE);  
            tombolHubungkankePadukData.setEnabled(false);  
            putuskanKoneksiKePadukData.setEnabled(false);  
            tombolUbahPadukData.setEnabled(false);  
            tombolBatal.setEnabled(false);  
            keluar.setEnabled(true);  
            masuk.setEnabled(true);
            statusKoneksi.setText("Tidak Ada Koneksi ke Paduk Data");
            putuskanKoneksiKePadukData.setEnabled(false);                          
            connection.close();                          
          } */ 
        if (("".equals(namaPengguna1)))  
          {  
            tombolHubungkankePadukData.setEnabled(false);  
            putuskanKoneksiKePadukData.setEnabled(false);  
            tombolUbahPadukData.setEnabled(false);  
            tombolBatal.setEnabled(false);  
            keluar.setEnabled(true);  
            masuk.setEnabled(true);
            statusKoneksi.setText("Tidak Ada Koneksi ke Paduk Data");
            putuskanKoneksiKePadukData.setEnabled(false);  
            JOptionPane.showMessageDialog(null, dx, ix, JOptionPane.INFORMATION_MESSAGE);                          
            connection.close(); 
            statement.close();
          }  
          /*else if (("".equals(passwordPengguna1)))  
          {  
            tombolHubungkankePadukData.setEnabled(false);  
            putuskanKoneksiKePadukData.setEnabled(false);  
            tombolUbahPadukData.setEnabled(false);  
            tombolBatal.setEnabled(false);  
            keluar.setEnabled(true); 
            masuk.setEnabled(true);
            statusKoneksi.setText("Tidak Ada Koneksi ke Paduk Data");
            putuskanKoneksiKePadukData.setEnabled(false);  
            JOptionPane.showMessageDialog(null, dx, bx, JOptionPane.INFORMATION_MESSAGE);                          
            connection.close();                          
          }  */
        }     
                          }  
                          catch (java.lang.Exception ex){ 
                              ex.printStackTrace();
                              statusMasuk.setText("Gagal Masuk");  
                          }
                }});
    
    keluar.addActionListener(new java.awt.event.ActionListener() {  
                @Override  
                public void actionPerformed(java.awt.event.ActionEvent evt) {  
                    keluar();  
                }  
      
                private void keluar() {  
                    System.exit(0);  
                }  
            });  
    tombolBatal.addActionListener(new java.awt.event.ActionListener() {  
                @Override  
                public void actionPerformed(java.awt.event.ActionEvent evt) {  
                    batal();  
                }  
      
                private void batal() {  
                    myocardialInfarction.setVisible(false);
                    stroke.setVisible(false);
                    for (int k = 0; k < 4; k++)  
                       {  
                          jawabKriteria[k][0].setText("");  
                          jawabKriteria[k][1].setText("");  
                          kriteria[k][0].setVisible(false);
                          kriteria[k][1].setVisible(false);
                       }  
                    for (int lkm = 0; lkm < 5; lkm++)  
                    {  
                          jawabAlternatif[lkm][0].setText("");  
                          jawabAlternatif[lkm][1].setText("");  
                          alternatif[lkm][0].setVisible(false);
                          alternatif[lkm][1].setVisible(false);
                       }  
                    for (int lqj = 0; lqj < 4; lqj++)  
                       {  
                          jawabKriteria[lqj][0].setEditable(false);  
                          jawabKriteria[lqj][1].setEditable(false); 
                          jawabKriteria[lqj][0].setVisible(false);  
                          jawabKriteria[lqj][1].setVisible(false);  
                       }  
                    for (int ljq = 0; ljq < 5; ljq++)  
                    {  
                          jawabAlternatif[ljq][0].setEditable(false);  
                          jawabAlternatif[ljq][1].setEditable(false);  
                          jawabAlternatif[ljq][0].setVisible(false);  
                          jawabAlternatif[ljq][1].setVisible(false);  
                       }  
                    lanjut.setEnabled(false);  
                }  
            });  
    tombolHubungkankePadukData.addActionListener(new java.awt.event.ActionListener() {  
            private String usrname;  
            private String passwrd;  
                @Override  
                public void actionPerformed(java.awt.event.ActionEvent evt) {  
                    if (connection == null)  
                    {  
                       connectToDB();  
                        try {
                            System.out.println("con="+connection.isClosed());
                        } catch (SQLException ex) {
                            Logger.getLogger(ProgramTesisBaru.class.getName()).log(Level.SEVERE, null, ex);
                        }
                       statusKoneksi.setText("Terhubung ke Paduk Data");  
                    }  
                    else  
                    {  
                        try {
                            System.out.println("con="+connection.isClosed());
                        } catch (SQLException ex) {
                            Logger.getLogger(ProgramTesisBaru.class.getName()).log(Level.SEVERE, null, ex);
                        }
                        statusKoneksi.setText("Sudah Terhubung ke Paduk Data");  
                    }  
                }  
      
            private void connectToDB() {  
                    String uniRL = "jdbc:odbc:DatabaseKlinik";  
                    //URL uniRL = (URL)jcboURL.getSelectedItem();  
                    usrname = txtNama.getText().trim();  
                    passwrd = new String(sandiKata.getPassword());  
                    try {  
                        Class.forName("sun.jdbc.odbc.JdbcOdbcDriver");  
                        connection = DriverManager.getConnection(uniRL, usrname, passwrd);  
                        //rowSet.setURL(uniRL);  
                        statusKoneksi.setText("Terhubung ke Paduk Data");  
                    }  
                    catch (ClassNotFoundException ex) {  
                        ex.printStackTrace();
                        statusKoneksi.setText("Gagal Terhubung ke Paduk Data");  
                    }
                    catch (SQLException ex) {
                        ex.printStackTrace();
                        statusKoneksi.setText("Gagal Terhubung ke Paduk Data");
                    }
            }  
        });  
    for (int m = 0; m <5; m++)  
    {  
    jawabAlternatif[m][0].setEditable(false);  
    jawabAlternatif[m][1].setEditable(false);  
    }  
    for (int hki = 0; hki < 4; hki++)  
    {  
        jawabKriteria[hki][0].setEditable(false);  
        jawabKriteria[hki][1].setEditable(false);  
    }  
    // Tanda Alternatif Harga Myocardial Infarction  
    kriteria[0][0].setBounds(1,200,100,25);  
    kriteria[1][0].setBounds(1,230,100,25);  
    kriteria[2][0].setBounds(1,260,100,25);  
    kriteria[3][0].setBounds(1,290,100,25);  
    for (int lop = 0; lop < 4; lop++)  
    {  
    konten.add(kriteria[lop][0]);  
    }  
    // Alternatif Sakit Harga Myocardial Infarction  
    jawabKriteria[0][0].setBounds(101,200,70,25);  
    jawabKriteria[1][0].setBounds(101,230,70,25);  
    jawabKriteria[2][0].setBounds(101,260,70,25);  
    jawabKriteria[3][0].setBounds(101,290,70,25);  
    for (int jki = 0; jki < 4; jki++)  
    {  
    konten.add(jawabKriteria[jki][0]);  
    }  
    // Kriteria Sakit Myocardial Infarction  
    alternatif[0][0].setBounds(200,200,100,25);  
    alternatif[1][0].setBounds(200,230,100,25);  
    alternatif[2][0].setBounds(200,260,100,25);  
    alternatif[3][0].setBounds(200,290,100,25);  
    alternatif[4][0].setBounds(200,320,100,25);  
      
    for (int loyo = 0; loyo < 5; loyo++)  
    {  
    konten.add(alternatif[loyo][0]);  
    }  
    jawabAlternatif[0][0].setBounds(360,200,70,25);  
    jawabAlternatif[1][0].setBounds(360,230,70,25);  
    jawabAlternatif[2][0].setBounds(360,260,70,25);  
    jawabAlternatif[3][0].setBounds(360,290,70,25);  
    jawabAlternatif[4][0].setBounds(360,320,70,25);  
    for (int gfk = 0; gfk < 5; gfk++)  
    {  
        konten.add(jawabAlternatif[gfk][0]);  
    }  
    // Awal Stroke  
    stroke.setBounds(0,380,200,25);  
    konten.add(stroke);  
    // Tanda Kriteria Stroke  
    kriteria[0][1].setBounds(1,420,200,25);  
    kriteria[1][1].setBounds(1,450,200,25);  
    kriteria[2][1].setBounds(1,480,200,25);  
    kriteria[3][1].setBounds(1,510,200,25);  
    for (int gdu = 0; gdu < 4; gdu++)  
    {  
    konten.add(kriteria[gdu][1]);  
    }  
    // Kriteria Sakit Stroke  
    jawabKriteria[0][1].setBounds(101,420,60,25);  
    jawabKriteria[1][1].setBounds(101,450,60,25);  
    jawabKriteria[2][1].setBounds(101,480,60,25);  
    jawabKriteria[3][1].setBounds(101,510,60,25);  
    for (int jku = 0; jku < 4; jku++)  
    {  
    konten.add(jawabKriteria[jku][1]);  
    }  
    alternatif[0][1].setBounds(200,420,100,25);  
    alternatif[1][1].setBounds(200,450,100,25);  
    alternatif[2][1].setBounds(200,480,100,25);  
    alternatif[3][1].setBounds(200,510,100,25);  
    alternatif[4][1].setBounds(200,540,100,25);  
    for (int loyom = 0; loyom < 5; loyom++)  
    {  
    konten.add(alternatif[loyom][1]);  
    }  
    jawabAlternatif[0][1].setBounds(360,420,70,25);  
    jawabAlternatif[1][1].setBounds(360,450,70,25);  
    jawabAlternatif[2][1].setBounds(360,480,70,25);  
    jawabAlternatif[3][1].setBounds(360,510,70,25);  
    jawabAlternatif[4][1].setBounds(360,540,70,25);  
    for (int gfki = 0; gfki < 5; gfki++)  
    {  
        konten.add(jawabAlternatif[gfki][1]);  
    }  
    lanjut.setBounds(880,560,100,25);  
    konten.add(lanjut);  
    lanjut.setEnabled(false);  
      
    } //Akhir Konstruktor  
    
    
    public static void main(String[] args)  
    {  
            ProgramTesisBaru tesis = new ProgramTesisBaru();   
            tesis.setTitle("Program Pemilihan Obat dengan Cara Analytic Hierarchycal Process");  
            tesis.setSize(1024,768);  
            tesis.setVisible(true);  
            tesis.setDefaultCloseOperation(JFrame.EXIT_ON_CLOSE);  
            tesis.setLocationRelativeTo(null);  
    }};
    Last edited by Tawijakarta; June 15th, 2013 at 10:39 AM.
  15. Contributing User
    Devshed Expert (3500 - 3999 posts)

    Join Date
    Aug 2010
    Location
    Eastern Florida
    Posts
    3,696
    Rep Power
    347
    It should continue to entryPrg()
    Only if the connection is open (not closed).
    What happens when the calls to connection.close() are removed?

    Can you describe what happens when the new version of the code is executed?
    Descrbe all the steps the user does and what the program does.
    What does the program do first?
    What does the user do? What does he type in and what button does he press.
    What does the program do now? What method(s) is/are called?
    What do each of the methods do as they are executed? What values are retrieved from the textfields? What values are read from the data base?
    Are the if statements true or false?
    What does the code do when they are true?
    What does the code do when they are false?



    NOTE: The posted code does not compile without many errors:
    Running: D:\Java\jdk1.7.0.7\bin\javac.exe -cp . -Xlint ProgramTesisBaru.java

    ProgramTesisBaru.java:18: error: cannot find symbol
    public class ProgramTesisBaru extends FrameBaru {
    ^
    symbol: class FrameBaru
    ProgramTesisBaru.java:19: error: cannot find symbol
    Container konten = getContentPane();
    ^
    symbol: method getContentPane()
    location: class ProgramTesisBaru
    ProgramTesisBaru.java:32: warning: [rawtypes] found raw type: JComboBox
    JComboBox jcboURL = new JComboBox (new String[] {"jdbcdbcatabaseKlinik"});
    ^
    missing type arguments for generic class JComboBox<E>
    where E is a type-variable:
    E extends Object declared in class JComboBox
    ProgramTesisBaru.java:32: warning: [rawtypes] found raw type: JComboBox
    JComboBox jcboURL = new JComboBox (new String[] {"jdbcdbcatabaseKlinik"});
    ^
    missing type arguments for generic class JComboBox<E>
    where E is a type-variable:
    E extends Object declared in class JComboBox
    ProgramTesisBaru.java:32: warning: [unchecked] unchecked call to JComboBox(E[]) as a member of the raw type JComboBox
    JComboBox jcboURL = new JComboBox (new String[] {"jdbcdbcatabaseKlinik"});
    ^
    where E is a type-variable:
    E extends Object declared in class JComboBox
    ProgramTesisBaru.java:33: warning: [rawtypes] found raw type: JComboBox
    JComboBox jcboDriver = new JComboBox (new String[] {"sun.jdbc.odbc.JdbcOdbcDriver"});
    ^
    missing type arguments for generic class JComboBox<E>
    where E is a type-variable:
    E extends Object declared in class JComboBox
    ProgramTesisBaru.java:33: warning: [rawtypes] found raw type: JComboBox
    JComboBox jcboDriver = new JComboBox (new String[] {"sun.jdbc.odbc.JdbcOdbcDriver"});
    ^
    missing type arguments for generic class JComboBox<E>
    where E is a type-variable:
    E extends Object declared in class JComboBox
    ProgramTesisBaru.java:33: warning: [unchecked] unchecked call to JComboBox(E[]) as a member of the raw type JComboBox
    JComboBox jcboDriver = new JComboBox (new String[] {"sun.jdbc.odbc.JdbcOdbcDriver"});
    ^
    where E is a type-variable:
    E extends Object declared in class JComboBox
    ProgramTesisBaru.java:161: error: cannot find symbol
    labelPerhitunganKriteria.setVisible(false);
    ^
    symbol: variable labelPerhitunganKriteria
    location: class ProgramTesisBaru
    ProgramTesisBaru.java:162: error: cannot find symbol
    tampilKriteria.setVisible(false);
    ^
    symbol: variable tampilKriteria
    location: class ProgramTesisBaru
    ProgramTesisBaru.java:163: error: cannot find symbol
    tampilKriteria1.setVisible(false);
    ^
    symbol: variable tampilKriteria1
    location: class ProgramTesisBaru
    ProgramTesisBaru.java:164: error: cannot find symbol
    ubah.setVisible(false);
    ^
    symbol: variable ubah
    location: class ProgramTesisBaru
    ProgramTesisBaru.java:165: error: cannot find symbol
    kembali.setVisible(false);
    ^
    symbol: variable kembali
    location: class ProgramTesisBaru
    ProgramTesisBaru.java:166: error: cannot find symbol
    lanjutlah.setVisible(false);
    ^
    symbol: variable lanjutlah
    location: class ProgramTesisBaru
    ProgramTesisBaru.java:167: error: cannot find symbol
    lanjutlah1.setVisible(false);
    ^
    symbol: variable lanjutlah1
    location: class ProgramTesisBaru
    ProgramTesisBaru.java:168: error: cannot find symbol
    perhitunganKriteria.setVisible(false);
    ^
    symbol: variable perhitunganKriteria
    location: class ProgramTesisBaru
    ProgramTesisBaru.java:169: error: cannot find symbol
    perhitunganKriteria1.setVisible(false);
    ^
    symbol: variable perhitunganKriteria1
    location: class ProgramTesisBaru
    ProgramTesisBaru.java:170: error: cannot find symbol
    kmbl.setVisible(false);
    ^
    symbol: variable kmbl
    location: class ProgramTesisBaru
    ProgramTesisBaru.java:171: error: cannot find symbol
    kmbl1.setVisible(false);
    ^
    symbol: variable kmbl1
    location: class ProgramTesisBaru
    ProgramTesisBaru.java:172: error: cannot find symbol
    update.setVisible(false);
    ^
    symbol: variable update
    location: class ProgramTesisBaru
    ProgramTesisBaru.java:173: error: cannot find symbol
    update1.setVisible(false);
    ^
    symbol: variable update1
    location: class ProgramTesisBaru
    ProgramTesisBaru.java:174: error: cannot find symbol
    myocardInfarc.setVisible(false);
    ^
    symbol: variable myocardInfarc
    location: class ProgramTesisBaru
    ProgramTesisBaru.java:175: error: cannot find symbol
    stroke1.setVisible(false);
    ^
    symbol: variable stroke1
    location: class ProgramTesisBaru
    ProgramTesisBaru.java:176: error: cannot find symbol
    for (int hklma = 0; hklma < jawabKriteria1.length; hklma++) {
    ^
    symbol: variable jawabKriteria1
    location: class ProgramTesisBaru
    ProgramTesisBaru.java:177: error: cannot find symbol
    for (int nyola = 0; nyola < jawabKriteria1[hklma].length; nyola++) {
    ^
    symbol: variable jawabKriteria1
    location: class ProgramTesisBaru
    ProgramTesisBaru.java:178: error: cannot find symbol
    jawabKriteria1[hklma][nyola].setVisible(false);
    ^
    symbol: variable jawabKriteria1
    location: class ProgramTesisBaru
    ProgramTesisBaru.java:181: error: cannot find symbol
    for (int hklma = 0; hklma < jawabAlternatif1.length; hklma++) {
    ^
    symbol: variable jawabAlternatif1
    location: class ProgramTesisBaru
    ProgramTesisBaru.java:182: error: cannot find symbol
    for (int nyola = 0; nyola < jawabAlternatif1[hklma].length; nyola++) {
    ^
    symbol: variable jawabAlternatif1
    location: class ProgramTesisBaru
    ProgramTesisBaru.java:183: error: cannot find symbol
    jawabAlternatif1[hklma][nyola].setVisible(false);
    ^
    symbol: variable jawabAlternatif1
    location: class ProgramTesisBaru
    ProgramTesisBaru.java:186: error: cannot find symbol
    for (int hklma = 0; hklma < labelLuarKriteria.length; hklma++) {
    ^
    symbol: variable labelLuarKriteria
    location: class ProgramTesisBaru
    ProgramTesisBaru.java:187: error: cannot find symbol
    for (int nyola = 0; nyola < labelLuarKriteria[hklma].length; nyola++) {
    ^
    symbol: variable labelLuarKriteria
    location: class ProgramTesisBaru
    ProgramTesisBaru.java:188: error: cannot find symbol
    labelLuarKriteria[hklma][nyola].setVisible(false);
    ^
    symbol: variable labelLuarKriteria
    location: class ProgramTesisBaru
    ProgramTesisBaru.java:191: error: cannot find symbol
    for (int hklma = 0; hklma < labelLuarAlternatif.length; hklma++) {
    ^
    symbol: variable labelLuarAlternatif
    location: class ProgramTesisBaru
    ProgramTesisBaru.java:192: error: cannot find symbol
    for (int nyola = 0; nyola < labelLuarAlternatif[hklma].length; nyola++) {
    ^
    symbol: variable labelLuarAlternatif
    location: class ProgramTesisBaru
    ProgramTesisBaru.java:193: error: cannot find symbol
    labelLuarAlternatif[hklma][nyola].setVisible(false);
    ^
    symbol: variable labelLuarAlternatif
    location: class ProgramTesisBaru
    ProgramTesisBaru.java:196: error: cannot find symbol
    for (int hklma = 0; hklma < labelLuarAlternatif1.length; hklma++) {
    ^
    symbol: variable labelLuarAlternatif1
    location: class ProgramTesisBaru
    ProgramTesisBaru.java:197: error: cannot find symbol
    for (int nyola = 0; nyola < labelLuarAlternatif1[hklma].length; nyola++) {
    ^
    symbol: variable labelLuarAlternatif1
    location: class ProgramTesisBaru
    ProgramTesisBaru.java:198: error: cannot find symbol
    labelLuarAlternatif1[hklma][nyola].setVisible(false);
    ^
    symbol: variable labelLuarAlternatif1
    location: class ProgramTesisBaru
    ProgramTesisBaru.java:201: error: cannot find symbol
    for (int hklm = 0; hklm < labelLuarKriteria1.length; hklm++) {
    ^
    symbol: variable labelLuarKriteria1
    location: class ProgramTesisBaru
    ProgramTesisBaru.java:202: error: cannot find symbol
    for (int nyol = 0; nyol < labelLuarKriteria1[hklm].length; nyol++) {
    ^
    symbol: variable labelLuarKriteria1
    location: class ProgramTesisBaru
    ProgramTesisBaru.java:203: error: cannot find symbol
    labelLuarKriteria1[hklm][nyol].setVisible(false);
    ^
    symbol: variable labelLuarKriteria1
    location: class ProgramTesisBaru
    ProgramTesisBaru.java:206: error: cannot find symbol
    kriteriaLanjut.setVisible(false);
    ^
    symbol: variable kriteriaLanjut
    location: class ProgramTesisBaru
    ProgramTesisBaru.java:207: error: cannot find symbol
    kriteriaLanjut1.setVisible(false);
    ^
    symbol: variable kriteriaLanjut1
    location: class ProgramTesisBaru
    ProgramTesisBaru.java:236: error: cannot find symbol
    lblKriteria = passCriteriaVariables;
    ^
    symbol: variable lblKriteria
    ProgramTesisBaru.java:237: error: cannot find symbol
    lblAlternatif = passAlternativeVariables;
    ^
    symbol: variable lblAlternatif
    ProgramTesisBaru.java:260: error: cannot find symbol
    for (int hklmaf = 0; hklmaf < jawabAlternatif1.length; hklmaf++) {
    ^
    symbol: variable jawabAlternatif1
    ProgramTesisBaru.java:261: error: cannot find symbol
    for (int nyolaf = 0; nyolaf < jawabAlternatif1[hklmaf].length; nyolaf++) {
    ^
    symbol: variable jawabAlternatif1
    ProgramTesisBaru.java:262: error: cannot find symbol
    jawabAlternatif1[hklmaf][nyolaf].setVisible(false);
    ^
    symbol: variable jawabAlternatif1
    ProgramTesisBaru.java:271: error: cannot find symbol
    labelPerhitunganKriteria.setVisible(true);
    ^
    symbol: variable labelPerhitunganKriteria
    ProgramTesisBaru.java:272: error: cannot find symbol
    tampilKriteria.setVisible(true);
    ^
    symbol: variable tampilKriteria
    ProgramTesisBaru.java:273: error: cannot find symbol
    tampilKriteria1.setVisible(true);
    ^
    symbol: variable tampilKriteria1
    ProgramTesisBaru.java:274: error: cannot find symbol
    ubah.setVisible(true);
    ^
    symbol: variable ubah
    ProgramTesisBaru.java:275: error: cannot find symbol
    kembali.setVisible(true);
    ^
    symbol: variable kembali
    ProgramTesisBaru.java:276: error: cannot find symbol
    lanjutlah.setVisible(true);
    ^
    symbol: variable lanjutlah
    ProgramTesisBaru.java:277: error: cannot find symbol
    lanjutlah1.setVisible(true);
    ^
    symbol: variable lanjutlah1
    ProgramTesisBaru.java:278: error: cannot find symbol
    perhitunganKriteria.setVisible(true);
    ^
    symbol: variable perhitunganKriteria
    ProgramTesisBaru.java:279: error: cannot find symbol
    perhitunganKriteria1.setVisible(true);
    ^
    symbol: variable perhitunganKriteria1
    ProgramTesisBaru.java:280: error: cannot find symbol
    kmbl.setVisible(true);
    ^
    symbol: variable kmbl
    ProgramTesisBaru.java:281: error: cannot find symbol
    kmbl1.setVisible(true);
    ^
    symbol: variable kmbl1
    ProgramTesisBaru.java:282: error: cannot find symbol
    update.setVisible(true);
    ^
    symbol: variable update
    ProgramTesisBaru.java:283: error: cannot find symbol
    update1.setVisible(true);
    ^
    symbol: variable update1
    ProgramTesisBaru.java:284: error: cannot find symbol
    myocardInfarc.setVisible(true);
    ^
    symbol: variable myocardInfarc
    ProgramTesisBaru.java:285: error: cannot find symbol
    stroke1.setVisible(true);
    ^
    symbol: variable stroke1
    ProgramTesisBaru.java:286: error: cannot find symbol
    for (int hklma = 0; hklma < jawabKriteria1.length; hklma++) {
    ^
    symbol: variable jawabKriteria1
    ProgramTesisBaru.java:287: error: cannot find symbol
    jawabKriteria1[hklma][0].setVisible(true);
    ^
    symbol: variable jawabKriteria1
    ProgramTesisBaru.java:288: error: cannot find symbol
    jawabKriteria1[hklma][1].setVisible(true);
    ^
    symbol: variable jawabKriteria1
    ProgramTesisBaru.java:290: error: cannot find symbol
    for (int hklma = 0; hklma < labelLuarKriteria.length; hklma++) {
    ^
    symbol: variable labelLuarKriteria
    ProgramTesisBaru.java:291: error: cannot find symbol
    for (int nyola = 0; nyola < labelLuarKriteria[hklma].length; nyola++) {
    ^
    symbol: variable labelLuarKriteria
    ProgramTesisBaru.java:292: error: cannot find symbol
    labelLuarKriteria[hklma][nyola].setVisible(true);
    ^
    symbol: variable labelLuarKriteria
    ProgramTesisBaru.java:295: error: cannot find symbol
    for (int hklma = 0; hklma < labelLuarAlternatif.length; hklma++) {
    ^
    symbol: variable labelLuarAlternatif
    ProgramTesisBaru.java:296: error: cannot find symbol
    for (int nyola = 0; nyola < labelLuarAlternatif[hklma].length; nyola++) {
    ^
    symbol: variable labelLuarAlternatif
    ProgramTesisBaru.java:297: error: cannot find symbol
    labelLuarAlternatif[hklma][nyola].setVisible(true);
    ^
    symbol: variable labelLuarAlternatif
    ProgramTesisBaru.java:300: error: cannot find symbol
    for (int hklma = 0; hklma < labelLuarAlternatif1.length; hklma++) {
    ^
    symbol: variable labelLuarAlternatif1
    ProgramTesisBaru.java:301: error: cannot find symbol
    for (int nyola = 0; nyola < labelLuarAlternatif1[hklma].length; nyola++) {
    ^
    symbol: variable labelLuarAlternatif1
    ProgramTesisBaru.java:302: error: cannot find symbol
    labelLuarAlternatif1[hklma][nyola].setVisible(true);
    ^
    symbol: variable labelLuarAlternatif1
    ProgramTesisBaru.java:305: error: cannot find symbol
    for (int hklm = 0; hklm < labelLuarKriteria1.length; hklm++) {
    ^
    symbol: variable labelLuarKriteria1
    ProgramTesisBaru.java:306: error: cannot find symbol
    for (int nyol = 0; nyol < labelLuarKriteria1[hklm].length; nyol++) {
    ^
    symbol: variable labelLuarKriteria1
    ProgramTesisBaru.java:307: error: cannot find symbol
    labelLuarKriteria1[hklm][nyol].setVisible(true);
    ^
    symbol: variable labelLuarKriteria1
    ProgramTesisBaru.java:320: error: cannot find symbol
    kriteriaLanjut.setVisible(true);
    ^
    symbol: variable kriteriaLanjut
    ProgramTesisBaru.java:321: error: cannot find symbol
    kriteriaLanjut1.setVisible(true);
    ^
    symbol: variable kriteriaLanjut1
    ProgramTesisBaru.java:839: error: cannot find symbol
    tesis.setTitle("Program Pemilihan Obat dengan Cara Analytic Hierarchycal Process");
    ^
    symbol: method setTitle(String)
    location: variable tesis of type ProgramTesisBaru
    ProgramTesisBaru.java:840: error: cannot find symbol
    tesis.setSize(1024,768);
    ^
    symbol: method setSize(int,int)
    location: variable tesis of type ProgramTesisBaru
    ProgramTesisBaru.java:841: error: cannot find symbol
    tesis.setVisible(true);
    ^
    symbol: method setVisible(boolean)
    location: variable tesis of type ProgramTesisBaru
    ProgramTesisBaru.java:842: error: cannot find symbol
    tesis.setDefaultCloseOperation(JFrame.EXIT_ON_CLOSE);
    ^
    symbol: method setDefaultCloseOperation(int)
    location: variable tesis of type ProgramTesisBaru
    ProgramTesisBaru.java:843: error: cannot find symbol
    tesis.setLocationRelativeTo(null);
    ^
    symbol: method setLocationRelativeTo(<null>)
    location: variable tesis of type ProgramTesisBaru
    79 errors
    6 warnings

    85 error(s)
    This is too much code to work with. Where is the smaller code: NewMain.java???
    Last edited by NormR; June 15th, 2013 at 10:56 AM.
Page 8 of 24 First ... 67891018 ... Last
  • Jump to page:

IMN logo majestic logo threadwatch logo seochat tools logo