a/--------------------------------------------
// khai báo UI
JTextField tfIMEI = new JTextField();
JTextField tfTendt = new JTextField();
JComboBox cbbLoaidt = new JComboBox();
JTextField tfHoten = new JTextField();
JTextField tfSdt = new JTextField();
JButton btnThem = new JButton("Thêm");
// Xử lý nhấn nút thêm
[Link](e -> {
String sql= "insert into DIENTHOAI values (?,?,?,?,?) ";
PreparedStatement stmt = [Link](sql);
[Link](1, [Link]());
[Link](2, [Link]());
[Link](3, [Link]().toString());
[Link](4, [Link]());
[Link](5, [Link]());
[Link]();
[Link]();
});
b/----------------------------------------------
JTextField tfIMEI = new JTextField();
JTextField tfTendt = new JTextField(); [Link](false);
JTextField tfHoten = new JTextField(); [Link](false);
JTextField tfNgaylap = new JTextField();
JTextField tfNoidungsua = new JTextField();
JButton btnThem = new JButton("Thêm");
// Enter IMEI
[Link](new KeyAdapter() {
@Override
public void KeyPressed(KeyEvent e) {
if ([Link]() != KeyEvent.VK_ENTER) return;
String sql = "select * from DIENTHOAI where IMEI =
[Link]()";
PreparedStatement stmt = [Link](sql);
ResultSet rs = [Link]();
while([Link]()) {
[Link]([Link]("tendt");
[Link]([Link]("hotenkh");
}
[Link]();
}
});
// Xu ly nut them
[Link](e -> {
String sql= "insert into SUACHUA(ngaylap, noidung, imei) values (?,?,?) ";
PreparedStatement stmt = [Link](sql);
[Link](1, [Link]());
[Link](2, [Link]());
[Link](3, [Link]());
[Link]();
[Link]();
});
c/-----------------------------------
// khai báo
JTextField tfIMEI = new JTextField();
JTextField tfTendt = new JTextField(); [Link](false);
JTextField tfHoten = new JTextField(); [Link](false);
JTextField tfNgaylap = new JTextField();
JTextField tfNoidungsua = new JTextField(); [Link](false);
JTable tbcv = new JTable();
JTable tbcvsc = new JTable();
JButton btnThemsc = new JButton("Thêm sửa chữa");
// thiết lập bảng
DefautTableModel mdcv = new DefautTableModel();
DefautTableModel mdcvsc = new DefautTableModel();
[Link](new Object[] {"Mã Công việc", "Công việc"});
[Link](new Object[] {"Công việc", "Đơn giá"});
[Link](mdcv);
[Link](mdcvsc);
// Enter IMEI
[Link](new KeyAdapter() {
@Override
public void KeyPressed(KeyEvent e) {
if ([Link]() != KeyEvent.VK_ENTER) return;
String sql = "select * from DIENTHOAI where IMEI =
[Link]()";
PreparedStatement stmt = [Link](sql);
ResultSet rs = [Link]();
while([Link]()) {
[Link]([Link]("tendt");
[Link]([Link]("hotenkh");
}
[Link]();
}
});
// Enter ngày lập
String mapsc = "";
[Link](new KeyAdapter() {
@Override
public void KeyPressed(KeyEvent e) {
if ([Link]() != KeyEvent.VK_ENTER) return;
String sql = '"select * from SUACHUA
where IMEI = [Link]() and Ngaylap =
[Link]()'";
PreparedStatement stmt = [Link](sql);
ResultSet rs = [Link]();
while([Link]()) {
[Link]([Link]("Noidungsuachua");
mapsc = [Link]("mapsc");
}
[Link]();
}
});
// load data congviec
class CongViec { String macv, tencv, dongia; boolean ispick;}
ArrayList<CongViec> arrcv = new ArrayList<>();
String sql = "select * from CONGVIEC";
PreparedStatement stmt = [Link](sql);
ResultSet rs = [Link]();
while([Link]()) {
CongViec cv = new CongViec();
[Link] = [Link]("macv");
[Link] = [Link]("tencv");
[Link] = [Link]("dongia");
[Link](cv);
[Link](new Object[] {[Link], [Link]});
}
[Link]();
// chon cong viec sua chua
[Link](new MouseAdapter() {
@Override
public void MouseClicked( MouseEvent e) {
int row = [Link]();
if (row < 0) return;
if (arrcv[row].ispick) return;
arrcv[row].ispick = true;
[Link](new Object[] {arrcv[row].tencv,
arrcv[row].dongia});
}
});
// xử lý thêm sửa chữa
[Link](e ->{
String sql1 = "insert into CT_SC values (?,?)";
PreparedStatement stmt1 = [Link](sql1);
int tongtien = 0;
for (CongViec x : arrcv) {
if(![Link]) continue;
tongtien += [Link]([Link]);
[Link](1, mapsc);
[Link](2, [Link]);
[Link]();
}
String sql2 = '"update into SUACHUA set TONGTIEN = ?
where mapsc = ?"';
PreparedStatement stmt2 = [Link](sql2);
[Link](1, tongtien);
[Link](2, mapsc);
[Link]();
[Link]();
});