1.准备SQL MYSQL数据库

  1 set character_set_client=GBK; 
  2 set character_set_connection=GBK; 
  3 set character_set_database=GBK; 
  4 set character_set_results=GBK; 
  5 set character_set_server=GBK;
  6 create database wabacusdemodb character set GBK;
  7 use wabacusdemodb;
  8 
  9 create table tbl_dynamicolumns(
 10     layer1 varchar (50) ,
 11     layer2 varchar (50) ,
 12     layer3 varchar (50) ,
 13     col_column varchar (50) 
 14 );
 15 insert into tbl_dynamicolumns values('[动态]个人资料','[动态]姓名','[动态]中文名','name');
 16 insert into tbl_dynamicolumns values('[动态]个人资料','[动态]姓名','[动态]英文名','ename');
 17 insert into tbl_dynamicolumns values('[动态]个人资料',null,'[动态]性别','sex');
 18 insert into tbl_dynamicolumns values('[动态]个人资料',null,'[动态]年龄','age');
 19 insert into tbl_dynamicolumns values(null,null,'[动态]出生日期','birthday');
 20 create table tbl_area(
 21     province    varchar(20),
 22     city        varchar(20),
 23     county        varchar(20)
 24 );
 25 insert into tbl_area values('江西','宜春','上高');
 26 insert into tbl_area values('江西','宜春','高安');
 27 insert into tbl_area values('江西','宜春','万载');
 28 insert into tbl_area values('江西','宜春','奉新');
 29 insert into tbl_area values('江西','南昌','进贤');
 30 insert into tbl_area values('江西','南昌','新建');
 31 insert into tbl_area values('江西','抚州','东乡');
 32 insert into tbl_area values('江西','抚州','临川');
 33 insert into tbl_area values('广东','深圳','宝安');
 34 insert into tbl_area values('广东','深圳','福田');
 35 insert into tbl_area values('广东','深圳','南山');
 36 insert into tbl_area values('广东','东莞','塘厦');
 37 insert into tbl_area values('广东','东莞','长安');
 38 insert into tbl_area values('福建','泉州','惠安');
 39 insert into tbl_area values('福建','泉州','安溪');
 40 insert into tbl_area values('福建','泉州','南安');
 41 insert into tbl_area values('福建','福州','永泰');
 42 insert into tbl_area values('福建','福州','连江');
 43 
 44 create table tbl_baseinfo(
 45     uuid        varchar(50),
 46     no        varchar(20),
 47     name        varchar(30),
 48     sex        int,
 49     age        int,
 50     birthday    date,
 51     deptno        varchar(20)
 52 );
 53 
 54 insert into tbl_baseinfo values('8a9f8189297d71b001297d71b01a0001','10001','宋文华',1,25,'1978-01-03','0001');
 55 insert into tbl_baseinfo values('8a9f8189297d71b001297d71b01a0002','10002','周燕',0,38,'1978-12-21','0001');
 56 insert into tbl_baseinfo values('8a9f8189297d71b001297d71b01a0003','10003','周红',0,45,'1968-05-23','0003');
 57 insert into tbl_baseinfo values('8a9f8189297d71b001297d71b01a0004','10004','胡智波',1,35,'1963-08-12','0001');
 58 insert into tbl_baseinfo values('8a9f8189297d71b001297d71b01a0005','10005','胡秀青',1,36,'1965-06-11','0002');
 59 insert into tbl_baseinfo values('8a9f8189297d71b001297d71b01a0006','10006','涂琦英',0,56,'1959-05-03','0001');
 60 insert into tbl_baseinfo values('8a9f8189297d71b001297d71b01a0007','10007','宋节斌',1,45,'1957-11-05','0002');
 61 insert into tbl_baseinfo values('8a9f8189297d71b001297d71b01a0008','10008','周英龙',1,26,'1980-10-09','0003');
 62 insert into tbl_baseinfo values('8a9f8189297d71b001297d71b01a0009','10009','吴树青',1,32,'1983-11-15','0001');
 63 insert into tbl_baseinfo values('8a9f8189297d71b001297d71b01a0010','10010','范新华',1,36,'1983-08-17','0012');
 64 insert into tbl_baseinfo values('8a9f8189297d71b001297d71b01a0011','10011','吴国发',1,26,'1980-07-19','0001');
 65 insert into tbl_baseinfo values('8a9f8189297d71b001297d71b01a0012','10012','吴志枫',1,43,'1978-08-13','0002');
 66 insert into tbl_baseinfo values('8a9f8189297d71b001297d71b01a0013','10013','范坚琴',0,28,'1977-03-03','0001');
 67 insert into tbl_baseinfo values('8a9f8189297d71b001297d71b01a0014','10014','周勇伟',1,36,'1978-07-05','0005');
 68 insert into tbl_baseinfo values('8a9f8189297d71b001297d71b01a0015','10015','周节华',1,46,'1976-05-17','0009');
 69 insert into tbl_baseinfo values('8a9f8189297d71b001297d71b01a0016','10016','范员波',1,35,'1978-07-16','0009');
 70 insert into tbl_baseinfo values('8a9f8189297d71b001297d71b01a0017','10017','胡冬琴',0,56,'1980-06-15','0005');
 71 insert into tbl_baseinfo values('8a9f8189297d71b001297d71b01a0018','10018','王洪枚',0,28,'1980-08-21','0007');
 72 insert into tbl_baseinfo values('8a9f8189297d71b001297d71b01a0019','10019','吴志清',1,37,'1968-07-27','0004');
 73 insert into tbl_baseinfo values('8a9f8189297d71b001297d71b01a0020','10020','吴志国',1,38,'1987-08-29','0001');
 74 insert into tbl_baseinfo values('8a9f8189297d71b001297d71b01a0021','10021','吴清珊',0,28,'1969-06-25','0009');
 75 insert into tbl_baseinfo values('8a9f8189297d71b001297d71b01a0022','10022','王志尖',1,36,'1980-07-26','0012');
 76 insert into tbl_baseinfo values('8a9f8189297d71b001297d71b01a0023','10023','吴良光',1,28,'1986-03-25','0001');
 77 insert into tbl_baseinfo values('8a9f8189297d71b001297d71b01a0024','10024','胡玟乐',1,37,'1976-03-21','0004');
 78 insert into tbl_baseinfo values('8a9f8189297d71b001297d71b01a0025','10025','洪亮亮',1,46,'1978-04-23','0001');
 79 insert into tbl_baseinfo values('8a9f8189297d71b001297d71b01a0026','10026','付瑞明',1,45,'1966-06-12','0006');
 80 insert into tbl_baseinfo values('8a9f8189297d71b001297d71b01a0027','10027','胡志莹',0,29,'1985-07-11','0010');
 81 insert into tbl_baseinfo values('8a9f8189297d71b001297d71b01a0028','10028','高洪波',1,34,'1975-03-10','0008');
 82 insert into tbl_baseinfo values('8a9f8189297d71b001297d71b01a0029','10029','刘铭署',1,38,'1973-07-15','0006');
 83 insert into tbl_baseinfo values('8a9f8189297d71b001297d71b01a0030','10030','胡婷',0,36,'1976-11-03','0010');
 84 insert into tbl_baseinfo values('8a9f8189297d71b001297d71b01a0031','10031','吴建中',1,39,'1988-12-15','0001');
 85 insert into tbl_baseinfo values('8a9f8189297d71b001297d71b01a0032','10032','吴志诚',1,26,'1986-04-19','0007');
 86 insert into tbl_baseinfo values('8a9f8189297d71b001297d71b01a0033','10033','苏伟官',1,28,'1963-10-26','0007');
 87 insert into tbl_baseinfo values('8a9f8189297d71b001297d71b01a0034','10034','吴圆蛾',0,29,'1968-08-27','0001');
 88 insert into tbl_baseinfo values('8a9f8189297d71b001297d71b01a0035','10035','吴芝红',0,23,'1965-01-21','0002');
 89 insert into tbl_baseinfo values('8a9f8189297d71b001297d71b01a0036','10036','万兴国',1,27,'1958-11-20','0011');
 90 insert into tbl_baseinfo values('8a9f8189297d71b001297d71b01a0037','10037','范贵红',0,45,'1980-10-23','0001');
 91 insert into tbl_baseinfo values('8a9f8189297d71b001297d71b01a0038','10038','宋国珍',0,36,'1982-06-13','0008');
 92 
 93 create table tbl_department(
 94     guid            varchar(50),
 95     deptno            varchar(20),    
 96     deptname        varchar(30),
 97     manager            varchar(30),
 98     builtdate        date,
 99     performance        varchar(20),
100     description        text
101 );
102 
103 insert into tbl_department values('3a8f8189297d71b001297d71b01a0001','0001','生产质量部','吴华云','2001-01-03','优秀','根据客户要求的产品交货期,安排生产,安排测试,安排包装,按时按质完成产品,对研发产品测试样机生产支持,管理生产车间,5S,精益生产,生产物料、半成品和成品管理,生产质量管理,生产人员管理,操作工技能培训,制定生产各部分的制度和流程,对销售的产品质量进行跟踪和管理,处理客户产品投诉,提出产品质量整改意见,组织和提高产品认证(3C,CCEE,CCIB,CE)、质量认证(ISO9000-ISO90004)、环境认证(ISO14000),制定和完善全面质量管理(TQM)');
104 insert into tbl_department values('3a8f8189297d71b001297d71b01a0002','0002','物流部','苏伟根','2001-01-03','很差','将销售部获得的客户订单录入到ERP系统,并生成相应的加工单,对成品按照客户要求的日期和发货地点完成成品发运,衡量公司对客户及时交货率;按照物流协议向供应商购买物料,催缴物料,对物料进行质量检查,并对供应商来料进行更总和物料FIFO管理,收到发票后组织付款,衡量供应商对公司的及时交货率,以及保税物料和报关实务处理,控制库存,制定物流制度和相应流程');
105 insert into tbl_department values('3a8f8189297d71b001297d71b01a0003','0003','采购部','胡忠华','2001-11-13','良好','前期供应商的搜寻,对供应商的认证和考核,谈判物料价格,制定物流采购协议,对供应商的产品和送货进行质量更总,非生产性物料的采购,制定所有采购材料的流程和制度,对工业项目采购的支持');
106 insert into tbl_department values('3a8f8189297d71b001297d71b01a0004','0004','财务部','胡新立','2003-06-09','良好','对公司的经营状况进行分析,提供决策财务数据支持,各种凭证录入系统,对供应商开具的发票付款,开发票给客户,并进行应收款的工作,对各种凭证汇总产生总账,出具财务报表(资产负债表,损益表,现金流量表),管理公司存款和现金,管理支票、汇票、发票、收据,报销,管理公司固定资产');
107 insert into tbl_department values('3a8f8189297d71b001297d71b01a0005','0005','研发技术部','潘林淘','2003-12-03','良好','负责对现有产品升级更新,性能优化,产品改进,新产品研发,产品生产技术支持,管理研发设备和研发实验室');
108 insert into tbl_department values('3a8f8189297d71b001297d71b01a0006','0006','人事行政部','胡新华','2003-12-09','优秀','发展公司企业文化,制定公司人事制度,管理员工入职离职,劳动合同管理,员工信息管理,制定员工福利和奖惩制度,制定公司培训政策和制度,安排出差人员的食宿,管理公司班车,管理公司食堂,管理公司办公设备');
109 insert into tbl_department values('3a8f8189297d71b001297d71b01a0007','0007','信息管理部','苏小琴','2004-03-12','优秀','管理公司的信息设备,保证设备和信息的安全,提供稳定,安全,高效的应用服务,配合公司战略规划,制定信息管理发展计划,带领和支持业务部门,提供优质的产品和服务');
110 insert into tbl_department values('3a8f8189297d71b001297d71b01a0008','0008','销售市场部','潘云鹏','2004-03-12','较好','为公司产品策划营销活动,树立公司品牌影响力,扩大产品市场占有额,管理分销商、代理商网络,制定公司年度销售计划,对销售活动进行监督和管理,考核销售业绩,为客户提供优质产品和服务');
111 insert into tbl_department values('3a8f8189297d71b001297d71b01a0009','0009','售后服务部','潘云飞','2004-03-12','较好','提供产品客户服务,产品安装,产品调试,产品维修,产品配件管理,产品售后服务管理,提供优质的产品售后服务');
112 insert into tbl_department values('3a8f8189297d71b001297d71b01a00010','0010','工业工程部','吴金升','2005-01-06','较好','规划生产线,提供精益生产方法和流程,制定产品生产工艺工序,产品生产操作手册,生产车间布局管理,优化生产工艺工序,提供工作效率,规划安全生产环境,产品技术变更管理,零部件版本升级管理,工程变更管理,将新研发的产品工业化,新产品生产线规划,操作工WI培训');
113 insert into tbl_department values('3a8f8189297d71b001297d71b01a00011','0011','设备维修部','吴平红','2005-01-06','良好','负责公司所有故障设备的维修与更新');
114 insert into tbl_department values('3a8f8189297d71b001297d71b01a00012','0012','保卫处','胡建国','2005-01-08','优秀','维护公司及员工安全,保障公司财产不受破坏');
115 
116 create table tbl_dept_pingjia(
117     guid            varchar(50),
118     pingjia            varchar(30)
119 );
120 
121 insert into tbl_dept_pingjia values('3a8f8189297d71b001297d71b01a0001','很好');
122 insert into tbl_dept_pingjia values('3a8f8189297d71b001297d71b01a0002','很差');
123 insert into tbl_dept_pingjia values('3a8f8189297d71b001297d71b01a0003','较好');
124 insert into tbl_dept_pingjia values('3a8f8189297d71b001297d71b01a0004','较差');
125 insert into tbl_dept_pingjia values('3a8f8189297d71b001297d71b01a0005','很好');
126 insert into tbl_dept_pingjia values('3a8f8189297d71b001297d71b01a0006','较好');
127 insert into tbl_dept_pingjia values('3a8f8189297d71b001297d71b01a0007','较好');
128 insert into tbl_dept_pingjia values('3a8f8189297d71b001297d71b01a0008','很好');
129 insert into tbl_dept_pingjia values('3a8f8189297d71b001297d71b01a0009','较好');
130 insert into tbl_dept_pingjia values('3a8f8189297d71b001297d71b01a00010','较好');
131 insert into tbl_dept_pingjia values('3a8f8189297d71b001297d71b01a00011','很差');
132 insert into tbl_dept_pingjia values('3a8f8189297d71b001297d71b01a00012','很好');
133 
134 create table tbl_detailinfo(
135     no        varchar(20),
136     ename        varchar(30),
137     salary        float,
138     joinindate    date,
139     province    varchar(30),
140     city        varchar(30),
141     county        varchar(30),
142     marriage    int,
143     interest    varchar(100),
144     photo        varchar(100),
145     description    text,
146     jl        varchar(100),
147     orderline    int
148 );
149 
150 insert into tbl_detailinfo values('10001','songwenhua',1320.2,'2008-11-03','江西','南昌','进贤',1,'健身,篮球','/WabacusDemo/wabacusdemo/uploadfile/2_chiay.jpg','努力勤奋,上进好学','',101538111);
151 insert into tbl_detailinfo values('10002','zhouyuan',2345.32,'2003-02-21','广东','深圳','宝安',0,'排球,旅游,跑步','/WabacusDemo/wabacusdemo/uploadfile/2_claudxyz.jpg','好吃懒做,游手好闲,好逸恶劳','',111538112);
152 insert into tbl_detailinfo values('10003','zhouhong',4323.23,'2005-03-23','福建','泉州','惠安',0,'足球,爬山,游泳','/WabacusDemo/wabacusdemo/uploadfile/2_cuidenghong123.jpg','勤偷节约,积极上进','',121538113);
153 insert into tbl_detailinfo values('10004','huzhibo',6352,'2006-08-22','江西','宜春','高安',1,'排球,旅游','/WabacusDemo/wabacusdemo/uploadfile/2_cxz003.jpg','努力勤奋,上进好学','',131538114);
154 insert into tbl_detailinfo values('10005','huxiuqing',4367.2,'2005-06-01','福建','泉州','安溪',0,'足球,旅游,跑步,健身','/WabacusDemo/wabacusdemo/uploadfile/2_e_mi_tuo_fo.jpg','勤偷节约,积极上进','',141538115);
155 insert into tbl_detailinfo values('10006','tuqiying',5355.2,'2006-05-23','广东','东莞','塘厦',0,'跑步,健身','/WabacusDemo/wabacusdemo/uploadfile/2_emon123.jpg','努力勤奋,上进好学','',151538116);
156 insert into tbl_detailinfo values('10007','songjiebin',7434.34,'2002-11-03','江西','南昌','进贤',0,'跑步,健身,篮球','/WabacusDemo/wabacusdemo/uploadfile/2_fanyuanwaifdl.jpg','勤偷节约,积极上进','',161538117);
157 insert into tbl_detailinfo values('10008','zhouyinglong',7436.5,'2000-10-19','福建','泉州','惠安',0,'游泳,排球,旅游,','/WabacusDemo/wabacusdemo/uploadfile/2_fellowcheng.jpg','努力勤奋,上进好学','',171538118);
158 insert into tbl_detailinfo values('10009','wushuqing',3455.3,'2009-11-15','江西','抚州','临川',1,'篮球','/WabacusDemo/wabacusdemo/uploadfile/2_gaohenggaoheng.jpg','努力勤奋,上进好学','',181538119);
159 insert into tbl_detailinfo values('10010','fanxinhua',3466.3,'2007-08-20','江西','南昌','进贤',0,'游泳,排球','/WabacusDemo/wabacusdemo/uploadfile/2_haiyong_sea.jpg','努力勤奋,上进好学','',191538120);
160 insert into tbl_detailinfo values('10011','woguofa',3677.4,'2000-07-29','江西','抚州','临川',0,'跑步,健身,篮球','/WabacusDemo/wabacusdemo/uploadfile/2_huahua320.jpg','努力勤奋,上进好学','',201538121);
161 insert into tbl_detailinfo values('10012','wuzhifeng',7637.3,'2002-08-23','广东','深圳','福田',0,'游泳,排球,旅游','/WabacusDemo/wabacusdemo/uploadfile/2_huiyaxiong.jpg','勤偷节约,积极上进','',211538122);
162 insert into tbl_detailinfo values('10013','fanjianqin',6346.3,'2006-03-23','江西','宜春','高安',0,'爬山,排球','/WabacusDemo/wabacusdemo/uploadfile/2_hyblusea.jpg','好吃懒做,游手好闲,好逸恶劳','',221538123);
163 insert into tbl_detailinfo values('10014','zhouyongwei',7598,'2004-07-15','福建','泉州','惠安',0,'足球,跑步,健身','/WabacusDemo/wabacusdemo/uploadfile/2_ivfangwang_long.jpg','好吃懒做,游手好闲,好逸恶劳','',231538124);
164 insert into tbl_detailinfo values('10015','zhoujiehua',9346.3,'2000-05-07','广东','深圳','宝安',1,'旅游,跑步,健身','/WabacusDemo/wabacusdemo/uploadfile/2_jaffy.jpg','勤偷节约,积极上进','',241538125);
165 insert into tbl_detailinfo values('10016','fanyuanbo',7463.3,'2003-07-06','江西','抚州','临川',0,'跑步,健身,篮球','/WabacusDemo/wabacusdemo/uploadfile/2_javaalpha.jpg','勤偷节约,积极上进','',51538126);
166 insert into tbl_detailinfo values('10017','hudongqin',8998.2,'2008-06-05','江西','宜春','上高',0,'足球,爬山,篮球','/WabacusDemo/wabacusdemo/uploadfile/2_jennyvenus.jpg','好吃懒做,游手好闲,好逸恶劳','',281538127);
167 insert into tbl_detailinfo values('10018','zhouhong',7654.7,'2007-08-11','福建','福州','永泰',0,'足球,爬山,排球','/WabacusDemo/wabacusdemo/uploadfile/2_jjkodada.jpg','勤偷节约,积极上进','',271538128);
168 insert into tbl_detailinfo values('10019','wuzhiqing',6745.3,'2006-07-17','广东','深圳','南山',1,'健身,篮球','/WabacusDemo/wabacusdemo/uploadfile/2_kaiyekai.jpg','努力勤奋,上进好学','',281538129);
169 insert into tbl_detailinfo values('10020','wuzhiguo',7655.4,'2005-08-20','广东','深圳','福田',0,'足球,爬山','/WabacusDemo/wabacusdemo/uploadfile/2_kakajay008.jpg','勤偷节约,积极上进','',291538130);
170 insert into tbl_detailinfo values('10021','wuqingshan',10080.3,'2005-06-15','福建','福州','连江',0,'旅游,跑步','/WabacusDemo/wabacusdemo/uploadfile/2_lbh119.jpg','勤偷节约,积极上进','',301538131);
171 insert into tbl_detailinfo values('10022','wangzhijian',2980.9,'2006-07-20','江西','宜春','高安',1,'健身,篮球','/WabacusDemo/wabacusdemo/uploadfile/2_liufang12381.jpg','好吃懒做,游手好闲,好逸恶劳','',311538132);
172 insert into tbl_detailinfo values('10023','wuliangguang',3800,'2007-03-20','广东','深圳','福田',0,'足球,篮球','/WabacusDemo/wabacusdemo/uploadfile/2_liuxk99.jpg','勤偷节约,积极上进','',321538134);
173 insert into tbl_detailinfo values('10024','huwenle',9890.3,'2006-03-23','广东','深圳','福田',1,'足球,爬山,游泳,排球','/WabacusDemo/wabacusdemo/uploadfile/2_luojianfeng.jpg','勤偷节约,积极上进','',331538135);
174 insert into tbl_detailinfo values('10025','hongliangliang',6551,'2008-04-21','福建','泉州','惠安',1,'排球,健身,篮球','/WabacusDemo/wabacusdemo/uploadfile/2_luxiaoshuai.jpg','好吃懒做,游手好闲,好逸恶劳','',341538136);
175 insert into tbl_detailinfo values('10026','fuluiming',3455.3,'2003-06-22','福建','福州','连江',1,'跑步,健身,篮球','/WabacusDemo/wabacusdemo/uploadfile/2_lzj_freedom.jpg','勤偷节约,积极上进','',351538137);
176 insert into tbl_detailinfo values('10027','huzhiying',5764.3,'2009-07-12','江西','宜春','上高',0,'旅游,跑步,健身,篮球','/WabacusDemo/wabacusdemo/uploadfile/2_minvt.jpg','好吃懒做,游手好闲,好逸恶劳','',361538138);
177 insert into tbl_detailinfo values('10028','gaohongbo',9832.3,'2007-03-13','福建','福州','连江',0,'排球,旅游,跑步','/WabacusDemo/wabacusdemo/uploadfile/2_pepeet.jpg','勤偷节约,积极上进','',371538139);
178 insert into tbl_detailinfo values('10029','liumingshu',4645,'2006-07-16','江西','南昌','新建',0,'跑步,健身,篮球','/WabacusDemo/wabacusdemo/uploadfile/2_pxh360395296.jpg','勤偷节约,积极上进','',381538140);
179 insert into tbl_detailinfo values('10030','huting',5789,'2004-11-02','广东','深圳','南山',0,'爬山,游泳,健身,篮球','/WabacusDemo/wabacusdemo/uploadfile/2_pzy0428.jpg','好吃懒做,游手好闲,好逸恶劳','',391538141);
180 insert into tbl_detailinfo values('10031','wujianzhong',3456,'2007-12-25','福建','福州','永泰',0,'足球,爬山,游泳','/WabacusDemo/wabacusdemo/uploadfile/2_q107770540.jpg','勤偷节约,积极上进','',401538142);
181 insert into tbl_detailinfo values('10032','wuzhicheng',9253,'2003-04-10','江西','南昌','进贤',1,'足球,爬山,篮球','/WabacusDemo/wabacusdemo/uploadfile/2_qiubojuncode.jpg','勤偷节约,积极上进','',411538143);
182 insert into tbl_detailinfo values('10033','shuweiguan',8992.5,'2000-10-16','广东','东莞','塘厦',0,'健身,篮球','/WabacusDemo/wabacusdemo/uploadfile/2_shineboyadh.jpg','努力勤奋,上进好学','',421538144);
183 insert into tbl_detailinfo values('10034','wuyuane',7687,'2002-08-23','福建','福州','永泰',1,'足球,爬山,篮球','/WabacusDemo/wabacusdemo/uploadfile/2_songpengasp.jpg','好吃懒做,游手好闲,好逸恶劳','',431538145);
184 insert into tbl_detailinfo values('10035','wuzhihong',2336,'2006-01-22','江西','宜春','高安',0,'排球,旅游,跑步','/WabacusDemo/wabacusdemo/uploadfile/2_steptodream.jpg','勤偷节约,积极上进','',441538146);
185 insert into tbl_detailinfo values('10036','wanxingguo',8566.3,'2005-11-23','福建','泉州','安溪',0,'游泳,排球','/WabacusDemo/wabacusdemo/uploadfile/2_stonekind.jpg','勤偷节约,积极上进','',451538147);
186 insert into tbl_detailinfo values('10037','fanguihong',3246,'2001-10-25','江西','南昌','新建',1,'跑步,健身,篮球','/WabacusDemo/wabacusdemo/uploadfile/2_tashiwoweiyi.jpg','好吃懒做,游手好闲,好逸恶劳','',461538148);
187 insert into tbl_detailinfo values('10038','songguozhen',9675,'2003-06-18','广东','东莞','长安',1,'足球,爬山,篮球','/WabacusDemo/wabacusdemo/uploadfile/2_teng_s2000.jpg','努力勤奋,上进好学','',471538149);
188 
189 
190 create table tbl_zhaoping(
191     id        int auto_increment NOT NULL,
192     zhiwei        varchar(30),
193     salary        float,
194     count        int,
195     xueli        varchar(30),
196     primary key (id)
197 );
198 insert into tbl_zhaoping values(null,'网络工程师',5030,1,'本科以上');
199 insert into tbl_zhaoping values(null,'软件工程师',6800,3,'本科以上');
200 insert into tbl_zhaoping values(null,'高级会计师',8000,1,'硕士以上');
201 insert into tbl_zhaoping values(null,'计算机运行维护工程师',4500,2,'专科以上');
202 insert into tbl_zhaoping values(null,'策划经理',8200,1,'本科以上');
203 insert into tbl_zhaoping values(null,'质量管理工程师',5500,5,'本科以上');
204 insert into tbl_zhaoping values(null,'普工',1200,20,'无');
205 insert into tbl_zhaoping values(null,'厨师',3000,2,'无');
206 insert into tbl_zhaoping values(null,'项目经理',8500,2,'本科以上');
207 
208 
209 create table tbl_zhaopingdesc(
210     id        int  NOT NULL,
211     yaoqiu        varchar(3000),
212     description    varchar(3000)
213 );
214 insert into tbl_zhaopingdesc values(1,'两年以上相关工作经验,工作刻苦,能承受工作压力,能出差','负责公司网络架构与维护以及网络相关产品的采购');
215 insert into tbl_zhaopingdesc values(2,'三年以上相关工作经验,学习能力强,能承受工作压力,能出差','负责公司所用软件的开发与维护,并培训公司员工使用');
216 insert into tbl_zhaopingdesc values(3,'五年以上相关工作经验,思维活跃,认真负责','负责公司做帐');
217 insert into tbl_zhaopingdesc values(4,'工作刻苦,能承受工作压力,能出差','负责公司所用电脑进行安装与维护');
218 insert into tbl_zhaopingdesc values(5,'三年以上相关工作经验,思维活跃,认真负责,责任心强,亲和力强','负责公司新产品的策划以及公司其它活动的组织和策划');
219 insert into tbl_zhaopingdesc values(6,',认真负责,工作刻苦,能承受工作压力,能出差','负责公司产品的测试');
220 insert into tbl_zhaopingdesc values(7,'工作刻苦,积极肯干,能承受工作压力,服从安排','负责公司产品的生产');
221 insert into tbl_zhaopingdesc values(8,'三年以上相关工作经验,工作刻苦,讲卫生','负责公司食堂炒菜煮饭');
222 insert into tbl_zhaopingdesc values(9,'三年以上相关工作经验,表达能力强,亲和力强','负责领导公司产品小组的开发与测试');
223 
224 create table tbl_zhaoping2(
225     id        int  NOT NULL,
226     zhiwei        varchar(30),
227     salary        float,
228     count        int,
229     xueli        varchar(30),
230     primary key (id)
231 );
232 insert into tbl_zhaoping2 values(1,'网络工程师2',5030,1,'本科以上');
233 insert into tbl_zhaoping2 values(2,'软件工程师2',6800,3,'本科以上');
234 insert into tbl_zhaoping2 values(3,'高级会计师2',8000,1,'硕士以上');
235 insert into tbl_zhaoping2 values(4,'计算机运行维护工程师2',4500,2,'专科以上');
236 insert into tbl_zhaoping2 values(5,'策划经理2',8200,1,'本科以上');
237 insert into tbl_zhaoping2 values(6,'质量管理工程师2',5500,5,'本科以上');
238 insert into tbl_zhaoping2 values(7,'普工2',1200,20,'无');
239 insert into tbl_zhaoping2 values(8,'厨师2',3000,2,'无');
240 insert into tbl_zhaoping2 values(9,'项目经理2',8500,2,'本科以上');
241 
242 
243 create table tbl_zhaopingdesc2(
244     id        int  NOT NULL,
245     yaoqiu        varchar(3000),
246     description    varchar(3000)
247 );
248 insert into tbl_zhaopingdesc2 values(1,'两年以上相关工作经验,工作刻苦,能承受工作压力,能出差','负责公司网络架构与维护以及网络相关产品的采购');
249 insert into tbl_zhaopingdesc2 values(2,'三年以上相关工作经验,学习能力强,能承受工作压力,能出差','负责公司所用软件的开发与维护,并培训公司员工使用');
250 insert into tbl_zhaopingdesc2 values(3,'五年以上相关工作经验,思维活跃,认真负责','负责公司做帐');
251 insert into tbl_zhaopingdesc2 values(4,'工作刻苦,能承受工作压力,能出差','负责公司所用电脑进行安装与维护');
252 insert into tbl_zhaopingdesc2 values(5,'三年以上相关工作经验,思维活跃,认真负责,责任心强,亲和力强','负责公司新产品的策划以及公司其它活动的组织和策划');
253 insert into tbl_zhaopingdesc2 values(6,',认真负责,工作刻苦,能承受工作压力,能出差','负责公司产品的测试');
254 insert into tbl_zhaopingdesc2 values(7,'工作刻苦,积极肯干,能承受工作压力,服从安排','负责公司产品的生产');
255 insert into tbl_zhaopingdesc2 values(8,'三年以上相关工作经验,工作刻苦,讲卫生','负责公司食堂炒菜煮饭');
256 insert into tbl_zhaopingdesc2 values(9,'三年以上相关工作经验,表达能力强,亲和力强','负责领导公司产品小组的开发与测试');
257 
258 CREATE TABLE tbl_salary2 (
259     no varchar(50),
260     year int null,
261     jan float null,
262     feb float NULL,
263     mar float NULL,
264     apr float NULL,
265     may float NULL,
266     june float NULL,
267     july float NULL,
268     aug float NULL,
269     sep float NULL,
270     oct float NULL,
271     nov float NULL,
272     dece float NULL
273 );
274 
275 insert into tbl_salary2 values('10001',2008,7575.3,6757,2426.2,2964.3,2422.5,4644.5,5234.2,7675.2,7680,8676,4744,6575.3);
276 insert into tbl_salary2 values('10002',2008,3543.3,6535,3433.2,4235.3,2454.5,5775.5,2335.2,6444.2,5467,5675,7568,5646.3);
277 insert into tbl_salary2 values('10003',2008,7867.3,5475,5463.2,1124.3,3532.5,4470.5,5346.2,6489.2,4469,5678,5458,5464.3);
278 insert into tbl_salary2 values('10004',2008,5346.3,6887,3535.2,1421.3,2453.5,10755.5,2422.2,3565.2,3567,5647,6857,3533.3);
279 insert into tbl_salary2 values('10005',2008,7689.3,3456,5357.2,3414.3,4663.5,6355.5,5435.2,5635.2,4653,6587,4364,3535.3);
280 insert into tbl_salary2 values('10006',2008,4355.3,3444,4645.2,4212.3,4278.5,2378.5,5343.2,5689.2,5754,6758,5675,4522.3);
281 insert into tbl_salary2 values('10007',2008,7870.3,7565,3535.2,5353.3,3453.5,12786.5,3536.2,6675.2,2367,5867,8966,3246.3);
282 insert into tbl_salary2 values('10008',2008,8967.3,4555,5354.2,3808.3,4257.5,2757.5,6444.2,6578.2,3424,7865,4564,3566.3);
283 insert into tbl_salary2 values('10009',2008,8656.3,7699,4356.2,7865.3,3535.5,8653.5,3535.2,7568.2,1954,5758,4654,5424.3);
284 insert into tbl_salary2 values('10010',2008,2243.3,5466,3464.2,6448.3,5362.5,3787.5,2345.2,7647.2,7576,7478,5657,4263.3);
285 insert into tbl_salary2 values('10011',2008,5798.3,3453,6543.2,5757.3,2346.5,5376.5,3424.2,6478.2,3556,4767,6347,3456.3);
286 insert into tbl_salary2 values('10012',2008,7867.3,6768,3536.2,9766.3,5423.5,8675.5,4647.2,5474.2,7555,5689,4643,5365.3);
287 
288 insert into tbl_salary2 values('10001',2009,8980.3,6789,7546.2,5464.3,2235.5,23453.5,6789.2,7866.2,9566,8676,6545,5646.3);
289 insert into tbl_salary2 values('10002',2009,8690.3,8866,3564.2,3432.3,2543.5,1276.5,4326.2,6458.2,7568,6746,7655,5464.3);
290 insert into tbl_salary2 values('10003',2009,5460.3,6475,3567.2,5353.3,2144.5,1256.5,8553.2,5690.2,5674,5867,4568,7866.3);
291 insert into tbl_salary2 values('10004',2009,2425.3,5768,8955.2,3357.3,2131.5,4786.5,5236.2,5757.2,4687,8696,7968,2355.3);
292 insert into tbl_salary2 values('10005',2009,3543.3,5457,8865.2,5333.3,2467.5,1576.5,1435.2,4633.2,6548,5675,2545,5422.3);
293 insert into tbl_salary2 values('10006',2009,7690.3,8708,5346.2,3454.3,2425.5,5456.5,5322.2,7988.2,4467,8796,6799,2422.3);
294 insert into tbl_salary2 values('10007',2009,5375.3,7797,7586.2,5464.3,5472.5,2435.5,2489.2,6759.2,6778,6765,69679,4224.3);
295 insert into tbl_salary2 values('10008',2009,6775.3,5688,8686.2,5467.3,2437.5,4669.5,3649.2,6570.2,6347,4765,5796,3535.3);
296 insert into tbl_salary2 values('10009',2009,2454.3,9977,4644.2,5353.3,3533.5,4568.5,4646.2,6757.2,5686,5889,5758,3542.3);
297 insert into tbl_salary2 values('10010',2009,5646.3,4575,4678.2,7567.3,2342.5,9564.5,5648.2,3654.2,5465,5856,5745,2425.3);
298 insert into tbl_salary2 values('10011',2009,3586.3,6842,7885.2,6545.3,2425.5,4366.5,7853.2,8066.2,7686,5787,5678,2635.3);
299 insert into tbl_salary2 values('10012',2009,6678.3,6478,5478.2,7956.3,5332.5,4697.5,3256.2,4589.2,6890,6467,7689,5648.3);
300 
301 
302 
303 CREATE TABLE tbl_salary (
304     no varchar(50),
305     year int null,
306     month int null,
307     salary float NULL 
308 );
309 
310 insert into tbl_salary values('10001',2008,1,3543.3);
311 insert into tbl_salary values('10001',2008,2,3643.3);
312 insert into tbl_salary values('10001',2008,3,3573.2);
313 insert into tbl_salary values('10001',2008,4,4543.3);
314 insert into tbl_salary values('10001',2008,5,3943.8);
315 insert into tbl_salary values('10001',2008,6,3547.3);
316 insert into tbl_salary values('10001',2008,7,3549.3);
317 insert into tbl_salary values('10001',2008,8,3543.0);
318 insert into tbl_salary values('10001',2008,9,3544.3);
319 insert into tbl_salary values('10001',2008,10,3343.6);
320 insert into tbl_salary values('10001',2008,11,3143.4);
321 insert into tbl_salary values('10001',2008,12,3943.3);
322 
323 insert into tbl_salary values('10002',2008,1,6343.3);
324 insert into tbl_salary values('10002',2008,2,6743.3);
325 insert into tbl_salary values('10002',2008,3,6843.3);
326 insert into tbl_salary values('10002',2008,4,6543.45);
327 insert into tbl_salary values('10002',2008,5,6342.0);
328 insert into tbl_salary values('10002',2008,6,6443.3);
329 insert into tbl_salary values('10002',2008,7,6541.3);
330 insert into tbl_salary values('10002',2008,8,6643.5);
331 insert into tbl_salary values('10002',2008,9,6844.3);
332 insert into tbl_salary values('10002',2008,10,7573.3);
333 insert into tbl_salary values('10002',2008,11,4593.7);
334 insert into tbl_salary values('10002',2008,12,6545.13);
335 
336 insert into tbl_salary values('10003',2008,1,5463.13);
337 insert into tbl_salary values('10003',2008,2,5142.2);
338 insert into tbl_salary values('10003',2008,3,5343.3);
339 insert into tbl_salary values('10003',2008,4,5543.7);
340 insert into tbl_salary values('10003',2008,5,5596.3);
341 insert into tbl_salary values('10003',2008,6,5543.3);
342 insert into tbl_salary values('10003',2008,7,5643.3);
343 insert into tbl_salary values('10003',2008,8,5579.9);
344 insert into tbl_salary values('10003',2008,9,5543.3);
345 insert into tbl_salary values('10003',2008,10,5540.3);
346 insert into tbl_salary values('10003',2008,11,5583.3);
347 insert into tbl_salary values('10003',2008,12,5841.0);
348 
349 insert into tbl_salary values('10004',2008,1,1583.6);
350 insert into tbl_salary values('10004',2008,2,1842.3);
351 insert into tbl_salary values('10004',2008,3,1563.8);
352 insert into tbl_salary values('10004',2008,4,1443.3);
353 insert into tbl_salary values('10004',2008,5,1508.3);
354 insert into tbl_salary values('10004',2008,6,1543.3);
355 insert into tbl_salary values('10004',2008,7,1643.9);
356 insert into tbl_salary values('10004',2008,8,1239.3);
357 insert into tbl_salary values('10004',2008,9,1743.3);
358 insert into tbl_salary values('10004',2008,10,1553.3);
359 insert into tbl_salary values('10004',2008,11,1943.5);
360 insert into tbl_salary values('10004',2008,12,1812.3);
361 
362 insert into tbl_salary values('10005',2008,1,3542.2);
363 insert into tbl_salary values('10005',2008,2,3713.3);
364 insert into tbl_salary values('10005',2008,3,3541.5);
365 insert into tbl_salary values('10005',2008,4,3843.3);
366 insert into tbl_salary values('10005',2008,5,3513.3);
367 insert into tbl_salary values('10005',2008,6,3040.7);
368 insert into tbl_salary values('10005',2008,7,3543.3);
369 insert into tbl_salary values('10005',2008,8,3523.2);
370 insert into tbl_salary values('10005',2008,9,3243.3);
371 insert into tbl_salary values('10005',2008,10,3527.3);
372 insert into tbl_salary values('10005',2008,11,3143.2);
373 insert into tbl_salary values('10005',2008,12,3549.3);
374 
375 insert into tbl_salary values('10006',2008,1,7543.3);
376 insert into tbl_salary values('10006',2008,2,7570.2);
377 insert into tbl_salary values('10006',2008,3,7543.3);
378 insert into tbl_salary values('10006',2008,4,7518.6);
379 insert into tbl_salary values('10006',2008,5,7543.3);
380 insert into tbl_salary values('10006',2008,6,7543.2);
381 insert into tbl_salary values('10006',2008,7,7593.3);
382 insert into tbl_salary values('10006',2008,8,7543.3);
383 insert into tbl_salary values('10006',2008,9,7549.3);
384 insert into tbl_salary values('10006',2008,10,7563.6);
385 insert into tbl_salary values('10006',2008,11,7540.3);
386 insert into tbl_salary values('10006',2008,12,7510.1);
387 
388 insert into tbl_salary values('10007',2008,1,6519.1);
389 insert into tbl_salary values('10007',2008,2,6343.3);
390 insert into tbl_salary values('10007',2008,3,6547.5);
391 insert into tbl_salary values('10007',2008,4,6753.3);
392 insert into tbl_salary values('10007',2008,5,6743.3);
393 insert into tbl_salary values('10007',2008,6,6541.7);
394 insert into tbl_salary values('10007',2008,7,6993.3);
395 insert into tbl_salary values('10007',2008,8,6507.3);
396 insert into tbl_salary values('10007',2008,9,6043.8);
397 insert into tbl_salary values('10007',2008,10,6943.3);
398 insert into tbl_salary values('10007',2008,11,6903.8);
399 insert into tbl_salary values('10007',2008,12,6213.5);
400 
401 
402 insert into tbl_salary values('10008',2008,1,3569.23);
403 insert into tbl_salary values('10008',2008,2,3643.3);
404 insert into tbl_salary values('10008',2008,3,3529.8);
405 insert into tbl_salary values('10008',2008,4,3523.3);
406 insert into tbl_salary values('10008',2008,5,3923.8);
407 insert into tbl_salary values('10008',2008,6,3544.3);
408 insert into tbl_salary values('10008',2008,7,3543.7);
409 insert into tbl_salary values('10008',2008,8,3013.3);
410 insert into tbl_salary values('10008',2008,9,3519.9);
411 insert into tbl_salary values('10008',2008,10,3313.0);
412 insert into tbl_salary values('10008',2008,11,3153.0);
413 insert into tbl_salary values('10008',2008,12,3189.8);
414 
415 insert into tbl_salary values('10009',2008,1,2829.2);
416 insert into tbl_salary values('10009',2008,2,2543.3);
417 insert into tbl_salary values('10009',2008,3,2610.3);
418 insert into tbl_salary values('10009',2008,4,2542.5);
419 insert into tbl_salary values('10009',2008,5,2433.3);
420 insert into tbl_salary values('10009',2008,6,2543.3);
421 insert into tbl_salary values('10009',2008,7,2538.3);
422 insert into tbl_salary values('10009',2008,8,2835.6);
423 insert into tbl_salary values('10009',2008,9,2518.3);
424 insert into tbl_salary values('10009',2008,10,2557.36);
425 insert into tbl_salary values('10009',2008,11,2913.3);
426 insert into tbl_salary values('10009',2008,12,2915.35);
427 
428 insert into tbl_salary values('10010',2008,1,10546.2);
429 insert into tbl_salary values('10010',2008,2,10513.3);
430 insert into tbl_salary values('10010',2008,3,10240.3);
431 insert into tbl_salary values('10010',2008,4,10543.4);
432 insert into tbl_salary values('10010',2008,5,10243.3);
433 insert into tbl_salary values('10010',2008,6,10592.3);
434 insert into tbl_salary values('10010',2008,7,10640.2);
435 insert into tbl_salary values('10010',2008,8,10540.3);
436 insert into tbl_salary values('10010',2008,9,10833.3);
437 insert into tbl_salary values('10010',2008,10,10543.3);
438 insert into tbl_salary values('10010',2008,11,10040.3);
439 insert into tbl_salary values('10010',2008,12,10801.6);
440 
441 insert into tbl_salary values('10011',2008,1,2830.0);
442 insert into tbl_salary values('10011',2008,2,2543.3);
443 insert into tbl_salary values('10011',2008,3,2122.5);
444 insert into tbl_salary values('10011',2008,4,2543.3);
445 insert into tbl_salary values('10011',2008,5,1912.6);
446 insert into tbl_salary values('10011',2008,6,2143.3);
447 insert into tbl_salary values('10011',2008,7,2508.8);
448 insert into tbl_salary values('10011',2008,8,2943.3);
449 insert into tbl_salary values('10011',2008,9,2505.8);
450 insert into tbl_salary values('10011',2008,10,2703.7);
451 insert into tbl_salary values('10011',2008,11,2216.6);
452 insert into tbl_salary values('10011',2008,12,2731.5);
453 
454 insert into tbl_salary values('10012',2008,1,12768.6);
455 insert into tbl_salary values('10012',2008,2,12643.2);
456 insert into tbl_salary values('10012',2008,3,12471.3);
457 insert into tbl_salary values('10012',2008,4,12143.0);
458 insert into tbl_salary values('10012',2008,5,12222.3);
459 insert into tbl_salary values('10012',2008,6,12243.0);
460 insert into tbl_salary values('10012',2008,7,12312.3);
461 insert into tbl_salary values('10012',2008,8,12043.0);
462 insert into tbl_salary values('10012',2008,9,12843.3);
463 insert into tbl_salary values('10012',2008,10,12510.2);
464 insert into tbl_salary values('10012',2008,11,12643.1);
465 insert into tbl_salary values('10012',2008,12,12560.8);
466 
467 insert into tbl_salary values('10001',2009,1,5546.3);
468 insert into tbl_salary values('10001',2009,2,5523.3);
469 insert into tbl_salary values('10001',2009,3,5543.3);
470 insert into tbl_salary values('10001',2009,4,5518.1);
471 insert into tbl_salary values('10001',2009,5,5643.1);
472 insert into tbl_salary values('10001',2009,6,5543.3);
473 insert into tbl_salary values('10001',2009,7,5943.2);
474 insert into tbl_salary values('10001',2009,8,5549.3);
475 insert into tbl_salary values('10001',2009,9,5443.3);
476 insert into tbl_salary values('10001',2009,10,5523.8);
477 insert into tbl_salary values('10001',2009,11,6543.3);
478 insert into tbl_salary values('10001',2009,12,5518.9);
479                                           
480 insert into tbl_salary values('10002',2009,1,8233.3);
481 insert into tbl_salary values('10002',2009,2,8343.13);
482 insert into tbl_salary values('10002',2009,3,8633.23);
483 insert into tbl_salary values('10002',2009,4,8723.3);
484 insert into tbl_salary values('10002',2009,5,8413.34);
485 insert into tbl_salary values('10002',2009,6,8533.62);
486 insert into tbl_salary values('10002',2009,7,8353.3);
487 insert into tbl_salary values('10002',2009,8,8283.3);
488 insert into tbl_salary values('10002',2009,9,8143.3);
489 insert into tbl_salary values('10002',2009,10,8673.8);
490 insert into tbl_salary values('10002',2009,11,8723.9);
491 insert into tbl_salary values('10002',2009,12,8833.31);
492                                           
493 insert into tbl_salary values('10003',2009,1,6703.3);
494 insert into tbl_salary values('10003',2009,2,6542.5);
495 insert into tbl_salary values('10003',2009,3,6593.3);
496 insert into tbl_salary values('10003',2009,4,6843.3);
497 insert into tbl_salary values('10003',2009,5,6541.13);
498 insert into tbl_salary values('10003',2009,6,6543.3);
499 insert into tbl_salary values('10003',2009,7,6533.0);
500 insert into tbl_salary values('10003',2009,8,6571.3);
501 insert into tbl_salary values('10003',2009,9,6243.3);
502 insert into tbl_salary values('10003',2009,10,6241.8);
503 insert into tbl_salary values('10003',2009,11,6573.3);
504 insert into tbl_salary values('10003',2009,12,6241.9);
505                                           
506 insert into tbl_salary values('10004',2009,1,2591.2);
507 insert into tbl_salary values('10004',2009,2,2643.3);
508 insert into tbl_salary values('10004',2009,3,2986.2);
509 insert into tbl_salary values('10004',2009,4,2543.3);
510 insert into tbl_salary values('10004',2009,5,2848.3);
511 insert into tbl_salary values('10004',2009,6,2543.7);
512 insert into tbl_salary values('10004',2009,7,26473.3);
513 insert into tbl_salary values('10004',2009,8,2549.3);
514 insert into tbl_salary values('10004',2009,9,2353.2);
515 insert into tbl_salary values('10004',2009,10,2543.3);
516 insert into tbl_salary values('10004',2009,11,2213.3);
517 insert into tbl_salary values('10004',2009,12,2142.1);
518                                          
519 insert into tbl_salary values('10005',2009,1,3811.2);
520 insert into tbl_salary values('10005',2009,2,3841.3);
521 insert into tbl_salary values('10005',2009,3,3842.3);
522 insert into tbl_salary values('10005',2009,4,3553.3);
523 insert into tbl_salary values('10005',2009,5,3847.3);
524 insert into tbl_salary values('10005',2009,6,3543.7);
525 insert into tbl_salary values('10005',2009,7,3542.3);
526 insert into tbl_salary values('10005',2009,8,3863.3);
527 insert into tbl_salary values('10005',2009,9,3541.2);
528 insert into tbl_salary values('10005',2009,10,3543.3);
529 insert into tbl_salary values('10005',2009,11,3743.3);
530 insert into tbl_salary values('10005',2009,12,3961.1);
531                                           
532 insert into tbl_salary values('10006',2009,1,7805.2);
533 insert into tbl_salary values('10006',2009,2,7803.3);
534 insert into tbl_salary values('10006',2009,3,7873.3);
535 insert into tbl_salary values('10006',2009,4,7883.8);
536 insert into tbl_salary values('10006',2009,5,7865.3);
537 insert into tbl_salary values('10006',2009,6,7843.3);
538 insert into tbl_salary values('10006',2009,7,782.4);
539 insert into tbl_salary values('10006',2009,8,7841.3);
540 insert into tbl_salary values('10006',2009,9,7843.1);
541 insert into tbl_salary values('10006',2009,10,7823.3);
542 insert into tbl_salary values('10006',2009,11,7843.1);
543 insert into tbl_salary values('10006',2009,12,7810.3);
544                                           
545 insert into tbl_salary values('10007',2009,1,7519.1);
546 insert into tbl_salary values('10007',2009,2,7348.3);
547 insert into tbl_salary values('10007',2009,3,7547.5);
548 insert into tbl_salary values('10007',2009,4,7558.4);
549 insert into tbl_salary values('10007',2009,5,7443.8);
550 insert into tbl_salary values('10007',2009,6,7541.7);
551 insert into tbl_salary values('10007',2009,7,7995.3);
552 insert into tbl_salary values('10007',2009,8,7507.3);
553 insert into tbl_salary values('10007',2009,9,7043.2);
554 insert into tbl_salary values('10007',2009,10,7943.2);
555 insert into tbl_salary values('10007',2009,11,7903.8);
556 insert into tbl_salary values('10007',2009,12,7215.1);
557                                    
558 insert into tbl_salary values('10008',2009,1,4169.23);
559 insert into tbl_salary values('10008',2009,2,4243.3);
560 insert into tbl_salary values('10008',2009,3,4529.8);
561 insert into tbl_salary values('10008',2009,4,3927.3);
562 insert into tbl_salary values('10008',2009,5,4783.8);
563 insert into tbl_salary values('10008',2009,6,3844.3);
564 insert into tbl_salary values('10008',2009,7,4543.7);
565 insert into tbl_salary values('10008',2009,8,4313.3);
566 insert into tbl_salary values('10008',2009,9,4519.9);
567 insert into tbl_salary values('10008',2009,10,3813.2);
568 insert into tbl_salary values('10008',2009,11,4453.2);
569 insert into tbl_salary values('10008',2009,12,4189.6);
570                                           
571 insert into tbl_salary values('10009',2009,1,3821.2);
572 insert into tbl_salary values('10009',2009,2,3543.0);
573 insert into tbl_salary values('10009',2009,3,3115.3);
574 insert into tbl_salary values('10009',2009,4,3542.5);
575 insert into tbl_salary values('10009',2009,5,3233.8);
576 insert into tbl_salary values('10009',2009,6,3545.3);
577 insert into tbl_salary values('10009',2009,7,2538.8);
578 insert into tbl_salary values('10009',2009,8,2935.6);
579 insert into tbl_salary values('10009',2009,9,3513.1);
580 insert into tbl_salary values('10009',2009,10,2557.9);
581 insert into tbl_salary values('10009',2009,11,3013.3);
582 insert into tbl_salary values('10009',2009,12,3016.8);
583                                           
584 insert into tbl_salary values('10010',2009,1,11546.2);
585 insert into tbl_salary values('10010',2009,2,11513.1);
586 insert into tbl_salary values('10010',2009,3,11240.0);
587 insert into tbl_salary values('10010',2009,4,10943.4);
588 insert into tbl_salary values('10010',2009,5,10843.7);
589 insert into tbl_salary values('10010',2009,6,11592.3);
590 insert into tbl_salary values('10010',2009,7,10646.2);
591 insert into tbl_salary values('10010',2009,8,10930.1);
592 insert into tbl_salary values('10010',2009,9,10938.2);
593 insert into tbl_salary values('10010',2009,10,11523.6);
594 insert into tbl_salary values('10010',2009,11,10940.3);
595 insert into tbl_salary values('10010',2009,12,11209.8);
596                                           
597 insert into tbl_salary values('10011',2009,1,3138.0);
598 insert into tbl_salary values('10011',2009,2,3043.3);
599 insert into tbl_salary values('10011',2009,3,3362.5);
600 insert into tbl_salary values('10011',2009,4,3245.6);
601 insert into tbl_salary values('10011',2009,5,3312.7);
602 insert into tbl_salary values('10011',2009,6,3547.2);
603 insert into tbl_salary values('10011',2009,7,3608.4);
604 insert into tbl_salary values('10011',2009,8,3042.1);
605 insert into tbl_salary values('10011',2009,9,3105.2);
606 insert into tbl_salary values('10011',2009,10,2902.0);
607 insert into tbl_salary values('10011',2009,11,3216.3);
608 insert into tbl_salary values('10011',2009,12,3035.6);
609                                           
610 insert into tbl_salary values('10012',2009,1,13162.3);
611 insert into tbl_salary values('10012',2009,2,13243.5);
612 insert into tbl_salary values('10012',2009,3,13178.5);
613 insert into tbl_salary values('10012',2009,4,13343.5);
614 insert into tbl_salary values('10012',2009,5,13128.8);
615 insert into tbl_salary values('10012',2009,6,13043.8);
616 insert into tbl_salary values('10012',2009,7,13612.3);
617 insert into tbl_salary values('10012',2009,8,12546.3);
618 insert into tbl_salary values('10012',2009,9,13345.2);
619 insert into tbl_salary values('10012',2009,10,13119.1);
620 insert into tbl_salary values('10012',2009,11,13049.8);
621 insert into tbl_salary values('10012',2009,12,13566.3);
622 
623 create table tbl_log(
624     uuid        varchar(50),
625     createdate    datetime,
626     content        varchar(200),
627     updatetype    varchar(20)
628 );
629 
630 create table tbl_testimport1(
631     no        varchar(20),    
632     name        varchar(30),
633     age        int,
634     birthday    date,
635     salary        float
636 );
637 
638 create table tbl_testimport2(
639     no        varchar(20),    
640     description    text
641 );
642 commit;
643 
644 DELIMITER $$ ;
645 
646 DROP PROCEDURE IF EXISTS `WabacusDemoDB`.`sp_testInsertData`$$
647 
648 CREATE  PROCEDURE `sp_testInsertData`(
649     in_uuid varchar(50),
650     in_deptno varchar(20),
651     in_deptname varchar(30),
652     in_manager varchar(30),
653     in_builtdate datetime,
654     in_performance varchar(20),
655     in_description varchar(3000),
656     out out_rtnValue varchar(500)
657 )
658 BEGIN
659     insert into tbl_department(guid,deptno,deptname,manager,builtdate,performance,description) values (in_uuid,in_deptno,in_deptname,in_manager,in_builtdate,in_performance,in_description);
660     set out_rtnValue=concat('添加工号:',in_deptno,',姓名:',in_deptname,'的记录成功');
661 END$$
662 
663 
664 DROP PROCEDURE IF EXISTS `WabacusDemoDB`.`sp_testUpdateData`$$
665 
666 CREATE PROCEDURE `sp_testUpdateData`(
667     in_deptno varchar(20),
668     in_deptno_old varchar(20),
669     in_manager varchar(30),
670     in_builtdate datetime,
671     in_performance varchar(20),
672     in_description varchar(3000),
673     out out_rtnValue varchar(50)
674 )
675 BEGIN
676     update tbl_department set deptno=in_deptno,manager=in_manager,builtdate=in_builtdate,performance=in_performance,description=in_description where deptno=in_deptno_old;
677     set out_rtnValue=concat('修改工号:',in_deptno_old,'的记录成功');
678 END$$
679 
680 DROP PROCEDURE IF EXISTS `WabacusDemoDB`.`sp_testDeleteData`$$
681 
682 CREATE  PROCEDURE `sp_testDeleteData`(
683     in_deptno varchar(20)
684 )
685 BEGIN
686      delete from tbl_department where deptno=in_deptno;
687 END$$
688 
689 DROP PROCEDURE IF EXISTS `WabacusDemoDB`.`sp_testInvokeServerSP`$$
690 
691 CREATE PROCEDURE `sp_testInvokeServerSP`(
692     in_uuid varchar(50),
693     in_now datetime,
694     in_param_no varchar(50),
695     in_content varchar(300)
696 )
697 BEGIN
698     update tbl_detailinfo set marriage=0 where no=in_param_no;
699     insert into tbl_log(uuid,createdate,content,updatetype)values(in_uuid,in_now,in_content,'设置为未婚状态');
700 END$$
701 
702 DROP PROCEDURE IF EXISTS sp_selectEmployeeData$$
703 
704 CREATE  PROCEDURE sp_selectEmployeeData(
705     txtno varchar(20),
706     txtprovince varchar(30),
707     txtage varchar(30),
708     i_systeminfo varchar(3000)
709 )
710 BEGIN
711     declare var_sql varchar(1000);    
712     set var_sql='SELECT A.no,name,ename,sex,age,salary,marriage,birthday,joinindate,province,city,county,description FROM tbl_baseinfo A left join tbl_detailinfo B on A.no=B.no where  1=1';
713     if txtno<>'' then set var_sql=concat(var_sql,' and A.no like  \'%',txtno,'%\''); end if;
714     if txtprovince<>'' then set var_sql=concat(var_sql,' and province like  \'%',txtprovince,'%\''); end if;
715     if txtage<>'' then set var_sql=concat(var_sql,' and A.age >=',txtage); end if;
716     call SP_WABACUS_EXECUTE (var_sql,'no,name desc',i_systeminfo);
717 END$$

 

 

 2.目录结构  wabacus4.1-release.zip 官网下

