java.sql.SQLException: æ æçåç´¢å¼
âæ æçåç´¢å¼âå
¶å®æ¯ä¸ªä½çº§çé误ï¼åå æ éå 个ï¼
1ãsql串ç?å·æ°ç®åæä¾çåéæ°ç®ä¸ä¸è´ï¼
ä¾å¦ï¼jdbcTemplate.update(sql, new Object[] {newState,oldState});
å¦æsqléé¢æ1个?å·ï¼Object[]éäº2个ï¼å°±ä¼æ¥éã
2ãsql串éç?å·ä¹¦åä¸æ£ç¡®
è±æ?åä¸æï¼ææ¶é¾ä»¥åºåã
3ãsql串ç?å·ç¨''æ¬äºèµ·æ¥ã
ä¾å¦ï¼sql="UPDATE abc SET abc.name='?' WHERE abc.id='?'";
æ''å»æå°±å¯ä»¥äºã
4ï¼éå°è¿ç§æ
åµselect*from user where info like %?%;
è½ç¶è¿æ¯sqlçåæ³ï¼ä½æ¯å¨jdbc ä¸éè¦æ¹æ select*from user where info like ?;
å¦ps.setString(â%â+value+â%â);
温馨提示:答案为网友推荐,仅供参考