|
?最近搞Jpetstore 碰到的问题,步骤如下：
1,下载Jpetstore 5.0
2，创建jpetstore项目，把下载的项目copy过去，并把devlib,lib copy 到web-inf/lib下
3，根据数据库的不同改数据库链接。
mssql2000如下：
driver=com.microsoft.jdbc.sqlserver.SQLServerDriver
url=jdbc:microsoft:sqlserver://localhost:1433;DatabaseName=JPetStore;SelectMethod=cursor
username=sa
password=sa
注意事项：
1，sql2000需升级sq4
2,更改persistence/sqlmapdao/sql下 Item.xml
?SELECT
????? I.ITEMID,
????? LISTPRICE,
????? UNITCOST,
????? SUPPLIER AS supplierId,
????? I.PRODUCTID AS "product.productId",
????? NAME AS "product.name",
????? DESCN AS "product.description",
????? CATEGORY AS "product.categoryId",
????? STATUS,
????? ATTR1 AS attribute1,
????? ATTR2 AS attribute2,
????? ATTR3 AS attribute3,
????? ATTR4 AS attribute4,
????? ATTR5 AS attribute5
??? FROM ITEM I,PRODUCT P
??? WHERE P.PRODUCTID = I.PRODUCTID
??? AND I.PRODUCTID = #value#
有两处
3，把sql2000 for jdbc copy到tomcat 下lib下
（编辑：李大同）
【声明】本站内容均来自网络，其相关言论仅代表作者个人观点，不代表本站立场。若无意侵犯到您的权利，请及时与联系站长删除相关内容!
|
