StudyEnglish.sql

/*
SQLyog Ultimate v12.08 (64 bit)
MySQL - 8.0.18 : Database - studywords
*********************************************************************
*/

/*!40101 SET NAMES utf8 */;

/*!40101 SET SQL_MODE=''*/;

/*!40014 SET @OLD_UNIQUE_CHECKS=@@UNIQUE_CHECKS, UNIQUE_CHECKS=0 */;
/*!40014 SET @OLD_FOREIGN_KEY_CHECKS=@@FOREIGN_KEY_CHECKS, FOREIGN_KEY_CHECKS=0 */;
/*!40101 SET @OLD_SQL_MODE=@@SQL_MODE, SQL_MODE='NO_AUTO_VALUE_ON_ZERO' */;
/*!40111 SET @OLD_SQL_NOTES=@@SQL_NOTES, SQL_NOTES=0 */;
CREATE DATABASE /*!32312 IF NOT EXISTS*/`studywords` /*!40100 DEFAULT CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci */ /*!80016 DEFAULT ENCRYPTION='N' */;

USE `studywords`;

/*Table structure for table `book` */

DROP TABLE IF EXISTS `book`;

CREATE TABLE `book` (
  `bookId` int(11) NOT NULL AUTO_INCREMENT,
  `bookName` varchar(32) NOT NULL,
  `bookUser` varchar(32) DEFAULT NULL,
  `description` longtext,
  `content` longtext,
  PRIMARY KEY (`bookId`)
) ENGINE=InnoDB AUTO_INCREMENT=8 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci;

/*Data for the table `book` */

