Advertisement
Guest User

Untitled

a guest
Jul 13th, 2016
85
0
Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
text 0.80 KB | None | 0 0
  1. try{
  2. String url="jdbc:sqlserver://LENOVO-PC\SQL2012:1433;databaseName=qseal" ;
  3. String user="sa";
  4. String pass="123";
  5. Class.forName("com.microsoft.sqlserver.jdbc.SQLServerDriver");
  6. Connection con=DriverManager.getConnection(url,user,pass);
  7. String sql="update inventorytable set quntity=(quantity-?) where product_code=?";
  8. PreparedStatement pst=con.prepareStatement(sql);
  9. pst.setInt(1,Integer.parseInt(Quantity.getText()));
  10. pst.setString(2,ProductCode.getText());
  11. Quantity.setText("");
  12. ProductCode.setText("");
  13. close();
  14. GenerateBill gb=new GenerateBill();
  15. gb.setVisible(true);
  16. }
  17. catch(Exception e){
  18. JOptionPane.showMessageDialog(this, e.getMessage());
  19. }
  20.  
  21. "update inventorytable set quntity=(quantity-" + UserData + ") where product_code=?"
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement