！！！急等：《ibatis中关于多表查询出现我不能解决的问题，为什么结果不定

Question

这个东西应该类似Spring一样的吧

Answer 1

ibatis我用过，出现你这样的情况，可能不是ibatis的问题。你可以跟踪进去，看看每次查询出不同结果的sql语句。

Answer 2

我详细分析了console上打印出来的消息
下面的信息是我删除操作以后，连续两次点击取数据模块出现的结果
当[http8080-Processor？]当中的问号为8的时候搜出来的数据有两条，为1或者2的时候查询出来的数据是一条，此时数据库中的数据确实是只有一条（用mysql客户端），请大家帮忙看看
===========BOproducts.size=====customerid=========1
====================sqlmapdao========custid1
DEBUG [http8080-Processor1] - {conn-103111} Connection
DEBUG [http8080-Processor1] - {conn-103111} Connection
DEBUG [http8080-Processor1] - {pstm-103112} PreparedStatement:       select
   ProductInfo.pname as productname,      ProductUnit.puname as unitname,      P
roductInfo.image as image,        Customer_FBI.addDate as adddate,       Custome
r_FBI.Productid as productid ,      ShopProduct.spid as spid     from       Cust
omer_FBI,ProductInfo,ProductUnit,ShopProduct     where       Customer_FBI.Custom
erid=?       and Customer_FBI.Productid=ProductInfo.pid      and ShopProduct.pid
=Customer_FBI.Productid       and ProductInfo.unit=ProductUnit.puid      and Pro
ductInfo.state=1      and ShopProduct.state=1     group by Customer_FBI.Producti
d     order by adddate
DEBUG [http8080-Processor1] - {pstm-103112} PreparedStatement:       select
   ProductInfo.pname as productname,      ProductUnit.puname as unitname,      P
roductInfo.image as image,        Customer_FBI.addDate as adddate,       Custome
r_FBI.Productid as productid ,      ShopProduct.spid as spid     from       Cust
omer_FBI,ProductInfo,ProductUnit,ShopProduct     where       Customer_FBI.Custom
erid=?       and Customer_FBI.Productid=ProductInfo.pid      and ShopProduct.pid
=Customer_FBI.Productid       and ProductInfo.unit=ProductUnit.puid      and Pro
ductInfo.state=1      and ShopProduct.state=1     group by Customer_FBI.Producti
d     order by adddate
DEBUG [http8080-Processor1] - {pstm-103112} Parameters: [1]
DEBUG [http8080-Processor1] - {pstm-103112} Parameters: [1]
DEBUG [http8080-Processor1] - {pstm-103112} Types: [java.lang.Integer]
DEBUG [http8080-Processor1] - {pstm-103112} Types: [java.lang.Integer]
DEBUG [http8080-Processor1] - {rset-103113} ResultSet
DEBUG [http8080-Processor1] - {rset-103113} ResultSet
DEBUG [http8080-Processor1] - {rset-103113} Header: [productname, unitname, imag
e, adddate, productid, spid]
DEBUG [http8080-Processor1] - {rset-103113} Header: [productname, unitname, imag
e, adddate, productid, spid]
DEBUG [http8080-Processor1] - {rset-103113} Result: [fish, fixed, graphics/produ
ct/040910image/1094822753109.jpg, 2004-09-16 10:32:10.0, 60, 1]
DEBUG [http8080-Processor1] - {rset-103113} Result: [fish, fixed, graphics/produ
ct/040910image/1094822753109.jpg, 2004-09-16 10:32:10.0, 60, 1]
===========BO productssize afterGetFbi=====53=========1
============Action list.sizeafterGetFbi=============1
=========customer role ===============com.afroshopping.vo.Customer@9a41d2
===========BO  customerid=========1
====================sqlmapdao========custid1
DEBUG [http8080-Processor8] - {pstm-103114} PreparedStatement:       select
   ProductInfo.pname as productname,      ProductUnit.puname as unitname,      P
roductInfo.image as image,        Customer_FBI.addDate as adddate,       Custome
r_FBI.Productid as productid ,      ShopProduct.spid as spid     from       Cust
omer_FBI,ProductInfo,ProductUnit,ShopProduct     where       Customer_FBI.Custom
erid=?       and Customer_FBI.Productid=ProductInfo.pid      and ShopProduct.pid
=Customer_FBI.Productid       and ProductInfo.unit=ProductUnit.puid      and Pro
ductInfo.state=1      and ShopProduct.state=1     group by Customer_FBI.Producti
d     order by adddate
DEBUG [http8080-Processor8] - {pstm-103114} PreparedStatement:       select
   ProductInfo.pname as productname,      ProductUnit.puname as unitname,      P
roductInfo.image as image,        Customer_FBI.addDate as adddate,       Custome
r_FBI.Productid as productid ,      ShopProduct.spid as spid     from       Cust
omer_FBI,ProductInfo,ProductUnit,ShopProduct     where       Customer_FBI.Custom
erid=?       and Customer_FBI.Productid=ProductInfo.pid      and ShopProduct.pid
=Customer_FBI.Productid       and ProductInfo.unit=ProductUnit.puid      and Pro
ductInfo.state=1      and ShopProduct.state=1     group by Customer_FBI.Producti
d     order by adddate
DEBUG [http8080-Processor8] - {pstm-103114} Parameters: [1]
DEBUG [http8080-Processor8] - {pstm-103114} Parameters: [1]
DEBUG [http8080-Processor8] - {pstm-103114} Types: [java.lang.Integer]
DEBUG [http8080-Processor8] - {pstm-103114} Types: [java.lang.Integer]
DEBUG [http8080-Processor8] - {rset-103115} ResultSet
DEBUG [http8080-Processor8] - {rset-103115} ResultSet
DEBUG [http8080-Processor8] - {rset-103115} Header: [productname, unitname, imag
e, adddate, productid, spid]
DEBUG [http8080-Processor8] - {rset-103115} Header: [productname, unitname, imag
e, adddate, productid, spid]
DEBUG [http8080-Processor8] - {rset-103115} Result: [fish, fixed, graphics/produ
ct/040910image/1094822753109.jpg, 2004-09-16 10:32:10.0, 60, 1]
DEBUG [http8080-Processor8] - {rset-103115} Result: [fish, fixed, graphics/produ
ct/040910image/1094822753109.jpg, 2004-09-16 10:32:10.0, 60, 1]
DEBUG [http8080-Processor8] - {rset-103115} Result: [cartoon, TB, graphics/produ
ct/040911image/1094868598203.jpg, 2004-09-16 10:57:54.0, 61, 13]
DEBUG [http8080-Processor8] - {rset-103115} Result: [cartoon, TB, graphics/produ
ct/040911image/1094868598203.jpg, 2004-09-16 10:57:54.0, 61, 13]
===========BO productssize afterGetFbi=====53=========2
============Action list.sizeafterGetFbi=============2
=========customer role ===============com.afroshopping.vo.Customer@9a41d2

Answer 3

与我的request scope是不是有关系啊？
当我加了6条数据的时候，我再取的时候会出现三种情况，这到底是怎么回事啊？
难道没人遇到过这样的问题么？

Answer 4

用缓存没有
adddata是不是都相等

Answer 5

我再Up,
还有没有可能是数据库有问题？或者sql语句有问题啊？