@Controller public class ShowRecommendationController extends BaseController { private static Log logger = LogFactory.getLog(ShowRecommendationController.class); private static boolean isDebug = logger.isDebugEnabled(); @Autowired IRecommendationService recommendationService; @RequestMapping(value = "/admin/showRecommendations", method = RequestMethod.GET) public String showRecommendations( Model model, HttpServletRequest request, HttpServletResponse response) throws Exception { // Integer sid = WebUtils.getReqParameter(request, "sid", -1);//default value should be -1, use // 1 for test Integer sid = Integer.parseInt(((T00User) getSessionData(request, StaticVarAll.USER_SESSION)).getId()); model.addAttribute("sid", sid); // 获取页数 int pagenum = WebUtils.getReqParameter(request, "pagenum", 1); if (pagenum <= 0 || pagenum <= 0) { pagenum = 1; } int pagesize = 20; List<T01Position> positionList = recommendationService.getRecommentdationPositionListBySid(sid); if (isDebug) { logger.debug("*****************sid******************" + sid); logger.debug("*****************positionList******************" + positionList); logger.debug("*****************pagenum******************" + pagenum); } Pager pager = new Pager(pagenum, recommendationService.getRecommendationCount(sid), pagesize); model.addAttribute("positionList", positionList); return "/admin/showRecommendations"; } }
@Service public class StudentRewardService implements IStudentRewardService { private static Log logger = LogFactory.getLog(StudentRewardService.class); public int addReward(T01RewardExp t01RewardExp) throws DaoException { String sql = "insert into t01_rewarded_exp values (null,?,?,?,?)"; if (logger.isDebugEnabled()) { logger.debug("**sql:" + sql); logger.debug("**rid:" + t01RewardExp); } IDao dao = DaoFactory.createDaoInstance(); return dao.update( "ijsp", sql, new Object[] { t01RewardExp.getRSid(), t01RewardExp.getRewardName(), t01RewardExp.getRewardTime(), t01RewardExp.getOrganization() }); } public int updateReward(T01RewardExp t01RewardExp) throws DaoException { String sql = "update t01_rewarded_exp set rewardName=?, rewardTime=?,organization=? where rid = ?"; if (logger.isDebugEnabled()) { logger.debug("**sql:" + sql); logger.debug("**rid:" + t01RewardExp); } IDao dao = DaoFactory.createDaoInstance(); return dao.update( "ijsp", sql, new Object[] { t01RewardExp.getRewardName(), t01RewardExp.getRewardTime(), t01RewardExp.getOrganization(), t01RewardExp.getRid() }); } public int getRewardCount(int rSid) throws DaoException { String sql = "select count(1) from t01_rewarded_exp where rSid = " + rSid; IDao dao = DaoFactory.createDaoInstance(); int count = dao.queryCount("ijsp", sql); if (logger.isDebugEnabled()) { logger.debug("**sql:" + sql); logger.debug("**count:" + count); } return count; } public T01RewardExp getReward(long rid) throws DaoException { String sql = "select * from t01_rewarded_exp where rid=?"; if (logger.isDebugEnabled()) { logger.debug("**sql:" + sql); logger.debug("**id:" + rid); } IDao dao = DaoFactory.createDaoInstance(); return dao.queryUniq("ijsp", sql, T01RewardExp.class, rid); } public List<T01RewardExp> listReward(int start, int length, int rSid) throws DaoException { String sql = "select * from t01_rewarded_exp where rSid = ? limit ?,?"; logger.debug("**sql:" + sql); logger.debug("**rSid:" + rSid); logger.debug("**start:" + start); logger.debug("**length:" + length); IDao dao = DaoFactory.createDaoInstance(); List<T01RewardExp> list = dao.query("ijsp", sql, T01RewardExp.class, new Object[] {rSid, start, length}); return list; } public int deleteReward(long rid) throws DaoException { String sql = "delete from t01_rewarded_exp where rid = ?"; if (logger.isDebugEnabled()) { logger.debug("**sql:" + sql); logger.debug("**id:" + rid); } IDao dao = DaoFactory.createDaoInstance(); return dao.update("ijsp", sql, rid); } }