Part I – Build a Customer Business Object . This class will have 6 properties, C

ID: 3586914 • Letter: P

Question

Part I – Build a Customer Business Object. This class will have 6 properties, CustId, CustPassword, CustFirstName, CustLastName, CustAddress and CustEmail. Build an empty args Constructor in the Customer class that initializes all properties to 0 or “”. Also build a constructor that takes all 6 args and set the appropriate properties. Then build the following 3 methods:

selectDB(custID); //to find a customer’s info in the DB

insertDB(custId, custPassword, custFirstName, custLastName, custAddress, custEmail) // to insert a new Customer in the DB

deleteDB(); //this method will delete the Customer from the DB

//so to check login execute the following code à

Customer c1 = new Customer(); //creates empty object

c1.selectDB(id); //does the DB lookup to find Customer

String pwdb = c1.getPassword();

if (pw.equals(pwdb)) { //this compares pw(from gui to the

//password from the database

//login correct

}

else {

//login incorrect

}

Now we are going to add to our Account Business Class . We need to add 2 methods:

deposit(amt); // adds the amt to the balance in the object and

// also updates the balance in the DB

withdraw(amt); //same as deposit above, except subtract

Account a1 = new Account();

//so to find an account in the database, call selectDB().

a1.selectDB(3001);

// so now to make a deposit we simply

a1.deposit(300.00);

// this method will display the new account balance

a1.display();

Part II – Now build an AccountList Business Class. This class will have a list of Account Objects. You can use an Array or an ArrayList to store this list. I would also have a count property to keep track of how many Accounts are in the list. Methods should include a display() method, and an add(Account a1) method.

Part II – Now build an Account Business Object. This class will have all of the database access code to lookup an Account in the database. Build a selectDB(acctNo) method in the Account class that accepts an integer acctNo. This method will then go to the database and find all information about the Account requested. Then, in the next lab, when our Servlet wants to find an Account in the DB, all we have to do is à

Account a1 = new Account();

a1.selectDB(acctNo);

abalance = a1.getBalance();

Part III – Now add a new Property to the Customer class.

AccountList aList;

Make it so that when an User calls the selectDB(3001) method(and passes a custid), the Customer class will go look in the database for all accounts that belong to this customer and put them in the use the aList object. So the Customer class will contain a list of Accounts that the customer owns

It has to be working….Take screenshots.

Explanation / Answer

Please copy the below code in java classes

CustomerBusiness.java

package com.bank;

import java.util.List;

public class CustomerBusiness {

private int CustId;

private String CustPassword;

private String CustFirstName;

private String CustLastName;

private String CustAddress;

private String CustEmail;

public int getCustId() {

return CustId;

}

public void setCustId(int custId) {

CustId = custId;

}

public String getCustPassword() {

return CustPassword;

}

public void setCustPassword(String custPassword) {

CustPassword = custPassword;

}

public String getCustFirstName() {

return CustFirstName;

}

public void setCustFirstName(String custFirstName) {

CustFirstName = custFirstName;

}

public String getCustLastName() {

return CustLastName;

}

public void setCustLastName(String custLastName) {

CustLastName = custLastName;

}

public String getCustAddress() {

return CustAddress;

}

public void setCustAddress(String custAddress) {

CustAddress = custAddress;

}

public String getCustEmail() {

return CustEmail;

}

public void setCustEmail(String custEmail) {

CustEmail = custEmail;

}

public CustomerBusiness(int custId, String custPassword, String custFirstName, String custLastName,

String custAddress, String custEmail) {

super();

CustId = custId;

CustPassword = custPassword;

CustFirstName = custFirstName;

CustLastName = custLastName;

CustAddress = custAddress;

CustEmail = custEmail;

}

public CustomerBusiness(){

super();

CustId = 0;

CustPassword = "";

CustFirstName = "";

CustLastName = "";

CustAddress = "";

CustEmail = "";

}

public void insertDb(int custId, String custPassword, String custFirstName, String custLastName,

String custAddress, String custEmail){

}

public String deleteDb(int custId){

return null;

}

public List<CustomerBusiness> selectDb(int custId){

return null;

}

AccountBusiness.java

package com.bank;

public class AccountBusiness {

public String deposit(double amt){

return null;

}

public String withdraw(double amt){

return null;

}

public double getBalance(int acctid){

return 0;

}

Customer.java

package com.bank;

import java.util.List;

public class Customer {

CustomerBusiness c1 = new CustomerBusiness();

AccountList alist;

public boolean validatePassword(int custid,String passwordUser){

List<CustomerBusiness> mylist= c1.selectDb(101);

if(!mylist.isEmpty()){

String password = mylist.get(0).getCustPassword();

if(password.equals(passwordUser)){

//valid log in

return true;

}else{

return false;

//invalid login

}

return false;

}

Account.java

package com.bank;

import java.util.List;

public class Account {

private int acctId;

private double Balance;

private int custId;

public int getAcctId() {

return acctId;

}

public void setAcctId(int acctId) {

this.acctId = acctId;

}

public double getBalance() {

return Balance;

}

public void setBalance(double balance) {

Balance = balance;

}

public int getCustId() {

return custId;

}

public void setCustId(int custId) {

this.custId = custId;

}

AccountBusiness ab = new AccountBusiness();

public List<Account> selectDb(int acctid){

ab.deposit(100.00);

return null;

}

public void Display(){

System.out.println("display all balances");

}

AccountList.java

package com.bank;

public class AccountList {

public void addAcount(Account a1){

}

public void display(int custid){

System.out.println("arraylist to display all");

}

Loginpage.jsp

<%@ page language="java" contentType="text/html; charset=ISO-8859-1"
pageEncoding="ISO-8859-1"%>
<!DOCTYPE html PUBLIC "-//W3C//DTD HTML 4.01 Transitional//EN" "http://www.w3.org/TR/html4/loose.dtd">
<html>
<head>
<meta http-equiv="Content-Type" content="text/html; charset=ISO-8859-1">
<title>Insert title here</title>
</head>
<body>

<form name="custForm" action="/Login">
CutomerId:<input type="text" name="custid" /><br/>
password:<input type="password" name="password" /><br/>
<input type="submit" name="submit"/>
</form>

</body>
</html>

LoginServlet.java

package com.bank;

import java.io.IOException;

import javax.servlet.Servlet;

import javax.servlet.ServletConfig;

import javax.servlet.ServletException;

import javax.servlet.ServletRequest;

import javax.servlet.ServletResponse;

import javax.servlet.http.HttpServlet;

public class LoginServlet implements Servlet{

@Override

public void destroy() {