【正文】 g this保存成功 addGysqcToComboBox cmb_xiugaigysqc addGysqcToComboBox cmb_shanchugysqc addGysqcToComboBox cmb_xiugaigysqc addGysqcToComboBox cmb_shanchugysqc gysqc cmb_xiugaigysqcgetSelectedItem toString queryGysInfoToTextFields gysqc showGysInfoToTable 全部 btn_baocunsetEnabled false exprintStackTrace 修改供應(yīng)商信息修改供應(yīng)商信息窗體設(shè)計(jì)如圖53所示圖53 修改供應(yīng)商信息窗體代碼實(shí)現(xiàn)public void updateGysInfo String gysid try String gysqc txf_xiugaigysqcgetText trim String jiancheng txf_xiugaijianchenggetText trim String dizhi txf_xiugaidizhigetText trim String youbian txf_xiugaiyoubiangetText trim String dianhua txf_xiugaidianhuagetText trim String chuanzhen txf_xiugaichuanzhengetText trim String lianxiren txf_xiugailianxirengetText trim String lianxidianhua txf_xiugailianxidianhuagetText trim String kaihuhang txf_xiugaikaihuhanggetText trim String txf_xiugaigetText trim conn daoConngetConn pssetString 1gysqc pssetString 2jiancheng pssetString 3dizhi pssetString 4youbian pssetString 5dianhua pssetString 6chuanzhen pssetString 7lianxiren pssetString 8lianxidianhua pssetString 9kaihuhang pssetString 10yinhangzhanghao pssetString 11 pssetString 12gysid psexecuteUpdate JOptionPaneshowMessageDialog this修改成功 catch Exception ex JOptionPaneshowMessageDialog this數(shù)據(jù)庫(kù)異常 finally 刪除供應(yīng)商信息刪除供應(yīng)信息窗體設(shè)計(jì)如圖54所示圖54 刪除供應(yīng)商信息頁(yè)面代碼實(shí)現(xiàn)private void btn_shanchuActionPerformed tActionEvent evt Object object null int selectedRow tb_shanchugetSelectedRow if totalRows 1 selectedRow 1 JOptionPaneshowMessageDialog this請(qǐng)選擇要?jiǎng)h除的行 return else if totalRows 1 object tableModelgetValueAt 00 else if totalRows 1 tb_shanchugetRowCount 0 JOptionPaneshowMessageDialog this沒有可以刪除的數(shù)據(jù) return else object tableModelgetValueAt selectedRow0 if object null String gysid objecttoString if JOptionPaneshowConfirmDialog this確實(shí)要?jiǎng)h除該供應(yīng)商信息嗎\t\n單擊確定按鈕將永久刪除不能恢復(fù)\t\n確認(rèn)對(duì)話框JOptionPaneOK_CANCEL_OPTION JOptionPaneOK_OPTION deleteGysInfo gysid addGysqcToComboBox cmb_xiugaigysqc addGysqcToComboBox cmb_shanchugysqc if cmb_xiugaigysqcgetItemCount 0 String queryGysInfoToTextFields gysqc showGysInfoToTable gongyingshangquancheng else JOptionPaneshowMessageDialog this請(qǐng)選擇有數(shù)據(jù)的行 入庫(kù)信息查詢模塊入庫(kù)信息查詢窗體設(shè)計(jì)如圖55所示圖55 入庫(kù)查詢頁(yè)面頁(yè)面代碼實(shí)現(xiàn)由于篇幅有限這里只給出查詢按鈕的事件處理過程和該事件處理過程所用到的方法private void showDataToTable String sql String[] columnNames 入庫(kù)票號(hào) 商品編號(hào) 商品名稱 產(chǎn)地 規(guī)格 單價(jià)數(shù)量 金額 結(jié)算方式 入庫(kù)日期 批號(hào) 批準(zhǔn)文號(hào) 供應(yīng)商全稱 驗(yàn)收結(jié)論 備注 String[][] tableValues getData sql tableModel new DefaultTableModel tableValues columnNames tb_showrukuinfosetModel tableModel TableColumn column tb_showrukuinfogetColumn 入庫(kù)票號(hào) columnsetPreferredWidth 110 column tb_showrukuinfogetColumn 產(chǎn)地 columnsetPreferredWidth 100 圖56 添加用戶信息窗體b代碼實(shí)現(xiàn)private void saveUserInfo String username String pwd try String sql insert into tb_user values conn daoConngetConn ps connprepareStatement sql pssetString 1 username pssetString 2 pwd pssetString 3 一般用戶 psexecuteUpdate JOptionPaneshowMessageDialog this 新用戶添加成功 catch Exception ex JOptionPaneshowMessageDialog this 數(shù)據(jù)庫(kù)中已經(jīng)存在該用 戶\t\n請(qǐng)換個(gè)用戶名 finally try connclose catch Exception e JOptionPaneshowMessageDialog this 數(shù)據(jù)庫(kù)異常\t\n egetMessage txf_usernamesetText null pwd_passwordsetText null pwd_okpasswordsetText null txf_usernamerequestFocus 刪除用戶信息刪除用戶信息窗體設(shè)計(jì)如圖57所示圖57 刪除用戶信息窗體代碼實(shí)現(xiàn)Privatevoidbtn_scshanchuActionPerformed tActionEvent evt try if SaveUserInfogetQuanXian equals 系統(tǒng)管理員 int currentRow tb_showuserinfogetSelectedRow String username Object object tableModelgetValueAt currentRow 0 if object null username objecttoString String sql delete from tb_user where username conn daoConngetConn ps connprepareStatement sql pssetString 1 username if psexecuteUpdate 0 JOptionPaneshowMessageDialog this 刪除成功 showUsername showUserInfoToTable 全部 else if SaveUserInfogetQuanXian equals 管理員 JOptionPane showMessageDialog this 管理員只具有查看用戶信息的權(quán)限不能刪除用戶 catch Exception ex exprintStackTrace 設(shè)置用戶權(quán)限設(shè)置用戶權(quán)限窗體設(shè)計(jì)如圖58所示圖58 設(shè)置用戶權(quán)限窗體b代碼實(shí)現(xiàn)private void jTabbedPane1StateChanged jtChangeEvent evt if jTabbedPane1getTitleAt jTabbedPane1getSelectedIndex equals 設(shè)置權(quán)限 if SaveUserInfogetQuanXian equals 系統(tǒng)管理員 addUserToComboBox cmb_username 系統(tǒng)管理員 showQuanxian else if SaveUserInfogetQuanXian equals 管理員 addUserToComboBox cmb_username 管理員 showQuanxian else JOptionPaneshowMessageDialog this 您不