我需要帮助,我到处寻找,但没有成功,我正在创建 Java gui 应用程序,它将有许多按钮,这些按钮将是一些类似的对象,并且具有来自 SQL 的名称和价格,但是数量将是按钮的点击次数,在计算出我需要删除该列表的产品后,问题是一切正常,但是当我尝试创建新列表(即 DbutilsTableModel)时,数量只是继续从上一个列表!这是擦除按钮的代码,预计会将所有计数器重置为 0(零):
JButton btnBrisiListu = new JButton("Brisi racun listu"); // Button for erasing the list
buttonGroup.add(btnBrisiListu);
btnBrisiListu.addActionListener(new ActionListener() {
public void actionPerformed(ActionEvent event) {
String naredba1 = " UPDATE ArtikliRacun SET [Komada]= 0 ";
String naredba = "SELECT [Naziv],[Komada],[Cena] from ArtikliRacun WHERE Komada > 0";
try {
Statement stmt = konekcioniObj.createStatement();
stmt.executeUpdate(naredba1);
ResultSet rs = stmt.executeQuery(naredba);
table.setModel(DbUtils.resultSetToTableModel(rs));
System.out.println(rs);
} catch (SQLException e1) {
// TODO Auto-generated catch block
e1.printStackTrace();
}
}
});
这是按钮的代码(一些文章/产品) - 所有这些按钮的代码都是相同的:
JButton button = new JButton("Jelen 0.33");
buttonGroup.add(button);
button.setName("Jelen 0.33");
button.addActionListener(new ActionListener() {
int komada = 0;
public void actionPerformed(ActionEvent event) {
komada++;
String naredba1 = " UPDATE ArtikliRacun SET [Komada]='"+komada+"' WHERE Naziv ='"+button.getName()+"' ";
String naredba = "SELECT [Naziv],[Komada],[Cena] from ArtikliRacun WHERE Komada > 0";
try {
Statement stmt = konekcioniObj.createStatement();
stmt.executeUpdate(naredba1);
ResultSet rs = stmt.executeQuery(naredba);
table.setModel(DbUtils.resultSetToTableModel(rs));
System.out.println(rs);
} catch (SQLException e1) {
// TODO Auto-generated catch block
e1.printStackTrace();
}
跃然一笑
相关分类