ibatis3.06 + spring 3.06+velocity 整合的VSSI框架测试

好多年没动过J2ee了,搞了2个晚上终于整出了全套3.0的VSSI框架, 后面继续CodeSmith模版,写完了还没测试,全部代码和Eclipse项目压缩文件下载

参考资料 http://code.google.com/p/mybatis/wiki/Spring

mysql 数据库,用了 JPetShop的Item表,表结构是: 
CREATE TABLE `item` (                                  
         `itemid` varchar(10) collate utf8_bin NOT NULL,      
         `productid` varchar(10) collate utf8_bin NOT NULL,   
         `listprice` decimal(10,2) default NULL,              
         `unitcost` decimal(10,2) default NULL,               
         `supplier` int(11) default NULL,                     
         `status` varchar(2) collate utf8_bin default NULL,   
         `attr1` varchar(80) collate utf8_bin default NULL,   
         `attr2` varchar(80) collate utf8_bin default NULL,   
         `attr3` varchar(80) collate utf8_bin default NULL,   
         `attr4` varchar(80) collate utf8_bin default NULL,   
         `attr5` varchar(80) collate utf8_bin default NULL,   
         PRIMARY KEY  (`itemid`),                             
         KEY `fk_item_2` (`supplier`),                        
         KEY `itemProd` (`productid`)                         
       ) ENGINE=MyISAM DEFAULT CHARSET=utf8 COLLATE=utf8_bin 

