Ibatis3.06 + spring 3.06 + velocity integrated vssi framework Testing

I haven't moved J2EE for many years. After two nights, I finally got a full set of 3.0 vssi frameworks. Later I went on to the codesmith template, and I haven't tested it yet, download all code and Eclipse project compressed files

Reference http://code.google.com/p/mybatis/wiki/Spring

MySQL database uses the item table of jpetshop. The table structure is:
Create Table 'item '(
'Itemid' varchar (10) Collate utf8_bin not null,
'Produtid' varchar (10) Collate utf8_bin not null,
'Listprice' decimal (10, 2) default null,
'Unitcost' decimal () default null,
'Provision' 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 '('provision '),
Key 'itemprod' ('produd D ')
) Engine = MyISAM default charset = utf8 collate = utf8_bin

Table data:
Insert into 'item' ('itemid', 'produd d', 'listprice', 'unitcost', 'provision', 'status', 'attr1', 'attr2 ', 'attr3', 'attr4', 'attr5') values ('Est-1', 'fi-SW-01 ', '16. 50', '10. 00', '1', 'P', 'large ', null );
Insert into 'item' ('itemid', 'produd d', 'listprice', 'unitcost', 'provision', 'status', 'attr1', 'attr2 ', 'attr3', 'attr4', 'attr5') values ('Est-2', 'fi-SW-01 ', '16. 50', '10. 00', '1', 'P', 'small', null );
Insert into 'item' ('itemid', 'produd d', 'listprice', 'unitcost', 'provision', 'status', 'attr1', 'attr2 ', 'attr3', 'attr4', 'attr5') values ('Est-3', 'fi-SW-02 ', '18. 50', '12. 00', '1', 'P', 'toothless ', null );
Insert into 'item' ('itemid', 'produd d', 'listprice', 'unitcost', 'provision', 'status', 'attr1', 'attr2 ', 'attr3', 'attr4', 'attr5') values ('Est-4', 'fi-FW-01 ', '18. 50', '12. 00', '1', 'P', 'spotted', null );
Insert into 'item' ('itemid', 'produd d', 'listprice', 'unitcost', 'provision', 'status', 'attr1', 'attr2 ', 'attr3', 'attr4', 'attr5') values ('Est-5', 'fi-FW-01 ', '18. 50', '12. 00', '1', 'P', 'spots', null );
Insert into 'item' ('itemid', 'produd d', 'listprice', 'unitcost', 'provision', 'status', 'attr1', 'attr2 ', 'attr3', 'attr4', 'attr5') values ('Est-6', 'k9-BD-01 ', '18. 50', '12. 00', '1', 'P', 'male adresult', null );
Insert into 'item' ('itemid', 'produd d', 'listprice', 'unitcost', 'provision', 'status', 'attr1', 'attr2 ', 'attr3', 'attr4', 'attr5') values ('Est-7', 'k9-BD-01 ', '18. 50', '12. 00', '1', 'P', 'female puppy ', null );
Insert into 'item' ('itemid', 'produd d', 'listprice', 'unitcost', 'provision', 'status', 'attr1', 'attr2 ', 'attr3', 'attr4', 'attr5') values ('Est-8', 'k9-PO-02 ', '18. 50', '12. 00', '1', 'P', 'male puppy ', null );
Insert into 'item' ('itemid', 'produd d', 'listprice', 'unitcost', 'provision', 'status', 'attr1', 'attr2 ', 'attr3', 'attr4', 'attr5') values ('Est-9', 'k9-DL-01 ', '18. 50', '12. 00', '1', 'P', 'spotless male puppy ', null );
Insert into 'item' ('itemid', 'produd d', 'listprice', 'unitcost', 'provision', 'status', 'attr1', 'attr2 ', 'attr3', 'attr4', 'attr5') values ('Est-10', 'k9-DL-01 ', '18. 50', '12. 00', '1', 'P', 'spotted adult female ', null );
Insert into 'item' ('itemid', 'produd d', 'listprice', 'unitcost', 'provision', 'status', 'attr1', 'attr2 ', 'attr3', 'attr4', 'attr5') values ('Est-11', 'rp-SN-01 ', '18. 50', '12. 00', '1', 'P', 'venomless ', null );
Insert into 'item' ('itemid', 'produd d', 'listprice', 'unitcost', 'provision', 'status', 'attr1', 'attr2 ', 'attr3', 'attr4', 'attr5') values ('Est-12', 'rp-SN-01 ', '18. 50', '12. 00', '1', 'P', 'rattleless ', null );
Insert into 'item' ('itemid', 'produd d', 'listprice', 'unitcost', 'provision', 'status', 'attr1', 'attr2 ', 'attr3', 'attr4', 'attr5') values ('Est-13', 'rp-LI-02 ', '18. 50', '12. 00', '1', 'P', 'green adresult', null );
Insert into 'item' ('itemid', 'produd d', 'listprice', 'unitcost', 'provision', 'status', 'attr1', 'attr2 ', 'attr3', 'attr4', 'attr5') values ('Est-14', 'fl-DSH-01 ', '58. 50', '12. 00', '1', 'P', 'tailless ', null );
Insert into 'item' ('itemid', 'produd d', 'listprice', 'unitcost', 'provision', 'status', 'attr1', 'attr2 ', 'attr3', 'attr4', 'attr5') values ('Est-15', 'fl-DSH-01 ', '23. 50', '12. 00', '1', 'P', 'with tail', null );
Insert into 'item' ('itemid', 'produd d', 'listprice', 'unitcost', 'provision', 'status', 'attr1', 'attr2 ', 'attr3', 'attr4', 'attr5') values ('Est-16', 'fl-DLH-02 ', '93. 50', '12. 00', '1', 'P', 'Adult female ', null );
Insert into 'item' ('itemid', 'produd d', 'listprice', 'unitcost', 'provision', 'status', 'attr1', 'attr2 ', 'attr3', 'attr4', 'attr5') values ('Est-17', 'fl-DLH-02 ', '93. 50', '12. 00', '1', 'P', 'Adult male ', null );
Insert into 'item' ('itemid', 'produd d', 'listprice', 'unitcost', 'provision', 'status', 'attr1', 'attr2 ', 'attr3', 'attr4', 'attr5') values ('Est-18', 'av-CB-01', '2017. 50', '92. 00', '1', 'P', 'Adult male ', null );
Insert into 'item' ('itemid', 'produd d', 'listprice', 'unitcost', 'provision', 'status', 'attr1', 'attr2 ', 'attr3', 'attr4', 'attr5') values ('Est-19', 'av-SB-02 ', '15. 50', '2. 00', '1', 'P', 'Adult male ', null );
Insert into 'item' ('itemid', 'produd d', 'listprice', 'unitcost', 'provision', 'status', 'attr1', 'attr2 ', 'attr3', 'attr4', 'attr5') values ('Est-20', 'fi-FW-02 ', '5. 50', '2. 00', '1', 'P', 'Adult male ', null );
Insert into 'item' ('itemid', 'produd d', 'listprice', 'unitcost', 'provision', 'status', 'attr1', 'attr2 ', 'attr3', 'attr4', 'attr5') values ('Est-21', 'fi-FW-02 ', '5. 29', '1. 00', '1', 'P', 'Adult female ', null );
Insert into 'item' ('itemid', 'produd d', 'listprice', 'unitcost', 'provision', 'status', 'attr1', 'attr2 ', 'attr3', 'attr4', 'attr5') values ('Est-22', 'k9-RT-02 ', '2017. 50', '2017. 00', '1', 'P', 'Adult male ', null );
Insert into 'item' ('itemid', 'produd d', 'listprice', 'unitcost', 'provision', 'status', 'attr1', 'attr2 ', 'attr3', 'attr4', 'attr5') values ('Est-23', 'k9-RT-02 ', '2017. 49', '2017. 00', '1', 'P', 'Adult female ', null );
Insert into 'item' ('itemid', 'produd d', 'listprice', 'unitcost', 'provision', 'status', 'attr1', 'attr2 ', 'attr3', 'attr4', 'attr5') values ('Est-24', 'k9-RT-02 ', '2017. 50', '92. 00', '1', 'P', 'Adult male ', null );
Insert into 'item' ('itemid', 'produd d', 'listprice', 'unitcost', 'provision', 'status', 'attr1', 'attr2 ', 'attr3', 'attr4', 'attr5') values ('Est-25', 'k9-RT-02 ', '2017. 29', '90. 00', '1', 'P', 'Adult female ', null );
Insert into 'item' ('itemid', 'produd d', 'listprice', 'unitcost', 'provision', 'status', 'attr1', 'attr2 ', 'attr3', 'attr4', 'attr5') values ('Est-26', 'k9-CW-01 ', '2017. 50', '92. 00', '1', 'P', 'Adult male ', null );
Insert into 'item' ('itemid', 'produd d', 'listprice', 'unitcost', 'provision', 'status', 'attr1', 'attr2 ', 'attr3', 'attr4', 'attr5') values ('Est-27', 'k9-CW-01 ', '2017. 29', '90. 00', '1', 'P', 'Adult female ', null );
Insert into 'item' ('itemid', 'produd d', 'listprice', 'unitcost', 'provision', 'status', 'attr1', 'attr2 ', 'attr3', 'attr4', 'attr5') values ('Est-28', 'k9-RT-01 ', '2017. 29', '90. 00', '1', 'P', 'Adult female ', null );

Eclipse indigo, jdk1.6, Tomcat 6, all code and Eclipse project compressed file download