Java Swing项目：ATM银行系统后端.zip

package com.view; import java.awt.EventQueue; import java.awt.FileDialog; import java.awt.HeadlessException; import java.sql.Connection; import java.sql.ResultSet; import java.util.Vector; import javax.swing.JFrame; import javax.swing.JPanel; import javax.swing.JScrollPane; import javax.swing.JTable; import javax.swing.WindowConstants; import javax.swing.border.EmptyBorder; import javax.swing.table.DefaultTableModel; import com.dao.CardDao; import com.model.Card; import com.sun.org.glassfish.gmbal.ManagedData; import com.model.Admin; import com.util.DbUtil; import com.util.ExcelExporter; import com.util.StringUtil; import java.awt.Font; import javax.swing.border.TitledBorder; import javax.swing.JLabel; import javax.swing.JOptionPane; import javax.swing.JTextField; import javax.swing.JButton; import javax.swing.ImageIcon; import java.awt.event.ActionListener; import java.awt.event.ActionEvent; import javax.swing.JRadioButton; import javax.imageio.ImageIO; import javax.swing.ButtonGroup; import java.awt.event.MouseAdapter; import java.awt.event.MouseEvent; import java.io.*; public class MainFrm extends JFrame { private JPanel contentPane; private JTable CardTable; private JRadioButton manJrb; private JRadioButton womanJrb; private JRadioButton manAddJrb; private JRadioButton womanAddJrb; private DbUtil dbUtil = new DbUtil(); private CardDao cardDao = new CardDao(); private JTextField accountTxt; private JTextField nameTxt; private JTextField IDCardTxt; private JTextField accountTxt_1; private JTextField passwordTxt; private JTextField idCardTxt; private JTextField nameTxt_1; private JTextField ageTxt; private JTextField balanceTxt; private final ButtonGroup buttonGroup = new ButtonGroup(); private JTextField accountAddTxt; private JTextField passwordAddTxt; private JTextField idCardAddTxt; private JTextField nameAddTxt; private JTextField ageAddTxt; private JTextField balanceAddTxt; private final ButtonGroup buttonGroup_1 = new ButtonGroup(); /** * Launch the application. */ public static void main(String[] args) { EventQueue.invokeLater(new Runnable() { public void run() { try { MainFrm frame = new MainFrm(new Admin()); frame.setVisible(true); } catch (Exception e) { e.printStackTrace(); } } }); } /** * Create the frame. */ public MainFrm(Admin admin) { setResizable(false); setTitle("用户信息管理"); setDefaultCloseOperation(JFrame.DISPOSE_ON_CLOSE); //关闭并销毁 而不是退出 setBounds(100, 100, 690, 654); contentPane = new JPanel(); contentPane.setBorder(new EmptyBorder(5, 5, 5, 5)); setContentPane(contentPane); contentPane.setLayout(null); JScrollPane scrollPane = new JScrollPane(); scrollPane.setBounds(10, 64, 664, 150); contentPane.add(scrollPane); CardTable = new JTable(); CardTable.addMouseListener(new MouseAdapter() { @Override public void mousePressed(MouseEvent met) { CardTableMousePressed(met); } }); CardTable.setFont(new Font("微软雅黑", Font.PLAIN, 16)); CardTable.setModel(new DefaultTableModel( new Object[][] { }, new String[] { "账号", "密码", "姓名", "性别", "年龄", "身份证号", "余额" } ) { boolean[] columnEditables = new boolean[] { false, false, false, false, false, false, false }; public boolean isCellEditable(int row, int column) { return columnEditables[column]; } }); CardTable.getColumnModel().getColumn(2).setPreferredWidth(64); CardTable.getColumnModel().getColumn(3).setPreferredWidth(49); CardTable.getColumnModel().getColumn(4).setPreferredWidth(50); CardTable.getColumnModel().getColumn(5).setPreferredWidth(91); CardTable.getColumnModel().getColumn(6).setPreferredWidth(90); scrollPane.setViewportView(CardTable); JPanel panel = new JPanel(); panel.setBorder(new TitledBorder(null, "搜索条件", TitledBorder.LEADING, TitledBorder.TOP, null, null)); panel.setBounds(10, 10, 664, 52); contentPane.add(panel); panel.setLayout(null); JLabel lblNewLabel = new JLabel("账号："); lblNewLabel.setFont(new Font("微软雅黑", Font.PLAIN, 16)); lblNewLabel.setBounds(18, 23, 51, 15); panel.add(lblNewLabel); accountTxt = new JTextField(); accountTxt.setBounds(63, 20, 108, 21); panel.add(accountTxt); accountTxt.setColumns(10); JLabel label = new JLabel("姓名："); label.setFont(new Font("微软雅黑", Font.PLAIN, 16)); label.setBounds(191, 23, 51, 15); panel.add(label); nameTxt = new JTextField(); nameTxt.setColumns(10); nameTxt.setBounds(233, 20, 72, 21); panel.add(nameTxt); JButton btnNewButton = new JButton("查询"); btnNewButton.addActionListener(new ActionListener() { public void actionPerformed(ActionEvent e) { cardSearchActionPerformed(e); } }); btnNewButton.setFont(new Font("微软雅黑", Font.PLAIN, 16)); btnNewButton.setIcon(new ImageIcon(MainFrm.class.getResource("/images/查询.png"))); btnNewButton.setBounds(536, 10, 118, 33); panel.add(btnNewButton); JLabel label_1 = new JLabel("身份证号："); label_1.setFont(new Font("微软雅黑", Font.PLAIN, 16)); label_1.setBounds(326, 23, 80, 15); panel.add(label_1); IDCardTxt = new JTextField(); IDCardTxt.setColumns(10); IDCardTxt.setBounds(403, 21, 123, 21); panel.add(IDCardTxt); JPanel panel_1 = new JPanel(); panel_1.setBorder(new TitledBorder(null, "表单操作", TitledBorder.LEADING, TitledBorder.TOP, null, null)); panel_1.setBounds(10, 256, 664, 150); contentPane.add(panel_1); panel_1.setLayout(null); JLabel label_2 = new JLabel("账号："); label_2.setFont(new Font("微软雅黑", Font.PLAIN, 15)); label_2.setBounds(28, 28, 54, 15); panel_1.add(label_2); accountTxt_1 = new JTextField(); accountTxt_1.setEditable(false); accountTxt_1.setBounds(68, 25, 100, 21); panel_1.add(accountTxt_1); accountTxt_1.setColumns(10); JLabel label_3 = new JLabel("密码："); label_3.setFont(new Font("微软雅黑", Font.PLAIN, 15)); label_3.setBounds(196, 28, 54, 15); panel_1.add(label_3); passwordTxt = new JTextField(); passwordTxt.setBounds(236, 25, 100, 21); panel_1.add(passwordTxt); passwordTxt.setColumns(10); JLabel label_4 = new JLabel("身份证号："); label_4.setFont(new Font("微软雅黑", Font.PLAIN, 15)); label_4.setBounds(362, 28, 75, 15); panel_1.add(label_4); idCardTxt = new JTextField(); idCardTxt.setBounds(431, 25, 223, 21); panel_1.add(idCardTxt); idCardTxt.setColumns(10); JLabel label_5 = new JLabel("姓名："); label_5.setFont(new Font("微软雅黑", Font.PLAIN, 15)); label_5.setBounds(28, 70, 45, 15); panel_1.add(label_5); nameTxt_1 = new JTextField(); nameTxt_1.setColumns(10); nameTxt_1.setBounds(68, 67, 100, 21); panel_1.add(nameTxt_1); JLabel label_6 = new JLabel("性别："); label_6.setFont(new Font("微软雅黑", Font.PLAIN, 15)); label_6.setBounds(196, 70, 45, 15); panel_1.add(label_6); JLabel label_7 = new JLabel("年龄："); label_7.setFont(new Font("微软雅黑", Font.PLAIN, 15)); label_7.setBounds(363, 70, 45, 15); panel_1.add(label_7); ageTxt = new JTextField(); ageTxt.setColumns(10); ageTxt.setBounds(402, 67, 100, 21); panel_1.add(ageTxt); JLabel lblNewLabel_1 = new JLabel("余额："); lblNewLabel_1.setFont(new Font("微软雅黑", Font.PLAIN, 15)); lblNewLabel_1.setBounds(28, 112, 45, 15); panel_1.add(lblNewLabel_1); balanceTxt = new JTextField(); balanceTxt.setColumns(10); balanceTxt.setBounds(68, 109, 100, 21); panel_1.add(balanceTxt); manJrb = new JRadioButton("男"); buttonGroup.add(manJrb); manJrb.setSelected(true); manJrb.setFont(new Font("微软雅黑", Font.PLAIN, 15)); manJrb.setBounds(238, 65, 40, 23); panel_1.add(manJrb);