Date value insert

In this chapter you will learn:

  1. How to insert date value to database

Insert Date value

import java.sql.Connection;
import java.sql.DriverManager;
import java.sql.PreparedStatement;
import java.sql.ResultSet;
import java.sql.ResultSetMetaData;
import java.sql.Statement;
//from j a  v  a2  s . com
public class Main {
  public static void main(String[] args) throws Exception {
    Connection conn = getConnection();
    Statement st = conn
        .createStatement();

    st.executeUpdate("create table survey (id int,myDate DATE);");
    String INSERT_RECORD = "insert into survey(id, myDate) values(?, ?)";
    
    PreparedStatement pstmt = conn.prepareStatement(INSERT_RECORD);
    pstmt.setString(1, "1");
    java.sql.Date sqlDate = new java.sql.Date(new java.util.Date().getTime());
    pstmt.setDate(2, sqlDate);
    
    pstmt.executeUpdate();
    
    ResultSet rs = st.executeQuery("SELECT * FROM survey");

    outputResultSet(rs);

    rs.close();
    st.close();
    conn.close();
  }
  private static void outputResultSet(ResultSet rs) throws Exception {
    ResultSetMetaData rsMetaData = rs.getMetaData();
    int numberOfColumns = rsMetaData.getColumnCount();
    for (int i = 1; i < numberOfColumns + 1; i++) {
      String columnName = rsMetaData.getColumnName(i);
      System.out.print(columnName + "   ");

    }
    System.out.println();
    System.out.println("----------------------");

    while (rs.next()) {
      for (int i = 1; i < numberOfColumns + 1; i++) {
        System.out.print(rs.getString(i) + "   ");
      }
      System.out.println();
    }

  }

  private static Connection getConnection() throws Exception {
    Class.forName("org.hsqldb.jdbcDriver");
    String url = "jdbc:hsqldb:mem:data/tutorial";

    return DriverManager.getConnection(url, "sa", "");
  }
}

The code above generates the following result.

Next chapter...

What you will learn in the next chapter:

  1. Get Date value from ResultSet
Home » Java Tutorial » SQL Data Types

Data Type

    Data type Mapping
    Blob type data insert
    Blob type data read
    Clob type data insert with FileInputStream
    Clob data insert with FileReader
    Clob data read
    Image file insert
    Image file retrieve
    Byte array insert and retrieve
    Date value insert
    Date value retrieve
    Date value for a Time Zone
    TIME value insert
    TIME value retrieve
    TIMESTAMP value
    TIMESTAMP type value retrieve
    Decimal insert

NULL

    NULL Values
    NULL primitive data types

SQL Date, TimeStamp, Time

    JDBC Date time types
    Create sql Date from string for certain format
    SQL Date from Calendar
    Create sql Date from String
    TimeStamp from milli-second
    Create TimeStamp from String
    Create TimeStamp from year, month and day, hour, minute and second
    TimeStamp Now
    Format TimeStamp
    TimeStamp to readable string
    Convert TimeStamp to Date
    Create TimeStamp from String with format
    Convert Date to Time
    Convert TIME to Calendar