´ø²ÎÊýµÄSQLÓï¾ä

String sql="insert into author values(?£¬?, ?);";
super.updateBySql(sql, new IParamBinding(){
public void bindParam(PreparedStatement pstmt) throws SQLException{
System.out.print("asd");
pstmt.setInt(1, model.getId());
pstmt.setString(2,model.getFirstname());
pstmt.setString(3,model.getLastname());
}
                       
ÇëÎÊÎÒÕâ¸öSQLÓï·¨ÓдíÎóÂð£¿ÎÒÊÇÁ´½ÓMYSQLµÄ    TOMCAT×ÜÊÇ˵No value specified for parameter 1

---

String sql="insert into author values(?£¬?, ?);";

×¢ÒâÒ»ÏÂÕâ¸ö·ûºÅ£¬Èç¹ûÈÔÓÐÎÊÌ⣬½¨Òéµ½ java°æ»ò web°æÈ¥ÎÊһϡ£

---

ÒýÓÃ

String sql="insert into author values(?£¬?, ?);";

×¢ÒâÒ»ÏÂÕâ¸ö·ûºÅ£¬Èç¹ûÈÔÓÐÎÊÌ⣬½¨Òéµ½ java°æ»ò web°æÈ¥ÎÊһϡ£

ÎÒÖªµÀ×Ô¼º´ò´í£¬µ«ÎÒÔÚMYECLIPSEÊÇûÓдò´íµÄ£¬ÕâÖÖÓï·¨ÔÚmysqLÓ¦¸Ãû´í°É£¿

---

String sql="insert into author values(?£¬?, ?);";
java
ÀïÃæû·ÖºÅ

---

Column count doesn't match value count at row 1
ÄÇÕâ¸öÊÇʲô´íÎ󣬿ÉÒÔÖ¸µãÏÂÂð£¿

---

Õâ¸öÊÇ˵ÄãµÄ£¿¸öÊýºÍÄãsetʱºò²ÎÊý²»Æ¥Åä

¾ÍÊÇÄãûÍêÈ«ÉèÖòÎÊý

Ó¦¸ÃÊÇÄãsetµÄʱºòÓпÉÄÜûֵ

---

String sql="insert into author values(?,?,?)";
PreparedStatement pstmt = con.createPreparedStatement(sql);