Examples with Problem cn.edu.zju.acm.onlinejudge.bean.Problem used on opensource projects

Example 41 with Problem

use of cn.edu.zju.acm.onlinejudge.bean.Problem in project zoj by licheng.

the class MockProblemDAO method cloneProblem.

private Problem cloneProblem(Problem problem) {
    Problem ret = new Problem();
    ret.setId(problem.getId());
    ret.setRevision(problem.getRevision());
    ret.setLimit(cloneLimit(problem.getLimit()));
    ret.setChecker(problem.isChecker());
    return ret;
}

Example 42 with Problem

use of cn.edu.zju.acm.onlinejudge.bean.Problem in project zoj by licheng.

the class UserStatistics method isSolved.

public boolean isSolved(long id) {
    Problem p = new Problem();
    p.setId(id);
    return this.isSolved(p);
}

Example 43 with Problem

use of cn.edu.zju.acm.onlinejudge.bean.Problem in project zoj by licheng.

the class SubmissionPersistenceImpl method getUserStatistics.

public UserStatistics getUserStatistics(long contestId, long userId) throws PersistenceException {
    Connection conn = null;
    try {
        UserStatistics statistics = new UserStatistics(userId, contestId);
        conn = Database.createConnection();
        PreparedStatement ps = null;
        /*String sql =
                    "SELECT DISTINCT p.problem_id, p.code, p.title, s.judge_comment " +
                        SubmissionPersistenceImpl.GET_SUBMISSION_FROM_PART +
                        " AND s.user_profile_id=? AND s.judge_reply_id=? AND s.contest_id=?";*/
        String sql = "SELECT p.problem_id, p.code, p.title, s.judge_comment " + SubmissionPersistenceImpl.GET_SUBMISSION_FROM_PART + " AND s.user_profile_id=? AND s.judge_reply_id=? AND s.contest_id=?";
        sql = sql.replace("FORCE_INDEX", "USE INDEX (index_submission_user_reply_contest)");
        HashSet<Long> solvedid = new HashSet<Long>();
        HashSet<Long> confirmedid = new HashSet<Long>();
        List<Problem> solved = new ArrayList<Problem>();
        List<Problem> confirmed = new ArrayList<Problem>();
        try {
            ps = conn.prepareStatement(sql);
            ps.setLong(1, userId);
            ps.setLong(2, JudgeReply.ACCEPTED.getId());
            ps.setLong(3, contestId);
            ResultSet rs = ps.executeQuery();
            while (rs.next()) {
                Long probemid = new Long(rs.getLong("problem_id"));
                if (!solvedid.contains(probemid)) {
                    Problem p = new Problem();
                    p.setContestId(contestId);
                    p.setId(rs.getLong("problem_id"));
                    p.setCode(rs.getString("code"));
                    p.setTitle(rs.getString("title"));
                    solved.add(p);
                    solvedid.add(probemid);
                }
                String comment = rs.getString("judge_comment");
                if (!confirmed.contains(probemid) && "Yes".equals(comment)) {
                    Problem p = new Problem();
                    p.setContestId(contestId);
                    p.setId(rs.getLong("problem_id"));
                    p.setCode(rs.getString("code"));
                    p.setTitle(rs.getString("title"));
                    confirmed.add(p);
                    confirmedid.add(probemid);
                }
            }
        } finally {
            Database.dispose(ps);
        }
        statistics.setSolved(new TreeSet<Problem>(solved));
        statistics.setConfirmed(new TreeSet<Problem>(confirmed));
        try {
            ps = conn.prepareStatement("SELECT judge_reply_id, count(*) FROM submission WHERE contest_id=? AND user_profile_id=? GROUP BY judge_reply_id");
            ps.setLong(1, contestId);
            ps.setLong(2, userId);
            ResultSet rs = ps.executeQuery();
            while (rs.next()) {
                long jid = rs.getLong(1);
                int count = rs.getInt(2);
                statistics.setCount(jid, count);
            }
            return statistics;
        } finally {
            Database.dispose(ps);
        }
    } catch (SQLException e) {
        throw new PersistenceException("Failed to get the user statistics", e);
    } finally {
        Database.dispose(conn);
    }
}

Example 44 with Problem

use of cn.edu.zju.acm.onlinejudge.bean.Problem in project zoj by licheng.

the class ContestManager method searchProblems.

public List<Problem> searchProblems(ProblemCriteria criteria, int offset, int count) throws PersistenceException {
    List<Object> key = new ArrayList<Object>();
    key.add(criteria);
    key.add(new Integer(offset));
    key.add(new Integer(count));
    synchronized (this.contestProblemsCache) {
        List<Problem> problems = this.contestProblemsCache.get(key);
        if (problems == null) {
            ProblemPersistence problemPersistence = PersistenceManager.getInstance().getProblemPersistence();
            problems = problemPersistence.searchProblems(criteria, offset, count);
            this.contestProblemsCache.put(key, problems);
        }
        return problems;
    }
}