JComboBox与数组、数据库的结合--实例二

最新推荐文章于 2024-07-07 20:57:27 发布

chjk1

最新推荐文章于 2024-07-07 20:57:27 发布

阅读量695

点赞数

分类专栏： Java笔记文章标签：数据库 class database action exception numbers

本文链接：https://blog.csdn.net/chjk1/article/details/1967066

版权

Java笔记专栏收录该内容

24 篇文章 0 订阅

订阅专栏

程序说明：用实例说明JComboBox与数据库的结合；本文来自《JAVA大学简明教程----实例程序设计》第26章‘ATM应用程序’，由于调试IBM Cloudscape5.1.3数据库失败，所以无法进一步说明，尽管如此其代码还是有很多可以借鉴的地方，特别是java数据库编程方面知识！（若有谁调试成功望告知，谢谢!）

代码如下：

// Tutorial 26: ATM.java
// ATM application allows users to access an account,
// view the balance and withdraw money from the account.
import java.awt.*;
import java.awt.event.*;
import java.sql.*;
import java.text.*;
import javax.swing.*;
import javax.swing.event.*;

public class ATM extends JFrame
{
// JTextArea to display message
private JTextArea messageJTextArea;

// JTextField to enter PIN or withdrawal amount
private JTextField numberJTextField;

// JPanel for number JButtons
private JPanel buttonsJPanel;

   // JButtons for input of PIN or withdrawal amount
   private JButton oneJButton;
   private JButton twoJButton;
   private JButton threeJButton;
   private JButton fourJButton;
   private JButton fiveJButton;
   private JButton sixJButton;
   private JButton sevenJButton;
   private JButton eightJButton;
   private JButton nineJButton;
   private JButton zeroJButton;

// JButton to submit PIN or withdrawal amount
private JButton enterJButton;

// JButton to view balance
private JButton balanceJButton;

// JButton to withdraw from account
private JButton withdrawJButton;

// JButton to close the transaction
private JButton doneJButton;

// JPanel to get account numbers
private JPanel accountNumberJPanel;

   // JLabel and JComboBox for account numbers
   private JLabel accountNumberJLabel;
   private JComboBox accountNumberJComboBox;

   // constants for user action
   private final static int ENTER_PIN = 1;
   private final static int WITHDRAWAL = 2;

   // instance variables used to store PIN and
   // firstName from database
   private String pin, firstName;

// instance variable used to distinguish user action
private int action;

   // instance variables used to store user selected account number
   // and PIN
   private String userAccountNumber, userPIN;

// instance variable used to store account balance
private double balance;

   // instance variables used to manipulate database
   private Connection myConnection;
   private Statement myStatement;
   private ResultSet myResultSet;

   // constructor
   public ATM( String databaseDriver, String databaseURL )
   {
      // establish connection to database
      try
      {
         // load Cloudscape driver
         Class.forName( databaseDriver );

         // connect to database
         myConnection =
            DriverManager.getConnection( databaseURL );

         // create Statement for executing SQL
         myStatement = myConnection.createStatement();
      }
      catch ( SQLException exception )
      {
         exception.printStackTrace();
      }
      catch ( ClassNotFoundException exception )
      {
         exception.printStackTrace();
      }

      createUserInterface(); // set up GUI

   } // end constructor

   // create and position GUI components; register event handler
   private void createUserInterface()
   {
      // get content pane for attaching GUI components
      Container contentPane = getContentPane();

// enable explicit positioning of GUI components
contentPane.setLayout( null );

      // set up messageJTextArea
      messageJTextArea = new JTextArea();
      messageJTextArea.setBounds( 40, 16, 288, 88 );
      messageJTextArea.setText(
         "Please select your account number." );
      messageJTextArea.setBorder(
         BorderFactory.createLoweredBevelBorder() );
      messageJTextArea.setEditable( false );
      contentPane.add( messageJTextArea );

      // set up numberJTextField
      numberJTextField = new JTextField();
      numberJTextField.setBounds( 110, 120, 128, 21 );
      numberJTextField.setBorder(
         BorderFactory.createLoweredBevelBorder() );
      numberJTextField.setEditable( false );
      contentPane.add( numberJTextField );

      // set up buttonsJPanel
      buttonsJPanel = new JPanel();
      buttonsJPanel.setBounds( 44, 160, 276, 150 );
      buttonsJPanel.setBorder( BorderFactory.createEtchedBorder() );
      buttonsJPanel.setLayout( null );
      contentPane.add( buttonsJPanel );

      // set up oneJButton
      oneJButton = new JButton();
      oneJButton.setBounds( 53, 28, 24, 24 );
      oneJButton.setText( "1" );
      oneJButton.setBorder(
         BorderFactory.createRaisedBevelBorder() );
      buttonsJPanel.add( oneJButton );
      oneJButton.addActionListener(

         new ActionListener() // anonymous inner class
         {
            // event handler called when oneJButton is clicked
            public void actionPerformed( ActionEvent event )
            {
               oneJButtonActionPerformed( event );
            }