如何在Java中插入日期和时间

Question

我在Netbeans IDE中用JDBC oracle数据库做一个Java项目，我需要在数据库中插入日期和时间，它的格式是11/16/2013 10:30。我把我的代码附在下面。

在DBConnector中插入代码

public void insert(String id, String uid, String vmid, String ttid, String faid, String taid, String fdate, String tdate, String onbooking, String msbooking, String bcreated)
            throws SQLException {
        Statement stmt = null;
        String query = "Insert into DMUSER.CAB2("
                + "ID,"
                + "USER_ID,"
                + "VEHICLE_MODEL_ID,"
                + "TRAVEL_TYPE_ID,"
                + "FROM_AREA_ID,"
                + "TO_AREA_ID,"
                + "FROM_DATE,"
                + "TO_DATE,"
                + "ONLINE_BOOKING,"
                + "MOBILE_SITE_BOOKING,"
                + "BOOKING_CREATED"
                + ") values ("
                + id + ","
                + uid + ","
                + vmid + ","
                + ttid + ","
                + faid + ","
                + taid + ","
                + fdate + ","
                + tdate + ","
                + onbooking + ","
                + msbooking + ","
                + bcreated + ""
                + ")";

按钮单击事件

private void btn_insertActionPerformed(java.awt.event.ActionEvent evt) {                                           

    txt_id.setText("132536");
    txt_user_id.setText("16");
    txt_vechile_mdl_id.setText("28");
    txt_from_area_id.setText("58");
    txt_to_area_id.setText("1063");
    txt_frm_date.setText("11/16/2013 9:30");
    txt_to_date.setText("NULL");
    txt_booking_created.setText("11/16/2013 9:30");
    txt_travel_type_id.setText("2");
    txt_mobile_site_booking.setText("0");
    txt_online_booking.setText("1");
} 

private void btn_predictionActionPerformed(java.awt.event.ActionEvent evt) {                                               
        try {

            String id = txt_id.getText();
            String uid = txt_user_id.getText();
            String vmid = txt_vechile_mdl_id.getText();
            String ttid = txt_travel_type_id.getText();
            String faid = txt_from_area_id.getText();
            String fdate = txt_frm_date.getText();
            String tdate = txt_to_date.getText();
            String onbooking = txt_online_booking.getText();
            String msbooking = txt_mobile_site_booking.getText();
            String bcreated = txt_booking_created.getText();
            String taid = txt_to_area_id.getText();

            DB_Connector con = new DB_Connector();

            try {
                con.insert(id, uid, vmid, ttid, faid, taid, fdate, tdate, onbooking, msbooking, bcreated);
            } catch (SQLException ex) {

Logger.GetLogger（CabCancellationUI.Class.GetName（））.Log（Level.Severe,null,ex）；}}捕获（Exception ex）{}}

这里的问题是，在数据库中的日期列是varchar数据类型，所以我如何将这个11/16/2013 10:30插入到数据库中，请帮我整理一下。

编辑：发生异常

query：：插入dmuser.cab2(ID,USER_ID,VEHICLE_MODEL_ID,TRAVEL_TYPE_ID,FROM_AREA_ID,TO_AREA_ID,FROM_DATE,TO_DATE,ONLINE_BOOKING,MOBILE_SITE_BOOKING,BOOKING_CREATED)值（132536,16,28,2,58,106 3,11/16/2013 10:30,NULL,1,0,01）java.sql.sqlsyntaxerrorexception：ora-00917:缺少逗号

在oracle.jdbc.driver.sqlstatemapping.newsqlexception（sqlstatemapping.Java:91)在oracle.jdbc.driver.databaseerror.newsqlexception（databaseerror.Java:133)在oracle.jdbc.driver.databaseerror.throwsqlexception（databaseerror.Java:206)在oracle.jdbc.driver.t4cttioer.processerror(t4cttioer.:455)在ionPerformed（CabCancellationUI.Access$500（CabCancellationUI.java:28)在UI.CabCancellationUI$6。ActionPerformed（CabCancellationUI.java:151)在javax.Swing.AbstractButton.FireActionPerformed（AbstractButton.java:2022)在javax.Swing.AbstractButton.Handler。ActionPerformed（AbstractButton.java:2348)在a.awt.LightWeightDispatcher.RetargetMouseEvent（container.java:4888)在java.awt.LightWeightDispatcher.ProcessMouseEvent（container.java:4525)在java.awt.LightWeightDispatcher.DispatchEvent（container.java:4466)在java.awt.Window.DispatchEvent（container.java:2280)在java.awt.Window.DispatchEventImpl（container.java:2750)在ntroller.doprivileged（本机方法）在java.security.protectiondomain$javasecurityaccessimpl.doIntersectionPrivilege(protectiondomain.java:76)在java.awt.EventQueue.DispatchEvent(EventQueue.java:728)在java.awt.EventDispatchThread.PumponeEventForFilters（EventDispatchThread.java:201)在

Answer 1

问题不是你想的那样。一个例外是抱怨插入数据的SQL语法错误。

您需要在insert方法中更正查询字符串。而且，您接受的每个表列都是字符串，这似乎是不正确的。考虑一下表中每列的正确数据类型，比如ID应该是number而不是varchar，等等。

如果每个参数都是string类型，那么正确的代码必须在查询字符串中的参数前后各处添加'，如下所示：

String query = "Insert into DMUSER.CAB2("
            + "ID,"
            + "USER_ID,"
            + "VEHICLE_MODEL_ID,"
            + "TRAVEL_TYPE_ID,"
            + "FROM_AREA_ID,"
            + "TO_AREA_ID,"
            + "FROM_DATE,"
            + "TO_DATE,"
            + "ONLINE_BOOKING,"
            + "MOBILE_SITE_BOOKING,"
            + "BOOKING_CREATED"
            + ") values ("
            + "'"+ id + "',"
            + "'" + uid + "',"
            + "'" + vmid + "',"
            + "'" + ttid + "',"
            + "'" + faid + "',"
            + "'" + taid + "',"
            + "'" + fdate + "',"
            + "'" + tdate + "',"
            + "'" + onbooking + "',"
            + "'"+ msbooking + "',"
            + "'"+bcreated + "'"
            + ")";

最后，这是一个可怕的代码。您应该考虑使用PreparedStatement。