Banking database system - java database connectivity, JAVA Programming

Assignment Help:

JDBC Assignment

Banking Database System:

BankCustomer
CUST_ID	CUST_NAME	ADDRESS	ACC_TYPE

CUST_ID : customer identification number [primary key]

NAME : Name of the customer

ADDRESS : Address of the Customer

ACC_TYPE : Account type i.e savings/current

CustomerAccount
CUST_ID	BALANCE

CUST_ID : customer identification number [foreign key]

BALANCE : account balance

By using above tables write a Program to cover all the below operations

1. Find customer details of the given customer account

2. Get balance of the given customer account

3. Deposit amount into the given customer account

4. Withdraw amount from the given customer account (minimum balance should be 1000)

5. Show all the customer details and account balances

Related Discussions:- Banking database system - java database connectivity

Describe validate() and reset() methods, Validate() : Used to validate prop...

Validate() : Used to validate properties after they have been populated; known as before FormBean is handed to Action. Returns a collection of ActionError as ActionErrors. Followin

Collections, Employee get data from console

Employee get data from console

Preventing applet based social engineering attacks, Preventing Applet Based...

Preventing Applet Based Social Engineering Attacks To help avoid this, Java applet windows are specifically labeled as such along with an ugly bar that says: "Warning: Applet W

Need help, please fix polygon method, code below: /** * @(#)AnimationExtr...

please fix polygon method, code below: /** * @(#)AnimationExtraCredit.java * * AnimationExtraCredit Applet application * * @author * @version 1.00 2013/5/5 */ import jav

Inheritance, Your task for this assignment is to define multiple classes vi...

Your task for this assignment is to define multiple classes via inheritance. Your classes should implement various "snacks" including "M&Ms", "Popcorn", etc. To begin, create an a

I want school management project, I want School Management project Proje...

I want School Management project Project Description: An easy school management project which able to store all data about students like fees structure, admission details and

Compare an abstract class and an interface , You want the base class to rep...

You want the base class to represent only an interface for its derived classes. That means, you don't want anyone to actually instantiate an object of the parent class. You only

MiscCollectionSolution, How do you set up a nested class?

How do you set up a nested class?

Define the difference between stringbuffer and string class, Define the dif...

Define the difference between StringBuffer and String class ?

Relate java with C/C++, Relate Java with C/C++ Very similar C/C++ synta...

Relate Java with C/C++ Very similar C/C++ syntax, operators, etc. Core language is simpler than C++ -- no pointers, no operator overloading, and no multiple inheritance.

Write Your Message!

Name

Email id

Message

Verfication Code

User Account

All Pages