Answered step by step
Verified Expert Solution
Link Copied!

Question

1 Approved Answer

I need help in Java, How can I code the following, I already have the other files, just need this one: Lastly code your LoanProcessing

I need help in Java,

How can I code the following, I already have the other files, just need this one:

Lastly code your LoanProcessing class file.

For your LoanProcessing source file make sure to extendBankRecords.

Include the following methods for your file.

Include in main() your readData() method call which will process your BankRecord objects. Theninstantiate a Dao object and trigger your createTable() method,your insertRecords(your BankRecords array object)method and retrieveRecords() method in that order. Of course you can comment out your createTable / insertRecords once youve accomplished that to test how your output statements appear. Logic for that follows next.

Once you have retrieved a recordset, print out all the records from the recordset to the console in a nice columnar format included with heading names for id, income and pep. Doesnt hurt to have a title too, like Loan Analysis Report.

Sample starter code for main (fill in code where comments are shown to do so):

BankRecords br = new BankRecords();

br.readData();

Dao dao = new Dao();

dao.createTable();

dao.insertRecords(robjs); // perform inserts

ResultSet rs = dao.retrieveRecords(); // fill result set object

// Create heading for display

// Extract data from result set

while (rs.next()) {

// Retrieve data by column name (i.e., for id,income,pep)

// Display values for id,income,pep

}

rs.close();// closes result set object

Extra Credit options

-Include SQL Prepared statements when inserting records (+5 points)

-Include besides console, output a JTable GUI output display of your recordset

data(+5 points)

For a JTable to trigger code, build a frame with Javax Swing components which will

display your loan data into a JTable.Column headings must be included as well as a

scrollbar for proper appearance of your display within a GUI frame showing your table

component.

Oryou for extra credit you may choose the following option

-Serialize and deserialize BankRecord objects using the java.util.Map class. (+10 points)

Name your serializable file bankrecords.ser. Make your application sleep for 5 seconds

between the processes. Display to the console the time difference between the serialization

and deserialization processes.?

The following is my bank records file:

import java.io.BufferedReader;

import java.io.FileNotFoundException;

import java.io.FileReader;

import java.io.IOException;

import java.util.ArrayList;

import java.util.Arrays;

import java.util.List;

public class BankRecords extends Client{

static BankRecords inforec[];

List> array = new ArrayList>();

//declaring variables

String id;

int age;

String gender;

double income;

String married;

int child;

String auto;

String save_act;

String current_act;

String mortage;

String savings;

String pep;

String region;

//Reads Data

void readData()

{

String Line = "";

try(BufferedReader br = new BufferedReader (new FileReader("D:/bank-Detail.csv")))

{

int i = 0;

while((Line = br.readLine()) != null)

{

array.add(Arrays.asList(Line.split(",")));

}

} catch (FileNotFoundException e) {

// TODO Auto-generated catch block

e.printStackTrace();

} catch (IOException e) {

// TODO Auto-generated catch block

e.printStackTrace();

}

processData();

}

public String getId() {

return id;

}

public void setId(String id) {

this.id = id;

}

public int getAge() {

return age;

}

public void setAge(int age) {

this.age = age;

}

public String getgender() {

return gender;

}

public void setgender(String gender) {

this.gender = gender;

}

public String getregion() {

return region;

}

public void setregion(String region) {

this.region = region;

}

public double getIncome() {

return income;

}

public void setIncome(double income) {

this.income = income;

}

public String getMarried() {

return married;

}

public void setMarried(String married) {

this.married = married;

}

public int getChild() {

return child;

}

public void setChild(int child) {

this.child = child;

}

public String getauto() {

return auto;

}

public void setauto(String auto) {

this.auto = auto;

}

public String getSave_act() {

return save_act;

}

public void setSave_act(String save_act) {

this.save_act = save_act;

}

public String getCurrent_act() {

return current_act;

}

public void setCurrent_act(String current_act) {

this.current_act = current_act;

}

public String getPep() {

return pep;

}

public void setPep(String pep) {

this.pep = pep;

}

public String getMortage() {

return mortage;

}

public void setMortage(String mortage) {

this.mortage = mortage;

}

public String getsavings() {

return savings;

}

public void setsavings(String savings) {

this.savings = savings;

}

// Process Data

void processData()

{

int i = 0;

inforec = new BankRecords[array.size()];

for(List row: array)

{

inforec[i] = new BankRecords();

inforec[i].setId(row.get(0));

inforec[i].setAge(Integer.parseInt(row.get(1)));

inforec[i].setgender(row.get(4));

inforec[i].setregion(row.get(5));

inforec[i].setIncome(Double.parseDouble(row.get(6)));

inforec[i].setMarried(row.get(6));

inforec[i].setChild(Integer.parseInt(row.get(6)));

inforec[i].setauto(row.get(9));

inforec[i].setSave_act(row.get(9));

inforec[i].setCurrent_act(row.get(9));

inforec[i].setMortage(row.get(12));

inforec[i].setsavings(row.get(12));

inforec[i].setPep(row.get(11));

i++;

}

//Data would be printed

}

void printData()

{

System.out.println("ID\t\tAge\t\tSex\t\tRegion\t\tIncome\t\tMortgage\tsavings" );

for (int i=0; i<=24; i++)

{

String Final = String.format( "%s\t\t%s\t\t%s\t\t%-10s\t%8.2f\t%s",inforec[i].getId(),inforec[i].getAge(),inforec[i].getgender(),

inforec[i].getregion(),inforec[i].getIncome(), inforec[i].getMortage());

System.out.println(Final);

}

}

public static void main(String[] args) throws IOException

{

BankRecords sc = new BankRecords();

sc.readData();

}

}

Client file:

public abstract class Client {

abstract void readData();

abstract void processData();

abstract void printData();

}

Step by Step Solution

There are 3 Steps involved in it

Step: 1

blur-text-image

Get Instant Access to Expert-Tailored Solutions

See step-by-step solutions with expert insights and AI powered tools for academic success

Step: 2

blur-text-image

Step: 3

blur-text-image

Ace Your Homework with AI

Get the answers you need in no time with our AI-driven, step-by-step assistance

Get Started

Recommended Textbook for

Databases Demystified

Authors: Andrew Oppel

1st Edition

0072253649, 9780072253641

Students also viewed these Databases questions

Question

Describe the importance of global talent management.

Answered: 1 week ago

Question

Summarize the environment of recruitment.

Answered: 1 week ago