NHATKYBANHANG Table We can see that the quantity of item with H2 code is 40 (reduced by 5) while it should be 35 (reduced by 10). So the above trigger is not working properly in this case. To fix the above error, we redefine the trigger as follows: CREATE TRIGGER trg_nhatkybanhang_update_soluong ON ...
SELECT masv,hodem,name,CASE gioitinh WHEN 1 THEN Nam ELSE Female END AS gioitinh FROM sinhvien or SELECT name, address, name, CASE WHEN gioitinh=1 THEN Male ELSE Female END AS gioitinh FROM sinhvien The results of the two statements above are in the following form: Constants and expressions in the ...
} else { List li = (List) source; String selected = li.getSelectedItem(); lab.setText(selected); } } } Program execution results: Figure 4.17 ListDemo Exercise 5: Build a Dialog container class to display messages like the MessageBox function on Windows. import java.awt.*; import java.awt.event.*; ...
Constraints.gridx = 2; constraints.gridy = 5; constraints.gridheight = 1; constraints.gridwidth = 1; constraints.weightx = 2.0; layout.setConstraints(buttons[7], constraints); // Set the step for the 9th button constraints.gridx = 3; constraints.gridy = 6; constraints.gridheight = 1; ...
