colb是什么,不懂,没有用过
insert into 表名(TITLE,CONTENT,SHOWT,UPTIME) values(title, content, showt, to_date(uptime,'dd/mm/yyyy'))uptime 是格式为'dd/mm/yyyy' 类型的 string.
insert into 表名(TITLE,CONTENT,SHOWT,UPTIME) values(title, content, showt, to_date(uptime,'dd/mm/yyyy'))uptime 是格式为'dd/mm/yyyy' 类型的 string.
insert into 表名(TITLE,CONTENT,SHOWT,UPTIME)
values('', lc_col, '', to_date(sysdate,'dd/mm/yyyy'))
values('" + title +"','" + content+ "','" +showt+"','"+"'to_date ('"+uptime+"','dd/mm/yyyy')"+
"')";
我这样写错在哪里?
{ String str = "insert into SHOW_INFO(TITLE,CONTENT,SHOWT,UPTIME) values('" + title +"','" + content+ "','" +showt+"','"+"'to_date('"+uptime+"','dd/mm/yyyy')"+
"')";
int i = data.sqlOther(str);
if (i > 0)
{
return "y";
}
else
{
return "n";
}
}
测试类: String s=info.addInfo("111","aaa","aaa","12/31/2311");哪里不对?请指正!
这么看比较累得。