Topic: 求如何获取当前日期并写入SQL数据库的代码！！！！

  Print this page
1.求如何获取当前日期并写入SQL数据库的代码！！！！ Copy to clipboard
Posted by: zzw5516
Posted on: 2005-10-06 09:05

java.util.Date zcdate=new java.util.Date();
    int rank=0;
    String strSQL="insert into users values('"+userName+"','"+pass+"','"+email+"','"+zcdate+"','"+rank+"')";
我这段代码虽然获取了日期
但是无法传入数据库
原因：从字符串转换为 datetime 时发生语法错误。
应如何更正 请个位朋友 帮个忙
2.Re:求如何获取当前日期并写入SQL数据库的代码！！！！ [Re: zzw5516] Copy to clipboard
Posted by: why
Posted on: 2005-10-06 18:41

1. check the date format required by your 数据库, and format zcdate as such (using DateFormat or just SimpleDateFormat)
or
2. use PreparedStatement and setDate( )
or
...

   Powered by Jute Powerful Forum® Version Jute 1.5.6 Ent
Copyright © 2002-2021 Cjsdn Team. All Righits Reserved. 闽ICP备05005120号-1
客服电话 18559299278    客服信箱 714923@qq.com    客服QQ 714923