数据库原理实验-游标与存储过程.doc

数据库实验操作 陈振凯 建立EPoem表和CPoem表，并插入数据 EPoem The furthest distance in the world, is not when plainly cannot resist the yearning, yet pretending you have never been in my heart The furthest distance in the world, is not when plainly cannot resist the yearning, yet pretending you have never been in my heart But using one’s indifferent heart, to dig an uncrossable river for the one who loves you But when undoubtedly knowing the love from both, yet cannot be together The furthest distance in the world, is not being apart while being in love But when plainly can not resist the yearning, yet pretending you have never been in my heart The furthest distance in the world, is not when I stand in front of you, yet you can’t see my love But when I stand in front of you, yet you don’t know that I love you The furthest distance in the world, is not between life and death LineText 世界上最遥远的距离，不是明明无法抵挡这股思念，却还要故意装作丝毫没有把你放在心里， 世界上最遥远的距离，不是明明无法抵挡这股思念，却还要故意装作丝毫没有把你放在心里， 而是用自己冷漠的心，对爱你的人掘了一条无法跨越的沟渠 而是明明知道彼此相爱，却不能在一起 世界上最遥远的距离，不是明明知道彼此相爱，却不能在一起 而是明明无法抵挡这股思念，却还得故意装作丝毫没有把你放在心里 世界上最遥远的距离，不是我站在你面前，你却不知道我爱你 而是我就站在你的面前，你却不知道我爱你 世界上最遥远的距离，不是生与死 LineText 写存储过程read_poem，依次实现如下功能 显示 “英文诗” 依次显示EPoem的所有记录 显示一个空行 显示“中文诗” 依次显示CPoem的所有记录 代码： create table czk_EPoem ( LineText char(1000) not null ) create table czk_CPoem ( LineText char(100) not null ) insert into czk_EPoem values(The furthest distance in the world, is not between life and death) insert into czk_EPoem values(But when I stand in front of you, yet you don’t know that I love you) insert into czk_EPoem values(The furthest distance in the world, is not when I stand in front of you, yet you can’t see my love) insert into czk_EPoem values(But when undoubtedly knowing the love from both, yet cannot be together) insert into czk_EPoem values(The furthest distance in the world, is not being apart while being in love) insert into czk_EPoem values(But when plainly can not resist the yearning, yet pretending you have never been in my heart