How to retrieve text from check box

[Hulk]

how to retrieve text from checkBox/radio button to insert into database in ms Access..??...

[crptcblade]

Well, you can use the getLabel() method of the Checkbox. Is that what you are looking for?

[Hulk]

Ok, i try first the getLabel() to retrieve text in radio button (because it contains only one text to retrieve)but how about check box..??...if we wanna insert more than one value into db under same column(table in ms access db)..??..here are part of my codes......please verify..

***********
/**this is my check box declaration
JCheckBox IT = new JCheckBox("IT");
JCheckBox Magazine = new JCheckBox("Magazine");
JCheckBox Novel = new JCheckBox("Novel");
JCheckBox Cookery = new JCheckBox("Cookery");

*/



if (e.getSource()==saveButton) {

// INSERT DATA INTO DATABASE

try{

Statement statement = connection.createStatement();

if(!memberIDField.getText().equals("")&&
!nameField.getText().equals("")){

String query = "INSERT INTO Members(" +
"MemberID,Name,Age,Preference, " +
"AnnuallySpent,Status " +
") VALUES ('" +

memberIDField.getText() + "', '" + nameField.getText() + "', '" +
ageField.getText() + "','" +

// HERE I'V TO RETRIEVE THE VALUES FROM CHECK BOX & INSERT INTO DB... annuallySpentField.getText() + "', '" + statusField.getText() + "')";

JOptionPane.showMessageDialog(null,"Sending Query....Please wait.. ");

int result = statement.executeUpdate(query);

if(result == 1){

JOptionPane.showMessageDialog(null,"Insertion Succcessful !!!");
memberIDField.setText("");
nameField.setText("");
ageField.setText("");
IT.setSelected(false);
Magazine.setSelected(false);
Novel.setSelected(false);
Cookery.setSelected(false);
annuallySpentField.setText("");
statusField.setText("");

}



else{

JOptionPane.showMessageDialog(null,"Insertion FAILED!!!");
memberIDField.setText("");
nameField.setText("");
ageField.setText("");
IT.setSelected(false);
Magazine.setSelected(false);
Novel.setSelected(false);
Cookery.setSelected(false);
annuallySpentField.setText("");
statusField.setText("");



}//ELSE


}// first IF


else

JOptionPane.showMessageDialog(null,"Please Enter Member's ID and Name Price");
statement.close();


}// try


catch (SQLException sqlex){

sqlex.printStackTrace();
System.out.println(sqlex.toString());

}//catch



} // if saveButton