下完解压缩直接将WabacusBlank_project.zip包下的工程导入

然后依赖的第三方jar包和依赖的第三方客户端组件 导入

 

 

 

 

 2.wabcaus.cfg.xml 核心配置文件 可修改数据源信息

  1 <?xml version="1.0" encoding="UTF-8"?>
  2 <wabacus-config xmlns="http://www.wabacus.com"
  3                xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance"
  4                xsi:schemaLocation="http://www.wabacus.com xsd/wabacus.cfg.xsd">
  5     <system>
  6         <item name="webroot" value="/WabacusBlank"/><!-- 应用的根URL -->
  7         <item name="webroot-abspath" value=""/><!-- 默认为context.getRealPath("/")获取的值,可以直接配置根路径 -->
  8         <item name="showreport-url" value="/ShowReport.wx"/><!--显示报表数据的URL,就是在web.xml中配置的<url-pattern/>的值可以带参数-->
  9         <item name="encode" value="UTF-8"/>
 10         <item name="show-sql" value="true"/><!-- 是否显示执行的SQL语句或存储过程 -->
 11         <item name="default-cellresize" value="2"/><!-- 指定整个项目中所有单行表头的数据自动列表报表的表格单元格默认可移动性 -->
 12         <item name="default-labelstyle" value="1"/><!-- 查询条件提示标签的显示位置 -->
 13         <item name="server-validate-class" value=""/><!-- 自己开发的服务器端校验类 -->
 14         <item name="skin" value="vista"/><!-- 皮肤样式 -->
 15         <item name="default-checkpermission" value="true"/><!-- 本应用是否要检查权限,如果在不需要检查权限的应用中关闭它,可以改善性能 -->
 16         <item name="prompt-dialog-type" value="artdialog"/><!-- 提示组件类型 ymprompt;artdialog-->
 17     </system>
 18     <datasources default="ds_mysql">
 19         <datasource name="ds_sqlserver2k" type="com.wabacus.config.database.datasource.C3P0DataSource"
 20             dbtype="com.wabacus.config.database.type.SQLSERVER2K">
 21             <property name="driver">net.sourceforge.jtds.jdbc.Driver</property>
 22             <property name="url">jdbc:jtds:sqlserver://localhost:1433;DatabaseName=WabacusDemoDB</property>
 23             <property name="user">sa</property>
 24             <property name="password">111111</property>
 25             
 26             <property name="max_size">20</property>   
 27               <property name="min_size">5</property>   
 28               <property name="timeout">100</property>   
 29               <property name="max_statements">100</property>   
 30               <property name="idle_test_period">50</property>   
 31               <property name="acquire_increment">2</property>  
 32         </datasource>
 33         <datasource name="ds_sqlserver2k5" type="com.wabacus.config.database.datasource.C3P0DataSource"
 34             dbtype="com.wabacus.config.database.type.SQLSERVER2K5">
 35             <property name="driver">net.sourceforge.jtds.jdbc.Driver</property>
 36             <property name="url">jdbc:jtds:sqlserver://localhost:1433;DatabaseName=WabacusDemoDB</property>
 37             <property name="user">sa</property>
 38             <property name="password">sse#2007</property>
 39             
 40             <property name="max_size">20</property>   
 41               <property name="min_size">5</property>   
 42               <property name="timeout">100</property>   
 43               <property name="max_statements">100</property>   
 44               <property name="idle_test_period">50</property>   
 45               <property name="acquire_increment">2</property>  
 46         </datasource>
 47         <datasource name="ds_oracle" type="com.wabacus.config.database.datasource.C3P0DataSource"
 48             dbtype="com.wabacus.config.database.type.Oracle">
 49             <property name="driver">oracle.jdbc.driver.OracleDriver</property>
 50             <property name="url">jdbc:oracle:thin:@localhost:1521:WabacusDemoDB</property>
 51             <property name="user">scott</property>
 52             <property name="password">tiger</property>
 53             
 54             <property name="max_size">20</property>   
 55               <property name="min_size">5</property>   
 56               <property name="timeout">100</property>   
 57               <property name="max_statements">100</property>   
 58               <property name="idle_test_period">50</property>   
 59               <property name="acquire_increment">2</property>  
 60         </datasource>
 61         <datasource name="ds_mysql" type="com.wabacus.config.database.datasource.C3P0DataSource"
 62             dbtype="com.wabacus.config.database.type.MySql">
 63             <property name="driver">com.mysql.jdbc.Driver</property>
 64             <property name="url"><![CDATA[jdbc:mysql://localhost/wabacusdemodb?useUnicode=true&characterEncoding=GBK]]></property>
 65             <property name="user">root</property>
 66             <property name="password">123456</property>
 67             
 68             <property name="max_size">20</property>   
 69               <property name="min_size">5</property>   
 70               <property name="timeout">100</property>   
 71               <property name="max_statements">100</property>   
 72               <property name="idle_test_period">50</property>   
 73               <property name="acquire_increment">2</property>  
 74         </datasource>
 75         <!-- 演示Proxool配置的数据源 -->
 76         <!--datasource name="ds_mysql_proxool" type="com.wabacus.config.database.datasource.ProxoolDataSource"
 77             dbtype="com.wabacus.config.database.type.MySql">
 78             <property name="alias">proxool_pool</property>
 79             <property name="configfile">proxool.xml</property>
 80         </datasource-->
 81         <!-- 演示JNDI方式配置的数据源 -->
 82         <!--datasource name="ds_sqlserver2k5" type="com.wabacus.config.database.datasource.JNDIDataSource"
 83             dbtype="com.wabacus.config.database.type.SQLSERVER2K5">
 84             <property name="jndi">java:comp/env/demoSource</property>
 85         </datasource-->
 86         <!-- 演示直接用DriverManager配置的数据源 -->
 87         <!--datasource name="ds_sqlserver2k5" type="com.wabacus.config.database.datasource.DriverManagerDataSource"
 88             dbtype="com.wabacus.config.database.type.SQLSERVER2K5">
 89             <property name="driver">net.sourceforge.jtds.jdbc.Driver</property>
 90             <property name="url">jdbc:jtds:sqlserver://localhost:1433;DatabaseName=szseWebDB3</property>
 91             <property name="user">sa</property>
 92             <property name="password">111111</property>
 93         </datasource-->
 94     </datasources>
 95 
 96     <inputbox-types/>
 97     
 98     <!-- 配置本项目中所有报表页面都必须包含的js文件 -->
 99     <global-jsfiles/>
100     
101     <!-- 配置本项目中所有报表页面都必须包含的css文件 -->
102     <global-cssfiles/>
103         
104     <i18n-resources file="resources/i18n/ApplicationResources.xml"/>
105     
106     <!-- 注册所有全局资源文件 -->
107     <global-resources/>
108     
109     <!-- 注册所有报表配置文件 -->
110     <report-files>
111           <report-file>report/report.xml</report-file>
112     </report-files>
113 </wabacus-config>

 

2.测试地址:

http://localhost:8080/WabacusBlank/ShowReport.wx?PAGEID=listpage1

 

posted on 2016-06-22 13:51  Sharpest  阅读(3612)  评论(0)    收藏  举报