我需要帮助,我到处寻找,但没有成功,我正在创建 Java gui 应用程序,它将有许多按钮,这些按钮将是一些类似的对象,并且具有来自 SQL 的名称和价格,但是数量将是按钮的点击次数,在计算出我需要删除该列表的产品后,问题是一切正常,但是当我尝试创建新列表(即 DbutilsTableModel)时,数量只是继续从上一个列表!这是擦除按钮的代码,预计会将所有计数器重置为 0(零):JButton btnBrisiListu = new JButton("Brisi racun listu"); // Button for erasing the listbuttonGroup.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(); }
1 回答

跃然一笑
TA贡献1826条经验 获得超6个赞
就像是
UPDATE ArticlesAccount SET [Piece]=[Piece] + 1 WHERE Name ='"+button.getName()+"'
这是有效的!!!!谢谢@MadProgrammer
添加回答
举报
0/150
提交
取消