ATM机案例3之查询信息类以及查询信息操作类（三）

ATM机案例3之查询信息类以及查询信息操作类（三）

目录

一、ShowInfo(查询信息实体类)

点击查看代码

public class ShowInfo {
    private String username;
    private String bankname;
    private int cardid;
    private double balance;

    @Override
    public String toString() {
        StringBuilder stringBuilder = new StringBuilder();
        stringBuilder.append("用户名：" + username);
        stringBuilder.append("\t银行名：" + bankname);
        stringBuilder.append("\t卡  号：" + cardid);
        stringBuilder.append("\t余  额：" + balance);
        return stringBuilder.toString();
    }

    public String getUsername() {
        return username;
    }

    public void setUsername(String username) {
        this.username = username;
    }

    public String getBankname() {
        return bankname;
    }

    public void setBankname(String bankname) {
        this.bankname = bankname;
    }

    public int getCardid() {
        return cardid;
    }

    public void setCardid(int cardid) {
        this.cardid = cardid;
    }

    public double getBalance() {
        return balance;
    }

    public void setBalance(double balance) {
        this.balance = balance;
    }
}

二、ShowInfoDAO(银行卡操作类)

点击查看代码

import java.sql.Connection;
import java.sql.ResultSet;
import java.sql.SQLException;
import java.sql.Statement;
import java.util.ArrayList;
import java.util.List;

public class ShowInfoDAO {

    //展示银行卡信息
    public void show(int id) {
        Connection connection = DBUtils.getConnection();
        Statement statement = null;
        ResultSet resultSet = null;
        try {
            statement = connection.createStatement();
            String string = "SELECT ta.USERNAME ,tb.BANK_NAME ,tbc.CARD_NUMBER ,tbc.BALANCE \n" +
                    "FROM T_ACCOUNT ta ,T_BANK tb ,T_BANK_CARD tbc \n" +
                    "WHERE ta.ACCOUNT_ID =tbc.ACCOUNT_ID \n" +
                    "AND tbc.BANK_ID =tb.BANK_ID\n" +
                    "AND tbc.STATUS ='可用'" +
                    "AND ta.account_id = %d";
            String sql = String.format(string, id);
            resultSet = statement.executeQuery(sql);

            List<ShowInfo> list = new ArrayList<>();
            while (resultSet.next()) {
                ShowInfo showInfo = new ShowInfo();
                showInfo.setUsername(resultSet.getString("username"));
                showInfo.setBankname(resultSet.getString("bank_name"));
                showInfo.setCardid(resultSet.getInt("card_number"));
                showInfo.setBalance(resultSet.getDouble("balance"));
                list.add(showInfo);
            }
            for (ShowInfo showInfo : list) {
                System.out.println(showInfo);
            }
        } catch (SQLException e) {
            e.printStackTrace();
        } finally {
            DBUtils.close(resultSet, statement, connection);
        }
    }

    //删除银行卡信息
    public void deleteShowInfo(int cardNumber) {
        Connection connection = DBUtils.getConnection();
        Statement statement = null;
        try {
            statement = connection.createStatement();
            statement.executeUpdate("DELETE FROM T_BANK_CARD WHERE CARD_NUMBER = " + cardNumber);
            System.out.println("销卡成功！");
        } catch (SQLException e) {
            e.printStackTrace();
        } finally {
            DBUtils.close(statement,connection);
        }
    }
}

未完