在写练习小项目的修改书籍功能,发现报: Unknown column 'imgs' in 'field list',上网搜索了许久都不能解决
然后一步步调试发现,
book_image是varchar类型,原来是一个低级的小错误,少了单引号
''
update T_BOOK set
book_name=?,book_name_pinyin=?, book_category_id=?,
book_author=?,book_price=?,publishing=?,
book_desc=? ,
book_image=
imgs/zwtp.jpg where book_id=?
update T_BOOK set
book_name=?,book_name_pinyin=?, book_category_id=?,
book_author=?,book_price=?,publishing=?,
book_desc=? ,
book_image=
'
imgs/zwtp.jpg'
where book_id=?