import java.text.SimpleDateFormat;
import java.sql.PreparedStatement;
import java.sql.Connection;
import java.sql.SQLException;
import java.sql.Timestamp;
Application Module Code
import java.sql.PreparedStatement;
import java.sql.Connection;
import java.sql.SQLException;
import java.sql.Timestamp;
public void SettingWhoColumns(String CStringDate) { java.sql.Date ConvStringDate = null; try { Connection conn = getOADBTransaction().getJdbcConnection(); String Query = "insert into XX_INSERT_WHO_COLUMNS CREATION_DATE, CREATED_BY, LAST_UPDATE_DATE, LAST_UPDATED_BY, LAST_UPDATE_LOGIN values (:1, :2, :3, :4 ,:5)"; PreparedStatement stmt = conn.prepareStatement(Query); //Creation Date stmt.setTimestamp(1, new Timestamp(System.currentTimeMillis())); stmt.setInt(2, getOADBTransaction().getUserId()); // Created by //Last update date stmt.setTimestamp(3, new Timestamp(System.currentTimeMillis())); stmt.setInt(4, getOADBTransaction().getUserId()); // Last updated by stmt.setInt(5,getOADBTransaction().getLoginId()); // Last updated login //Who columns setting end here..... // Getting Date as a String, Converting it to Date format and setting it if (CStringDate != null & !("".equalsIgnoreCase(CStringDate))) { SimpleDateFormat dtformatter = new SimpleDateFormat("dd-MMM-yyyy"); ConvStringDate = new java.sql.Date(dtformatter.parse(CStringDate).getTime()); dtformatter.format(ConvStringDate); } stmt.setDate(6, ConvStringDate); } catch (Exception e) { throw new OAException("Exception" + e); } }
Thanks,--Anil