jdbconn.java~3~

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 {
    String database_username="";
    String database_password="";

    public jdbconn() {
        try {

           String url = "jdbc:odbc:atm";

           Class.forName("sun.jdbc.odbc.JdbcOdbcDriver");
              Connection dbConn = DriverManager.getConnection(url,database_username, database_password);
              Statement stmt = dbConn.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);
       }

    }
}