tupdate.java~8~

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 up;
    public static int a3;
    public Statement stmt;
    public Connection dbConn;
    public static String tr ;
    Ttranstype t2=new Ttranstype();
         String tr1=t2.tr;
    Tbalance t1=new Tbalance();
         int a2=t1.aa;
    Fecth f=new Fecth();
         String fe=f.d;
    userlogin uu = new userlogin();
         String t = uu.s;

   String strSql="";
   String database_username="";
   String database_password="";
   ResultSet rs = null;
   String url = "jdbc:odbc:atm";


    public Tupdate() {
        super();

    }
     public void initislize(){

         try {

             Class.forName("sun.jdbc.odbc.JdbcOdbcDriver");
             dbConn = DriverManager.getConnection(url,
                     database_username, database_password);
             stmt = dbConn.createStatement();

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


     }
     public void terminnate(){
         try{
                    rs.close();
                    stmt.close();
                    dbConn.close();

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

     }
     public void DisplaySelect(){
         strSql = "select transtype from transinfo where cardid='"+t+"'";
         rs = stmt.executeQuery(strSql);
         while (rs.next()) {
             tr = rs.getString("transtype");
         }
     }
     public void updateBalance(){

              String er=(new java.util.Date()).toLocaleString();
              while(rs.next()){
               if(t2.equals("tr")){
             strSql="update cardinfo set balance='"+a3+"where cardid='"+t+"'";
           int a1=Integer.parseInt(rs.getString("balance"));
            a3=a1-a2;
          int x = stmt.executeUpdate(strSql);
               }
              }

    }

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

    }
}