ATM Database

Description: it runs like a ATM machine. you can withdraw money from bank or transfer money to other account


//Mainmenu.java
import java.awt.event.* ; //
import javax.swing.* ; // PACKAGES
import java.awt.* ; //
import java.sql.*; //
//-----------------THE MAIN MENU---------------------
public class MainMenu extends JFrame implements ActionListener {
private JButton but1, but2, but3, but4, but5, but6,but7,but8,but9 ;
private JLabel labb,label,label2,label3,label4,label4a,label5,label6,label6a,label7;
private JTextArea textarea;
private JPasswordField pwordfield;
private int pw,intt;
static String url = "jdbc:odbc:abc";
private String str1;
Container c;
//--Constructor----
public MainMenu() {
super("ATM");
}
//----Method Main(The main Method)-----
public void Main(){
c = getContentPane() ;
c.setLayout(null) ;


but1 = new JButton(">>>") ;
but1.setPreferredSize( new Dimension(100,30) ) ;
but1.setSize( but1.getPreferredSize() ) ;
but1.setLocation(50,50) ;
but1.addActionListener(this) ;
c.add(but1) ;

but2 = new JButton(">>>") ;
but2.setPreferredSize( new Dimension(100,30) ) ;
but2.setSize( but2.getPreferredSize() ) ;
but2.setLocation(50,100) ;
but2.addActionListener(this) ;
c.add(but2) ;

but3=new JButton(">>>");
but3.setPreferredSize(new Dimension(100,30));
but3.setSize(but3.getPreferredSize());
but3.addActionListener(this);
but3.setLocation(50,150);
c.add(but3);

but4 = new JButton("<<<");
but4.setPreferredSize(new Dimension(100,30));
but4.setSize(but4.getPreferredSize());
but4.addActionListener(this);
but4.setLocation(375,50);
c.add(but4);

but5 = new JButton("<<<");
but5.setPreferredSize(new Dimension(100,30));
but5.setSize(but5.getPreferredSize());
but5.setLocation(375,100);
but5.addActionListener(this);
c.add(but5);

but6 = new JButton("<<<");
but6.setPreferredSize(new Dimension(100,30));
but6.setSize(but6.getPreferredSize());
but6.setLocation(375,150);
but6.addActionListener(this);
but6.addActionListener(new ActionListener(){
//----Creating the odbc Driver for but6-----
public void actionPerformed(ActionEvent event){
if(event.getSource()==but6){
try{
Class.forName("sun.jdbc.odbc.JdbcOdbcDriver");
}catch(ClassNotFoundException a){
JOptionPane.showMessageDialog(
null, url,"CLASS NOT FOUND EXCEPTION !!!",JOptionPane.INFORMATION_MESSAGE);
}
}
}


});
c.add(but6);

but7 = new JButton("CANCEL");
but7.setPreferredSize(new Dimension(100,30));
but7.setSize(but7.getPreferredSize());
but7.setLocation(200,212);
but7.addActionListener(this);
c.add(but7);

label=new JLabel("CASH");
label.setPreferredSize(new Dimension(75,50));
label.setSize(label.getPreferredSize());
label.setLocation(160,40);
label.setToolTipText("to draw money,please click on the left button");
c.add(label);

label2 = new JLabel(" INFORMATION");
label2.setPreferredSize(new Dimension(85,50));
label2.setSize(label2.getPreferredSize());
label2.setLocation(280,40);
label2.setToolTipText("For information,please click on the left button");
c.add(label2);

label3 = new JLabel("TRANSFER");
label3.setPreferredSize(new Dimension(85,50));
label3.setSize(label3.getPreferredSize());
label3.setLocation(160,90);
label3.setToolTipText("for referring money,click on the right button");
c.add(label3);

label4 = new JLabel("CARD ");
label4.setPreferredSize(new Dimension(85,50));
label4.setSize(label4.getPreferredSize());
label4.setLocation(160,132);
label4.setToolTipText(
"For password,dept operations,please click on the left button");
c.add(label4);

label4a = new JLabel("TRANSACTIONS");
label4a.setPreferredSize(new Dimension(100,50));
label4a.setSize(label4a.getPreferredSize());
label4a.setLocation(160,148);
c.add(label4a);

label5 = new JLabel(" INVESTMENT");
label5.setPreferredSize(new Dimension(95,50));
label5.setSize(label5.getPreferredSize());
label5.setLocation(280,90);
label5.setToolTipText(
"To buy fund,bond etc.,please click on the right button");
c.add(label5);

label6 = new JLabel(" STANDARD");
label6.setPreferredSize(new Dimension(75,50));
label6.setSize(label6.getPreferredSize());
label6.setLocation(280,132);
label6.setToolTipText("To get 10$ rapidly,please click");
c.add(label6);

label6a = new JLabel(" CASH");
label6a.setPreferredSize(new Dimension(75,50));
label6a.setSize(label6a.getPreferredSize());
label6a.setLocation(280,147);
label6a.setToolTipText("To get 10$ rapidly please click");
c.add(label6a);

setSize(500,410) ;
show();
}
//------actionPerformed method for ActionListener-----
public void actionPerformed( ActionEvent event ){
if( event.getSource()==but7 )
System.exit(0) ;
else if( event.getSource() == but1 ){
new Cash();this.hide();}
else if(event.getSource()== but2 ){
new Transfer();this.hide();}
else if(event.getSource()==but3){
new CardTransactions();this.hide();}
else if(event.getSource()==but4 ){
new Information();this.hide();}
else if(event.getSource()==but6){
new StandardCash();this.hide();}
else if(event.getSource()==but9)
System.exit(0);
else if(event.getSource()==but8){
//----Select operation for comparison of first password entered----
try{
Class.forName("sun.jdbc.odbc.JdbcOdbcDriver");
}catch(ClassNotFoundException a){
JOptionPane.showMessageDialog(
null, url,"CLASS NOT FOUND EXCEPTION !!!",
JOptionPane.INFORMATION_MESSAGE);
}

try{
String string = new String(pwordfield.getPassword());
intt=Integer.parseInt(string);
String run = "SELECT * FROM abc " +"WHERE password = " +intt;
System.out.println(run + "SQL string executed");
Connection connection = DriverManager.getConnection(url,"","");
Statement stmt = connection.createStatement();
ResultSet result=stmt.executeQuery(run);
while(result.next()){
String name = result.getString(1);
String surname = result.getString(2);
int amount = result.getInt(3);
int password = result.getInt(4);
pw=password;

}
connection.close();

}catch(SQLException a){
JOptionPane.showMessageDialog(
null,url,"SQL EXCEPTION AT SELECT OPERATION",
JOptionPane.INFORMATION_MESSAGE);
} this.hide();
//---Comparison---if there is not equivalent MainMenu does not appear-----
if(pw==intt){MainMenu s=new MainMenu();s.Main();}
else if(pw!=intt){
JOptionPane.showMessageDialog(
null,"Invalid Password,Please try again",
"EXCEPTION",JOptionPane.ERROR_MESSAGE);
MainMenu s=new MainMenu();s.Password();
}
}

}//-----method main---Executes the password asking--------
public static void main(String args[]){
MainMenu s=new MainMenu();
s.Password();
}//-----password method----------
public void Password(){
c = getContentPane() ;
c.setLayout(new FlowLayout()) ;
c.setBackground(Color.lightGray);

pwordfield=new JPasswordField(17);
c.add(pwordfield);

but8=new JButton("OK");
but8.setPreferredSize(new Dimension(90,25));
but8.setSize(but8.getPreferredSize());
but8.addActionListener(this);
c.add(but8);

but9=new JButton("CANCEL");
but9.setPreferredSize(new Dimension(90,25));
but9.setSize(but9.getPreferredSize());
but9.addActionListener(this);
c.add(but9);
//-----Informations about the program-----
String sttr=" W E L C O M E!\n"+
" Please write your password:\n"+
"----------------------------------------------\n"+
" This product is a\n"+
" guarenteed trade mark of\n"+
" 'SP COMPUTER SYSTEMS INC.\n"+
" For information we are on web:\n"+
" www.spcomputer.com\n"+
"----------------------------------------------\n"+
" Producer: ÖNER EKIZ";

//-----set up textarea----------------
textarea = new JTextArea(sttr,10,17);
c.add(new JScrollPane(textarea));
textarea.setBackground(Color.lightGray);
textarea.setEditable(false);
setSize(250,300) ;
show();
}
}




