package bank;
import java.sql.*;

public class Bankbean01 {

   double balance;
   double amount;
 
   String username;
   String password;

   public Bankbean01() { 
       balance =-1.0;
       amount = -1.0;
   }
   public void setUsername( String name ) {
       username = name;
   }
   public void setPassword( String pass ) {
       password = pass;
   }
   public void setAmount( double num ) {
       amount = num;
   }
   public double getBalance() { 
       balance=-1.0;  // needed since negative balance means invalid account
      
       Connection con;
       String query="select balance from hometown where username=\"" + username + "\" " + 
          "and password=\"" + password +"\""; 
  
       Statement stmt;
	
       try {
           Class.forName("org.gjt.mm.mysql.Driver");  
       } catch(java.lang.ClassNotFoundException e) {
	System.err.print("ClassNotFoundException: ");
	System.err.println(e.getMessage());
       }

        try {
            con = DriverManager.getConnection("jdbc:mysql:///bank","","");
            System.out.println("just after getConnection"); 
            stmt=con.createStatement();						
            ResultSet rs = stmt.executeQuery(query);
  
            if (rs.next()){
               balance = rs.getDouble("balance");
               System.out.println("just after getting balance:  balance= " + balance);
            }
            else {
               System.out.println("bad username or password");
            }
            stmt.close();
            con.close();

   

       } catch(SQLException ex) {
           System.err.print("SQLException: bozo");
           System.err.println(ex.getMessage());
       }
   return balance;

   }



   public int setBalance(double newbalance){
       System.out.println("inside setBalance.. newbalance=" + newbalance);
	
       Connection con;
       String updateString="update hometown set balance=" + newbalance +"  where " +
        " username=\"" + username + "\" and " +
        " password=\"" + password +"\"  ";
       Statement stmt=null;
	
       try {
           Class.forName("org.gjt.mm.mysql.Driver");  
       } catch(java.lang.ClassNotFoundException e) {
           System.err.print("ClassNotFoundException: ");
           System.err.println(e.getMessage());
       }
       try {
          con = DriverManager.getConnection("jdbc:mysql:///bank","","");
          System.out.println("just after getConnection"); 
          stmt = con.createStatement();

          stmt.executeUpdate(updateString);
        
          stmt.close();
          con.close();

       } catch(SQLException ex) {
          System.err.print("SQLException: ");
          System.err.println(ex.getMessage());
       }
     return 1;
  }// end setBalance member
	
	
  public String getUsername() { 
     return username;
  }
  public String getPassword() { 
     return password;
  }
  public double getAmount() { 
     return amount;
  }


}