showall.java

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.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{
    String strSql0="";
    String database_username="";
    String database_password="";
    userlogin u=new userlogin();
    String yy=u.s;
    ResultSet rs1 = null;
     public Showall() {
        try{
        jbInit();
    } catch (Exception ex) {
        ex.printStackTrace();
    }

     try {
             String url = "jdbc:odbc:atm";
             Class.forName("sun.jdbc.odbc.JdbcOdbcDriver");
             Connection dbConn = DriverManager.getConnection(url,database_username, database_password);
             Statement stmt = dbConn.createStatement();
            strSql0="select * from transinfo where cardid='"+yy+"'";
             rs1 =stmt.executeQuery(strSql0);
               // System.out .println(rs.getDate("transdate"));
               baobiao();
            } catch (SQLException eq) {
                JOptionPane.showMessageDialog(null, eq.getMessage(),
                                              "Database Error",
                                              JOptionPane.ERROR_MESSAGE);
                System.exit(1);
            }
            catch (Exception ee) {
                System.out.print("1出错");
            }

}
      public void baobiao(){
          for(int i=model.getRowCount()-1;i>=0;i--){
            model.removeRow(i);
                    try {
                            while(rs1.next()) {
                             v=new Vector(1,1);
                             v.add(rs1.getDate("transdate"));
                             v.add(rs1.getString("cardid"));
                             v.add(rs1.getString("transtype"));
                             v.add(rs1.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();
     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();
    }
}