//Transfer.java
import java.awt.*; //
import java.awt.event.*; //
import javax.swing.*; // PACKAGES
import java.sql.*; //
import sun.jdbc.odbc.*; //

public class Transfer extends JFrame implements ActionListener{
private JTextField textfield1,textfield2,textfield3,textfield4,textfield5;
private JButton OKButton,ExitButton;
private JLabel label;
private int int1,int2,int3,Amount,Amount1,Password;
private String str1,str2,str3;
static String url = "jdbc:odbc:abc";
//SET UP GUI
public Transfer(){
super("Money Transfer");
Container container = getContentPane();
container.setLayout(new FlowLayout() );

label=new JLabel("Password of the user:");
label.setLocation(200,50);
container.add(label);

textfield5 = new JTextField(15);
container.add(textfield5);

textfield1 = new JTextField("Password of the receiver:");
textfield1.setEditable(false);
container.add(textfield1);
textfield2 = new JTextField(15);
container.add(textfield2);

textfield3 = new JTextField("Amount of the sent:",15);
textfield3.setEditable(false);
container.add(textfield3);
textfield4 = new JTextField(15);
container.add(textfield4);

OKButton = new JButton("OK");
OKButton.setPreferredSize(new Dimension(80,20));
OKButton.setSize(OKButton.getPreferredSize());
OKButton.addActionListener(this);
container.add(OKButton);

ExitButton = new JButton("Exit");
ExitButton.setPreferredSize(new Dimension(80,20));
ExitButton.setSize(ExitButton.getPreferredSize());
ExitButton.addActionListener(this);
container.add(ExitButton);

setSize(400,150);
setVisible(true);

}//-------------actionPerformed----------------------------------------
public void actionPerformed(ActionEvent event){
if(event.getSource()==ExitButton){
this.hide();MainMenu s=new MainMenu();s.Main();
}
else if(event.getSource()==OKButton){
try{
Class.forName("sun.jdbc.odbc.JdbcOdbcDriver");
}catch(ClassNotFoundException a){
JOptionPane.showMessageDialog(null, url,"CLASS NOT FOUND EXCEPTION !!!",JOptionPane.INFORMATION_MESSAGE);
}
}
try{ //Select operation:
str3=textfield5.getText(); // gets password of user
int1=Integer.parseInt(str3);
String run = "SELECT * FROM abc " +"WHERE password = " +int1;
System.out.println(run + "SQL string executed");
Connection connection = DriverManager.getConnection(url,"","");
Statement stmt = connection.createStatement();
ResultSet result=stmt.executeQuery(run);
while(result.next()){
String name = result.getString(1);
String surname = result.getString(2);
int amount = result.getInt(3);
int password = result.getInt(4);

Amount=amount;
}
connection.close();
}
catch(SQLException a){
JOptionPane.showMessageDialog(null,url,"SQL EXCEPTION AT SELECT OPERATION",JOptionPane.INFORMATION_MESSAGE);
}

str2=textfield4.getText(); //amount of sent
int3=Integer.parseInt(str2);
Amount=Amount-int3;
//--------------Updating values of the database-------------
String run = "UPDATE abc SET " +
"amount='" +Amount+"' WHERE password="+int1;
try{
Connection connection = DriverManager.getConnection(url,"","");
Statement stmt = connection.createStatement();
stmt.executeUpdate(run);
System.out.println("Operation completed...");
connection.close();
}catch(SQLException a){JOptionPane.showMessageDialog(null,url,"SQL EXCEPTION AT UPDATE OPERATION",JOptionPane.INFORMATION_MESSAGE);
}
//---Select operation for the person (the money transferred to)------
try{
Class.forName("sun.jdbc.odbc.JdbcOdbcDriver");
}catch(ClassNotFoundException a){
JOptionPane.showMessageDialog(null, url,"CLASS NOT FOUND EXCEPTION !!!",JOptionPane.INFORMATION_MESSAGE);
}
try{
str1=textfield2.getText();//password of receiver
int2=Integer.parseInt(str1);

String run2 = "SELECT * FROM abc " +"WHERE password = " +int2;
System.out.println(run2 + "SQL string executed");
Connection connection = DriverManager.getConnection(url,"","");
Statement stmt = connection.createStatement();
ResultSet result=stmt.executeQuery(run2);
while(result.next()){
String name = result.getString(1);
String surname = result.getString(2);
int amount = result.getInt(3);
int password = result.getInt(4);

Amount1=amount;
}
connection.close();
}
catch(SQLException a){
JOptionPane.showMessageDialog(null,url,"SQL EXCEPTION AT SELECT OPERATION",JOptionPane.INFORMATION_MESSAGE);
}
Amount1=Amount1+int3;
//---------Updating the values for the person,money transferred to--
String run1 = "UPDATE abc SET " +
"amount='" +Amount1+"' WHERE password="+int2;
try{
Connection connection = DriverManager.getConnection(url,"","");
Statement stmt = connection.createStatement();
stmt.executeUpdate(run1);
System.out.println("Operation completed...");
connection.close();
}catch(SQLException a){JOptionPane.showMessageDialog(null,url,"SQL EXCEPTION AT UPDATE OPERATION",JOptionPane.INFORMATION_MESSAGE);
}

}
}





