惯性聚合 高效追踪和阅读你感兴趣的博客、新闻、科技资讯
阅读原文 在惯性聚合中打开

推荐订阅源

Google DeepMind News
Google DeepMind News
aimingoo的专栏
aimingoo的专栏
爱范儿
爱范儿
D
Docker
I
InfoQ
Microsoft Security Blog
Microsoft Security Blog
G
Google Developers Blog
OSCHINA 社区最新新闻
OSCHINA 社区最新新闻
Vercel News
Vercel News
H
Hackread – Cybersecurity News, Data Breaches, AI and More
T
Tailwind CSS Blog
D
DataBreaches.Net
月光博客
月光博客
N
Netflix TechBlog - Medium
Cyber Security Advisories - MS-ISAC
Cyber Security Advisories - MS-ISAC
让小产品的独立变现更简单 - ezindie.com
让小产品的独立变现更简单 - ezindie.com
V
Visual Studio Blog
MyScale Blog
MyScale Blog
B
Blog
阮一峰的网络日志
阮一峰的网络日志
L
LangChain Blog
Recent Announcements
Recent Announcements
Microsoft Azure Blog
Microsoft Azure Blog
WordPress大学
WordPress大学

博客园 - shareach

博客搬家了，欢迎访问 http://blog.csdn.net/yinpengxiang/ IOS Storyboard使用-模拟登录、注册、混合使用 XCode 细点 蛋痛的C#和.net，采集问题（小数点） Mapbar POI 转 经纬度坐标的各个版本 MongoDB的主键类型修改，记录下 Android 自动化功能测试神器ChimpChat(MonkeyRunner) .Net C# 的一个bug（暂时命名为Bug） MongoDB的GeoSpatial索引 之 GeoNear命令，取得距离 MongoDB的GeoSpatial索引 Android + HTML开发手机应用 demo 代码 commonsware-Android平台可复用代码仓库 jqMobi + Android 试手 服务端通过设置 响应头允许其他域名跨域访问数据 Android上 用Html5做界面，javascript调用摄像头实例 Android 拍照加剪切处理方式 css3替代图片的尖角圆角效果 抛弃作为mongoDB做主存储的一些关键因素 基于即时更新的缓存策略设计草稿
ibatis3.06 + spring 3.06+velocity 整合的VSSI框架测试
shareach · 2011-12-07 · via 博客园 - shareach

好多年没动过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项目压缩文件下载

此内容由惯性聚合(RSS阅读器)自动聚合整理，仅供阅读参考。 原文来自 — 版权归原作者所有。