?? addspecialduty.java
字號:
package frame;
import javax.swing.*;
import java.awt.*;
import model.*;
import java.awt.event.*;
import com.DAO;
import java.sql.*;
public class AddSpecialDuty extends JFrame{
JFrame asd = new JFrame("職稱添加");
JPanel p = new JPanel();
JLabel lblduty = new JLabel("職稱名稱:");
JTextField txtduty = new JTextField(10);
JLabel lg = new JLabel("職稱等級:");
JComboBox cbodg = new JComboBox();
JLabel ls = new JLabel("職稱序列:");
JComboBox cbos = new JComboBox();
JLabel lmark = new JLabel("聘任標志:");
JTextField txtmark = new JTextField(10);
JLabel lhd = new JLabel("聘任日期:");
JTextField thd = new JTextField(10);
JLabel lfd = new JLabel("解聘日期:");
JTextField tfd = new JTextField(10);
JLabel lsaldg = new JLabel("工資等級:");
JTextField txtsaldg = new JTextField(10);
JLabel lsal = new JLabel("工資金額:");
JTextField txtsal = new JTextField(10);
JLabel lsdmd = new JLabel("工資調整時間:");
JTextField tsdmd = new JTextField(10);
JButton btnduty = new JButton("添加職稱");
public AddSpecialDuty() {
// 初始化
FrameInit.InitFrame(asd, p);
asd.addWindowListener(new WindowAdapter(){
public void windowOpened(WindowEvent e){
ResultSet rs1 = DAO.getSpecialDutygrade();
ResultSet rs2 = DAO.getSpecialserial();
try{
//初始化等級下拉框
while(rs1.next()){
cbodg.addItem(new Integer(rs1.getInt("sdgrade")));
}
//初始化序列下拉框
while(rs2.next()){
cbos.addItem(new Integer(rs2.getInt("sdsid")));
}
}catch(Exception ex){
System.out.println(ex.getMessage());
}
}
});
asd.setSize(new Dimension(300,500));
p.setLayout(new GridLayout(10,1));
JPanel p1 = new JPanel();
JPanel p2 = new JPanel();
JPanel p3 = new JPanel();
JPanel p4 = new JPanel();
JPanel p5 = new JPanel();
JPanel p6 = new JPanel();
JPanel p7 = new JPanel();
JPanel p8 = new JPanel();
JPanel p9 = new JPanel();
JPanel p10 = new JPanel();
p.add(p1);
p.add(p2);
p.add(p3);
p.add(p4);
p.add(p5);
p.add(p6);
p.add(p7);
p.add(p8);
p.add(p10);
p.add(p9);
p1.add(lblduty);
p1.add(txtduty);
p2.add(lg);
p2.add(cbodg);
p3.add(ls);
p3.add(cbos);
p4.add(lmark);
p4.add(txtmark);
p5.add(lhd);
p5.add(thd);
p6.add(lfd);
p6.add(tfd);
p7.add(lsaldg);
p7.add(txtsaldg);
p8.add(lsal);
p8.add(txtsal);
p10.add(lsdmd);
p10.add(tsdmd);
p9.add(btnduty);
//添加按鈕的事件監聽
btnduty.addActionListener(new ActionListener(){
public void actionPerformed(ActionEvent e){
//名稱不能為空
if(txtduty.getText().equals("")){
JOptionPane.showMessageDialog(null, "請輸入職稱名稱!","警告",JOptionPane.WARNING_MESSAGE);
return;
}
//封裝到實體
TbSpecialdutyInfo info = new TbSpecialdutyInfo();
info.setSdname(txtduty.getText().trim());
info.setSdgrade(Integer.parseInt(cbodg.getSelectedItem().toString().trim()));
info.setSdsalgrade(Integer.parseInt(cbos.getSelectedItem().toString().trim()));
info.setHiremark(txtmark.getText().trim());
info.setHiredate(thd.getText().trim());
info.setFiredate(tfd.getText().trim());
info.setSdsalgrade(Integer.parseInt(txtsaldg.getText().trim()));
info.setSdsal(Integer.parseInt(txtsal.getText().trim()));
info.setSdsalmoddate(tsdmd.getText().trim());
//執行插入
boolean flag = DAO.addSpecialduty(info);
//判斷是否執行成功
if(flag){
JOptionPane.showMessageDialog(null, "添加職稱成功!","友情提示",JOptionPane.INFORMATION_MESSAGE);
return;
}else{
JOptionPane.showMessageDialog(null, "添加職稱失敗!","發生錯誤",JOptionPane.ERROR_MESSAGE);
return;
}
}
});
asd.setVisible(true);
}
}
?? 快捷鍵說明
復制代碼
Ctrl + C
搜索代碼
Ctrl + F
全屏模式
F11
切換主題
Ctrl + Shift + D
顯示快捷鍵
?
增大字號
Ctrl + =
減小字號
Ctrl + -