//Standardcash.java

import java.awt.*; //
import java.awt.event.*; // PACKAGES
import javax.swing.*; //
import java.sql.*; //
public class StandardCash extends JFrame implements ActionListener {
private JButton button1,button2;
private JLabel label1;
private String str1;
private int Amount,Password;
private JTextField text1;
static String url = "jdbc:odbc:abc";
Container container;
//SET UP GUI
public StandardCash(){
super("Standard Cash (10$)");
Container container = getContentPane();
container.setLayout(null);

button1 = new JButton("OK");
button1.setPreferredSize(new Dimension (90,30));
button1.setSize(button1.getPreferredSize());
button1.setLocation(50,100);
button1.addActionListener(this);
container.add(button1);

text1=new JTextField(10);
text1.setPreferredSize(new Dimension(10,22));
text1.setSize(text1.getPreferredSize());
text1.setLocation(50,60);
container.add(text1);

button2 = new JButton("CANCEL");
button2.setPreferredSize(new Dimension (90,30));
button2.setSize(button2.getPreferredSize());
button2.addActionListener(this);
button2.setLocation(150,100);

container.add(button2);

label1 = new JLabel("Please enter your password:");
label1.setPreferredSize(new Dimension(250,20));
label1.setSize(label1.getPreferredSize());
label1.setLocation(50,40);
container.add(label1);

setSize(350,300);
show();

}//------Method for ActionListener-----------------
public void actionPerformed(ActionEvent event){
if(event.getSource()==button1){
//Selecting the values for the user--------
try{
str1=text1.getText();
int int1=Integer.parseInt(str1);

String run = "SELECT * FROM abc " +"WHERE password = " +int1;
System.out.println(run + "SQL string executed");
Connection connection = DriverManager.getConnection(url,"","");
Statement stmt = connection.createStatement();
ResultSet result=stmt.executeQuery(run);
while(result.next()){
String name = result.getString(1);
String surname = result.getString(2);
int amount = result.getInt(3);
int password = result.getInt(4);
Password=password;
Amount=amount-10;
}
connection.close();
}
catch(SQLException a){
JOptionPane.showMessageDialog(
null,url,"SQL EXCEPTION AT SELECT OPERATION",
JOptionPane.INFORMATION_MESSAGE);
}
//-----Updating the Amount that is reduced up ^^----------
String run = "UPDATE abc SET " +
"amount='" +Amount+"' WHERE password="+Password;
try{
Connection connection = DriverManager.getConnection(url,"","");
Statement stmt = connection.createStatement();
stmt.executeUpdate(run);
System.out.println("Operation completed...");
connection.close();
}catch(SQLException a){JOptionPane.showMessageDialog(
null,url,"SQL EXCEPTION AT UPDATE OPERATION",
JOptionPane.INFORMATION_MESSAGE);
}
}
else if(event.getSource()==button2){
this.hide();
MainMenu s=new MainMenu();s.Main();
}

}
}







