ATM银行取款机（可连接数据库）.doc

ATM银行取款机模拟程序(可连接数据库) import javax.swing.*; import java.awt.*; import java.awt.event.*; import javax.swing.event.*; import java.sql.*; import .URL; public class DBAccess extends JFrame implements ActionListener { //JDBC驱动器名称（JDBC-ODBC桥） private String strDBDriver = sun.jdbc.odbc.JdbcOdbcDriver; //数据库的URL地址 private String strUrl = jdbc:odbc:atm1; //指定要访问的数据库名称 private String strDBName = atm1; //数据库用户名称 private String strUserName = testUser; //数据库用户密码 private String strPassWord = 12345; //数据库连接对象，初始化为空 private Connection conTemp = null; //连接的容器对象，初始化为空 private Statement stmtTemp = null; //结果集对象，初始化为空 private ResultSet rsTemp = null; //操作记录行数 private int intOperateNum = 0; public static void main(String[] args) { DBAccess d=new DBAccess(); d.setSize(400,300); d.setLocation(300,200); d.setTitle(欢迎光临杰宇阁银行); d.setDefaultCloseOperation(JFrame.EXIT_ON_CLOSE); d.show(); // f.show(); } /**----------------------------------------- * 功能概述：构造方法，加载指定缺省的驱动程序 -------------------------------------------*/ public DBAccess(){ try{ Class.forName(strDBDriver); } catch(Exception e){ e.printStackTrace(); } showCardLayout(); }//DBAccess() /**----------------------------------------- * 功能概述：和数据库建立连接 -------------------------------------------*/ public boolean createConnection(){ boolean blConnect = false; try{ conTemp = DriverManager.getConnection(strUrl,strUserName,strPassWord); conTemp.setCatalog(strDBName); conTemp.setAutoCommit( false ); blConnect = true; } catch(Exception e){ e.printStackTrace(); } return blConnect; }//createConnection() /**----------------------------------------- * 功能概述：获得查询结果集 -------------------------------------------*/ public ResultSet executeQuery(String strSQL){ try{ if(conTemp==null){ createConnection(); } stmtTemp = conTemp.createStatement(); rsTemp = stmtTemp.executeQuery(strSQL); return rsTemp; } catch(Exception e){ e.printStackTrace(); return null; } }//executeQuery() /**----------------------------------------- * 功能概述：对数据库执行更新、插入操作 ------------------