ttranstype.java~8~

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 java.util.*;

/**
 * <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{
        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 money from atmMoney where id=1";
        rs= stmt.executeQuery(strSql);
        int  m=Integer.parseInt(rs.getString("money"));
         while(rs.next()){
            System.out.println("成功！！！");
         }

        rs.close();
        stmt.close();
        dbConn.close();
       }catch(Exception ex){
           ex.getMessage();
       }


    }

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