Java开发网 - Re:英国一公司招聘考题(1)

Java开发网

您没有登录

» Java开发网 » Java SE 综合讨论区

打印话题 寄给朋友 订阅主题

作者

Re:英国一公司招聘考题(1) [Re:brolinuk]

brolinuk

发贴: 6
积分: 0

于 2006-02-03 14:07

Part Two

The business users then decide that they want a Web front-end to the customer and account databases, covering simplified data entry.

You will need three data entry screens
1)  customer
2)  customer contact
3)  create account for customer

the page flow being: create or find a customer, add or update contact, add or update account.

The customer screen will show the contacts for that customer, and the accounts for that customer, with the tools to add or update the customer, contact or account.

On the addition or update of an account you will want to ‘fire’ the data loading application written previously, ensuring the integrity of the system.

The reporting screen will allow you to query by customer, contact or account. Searching will give you a list of customers; clicking on the name will take you through to the customer screen.

Other reports required are:
1)  a list of all customers and their contacts (regardless of whether they have contacts)
2)  a list of all customers without contacts
3)  a list of the customers with a count of contacts for that customer
4) a count of customers by country

This application will have to be password protected.

Outline your design for this application – illustrate this with snippets of java code as you think necessary. Point out any choices you make and why you made them.

Show the SQL you would use in each reporting screen.

Provide the DDL for the schema (in whichever dialect you use)

For the contact table, say whether or not each field is a candidate for a key and why.

• 自己设计的一个java小管理程序

话题树型展开

人气	标题	作者	字数	发贴时间
4985	英国一公司招聘考题(1)	brolinuk	1733	2006-02-03 13:15
4025	Re:英国一公司招聘考题(1)	brolinuk	303	2006-02-03 13:22
3791	Re:英国一公司招聘考题(1)	ranchgirl	175	2006-02-03 13:37
4130	Re:英国一公司招聘考题(1)	brolinuk	1575	2006-02-03 14:07

已读帖子

新的帖子

被删除的帖子