java实现药房管理系统

import javax.swing.*; import java.awt.*; import java.awt.event.*; import java.sql.*; import java.util.Date; import java.text.SimpleDateFormat; class currentMedicManage extends JFrame implements ActionListener,FocusListener,ItemListener { Statement sql; ResultSet rs; public static int sign=-1; public static int row=-1; public Connection con; Box box1; public Checkbox MedicNum_checkbox,spellCode_checkbox,usefulDate_checkbox,medicName_checkbox,currentMedicNum_checkbox; Panel panel1,panel2,panel3,panel4,panel5,panel6,panel7,panel8; Checkbox amend_checkbox,amendBelow_checkbox; CheckboxGroup sort; public static TextField medicName_textf,currentMedicNum_textf,selectSpellCode_textf; public static TextField spellCode_textf,productionManufacturer_textf,MedicNum_textf; public static TextField usefulDate_textf,sellPrice_textf,inputPrice_textf,passNum_textf,inputNum_textf; public static TextField medicSpec_textf,unit_textf; JTable table; Object value[][]; Object name[]={"药品编号","药品名称","拼音代码","药品规格","批准文号","进货单价","销售单价","有效期限","库存量","生产商","入库单号","计量单位"}; public Button delete_button,save_button,return_button,add_button,amend_button; public currentMedicManage(String s) { super(s); createConect(); panel1=new Panel(); panel2=new Panel(); panel3=new Panel(); panel4=new Panel(); panel5=new Panel(); panel6=new Panel(); panel7=new Panel(); panel8=new Panel(); box1=Box.createVerticalBox(); sort=new CheckboxGroup(); MedicNum_checkbox=new Checkbox("按 药 品 编 号 排 序",true,sort); MedicNum_checkbox.addItemListener(this); spellCode_checkbox=new Checkbox("按 拼 音 代 码 排 序",false,sort); spellCode_checkbox.addItemListener(this); usefulDate_checkbox=new Checkbox("按 有 效 期 限 排 序",false,sort); usefulDate_checkbox.addItemListener(this); medicName_checkbox=new Checkbox("按 药 品 名 称 排 序",false,sort); medicName_checkbox.addItemListener(this); currentMedicNum_checkbox=new Checkbox("按 库 存 数 量 排 序",false,sort); currentMedicNum_checkbox.addItemListener(this); panel7.add(MedicNum_checkbox); panel7.add(spellCode_checkbox); panel7.add(usefulDate_checkbox); panel7.add(medicName_checkbox); panel7.add(currentMedicNum_checkbox); box1.add(panel7); panel6.add(new Label("[输入拼音代码筛选]")); selectSpellCode_textf=new TextField(20); selectSpellCode_textf.addActionListener(this); panel6.add(selectSpellCode_textf); box1.add(panel6); panel1.add(new Label("[药品编号]")); MedicNum_textf= new TextField(20); MedicNum_textf.setEditable(false); panel1.add(MedicNum_textf); panel1.add(new Label("[药品名称]")); medicName_textf= new TextField(20); medicName_textf.setEditable(false); panel1.add(medicName_textf); panel1.add(new Label("[拼音代码]")); spellCode_textf= new TextField(20); spellCode_textf.setEditable(false); panel1.add(spellCode_textf); box1.add(panel1); // panel2.add(new Label("[生产厂商]")); productionManufacturer_textf= new TextField(20); productionManufacturer_textf.setEditable(false);/////////////////////////////////// panel2.add(productionManufacturer_textf); panel2.add(new Label("[有效期限]")); usefulDate_textf= new TextField(20); usefulDate_textf.setEditable(false); panel2.add(usefulDate_textf); panel2.add(new Label("[销售单价]")); sellPrice_textf= new TextField(20); sellPrice_textf.setEditable(false);////////////////////////////////// panel2.add(sellPrice_textf); box1.add(panel2); // panel3.add(new Label("[药品规格]")); medicSpec_textf= new TextField(20); medicSpec_textf.setEditable(false); panel3.add(medicSpec_textf); panel3.add(new Label("[计量单位]")); unit_textf= new TextField(20); unit_textf.setEditable(false); panel3.add(unit_textf); panel3.add(new Label("[批准文号]")); passNum_textf= new TextField(20); passNum_textf.setEditable(false);//////////////////////////////////// panel3.add(passNum_textf); box1.add(panel3); // panel4.add(new Label("[库存数量]")); currentMedicNum_textf=new TextField(20); currentMedicNum_textf.setEditable(false); panel4.add(currentMedicNum_textf); panel4.add(new Label("[进货单价]")); inputPrice_textf= new TextField(20); inputPrice_textf.setEditable(false); panel4.add(inputPrice_textf); panel4.add(new Label("[入库单号]")); inputNum_textf= new TextField(20); inputNum_textf.setEditable(false); panel4.add(inputNum_textf); box1.add(panel4); add_button=new Button(" 新 增 "); add_button.addActionListener(this); delete_button=new Button(" 删 除 "); delete_button.addActionListener(this); amend_button=new Button(" 修 改 "); amend_button.addActionListener(this); save_button=new Button("保 存 "); save_button.addActionListener(this); return_button=new Button(" 返 回 "); return_button.addActionListener(this); panel5.add(add_button); panel5.add(delete_button); panel5.add(amend_button); panel5.add(save_button); panel5.add(return_button); box1.add(panel5); value=new Object[medicCount()+10][12]; table=new JTable(value,name); table.addFocusListener(this); box1.add(new JScrollPane(table)); add(box1); addWindowListener(new WindowAdapter() { public void WindowClosing(WindowEvent e) { System.exit(0); } } ); setSize(820,500); setVisible(true); addDataToCurrentMedicManage(); } /// public void focusGained(FocusEvent e) { int h=table.getSelectedRow(); if(value[h][0]!=null) { if(value[h][0]!=null) MedicNum_textf.setText(value[h][0].toString()); if(value[h][1]!=null) medicName_textf.setText(value[h][1].toString()); if(value[h][2]!=null) spellCode_textf.setText(value[h][2].toString()); if(value[h][3]!=null) medicSpec_textf.setText(value[h][3].toString()); if(value[h][4]!=null) passNum_textf.setText(value[h][4].toString()); if(value[h][5]!=null) inputPrice_textf.setText(value[h][5].toString()); if(value[h][6]!=null) sellPrice_textf.setText(value[h][6].toString()); if(value[h][7]!=null) usefulDate_textf.setText(value[h][7].toString()); if(value[h][8]!=null) currentMedicNum_textf.setText(value[h][8].toString()); if(value[h][9]!=null) productionManufacturer_textf.setText(value[h][9].toString()); if(value[h][10]!=null) inputNum_textf.setText(value[h][10].toString()); if(value[h][11]!=null) unit_textf.setText(value[h][11].toString()); do { value[h][0]=null; value[h][1]=null; value[h][2]=null; value[h][3]=null; value[h][4]=null; value[h][5]=null; value[h][6]=null; value[h][7]=null; value[h][8]=null; value[h][9]=null; value[h][10]=null; value[h][11]=null; if(++h>row) { break; } } while (value[h][0]!=null); table.repaint(); } } public void focusLost(FocusEvent e) { } ///// public void changeNull() { spellCode_textf.setText(""); medicName_textf.setText(""); MedicNum_textf.setText(""); sellPrice_textf.setText(""); usefulDate_textf.setText(""); productionManufacturer_textf.setText(""); unit_textf.setText(""); medicSpec_textf.setText(""); inputPrice_textf.setText(""); currentMedicNum_textf.setText(""); passNum_textf.setText(""); inputNum_textf.setText(""); } ///// public void changefalse(int b) { if(b==0) { spellCode_textf.setEditable(false); medicName_textf.setEditable(false); sellPrice_textf.setEditable(false); usefulDate_textf.setEditable(false); productionManufacturer_textf.setEditable(false); uni