Advertisement
Guest User

Untitled

a guest
Jan 23rd, 2018
51
0
Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
text 0.51 KB | None | 0 0
  1. public void updateWyniki(int idProduktu, String ilosc) {
  2. String sql = "Select ilosc from magazyn where idProduktu =" + idProduktu;
  3. int counter = ilosc;
  4. try {
  5. ResultSet rs = st.executeQuery(sql);
  6. while (rs.next()) {
  7. counter += rs.getInt("ilosc");
  8. }
  9. } catch (SQLException e) {
  10. e.printStackTrace();
  11. }
  12.  
  13. sql = "UPDATE magazyn set ilosc = " + counter + " where idProduktu =" + idProduktu;
  14. executeUpdate(sql);
  15. }
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement