下載ibatis jPetStore看了一下，的確是個(gè)學(xué)習(xí)的好例子,
我運(yùn)行了一下,用的是mysql,運(yùn)行到把產(chǎn)品添加到購物車就報(bào)錯(cuò):
com.ibatis.dao.client.template.SqlMapDaoTemplate.queryForObject
(SqlMapDaoTemplate.java:162)
????
?37?more
Caused?by:?java.sql.SQLException:?Duplicate?key?or?integrity?
constraint?violation?message?from?server:?"Column?'ITEMID'?in?field?
list?is?ambiguous"
????at?com.mysql.jdbc.MysqlIO.checkErrorPacket(MysqlIO.java:1997)
????at?com.mysql.jdbc.MysqlIO.sendCommand(MysqlIO.java:1167)
????at?com.mysql.jdbc.MysqlIO.sqlQueryDirect(MysqlIO.java:1278)
????at?com.mysql.jdbc.Connection.execSQL(Connection.java:2247)
????at?com.mysql.jdbc.PreparedStatement.execute
(PreparedStatement.java:1371)
????at?
com.ibatis.sqlmap.engine.execution.SqlExecutor.executeQuery
(SqlExecutor.java:180)
????at?
com.ibatis.sqlmap.engine.mapping.statement.GeneralStatement.sqlExecut
eQuery(GeneralStatement.java:205)
????at?
com.ibatis.sqlmap.engine.mapping.statement.GeneralStatement.executeQu
eryWithCallback(GeneralStatement.java:173)
?????43?more
查了半天原來是配置文件查詢的地方有的小錯(cuò)誤。
??<select?id="getItem"?resultClass="item"?parameterClass="string"?cacheModel="quantityCache">
????select
//默認(rèn)里面少了個(gè)”I“。。。。。
???????? 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,
??????QTY?AS?quantity
????from?ITEM?I,?INVENTORY?V,?PRODUCT?P
????where?P.PRODUCTID?=?I.PRODUCTID
??????and?I.ITEMID?=?V.ITEMID
??????and?I.ITEMID?=?#value#
??</select>