qqmail.sql

运用JSP/servlet/JavaBean 技术

/*
MySQL Data Transfer
Source Host: localhost
Source Database: qqmail
Target Host: localhost
Target Database: qqmail
Date: 2008-07-27 上午 10:44:31
*/

SET FOREIGN_KEY_CHECKS=0;
-- ----------------------------
-- Table structure for t_contactperson
-- ----------------------------
DROP TABLE IF EXISTS `t_contactperson`;
CREATE TABLE `t_contactperson` (
  `autoId` int(4) NOT NULL auto_increment,
  `nickname` varchar(10) default NULL,
  `contactId` int(5) default NULL,
  `userId` int(5) default NULL,
  PRIMARY KEY  (`autoId`),
  KEY `contactId` (`contactId`),
  KEY `userId` (`userId`),
  CONSTRAINT `t_contactperson_ibfk_1` FOREIGN KEY (`contactId`) REFERENCES `t_user` (`userId`),
  CONSTRAINT `t_contactperson_ibfk_2` FOREIGN KEY (`userId`) REFERENCES `t_user` (`userId`)
) ENGINE=InnoDB AUTO_INCREMENT=13 DEFAULT CHARSET=utf8;

-- ----------------------------
-- Table structure for t_mail
-- ----------------------------
DROP TABLE IF EXISTS `t_mail`;
CREATE TABLE `t_mail` (
  `mailId` int(5) NOT NULL auto_increment,
  `mailStatus` int(1) NOT NULL,
  `mailTitle` varchar(40) default NULL,
  `mailContent` text,
  `userId` int(5) default NULL,
  `whoSended` int(5) default NULL,
  `whoReceive` int(5) default NULL,
  PRIMARY KEY  (`mailId`),
  KEY `userId` (`userId`),
  KEY `whoSended` (`whoSended`),
  KEY `whoReceive` (`whoReceive`),
  CONSTRAINT `t_mail_ibfk_1` FOREIGN KEY (`userId`) REFERENCES `t_user` (`userId`),
  CONSTRAINT `t_mail_ibfk_2` FOREIGN KEY (`whoSended`) REFERENCES `t_user` (`userId`),
  CONSTRAINT `t_mail_ibfk_3` FOREIGN KEY (`whoReceive`) REFERENCES `t_user` (`userId`)
) ENGINE=InnoDB AUTO_INCREMENT=17 DEFAULT CHARSET=utf8;

-- ----------------------------
-- Table structure for t_user
-- ----------------------------
DROP TABLE IF EXISTS `t_user`;
CREATE TABLE `t_user` (
  `userId` int(5) NOT NULL auto_increment,
  `emailName` varchar(18) NOT NULL,
  `password` varchar(20) character set utf8 collate utf8_bin NOT NULL,
  PRIMARY KEY  (`userId`),
  UNIQUE KEY `emailName` (`emailName`)
) ENGINE=InnoDB AUTO_INCREMENT=6 DEFAULT CHARSET=utf8;