//Information.java
import java.awt.*; //
import java.awt.event.*; // PACKAGES
import javax.swing.*; //
import java.sql.*; //
public class Information extends JFrame implements ActionListener {
private JButton button1,button2;
private JLabel label1,label2;
static String url = "jdbc:odbc:abc";
//-----Constructor------
public Information(){
super();
Container container = getContentPane();
container.setLayout(null);

button1 = new JButton(" >>> ");
button1.setPreferredSize(new Dimension(100,30));
button1.setSize(button1.getPreferredSize());
button1.setLocation(30,50);
button1.addActionListener(this);
container.add(button1);

button2 = new JButton(" CANCEL ");
button2.setPreferredSize(new Dimension(100,30));
button2.setSize(button2.getPreferredSize());
button2.setLocation(30,100);
button2.addActionListener(this);
container.add(button2);

label1 = new JLabel("Demonstration");
label1.setPreferredSize(new Dimension(120,30));
label1.setSize(label1.getPreferredSize());
label1.setLocation(150,43);
container.add(label1);

label2 = new JLabel("of Remainder");
label2.setPreferredSize(new Dimension(120,30));
label2.setSize(label2.getPreferredSize());
label2.setLocation(150,56);
container.add(label2);

setSize(400,300);
setVisible(true);
}//------actionPerformed method for ActionListener-----
public void actionPerformed(ActionEvent event){

if(event.getSource()==button1){
DB2 s=new DB2();s.Demonstration();
}
else if(event.getSource()==button2){
//--Closes the present window--
this.hide();
//--Going to DB2 class for execution
DB2 s=new DB2();s.Back();
}
}

}






