?? updatejiaofei.java
字號:
String str = "select * from jiaofei where 車牌號='" +
findcarid_t.getText().trim() + "'";
r = db.getResult(str);
r.first();
carid_t.setText(findcarid_t.getText());
jComboBox1.setSelectedItem(r.getString("費用種類"));
begindate_t.setText(r.getString("起始日期"));
enddate_t.setText(r.getString("截止日期"));
givemoney_t.setText(r.getString("交費日期"));
person_t.setText(r.getString("收款人"));
unit_t.setText(r.getString("收款單位"));
money_t.setText(r.getString("費用金額"));
demo_a.setText(r.getString("備注"));
if (r.isFirst()) {
jButton2.setEnabled(false);
jButton6.setEnabled(true);
} else if (r.isLast()) {
jButton6.setEnabled(false);
jButton2.setEnabled(true);
} else {
jButton6.setEnabled(true);
jButton2.setEnabled(true);
}
}
} catch (Exception ex) {
System.out.println(ex.toString());
}
}
public void jButton3_actionPerformed(ActionEvent e) {
try { //車牌號,費用種類,起始日期,截止日期,交費日期,收款人,收款單位,費用金額,備注
String strSQL = "update jiaofei set 車牌號='" +
carid_t.getText().trim() + "',費用種類='" +
jComboBox1.getSelectedItem() + "',起始日期='" +
begindate_t.getText().trim() + "',截止日期='" +
enddate_t.getText().trim() + "',交費日期='" +
givemoney_t.getText().trim() + "',收款人='" +
person_t.getText().trim() + "',收款單位='" +
unit_t.getText().trim() + "',費用金額='" +
money_t.getText().trim() + "',備注='" +
demo_a.getText().trim() +
"' where 維修車號='" + carid_t.getText().trim() + "'";
if (db.updateSql(strSQL)) {
JOptionPane.showMessageDialog(null, "信息修改成功！");
} else {
JOptionPane.showMessageDialog(null, "信息修改失??！");
}
} catch (Exception ex) {
System.out.println(ex.toString());
}
}
public void jButton4_actionPerformed(ActionEvent e) {
try {
String str2 = "delete from jiaofei where 車牌號='" +
carid_t.getText().trim() + "' and 費用種類='" +
jComboBox1.getSelectedItem() + "' and 起始日期='" +
begindate_t.getText().trim() + "' and 截止日期='" +
enddate_t.getText().trim() + "' and 交費日期='" +
givemoney_t.getText().trim() + "' and 收款人='" +
person_t.getText().trim() + "' and 收款單位='" +
unit_t.getText().trim() + "' and 費用金額='" +
money_t.getText().trim() + "' and 備注='" +
demo_a.getText().trim() + "'";
String q = "確定要刪除嗎？";
int ok = JOptionPane.showConfirmDialog(null, q, "確認",
JOptionPane.YES_NO_OPTION,
JOptionPane.QUESTION_MESSAGE);
if (ok == JOptionPane.YES_OPTION) {
if (db.updateSql(str2)) {
JOptionPane.showMessageDialog(null, "刪除成功！");
r.updateRow();
} else
JOptionPane.showMessageDialog(null, "刪除失??！");
}
} catch (Exception ex) {
System.out.println(ex.toString());
}
}
public void findcarid_t_focusLost(FocusEvent focusEvent) {
if (findcarid_t.getText().trim().equals(""))
JOptionPane.showMessageDialog(null,
"關鍵字不能為空！");
}
public void jButton2_actionPerformed(ActionEvent e) {
try {
r.previous();
carid_t.setText(findcarid_t.getText());
jComboBox1.setSelectedItem(r.getString("費用種類"));
begindate_t.setText(r.getString("起始日期"));
enddate_t.setText(r.getString("截止日期"));
givemoney_t.setText(r.getString("交費日期"));
person_t.setText(r.getString("收款人"));
unit_t.setText(r.getString("收款單位"));
money_t.setText(r.getString("費用金額"));
demo_a.setText(r.getString("備注"));
if (r.isFirst()) {
jButton2.setEnabled(false);
jButton6.setEnabled(true);
} else if (r.isLast()) {
jButton6.setEnabled(false);
jButton2.setEnabled(true);
} else {
jButton6.setEnabled(true);
jButton2.setEnabled(true);
}
} catch (SQLException ex) {
}
}
public void jButton6_actionPerformed(ActionEvent e) {
try {
r.next();
carid_t.setText(findcarid_t.getText());
jComboBox1.setSelectedItem(r.getString("費用種類"));
begindate_t.setText(r.getString("起始日期"));
enddate_t.setText(r.getString("截止日期"));
givemoney_t.setText(r.getString("交費日期"));
person_t.setText(r.getString("收款人"));
unit_t.setText(r.getString("收款單位"));
money_t.setText(r.getString("費用金額"));
demo_a.setText(r.getString("備注"));
if (r.isFirst()) {
jButton2.setEnabled(false);
jButton6.setEnabled(true);
} else if (r.isLast()) {
jButton6.setEnabled(false);
jButton2.setEnabled(true);
} else {
jButton6.setEnabled(true);
jButton2.setEnabled(true);
}
} catch (SQLException ex) {
}
}
public void findcarid_t_keyPressed(KeyEvent e) {
if (e.getKeyCode() == KeyEvent.VK_ENTER) {
db = new DataBaseManager();
try {
String str1 = "select * from car where 車牌號='" +
findcarid_t.getText().trim() + "'";
String str2 = "select * from jiaofei where 車牌號='" +
findcarid_t.getText().trim() + "'";
if (findcarid_t.getText().trim().equals(""))
JOptionPane.showMessageDialog(null, "請輸入車牌號！");
else if (!db.getResult(str1).first()) {
String s = "沒有編號為" + findcarid_t.getText().trim() +
"的車輛,請重新輸入車牌號。";
JOptionPane.showMessageDialog(null, s);
findcarid_t.setText("");
} else if (!db.getResult(str2).first()) {
String s = findcarid_t.getText().trim() +
"車輛的繳費信息不存在！";
JOptionPane.showMessageDialog(null, s);
findcarid_t.setText("");
} else {
String str = "select * from jiaofei where 車牌號='" +
findcarid_t.getText().trim() + "'";
r = db.getResult(str);
r.first();
carid_t.setText(findcarid_t.getText());
jComboBox1.setSelectedItem(r.getString("費用種類"));
begindate_t.setText(r.getString("起始日期"));
enddate_t.setText(r.getString("截止日期"));
givemoney_t.setText(r.getString("交費日期"));
person_t.setText(r.getString("收款人"));
unit_t.setText(r.getString("收款單位"));
money_t.setText(r.getString("費用金額"));
demo_a.setText(r.getString("備注"));
if (r.isFirst()) {
jButton2.setEnabled(false);
jButton6.setEnabled(true);
} else if (r.isLast()) {
jButton6.setEnabled(false);
jButton2.setEnabled(true);
} else {
jButton6.setEnabled(true);
jButton2.setEnabled(true);
}
}
} catch (Exception ex) {
System.out.println(ex.toString());
}
}
}
}
class Updatejiaofei_jButton4_actionAdapter implements ActionListener {
private Updatejiaofei adaptee;
Updatejiaofei_jButton4_actionAdapter(Updatejiaofei adaptee) {
this.adaptee = adaptee;
}
public void actionPerformed(ActionEvent e) {
adaptee.jButton4_actionPerformed(e);
}
}
class Updatejiaofei_jButton3_actionAdapter implements ActionListener {
private Updatejiaofei adaptee;
Updatejiaofei_jButton3_actionAdapter(Updatejiaofei adaptee) {
this.adaptee = adaptee;
}
public void actionPerformed(ActionEvent e) {
adaptee.jButton3_actionPerformed(e);
}
}
class Updatejiaofei_jButton1_actionAdapter implements ActionListener {
private Updatejiaofei adaptee;
Updatejiaofei_jButton1_actionAdapter(Updatejiaofei adaptee) {
this.adaptee = adaptee;
}
public void actionPerformed(ActionEvent e) {
adaptee.jButton1_actionPerformed(e);
}
}
class Updatejiaofei_jButton5_actionAdapter implements ActionListener {
private Updatejiaofei adaptee;
Updatejiaofei_jButton5_actionAdapter(Updatejiaofei adaptee) {
this.adaptee = adaptee;
}
public void actionPerformed(ActionEvent e) {
adaptee.jButton5_actionPerformed(e);
}
}
?? 快捷鍵說明
復制代碼
Ctrl + C
搜索代碼
Ctrl + F
全屏模式
F11
切換主題
Ctrl + Shift + D
顯示快捷鍵
?
增大字號
Ctrl + =
減小字號
Ctrl + -