[問題] 想用java抓Date 再存入MySQL

[Avle (慢慢的看清楚了...)]

我希望能在抓資料進DB的同時，也能一併記下時間

目前遇到的問題是
MySQL吃的Date格式是 YYYY-MM-DD

但我弄出的時間  往往會變成這種格式  'Jul 30 21:30:13 CST 2009)'


也許各位大大有更好的方法  請不吝賜教 <(_ _)>

=============================================================================
                main方法中

                String driver = "com.mysql.jdbc.Driver";
                String urlString =
                //帳密跳過
                "jdbc:mysql://j.snpy.org/java33?user=?&password=?&+
                  useUnicode=true&characterEncoding=UTF-8";
                Connection conn = null;
                Statement smt = null;
                DateFormat dateFormat1 = new SimpleDateFormat("yyyy-MM-dd");//
                try {
                        Class.forName(driver);
                        conn = DriverManager.getConnection(urlString);
                        smt = conn.createStatement();

                        String sql = "Insert Into `threeindex` (`date`)
                                +Values(new java.util.Date())";
                             // 重點    ^^^^^^^^^^^^^^^^^^^^

                smt.execute(sql);
                        conn.close();
                } catch (ClassNotFoundException e) {
                        e.printStackTrace();
                } catch (SQLException e) {
                        e.printStackTrace();
                }

=============================================================================
錯誤訊息


com.mysql.jdbc.exceptions.jdbc4.MySQLSyntaxErrorException: 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 'Jul 30 21:30:13 CST 2009)' at line 1
                                         ^^^^^^^^^^^^^^^^^^^^^^^^^^
        at sun.reflect.NativeConstructorAccessorImpl.newInstance0(Native Method)
        at sun.reflect.NativeConstructorAccessorImpl.newInstance(Unknown Source)
        at sun.reflect.DelegatingConstructorAccessorImpl.newInstance(Unknown Source)
        at java.lang.reflect.Constructor.newInstance(Unknown Source)
        at com.mysql.jdbc.Util.handleNewInstance(Util.java:406)
        at com.mysql.jdbc.Util.getInstance(Util.java:381)
        at com.mysql.jdbc.SQLError.createSQLException(SQLError.java:1030)
        at com.mysql.jdbc.SQLError.createSQLException(SQLError.java:956)
        at com.mysql.jdbc.MysqlIO.checkErrorPacket(MysqlIO.java:3515)
        at com.mysql.jdbc.MysqlIO.checkErrorPacket(MysqlIO.java:3447)
        at com.mysql.jdbc.MysqlIO.sendCommand(MysqlIO.java:1951)
        at com.mysql.jdbc.MysqlIO.sqlQueryDirect(MysqlIO.java:2101)
        at com.mysql.jdbc.ConnectionImpl.execSQL(ConnectionImpl.java:2548)
        at com.mysql.jdbc.ConnectionImpl.execSQL(ConnectionImpl.java:2477)
        at com.mysql.jdbc.StatementImpl.execute(StatementImpl.java:741)
        at com.mysql.jdbc.StatementImpl.execute(StatementImpl.java:587)
        at Threeindex03.main(Threeindex03.java:112)


==============================================================================

--
自古多情空餘恨
    從來殘忍少添傷~

--
※ 發信站: 批踢踢實業坊(ptt.cc) 
◆ From: 122.124.98.199
推 now99:SimpleDateFormat
推 qrtt1:為什麼不直接用 MySQL 的 NOW() 函式
推 PsMonkey:你的 sql 句子一整個很奇怪阿... 是你貼錯嗎？
推 PsMonkey:btw... 我直接用 new Date().toString() 可以塞....
→ Avle:感謝!  String sql = "Insert Into `threeindex` (`date`)
→ Avle:+Values((select NOW()))"; 就搞定了! 但這是靠MySQL語法 XD
→ adrianshum:請 bind parameter 吧, 不要直接建 SQL...
推 qrtt1:靠特定資料庫的語法也沒什麼不好，輕易地轉換DB只是個夢。
推 puzi:如果支援多個DB的時候，每個資料庫的語法都要寫一遍嗎Orz