String sql = "insert into homeifo(xiaoquname,price,fangxing,chaoxiang,zhuangxiu,louceng,mianji,other,time) values('"
+ xiaoquname
+ "','"
+ price
+ "','"
+ fangxing
+ "','"
+ chaoxiang
+"','"
+ zhuangxiu
+"','"
+ louceng
+"','"
+ mianji
+"','"
+ other
+"',"
+ now()
+ ");";
这个now()在eclipse下总是抱错,我这个是想提取当前时间放入数据库中,可是怎么写都不对,希望大家帮我看看,谢谢
+ xiaoquname
+ "','"
+ price
+ "','"
+ fangxing
+ "','"
+ chaoxiang
+"','"
+ zhuangxiu
+"','"
+ louceng
+"','"
+ mianji
+"','"
+ other
+"',"
+ now()
+ ");";
这个now()在eclipse下总是抱错,我这个是想提取当前时间放入数据库中,可是怎么写都不对,希望大家帮我看看,谢谢
+ now()
+ "')";
日期用单引号,并且不需要最后的;[align=center]==== 思想重于技巧 ====
[/align]
+ xiaoquname
+ "','"
+ price
+ "','"
+ fangxing
+ "','"
+ chaoxiang
+"','"
+ zhuangxiu
+"','"
+ louceng
+"','"
+ mianji
+"','"
+ other
+"','"
+ now()
+ '")";
这样看看 ,你把sql打印到控制台,就能知道是哪里错了。
[/align]
+ xiaoquname
+ "','"
+ price
+ "','"
+ fangxing
+ "','"
+ chaoxiang
+"','"
+ zhuangxiu
+"','"
+ louceng
+"','"
+ mianji
+"','"
+ other
+"',"
+ "now()"
+ ")";