ATM-Project/Bal_trans.java at master · irufaan/ATM-Project · GitHub

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
111
112
113
114
115
116
117
118
119
120
121
122
123
124
125
126
127
128
129
130
/**
 * @(#)Bal_trans.java
 *
 *
 * @author
 *
 */


import java.awt.*;
import javax.swing.*;
import java.awt.event.*;
import java.sql.*;

public class Bal_trans extends JFrame implements ActionListener{

	JPasswordField txtuser=new JPasswordField(25);
	JTextField txtpass=new JTextField(25);
	JLabel lbluser=new JLabel("Pin Number: ");
	JLabel lblpass=new JLabel("Balanced");
	JButton btnOk=new JButton("Back to Menu");
	JButton btnRegister=new JButton("Bal.Inquire");


	Connection cn;
	//ResultSet rs;
	Statement st;

	public Bal_trans(){

		JPanel pane=new JPanel();
		pane.setLayout(null);
		//----Adding Components into your Frame
		pane.add(txtuser);
		pane.add(txtpass);
		pane.add(lbluser);
		pane.add(lblpass);
		pane.add(btnOk);
		pane.add(btnRegister);
		//-----Setting the location of the components
		lbluser.setBounds(10,20,80,20);
		lblpass.setBounds(10,40,80,20);
		txtuser.setBounds(100,20,100,20);
		txtpass.setBounds(100,40,100,20);
		btnOk.setBounds(80,120,140,20);
		btnRegister.setBounds(100,70,100,20);
		//-----Adding the an actionlistener to the buttons
		btnOk.addActionListener(this);
		btnRegister.addActionListener(this);

		txtpass.setEditable(false);
		btnOk.setToolTipText("Click To Back to Menu");

		btnOk.setForeground(Color.yellow);
		btnRegister.setForeground(Color.yellow);
		btnOk.setBackground(Color.black);
		btnRegister.setBackground(Color.black);

		setContentPane(pane);
		setDefaultCloseOperation(JFrame.DO_NOTHING_ON_CLOSE);

		JLabel lbl = new JLabel(new ImageIcon("back.jpg"));

		lbl.setBounds(0,0,250,200);
		pane.add(lbl);


		//connection

		try{
			Class.forName("sun.jdbc.odbc.JdbcOdbcDriver");
			cn = DriverManager.getConnection("jdbc:odbc:project");
		}catch(ClassNotFoundException e)  {
 			System.err.println("Failed to load driver");
 			e.printStackTrace();

 		}catch(SQLException e){
 			System.err.println("Unable to connect");
 			e.printStackTrace();

 		}
	}

	public void actionPerformed(ActionEvent e){
		Object source=e.getSource();

		if(source==btnOk){
			third_atm panel = new third_atm();
			panel.setSize(330,300);
			panel.setVisible(true);
			panel.setResizable(false);
			panel.setLocation(400,250);
			dispose();


		}else if(source==btnRegister){
			try{
				st= cn.createStatement();
					ResultSet rs=st.executeQuery("SELECT * FROM tbl_list WHERE Password ='"+txtuser.getText()+"'");
						while(rs.next()){
							txtpass.setText(rs.getString(9));

						JOptionPane.showMessageDialog(null,"Record Found.","ATM System",JOptionPane.INFORMATION_MESSAGE);

						}
					st.close();
				}
				catch(SQLException s){
					System.out.println("No record found!\n\n\n");
					System.out.println("SQL Error" + s.toString() + " " + s.getErrorCode() + " " + s.getSQLState());
				}
				catch(Exception x){
					System.out.println("Error" + x.toString()+" " + x.getMessage());
				}

		}
	}

	public static void main(String[]args){
		Bal_trans log=new Bal_trans();

		log.setLocation(400,250);
		log.setSize(250,200);
		log.setTitle("Balance Inquiry");
		log.setResizable(false);
		log.setVisible(true);


	}
}