xiaohu.java

ATM系统分为前台和后台

package atm;

import javax.swing.SwingUtilities;
import java.awt.BorderLayout;

import javax.swing.JOptionPane;
import javax.swing.JPanel;
import javax.swing.JFrame;
import java.awt.GridBagLayout;
import javax.swing.JButton;
import java.awt.GridBagConstraints;
import java.sql.ResultSet;
import java.sql.SQLException;

import javax.swing.JScrollPane;
import javax.swing.JTable;
import java.sql.*;
import oo.Sql;
//import java.awt.Dimension;

public class Xiaohu extends JFrame {

	private static final long serialVersionUID = 1L;

	private JPanel jContentPane = null;

	private JPanel jPanel = null;

	private JButton jButton = null;

	private JScrollPane jScrollPane = null;

	private JTable jTable = null;

	private JButton jButton1 = null;

	/**
	 * This method initializes jPanel	
	 * 	
	 * @return javax.swing.JPanel	
	 */
	private JPanel getJPanel() {
		if (jPanel == null) {
			GridBagConstraints gridBagConstraints1 = new GridBagConstraints();
			gridBagConstraints1.gridx = 2;
			GridBagConstraints gridBagConstraints = new GridBagConstraints();
			gridBagConstraints.gridx = 1;
			gridBagConstraints.gridy = 0;
			jPanel = new JPanel();
			jPanel.setLayout(new GridBagLayout());
			jPanel.add(getJButton(), new GridBagConstraints());
			jPanel.add(getJButton1(), gridBagConstraints1);
			jPanel.add(getJButton2(), gridBagConstraints);
		}
		return jPanel;
	}

	/**
	 * This method initializes jButton	
	 * 	
	 * @return javax.swing.JButton	
	 */
	private JButton getJButton() {
		if (jButton == null) {
			jButton = new JButton();
			jButton.setText("销户");
			jButton.addActionListener(new java.awt.event.ActionListener() {
				public void actionPerformed(java.awt.event.ActionEvent e) {
					System.out.println("actionPerformed()"); // TODO Auto-generated Event stub actionPerformed()
					del();
				}
			});
		}
		return jButton;
	}

	/**
	 * This method initializes jScrollPane	
	 * 	
	 * @return javax.swing.JScrollPane	
	 */
	private JScrollPane getJScrollPane() {
		if (jScrollPane == null) {
			jScrollPane = new JScrollPane();
			jScrollPane.setViewportView(getJTable());
		}
		return jScrollPane;
	}

	/**
	 * This method initializes jTable	
	 * 	
	 * @return javax.swing.JTable	
	 */
	private JTable getJTable() {
		if (jTable == null) {
			jTable = new JTable();
		}
		return jTable;
	}
	Sql db=new Sql();
	Connection con;

	private JButton jButton2 = null;
	
	public void showTable(){
		con=db.getConn();
		int count=0;
		ResultSet rs=db.executeQuery("select * from cardInfo");
		try{
			while(rs.next()){
				count++;
			}
			rs.close();
			Object[][] cells=new Object[count][9];
			int i=0;
			rs=db.executeQuery("select * from cardInfo");
			while(rs.next()){
				cells[i]=new Object[]{rs.getString(1),rs.getString(2),
						rs.getString(3),rs.getString(4),
						rs.getString(5),rs.getString(6),
						rs.getString(7),rs.getString(8),rs.getString(9)
				};
				i++;
			}
			String[] colnames={"卡号","货币类型","存款类型","开户日期","开户金额","余额","密码","是否挂失","顾客编号"};
			jTable=new JTable(cells,colnames);
			jScrollPane.setViewportView(jTable);
		}catch(SQLException ex){
			javax.swing.JOptionPane.showMessageDialog(null, ex.getMessage().toString());
		}
	}
	public void del(){
		Sql dbc = new Sql();
		dbc.getConn();
        int row = jTable.getSelectedRow();
        System.out.println(row);
        if (row < 0) {
            javax.swing.JOptionPane.showMessageDialog(null, "您还没有选中要删除的信息!");
            return;
        }
        Object value = jTable.getValueAt(row, 0);
        String id = value.toString();
        System.out.println(id);
        int returnValue;
	    returnValue = JOptionPane.showConfirmDialog(this, "确实要删除该记录吗？", "确认删除", JOptionPane.YES_NO_OPTION);
	    if (returnValue == JOptionPane.YES_OPTION){

        if (dbc.executeUpdateSQL("DELETE FROM cardInfo WHERE cardID ='" + id+"'")) {
            javax.swing.JOptionPane.showMessageDialog( this,"卡号为" + id + "的顾客信息已成功被删除！请刷新！");
        } else {
            javax.swing.JOptionPane.showMessageDialog(this, "删除失败！请再试。");
        }
	    }else
	    	return ;
	}
	/**
	 * This method initializes jButton1	
	 * 	
	 * @return javax.swing.JButton	
	 */
	private JButton getJButton1() {
		if (jButton1 == null) {
			jButton1 = new JButton();
			jButton1.setText("返回");
			jButton1.addActionListener(new java.awt.event.ActionListener() {
				public void actionPerformed(java.awt.event.ActionEvent e) {
					System.out.println("actionPerformed()"); // TODO Auto-generated Event stub actionPerformed()
					
						close();
					
				}
			});
		}
		return jButton1;
	}
public void close(){
	this.setVisible(false);
}
	/**
 * This method initializes jButton2	
 * 	
 * @return javax.swing.JButton	
 */
private JButton getJButton2() {
	if (jButton2 == null) {
		jButton2 = new JButton();
		jButton2.setText("刷新");
		jButton2.addActionListener(new java.awt.event.ActionListener() {
			public void actionPerformed(java.awt.event.ActionEvent e) {
				System.out.println("actionPerformed()"); // TODO Auto-generated Event stub actionPerformed()
				initialize1();
			}
		});
	}
	return jButton2;
}

	/**
	 * @param args
	 */
	//static Xiaohu thisClass;
	public static void main(String[] args) {
		// TODO 自动生成方法存根
		SwingUtilities.invokeLater(new Runnable() {
			public void run() {
				Xiaohu thisClass = new Xiaohu();
				thisClass.setDefaultCloseOperation(JFrame.EXIT_ON_CLOSE);
				thisClass.setVisible(true);
			}
		});
	}

	/**
	 * This is the default constructor
	 */
	public Xiaohu() {
		super();
		initialize();
	}

	/**
	 * This method initializes this
	 * 
	 * @return void
	 */
	private void initialize() {
		this.setSize(450, 281);
		this.setContentPane(getJContentPane());
		this.setTitle("销户");
		this.showTable();
	}
	private void initialize1() {
		this.setSize(300, 200);
		this.setContentPane(getJContentPane());
		this.setTitle("销户");
		this.showTable();
	}
	/**
	 * This method initializes jContentPane
	 * 
	 * @return javax.swing.JPanel
	 */
	private JPanel getJContentPane() {
		if (jContentPane == null) {
			jContentPane = new JPanel();
			jContentPane.setLayout(new BorderLayout());
			jContentPane.add(getJPanel(), BorderLayout.SOUTH);
			jContentPane.add(getJScrollPane(), BorderLayout.CENTER);
		}
		return jContentPane;
	}

}  //  @jve:decl-index=0:visual-constraint="10,10"