checkrecord.java~40~

银行系统中储蓄模块的实现

package chuxu;
import javax.swing.*;
import java.awt.BorderLayout;
import java.awt.Rectangle;
import java.awt.Dimension;
import java.awt.Font;
import javax.swing.border.TitledBorder;
import java.awt.event.ActionEvent;
import java.awt.Point;
import java.awt.event.ActionListener;
import java.awt.SystemColor;
import java.sql.*;
import Database.DbConnector;
import Database.SqlController;
import javax.swing.table.DefaultTableModel;
/**
 * <p>Title: </p>
 *
 * <p>Description: </p>
 *
 * <p>Copyright: Copyright (c) 2007</p>
 *
 * <p>Company: </p>
 *
 * @author not attributable
 * @version 1.0
 */
public class CheckRecord extends JFrame{

    JPanel contentPane;
    JPanel chuxumenu;
    JMenuBar jMenuBar1 = new JMenuBar();
    JMenu jMenuFile = new JMenu();
    JMenuItem jMenuFileExit = new JMenuItem();
    JMenu jMenuHelp = new JMenu();
    JMenuItem jMenuHelpAbout = new JMenuItem();
    JToolBar jToolBar = new JToolBar();
    JMenuItem jMenuItem1 = new JMenuItem();
    TitledBorder titledBorder1 = new TitledBorder("");
    JTable jTable1 = new JTable();

    DefaultTableModel dtm = new DefaultTableModel();
    JScrollPane jScrollPane1 = new JScrollPane();
    int columnCount;
    String Cnum;
    int ZHnum;
    public CheckRecord(String cnum,int zhnum) {
        this.Cnum=cnum;
        this.ZHnum=zhnum;
        try {
            jbInit();
        } catch (Exception ex) {
            ex.printStackTrace();
        }
    }

    private void jbInit() throws Exception {
        this.getContentPane().setLayout(null);
        setSize(new Dimension(500, 400));
        setTitle("SE 银行--储蓄--查询存取记录");
        contentPane = (JPanel) getContentPane();
      jMenuFileExit.setText("离开");
      jMenuFileExit.addActionListener(new CheckRecord_jMenuFileExit_ActionAdapter(this));
      jMenuHelp.setText("Help");
      jMenuHelpAbout.setText("About");
      jMenuHelpAbout.addActionListener(new CheckRecord_jMenuHelpAbout_ActionAdapter(this));
        jMenuFile.setText("选项");
      jMenuItem1.setText("注销");
        jButton1.setText("查询");
        //jButton1.addActionListener(new CheckRecord_jButton1_actionAdapter(this));
        contentPane.setLayout(null);
        jButton2.setBounds(new Rectangle(390, 302, 80, 29));
        jButton2.setText("取消");
        jButton2.addActionListener(new CheckRecord_jButton2_actionAdapter(this));
        jMenuBar1.add(jMenuFile);
      jMenuBar1.add(jMenuHelp);
      jMenuHelp.add(jMenuHelpAbout);
      setJMenuBar(jMenuBar1);
      contentPane.add(jToolBar, null);
      jScrollPane1.getViewport().add(jTable1);
        contentPane.add(jButton1);
        jMenuFile.add(jMenuItem1);
      jMenuFile.add(jMenuFileExit);

        jLabel1.setText("帐户存取记录");
        jLabel1.setBounds(new Rectangle(11, 11, 102, 33));
        this.getContentPane().add(jLabel1);
        contentPane.add(jButton2);



        DbConnector conn = DbConnector.getInstance();
        SqlController sql = new SqlController(conn.getConnection());
       //ResultSet rs=sql.SelectStmt("select 余额 from 帐户余额表 where 卡号='"+Cnum+"' and 帐户号="+ZHnum);
       ResultSet rs=sql.SelectStmt("select * from 存取记录表 where 卡号='1234' and 帐户号='1222'");
        System.out.print(Cnum);
         System.out.print(ZHnum);
        columnCount = rs.getMetaData().getColumnCount();
        for (int i = 1; i <= columnCount; i++) {
            dtm.addColumn(rs.getMetaData().getColumnName(i));
        }

        try {
            String[] s = new String[columnCount];
            while (rs.next()) {
                for (int i = 1; i <= columnCount; i++) {
                    s[i - 1] = rs.getString(i);
                }
                dtm.addRow(s);
            }
        } catch (SQLException e) {
            System.out.println("1-->" + e);
            e.printStackTrace();
        }
        jTable1.setModel(dtm);


    }
    void jMenuFileExit_actionPerformed(ActionEvent actionEvent) {
       System.exit(0);
   }

   void jMenuHelpAbout_actionPerformed(ActionEvent actionEvent) {

      Dimension frmSize = getSize();
      Point loc = getLocation();

  }

     JLabel jLabel1 = new JLabel();
     JButton jButton1 = new JButton();
     JButton jButton2 = new JButton();
     JFrame checkInf = new CheckInfor(Cnum);
     public void jButton2_actionPerformed(ActionEvent e) {
        dispose();
        checkInf.setVisible(true);

    }


}


class CheckRecord_jButton2_actionAdapter implements ActionListener {
    private CheckRecord adaptee;
    CheckRecord_jButton2_actionAdapter(CheckRecord adaptee) {
        this.adaptee = adaptee;
    }

    public void actionPerformed(ActionEvent e) {
        adaptee.jButton2_actionPerformed(e);
    }
}





class CheckRecord_jMenuFileExit_ActionAdapter implements ActionListener {
    CheckRecord adaptee;

    CheckRecord_jMenuFileExit_ActionAdapter(CheckRecord adaptee) {
        this.adaptee = adaptee;
    }

    public void actionPerformed(ActionEvent actionEvent) {
        adaptee.jMenuFileExit_actionPerformed(actionEvent);
    }
}


class CheckRecord_jMenuHelpAbout_ActionAdapter implements ActionListener {
    CheckRecord adaptee;

    CheckRecord_jMenuHelpAbout_ActionAdapter(CheckRecord adaptee) {
        this.adaptee = adaptee;
    }

    public void actionPerformed(ActionEvent actionEvent) {
        adaptee.jMenuHelpAbout_actionPerformed(actionEvent);
    }
}