-
Notifications
You must be signed in to change notification settings - Fork 0
Expand file tree
/
Copy pathWithdrawal.java
More file actions
110 lines (91 loc) · 3.57 KB
/
Copy pathWithdrawal.java
File metadata and controls
110 lines (91 loc) · 3.57 KB
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
32
33
34
35
36
37
38
39
40
41
42
43
44
45
46
47
48
49
50
51
52
53
54
55
56
57
58
59
60
61
62
63
64
65
66
67
68
69
70
71
72
73
74
75
76
77
78
79
80
81
82
83
84
85
86
87
88
89
90
91
92
93
94
95
96
97
98
99
100
101
102
103
104
105
106
107
108
109
110
import javax.swing.*;
import java.awt.*;
import java.awt.event.*;
import java.sql.*;
import java.util.Date;
public class Withdrawal extends JFrame implements ActionListener{
String pin;
TextField textField;
JButton b1,b2;
Withdrawal(String pin){
this.pin = pin;
ImageIcon i1 = new ImageIcon(ClassLoader.getSystemResource("icons/atm2.png"));
Image i2 = i1.getImage().getScaledInstance(1550,830,Image.SCALE_DEFAULT);
ImageIcon i3 = new ImageIcon(i2);
JLabel l3 = new JLabel(i3);
l3.setBounds(0,0,1550,830);
l3.setLayout(null);
add(l3);
JLabel label1 = new JLabel("(Maximum withdrawal is 10,000)");
label1.setForeground(Color.WHITE);
label1.setFont(new Font("System",Font.BOLD,16));
label1.setBounds(460,180,400,20);
l3.add(label1);
JLabel label2 = new JLabel("Please enter your amount");
label2.setForeground(Color.WHITE);
label2.setFont(new Font("System",Font.BOLD,16));
label2.setBounds(460,220,400,35);
l3.add(label2);
textField = new TextField();
textField.setBackground(new Color(65,125,128));
textField.setForeground(Color.WHITE);
textField.setBounds(460,260,320,25);
textField.setFont(new Font("Raleway",Font.BOLD,22));
l3.add(textField);
b1 = new JButton("Withdrawal");
b1.setBackground(new Color(65,125,128));
b1.setBounds(700,362,150,35);
b1.setForeground(Color.WHITE);
b1.addActionListener(this);
l3.add(b1);
b2 = new JButton("BACK");
b2.setBackground(new Color(65,125,128));
b2.setBounds(700,406,150,35);
b2.setForeground(Color.WHITE);
b2.addActionListener(this);
l3.add(b2);
setLayout(null);
setSize(1550,1080);
setLocation(0,0);
setVisible(true);
}
@Override
public void actionPerformed(ActionEvent e) {
if(e.getSource()==b1){
try{
String amount = textField.getText();
Date date = new Date();
if(textField.getText().equals("")){
JOptionPane.showMessageDialog(null,"Please enter the amount you want to withdraw");
}else{
Con c = new Con();
ResultSet resultSet = c.statement.executeQuery("select * from bank where pin = '"+pin+"'");
int balance =0;
while(resultSet.next()){
if(resultSet.getString("type").equals("Deposit")){
balance += Integer.parseInt(resultSet.getString("amount"));
}else {
balance -= Integer.parseInt(resultSet.getString("amount"));
}
}
if(balance<Integer.parseInt(amount)){
JOptionPane.showMessageDialog(null,"Insufficient Balance");
return;
}
c.statement.executeUpdate("Insert into bank values('"+pin+"','"+date+"','Withdrawal','"+amount+"')");
JOptionPane.showMessageDialog(null,"RS. "+amount+" Debited successfully");
setVisible(false);
new main_Class(pin);
}
}
catch(Exception E){
}
}else if(e.getSource()==b2){
setVisible(false);
new main_Class(pin);
}
}
public static void main(String args[]){
new Withdrawal("");
}
}