ttranstype.java~3~

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 Ttranstype {
    public static int aa;
     public static String tr ;
   String strSql="";
   String database_username="";
   String database_password="";
   ResultSet rs = null;
   String url = "jdbc:odbc:atm";

    public Ttranstype() {
        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 transtype from transinfo where cardid='"+t+"' ";
       rs= stmt.executeQuery(strSql);
       while(rs.next()){
             tr=rs.getString("transtype");


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

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

    }

    public static void main(String[] args) {
        Ttranstype ttranstype = new Ttranstype();
    }
}