Advertisement
Not a member of Pastebin yet?
Sign Up,
it unlocks many cool features!
- private void RemoveButtonActionPerformed(java.awt.event.ActionEvent evt) {
- String url = "jdbc:derby://localhost:1527/Customers";
- String username = "username";
- String password = "password";
- try {
- Connection conn = DriverManager.getConnection(url, username, password);
- if (conn != null) {
- System.out.println("Connected");
- String sql = "UPDATE STOCKn"
- + "SET NUMBERINSTOCK = NUMBERINSTOCK -"+RemoveTextField1.getText()+" n"
- + "WHERE UPPER(name)=?";
- PreparedStatement statement = conn.prepareStatement(sql);
- statement.setString(1, RemoveTextField1.getText());
- statement.setString(2, RemoveAnItemTextField.getText().toUpperCase());
- int rowsUpdated = statement.executeUpdate();
- if (rowsUpdated > 0)
- {
- JOptionPane.showMessageDialog(null,"That item has been updated successfully");
- }
- else
- {
- JOptionPane.showMessageDialog(null,"That item is either not in the database or you have entered the wrong information");
- }
- }
- }catch (SQLException ex)
- {
- JOptionPane.showMessageDialog(null,ex.getMessage());
- }
- ResultSet rs = null;
- PreparedStatement ps = null;
- try{
- Connection conn = DriverManager.getConnection(url, username, password);
- ps = conn.prepareStatement("select * from Stock");
- rs = ps.executeQuery();
- SearchTable.setModel(DbUtils.resultSetToTableModel(rs));
- }catch(Exception ex){
- JOptionPane.showMessageDialog(null, ex.getMessage());
- }
- }
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement