MySQL error store boolean value into tinyint

Question

Class Code

this is some of code from Class Code that may help.

private ResultSet rs;
private Connection cn;
private Statement st;    

public void insertData(String data)

{
    try
    {
        st.executeUpdate(data);
        {
        JOptionPane.showMessageDialog(null, "Data berhasil Disimpan");
    }
    }
    catch(Exception e)
    {
        JOptionPane.showMessageDialog(null, "Gagal Insert Data");
    }
}

InsertDaftar Class

public class InsertDaftar implements DaftarInterface {
    public String nama;
    public boolean kuasa;
    Code cd = new Code();

    public void setNama(String nama){
         this.nama=nama;
    }
    public void setKuasa(Boolean kuasa){
         this.kuasa=kuasa;
    }
    public void Akun(){
        String data = "INSERT INTO akun (Nama,Kuasa)"+"values('"+this.nama+"','"+this.kuasa+"')";
        cd.insertData(data);
}

I have created some code boolean for radio button.

    boolean akun_kuasa;
    if (admin.isSelected()){
            akun_kuasa=true;
        }
        if (teller.isSelected()){
            akun_kuasa=false;
        }
    //todo
    InsertDaftar id = new InsertDaftar()
    id.setNama(akun_nama.getText());
    id.setKuasa(akun_kuasa);

there are warning message on

id.setKuasa(akun_kuasa);

Warning in Netbeans.

Initialize variable of akun_kuasa

I have tried to change type of "akun_kuasa" into int, and changed akun_kuasa into 0 and 1, but there still error.

I have searched this problem. but there are to many about BOOLEAN or TinyInt.

NOTE: id is an object that have a method to store into database.

What error are you getting? Please add it to your question.

PM 77-1
– PM 77-1

2015-06-14 02:16:00 +00:00
Commented Jun 14, 2015 at 2:16 — PM 77-1
– PM 77-1, Commented Jun 14, 2015 at 2:16
What in the world is id.setKuasa(), a class setter?

AsConfused
– AsConfused

2015-06-14 02:29:51 +00:00
Commented Jun 14, 2015 at 2:29 — AsConfused
– AsConfused, Commented Jun 14, 2015 at 2:29

AsConfused · Accepted Answer · 2015-06-14 03:13:26Z

1

akun_kuasa can be undefined after the if's

Set it to false first? Only u would know

It is a good compiler warning to u

akun_kuasa is declared but potentially undefined

when u call the setter

edited Jun 14, 2015 at 3:13

answered Jun 14, 2015 at 2:59

AsConfused

3352 silver badges7 bronze badges

Sign up to request clarification or add additional context in comments.

Collectives™ on Stack Overflow

MySQL error store boolean value into tinyint

1 Answer 1

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

Comments

Your Answer

Sign up or log in

Post as a guest

Related