当前位置: 代码迷 >> Java相关 >> Unknown table 'book' in field list
  详细解决方案

Unknown table 'book' in field list

热度:6166   发布时间:2013-02-25 21:50:44.0
求助Unknown table 'book' in field list
Unknown table 'book' in field list




 sqlStr="select book.id,book.bookname,book.bookclass,bookclass.classname,"+

  "book.author,book.publish,book.bookno,book.content,book.prince,book.amount,"+

  "book.Leav_number,book.regtime,book.picturefrombook,bookclass"+

  "wherebook.Bookclass=bookclass.Id";

------解决方案--------------------------------------------------------
sqlStr="select book.id,book.bookname,book.bookclass,bookclass.classname,"+ 

"book.author,book.publish,book.bookno,book.content,book.prince,book.amount,"+ 

"book.Leav_number,book.regtime,book.picture from book,bookclass"+ 

"where book.Bookclass=bookclass.Id";

丢失空格
  相关解决方案