关闭

关于邮件统计与下载的题目

439人阅读 评论(0) 收藏 举报

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;

0
0

查看评论
* 以上用户言论只代表其个人观点,不代表CSDN网站的观点或立场
    个人资料
    • 访问:17497次
    • 积分:289
    • 等级:
    • 排名:千里之外
    • 原创:11篇
    • 转载:2篇
    • 译文:0篇
    • 评论:4条
    最新评论