-- ----------------------------
-- Records 
-- ----------------------------
INSERT INTO `t_contactperson` VALUES ('1', '鍐弓', '2', '1');
INSERT INTO `t_contactperson` VALUES ('2', '鑰佽檸', '3', '1');
INSERT INTO `t_contactperson` VALUES ('3', '鐗圭憺', '5', '1');
INSERT INTO `t_contactperson` VALUES ('4', '姹ょ背', '1', '2');
INSERT INTO `t_contactperson` VALUES ('5', '鎷夊皵澶?, '4', '2');
INSERT INTO `t_contactperson` VALUES ('6', '姹ょ背', '1', '3');
INSERT INTO `t_contactperson` VALUES ('7', 'RALF', '4', '3');
INSERT INTO `t_contactperson` VALUES ('8', 'Terry', '5', '3');
INSERT INTO `t_contactperson` VALUES ('9', 'F.L.', '2', '4');
INSERT INTO `t_contactperson` VALUES ('10', 'Tiger', '3', '4');
INSERT INTO `t_contactperson` VALUES ('11', '鍞愮背', '1', '5');
INSERT INTO `t_contactperson` VALUES ('12', '娉版牸', '3', '5');
INSERT INTO `t_mail` VALUES ('1', '0', '锛堟棤涓婚锛?, '鍐弓鎮ㄥソ锛乗r\n    鎴戞槸Tommy锛屾垜鐨勫悕瀛楀惉璧锋潵寰堢啛鎮夊惂锛熸病閿欙紝鎴戝氨鏄緺鐩楄溅鎵嬮噷鐨勪富瑙掋€?, '2', '1', '2');
INSERT INTO `t_mail` VALUES ('2', '3', '锛堟棤涓婚锛?, '鍐弓鎮ㄥソ锛乗r\n    鎴戞槸Tommy锛屾垜鐨勫悕瀛楀惉璧锋潵寰堢啛鎮夊惂锛熸病閿欙紝鎴戝氨鏄緺鐩楄溅鎵嬮噷鐨勪富瑙掋€?, '1', '1', '2');
INSERT INTO `t_mail` VALUES ('3', '0', 'i\'m tommy', 'Hi F.L.\r\n    Do you remeber me? yeah,Tommy,the heroic thief!', '2', '1', '2');
INSERT INTO `t_mail` VALUES ('4', '3', 'i\'m tommy', 'Hi F.L.\r\n    Do you remeber me? yeah,Tommy,the heroic thief!', '1', '1', '2');
INSERT INTO `t_mail` VALUES ('5', '1', '浣犲ソ鍐弓', '鎴戞槸Tommy锛屼綘杩樺ソ鍚楋紵濂戒箙娌℃湁鐜╀緺鐩楄溅鎵嬩簡鍟婏紵鏈夌┖灏辨潵瑙佽鎴戝惂锛屾垜閮介椃姝讳簡銆?, '2', '1', '2');
INSERT INTO `t_mail` VALUES ('6', '3', '浣犲ソ鍐弓', '鎴戞槸Tommy锛屼綘杩樺ソ鍚楋紵濂戒箙娌℃湁鐜╀緺鐩楄溅鎵嬩簡鍟婏紵鏈夌┖灏辨潵瑙佽鎴戝惂锛屾垜閮介椃姝讳簡銆?, '1', '1', '2');
INSERT INTO `t_mail` VALUES ('7', '1', '锛堟棤涓婚锛?, '浣犳槸璋佸皬瀛愶紵鎴戞槸鎷虫墜Terry锛屾垜鎬绘槸闂蹭笉浣忥紝甯屾湜閬囪瀵规墜锛屼綘鑳絇K鍢涳紵鏁㈡潵鍋氭垜鐨勫鎵嬪悧锛?, '2', '5', '2');
INSERT INTO `t_mail` VALUES ('8', '3', '锛堟棤涓婚锛?, '浣犳槸璋佸皬瀛愶紵鎴戞槸鎷虫墜Terry锛屾垜鎬绘槸闂蹭笉浣忥紝甯屾湜閬囪瀵规墜锛屼綘鑳絇K鍢涳紵鏁㈡潵鍋氭垜鐨勫鎵嬪悧锛?, '5', '5', '2');
INSERT INTO `t_mail` VALUES ('9', '0', '浣犲ソtommy', 'tommy浣犲ソ锛屾渶杩戞垜姣旇緝蹇欙紝瑕佸寰堝涓滆タ锛屾瘯绔熷湪涓浗锛屼汉澶氬矖浣嶅皯锛屽伐浣滀笉濂芥壘锛屼笉寰椾笉澶氬涔犲涔犮€傛湁绌烘垜鍐嶆潵鎵句綘鐜╁惂銆?, '1', '2', '1');
INSERT INTO `t_mail` VALUES ('10', '3', '浣犲ソtommy', 'tommy浣犲ソ锛屾渶杩戞垜姣旇緝蹇欙紝瑕佸寰堝涓滆タ锛屾瘯绔熷湪涓浗锛屼汉澶氬矖浣嶅皯锛屽伐浣滀笉濂芥壘锛屼笉寰椾笉澶氬涔犲涔犮€傛湁绌烘垜鍐嶆潵鎵句綘鐜╁惂銆?, '2', '2', '1');
INSERT INTO `t_mail` VALUES ('11', '0', 'Hi Terry', '浣犳槸KOF閲岀殑Terry鍚э紝鎴戝彲浠ュ仛浣犵殑瀵规墜锛岃鍛婁綘鎴戝彲鏄嫵鐨囬珮鎵嬶紝浣犳渶濂藉甫涓婁綘鐨勫厔寮烺alf杩樻湁浣犵殑闀垮畼涓€璧锋潵锛屽惁鍒欎細姝荤殑寰堟儴锛屽懙鍛碉紝鎭愭€曞甫涓婁粬浠篃娌℃湁浠€涔堟剰涔夛紝鍙槸澶氫簡涓や釜闄懍鐨勭舰浜嗭紝鎴戜細缁欎綘浠潵涓竴閽忎笁銆傚搱鍝垀~~', '5', '2', '5');
INSERT INTO `t_mail` VALUES ('12', '3', 'Hi Terry', '浣犳槸KOF閲岀殑Terry鍚э紝鎴戝彲浠ュ仛浣犵殑瀵规墜锛岃鍛婁綘鎴戝彲鏄嫵鐨囬珮鎵嬶紝浣犳渶濂藉甫涓婁綘鐨勫厔寮烺alf杩樻湁浣犵殑闀垮畼涓€璧锋潵锛屽惁鍒欎細姝荤殑寰堟儴锛屽懙鍛碉紝鎭愭€曞甫涓婁粬浠篃娌℃湁浠€涔堟剰涔夛紝鍙槸澶氫簡涓や釜闄懍鐨勭舰浜嗭紝鎴戜細缁欎綘浠潵涓竴閽忎笁銆傚搱鍝垀~~', '2', '2', '5');
INSERT INTO `t_mail` VALUES ('13', '2', '绉樼睄', 'tommy浣犲ソ锛屾渶杩戝惉璇翠綘鍦ㄤ綘鐨勪笘鐣岄噷杩囩殑寰堣緵鑻︼紝涓嶈鎷呭績锛屾垜鎵炬潵浜嗙绫嶏紝鎴戜細璁╀綘鍙樼殑寰堟湁閽辩殑锛屼笉杩囨垜鎯抽挶瀵逛綘娌℃湁澶ぇ鎰忎箟锛屼綘鐨勮溅閮芥槸鎶㈡潵鐨勶紝鎴垮瓙涔熶拱浜嗕笉灏戯紝浣犻渶瑕佺殑涓嶆槸閽卞惂锛屽惉璇翠綘浠府娲惧父甯歌楠氭壈锛屾垜浼氱粰浣犲紕瀛愯浆杞満鏋紝閭ｅ浼欏彲浠ユ妸鍧﹀厠涔熸墦鎴愯渹绐濈殑銆傚搱鍝堟€庝箞鏍枫€傞珮鍏村惂锛熸湁浠€涔堥渶瑕佸氨鍛婅瘔鎴戝惂锛屾垜鐨勬湅鍙嬶紒', '2', '2', '1');
INSERT INTO `t_mail` VALUES ('14', '2', '鎬曚簡鍚楋紵', '灏忓瓙锛屼綘鏋滅劧甯︿笂浜嗕笉灏戜汉鏉ワ紝鍙儨锛屾垜宸茬粡璀﹀憡杩囦綘锛屼綘娌℃湁鍚彇鍒汉鐨勫繝鍛婏紝杩欏氨鏄綘鐨勪笅鍦猴紝鎴戝彧闇€瑕佷竴涓汉灏卞彲浠ユ潃姝讳綘璁稿娆★紝甯屾湜浣犱笉瑕佸啀鐙傚鑷ぇ浜嗐€傝繖瀵逛綘鏄釜涓嶉敊鐨勬暀璁€?, '2', '2', '5');
INSERT INTO `t_mail` VALUES ('15', '0', '锛堟棤涓婚锛?, '浣犲ソ锛屾垜鏄啹楣紝浣犱笉璁よ瘑鎴戝惂锛熶笉瑕佹媴蹇冿紝鎴戞病鏈夋悶閿欙紝鎴戞兂璁よ瘑璁よ瘑浣犮€傚惉璇翠綘寰堝嚩鐚涳紝鏄惂锛熸垜寰堝枩娆㈡寫鎴橈紝鎯冲拰浣犱細浼氾紝浣犵湅鎬庝箞鏍凤紵绾︿釜鏃堕棿锛?, '3', '2', '3');
INSERT INTO `t_mail` VALUES ('16', '4', '锛堟棤涓婚锛?, '浣犲ソ锛屾垜鏄啹楣紝浣犱笉璁よ瘑鎴戝惂锛熶笉瑕佹媴蹇冿紝鎴戞病鏈夋悶閿欙紝鎴戞兂璁よ瘑璁よ瘑浣犮€傚惉璇翠綘寰堝嚩鐚涳紝鏄惂锛熸垜寰堝枩娆㈡寫鎴橈紝鎯冲拰浣犱細浼氾紝浣犵湅鎬庝箞鏍凤紵绾︿釜鏃堕棿锛?, '2', '2', '3');
INSERT INTO `t_user` VALUES ('1', 'tommy', 'Aa');
INSERT INTO `t_user` VALUES ('2', 'fenglu', '123');
INSERT INTO `t_user` VALUES ('3', 'tiger', 'tiger');
INSERT INTO `t_user` VALUES ('4', 'ralf', '123');
INSERT INTO `t_user` VALUES ('5', 'terry', '123');