showall.java~92~

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{
    String strSql="";
    String database_username="";
    String database_password="";


    public Showall() {
        super();
        try {
            jbInit();
           // dbshow();
        } catch (Exception ex) {
            ex.printStackTrace();
        }
    }

    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("交易金额");
        dbshow();
    }
     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 dbshow(){
         userlogin u=new userlogin();
         u.setVisible(false);
         String yy=u.s;
         try{
          String url = "jdbc:odbc:atm";
          Class.forName("sun.jdbc.odbc.JdbcOdbcDriver");
          ResultSet rs = null;
          Connection dbConn = DriverManager.getConnection(url,database_username, database_password);
          Statement stmt = dbConn.createStatement();
          strSql="select * from transinfo where cardid='"+yy+"'";
          rs=stmt.executeQuery(strSql);

          while (rs.next()) {

                  System.out.println(rs.getString(4));
              }


              rs.close();
              stmt.close();
              dbConn.close();

       }catch(Exception ex){
           ex.getMessage();
       }

 /**        for(int i = model.getRowCount() - 1; i >= 0; i-- ){
              model.removeRow(i);
                      try {
                           //  System.out.println("1234567");

                             while (rs.next()) {

                         //  System.out.println(rs.getDate(1));
                         //  System.out.println(rs.getString(2));
                         //  System.out.println(rs.getInt(4));
                         //  System.out.println(rs.getString("transtype"));
                               //System.out.print("123456");
                             //  rs.beforeFirst();
                               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 void jButton2_actionPerformed(ActionEvent e) {
           setVisible(false);
           Function f=new Function();
    }
}