stock.sql

这是一个关于jsp的学习文档.为学习jsp的朋友提供方便

create table stock(
    stockid varchar(7),
    stockname varchar(10),
    shoupan number(6,2),
    zhangdie number(6,2),
    stockmax number(6,2),
    stockmin number(6,2),
    stocknum number(10,2)
);

insert into stock (stockid,stockname,shoupan,zhangdie,stockmax,stockmin,stocknum) values ('600053','江西纸业',11.12,0.23,11.12,10.6,386850);
insert into stock (stockid,stockname,shoupan,zhangdie,stockmax,stockmin,stocknum) values ('600055','万东医疗',19.37,0.87,19.4,18.56,8197255);
insert into stock (stockid,stockname,shoupan,zhangdie,stockmax,stockmin,stocknum) values ('600057','厦新电子',16.65,0.88,16.65,15.8,51984810);
insert into stock (stockid,stockname,shoupan,zhangdie,stockmax,stockmin,stocknum) values ('600059','古越龙山',16.92,-0.27,16.9,16.3,1520150);
insert into stock (stockid,stockname,shoupan,zhangdie,stockmax,stockmin,stocknum) values ('600060','海信电器',14.64,0.36,15.25,14.5,2772004);
insert into stock (stockid,stockname,shoupan,zhangdie,stockmax,stockmin,stocknum) values ('600062','双鹤药业',11.9,0.51,12.05,11.31,1491286);
insert into stock (stockid,stockname,shoupan,zhangdie,stockmax,stockmin,stocknum) values ('600063','皖维股份',11.1,0.24,11.42,10.99,2788211);
insert into stock (stockid,stockname,shoupan,zhangdie,stockmax,stockmin,stocknum) values ('600065','大庆联谊',24.5,1.03,25.6,24.45,13883530);
insert into stock (stockid,stockname,shoupan,zhangdie,stockmax,stockmin,stocknum) values ('600066','宇通客车',24.31,0.53,24.5,23.8,1340956);
insert into stock (stockid,stockname,shoupan,zhangdie,stockmax,stockmin,stocknum) values ('600067','福州大通',9.91,0.23,9.95,9.8,436818);
insert into stock (stockid,stockname,shoupan,zhangdie,stockmax,stockmin,stocknum) values ('600069','漯河银鸽',11.6,0.6,12.4,11.65,1865624);
insert into stock (stockid,stockname,shoupan,zhangdie,stockmax,stockmin,stocknum) values ('600070','浙江富涧',7.88,0.32,8.2,7.83,293114);
insert into stock (stockid,stockname,shoupan,zhangdie,stockmax,stockmin,stocknum) values ('600071','凤凰光学',13.22,0.42,13.86,13.13,12274833);
insert into stock (stockid,stockname,shoupan,zhangdie,stockmax,stockmin,stocknum) values ('600712','南宁百货',8.78,0.28,8.78,8.3,398159);
insert into stock (stockid,stockname,shoupan,zhangdie,stockmax,stockmin,stocknum) values ('600723','西单商场',7.6,0.0,7.6,7.31,663071);
insert into stock (stockid,stockname,shoupan,zhangdie,stockmax,stockmin,stocknum) values ('600729','重庆百货',8.38,-0.05,8.59,8.21,186409);
insert into stock (stockid,stockname,shoupan,zhangdie,stockmax,stockmin,stocknum) values ('600735','寰宇股份',9.0,0.0,9.4,8.95,1293055);
insert into stock (stockid,stockname,shoupan,zhangdie,stockmax,stockmin,stocknum) values ('600738','兰州民百',7.67,0.26,7.69,7.25,627957);
insert into stock (stockid,stockname,shoupan,zhangdie,stockmax,stockmin,stocknum) values ('600754','新亚股份',8.36,-0.33,8.69,8.66,348770);
insert into stock (stockid,stockname,shoupan,zhangdie,stockmax,stockmin,stocknum) values ('600766','烟台华联',12.0,0.2,12.22,12.22,69000);
insert into stock (stockid,stockname,shoupan,zhangdie,stockmax,stockmin,stocknum) values ('600774','汉商集团',12.1,0.25,12.15,11.86,146240);
insert into stock (stockid,stockname,shoupan,zhangdie,stockmax,stockmin,stocknum) values ('600778','新疆友好',6.35,-0.04,604.0,6.2,328385);
insert into stock (stockid,stockname,shoupan,zhangdie,stockmax,stockmin,stocknum) values ('600785','新华百货',9.2,0.2,9.29,8.85,314890);
insert into stock (stockid,stockname,shoupan,zhangdie,stockmax,stockmin,stocknum) values ('600831','东方职业',3.0,2.0,4.0,3.0,3);
insert into stock (stockid,stockname,shoupan,zhangdie,stockmax,stockmin,stocknum) values ('600835','上海重工',8.0,9.0,8.0,9.0,8);