Thread: [HELP]Bugs of Java or Wrong Code?

Dear All,
What this is bugs of Java or me not to understand java programming, this my piece code :

String kode = txtKode.getText();
        String nama = inputNama.getText();
        String keterangan = inputKeterangan.getText();
 
        try {
            Connection c = KoneksiMySql.getKoneksi();
            String sql = "UPDATE UNIT SET NAMA=?, KETERANGAN=?, WKT_INPUT=now() WHERE KODE=?";
            PreparedStatement p = c.prepareStatement(sql);
 
            p.setString(1, nama);
            p.setString(2, keterangan);
            p.setString(3, kode);
 
            p.executeUpdate();
            p.close();
            JOptionPane.showMessageDialog(null, "Data Berubah",
                    "Pemberitahuan", JOptionPane.INFORMATION_MESSAGE);
        } catch(SQLException e) {
            System.out.println("Error : " + e);
            JOptionPane.showMessageDialog(null, "Proses Rubah Unit Gagal",
                    "Pesan Error", JOptionPane.ERROR_MESSAGE);        
        }finally {
	    inputNama.setText(null);
	    inputKeterangan.setText(null);
            btnTambah.setEnable(true);
            btnHapus.setEnabled(false);
            btnRubah.setEnabled(false);
            inputNama.requestFocus();
        }

JOptionPane is Show and no error appears but data in database does not change, and code in block finally not executed.
i'm use jInternalFrame, first run Only 'Add Button, Search Button' enable and other button are disable, then when 'Search Button' is clicked and open other jInternalFrame and get data form database, 'Add button' Disable and 'Delete Button, Change Button' are Enable. that my piece code on Change Button ActionPerformed.

Please it's support.
Thanks,
Best & Regrads.

This thread has been cross posted here:

http://www.java-forums.org/new-java/80401-ask-bugs-java-wrong-code.html
https://forums.oracle.com/thread/2564228

Although cross posting is allowed, for everyone's benefit, please read:

Java Programming Forums Cross Posting Rules

The Problems With Cross Posting

Originally Posted by Darryl.Burke

This thread has been cross posted here:

http://www.java-forums.org/new-java/80401-ask-bugs-java-wrong-code.html
https://forums.oracle.com/thread/2564228

Although cross posting is allowed, for everyone's benefit, please read:

Java Programming Forums Cross Posting Rules

The Problems With Cross Posting

ya, I posted on a few forums to get the answer. because sometimes if just post on one forum, I did not get the answer of my problem.

Hello.
Which message of JOptionPane is being shown? The one in try block or the one in catch block?
Can you print the connection obj to check if it is not null?

Syed.

Originally Posted by syedbhai

Hello.
Which message of JOptionPane is being shown? The one in try block or the one in catch block?
Can you print the connection obj to check if it is not null?

Syed.

of course JOptionPane in try block, not the catch block, and there is no SQLException e errors that appear. its database connection class certainly is not null. I made a connection class in use by the whole project and checked connections at starup program, if the connection fails then the program will be closed. Another class no problem for Insert, Update and Delete using the connection class. This class includes previously no problem, this problem appeared after I use SetEnable() Method on the JButton, latter i will be upload the code.

I see.
Whatever query you are executing can you try that at the sql prompt. If there is no change in the table then the problem is with the query. Either such record does not exist or some other reason.
You said finally didn't execute. Can you put one JOptionPane.showMessageDialog() at the end of the finally block and check if the message appears?
If it appears then finally block gets executed but you don't see the gui effects you are doing.
Based on your answer I can suggest what to do next.

Thanks,
Syed.

Originally Posted by syedbhai

I see.
Whatever query you are executing can you try that at the sql prompt. If there is no change in the table then the problem is with the query. Either such record does not exist or some other reason.
You said finally didn't execute. Can you put one JOptionPane.showMessageDialog() at the end of the finally block and check if the message appears?
If it appears then finally block gets executed but you don't see the gui effects you are doing.
Based on your answer I can suggest what to do next.

Thanks,
Syed.

sql query run properly, the data in the database was changed according to query. & already me try in phpMyAdmin query run properly. strange problem appears after I use Method SetEnable(false) on jButton, at the jInternalFrame first opened. & do Method SetEnable(true) after Table in jDialog retrieve data from the database and get selected row to field in jInternalFrame . yes i think the problem is located in the GUI, if there are specific rules to use the method SetEnable() on jButton?

thanks,
Best & Regrads.

Hello.
If you want you can just mail me your code.
I will try to fix it and reply back with the working code.

Thanks,
Syed.

Originally Posted by syedbhai

Hello.
If you want you can just mail me your code.
I will try to fix it and reply back with the working code.

Thanks,
Syed.

ok.. thanks before.

Hello vikar,
Your code is just fine.
If you go to your Unit class and line numbered 265 you typed table name 'unit' in uppercase when it is expected to be in lowercase.

Thanks,
Syed.

Originally Posted by syedbhai

Hello vikar,
Your code is just fine.
If you go to your Unit class and line numbered 265 you typed table name 'unit' in uppercase when it is expected to be in lowercase.

Thanks,
Syed.

ok, i will check again. But in Insert Data menu i use uppercase 'INSERT INTO UNIT' run well, no problem found.
Note : I've tried to change the 'UNIT' to lowercase, but the data in the database remains unchanged.[COLOR="Silver"]

--- Update ---

Thanks for the support, i have solve my problem. The problem it's located in Instance of jInternalFrame.
I Love Java ^_^.[COLOR="Silver"]