//DB.java

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

public class DB extends JFrame implements ActionListener {
static String url = "jdbc:odbc:abc";
private JTextField text1,text2,text3;
private JButton but1,but2,but3,but4;
private JLabel label1,label2,label3;
private int Amount,Amount1,pword,int1;
private String str1,str2,str3;
private String run;
Container c;
//---Constructor---
public DB(){
}//---Method for getting different amount--called from class Cash--
public void ExecutionForAnother(){

Container c=getContentPane();
c.setLayout(new FlowLayout());

label2=new JLabel(" Write the money you want to get and your password:");
c.add(label2);
text1=new JTextField(10);
c.add(text1);

label1=new JLabel("<>");
c.add(label1);
text2=new JTextField(10);
c.add(text2);

but1=new JButton(" OK ");
but1.addActionListener(this);
but1.setBackground(Color.white);
c.add(but1);

but4=new JButton(" BACK ");
but4.addActionListener(this);
but4.setBackground(Color.white);
c.add(but4);

setSize(400,250);
setResizable(true);
show();
}//----Method for getting one of the value(money) that is seen
//---on the screen--Called from class Cash---
public void CashScreen(){
c=getContentPane();
c.setLayout(new FlowLayout());

label3 = new JLabel("PLEASE WRITE Pword & PRESS OK:");
c.add(label3);
text3=new JTextField(10);
c.add(text3);

but2 = new JButton("OK");
but2.setPreferredSize(new Dimension(80,25));
but2.setSize(but2.getPreferredSize());
but2.setBackground(Color.white);
but2.addActionListener(this);
c.add(but2);

but3 = new JButton("CANCEL");
but3.setPreferredSize(new Dimension(80,25));
but3.setSize(but3.getPreferredSize());
but3.setBackground(Color.white);
but3.addActionListener(this);
c.add(but3);

setSize(350,200);
show();
}//--------Method for the ActionListener---------
public void actionPerformed(ActionEvent event){
if(event.getSource()==but2){// for CashScreen
str3=text3.getText();
int int8=Integer.parseInt(str3);
try{ //--Selection for CashScreen---
String run = "SELECT * FROM abc " +"WHERE password=" +int8;
System.out.println(run+"SQL Operatýon Executed..");
Connection connection = DriverManager.getConnection(url,"","");
Statement stmt = connection.createStatement();
ResultSet result=stmt.executeQuery(run);
while (result.next()){
String name = result.getString(1);
String surname = result.getString(2);
int amount = result.getInt(3);
int password = result.getInt(4);
Amount = amount;
}
connection.close();
}catch(SQLException a){
JOptionPane.showMessageDialog(null,url,"SQL EXCEPTION AT SELECTION OPERATION",JOptionPane.INFORMATION_MESSAGE);
}
Amount=Amount-20; //reducing the user's money
//---Updating the new values----
String run1 = "UPDATE abc SET " +
"amount='" +Amount+"' WHERE password="+int8;
try{
Connection connection = DriverManager.getConnection(url,"","");
Statement stmt = connection.createStatement();
stmt.executeUpdate(run1);
System.out.println("Operation completed...");
connection.close();
}catch(SQLException a){JOptionPane.showMessageDialog(null,url,"SQL EXCEPTION AT UPDATE OPERATION",JOptionPane.INFORMATION_MESSAGE);
}


}//--------------------------------------------------------
else if(event.getSource()==but4){
this.hide();}
else if(event.getSource()==but1){ //for another
str2=text1.getText(); // gets password
pword=Integer.parseInt(str2);
try{
Class.forName("sun.jdbc.odbc.JdbcOdbcDriver");
}catch(ClassNotFoundException a){
JOptionPane.showMessageDialog(null, url,"CLASS NOT FOUND EXCEPTION !!!",JOptionPane.INFORMATION_MESSAGE);
}
//---Selection for ExecutionForAnother----
try{
String run = "SELECT * FROM abc " +"WHERE password = " +pword;
System.out.println(run + "SQL string executed");
Connection connection = DriverManager.getConnection(url,"","");
Statement stmt = connection.createStatement();
ResultSet result=stmt.executeQuery(run);
while(result.next()){
String name = result.getString(1);
String surname = result.getString(2);
int amount = result.getInt(3);
int password = result.getInt(4);

Amount1=amount;
}
connection.close();
}catch(SQLException a){
JOptionPane.showMessageDialog(null,url,"SQL EXCEPTION AT SELECT OPERATION",JOptionPane.INFORMATION_MESSAGE);
}
str1=text2.getText(); //gets the wanted money
int1 =Integer.parseInt(str1);
Amount1=Amount1-int1; //and subtract it from the total money
//--Update the Amount after operations above--
String run1 = "UPDATE abc SET " +
"amount='" +Amount1+"' WHERE password="+pword;
try{
Connection connection = DriverManager.getConnection(url,"","");
Statement stmt = connection.createStatement();
stmt.executeUpdate(run1);
System.out.println("Operation completed...");
connection.close();
}catch(SQLException a){JOptionPane.showMessageDialog(null,url,"SQL EXCEPTION AT UPDATE OPERATION",JOptionPane.INFORMATION_MESSAGE);
}
}
else if(event.getSource()==but3){
this.hide();
}
}//--end of method actionPerformed---

}//--end of class.






