1、 邮件数据记录了从客户发过来的邮件,通过已有邮件数据统计出活动的参与度,并从高到低排名。
2、提供统计数据下载功能,下载格式为excel格式。注意:大家需要用到jxl.jar开源包
3、 数据库连接(Oracle9i及以上
4、 初始Sql
create table mail(
mail_no number(8) not null primary key,
linked_event number(8),
send_from varchar2(50) not null,
cc varchar2(50) not null,
send_time date
);
create table event(
event_no number(8) not null primary key,
title varchar2(100),
invite_count number(8)
);
create table customer(
custom_no number(8) not null primary key,
name varchar2(100),
email varchar2(50)
);
create index idx_mail_customer on customer(email);
insert into mail values(1,1,'m1@sktelecom.com','m2@sktelecom.com',to_date('2007-01-01 11:10','YYYY-MM-DD HH24:MI:SS'));
insert into mail values(2,1,'m2@sktelecom.com','m1@sktelecom.com',to_date('2007-02-03 11:10','YYYY-MM-DD HH24:MI:SS'));
insert into mail values(3,2,'m3@sktelecom.com','m4@sktelecom.com',to_date('2007-03-04 11:10','YYYY-MM-DD HH24:MI:SS'));
insert into mail values(4,2,'m4@sktelecom.com','m2@sktelecom.com',to_date('2007-04-01 11:10','YYYY-MM-DD HH24:MI:SS'));
insert into mail values(5,2,'m1@sktelecom.com','m2@sktelecom.com',to_date('2007-05-01 11:10','YYYY-MM-DD HH24:MI:SS'));
insert into mail values(6,3,'m2@sktelecom.com','m4@sktelecom.com',to_date('2007-06-01 11:10','YYYY-MM-DD HH24:MI:SS'));
insert into mail values(7,3,'m4@sktelecom.com','m1@sktelecom.com',to_date('2007-07-01 11:10','YYYY-MM-DD HH24:MI:SS'));
commit;
insert into event values(1,'积分换礼品',10);
insert into event values(2,'欧洲10日游',3);
insert into event values(3,'免费国内机票',10);
commit;
insert into customer values(1,'汪振华','m1@sktelecom.com');
insert into customer values(2,'周伟','m2@sktelecom.com');
insert into customer values(3,'李用如','m3@sktelecom.com');
insert into customer values(4,'金泽龙','m4@sktelecom.com');
commit;