hujiguanli.rar_户籍_户籍管理_户籍管理系统

import java.awt.BorderLayout; import java.awt.EventQueue; import java.awt.event.ActionEvent; import java.awt.event.ActionListener; import java.sql.Connection; import java.sql.DriverManager; import java.sql.ResultSet; import java.sql.SQLException; import java.sql.Statement; import javax.swing.JFrame; import javax.swing.JPanel; import javax.swing.border.EmptyBorder; import javax.swing.JLabel; import javax.swing.JScrollPane; import javax.swing.JTable; import javax.swing.JTextField; import javax.swing.JButton; public class XGgeren extends JFrame { private JPanel contentPane; private JTextField textField; /** * Launch the application. */ String c,d,e1,f,g,h,i,j,k,l,m,n,o,p,q; String[] a=new String[15]; JTable table; private JTextField textField_1; private JTextField textField_2; private JTextField textField_3; private JTextField textField_4; private JTextField textField_5; private JTextField textField_6; private JTextField textField_7; private JTextField textField_8; private JTextField textField_9; private JTextField textField_10; private JTextField textField_11; private JTextField textField_12; private JTextField textField_13; private JTextField textField_14; private JTextField textField_15; public XGgeren() { setDefaultCloseOperation(JFrame.EXIT_ON_CLOSE); setBounds(40, 100, 952, 498); contentPane = new JPanel(); contentPane.setBorder(new EmptyBorder(5, 5, 5, 5)); setContentPane(contentPane); contentPane.setLayout(null); JLabel label = new JLabel("\u8F93\u5165\u8EAB\u4EFD\u8BC1\u53F7"); label.setBounds(76, 10, 117, 23); contentPane.add(label); textField = new JTextField(); textField.setBounds(203, 11, 395, 21); contentPane.add(textField); textField.setColumns(10); JLabel label_1 = new JLabel("\u59D3\u540D"); label_1.setBounds(76, 290, 54, 15); contentPane.add(label_1); JLabel label_2 = new JLabel("\u6027\u522B"); label_2.setBounds(76, 324, 54, 15); contentPane.add(label_2); JLabel label_3 = new JLabel("\u8EAB\u4EFD\u8BC1\u53F7"); label_3.setBounds(76, 356, 54, 15); contentPane.add(label_3); JLabel label_4 = new JLabel("\u6C11\u65CF"); label_4.setBounds(76, 394, 54, 15); contentPane.add(label_4); JLabel label_5 = new JLabel("\u51FA\u751F\u65E5\u671F"); label_5.setBounds(76, 426, 54, 15); contentPane.add(label_5); JLabel label_6 = new JLabel("\u6237\u4E3B\u5173\u7CFB"); label_6.setBounds(342, 290, 54, 15); contentPane.add(label_6); JLabel label_7 = new JLabel("\u7C4D\u8D2F"); label_7.setBounds(342, 324, 54, 15); contentPane.add(label_7); JLabel label_8 = new JLabel("\u8EAB\u9AD8"); label_8.setBounds(342, 356, 54, 15); contentPane.add(label_8); JLabel label_9 = new JLabel("\u8840\u578B"); label_9.setBounds(342, 394, 54, 15); contentPane.add(label_9); JLabel label_10 = new JLabel("\u6587\u5316\u7A0B\u5EA6"); label_10.setBounds(342, 426, 54, 15); contentPane.add(label_10); JLabel label_11 = new JLabel("\u5A5A\u59FB\u72B6\u51B5"); label_11.setBounds(603, 290, 54, 15); contentPane.add(label_11); JLabel label_12 = new JLabel("\u5175\u5F79\u72B6\u51B5"); label_12.setBounds(603, 324, 54, 15); contentPane.add(label_12); JLabel label_13 = new JLabel("\u804C\u4E1A"); label_13.setBounds(603, 356, 54, 15); contentPane.add(label_13); JLabel label_14 = new JLabel("\u5B97\u6559\u4FE1\u4EF0"); label_14.setBounds(603, 394, 54, 15); contentPane.add(label_14); textField_1 = new JTextField(); textField_1.setBounds(162, 287, 123, 21); contentPane.add(textField_1); textField_1.setColumns(10); textField_2 = new JTextField(); textField_2.setBounds(162, 321, 117, 21); contentPane.add(textField_2); textField_2.setColumns(10); textField_3 = new JTextField(); textField_3.setBounds(162, 353, 123, 21); contentPane.add(textField_3); textField_3.setColumns(10); textField_4 = new JTextField(); textField_4.setBounds(159, 391, 126, 21); contentPane.add(textField_4); textField_4.setColumns(10); textField_5 = new JTextField(); textField_5.setBounds(162, 423, 123, 21); contentPane.add(textField_5); textField_5.setColumns(10); textField_6 = new JTextField(); textField_6.setBounds(406, 287, 117, 21); contentPane.add(textField_6); textField_6.setColumns(10); textField_7 = new JTextField(); textField_7.setBounds(406, 321, 117, 21); contentPane.add(textField_7); textField_7.setColumns(10); textField_8 = new JTextField(); textField_8.setBounds(404, 353, 119, 21); contentPane.add(textField_8); textField_8.setColumns(10); textField_9 = new JTextField(); textField_9.setBounds(406, 391, 117, 21); contentPane.add(textField_9); textField_9.setColumns(10); textField_10 = new JTextField(); textField_10.setBounds(406, 420, 117, 21); contentPane.add(textField_10); textField_10.setColumns(10); textField_11 = new JTextField(); textField_11.setBounds(667, 287, 100, 21); contentPane.add(textField_11); textField_11.setColumns(10); textField_12 = new JTextField(); textField_12.setBounds(667, 321, 100, 21); contentPane.add(textField_12); textField_12.setColumns(10); textField_13 = new JTextField(); textField_13.setBounds(671, 353, 96, 21); contentPane.add(textField_13); textField_13.setColumns(10); textField_14 = new JTextField(); textField_14.setBounds(667, 391, 100, 21); contentPane.add(textField_14); textField_14.setColumns(10); JButton button_2 = new JButton("\u4FEE\u6539");//修改按钮 button_2.addActionListener(new ActionListener() { public void actionPerformed(final ActionEvent e) { String sql1=null; String sql2=null; String sql3=null; String sql4=null; String sql5=null; String sql6=null; String sql7=null; String sql8=null; String sql9=null; String sql10=null; String sql11=null; String sql12=null; String sql13=null; String sql14=null; String sql15=null; //System.out.print(c); if(e.getActionCommand().equals("修改")) { a[0]=textField_1.getText().trim(); a[1]=textField_2.getText().trim(); a[2]=textField_3.getText().trim(); a[3]=textField_4.getText().trim(); a[4]=textField_5.getText().trim(); a[5]=textField_6.getText().trim(); a[6]=textField_7.getText().trim(); a[7]=textField_8.getText().trim(); a[8]=textField_9.getText().trim(); a[9]=textField_10.getText().trim(); a[10]=textField_11.getText().trim(); a[11]=textField_12.getText().trim(); a[12]=textField_13.getText().trim(); a[13]=textField_14.getText().trim(); a[14]=textField_15.getText().trim(); c=(String) table.getValueAt(1, 0); d=(String) table.getValueAt(1, 1); e1=(String) table.getValueAt(1, 2); f=(String) table.getValueAt(1, 3); g=(String) table.getValueAt(1, 4); h=(String) table.getValueAt(1, 5); i=(String) table.getValueAt(1, 6); j=(String) table.getValueAt(1, 7); k=(String) table.getValueAt(1, 8); l=(String) table.getValueAt(1, 9); m=(String) table.getValueAt(1, 10); n=(String) table.getValueAt(1, 11); o=(String) table.getValueAt(1, 12); p=(String) table.getValueAt(1, 13); q=(String) table.getValueAt(1, 14); sql1="update geren set 姓名='"+a[0]+"' where 姓名='"+c+"'" ; sql2="update geren set 性别='"+a[1]+"' where 性别='"+d+"'" ; sql3="update geren set 身份证号='"+a[2]+"' where 身份证号='"+e1+"'" ; sql4="update geren set 民族='"+a[3]+"' where 民族='"+f+"'" ;