首页 诗词 字典 板报 句子 名言 友答 励志 学校 网站地图
当前位置: 首页 > 教程频道 > JAVA > Java Web开发 >

语法异常,请帮忙看一上

2012-11-11 
语法错误,请帮忙看一下关键语句:String strSqlinsert into +tbName+ (ID,Exp,LastVisIP,LeftTime,Logi

语法错误,请帮忙看一下
关键语句:String strSql="insert into "+tbName
  +" (ID,Exp,LastVisIP,LeftTime,LoginCount,NickName,Password,"
  +"PostCount,Email,UserName,RegisterDate) values("
  +id+","+exp+","+lastvisip+","+lefttime+","
  +logincount+","+nickname+","+password+","
  +postcount+","+email+","+username+","
  +registerdate+")";
  System.out.println(strSql);

执行后提示语句:

insert into users (ID,Exp,LastVisIP,LeftTime,LoginCount,NickName,Password,PostCount,Email,UserName,RegisterDate) values(1,0,unknown,2012-10-30 15:14:25.362,0,nickname,unknown,0,aa@bb.cc,username,2012-10-30 15:14:25.362)

executeUpdate:You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near '15:14:25.362,0,nickname,unknown,0,aa@bb.cc,username,2012-10-30 15:14:25.362)' at line 1


[解决办法]
楼主,你太牛逼了,你这写法全当字段都是数值型的了!
字符型要转成字符串,日期型要转换成日期!
如(加如tbName变量里表的字段id是数值型,exp是字符型):"insert into "+tbName+" (ID,Exp) values ("+id+",'"+exp+"')";

热点排行