安道生網站技術練功房 - 分享經驗，累積智慧

1.修改generic_queries.sql，加上KarmaModel.deletePostKarma

# ###########
# KarmaModel
# ###########
...
KarmaModel.deletePostKarma = DELETE FROM jforum_karma WHERE post_id = ?
...

2.修改net/jforum/dao/KarmaDao.java，加上deletePostKarma(int postId) method宣告

public interface KarmaDAO
{
...
	/**
	 * Deletes the karma belonging to some post.
	 * This method will remove the post's karma from the
	 * karma table. 
	 *  
	 * @param postId The id of the post to delete	 
	 */
	public void deletePostKarma(int postId) ;
...
}

3.修改net/jforum/dao/generic/GenericKarmaDao.java，加上deletePostKarma(int postId) method實做

public class GenericKarmaDAO implements net.jforum.dao.KarmaDAO
{
...
	/**
	 * @see net.jforum.dao.KarmaDAO#deletePostKarma(int)
	 */
	public void deletePostKarma(int postId)
	{
		PreparedStatement p = null;		
		try {
			p = JForumExecutionContext.getConnection()
					.prepareStatement(SystemGlobals.getSql("KarmaModel.deletePostKarma"));
			p.setInt(1, postId);
			p.executeUpdate();
		}
		catch (SQLException e) {
			throw new DatabaseException(e);
		}
		finally {
			DbUtils.close(p);
		}
	}
...

4.修改net/jforum/view/forum/PostAction.java，修改delete() method，在Karma處理部分插入karmaDao.deletePostKarma(p.getId());在重算Karma之前

public class PostAction extends Command 
{
...
	public void delete()
	{
                ...
		// Karma
		KarmaDAO karmaDao = DataAccessDriver.getInstance().newKarmaDAO();
		karmaDao.deletePostKarma(p.getId());
		karmaDao.updateUserKarma(p.getUserId());
                ...
	}
...
}

5.重新編譯，並重新載入JForum