//Cardtransactions.java

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

public class CardTransactions extends JFrame {
private JButton button1,button2,button3;
private JLabel label1,label2;
static String url = "jdbc:odbc:abc";
Container container;
//---Constructor---
public CardTransactions(){
super(" Card Transactions");
Container container = getContentPane();
container.setLayout(null);

button1 = new JButton(">>>");
button1.setPreferredSize(new Dimension(100,30));
button1.setSize(button1.getPreferredSize());
button1.setLocation(30,50);
//---making connection with the database---
button1.addActionListener(new ActionListener(){
public void actionPerformed(ActionEvent event){
try{
Class.forName("sun.jdbc.odbc.JdbcOdbcDriver");
}catch(ClassNotFoundException a){
JOptionPane.showMessageDialog(null, url,"CLASS NOT FOUND EXCEPTION !!!",JOptionPane.INFORMATION_MESSAGE);
}
//--goes to DB2-ChangePword to execute changing password--
DB2 s=new DB2();s.ChangePword();
}
});
container.add(button1);

button2 = new JButton(">>>");
button2.setPreferredSize(new Dimension(100,30));
button2.setSize(button2.getPreferredSize());
button2.setLocation(30,100);
//--makes the connection with the database
//--and goes to DB2 to execute paying dept
button2.addActionListener(new ActionListener(){
public void actionPerformed(ActionEvent event){
DB2 s=new DB2();s.DeptPaying();
}
});
container.add(button2);

button3 = new JButton("");
button3.setPreferredSize(new Dimension(100,30));
button3.setSize(button3.getPreferredSize());
button3.setLocation(30,150);
button3.addActionListener(new ActionListener(){
public void actionPerformed(ActionEvent event){
DB2 s=new DB2();s.Back();
}
});
container.add(button3);

label1 = new JLabel("Change Password");
label1.setPreferredSize(new Dimension(120,30));
label1.setSize(label1.getPreferredSize());
label1.setLocation(130,45);
container.add(label1);

label2 = new JLabel("Dept paying");
label2.setPreferredSize(new Dimension(120,30));
label2.setSize(label2.getPreferredSize());
label2.setLocation(130,98);
container.add(label2);

setSize(400,350);
setVisible(true);
}//--end of constructor

}



//Cash.java