insert  into `book`(`bookId`,`bookName`,`bookUser`,`description`,`content`) values (1,'肖申克的救赎','斯蒂芬·埃德温·金','小说的背景是20世纪30年代，那时，“美国的政治腐败已经迟到了商人面前”，甚至波及到了监狱。故事中，年轻的银行家安迪因为妻子和她的情人被杀而被判无期徒刑，由于监狱的腐败，他在真相即将大白的情况下仍然得不到昭雪，反而在肖申克监狱饱受了各种精神上和肉体上的摧残。然而，安迪并没有被多舛的命运毁掉，他经过20多年水滴石穿般地不懈挖掘，终于在一个雷雨交加的夜晚，从500码长的污粪管道中爬出，重获自由，在墨西哥海边过上了自由人的生活','德弗瑞恩先生\r\nMr. Dufresne, describe...\r\n\r\n\r\n\r\n…描述一下你太太被谋杀当晚，你曾和她谈过些什么？\r\n...the confrontation you had with your wife the night she was murdered.\r\n\r\n\r\n\r\n一些很糟糕的话\r\nIt was very bitter.\r\n\r\n\r\n\r\n她说她很高兴我已知道，她不想再偷偷摸摸了\r\nShe said she was glad I knew, that she hated all the sneaking around.\r\n\r\n\r\n\r\n她说她想离婚\r\nAnd she said that she wanted a divorce in Reno.\r\n\r\n\r\n\r\n-你当时有什么反应？ -我对她说我不会在乎的\r\n- What was your response? - I told her I would not grant one.\r\n\r\n\r\n\r\n“在我看见你在雷诺市前，下地狱吧！”\r\n\"I\'ll see you in hell before I see you in Reno.\"\r\n\r\n\r\n\r\n你的邻居曾听你说过这些话吧？\r\nThose were your words, according to your neighbors.\r\n\r\n\r\n\r\n随他们怎么说\r\nIf they say so.\r\n\r\n\r\n\r\n我当时很不开心，什么都不记得了\r\nI really don\'t remember. I was upset.\r\n\r\n\r\n\r\n你和太太争吵后发生了什么事？\r\nWhat happened after you argued with your wife?\r\n\r\n\r\n\r\n她收拾好行李\r\nShe packed a bag.\r\n\r\n\r\n\r\n到昆汀先生家里去了\r\nShe packed a bag to go and stay with Mr. Quentin.\r\n\r\n\r\n\r\n格伦·昆汀，职业高尔夫教练\r\nGlenn Quentin, golf pro at the Snowden Hills Country Club...\r\n\r\n\r\n\r\n你知道他是你妻子的情人\r\n... whom you had discovered was your wife\'s lover.\r\n\r\n\r\n\r\n你跟踪她了吗？\r\nDid you follow her?\r\n\r\n\r\n\r\n我先去了几间酒吧找\r\nI went to a few bars first.\r\n\r\n\r\n\r\n接着，我开车去了昆汀家，但他们不在家里\r\nLater, I drove to his house to confront them. They weren\'t home.\r\n\r\n\r\n\r\n我把车停在街角\r\nI parked in the turnout...\r\n\r\n\r\n\r\n等在那里\r\n... and waited.\r\n\r\n\r\n\r\n有何企图吗？\r\nWith what intention?\r\n\r\n\r\n\r\n我不太确定\r\nI\'m not sure.\r\n\r\n\r\n\r\n我非常困惑\r\nI was confused...\r\n\r\n\r\n\r\n还有点醉\r\n... drunk.\r\n\r\n\r\n\r\n我觉得\r\nI think...\r\n\r\n\r\n\r\n我只是想吓一吓他们\r\n... mostly I wanted to scare them.\r\n\r\n\r\n\r\n他们到家后，你就进屋杀了他们\r\nWhen they arrived, you went up to the house and murdered them.\r\n\r\n\r\n\r\n没有，我控制了自己\r\nI was sobering up.\r\n\r\n\r\n\r\n我开车回家睡觉来忘记一切\r\nI got back in the car and I drove home to sleep it off.\r\n\r\n\r\n\r\n在回家的路上，我把枪扔进了河里\r\nAlong the way, I threw my gun into the Royal River.\r\n\r\n\r\n\r\n我很肯定这一点\r\nI\'ve been very clear on this point.\r\n\r\n\r\n\r\n但我感到奇怪的是，第二天早上清洁女工发现……\r\nI get hazy where the cleaning woman shows up the following morning...\r\n\r\n\r\n\r\n你太太和她的情人死在床上\r\n...and finds your wife in bed with her lover...\r\n\r\n\r\n\r\n致死的子弹是出自点38口径的手枪\r\n...riddled with.38-caliber bullets.\r\n\r\n\r\n\r\n德福瑞恩先生，你和我一样都觉得那是巧合吗？\r\nDoes that strike you as a fantastic coincidence, or is it just me?\r\n\r\n\r\n\r\n确实是巧合\r\nYes, it does.\r\n\r\n\r\n\r\n你仍坚持说你在凶案发生前\r\nYet you still maintain you threw your gun into the river...\r\n\r\n\r\n\r\n已经把枪扔进河里了吗？\r\n...before the murders took place.\r\n\r\n\r\n\r\n这对你很有利\r\nThat\'s very convenient.\r\n\r\n\r\n\r\n这是事实\r\nIt\'s the truth.'),(2,'泰坦尼克号','舒特斯曼','一艘船。\r\n　　梦幻之旅。\r\n　　巨大、气派、豪华。\r\n　　彩带飘舞、彩旗飞扬。鼓乐喧天、人声鼎沸。\r\n　　画面所具有的色彩只存在于我们的感觉里，而展现在我们面前的是单一的黄颜色，仿佛是过去多少岁月的老照片、经过无数春秋的陈年旧物。我们似乎可以拂去岁月的灰尘，历数春秋的时日，重新去领略那昔日的梦里情怀。\r\n　　《我心永恒》（《MyHeartGoOn》）—一曲女声的歌，似从九天而来，带着一种空蒙、辽阔的豪放之感，在我们耳际回响。歌声起伏跌宕、籁鸣啸天，却又缠绵悱侧、千回百转...','还有十三米 你应该看到了\r\n13 meters. You should see it.\r\n\r\n\r\n\r\n好的 把它开到艏栏上面去\r\nOkay, take her up and over the bow rail.\r\n\r\n\r\n\r\n和平二号 我们正越过艏栏 跟住了\r\nMir 2, we\'re going over the bow. Stay with us.\r\n\r\n\r\n\r\n好的安静 我们开始拍摄了\r\nOkay, quiet. We\'re rolling.\r\n\r\n\r\n\r\n看着她如幽灵船般从黑暗中浮现…\r\nSeeing her coming out of the darkness like a ghost\r\n\r\n\r\n\r\n每次都让我心动\r\nstill gets me every time.\r\n\r\n\r\n\r\n这艘巨轮的残骸就这样伏在她…\r\nTo see the sad ruin of the great ship sitting here...\r\n\r\n\r\n\r\n一九一二年四月十五日\r\nwhere she landed at 2:30 in the morning\r\n\r\n\r\n\r\n凌晨两点三十…\r\nof April 15, 1912...\r\n\r\n\r\n\r\n从海面慢慢…\r\nafter her long fall...\r\n\r\n\r\n\r\n坠落下来的地方\r\nfrom the world above.\r\n\r\n\r\n\r\n老大 你废话真多\r\nYou are so full of shit, boss.\r\n\r\n\r\n\r\n第六次下潜 我们又来到了泰坦尼克号的甲板上\r\nDive 6. Here we are again on the deck of\r\n\r\n\r\n\r\n水下二点五英里 三千八百二十一米\r\n21/2 miles down. 3,821 meters.\r\n\r\n\r\n\r\n外部压力为每平方英寸三点五吨\r\nThe pressure outside is 31/2 tons per square inch.\r\n\r\n\r\n\r\n这些窗户有九英寸厚\r\nThese windows are 9 inches thick.\r\n\r\n\r\n\r\n如果没了它们 一眨眼我们就拜拜了\r\nIf they go, it\'s sayonara in two microseconds.\r\n\r\n\r\n\r\n行了 废话够多了\r\nAll right, enough of that bullshit.\r\n\r\n\r\n\r\n跟昨天一样 把她停在船长室上面\r\nJust put her down on the roof of the officers\' quarters\r\n\r\n\r\n\r\n和平二号 我们正着陆在大阶梯上方 你们准备好了吗？\r\nMir 2, we\'re landing right over the\r\n\r\n\r\n\r\n好的布洛克 正在释放邓金 开始吧 查理\r\nYeah, Brock. Launching Dunkin now. Go, Charlie.\r\n\r\n\r\n\r\n- 好的 拖绳已释放  - 拖绳已释放\r\n- All right, tether out.  - Tether out.\r\n\r\n\r\n\r\n好了布洛克 我们正在沿着船体向下移动\r\nOkay, Brock, we\'re dropping down along the hull.\r\n\r\n\r\n\r\n好的明白 向下并从头等舱通道门进入\r\nYeah, roger that. Okay, drop down and go into the\r\n\r\n\r\n\r\n我要你们搜索D层…\r\nI want you guys working the D deck...\r\n\r\n\r\n\r\n接待处和餐厅\r\nreception area and the dining saloon.\r\n\r\n\r\n\r\n收到\r\nCopy that.\r\n\r\n\r\n\r\n- 释放拖绳 好 现在向左 向左  - 好的 从左面进去\r\n- Tether out. Okay, now left. Left,\r\n\r\n\r\n\r\n“史努比”号探测器开始下潜 我们沿着楼梯往下\r\nSnoop Dog is on the move. We\'re headed down\r\n\r\n\r\n\r\n好的刘易斯 下潜到B层\r\nOkay Lewis, drop down to B deck.\r\n\r\n\r\n\r\n- 好 A层了  - 老大 再放一点拖绳\r\n- Okay, A deck.  - Give me some rope, Captain.\r\n\r\n\r\n\r\nB层 进去 进去\r\nB deck. Get in there. Get in there.\r\n\r\n\r\n\r\n小心门框\r\nWatch the door frame.\r\n\r\n\r\n\r\n- 当心 当心  - 我看到了 没事\r\n- Watch it, watch it.  - I see it. I got it.\r\n\r\n\r\n\r\n- 一切都好吧？往下一点  - 我们没问题 老大 冷静点\r\n- We good? Bring her down.  - We\'re\r\n\r\n\r\n\r\n好的 转向\r\nOkay, make your turn.\r\n\r\n\r\n\r\n- 拖绳到头了 老大  - 转过去 注意墙壁\r\n- Cable out, Captain.  - Make your turn. Watch the\r\n\r\n\r\n\r\n布洛克 我们在钢琴这里 收到了吗？\r\nYeah Brock, we\'re at the piano. You copy?\r\n\r\n\r\n\r\n恩 收到了\r\nOkay, copy that.\r\n\r\n\r\n\r\n好的 就那里 就那里\r\nOkay, right there. Right there.\r\n\r\n\r\n\r\n好的就是它 就是那里 那是卧室的门\r\nOkay, that\'s it, that\'s it. That\'s the bedroom door.\r\n\r\n\r\n\r\n看到了 我看到了\r\nI see it. I see it.\r\n\r\n\r\n\r\n我们进去了！\r\nWe\'re in!\r\n\r\n\r\n\r\n进去了 宝贝儿 我们到了\r\nWe\'re in, baby. We\'re there.\r\n\r\n\r\n\r\n那是霍克利的床\r\nThat\'s Hockley\'s bed.\r\n\r\n\r\n\r\n那狗娘养的就睡这里啊\r\nThat\'s where the son of a bitch slept.\r\n\r\n\r\n\r\n唉哟 水龙头好像开着哦\r\nOops. Somebody left the water running.\r\n\r\n\r\n\r\n等一下等一下 回到右边\r\nHold it. Hold it just a second. Go back to the right.\r\n\r\n\r\n\r\n那个衣柜门 靠近点\r\nThat wardrobe door. Get closer.\r\n\r\n\r\n\r\n老大 你感觉到什么了吗？\r\nYou smelling something, boss?\r\n\r\n\r\n\r\n- 我想看看下面有什么  - 把机械臂放出来\r\n- I want to see what\'s under it.  - Give me my\r\n\r\n\r\n\r\n好\r\nAll right.'),(3,'阿甘正传','温斯顿·格鲁姆','阿甘是常人眼中的弱智和白痴，但他天性善良单纯，加上天赋异禀，使他先后成为大学美式橄榄球明星、越战英雄、世界级乒乓球运动员、摔跤选手、国际象棋大师和商业大亨，获得肯尼迪总统的接见，约翰逊总统的授勋，甚至还无意间发现了水门事件的真相。阿甘“轰轰烈烈”的传奇一生，看似荒诞不经，其实正是美国20世纪50年代到70年代历史与社会的缩影，透过阿甘的眼睛，也让我们看到了世态的险恶复杂与庸俗市侩，而更觉人性真诚的可贵。','你好\r\nHello.\r\n\r\n我叫弗里斯特  弗里斯特·甘\r\nMy name\'s Forrest. Forrest Gump.\r\n\r\n\r\n\r\n你想吃一块巧克力吗\r\nDo you want a chocolate?\r\n\r\n\r\n\r\n我可以吃下150万块这东西\r\nI could eat about a million and a half of these.\r\n\r\n\r\n\r\n我妈妈总是说\r\nMy mama always said\r\n\r\n\r\n\r\n生活就像一盒巧克力\r\nlife was like a box of chocolates.\r\n\r\n\r\n\r\n你永远不知道你将得到什么\r\nYou never know what you\'re gonna get.\r\n\r\n\r\n\r\n你这双鞋一定很舒服\r\nThose must be comfortable shoes.\r\n\r\n\r\n\r\n我猜穿着这种鞋\r\nI\'ll bet you could walk all day\r\n\r\n\r\n\r\n走一整天都不会累\r\nin shoes like that and not feel a thing.\r\n\r\n\r\n\r\n我也想要那样的鞋\r\nI wish I had shoes like that.\r\n\r\n\r\n\r\n我的脚很疼\r\nMy feet hurt.\r\n\r\n\r\n\r\n妈妈总是说\r\nMama always said\r\n\r\n\r\n\r\n你可以通过鞋来了解一个人的很多方面\r\nthere\'s an awful lot you could tell about a person by their shoes:\r\n\r\n\r\n\r\n他们要去哪儿  他们去过哪儿\r\nwhere they\'re going, where they\'ve been.\r\n\r\n\r\n\r\n我穿坏过很多双鞋\r\nI\'ve worn lots of shoes.\r\n\r\n\r\n\r\n我猜如果我仔细想想\r\nI bet if I think about it real hard,\r\n\r\n\r\n\r\n就能想起我的第一双鞋\r\nI could remember my first pair of shoes.\r\n\r\n\r\n\r\n妈妈说它们能带我去任何地方\r\nMama said they\'d take me anywhere.\r\n\r\n\r\n\r\n她说它们是我的魔法鞋子\r\nShe said they was my magic shoes.\r\n\r\n\r\n\r\n好了  弗里斯特  你可以睁开眼睛了\r\nAll right, Forrest, you can open your eyes now.\r\n\r\n\r\n\r\n走一走试试看\r\nLet\'s take a little walk around.\r\n\r\n\r\n\r\n感觉怎么样\r\nHow do those feel?\r\n\r\n\r\n\r\n他的腿很强壮  甘夫人\r\nHis legs are strong, Mrs. Gump,\r\n\r\n\r\n\r\n是我见过最强壮的\r\nas strong as I\'ve ever seen,\r\n\r\n\r\n\r\n但是他的脊背像政客一样扭曲\r\nbut his back is as crooked as a politician.\r\n\r\n\r\n\r\n不过我们会把他扳直的  对吧  弗里斯特\r\nBut we\'re gonna straighten him right up, now, aren\'t we, Forrest?\r\n\r\n\r\n\r\n弗里斯特\r\nForrest!\r\n\r\n\r\n\r\n我还是婴儿的时候\r\nNow, when I was a baby,\r\n\r\n\r\n\r\n妈妈用南北战争时期伟大的英雄\r\nMama named me after the great Civil War hero,\r\n\r\n\r\n\r\n内森·弗里斯特将军的名字给我取了名\r\nGeneral Nathan Bedford Forrest.\r\n\r\n\r\n\r\n她说我们和他有什么亲缘关系\r\nShe said we was related to him in some way.\r\n\r\n\r\n\r\n他做过的事情是\r\nAnd what he did was,\r\n\r\n\r\n\r\n他创建了一个叫三K党的俱乐部\r\nhe started up this club called the Ku Klux Klan.\r\n\r\n\r\n\r\n他们都披着长袍和床单\r\nThey\'d all dress up in their robes and their bed sheets\r\n\r\n\r\n\r\n表现得像鬼魂或幽灵之类的\r\nand act like a bunch of ghosts or spooks or something.\r\n\r\n\r\n\r\n他们甚至给马披上床单  骑着到处跑\r\nThey\'d even put bed sheets on their horses and ride around.\r\n\r\n\r\n\r\n不管怎样  我的名字就是这么来的\r\nAnd anyway, that\'s how I got my name,\r\n\r\n\r\n\r\n弗里斯特·甘\r\nForrest Gump.\r\n\r\n\r\n\r\n妈妈说\"弗里斯特\"这个名字\r\nMama said that the \"Forrest\" part\r\n\r\n\r\n\r\n是用来提醒我  有时候我们都会做\r\nwas to remind me that sometimes we all do things that,\r\n\r\n\r\n\r\n没有道理的事\r\nwell, just don\'t make no sense.\r\n\r\n\r\n\r\n好了  出来  出来\r\nOkay... Get it, get it...\r\n\r\n\r\n\r\n等等  是这边吗  等一下\r\nWait, is it this way? Hold on.\r\n\r\n\r\n\r\n好了\r\nAll right...\r\n                             ');

