转自:http://www.baiyuxiong.com/?p=797
1、MYSQL建表petstore,导入数据petstore\dal\src\main\resources\petstore\dal\sql
2、DAL POM.XML添加MYSQL JAR包依赖
3、修改data-source.xml
<bean id="dataSource" class="org.springframework.jdbc.datasource.DriverManagerDataSource">
<property name="driverClassName" value="com.mysql.jdbc.Driver"/>
<property name="url" value="jdbc:mysql://127.0.0.1:3306/petstore"/>
<property name="username" value="root"/>
<property name="password" value=""/>
</bean>
4、修改几处测试用例
有测试用户全报错,因为测试数据长于字段定义的长度。
petstore\dal\src\test\java\com\alibaba\sample\petstore\dal\dao\OrderDaoTests.java 69行和72行:
order.setExpiryDate和order.setStatus,值都改成1个字符,
5、修改一句SQL
\petstore\dal\src\main\resources\petstore\dal\sqlmap\ProductItem.xml改成下面这样:
<select id="getItemListByProduct" resultMap="resultWithQuantity" parameterClass="string"><![CDATA[
select
I.ITEMID, LISTPRICE, UNITCOST, SUPPLIER, I.PRODUCTID, NAME,
DESCN, CATEGORY, STATUS, ATTR1, ATTR2, ATTR3, ATTR4, ATTR5, QTY
from ITEM I, PRODUCT P, INVENTORY N where P.PRODUCTID = I.PRODUCTID and I.PRODUCTID = #value# and N.ITEMID=I.ITEMID
]]></select>