日期:2014-05-18  浏览次数:20628 次

更新
我想插入一条记录,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 ', ' ', ' ', ' ', ' ', ' ') ";