/*Table structure for table `grade` */

DROP TABLE IF EXISTS `grade`;

CREATE TABLE `grade` (
  `gradeId` int(4) NOT NULL,
  `gradeName` varchar(32) NOT NULL,
  PRIMARY KEY (`gradeId`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8;

/*Data for the table `grade` */

insert  into `grade`(`gradeId`,`gradeName`) values (1,'四级'),(2,'六级');

/*Table structure for table `listen` */

DROP TABLE IF EXISTS `listen`;

CREATE TABLE `listen` (
  `listenId` int(11) NOT NULL,
  `listenName` varchar(32) DEFAULT NULL,
  `path` varchar(32) DEFAULT NULL,
  `content` longtext,
  `grade` int(11) DEFAULT NULL,
  PRIMARY KEY (`listenId`),
  KEY `listen_grade_fk` (`grade`),
  CONSTRAINT `listen_grade_gradeId_fk` FOREIGN KEY (`grade`) REFERENCES `grade` (`gradeId`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci;

/*Data for the table `listen` */

insert  into `listen`(`listenId`,`listenName`,`path`,`content`,`grade`) values (1,'2019年6月英语四级听力真题第1套','cet4-201906-1.mp3','Section A News Report\r\nDirections： In this section， you will hear three news reports。 At the end of each news report， you will hear two or three questions。 Both the news report and the questions will be spoken only once。 After you hear a question， you must choose the best answer from the four choices marked A）， B）， C） and D）。 Then mark the corresponding letter on Answer Sheet 1 with a single line through the centre。\r\n\r\nQuestions 1 and 2 are based on the news report you have just heard.\r\n1. A) He set a record by swimming to and from an island.\r\nB) He celebrated his ninth birthday on a small island.\r\nC) He visited a prison located on a faraway island.\r\nD) He swam around an island near San Francisco.\r\n2. A) He doubled the reward.\r\nB) He cheered him on all the way.\r\nC) He set him an example.\r\nD) He had the event covered on TV.\r\n\r\nQuestions 3 and 4 are based on the news report you have just heard.\r\n3. A) To end the one-child policy.\r\nB) To encourage late marriage.\r\nC) To increase working efficiency.\r\nD) To give people more time to travel.\r\n4. A) They will not be welcomed by young people.\r\nB) They will help to popularize early marriage.\r\nC) They will boost China\'s economic growth.\r\nD) They will not come into immediate effect.\r\n\r\nQuestions 5 to 7 are based on the news report you have just heard.\r\n5. A) Cleaning service in great demand all over the world.\r\nB) Two ladies giving up well-paid jobs to do cleaning.\r\nC) A new company to clean up the mess after parties.\r\nD) Cleaners gainfully employed at nights and weekends.\r\n6. A) It takes a lot of time to prepare.\r\nB) It leaves the house in a mess.\r\nC) It makes party goers exhausted.\r\nD) It creates noise and misconduct.\r\n7. A) Hire an Australian lawyer.\r\nB) Visit the U.S. and Canada.\r\nC) Settle a legal dispute.\r\nD) Expand their business.\r\n\r\nSection B Conversation\r\nDirections： In this section， you will hear two long conversations。 At the end of each conversations you will hear four questions。 Both the conversations and the question-s will be spoken only once。 After you hear a question。 You must choose the best answer from the four choices marked A），B），C）and D）。 Then mark the corresponding letter on Answer Sheet 1 with a single line through the centre.\r\n\r\nQuestions 8 to 11 are based on the conversation you have just heard.\r\n8. A) He had a driving lesson.\r\nB) He got his driver\'s license.\r\nC) He took the driver\'s theory exam.\r\nD) He passed the driver\'s road test.\r\n9. A) He was not well prepared.\r\nB) He did not get to the exam in time.\r\nC) He was not used to the test format.\r\nD) He did not follow the test procedure.\r\n10. A) They are tough.\r\nB) They are costly.\r\nC) They are helpful.\r\nD) They are too short.\r\n11. A) Pass his road test the first time.\r\nB) Test-drive a few times on highways.\r\nC) Find an experienced driving instructor.\r\nD) Earn enough money for driving lessons.\r\n\r\nQuestions 12 to 15 are based on the conversation you have just heard.\r\n12. A) Where the woman studies.\r\nB) The acceptance rate at Leeds.\r\nC) Leed\'s tuition for international students.\r\nD) How to apply for studies at a university.\r\n13. A) Apply to an American university.\r\nB) Do research on higher education.\r\nC) Perform in a famous musical.\r\nD) Pursue postgraduate studies.\r\n14. A) His favorable recommendations.\r\nB) His outstanding musical talent.\r\nC) His academic excellence.\r\nD) His unique experience.\r\n15. A) Do a master\'s degree.\r\nB) Settle down in England.\r\nC) Travel widely.\r\nD) Teach overseas.\r\n\r\nSection C Passage\r\nDirections： In this section， you will hear three passages。 At the end of each passage， you will hear three or four questions。 Both the passage and the questions will be spoken only once。 After you hear a question， you must choose the best answer from the four choices marked A），B），C）and D）。Then mark the corresponding letter on Answer Sheet 1 with a single line through the centre.\r\n\r\nQuestions 16 to 18 are based on the passage you have just heard.\r\n16. A) They help farmers keep diseases in check.\r\nB) Many species remain unknown to scientists.\r\nC) Only a few species cause trouble to humans.\r\nD) They live in incredibly well-organized colonies.\r\n17. A) They are larger than many other species.\r\nB) They can cause damage to people\'s homes.\r\nC) They can survive a long time without water.\r\nD) They like to form colonies in electrical units.\r\n18. A) Deny them access to any food.\r\nB) Keep doors and windows shut.\r\nC) Destroy their colonies close by.\r\nD) Refrain from eating sugary food.\r\n\r\nQuestions 19 to 21 are based on the passage you have just heard.\r\n19. A) The function of the human immune system.\r\nB) The cause of various auto-immune diseases.\r\nC) The viruses that may infect the human immune system.\r\nD) The change in people\'s immune system as they get older.\r\n20. A) Report their illnesses.\r\nB) Offer blood samples.\r\nC) Act as research assistants.\r\nD) Help to interview patients.\r\n21. A) Strengthening people\'s immunity to infection.\r\nB) Better understanding patients\' immune system.\r\nC) Helping improve old people\'s health conditions.\r\nD) Further reducing old patients\' medical expenses.\r\n\r\nQuestions 22 to 25 are based on the passage you have just heard.\r\n22. A) His students had trouble getting on with each other.\r\nB) A lot of kids stayed at school to do their homework.\r\nC) His students were struggling to follow his lessons.\r\nD) A group of kids were playing chess after school.\r\n23. A) Visit a chess team in Nashville.\r\nB) Join the school\'s chess team.\r\nC) Participate in a national chess competition.\r\nD) Receive training for a chess competition.\r\n24. A) Most of them come from low-income families.\r\nB) Many have become national chess champions.\r\nC) A couple of them have got involved in crimes.\r\nD) Many became chess coaches after graduation.\r\n25. A) Actions speak louder than words.\r\nB) Think twice before taking action.\r\nC) Translate their words into action.\r\nD) Take action before it gets too late.',1),(2,'2018年12月英语四级听力真题第1套','cet4-201812-1.mp3','Section A News Report\r\nDirections： In this section， you will hear three news reports。 At the end of each news report， you will hear two or three questions。 Both the news report and the questions will be spoken only once。 After you hear a question， you must choose the best answer from the four choices marked A）， B）， C） and D）。 Then mark the corresponding letter on Answer Sheet 1 with a single line through the centre。\r\n\r\nQuestions 1 and 2 are based on the news report you have just heard.\r\n1. A) Land a space vehicle on the moon in 2019.\r\nB) Design a new generation of mobile phones.\r\nC) Set up a mobile phone network on the moon.\r\nD) Gather data from the moon with a tiny device.\r\n2. A) It is stable.\r\nB) It is durable.\r\nC) It is inexpensive.\r\nD) It is sophisticated.\r\n\r\nQuestions 3 and 4 are based on the news report you have just heard.\r\n3. A) It lasted more than six hours.\r\nB) No injuries were yet reported.\r\nC) Nobody was in the building when it broke out.\r\nD) It had burned for 45 minutes by the time firefighters arrived.\r\n4. A) Recruit and train more firefighters.\r\nB) Pull down the deserted shopping mall.\r\nC) Turn the shopping mall into an amusement park.\r\nD) Find money to renovate the local neighborhood.\r\n\r\nQuestions 5 to 7 are based on the news report you have just heard.\r\n5. A) Shrinking potato farming.\r\nB) Heavy reliance on import.\r\nC) Widespread plant disease.\r\nD) Insufficient potato supply.\r\n6. A) It intends to keep its traditional diet.\r\nB) It wants to expand its own farming.\r\nC) It is afraid of the spread of disease.\r\nD) It is worried about unfair competition.\r\n7. A) Global warming.\r\nB) Ever-rising prices.\r\nC) Government regulation.\r\nD) Diminishing investment.\r\n\r\nSection B Conversation\r\nDirections： In this section， you will hear two long conversations。 At the end of each conversations you will hear four questions。 Both the conversations and the question-s will be spoken only once。 After you hear a question。 You must choose the best answer from the four choices marked A），B），C）and D）。 Then mark the corresponding letter on Answer Sheet 1 with a single line through the centre.\r\n\r\nQuestions 8 to 11 are based on the conversation you have just heard.\r\n8. A) Informative.\r\nB) Inspiring.\r\nC) Dull.\r\nD) Shallow.\r\n9. A) She types on a keyboard.\r\nB) She does recording.\r\nC) She takes photos.\r\nD) She takes notes.\r\n10. A) It keeps her mind active.\r\nB) It makes her stay awake.\r\nC) It enables her to think hard.\r\nD) It helps her kill time.\r\n11. A) It enables her to improve her pronunciation.\r\nB) It helps her better remember what she learns.\r\nC) It turns out to be an enjoyable way of learning.\r\nD) It proves to be far more effective than writing.\r\n\r\nQuestions 12 to 15 are based on the conversation you have just heard.\r\n12. A) To spend her honeymoon.\r\nB) To try authentic Indian food.\r\nC) To take photos of the Taj Mahal.\r\nD) To trace the origin of a love story.\r\n13. A) In memory of a princess.\r\nB) In honor of a great emperor.\r\nC) To mark the death of an emperor of the 1600s.\r\nD) To celebrate the birth of a princess\'s 14th child.\r\n14. A) It looks older than expected.\r\nB) It is built of wood and bricks.\r\nC) It stores lots of priceless antiques.\r\nD) It has walls decorated with jewels.\r\n15. A) Their streets are narrow.\r\nB) They are mostly crowded.\r\nC) Each one has a unique character.\r\nD) Life can be tedious in some places.\r\n\r\nSection C Passage\r\nDirections： In this section， you will hear three passages。 At the end of each passage， you will hear three or four questions。 Both the passage and the questions will be spoken only once。 After you hear a question， you must choose the best answer from the four choices marked A），B），C）and D）。Then mark the corresponding letter on Answer Sheet 1 with a single line through the centre.\r\n\r\nQuestions 16 to 18 are based on the passage you have just heard.\r\n16. A) They help spread the latest technology.\r\nB) They greatly enrich people’s leisure life.\r\nC) They provide residents with the resources needed.\r\nD) They allow free access to digital books and videos.\r\n17. A) By helping them find jobs.\r\nB) By inspiring their creativity.\r\nC) By keeping them off the streets.\r\nD) By providing a place of relaxation.\r\n18. A) Their interaction with teenagers proved fruitful.\r\nB) They used libraries less often than teenagers.\r\nC) They tended to visit libraries regularly.\r\nD) Their number increased modestly.\r\n\r\nQuestions 19 to 21 are based on the passage you have just heard.\r\n19. A) It is the cleverest cat in the world.\r\nB) It is the largest cat in Africa.\r\nC) It is an unusual cross breed.\r\nD) It is a large-sized wild cat.\r\n20. A) They are as loyal as dogs.\r\nB) They have unusually long tails.\r\nC) They are fond of sleeping in cabinets.\r\nD) They know how to please their owners.\r\n21. A) They shake their front paws.\r\nB) They teach them to dive.\r\nC) They shower with them.\r\nD) They shout at them.\r\n\r\nQuestions 22 to 25 are based on the passage you have just heard.\r\n22. A) Anxious and depressed.\r\nB) Contented and relieved.\r\nC) Excited but somewhat sad.\r\nD) Proud but a bit nervous.\r\n23. A) It is becoming parents biggest concern.\r\nB) It is gaining increasing public attention.\r\nC) It depends on their parents for success.\r\nD) It starts the moment they are born.\r\n24. A) Set a good example for them to follow.\r\nB) Read books and magazines to them.\r\nC) Help them to learn by themselves.\r\nD) Choose the right school for them.\r\n25. A) Their intelligence.\r\nB) Their home life.\r\nC) The effort they put in learning.\r\nD) The quality of their school.',1),(3,'2019年6月英语六级听力真题第1套','cet6-201906-1.mp3','Section A\r\nDirections: In this section, you will hear two long conversations. At the end of each conversation, you will hear four questions. Both the conversation and the questions will be spoken only once. After you hear a question, you must choose the best answer from the four choices marked A, B, C and D. Then mark the corresponding letter on Answer Sheet I with a single line through the centre.\r\nQuestions 1 to 4 are based on the conversation you have just heard.\r\n\r\n1. A) A six-month-long negotiation.\r\nB) Preparations for the party.\r\nC) A project with a troublesome client.\r\nD) Gift wrapping for the colleagues.\r\n2. A) Take wedding photos.\r\nB) Advertise her company.\r\nC) Start a small business.\r\nD) Throw a celebration party.\r\n3. A) Hesitant.\r\nB) Nervous.\r\nC) Flattered.\r\nD) Surprised.\r\n4. A) Start her own bakery.\r\nB) Improve her baking skill.\r\nC) Share her cooking experience.\r\nD) Prepare for the wedding.\r\n\r\nQuestions 5 to 8 are based on the conversation you have just heard.\r\n\r\n5. A) They have to spend more time studying.\r\nB) They have to participate in club activities.\r\nC) They have to be more responsible for what they do.\r\nD) They have to choose a specific academic discipline.\r\n6. A) Get ready for a career.\r\nB) Make a lot of friends.\r\nC) Set a long-term goal.\r\nD) Behave like adults\r\n7. A) Those who share her academic interests.\r\nB) Those who respect her student commitments.\r\nC) Those who can help her when she is in need.\r\nD) Those who go to the same clubs as she does.\r\n8. A) Those helpful for tapping their potential.\r\nB) Those conducive to improving their social skills.\r\nC) Those helpful for cultivating individual interests.\r\nD) Those conducive to their academic studies.\r\n\r\n\r\nSection B\r\n\r\nDirections: In this section, you will hear two passages. At the end of each passage, you will hear three or four questions. Both the passage and the questions will be spoken only once. After you hear a question, you must choose the best answer from the four choices marked A, B, C and D. Then mark the corresponding letter on Answer Sheet 1 with a single line through the centre.\r\nQuestions 9 to 11 are based on the passage you have just heard.\r\n\r\n9. A) They break away from traditional ways of thinking.\r\nB) They are prepared to work harder than anyone else.\r\nC) They are good at refining old formulas.\r\nD) They bring their potential into full play.\r\n10. A) They contributed to the popularity of skiing worldwide.\r\nB) They resulted in a brand-new style of skiing technique.\r\nC) They promoted the scientific use of skiing poles.\r\nD) They made explosive news in the sports world.\r\n11. A) He was recognized as a genius in the world of sports.\r\nB) He competed in all major skiing events in the world.\r\nC) He won three gold medals in one Winter Olympics.\r\nD) He broke three world skiing records in three years.\r\nQuestions 12 to 15 are based on the passage you have just heard.\r\n\r\n12. A) They appear restless.\r\nB) They lose consciousness.\r\nC) They become upset.\r\nD) They die almost instantly.\r\n13. A) It has an instant effect on your body chemistry.\r\nB) It keeps returning to you every now and then.\r\nC) It leaves you with a long lasting impression.\r\nD) It contributes to the shaping of your mind.\r\n14. A) To succeed while feeling irritated.\r\nB) To feel happy without good health.\r\nC) To be free from frustration and failure.\r\nD) To enjoy good health while in dark moods\r\n15. A) They are closely connected.\r\nB) They function in a similar way.\r\nC) They are too complex to understand.\r\nD) They reinforce each other constantly.\r\nSection C\r\n\r\nDirections: In this section, you will hear three recordings of lectures or talks followed by three or four questions. The recordings will be played only once. After you hear a question, you must choose the best answer from the four choices marked A, B, C and D. Then mark the corresponding letter on Answer Sheet 1 with a single line through the centre.\r\nQuestions 16 to 18 are based on the recording you have just heard.\r\n\r\n16. A) They differ in their appreciation of music.\r\nB) They focus their attention on different things.\r\nC) They finger the piano keys in different ways.\r\nD) They choose different pieces of music to play.\r\n17. A) They manage to cooperate well with their teammates.\r\nB) They use effective tactics to defeat their competitors.\r\nC) They try hard to meet the spectators’ expectations.\r\nD) They attach great importance to high performance.\r\n18. A) It marks a breakthrough in behavioral science.\r\nB) It adopts a conventional approach to research.\r\nC) It supports a piece of conventional wisdom.\r\nD) It gives rise to controversy among experts.\r\nQuestions 19 to 21 are based on the recording you have just heard.\r\n\r\n19. A) People’s envy of slim models.\r\nB) People’s craze for good health.\r\nC) The increasing range of fancy products.\r\nD) The great variety of slimming products.\r\n20. A) They appear vigorous.\r\nB) They appear strange.\r\nC) They look charming.\r\nD) They look unhealthy.\r\n21. A) Culture and upbringing.\r\nB) Wealth and social status.\r\nC) Peer pressure.\r\nD) Media influence.\r\nQuestions 22 to 25 are based on the recording you have just heard.\r\n\r\n22. A) The relation between hair and skin.\r\nB) The growing interest in skin studies.\r\nC) The color of human skin.\r\nD) The need of skin protection.\r\n23. A) The necessity to save energy.\r\nB) Adaptation to the hot environment.\r\nC) The need to breathe with ease.\r\nD) Dramatic climate changes on earth.\r\n24. A) Leaves and grass.\r\nB) Man-made shelter.\r\nC) Their skin coloring.\r\nD) Hair on their skin.\r\n25. A) Their genetic makeup began to change.\r\nB) Their communities began to grow steadily.\r\nC) Their children began to mix with each other.\r\nD) Their pace of evolution began to quicken.',2);

/*Table structure for table `notice` */

DROP TABLE IF EXISTS `notice`;

CREATE TABLE `notice` (
  `noticeId` int(11) NOT NULL AUTO_INCREMENT,
  `title` varchar(32) DEFAULT NULL,
  `content` text NOT NULL,
  `creatTime` date NOT NULL,
  PRIMARY KEY (`noticeId`)
) ENGINE=InnoDB AUTO_INCREMENT=11 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci;

/*Data for the table `notice` */

insert  into `notice`(`noticeId`,`title`,`content`,`creatTime`) values (1,'欢迎','欢迎来到Study-English学习系统，该系统是基于SpringBoot+Mybatis开发，使用BootStrap作为前端页面框架，使用Thymeleaf模板引擎渲染页面。该系统有背单词，听听力，做练习，生成本，每日一句等功能。','2020-04-14'),(2,'欢迎您的到来，请您仔细阅读以下公告！','该英语学习网站的开发以 B/S 架构为基础，选用 java 为开发语言，服务器端采用 SpringBoot+Mybatis框架开发，使用了SpringBoot官方推荐的Thymeleaf作为模板引擎用于动态显示页面，前端则使用Bootstrap 框架美化页面。\r\n本学习系统分为注册登录模块，公告展示模块，背单词模块，听力练习模块，阅读书籍模块，每日一句模块，个人中心模块，以及后台管理模块。\r\n<p>介绍完毕，请您开始使用吧！\r\n<hr>\r\n<p>\r\n<a>感谢您的耐心阅读，如果在使用过程中遇到一些问题，请你把反馈信息发送到weirdchun@gmail.com，我们会有专业人员和您联系！\r\n\r\n','2020-04-16');

/*Table structure for table `sentence` */

DROP TABLE IF EXISTS `sentence`;

CREATE TABLE `sentence` (
  `sentenceId` int(11) NOT NULL AUTO_INCREMENT,
  `sentenceName` tinytext,
  `explain` varchar(32) DEFAULT NULL,
  PRIMARY KEY (`sentenceId`)
) ENGINE=InnoDB AUTO_INCREMENT=5 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci;

/*Data for the table `sentence` */

insert  into `sentence`(`sentenceId`,`sentenceName`,`explain`) values (1,'Never put off what you can do today until tomorrow.','今日事今日毕'),(2,'Action speak louder than words!','行动胜于言语'),(3,'The man who has made up his mind to win will never say impossible.','下决心取得胜利的人绝不会说“不可能”。'),(4,'Confidence is contagious. So is a lack of confidence. ','自信是会传染的，缺乏自信也是。');

/*Table structure for table `user` */

DROP TABLE IF EXISTS `user`;

CREATE TABLE `user` (
  `userId` int(8) NOT NULL AUTO_INCREMENT COMMENT '用户ID',
  `userName` varchar(32) NOT NULL COMMENT '用户名',
  `password` varchar(32) NOT NULL COMMENT '密码',
  `email` varchar(32) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL COMMENT '邮箱',
  `activeCode` varchar(100) DEFAULT NULL,
  `activeStatus` int(11) DEFAULT NULL,
  `role` int(11) NOT NULL DEFAULT '0',
  PRIMARY KEY (`userId`)
) ENGINE=InnoDB AUTO_INCREMENT=9 DEFAULT CHARSET=utf8;

/*Data for the table `user` */

insert  into `user`(`userId`,`userName`,`password`,`email`,`activeCode`,`activeStatus`,`role`) values (2,'Weirdchun','123','18645230407@163.com',NULL,1,0),(7,'Weirdchun123','123','9048595701@qq.com','',1,0),(8,'chun','123','904859570@qq.com','8b818f1984e34442b16e8942a9505c6a',1,1);

/*Table structure for table `word` */

DROP TABLE IF EXISTS `word`;

CREATE TABLE `word` (
  `wordId` int(11) NOT NULL AUTO_INCREMENT,
  `wordName` varchar(32) NOT NULL,
  `audio` varchar(32) NOT NULL,
  `explanation` varchar(32) NOT NULL,
  `example` varchar(255) NOT NULL,
  `grade` int(11) NOT NULL,
  `study` int(11) NOT NULL DEFAULT '0',
  `remember` int(11) NOT NULL DEFAULT '0',
  `collection` int(11) DEFAULT '0',
  PRIMARY KEY (`wordId`),
  KEY `word_grade_gradeId_fk` (`grade`),
  CONSTRAINT `word_grade_gradeId_fk` FOREIGN KEY (`grade`) REFERENCES `grade` (`gradeId`)
) ENGINE=InnoDB AUTO_INCREMENT=20 DEFAULT CHARSET=utf8;

/*Data for the table `word` */

insert  into `word`(`wordId`,`wordName`,`audio`,`explanation`,`example`,`grade`,`study`,`remember`,`collection`) values (1,'spit','[spit]','n. 唾液，口水，小雨 v. 唾吐，吐出，降小雨','The boys were spitting out of the train window ',1,0,0,0),(2,'spit','[spit]','n. 唾液，口水，小雨 v. 唾吐，吐出，降小雨','The boys were spitting out of the train window ',1,0,0,0),(3,'blast',' [blɑ:st]','n. 一阵(强风)，爆炸声，爆破  v. 爆破，摧毁','The bomb blast killed several harmless passers-by',1,0,0,0),(4,'spill',' [spil]','v. 溢出，洒，使...流出，泄漏 n. 溢出，流','Don`studywords`’t jog me, or you’ll make me spill something!',1,0,0,0),(5,'candidate','[’kændidit]','n. 候选人，求职者','  In my estimation, he is a more suitable candidate.',1,0,0,0),(6,'slip ',' [slip]','v.滑倒；滑脱；疏忽；溜走 adj. 滑动的；有活结的；活络的',' The ship slipped into the harbour at night',1,0,0,1),(7,'consume','  [kən’sju:m]','v. 消耗，花费，挥霍','  Consuming or eager to consume great amounts of food; ravenous',1,0,0,0),(8,'breed ',' [bri:d]','v. 繁殖，养育 n. 品种，血统','  I breed some chicks for pets.',1,0,0,0),(9,'slide','  [slaid]','vi. 滑，滑动，滑入，悄悄地溜走',' House values may begin to slide',1,0,0,0),(10,'dispose',' [di’spəuz]','vt. 倾向于，处置','  I must dispose of the trouble',1,0,0,0),(11,'transmit',' [trænz’mit]','vt. 传输，传送，代代相传，传达 ',' This infection is transmitted by mosquitoes',1,0,0,0),(12,'transport',' [træns’pɔ:t]','n.运输；输送；运送；运输机 v.运输，流放，为强烈的情绪所激动',' The goods have been cased up for transport. ',1,0,0,0),(13,'acute ','[ə’kju:t]','adj. 敏锐的，剧烈的','The patient is complaining of acute earache.',2,0,0,0),(14,'acknowledge','[ək’nɔlidʒ]','vt. 承认，公认，告知收到，表示感谢，注意到','He is unwilling to acknowledge defeat.',2,0,0,0),(15,'absurd',' [əb’sə:d]','adj. 荒唐的',' He looked absurd in that get-up',2,1,1,0),(16,'acquaint','[ə’kweint]','vt. 使...熟知','You must acquaint yourself with your new duties.',2,0,0,0),(17,'abrupt','[ə’brʌpt]','adj. 突然的，意外的，唐突的，陡峭的','It’s very unlike him to be so abrupt.',2,0,0,0),(18,'activate','[’æktiveit]','v. 激活，使活动，起动',' A similar device used to release or activate a mechanism',2,0,0,0),(19,'abolish','[ə’bɔliʃ]','vt. 废止，革除','There are many bad customs and laws that ought to be abolished',2,0,0,0);

/*!40101 SET SQL_MODE=@OLD_SQL_MODE */;
/*!40014 SET FOREIGN_KEY_CHECKS=@OLD_FOREIGN_KEY_CHECKS */;
/*!40014 SET UNIQUE_CHECKS=@OLD_UNIQUE_CHECKS */;
/*!40111 SET SQL_NOTES=@OLD_SQL_NOTES */;