showall.java~95~

ATM机具有存款、取款、查询结余、打印凭条、修改密码功能。

package atm;
import javax.swing.*;
import java.awt.*;
import com.borland.jbcl.layout.*;
import java.awt.event.ActionEvent;
import java.awt.event.ActionListener;
import java.awt.Font;
import java.awt.BorderLayout;
import java.awt.Dimension;
import java.sql.DriverManager;
import java.sql.Statement;
import java.sql.Connection;
import java.sql.ResultSet;
import com.borland.dbswing.JdbLabel;
import com.borland.dbswing.JdbTable;
import java.sql.*;
import java.util.Vector;
import javax.swing.table.DefaultTableModel;

/**
 * <p>Title: </p>
 *
 * <p>Description: </p>
 *
 * <p>Copyright: Copyright (c) 2008</p>
 *
 * <p>Company: </p>
 *
 * @author not attributable
 * @version 1.0
 */
public class Showall extends JFrame{
    public Showall() {
        super();
        try {
            jbInit();
        } catch (Exception ex) {
            ex.printStackTrace();
        }
        userlogin u=new userlogin();
         String yy=u.s;
         jdbconn o = new jdbconn();
         String strSql="select * from transinfo where cardid='"+yy+"'";
         try {
                rs = o.state.executeQuery(strSql);

            } catch (SQLException eq) {
                JOptionPane.showMessageDialog(null, eq.getMessage(),
                                              "Database Error",
                                              JOptionPane.ERROR_MESSAGE);
                System.exit(1);
            }

            catch (Exception ee) {
                System.out.print("1出错");
            }
   for(int i = model.getRowCount() - 1; i >= 0; i-- ){
             model.removeRow(i);
                     try {
                             while (rs.next()) {
              v = new Vector(1,1);
                              v.add(rs.getDate("transdate"));
                              v.add(rs.getString("cardid"));
                              v.add(rs.getString("transtype"));
                              v.add(rs.getInt("transmoney"));
                              model.addRow(v);
                          }
          }catch(Exception e){
                         System.out.print(e+"123456");
                     }
          }
}

    public static void main(String[] args) {
        Showall showall = new Showall();
    }
  private void jbInit() throws Exception {

        jLabel1.setFont(new java.awt.Font("宋体", Font.PLAIN, 20));
        jLabel1.setText("您操作的历史记录如下：");
        jButton1.setText("jButton1");

        this.getContentPane().setLayout(xYLayout1);
        jScrollPane1.getViewport().setBackground(Color.white);
        jTable1.setBackground(Color.lightGray);
        this.getContentPane().add(jLabel1, new XYConstraints(0, 1, 398, 25));
        jButton2.setText("jButton2");
        this.getContentPane().add(jButton1, new XYConstraints(61, 419, 98, 25));
        this.getContentPane().add(jButton2, new XYConstraints(263, 421, -1, -1));
        this.getContentPane().add(jScrollPane1,
                                  new XYConstraints(19, 23, 370, 367));
        jScrollPane1.getViewport().add(jTable1);
        setSize(430,500);
        setVisible(true);
        model.addColumn("交易时间");
        model.addColumn("卡号");
        model.addColumn("交易类型");
        model.addColumn("交易金额");

    }
     Vector v=new  Vector(1,1);
     DefaultTableModel model=new DefaultTableModel();
     ResultSet rs;
     JLabel jLabel1 = new JLabel();
     JScrollPane jScrollPane1 = new JScrollPane();
     JButton jButton1 = new JButton();
     XYLayout xYLayout1 = new XYLayout();
     JButton jButton2 = new JButton();
     JTable jTable1 = new JTable(model);



    public void jButton2_actionPerformed(ActionEvent e) {
           setVisible(false);
           Function f=new Function();
    }
}