更新
我想插入一条记录,id是变量,userid给定, 其它字段为空,我应该怎样写String sql,特别是逗号,谢谢.
String sql= "insert into usertab(cardid userid,pwd,usertele,useraddr,)values( ' "+id+ " ', ' "1000 " ', " " " ", " " " ", " " " ", " " " ", " " " ",) ";
------解决方案--------------------String sql= "insert into usertab(cardid,userid,pwd,usertele,useraddr)values( ' "+id+ " ', '1000 ', ' ', ' ', ' ', ' ', ' ') ";