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

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