Make your own free website on Tripod.com
import java.sql.*;
import oracle.jdbc.*;

/**
 * This class is a sample that illustrates how to insert and access Date from 
 * Database with time precision. If you insert java.sql.Date and access it , the 
 * time part will be truncated during insert and access, hence we will have to 
 * insert and access Date as an instance of java.sql.Timestamp. This will 
 * hold the time precision during insert and access. To get milli second
 * precision the database column should be Timestamp instead of Date.
 * 
 */
public class DateTimeSample  {

  public DateTimeSample( ) throws SQLException {
    // Register Oracle Driver with DriverMananger
    DriverManager.registerDriver( new OracleDriver( ) );
  }

  public static void main( String[] args ) throws SQLException {
    DateTimeSample sample = new DateTimeSample( );
    int empno = 1111;
    sample.insertDateTime( empno );
    sample.getDateTime( empno );
  }

  // Insert date with time precision
  public void insertDateTime( int empno ) throws SQLException {
  
    Connection conn = this.getConnection( );
    
    // java.util.Date(). getTime() will return the current datetime in milliseconds
    Timestamp hireDate = new Timestamp( new java.util.Date( ).getTime( ) );
    
    PreparedStatement pstmt = conn.prepareStatement( " INSERT INTO EMP(EmpNo, HireDate) VALUES(?,?) " );
    
    pstmt.setInt( 1, empno );
    pstmt.setTimestamp( 2, hireDate );
    
    pstmt.executeUpdate( );
    System.out.println(" Employee record inserted : " + empno + "   " + hireDate );
    
    pstmt.close( );
    conn.close( );
  }
  
  // Access date with time precision
  public void getDateTime( int empno ) throws SQLException {
    
    Connection conn = this.getConnection( );   
    
    PreparedStatement pstmt = conn.prepareStatement( "SELECT HireDate FROM Emp WHERE EmpNo = ? " );
    
    pstmt.setInt( 1, empno );
    
    ResultSet rset = pstmt.executeQuery( );
    
    while ( rset.next( ) )
      System.out.println( " Get Employee HireDate    : " + empno + "   " + rset.getTimestamp( 1 ) );
    
    rset.close( );
    pstmt.close( );
    conn.close( );
  }
  
  // Returns a connection to database
  public Connection getConnection( ) throws SQLException  {
  
    // Change the connection string based on your database 
    // jdbc:oracle:thin:@dbhostname:port:dbSID
    String jdbcurl = "jdbc:oracle:thin:@localhost:1521:ias904";
    
    return DriverManager.getConnection( jdbcurl, "scott", "tiger" );    
  }
  
}