import java.awt.*; //
import java.awt.event.*; // PACKAGES
import javax.swing.*; //
import java.sql.*; //
public class Cash extends JFrame implements ActionListener{
public JButton button1,button2,button3,button4,button5,button6,cancelBut;
private JLabel label1,label2,label3,label4,label5,label6;
private JTextField textField;
static String url = "jdbc:odbc:abc";
//---Constructor---
public Cash(){
super("Cash");
Container container=getContentPane() ;
container.setLayout(null);

textField=new JTextField(10);
button1 = new JButton(">>>");
button1.setPreferredSize(new Dimension(100,30));
button1.setSize(button1.getPreferredSize());
button1.setLocation(50,50);
button1.addActionListener(this);
container.add(button1);

button2 = new JButton(">>>");
button2.setPreferredSize(new Dimension(100,30));
button2.setSize(button2.getPreferredSize());
button2.setLocation(50,100);
button2.addActionListener(this);
container.add(button2);

button3 = new JButton(">>>");
button3.setPreferredSize(new Dimension(100,30));
button3.setSize(button3.getPreferredSize());
button3.setLocation(50,150);
button3.addActionListener(this);
container.add(button3);

button4 = new JButton("<<<");
button4.setPreferredSize(new Dimension(100,30));
button4.setSize(button4.getPreferredSize());
button4.setLocation(375,50);
//---makes the communication with the odbc Driver---
button4.addActionListener(new ActionListener(){
public void actionPerformed(ActionEvent event){
if(event.getSource()==button1){
try{
Class.forName("sun.jdbc.odbc.JdbcOdbcDriver");
}catch(ClassNotFoundException a){
JOptionPane.showMessageDialog(null, url,"CLASS NOT FOUND EXCEPTION !!!",JOptionPane.INFORMATION_MESSAGE);
}}DB s=new DB();s.CashScreen();}
});
container.add(button4);

button5 = new JButton("<<<");
button5.setPreferredSize(new Dimension(100,30));
button5.setSize(button5.getPreferredSize());
button5.setLocation(375,100);
button5.addActionListener(this);
container.add(button5);

button6 = new JButton("<<<");
button6.setPreferredSize(new Dimension(100,30));
button6.setSize(button6.getPreferredSize());
button6.setLocation(375,150);
//---makes the communication with the odbc Driver---
button6.addActionListener(new ActionListener(){
public void actionPerformed(ActionEvent event){
if(event.getSource()==button1){
try{
Class.forName("sun.jdbc.odbc.JdbcOdbcDriver");
}catch(ClassNotFoundException a){
JOptionPane.showMessageDialog(null, url,"CLASS NOT FOUND EXCEPTION !!!",JOptionPane.INFORMATION_MESSAGE);
}}DB s=new DB();s.ExecutionForAnother();}
});

container.add(button6);

cancelBut = new JButton("CANCEL");
cancelBut.setPreferredSize(new Dimension(100,30));
cancelBut.setSize(cancelBut.getPreferredSize());
cancelBut.setLocation(375,200);
cancelBut.addActionListener(this);
container.add(cancelBut);

label1=new JLabel(" 10 $");
label1.setPreferredSize(new Dimension(75,30));
label1.setSize(label1.getPreferredSize());
label1.setLocation(150,50);
container.add(label1);

label2=new JLabel(" 20 $");
label2.setPreferredSize(new Dimension(75,30));
label2.setSize(label2.getPreferredSize());
label2.setLocation(300,50);
container.add(label2);

label3=new JLabel(" 40 $");
label3.setPreferredSize(new Dimension(75,30));
label3.setSize(label3.getPreferredSize());
label3.setLocation(150,100);
container.add(label3);

label4=new JLabel(" 50 $");
label4.setPreferredSize(new Dimension(75,30));
label4.setSize(label4.getPreferredSize());
label4.setLocation(300,100);
container.add(label4);

label5=new JLabel(" 100 $");
label5.setPreferredSize(new Dimension(75,30));
label5.setSize(label5.getPreferredSize());
label5.setLocation(150,150);
container.add(label5);

label6=new JLabel(" Another..");
label6.setPreferredSize(new Dimension(85,30));
label6.setSize(label6.getPreferredSize());
label6.setLocation(300,150);
container.add(label6);

setSize(500,400);
setVisible(true);

}//---Method for Actionlistener---
public void actionPerformed(ActionEvent event){
if(event.getSource()==cancelBut){
this.hide();//closes the present application
MainMenu s=new MainMenu();s.Main();//and goes to MainMenu
}

}
}




//DB-1

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

