jdbconn.java~6~

ATM机具有存款、取款、查询结余、打印凭条、修改密码功能。

package atm;

import java.sql.Statement;
import java.sql.Connection;
import java.sql.DriverManager;
import javax.swing.JOptionPane;
import java.sql.SQLException;
/**
 * <p>Title: </p>
 *
 * <p>Description: </p>
 *
 * <p>Copyright: Copyright (c) 2008</p>
 *
 * <p>Company: </p>
 *
 * @author not attributable
 * @version 1.0
 */
public class jdbconn {
    Statement state;
     Connection conn;
     public jdbconn() {
         try {
            Class.forName("sun.jdbc.odbc.JdbcOdbcDriver");
            String url = "jdbc:odbc:atm";
            String login = "";
            String password = null;
            conn = DriverManager.getConnection(url, login, password);
            state = conn.createStatement();
        } catch (SQLException e) {
                  JOptionPane.showMessageDialog(null, e.getMessage(),
                                                "Database Error",
                                                JOptionPane.ERROR_MESSAGE);
           System.exit(1);
       } catch (ClassNotFoundException e) {
           JOptionPane.showMessageDialog(null, e.getMessage(),
                                         "Driver Not Found",
                                         JOptionPane.ERROR_MESSAGE);
           System.exit(1);
       }

    }
}