codice:
private void ModificaNomePlaylist() {
textNomeBase.setText("");
textIDBase.setText("");
textIDBase.setEnabled(false);
modelEdit.removeAllElements();
try {
Class.forName("org.sqlite.JDBC");
}
catch (Exception exc) {
System.out.println("Errore - Driver jdbc non presente: "+ exc.getMessage());
}
try {
conn = DriverManager.getConnection("jdbc:sqlite:basi.sqlite");
//String s1 = (String) comboEdit.getSelectedItem();
pstmt = (PreparedStatement) conn.prepareStatement("SELECT * FROM combolist ORDER BY combo ASC");
//pstmt.setString(1, s1);
rs = pstmt.executeQuery();
GridBagLayout grid = new GridBagLayout();
GridBagConstraints constraints = new GridBagConstraints();
constraints.insets.bottom = 5;
constraints.insets.left = 5;
constraints.insets.right = 5;
constraints.insets.top = 5;
constraints.fill = GridBagConstraints.BOTH;
labelModificaBase = new JLabel("Modifica Nome della PlayList");
constraints.gridx = 2;
constraints.gridy = 0;
constraints.gridheight = 1;
constraints.gridwidth = 1;
constraints.weightx = constraints.weighty = 0.0;
grid.setConstraints(labelModificaBase, constraints);
//lista playlist
constraints.gridx = 0;
constraints.gridy = 1;
constraints.gridwidth = 4;
constraints.gridheight = 4;
constraints.weightx = constraints.weighty = 1.0;
grid.setConstraints(scrollListEdit, constraints);
constraints.gridx = 0;
constraints.gridy = 5;
constraints.gridheight = 1;
constraints.gridwidth = 4;
constraints.weightx = constraints.weighty = 0.0;
constraints.fill = GridBagConstraints.HORIZONTAL;
grid.setConstraints(buttonModificaBase, constraints);
constraints.gridx = 4;
constraints.gridy = 1;
constraints.gridheight = 1;
constraints.gridwidth = 1;
constraints.weightx = constraints.weighty = 0.0;
grid.setConstraints(idBase, constraints);
constraints.gridx = 5;
constraints.gridy = 1;
constraints.gridheight = 1;
constraints.gridwidth = 1;
constraints.weightx = constraints.weighty = 0.0;
grid.setConstraints(textIDBase, constraints);
constraints.gridx = 4;
constraints.gridy = 2;
constraints.gridheight = 1;
constraints.gridwidth = 1;
constraints.weightx = constraints.weighty = 0.0;
grid.setConstraints(nomeBase, constraints);
constraints.gridx = 5;
constraints.gridy = 2;
constraints.gridheight = 1;
constraints.gridwidth = 1;
constraints.weightx = constraints.weighty = 0.0;
grid.setConstraints(textNomeBase, constraints);
constraints.gridx = 5;
constraints.gridy = 5;
constraints.gridheight = 1;
constraints.gridwidth = 1;
constraints.weightx = constraints.weighty = 0.1;
constraints.fill = GridBagConstraints.HORIZONTAL;
grid.setConstraints(salvaModificaBase, constraints);
constraints.gridx = 6;
constraints.gridy = 5;
constraints.gridheight = 1;
constraints.gridwidth = 1;
constraints.fill = GridBagConstraints.HORIZONTAL;
constraints.weightx = constraints.weighty = 0.1;
grid.setConstraints(buttonCanc, constraints);
JPanel p = new JPanel();
p.setLayout(grid);
p.add(idBase);
p.add(textIDBase);
p.add(labelModificaBase);
p.add(scrollListEdit);
p.add(buttonModificaBase);
p.add(nomeBase);
p.add(textNomeBase);
p.add(salvaModificaBase);
p.add(buttonCanc);
while (rs.next()) {
modelEdit.addElement(new QueryModificaNomePlaylist(rs.getInt("id"),rs.getString("combo")));
}
listEdit.setModel(modelEdit);
buttonModificaBase.setIcon(modifica);
buttonModificaBase.addActionListener(new ActionListener() {
public void actionPerformed(ActionEvent evt) {
try {
Class.forName("org.sqlite.JDBC");
}
catch (Exception exc) {
System.out.println("Errore - Driver jdbc non presente: "+ exc.getMessage());
}
try {
int[] selezione = listEdit.getSelectedIndices();
conn = DriverManager.getConnection("jdbc:sqlite:basi.sqlite");
for (int i=0; i<selezione.length; i++) {
QueryModificaNomePlaylist temp = (QueryModificaNomePlaylist)listEdit.getModel().getElementAt(selezione[i]);
textNomeBase.setText(temp.nomeModString2);
String tempID=String.valueOf(temp.idNumMod2);
textIDBase.setText(tempID);
}
}
catch (Exception exc) {
System.out.println("Errore: "+ exc.getMessage());
}
}
});
salvaModificaBase.setIcon(salva);
salvaModificaBase.addActionListener(new ActionListener() {
public void actionPerformed(ActionEvent evt) {
String s1 = textNomeBase.getText();
String s2= textIDBase.getText();
if (s1.equals("")){
JOptionPane.showMessageDialog(null, "Inserire il nome della playlisy", "Messaggio", JOptionPane.WARNING_MESSAGE);
}else {
try {
Class.forName("org.sqlite.JDBC");
}
catch (Exception exc) {
System.out.println("Errore - Driver jdbc non presente: "+ exc.getMessage());
}
try {
conn = DriverManager.getConnection("jdbc:sqlite:basi.sqlite");
String query = "UPDATE combolist SET combo=? where id="+s2;
pstmt = (PreparedStatement) conn.prepareStatement(query);
pstmt.setString(1, s1);
pstmt.executeUpdate();
JOptionPane.showMessageDialog(null, "Nome delle Playlist Modificata!", "Messaggio...",JOptionPane.INFORMATION_MESSAGE );
comboPrincipale.removeAllItems();
comboEdit.removeAllItems();
comboShow();
//textNomeBase.setText("");
//textIDBase.setText("");
}
catch (Exception exc) {
System.out.println("Errore: "+ exc.getMessage());
}
}
}
});
buttonCanc.setIcon(imgDelete2);
buttonCanc.addActionListener(new ActionListener() {
public void actionPerformed(ActionEvent evt) {
textNomeBase.setText("");
textIDBase.setText("");
}
});
JFrame frameModifica = new JFrame("Modifica Nome Plalist");
frameModifica.setLocationRelativeTo(null);
frameModifica.setSize(700,600);
frameModifica.getContentPane().add(p);
frameModifica.setLocationRelativeTo(null);
frameModifica.setVisible(true);
frameModifica.setDefaultCloseOperation(JFrame.DISPOSE_ON_CLOSE);
pstmt.close();
conn.close();
}
catch (Exception exc) {
System.out.println("Errore: "+ exc.getMessage());
}
}
questo è il cod. completo...vorrei tanto sapere dove sbaglio!!! in modo tale da non dover sbagliare +.....
Rispondi quotando
