代码如下:
String number=(String)session.getAttribute("id");
String condition="UPDATE student SET studentname = "+studentname+", sex = "+sex+" , age = "+age+", phone = "+phone+",email = "+email+",address = "+address+" WHERE studentid="+"'"+number+"'" ;
sql.executeUpdate(condition);
显示的错误如下:
java.sql.SQLException: [Microsoft][ODBC Microsoft Access Driver] UPDATE 语句的语法错误。
谢谢!
String condition="UPDATE student SET studentname = '"+studentname+"', sex = '"+sex+"' , age = "+age+", phone = '"+phone+"',email = "'+email+"',address = "'+address+"' WHERE studentid="+number;
再插入数据的时候,凡是String类型的都要加单引号,数字类型的不需要加引号。
再插入数据的时候,凡是String类型的都要加单引号,数字类型的不需要加引号。
温馨提示:答案为网友推荐,仅供参考
第1个回答 2007-12-01
建议多看看SQL