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
No comments:
Post a Comment
Note: Only a member of this blog may post a comment.