基于Java+Swing+Mysql实现通讯录管理系统2

package menu; import javax.swing.*; import java.io.*; import java.sql.Connection; import java.sql.DriverManager; import java.sql.ResultSet; import java.sql.SQLException; import java.sql.Statement; import java.util.Scanner; import java.awt.*; import java.awt.event.*; import javax.swing.event.*; public class Menu extends JFrame { public static void main(String[] args) { Menu app=new Menu(); app.addWindowListener ( new WindowAdapter() { public void windowClosing(WindowEvent e){System.exit(0);} } ); } TextField text1=new TextField(50); TextField text2=new TextField(50); TextField text3=new TextField(50); TextField text4=new TextField(50); TextField text5=new TextField(50); TextField text6=new TextField(50); TextField t1=new TextField(50); TextField t2=new TextField(50); TextField t3=new TextField(50); TextField t4=new TextField(50); TextField t5=new TextField(50); TextField t6=new TextField(50); TextField ta1=new TextField(5); TextField ta2=new TextField(5); TextField ta3=new TextField(5); TextArea txt1 =new TextArea(50,50); JButton b1=new JButton("清除"); JButton b2=new JButton("保存"); JButton b3=new JButton("修改"); JButton b4=new JButton("删除"); JButton b5=new JButton("查询"); Label l1=new Label(" Enter name :"); Label l2=new Label(" Enter age :"); Label l3=new Label(" Enter sex :"); Label l4=new Label(" Enter telephone :"); Label l5=new Label(" Enter address :"); Label l6=new Label(" Enter other :"); Label a1=new Label(" Enter name :"); Label a2=new Label(" Enter age :"); Label a3=new Label(" Enter sex :"); Label a4=new Label(" Enter telephone :"); Label a5=new Label(" Enter address :"); Label a6=new Label(" Enter other :"); Label a7=new Label("(Enter the name to delete)"); Label la1=new Label("name:"); Label la2=new Label("age:"); Label la3=new Label("sex:"); Label la4=new Label(" "); Label la8=new Label(" "); Label la9=new Label(" "); Label la11=new Label(" "); Label la12=new Label(" "); Label la5=new Label(""); Label la6=new Label(""); Label la7=new Label(""); JMenuBar bar; JMenu file,sear,dele; JMenuItem name,show,clear,sall,dall,oage,oname; JPanel ff=new JPanel(); JPanel f1=new JPanel(); JPanel f2=new JPanel(); JPanel f3=new JPanel(); JPanel f4=new JPanel(); JTabbedPane Tpan=new JTabbedPane();//定义分页面板对象 public Menu() //构造方法实现图形化界面 { super("通讯录");//用jframe设置title ff=(JPanel)this.getContentPane();//ff对象获取框架 text1.setBounds(50, 50, 130, 20); text2.setBounds(50, 70, 130, 20); f1.setVisible(true); f1.setBounds(0, 0, 300, 200); f1.setLayout(new FlowLayout());//设置页面的布局 f1.add(l1); f1.add(text1); f1.add(l2); f1.add(text2); f1.add(l3); f1.add(text3); f1.add(l4); f1.add(text4); f1.add(l5); f1.add(text5); f1.add(l6); f1.add(text6); f1.add(b1); f1.add(b2); f2.setLayout(new BorderLayout(10,50)); //设计f2的布局 bar=new JMenuBar(); sear=new JMenu("查找"); dele=new JMenu("删除"); name =new JMenuItem("姓名"); show =new JMenuItem("显示"); clear=new JMenuItem("清空"); sall =new JMenuItem("查找全部"); dall =new JMenuItem("删除全部"); bar.add(sear); bar.add(dele); sear.add(sall); dele.add(dall); setJMenuBar(bar);//现实或隐藏此组件 setVisible(true); //设置文本框 f2.add(txt1,BorderLayout.CENTER); f2.add(bar ,BorderLayout.NORTH); f2.add(f4 ,BorderLayout.WEST); f2.add(la5 ,BorderLayout.EAST); f2.add(la6 ,BorderLayout.SOUTH); //**************************************************************************** b1.addActionListener(new clean()); b2.addActionListener(new sav()); b3.addActionListener(new alter()); b4.addActionListener(new delec()); b5.addActionListener(new search()); //添加相应的监听者 show.addActionListener(new shower()); sall.addActionListener(new shower()); dall.addActionListener(new dall()); clear.addActionListener(new clean()); //************************************************************************************* ff.add(Tpan);//把两个容器放到分页面板tpan中然后放入同一个容器ff中 Tpan.add(f1,0); Tpan.add(f2,1); Tpan.add(f3,2); Tpan.setTitleAt(0, "输入信息"); Tpan.setTitleAt(1, "查看信息"); Tpan.setTitleAt(2, "修改信息"); Tpan.setSelectedIndex(0); //设置初始页 //设置第三个面板*********************************************************************************** f1.setLayout(new FlowLayout()); f3.add(a1); f3.add(t1); f3.add(a2); f3.add(t2); f3.add(a3); f3.add(t3); f3.add(a4); f3.add(t4); f3.add(a5); f3.add(t5); f3.add(a6); f3.add(t6); f3.add(b3); f3.add(b4); f3.add(a7); //****************设置第二个中的West面板************************************************ f4.setLayout(new GridLayout(4,5)); f4.add(la1);f4.add(ta1); f4.add(la2);f4.add(ta2); f4.add(la3);f4.add(ta3); f4.add(la4);f4.add(b5); f4.add(la7); f4.add(la8);f4.add(la9); f4.add(la11);f4.add(la12); txt1.setSize(50, 50); setSize(500,400); show(); } class clean implements ActionListener{ //实现“清除”功能 public void actionPerformed(ActionEvent e){ Object source=e.getSource(); if(source==b1) text1.setText(""); text2.setText(""); text3.setText(""); text4.setText(""); text5.setText(""); text6.setText(""); txt1 .setText(""); } } class dall implements ActionListener{ //类dall实现删除全部数据 public void actionPerformed(ActionEvent e) { String driver="com.mysql.cj.jdbc.Driver"; //jdbc协议：数据库子协议：主机：端口/连接的数据库 String url="jdbc:mysql://localhost:3306/addressbook?useSSL=false&allowPublicKeyRetrieval=true&serverTimezone=UTC"; String use="root"; String password="zj+12345678"; try{ //加载驱动程序 // 通过得到字节码对象的方式加载静态代码块，从而注册驱动程序 Class.forName(driver); //建立连接 Connection con=DriverManager.getConnection(url,use,password);//执行sql语句 Statement stmt=con.createStatement(); String sql="delete from number"; stmt.executeUpdate(sql); } catch(Exception ce) { ce.printStackTrace(); } } } class shower implements ActionListener{ //类shower用来实现将数据从文件读如到文本区域中 public void actionPerformed(ActionEvent e) { Object source=e.getSource(); String driver="com.mysql.cj.j