tupdate.java~2~

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

package atm;

import java.sql.DriverManager;
import java.sql.Statement;
import java.sql.Connection;
import java.sql.ResultSet;

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


    public Tupdate() {
        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"));
                System.out.println(aa);

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

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

    public static void main(String[] args) {
        Tupdate tupdate = new Tupdate();

}
}