jdbconn.java~2~

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:login";
           String login = "sa";
           String password = null;

           conn = DriverManager.getConnection(url, login, password);
           state = conn.createStatement();
           String  strSql="select * from atmMoney where id='1'";

       } 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);
       }

    }
}