表数据: 
insert into `item` (`itemid`, `productid`, `listprice`, `unitcost`, `supplier`, `status`, `attr1`, `attr2`, `attr3`, `attr4`, `attr5`) values('EST-1','FI-SW-01','16.50','10.00','1','P','Large',NULL,NULL,NULL,NULL); 
insert into `item` (`itemid`, `productid`, `listprice`, `unitcost`, `supplier`, `status`, `attr1`, `attr2`, `attr3`, `attr4`, `attr5`) values('EST-2','FI-SW-01','16.50','10.00','1','P','Small',NULL,NULL,NULL,NULL); 
insert into `item` (`itemid`, `productid`, `listprice`, `unitcost`, `supplier`, `status`, `attr1`, `attr2`, `attr3`, `attr4`, `attr5`) values('EST-3','FI-SW-02','18.50','12.00','1','P','Toothless',NULL,NULL,NULL,NULL); 
insert into `item` (`itemid`, `productid`, `listprice`, `unitcost`, `supplier`, `status`, `attr1`, `attr2`, `attr3`, `attr4`, `attr5`) values('EST-4','FI-FW-01','18.50','12.00','1','P','Spotted',NULL,NULL,NULL,NULL); 
insert into `item` (`itemid`, `productid`, `listprice`, `unitcost`, `supplier`, `status`, `attr1`, `attr2`, `attr3`, `attr4`, `attr5`) values('EST-5','FI-FW-01','18.50','12.00','1','P','Spotless',NULL,NULL,NULL,NULL); 
insert into `item` (`itemid`, `productid`, `listprice`, `unitcost`, `supplier`, `status`, `attr1`, `attr2`, `attr3`, `attr4`, `attr5`) values('EST-6','K9-BD-01','18.50','12.00','1','P','Male Adult',NULL,NULL,NULL,NULL); 
insert into `item` (`itemid`, `productid`, `listprice`, `unitcost`, `supplier`, `status`, `attr1`, `attr2`, `attr3`, `attr4`, `attr5`) values('EST-7','K9-BD-01','18.50','12.00','1','P','Female Puppy',NULL,NULL,NULL,NULL); 
insert into `item` (`itemid`, `productid`, `listprice`, `unitcost`, `supplier`, `status`, `attr1`, `attr2`, `attr3`, `attr4`, `attr5`) values('EST-8','K9-PO-02','18.50','12.00','1','P','Male Puppy',NULL,NULL,NULL,NULL); 
insert into `item` (`itemid`, `productid`, `listprice`, `unitcost`, `supplier`, `status`, `attr1`, `attr2`, `attr3`, `attr4`, `attr5`) values('EST-9','K9-DL-01','18.50','12.00','1','P','Spotless Male Puppy',NULL,NULL,NULL,NULL); 
insert into `item` (`itemid`, `productid`, `listprice`, `unitcost`, `supplier`, `status`, `attr1`, `attr2`, `attr3`, `attr4`, `attr5`) values('EST-10','K9-DL-01','18.50','12.00','1','P','Spotted Adult Female',NULL,NULL,NULL,NULL); 
insert into `item` (`itemid`, `productid`, `listprice`, `unitcost`, `supplier`, `status`, `attr1`, `attr2`, `attr3`, `attr4`, `attr5`) values('EST-11','RP-SN-01','18.50','12.00','1','P','Venomless',NULL,NULL,NULL,NULL); 
insert into `item` (`itemid`, `productid`, `listprice`, `unitcost`, `supplier`, `status`, `attr1`, `attr2`, `attr3`, `attr4`, `attr5`) values('EST-12','RP-SN-01','18.50','12.00','1','P','Rattleless',NULL,NULL,NULL,NULL); 
insert into `item` (`itemid`, `productid`, `listprice`, `unitcost`, `supplier`, `status`, `attr1`, `attr2`, `attr3`, `attr4`, `attr5`) values('EST-13','RP-LI-02','18.50','12.00','1','P','Green Adult',NULL,NULL,NULL,NULL); 
insert into `item` (`itemid`, `productid`, `listprice`, `unitcost`, `supplier`, `status`, `attr1`, `attr2`, `attr3`, `attr4`, `attr5`) values('EST-14','FL-DSH-01','58.50','12.00','1','P','Tailless',NULL,NULL,NULL,NULL); 
insert into `item` (`itemid`, `productid`, `listprice`, `unitcost`, `supplier`, `status`, `attr1`, `attr2`, `attr3`, `attr4`, `attr5`) values('EST-15','FL-DSH-01','23.50','12.00','1','P','With tail',NULL,NULL,NULL,NULL); 
insert into `item` (`itemid`, `productid`, `listprice`, `unitcost`, `supplier`, `status`, `attr1`, `attr2`, `attr3`, `attr4`, `attr5`) values('EST-16','FL-DLH-02','93.50','12.00','1','P','Adult Female',NULL,NULL,NULL,NULL); 
insert into `item` (`itemid`, `productid`, `listprice`, `unitcost`, `supplier`, `status`, `attr1`, `attr2`, `attr3`, `attr4`, `attr5`) values('EST-17','FL-DLH-02','93.50','12.00','1','P','Adult Male',NULL,NULL,NULL,NULL); 
insert into `item` (`itemid`, `productid`, `listprice`, `unitcost`, `supplier`, `status`, `attr1`, `attr2`, `attr3`, `attr4`, `attr5`) values('EST-18','AV-CB-01','193.50','92.00','1','P','Adult Male',NULL,NULL,NULL,NULL); 
insert into `item` (`itemid`, `productid`, `listprice`, `unitcost`, `supplier`, `status`, `attr1`, `attr2`, `attr3`, `attr4`, `attr5`) values('EST-19','AV-SB-02','15.50','2.00','1','P','Adult Male',NULL,NULL,NULL,NULL); 
insert into `item` (`itemid`, `productid`, `listprice`, `unitcost`, `supplier`, `status`, `attr1`, `attr2`, `attr3`, `attr4`, `attr5`) values('EST-20','FI-FW-02','5.50','2.00','1','P','Adult Male',NULL,NULL,NULL,NULL); 
insert into `item` (`itemid`, `productid`, `listprice`, `unitcost`, `supplier`, `status`, `attr1`, `attr2`, `attr3`, `attr4`, `attr5`) values('EST-21','FI-FW-02','5.29','1.00','1','P','Adult Female',NULL,NULL,NULL,NULL); 
insert into `item` (`itemid`, `productid`, `listprice`, `unitcost`, `supplier`, `status`, `attr1`, `attr2`, `attr3`, `attr4`, `attr5`) values('EST-22','K9-RT-02','135.50','100.00','1','P','Adult Male',NULL,NULL,NULL,NULL); 
insert into `item` (`itemid`, `productid`, `listprice`, `unitcost`, `supplier`, `status`, `attr1`, `attr2`, `attr3`, `attr4`, `attr5`) values('EST-23','K9-RT-02','145.49','100.00','1','P','Adult Female',NULL,NULL,NULL,NULL); 
insert into `item` (`itemid`, `productid`, `listprice`, `unitcost`, `supplier`, `status`, `attr1`, `attr2`, `attr3`, `attr4`, `attr5`) values('EST-24','K9-RT-02','255.50','92.00','1','P','Adult Male',NULL,NULL,NULL,NULL); 
insert into `item` (`itemid`, `productid`, `listprice`, `unitcost`, `supplier`, `status`, `attr1`, `attr2`, `attr3`, `attr4`, `attr5`) values('EST-25','K9-RT-02','325.29','90.00','1','P','Adult Female',NULL,NULL,NULL,NULL); 
insert into `item` (`itemid`, `productid`, `listprice`, `unitcost`, `supplier`, `status`, `attr1`, `attr2`, `attr3`, `attr4`, `attr5`) values('EST-26','K9-CW-01','125.50','92.00','1','P','Adult Male',NULL,NULL,NULL,NULL); 
insert into `item` (`itemid`, `productid`, `listprice`, `unitcost`, `supplier`, `status`, `attr1`, `attr2`, `attr3`, `attr4`, `attr5`) values('EST-27','K9-CW-01','155.29','90.00','1','P','Adult Female',NULL,NULL,NULL,NULL); 
insert into `item` (`itemid`, `productid`, `listprice`, `unitcost`, `supplier`, `status`, `attr1`, `attr2`, `attr3`, `attr4`, `attr5`) values('EST-28','K9-RT-01','155.29','90.00','1','P','Adult Female',NULL,NULL,NULL,NULL); 

eclipse Indigo, JDK1.6, Tomcat 6 ,全部代码和Eclipse项目压缩文件下载

posted @ 2012-02-19 10:45  张良  阅读(465)  评论(0编辑  收藏  举报