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