java电话本软件及源码.rar

import javax.swing.*; import java.awt.*; import java.awt.event.*; import javax.sql.rowset.*; public class DealPanel extends JPanel{ private JButton addButton,deleteButton,alterButton; public DealPanel(){ setLayout(new FlowLayout()); addButton = new JButton("添加"); addButton.addActionListener(new Add()); deleteButton = new JButton("删除"); deleteButton.addActionListener(new Delete()); alterButton = new JButton("修改"); alterButton.addActionListener(new Alter()); add(addButton); add(deleteButton); add(alterButton); } public void setAddButtonText(String name){ addButton.setText(name); } public void setAlterButtonText(String name){ alterButton.setText(name); } class Delete implements ActionListener{ private JList list; private String lname[]; private DbOperation db; public Delete(){ db = new DbOperation(); } public void actionPerformed(ActionEvent event){ int option = JOptionPane.showConfirmDialog(null,"真的要删除吗？","添加联系人",JOptionPane.OK_CANCEL_OPTION,JOptionPane.QUESTION_MESSAGE); if(option == JOptionPane.OK_OPTION){ int index = -1; list = PhoneBook.getNamePanel().getNameList(); index = list.getSelectedIndex(); if(index!=-1){ String dname = PhoneBook.getSelectedText(); String sql = "DELETE FROM 联系方式 WHERE NAME ='"+dname+"'"; db.executeUpdate(sql); try{ lname = PhoneBook.getNamePanel().getAllName(); list.setSelectedIndex(0); PhoneBook.getMainPanel().setFieldText("","","","","","","",""); list.setListData(lname); } catch(Exception e){} } else{ JOptionPane.showMessageDialog(null,"必须先选定才能删除！","提示",JOptionPane.INFORMATION_MESSAGE); } PhoneBook.refresh(); } } } class Alter implements ActionListener{ private JList list; private String name[],lname[]; private DbOperation db; private MainPanel panel; private String nameKey; public Alter(){ list = PhoneBook.getList(); db = new DbOperation(); panel = PhoneBook.getMainPanel(); } public void actionPerformed(ActionEvent event){ name = PhoneBook.getNamePanel().getAllName(); if(event.getActionCommand().equals("修改")){ nameKey = PhoneBook.getSelectedText(); if(nameKey.equals("")){ JOptionPane.showMessageDialog(null,"请先选择要修改的联系人！","提示",JOptionPane.INFORMATION_MESSAGE); } else{ setAlterButtonText("保存修改"); panel.setEditable(true,false); } } else if(event.getActionCommand().equals("保存修改")){ setAlterButtonText("修改"); panel.setEditable(false,false); String num1 = panel.getNum1Text(); String num2 = panel.getNum2Text(); String num3 = panel.getNum3Text(); String mail = panel.getMailText(); String qq = panel.getQqText(); String workunit = panel.getWorkunitText(); String address = panel.getAddressText(); String sql = "UPDATE 联系方式 SET NUM1 ='"+num1+"',NUM2='"+num2+"',NUM3='"+num3+"',MAIL='"+mail+"',QQ='"+qq+"',WORKUNIT='"+workunit+"',ADDRESS='"+address+"' WHERE NAME='"+nameKey+"'"; db.executeUpdate(sql); } } } class Add implements ActionListener{ private MainPanel panel; private DbOperation db; private String[] lname; private JList list; public Add(){ panel = new MainPanel(); panel.setEditable(true,true); db = new DbOperation(); } public void actionPerformed(ActionEvent event){ list = PhoneBook.getNamePanel().getNameList(); panel.setFieldText("","","","","","","",""); int option = JOptionPane.showConfirmDialog(null,panel,"添加联系人",JOptionPane.OK_CANCEL_OPTION,JOptionPane.PLAIN_MESSAGE); if(option == JOptionPane.OK_OPTION){ String name = panel.getNameText(); if(name.equals("")){ JOptionPane.showMessageDialog(null,"您必须输入姓名","提示",JOptionPane.INFORMATION_MESSAGE); } else{ String num1 = panel.getNum1Text(); String num2 = panel.getNum2Text(); String num3 = panel.getNum3Text(); String mail = panel.getMailText(); String qq = panel.getQqText(); String workunit = panel.getWorkunitText(); String address = panel.getAddressText(); String sql = "INSERT INTO 联系方式 VALUES('"+name+"','"+num1+"','"+num2+"','"+num3+"','"+mail+"','"+qq+"','"+workunit+"','"+address+"')"; db.executeUpdate(sql); lname = PhoneBook.getNamePanel().getAllName(); list.setListData(lname); } } PhoneBook.refresh(); } } }