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:

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

            To Test the selectDB() method use this code in the main():

                             Customer c1 = new Customer();

                   c1.selectDB(custId);

                   c1.display();

2.   insertDB(custId, custPassword, custFirstName, custLastName, custAddress, custEmail) // to insert a new Customer in the DB
3.   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 (pwgui.equals(pwdb)) { //this compares pw(from gui to the

      //password from the database

                              //login correct

          }       

          else {

                             //login incorrect

          }

Part II – Now build an Account Business Object. This class will have 4 properties, acctNo, custId, type and balance. Build an empty args Constructor in the Customer class that initializes all properties to 0 or “”. Also build a constructor that takes all 4 args and set the appropriate properties. Then build the following 3 methods:

1.   selectDB(acctNo);   //to find a account’s info in the DB
2.   insertDB(aNo, cid, ty, bal) // to insert a new Account into the DB
3.   deleteDB();   //this method will delete the current Cust from the DB

            To Test the selectDB() method use this code in the main():

                   Account a1 = new Account();

                   a1.selectDB(acctNo);

                   a1.display();

Answer 1

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() {

}

@Override

public ServletConfig getServletConfig() {

return null;

}

@Override

public String getServletInfo() {

return null;

}

@Override

public void init(ServletConfig arg0) throws ServletException {

}

@Override

public void service(ServletRequest request, ServletResponse response) throws ServletException, IOException {

int custid = Integer.parseInt(request.getParameter("custid"));

String password = request.getParameter("password");

Customer c1=new Customer();

if(c1.validatePassword(custid,password)){

}else{

}

}

}

web.xml

<?xml version="1.0" encoding="UTF-8"?>
<web-app xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance" xmlns="http://xmlns.jcp.org/xml/ns/javaee" xsi:schemaLocation="http://xmlns.jcp.org/xml/ns/javaee http://xmlns.jcp.org/xml/ns/javaee/web-app_3_1.xsd" id="WebApp_ID" version="3.1">
<display-name>BankAccounts</display-name>
<welcome-file-list>
<welcome-file>index.html</welcome-file>
<welcome-file>index.htm</welcome-file>
<welcome-file>index.jsp</welcome-file>
<welcome-file>default.html</welcome-file>
<welcome-file>default.htm</welcome-file>
<welcome-file>default.jsp</welcome-file>
</welcome-file-list>
  
<servlet>
<servlet-name>LoginServlet</servlet-name>
<servlet-class>com.bank.LoginServlet</servlet-class>
</servlet>

<servlet-mapping>
<servlet-name>LoginServlet</servlet-name>
<url-pattern>/Login</url-pattern>
</servlet-mapping>
</web-app>