【文章內(nèi)容簡(jiǎn)介】 1) UNSIGNED NOT NULL AUTO_INCREMENT,`record_num` int(6) UNSIGNED NOT NULL,`type` varchar(30) CHARACTER SET gbk COLLATE gbk_chinese_ci NOT NULL,`explains` varchar(100) CHARACTER SET gbk COLLATE gbk_chinese_ci NOT NULL,`start_date` varchar(30) CHARACTER SET gbk COLLATE gbk_chinese_ci NOT NULL,`end_date` varchar(30) CHARACTER SET gbk COLLATE gbk_chinese_ci NOT NULL,`ratifier_dept` int(11) NOT NULL,`retifier_record_num` int(11) NOT NULL,`ratifier_date` varchar(30) CHARACTER SET gbk COLLATE gbk_chinese_ci NOT NULL,PRIMARY KEY (`id`) ,CONSTRAINT `timecard_ibfk_1` FOREIGN KEY (`record_num`) REFERENCES `info_employee`.`info_record` (`record_num`),INDEX `record_num` (`record_num`) 《JAVA 基礎(chǔ)》課程設(shè)計(jì)實(shí)驗(yàn)報(bào)告 17 )。源程序：package 。import 。import 。import 。import 。import 。import 。import 。import 。import 。import 。import 。import 。import 。import 。import 。import 。import 。import 。import 。import 。import 。import 。import 。import 。import 。import 。import 。import 。import 。import 。import 。import 。import 。import 。import 。import 。import 。import 。import .*。 《JAVA 基礎(chǔ)》課程設(shè)計(jì)實(shí)驗(yàn)報(bào)告 18 import 。import 。public class RecordOperatePanel extends JPanel {private JTextField deptTextField。private JComboBox accessionFormComboBox。private JComboBox dutyComboBox。private ButtonGroup partyMemberButtonGroup = new ButtonGroup()。private ButtonGroup marriagedButtonGroup = new ButtonGroup()。private ButtonGroup sexButtonGroup = new ButtonGroup()。private JComboBox schoolageComboBox。private JComboBox nativePlaceComboBox。private JComboBox nationComboBox。private JTextField accumulationFundNOTextField。private JTextField annuitySafetyNOTextField。private JTextField pactEndDateTextField。private JTextField dimissionReasonTextField。private JTextField poSafetyNOTextField。private JTextField doleSafetyNOTextField。private JTextField medicareSafetyNOTextField。private JTextField societySafetyNOTextField。private JTextField pactAgeTextField。private JTextField bankNOTextField。private JTextField pactStartDateTextField。 《JAVA 基礎(chǔ)》課程設(shè)計(jì)實(shí)驗(yàn)報(bào)告 19 private JTextField dimissionDateTextField。private JTextField bankNameTextField。private JTextField firstPactDateTextField。private JTextField accessionDateTextField。private JTextField homeAddressTextField。private JTextField onesStrongSuitTextField。private JTextField likeTextField。private JTextField homePostalcodeTextField。private JTextField partyMemberDateTextField。private JTextField graduateSchoolTextField。private JTextField graduateDateTextField, secondSpecialtyTextField, secondSchoolageTextField, puterTextField, TextField, qqTextField, telephoneTextField, handsetTextField, addressTextField, postalcodeTextField, gradeTextField, specialtyTextField, foreignLanguageTextField, idCardTextField,partyMemberTextField,birthdayTextField,nameTextField,recordNoTextField。private JLabel photoLabel。private JTextField naPlaceTextField。SqlUtil sql = new SqlUtil()。public static Record UPDATE_RECORD = null。JScrollPane recordScrollPane = new JScrollPane()。public RecordOperatePanel(final JPanel rightPanel) {super()。final JLabel recordNoLabel = new JLabel()。( 檔案編號(hào)：)。(recordNoLabel)。recordNoTextField = new JTextField()。 《JAVA 基礎(chǔ)》課程設(shè)計(jì)實(shí)驗(yàn)報(bào)告 20 ()。(new Dimension(125, 20))。(false)。if (UPDATE_RECORD == null) {} else {(())。}(recordNoTextField)。final JPanel infoPanel = new JPanel()。(new BorderLayout())。()。(infoPanel, )。final JPanel recordInfoPanel = new JPanel()。(new GridBagLayout())。(new TitledBorder(null, 檔案信息, null, null))。()。(recordInfoPanel, )。final JLabel nameLabel = new JLabel()。(姓 名：)。(recordInfoPanel, 0, 0, nameLabel, new Insets(5, 0, 10, 0))。nameTextField = new JTextField()。(new Dimension(125, 20))。if (UPDATE_RECORD != null)(())。(recordInfoPanel, 1, 0, nameTextField, new Insets(5, 0, 10, 20))。final JLabel sexLabel = new JLabel()。(性 別：)。(recordInfoPanel, 2, 0, sexLabel, new Insets(5, 0, 10, 0))。final JRadioButton manRadioButton = new JRadioButton()。(manRadioButton)。()。(男)。(recordInfoPanel, 3, 0, manRadioButton, new Insets(0, 16, 10, 0))。final JRadioButton womanRadioButton = new JRadioButton()。(womanRadioButton)。 《JAVA 基礎(chǔ)》課程設(shè)計(jì)實(shí)驗(yàn)報(bào)告 21 ()。(女)。(recordInfoPanel, 4, 0, womanRadioButton, new Insets(0, 0, 10, 0))。if (UPDATE_RECORD != null) {。}final JLabel birthdayLabel = new JLabel()。(出生日期：)。(recordInfoPanel, 5, 0, birthdayLabel, new Insets(5, 0, 10, 0))。birthdayTextField = new JTextField()。()。(new Dimension(125, 20))。if (UPDATE_RECORD == null) {(YYYYMMDD)。} else {String date = ().toString()。date = (0, 10)。(date)。}(recordInfoPanel, 6, 0,2, birthdayTextField, new Insets(5, 0, 10, 0))。final JLabel label_2 = new JLabel()。( )。(recordInfoPanel, 8, 0, label_2, new Insets(0, 20, 0, 0))。photoLabel = new JLabel()。// 創(chuàng)建用來(lái)顯示照片的對(duì)象()。// 設(shè)置照片或文字居中顯示(new TitledBorder(null, , null, null))。// 設(shè)置邊框(new Dimension(120, 140))。// 設(shè)置顯示照片的大小if (UPDATE_RECORD == null || () == null ||().length() == 0) {// 新建檔案或未上傳照片(雙擊添加照片)。// 顯示文字提示} else {// 修改檔案并且已上傳照片URL url = ().getResource(/personnel_photo/)。// 獲得指定路徑的絕對(duì)路徑String photo = ().substring(5)+ ()。// 組織員工照片的存放路徑(new ImageIcon(photo))。// 創(chuàng)建照片對(duì)象并顯示} 《JAVA 基礎(chǔ)》課程設(shè)計(jì)實(shí)驗(yàn)報(bào)告 22 (new MouseAdapter() {// 添加鼠標(biāo)監(jiān)聽(tīng)器public void mouseClicked(MouseEvent e) {}})。final GridBagConstraints gridBagConstraints_8 = new GridBagConstraints()。 = new Insets(0, 0, 0, 0)。 = 5。 = 0。 = 9。(photoLabel, gridBagConstraints_8)。final JLabel nationLabel = new JLabel()。(民 族：