求助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";
丢失空格
