Question

java中如何对数据库执行嵌套子查询？

String sql="select cook_name,cook_price,cook_image from cook"
+ "where shop_name in(select shop_name from shop where shop_address='柳园' and shop_restaurant='1号')";
rs=ps.executeQuery(sql);

执行不了，不知道哪里出错了？

Answer 1

String sql="select cook_name,cook_price,cook_image from cook "
+ "where shop_name in(select shop_name from shop where shop_address='柳园' and shop_restaurant='1号')";
是不是cook和where之间没有空格

Answer 2

具体什么问题？

cook_image 是否 二进制 类型（比如oracle的blob，sqlserver的image）？

如果是，二进制不能这么查询的吧。

Answer 3

String sql="select cook_name,cook_price,cook_image from cook where shop_name=(select shop_name from shop where shop_address='柳园' and shop_restaurant='1号')";
看看这样行不行

Answer 4

报什么错呢？难道是因为你where前面没有空格的原因？

Answer 5

select * from(select * from A) where 。。。。。。。