- 论坛徽章:
- 0
|
insertstr=new String("insert into webdata values (" ;
insertstr+="1,'";
insertstr+=d.getIP();
insertstr+="',";
insertstr+="TO_DATE('";
insertstr+=d.getWEBDATE();
insertstr+="','YYYY-MM-DD HH24:MI:SS')";
insertstr+=",'";
insertstr+=d.getURL();
insertstr+="',";
insertstr+="'1')";
System.out.println(insertstr);
String str=new String("insert into webdata values (1,'218.103.255.22',TO_DATE('2004-03-29 03:10:06','YYYY-MM-DD HH24:MI:SS'),'/common/search.php','1')" ;
System.out.println(str);
System.out.println(str.equalsIgnoreCase(insertstr));
程序执行后结果是
insert into webdata values (1,'218.103.255.22',TO_DATE('2004-03-29 03:10:06','YYYY-MM-DD HH24:MI:SS'),'/common/search.php','1')
insert into webdata values (1,'218.103.255.22',TO_DATE('2004-03-29 03:10:06','YYYY-MM-DD HH24:MI:SS'),'/common/search.php','1')
false
而且在执行查询时第一条报错“插入值对于列过大”,而第二条就能成功执行。
不止是何原因??? |
|