tbalance.java

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

package atm;
import java.sql.*;
import javax.swing.JOptionPane;
/**
 * <p>Title: </p>
 *
 * <p>Description: </p>
 *
 * <p>Copyright: Copyright (c) 2008</p>
 *
 * <p>Company: </p>
 *
 * @author not attributable
 * @version 1.0
 */
public class Tbalance {
    public static int aa;
    String strSql="";
    String database_username="";
    String database_password="";
    ResultSet rs = null;
    String url = "jdbc:odbc:atm";

    public Tbalance() {
        super();
        try {
        userlogin uu=new userlogin();
        String t=uu.s;
        Class.forName("sun.jdbc.odbc.JdbcOdbcDriver");
        Connection dbConn = DriverManager.getConnection(url,
        database_username, database_password);
        Statement stmt = dbConn.createStatement();

        strSql = "select balance from cardinfo where cardid=1 ";
        rs= stmt.executeQuery(strSql);
        while(rs.next()){
              aa=Integer.parseInt(rs.getString("balance"));


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

     }catch(Exception ee){
         System.out.println(ee.getMessage());
     }



    }

    public static void main(String[] args) {
        Tbalance tbalance = new Tbalance();
    }

   }