tongxunlu.zip_有数据库的通讯录

package tongxunlu; import java.awt.Frame; import java.awt.event.ActionEvent; import java.awt.event.ActionListener; import java.sql.*; import javax.swing.JButton; import javax.swing.JComboBox; import javax.swing.JDialog; import javax.swing.JLabel; import javax.swing.JOptionPane; import javax.swing.JPanel; import javax.swing.JTextField; public class addPerson extends JDialog implements ActionListener { JPanel p1 ,p2; JLabel name,gender,age,dbo,phone,email,qq,adress; JTextField t_name,t_age,t_dbo,t_phone,t_email,t_qq,t_adress; JButton sure,cancel; JComboBox t_gender; JLabel l_dbo,l_email; public addPerson(Frame s,String c,Boolean m){ super(s,c,m); name=new JLabel("姓名"); name.setBounds(40,50,60,40); gender=new JLabel("性别"); gender.setBounds(40,100,60,40); age=new JLabel("年龄"); age.setBounds(40,150,60,40); dbo=new JLabel("生日"); dbo.setBounds(40,200,60,40); phone=new JLabel("手机"); phone.setBounds(40,250,60,40); email=new JLabel("Email"); email.setBounds(40,300,60,40); qq=new JLabel("QQ"); qq.setBounds(40,350,60,40); adress=new JLabel("地址"); adress.setBounds(40,400,60,40); t_name=new JTextField(); t_name.setBounds(100,55,100,25); String[] Gender={"男","女"}; t_gender=new JComboBox(Gender); t_gender.setBounds(100,105,100,25); t_age=new JTextField(); t_age.setBounds(100,155,100,25); t_dbo=new JTextField(); t_dbo.setBounds(100,205,100,25); l_dbo = new JLabel("样例：1995-09-25"); l_dbo.setBounds(100,228,125,25); t_phone=new JTextField(); t_phone.setBounds(100,255,100,25); t_email=new JTextField(); t_email.setBounds(100,305,100,25); l_email=new JLabel("样例:1356@qq.com"); l_email.setBounds(100,328,150,25); t_qq=new JTextField(); t_qq.setBounds(100,355,100,25); t_adress=new JTextField(); t_adress.setBounds(100,405,100,25); sure=new JButton("确定"); sure.addActionListener(this); sure.setBounds(55,450,60,30); cancel=new JButton("取消"); cancel.setBounds(135,450, 60,30); cancel.addActionListener(this); this.add(name); this.add(gender); this.add(age); this.add(dbo); this.add(phone); this.add(email); this.add(qq); this.add(adress); this.add(t_name); this.add(t_gender); this.add(t_age); this.add(t_dbo); this.add(t_phone); this.add(t_email); this.add(t_qq); this.add(t_adress); this.add(l_dbo); this.add(l_email); this.add(sure); this.add(cancel); this.setTitle(c); this.setSize(270,600); this.setLayout(null); this.setVisible(true); this.setLocation(500,300); this.setDefaultCloseOperation(DISPOSE_ON_CLOSE); } @Override public void actionPerformed(ActionEvent e) { String button=e.getActionCommand(); if(button.equals("取消")){ this.dispose(); } else if(button.equals("确定")) { PreparedStatement ps=null; Connection ct=null; ResultSet rs=null; try{ Class.forName("com.mysql.jdbc.Driver"); String url = "jdbc:mysql://localhost:3306/tongxun"; Statement stmt = ct.createStatement() ; ct = DriverManager.getConnection(url,"root","123456"); rs=stmt.executeQuery("insert into shujuku values(?,?,?,?,?,?,?,?)"); ps.setString(1,t_name.getText()); ps.setString(2,t_gender.getSelectedItem().toString()); ps.setString(3,t_age.getText()); ps.setString(4,t_dbo.getText()); ps.setString(5,t_phone.getText()); ps.setString(6,t_email.getText()); ps.setString(7,t_qq.getText()); ps.setString(8,t_adress.getText()); ps.executeUpdate(); this.dispose(); }catch(Exception e1){ System.out.println("ERROR:"+e1); }catch(Exception e2Exception){ JOptionPane.showMessageDialog(this,"信息输入的格式有误！"); } finally{ try{ if(rs!=null){ rs.close(); } if(ps!=null){ ps.close(); } if(ct!=null){ ct.close(); } } catch(Exception e2){ } } } } }