@Override
public boolean updateLmsFeedLike(LmsFeedLikeVO vo) throws LmsDaoException {
System.out.println("id =" + vo.getFeedLikeID());
// System.out.println("id =" +1234);
boolean status = true;
// Database connection start
Connection conn = null;
PreparedStatement stmt = null;
try {
conn = getConnection();
String sql =
"UPDATE lms_feed_like set FEED_ID=?, PARENT_COMMENT_ID=?, LIKE_ON=?, ASSOCIATE_ID=?, "
+ "LIKE_BY=?, LAST_USERID_CD=?, LAST_UPDT_TM=utc_timestamp\n"
+ " WHERE FEED_LIKE_ID=?";
/*String sql = "UPDATE lms_feed_like set FEED_ID=?, PARENT_COMMENT_ID=?, LIKE_ON=?, ASSOCIATE_ID=?, LIKE_BY=?, LAST_USERID_CD=?\n"
+ " WHERE FEED_LIKE_ID=?";*/
stmt = conn.prepareStatement(sql);
stmt.setInt(1, vo.getFeedID());
stmt.setInt(2, vo.getParentCommentID());
stmt.setString(3, vo.getLikeOn());
stmt.setInt(4, vo.getAssociateID());
stmt.setString(5, vo.getLikeBy());
stmt.setString(6, vo.getLastUserIDCd());
stmt.setInt(7, vo.getFeedLikeID());
// stmt.setString(7, vo.getLastUpdtTm());
stmt.executeUpdate();
logger.debug("updated records into the table...");
} catch (SQLException e) {
logger.error("LmsFeedLike SQLException1# " + e);
throw new LmsDaoException(e.getMessage());
} catch (Exception e) {
logger.error("LmsFeedLike Exception 2# " + e);
throw new LmsDaoException(e.getMessage());
} finally {
closeResources(conn, stmt, null);
}
logger.debug("Successfully updated....");
return status;
}
@Override
public void saveLmsFeedLike(LmsFeedLikeVO vo) throws LmsDaoException {
// Database connection start
Connection conn = null;
PreparedStatement stmt = null;
try {
conn = getConnection();
/*String sql = "INSERT INTO lms_feed_like(FEED_LIKE_ID, FEED_ID, PARENT_COMMENT_ID, LIKE_ON, ASSOCIATE_ID, " +
"LIKE_BY, LAST_USERID_CD) VALUES(?, ?, ?, ?, ?, ?, ?)";*/
String sql =
"INSERT INTO lms_feed_like(FEED_LIKE_ID, FEED_ID, PARENT_COMMENT_ID, LIKE_ON, ASSOCIATE_ID, "
+ "LIKE_BY, LAST_USERID_CD, LAST_UPDT_TM) VALUES(?, ?, ?, ?, ?, ?, ?, utc_timestamp)";
stmt = conn.prepareStatement(sql);
stmt.setInt(1, vo.getFeedLikeID());
stmt.setInt(2, vo.getFeedID());
stmt.setInt(3, vo.getParentCommentID());
stmt.setString(4, vo.getLikeOn());
stmt.setInt(5, vo.getAssociateID());
stmt.setString(6, vo.getLikeBy());
stmt.setString(7, vo.getLastUserIDCd());
// ...
stmt.executeUpdate();
logger.debug("Inserted records into the table...");
} catch (SQLException se) {
logger.error("lms_feed_like # " + se);
throw new LmsDaoException(se.getMessage());
} catch (Exception e) {
logger.error("lms_feed_like # " + e);
throw new LmsDaoException(e.getMessage());
} finally {
closeResources(conn, stmt, null);
}
logger.debug("Successfully saved....");
}