Banking database system - java database connectivity, JAVA Programming

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

 

Posted Date: 3/28/2013 2:09:52 AM | Location : United States







Related Discussions:- Banking database system - java database connectivity, Assignment Help, Ask Question on Banking database system - java database connectivity, Get Answer, Expert's Help, Banking database system - java database connectivity Discussions

Write discussion on Banking database system - java database connectivity
Your posts are moderated
Related Questions
Explain the char data type in java? A char is a single character in which a letter, a digit, a punctuation mark, a tab, a space or something same. A char literal is a single on

BeanFactory has many executions in Spring. But one of the most useful one is org.springframework.beans.factory.xml.XmlBeanFactory, which loads its beans based on the definitions ha

write a program that count the number of occurences of string in the n-th padovan string p(n)   program in java // aakash , suraj , prem sasi kumar kamaraj college progr

The basic system has to offer the following options: 1. Exit the program 2. Enter new customer The program prompts for the details of a new customer, assigns a unique cust

List the keywords which are used in java 1.1? The list of keywords which are used in java 1.1 are given below: Keyword Purpose boole

ActionServlet performs the role of Controller: ? Process user requests ? Verify what the user is trying to achieve according to the request ? Pull data from the model (if

What are the kinds of computer network according to the distance among nodes? the kinds of computer network according to the distance among nodes are as follows: There are t

Need Java Assignment for course Project Description: I want to get an assignment done. Involves building on a minesweeper game written in Java. You subsequent code is to be u

Want a ANTI Iframe Breaker Project Description: I want an ANTI Iframe Breaker code made, so that if I'm iframing a site, that contains JavaScript, flash or otherwise, to forc

Write a program that uses one of the Map classes to implement a contact list. Contact information should include first name, last name, a phone number and an email address. The lis