@Override
public boolean deleteLmsFeedLike(LmsFeedLikeVO vo) throws LmsDaoException {
System.out.println("id =" + vo.getFeedLikeID());
boolean status = true;
Connection conn = null;
PreparedStatement stmt = null;
try {
conn = getConnection();
String sql = "DELETE FROM lms_feed_like WHERE FEED_LIKE_ID = ?";
stmt = conn.prepareStatement(sql);
stmt.setInt(1, vo.getFeedLikeID());
stmt.executeUpdate();
logger.debug("Deleted records into the FEED_LIKE_ID table...");
} catch (SQLException se) {
logger.error("LmsFeedLike # " + se);
throw new LmsDaoException(se.getMessage());
} catch (Exception e) {
logger.error("LmsFeedLike # " + e);
throw new LmsDaoException(e.getMessage());
} finally {
closeResources(conn, stmt, null);
}
logger.debug("Successfully deleted....");
return status;
}
@Override
public LmsFeedLikeVO getLmsFeedLike(int id) throws LmsDaoException {
System.out.println("Inside getLmsFeedLikeVO(?) >>");
// Create object to return
LmsFeedLikeVO lmsFeedLikeVO = new LmsFeedLikeVO();
// 1 . jdbc code start
Connection conn = null;
PreparedStatement stmt = null;
try {
conn = getConnection();
String sql = "SELECT * FROM lms_feed_like where FEED_LIKE_ID=?";
stmt = conn.prepareStatement(sql);
stmt.setInt(1, lmsFeedLikeVO.getFeedLikeID());
ResultSet rs = stmt.executeQuery();
if (rs.next()) {
// 3. Set db data to object
lmsFeedLikeVO.setFeedLikeID(rs.getInt("FEED_LIKE_ID"));
lmsFeedLikeVO.setFeedID(rs.getInt("FEED_ID"));
lmsFeedLikeVO.setParentCommentID(rs.getInt("PARENT_COMMENT_ID"));
lmsFeedLikeVO.setLikeOn(rs.getString("LIKE_ON"));
lmsFeedLikeVO.setAssociateID(rs.getInt("ASSOCIATE_ID"));
lmsFeedLikeVO.setLikeBy(rs.getString("LIKE_BY"));
lmsFeedLikeVO.setLastUserIDCd(rs.getString("LAST_USERID_CD"));
lmsFeedLikeVO.setLastUpdtTm(rs.getString("LAST_UPDT_TM"));
}
logger.debug("get records into the table...");
} catch (SQLException se) {
logger.error("lmsFeedLikeVO # " + se);
throw new LmsDaoException(se.getMessage());
} catch (Exception e) {
logger.error("lmsFeedLikeVO # " + e);
throw new LmsDaoException(e.getMessage());
} finally {
closeResources(conn, stmt, null);
}
// 1 . jdbc code endd
// 4 Return as required by method
return lmsFeedLikeVO;
}
@Override
public List<LmsFeedLikeVO> getLmsFeedLikeList() throws LmsDaoException {
List<LmsFeedLikeVO> distList = new ArrayList<LmsFeedLikeVO>();
// 1 . jdbc code start
Connection conn = null;
PreparedStatement stmt = null;
try {
conn = getConnection();
String sql = "SELECT * FROM lms_feed_like ";
stmt = conn.prepareStatement(sql);
ResultSet rs = stmt.executeQuery();
while (rs.next()) {
// 3. Set db data to object
LmsFeedLikeVO lmsFeedLikeVO = new LmsFeedLikeVO();
lmsFeedLikeVO.setFeedLikeID(rs.getInt("FEED_LIKE_ID"));
lmsFeedLikeVO.setFeedID(rs.getInt("FEED_ID"));
lmsFeedLikeVO.setParentCommentID(rs.getInt("PARENT_COMMENT_ID"));
lmsFeedLikeVO.setLikeOn(rs.getString("LIKE_ON"));
lmsFeedLikeVO.setAssociateID(rs.getInt("ASSOCIATE_ID"));
lmsFeedLikeVO.setLikeBy(rs.getString("LIKE_BY"));
lmsFeedLikeVO.setLastUserIDCd(rs.getString("LAST_USERID_CD"));
lmsFeedLikeVO.setLastUpdtTm(rs.getString("LAST_UPDT_TM"));
// Add into list
distList.add(lmsFeedLikeVO);
}
logger.debug("get records into the list...");
} 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);
}
// 1 . jdbc code endd
// 4 Return as required by method
return distList;
}
@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....");
}