Insert Date, time and date time data to Oracle : Date Time Timestamp « Database SQL JDBC « Java

1. Java
2. Database SQL JDBC
3. Date Time Timestamp

Insert Date, time and date time data to Oracle

    
import java.sql.Connection;
import java.sql.DriverManager;
import java.sql.PreparedStatement;

public class InsertDateToOracle {
  public static Connection getConnection() throws Exception {
    String driver = "oracle.jdbc.driver.OracleDriver";
    String url = "jdbc:oracle:thin:@localhost:1521:databaseName";
    Class.forName(driver);
    return DriverManager.getConnection(url, "userName", "password");
  }

  public static void main(String args[])throws Exception {
    String INSERT_RECORD = "insert into TestDates(id, date_column, "
        + "time_column, timestamp_column) values(?, ?, ?, ?)";
    Connection conn = null;
    PreparedStatement pstmt = null;
    try {
      conn = getConnection();
      pstmt = conn.prepareStatement(INSERT_RECORD);
      pstmt.setString(1, "001");

      java.util.Date date = new java.util.Date();
      long t = date.getTime();
      java.sql.Date sqlDate = new java.sql.Date(t);
      java.sql.Time sqlTime = new java.sql.Time(t);
      java.sql.Timestamp sqlTimestamp = new java.sql.Timestamp(t);
      System.out.println("sqlDate=" + sqlDate);
      System.out.println("sqlTime=" + sqlTime);
      System.out.println("sqlTimestamp=" + sqlTimestamp);
      pstmt.setDate(2, sqlDate);
      pstmt.setTime(3, sqlTime);
      pstmt.setTimestamp(4, sqlTimestamp);
      pstmt.executeUpdate();
    } catch (Exception e) {
      e.printStackTrace();
      System.out.println("Failed to insert the record.");
    } finally {
      pstmt.close();
      conn.close();
    }
  }
}

           
         
    
    
    
  

Related examples in the same category