db.java~17~

网吧的计费系统,通过改系统可以简单的为网吧的收费提供方便

package prj;

import java.sql.Connection;
import java.sql.DriverManager;
import java.sql.SQLException;
import java.sql.Statement;
import java.sql.PreparedStatement;
import java.sql.ResultSet;
import javax.swing.JOptionPane;

/**
 * <p>Title: </p>
 *
 * <p>Description: </p>
 *
 * <p>Copyright: Copyright (c) 2007</p>
 *
 * <p>Company: </p>
 *
 * @author not attributable
 * @version 1.0
 */
public class DB {

    public DB() {
    }

    private static final String Driver = "sun.jdbc.odbc.JdbcOdbcDriver";
    private static final String url = "jdbc:odbc:java";

    public static Connection getConnection() {
        Connection dbConnection = null;
        try {
            Class.forName(Driver);
            dbConnection = DriverManager.getConnection(url);
        } catch (ClassNotFoundException ex) {
            ex.printStackTrace();
        } catch (SQLException ex) {
            ex.printStackTrace();
        }

        return dbConnection;
    }

    public boolean panduan(Card dbcard) {

        String id = dbcard.getId();
        String password = dbcard.getPassword();
        String strsql = "select password from Card where Id = ?";
        System.out.println("**" + id);


        try {
            Connection con = getConnection();

//            PreparedStatement s = con.prepareStatement(strsql);
//            s.setString(1, id);
//            ResultSet rs = s.executeQuery();
            Statement s = con.createStatement();
            ResultSet rs = s.executeQuery("select password from Card where Id =" + id );
            if (rs.next()) {
                if (password.equalsIgnoreCase(rs.getString(2))) {
                    return true;
                } else {
                    JOptionPane.showMessageDialog(null, "你输入的密码不正确! 请重新输入...");
                    return false;
                }
            } else {
                JOptionPane.showMessageDialog(null, "卡号不存在!");
                return false;
            }
        } catch (SQLException ex) {
            ex.printStackTrace();
        }
        return false;
    }
}