Need help about delete data

[yesaya handoyo]

Hi all,i need help..I use a JList to display data from mysql data..When i delete the data from the JList,it doesn't display the way i hope..Here are the codes i've made and the sql for the tables..I got data about usrname,menu and description.When the admin add user,the menu will be saved instead of description.And when the admin want to edit the authorization,the JList will display the description instead of the menu.Thanks a lot...

The sql file :

create table `data_user` ( 
`id` int(11) auto_increment, 
`nama` varchar(13), 
`usrname` varchar(6), 
`pwd` varchar(50), 
`jabatan` varchar(10), 
`last_login` datetime, 
primary key (`id`) 
)TYPE=MYISAM; 
 
INSERT INTO `data_user` (`id`,`nama`,`usrname`,`pwd`,`jabatan`,`last_login`) VALUES 
 
('1','ADMIN','ADM','21232f297a57a5a743894a0e4a801fc3','ADM','2008-09-05 22:00:00'); 
create table `jabatan` 
( 
`kode` varchar(3), 
`jabatan` varchar(10) 
)
TYPE=MYISAM; 
INSERT INTO `jabatan` (`kode`,`jabatan`) VALUES ('ADM','ADMINISTRATOR'); 
INSERT INTO `jabatan` 
 
(`kode`,`jabatan`) VALUES ('BOS','OWNER'); 
create table `hak_user` 
( 
`usrname` varchar(6), 
`menu` varchar(20) 
)TYPE=MYISAM; 
INSERT INTO `hak_user` (`usrname`,`menu`) VALUES ('ADM','mnuSupplier'); 
INSERT INTO `hak_user` (`usrname`,`menu`) VALUES ('ADM','mnuMasterBarang'); 
INSERT INTO `hak_user` (`usrname`,`menu`) VALUES ('ADM','mnuUser'); 
INSERT INTO `hak_user` (`usrname`,`menu`) VALUES ('ADM','mnuPO'); 
INSERT INTO `hak_user` (`usrname`,`menu`) VALUES ('ADM','mnuJualHarian'); 
create table `menu_user` 
( 
`menu` varchar(20), 
`deskripsi`varchar(70) 
)TYPE=MYISAM; 
INSERT INTO `menu_user` (`menu`,`deskripsi`) VALUES ('mnuSupplier','MASTER-MENU SUPPLIER'); 
INSERT INTO `menu_user` (`menu`,`deskripsi`) VALUES ('mnuMasterBarang','MASTER-MENU MASTER BARANG'); 
INSERT INTO `menu_user` (`menu`,`deskripsi`) VALUES ('mnuUser','MASTER-MENU USER'); 
INSERT INTO `menu_user` (`menu`,`deskripsi`) VALUES ('mnuPO','PEMBELIAN-MENU PO'); 
INSERT INTO `menu_user` (`menu`,`deskripsi`) VALUES ('mnuJualHarian','PENJUALAN-HARIAN'); 

the codes :

  public void loadMenuUser(){
listModel=new DefaultListModel();
   try{     
DBConnection conn = DBConnection.getInstance();
            HakUserDAOImpl dao = new HakUserDAOImpl(conn.getCon());
            Hakuser = dao.getAll(txtUser.getText());
           for (Hakuser hakuser : Hakuser) {
            listModel.addElement(hakuser.getMenu());
            }  
           listMenu2.setModel(listModel); 
           } catch (SQLException ex) {
            Logger.getLogger(DataUserFrame.class.getName()).log(Level.SEVERE, null, ex);
        }
}
 
public void ChangeMenu(){
    ListModel list=listMenu2.getModel(); 
    for (int i=0;i<list.getSize();i++){
    Menuuser menuuser= new Menuuser();
    String menu=(String) list.getElementAt(i);
    try{
    Class.forName("com.mysql.jdbc.Driver");
    String lokasi = "jdbc:mysql://localhost/inventory?" +
                     "user=admin&password=admin"; 
    String SQL="Select deskripsi from menu_user where menu=?";
    Connection koneksi = DriverManager.getConnection(lokasi);
    PreparedStatement ptmt=koneksi.prepareStatement(SQL);
    ptmt.setString(1, menu);
   ptmt.executeQuery();
   ResultSet rs=ptmt.executeQuery();
   while (rs.next()){              
menuuser.setDeskripsi(rs.getString(1));               
 for (Menuuser user : Menuuser) {
 //  menuuser.setDeskripsi(rs.getString(1));               
listModel.removeElementAt(i);            
//listModel.setElementAt(user.getDeskripsi(), i);            
listModel.addElement(user.getDeskripsi());            
}            
listMenu2.setModel(listModel);             
}              
}            catch(Exception x){               
 JOptionPane.showMessageDialog(this,x);            
}            }            
} 
 
public DataUserFrame() {      
  initComponents();        
loadMenuUser();       
 ChangeMenu();       
//listModel = new DefaultListModel();      
}
private void btRemoveActionPerformed(java.awt.event.ActionEvent evt) {                                       
 try {            
DBConnection conn = DBConnection.getInstance();           
 HakUserDAOImpl dao2 = new HakUserDAOImpl(conn.getCon());           
 Object selected[] = listMenu2.getSelectedValues();             
Hakuser hakuser= new Hakuser();    
for (int i = selected.length - 1; i >= 0; --i) 
{    
// dao2.delete((String) selected[i]);              
try{               
Class.forName("com.mysql.jdbc.Driver");                
String lokasi = "jdbc:mysql://localhost/inventory?" +                       
 "user=admin&password=admin";                 
String SQL="Select menu from menu_user where deskripsi=?";                
Connection koneksi = DriverManager.getConnection(lokasi);               
 PreparedStatement ptmt=koneksi.prepareStatement(SQL);               
 ptmt.setString(1,(String) selected[i]);             
ResultSet rs=ptmt.executeQuery();              
while (rs.next()){              
String menu=rs.getString(1)              
hakuser.setMenu(menu);                 
//gantiMenu();              
dao2.delete(hakuser.getMenu())              
//loadMenuUser();       
 //ChangeMenu();              
listModel.removeElement(selected[i]);             
 // JOptionPane.showMessageDialog(this, "Datasselected[i]+" berhasil dihapus");              
 JOptionPane.showMessageDialog(this, "Data "+menu+" berhasil dihapus");            
 }            
}           
 catch(Exception x)
{                
JOptionPane.showMessageDialog(this,x);            
}                 
listMenu2.getSelectionModel().clearSelection();                
}        
} catch (SQLException ex) 
{Logger.getLogger(DataUserFrame.class.getName()).log(Level.SEVERE, null, ex);        }                   
}   

[Jeanne Boyarsky]

Yesaya,
It doesn't delete from where? The database or the JList?

When you debugged this, what did you learn? In particular, at what line did something different happen than you expected?

[yesaya handoyo]

Hi Jeanne,sorry..I found out the problem.I don't need to use the ChangeMenu()..Thanks a lot..And sorry..