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

Java开发网

您没有登录

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

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

作者

英国一公司招聘考题(1)

brolinuk

发贴: 6
积分: 0

于 2006-02-03 13:15

Part One

Given the following 2 databases, on different servers:

The accounts database
account table
-----------------------------
id Number
customer_name Varchar2
revenue Number

The customer database
custermor table
-----------------------------
id Number
name Varchar2
address Varchar2
Country Varchar2

contact table
--------------------------------
id Number
sex Char
email Varchar2
customer_id (fk) varchar2
department varchar2

and knowing that the accounts database uses the name from the customer table as the identifier;

Create a data loading application that conforms to the following simple specification.

You are provided with a ‘connector’ object
Connector
----------------------
connect(): void
load(data: java.util.map):boolean

which handles connection and loading of the data – (connect has a tendency to throw Exceptions. Load will return true if it succeeds)

The user will want to specify the databases from which the data will come.
Take the data from these two databases, create a map where the key is “database.table.fieldname” and the value is the value of the column, one map for each row.

Also, the user wants to enable loading from a file for testing purposes.

The data needs to be validated – we don’t want to load anything with a zero revenue or an invalid email address, and we want to convert univ. to university in any of the customer names.

Make sure the application logs any invalid data in a way that a data admin will be able to locate and correct it.

• JCheckBox array 问题

话题树型展开

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

已读帖子

新的帖子

被删除的帖子