I wanted to make checkboxes and names added dynamically. The number of checkboxes is follow the number of row in MySQL and the name is retrieved from MySQL.
So far, the checkboxes can add dynamically but the problem is I have no idea on how to break the names so that each checkbox only have one name.
This is what I want to archive.
This is the output I get
Eerything start with staffManagement
adminAPI api= new adminAPI();
try {
num= api.displayCheckBoxAndLabel(); // there are 5 row
//allName= api.displayName();
//System.out.println(allName);
} catch (Exception e1) {
// TODO Auto-generated catch block
e1.printStackTrace();
}
deleteAdmin delete= new deleteAdmin(num);
delete.setVisible(true);
setVisible(false);
dispose();
adminAPI
public int displayCheckBoxAndLabel() throws Exception
{
int count = 0;
String sql="Select count(*) AS adminID from admin";
DatabaseConnection db = new DatabaseConnection();
Connection conn =db.getConnection();
PreparedStatement ps = conn.prepareStatement(sql);
ResultSet rs = ps.executeQuery();
while(rs.next())
{
count= rs.getInt("adminID");
}
ps.close();
rs.close();
conn.close();
return count ;
}
public List<String> displayName() throws Exception // get all the name
{
String sql = "Select name from admin";
List<String> names = new ArrayList<>();
DatabaseConnection db = new DatabaseConnection();
try (Connection conn = db.getConnection();
PreparedStatement ps = conn.prepareStatement(sql);
ResultSet rs = ps.executeQuery()) {
while (rs.next()) {
names.add(rs.getString("name"));
}
}
return names;
}
deleteAdmin
public deleteAdmin(int num)
{
super("Delete Admin");
setBounds(100, 200, 340, 229);
contentPane = new JPanel();
contentPane.setBorder(new EmptyBorder(5, 5, 5, 5));
setContentPane(contentPane);
JPanel panel = new JPanel();
panel.setBounds(35, 19, 242, 146);
contentPane.add(panel);
panel.setLayout(null);
adminAPI admin = new adminAPI();
List<String>allName = null;
try {
allName= admin.displayName();
} catch (Exception e) {
// TODO Auto-generated catch block
e.printStackTrace();
}
System.out.println(allName); //[john,1,1,23,sd]
JCheckBox[] checkBoxList = new JCheckBox[num];
for(int i = 0; i < num; i++) {
checkBoxList[i] = new JCheckBox(""+allName);
contentPane.add(checkBoxList[i]);
}
}
How can I break the arrayList so each checkbox will only have one name? Thanks