public class DB extends JFrame implements ActionListener {
static String url = "jdbc:odbc:abc";
private JTextField text1,text2,text3;
private JButton but1,but2,but3,but4;
private JLabel label1,label2,label3;
private int Amount,Amount1,pword,int1;
private String str1,str2,str3;
private String run;
Container c;
//---Constructor---
public DB(){
}//---Method for getting different amount--called from class Cash--
public void ExecutionForAnother(){

Container c=getContentPane();
c.setLayout(new FlowLayout());

label2=new JLabel(" Write the money you want to get and your password:");
c.add(label2);
text1=new JTextField(10);
c.add(text1);

label1=new JLabel("<>");
c.add(label1);
text2=new JTextField(10);
c.add(text2);

but1=new JButton(" OK ");
but1.addActionListener(this);
but1.setBackground(Color.white);
c.add(but1);

but4=new JButton(" BACK ");
but4.addActionListener(this);
but4.setBackground(Color.white);
c.add(but4);

setSize(400,250);
setResizable(true);
show();
}//----Method for getting one of the value(money) that is seen
//---on the screen--Called from class Cash---
public void CashScreen(){
c=getContentPane();
c.setLayout(new FlowLayout());

label3 = new JLabel("PLEASE WRITE Pword & PRESS OK:");
c.add(label3);
text3=new JTextField(10);
c.add(text3);

but2 = new JButton("OK");
but2.setPreferredSize(new Dimension(80,25));
but2.setSize(but2.getPreferredSize());
but2.setBackground(Color.white);
but2.addActionListener(this);
c.add(but2);

but3 = new JButton("CANCEL");
but3.setPreferredSize(new Dimension(80,25));
but3.setSize(but3.getPreferredSize());
but3.setBackground(Color.white);
but3.addActionListener(this);
c.add(but3);

setSize(350,200);
show();
}//--------Method for the ActionListener---------
public void actionPerformed(ActionEvent event){
if(event.getSource()==but2){// for CashScreen
str3=text3.getText();
int int8=Integer.parseInt(str3);
try{ //--Selection for CashScreen---
String run = "SELECT * FROM abc " +"WHERE password=" +int8;
System.out.println(run+"SQL Operatýon Executed..");
Connection connection = DriverManager.getConnection(url,"","");
Statement stmt = connection.createStatement();
ResultSet result=stmt.executeQuery(run);
while (result.next()){
String name = result.getString(1);
String surname = result.getString(2);
int amount = result.getInt(3);
int password = result.getInt(4);
Amount = amount;
}
connection.close();
}catch(SQLException a){
JOptionPane.showMessageDialog(null,url,"SQL EXCEPTION AT SELECTION OPERATION",JOptionPane.INFORMATION_MESSAGE);
}
Amount=Amount-20; //reducing the user's money
//---Updating the new values----
String run1 = "UPDATE abc SET " +
"amount='" +Amount+"' WHERE password="+int8;
try{
Connection connection = DriverManager.getConnection(url,"","");
Statement stmt = connection.createStatement();
stmt.executeUpdate(run1);
System.out.println("Operation completed...");
connection.close();
}catch(SQLException a){JOptionPane.showMessageDialog(null,url,"SQL EXCEPTION AT UPDATE OPERATION",JOptionPane.INFORMATION_MESSAGE);
}


}//--------------------------------------------------------
else if(event.getSource()==but4){
this.hide();}
else if(event.getSource()==but1){ //for another
str2=text1.getText(); // gets password
pword=Integer.parseInt(str2);
try{
Class.forName("sun.jdbc.odbc.JdbcOdbcDriver");
}catch(ClassNotFoundException a){
JOptionPane.showMessageDialog(null, url,"CLASS NOT FOUND EXCEPTION !!!",JOptionPane.INFORMATION_MESSAGE);
}
//---Selection for ExecutionForAnother----
try{
String run = "SELECT * FROM abc " +"WHERE password = " +pword;
System.out.println(run + "SQL string executed");
Connection connection = DriverManager.getConnection(url,"","");
Statement stmt = connection.createStatement();
ResultSet result=stmt.executeQuery(run);
while(result.next()){
String name = result.getString(1);
String surname = result.getString(2);
int amount = result.getInt(3);
int password = result.getInt(4);

Amount1=amount;
}
connection.close();
}catch(SQLException a){
JOptionPane.showMessageDialog(null,url,"SQL EXCEPTION AT SELECT OPERATION",JOptionPane.INFORMATION_MESSAGE);
}
str1=text2.getText(); //gets the wanted money
int1 =Integer.parseInt(str1);
Amount1=Amount1-int1; //and subtract it from the total money
//--Update the Amount after operations above--
String run1 = "UPDATE abc SET " +
"amount='" +Amount1+"' WHERE password="+pword;
try{
Connection connection = DriverManager.getConnection(url,"","");
Statement stmt = connection.createStatement();
stmt.executeUpdate(run1);
System.out.println("Operation completed...");
connection.close();
}catch(SQLException a){JOptionPane.showMessageDialog(null,url,"SQL EXCEPTION AT UPDATE OPERATION",JOptionPane.INFORMATION_MESSAGE);
}
}
else if(event.getSource()==but3){
this.hide();
}
}//--end of method actionPerformed---

}//--end of class.





END