Examples with PersistenceException cn.edu.zju.acm.onlinejudge.persistence.PersistenceException used on opensource projects

Example 31 with PersistenceException

use of cn.edu.zju.acm.onlinejudge.persistence.PersistenceException in project zoj by licheng.

the class ProblemPersistenceImpl method updateProblem.

/**
     * <p>
     * Updates the specified problem in persistence layer.
     * </p>
     * 
     * @param problem
     *            the Problem instance to update
     * @param user
     *            the id of the user who made this modification
     * @throws PersistenceException
     *             wrapping a persistence implementation specific exception
     */
public void updateProblem(Problem problem, long user) throws PersistenceException {
    Connection conn = null;
    try {
        conn = Database.createConnection();
        conn.setAutoCommit(false);
        PreparedStatement ps = null;
        long contestLimitId = ProblemPersistenceImpl.DEFAULT_LIMIT_ID;
        try {
            ps = conn.prepareStatement(ProblemPersistenceImpl.GET_CONTEST_LIMIT_ID);
            ps.setLong(1, problem.getContestId());
            ResultSet rs = ps.executeQuery();
            if (rs.next()) {
                contestLimitId = rs.getLong(1);
            }
        } finally {
            Database.dispose(ps);
        }
        // update a new limit
        Limit limit = problem.getLimit();
        if (limit.getId() != contestLimitId) {
            try {
                ps = conn.prepareStatement(ProblemPersistenceImpl.INSERT_LIMIT);
                ps.setInt(1, limit.getTimeLimit());
                ps.setInt(2, limit.getMemoryLimit());
                ps.setInt(3, limit.getOutputLimit());
                ps.setInt(4, limit.getSubmissionLimit());
                ps.executeUpdate();
                limit.setId(Database.getLastId(conn));
            } finally {
                Database.dispose(ps);
            }
        }
        try {
            // update the problem
            ps = conn.prepareStatement(ProblemPersistenceImpl.UPDATE_PROBLEM);
            ps.setLong(1, problem.getContestId());
            ps.setString(2, problem.getTitle());
            ps.setString(3, problem.getCode());
            ps.setLong(4, limit.getId());
            ps.setString(5, problem.getAuthor());
            ps.setString(6, problem.getSource());
            ps.setString(7, problem.getContest());
            ps.setBoolean(8, problem.isChecker());
            ps.setLong(9, user);
            ps.setTimestamp(10, new Timestamp(new Date().getTime()));
            ps.setString(11, problem.getColor());
            ps.setInt(12, problem.getScore());
            ps.setLong(13, problem.getId());
            ps.executeUpdate();
        } finally {
            Database.dispose(ps);
        }
        conn.commit();
    } catch (Exception e) {
        Database.rollback(conn);
        throw new PersistenceException("Failed to create problem.", e);
    } finally {
        Database.dispose(conn);
    }
}

Example 32 with PersistenceException

use of cn.edu.zju.acm.onlinejudge.persistence.PersistenceException in project zoj by licheng.

the class UserPersistenceImpl method getUserProfileByCode.

/**
     * <p>
     * Gets the user profile with given code in persistence layer.
     * </p>
     * 
     * @param code
     *            the code of the user profile
     * @return the user profile with given code in persistence layer
     * @throws NullPointerException
     *             if argument is null
     * @throws PersistenceException
     *             wrapping a persistence implementation specific exception
     */
public UserProfile getUserProfileByCode(String code) throws PersistenceException {
    Connection conn = null;
    try {
        conn = Database.createConnection();
        PreparedStatement ps = null;
        try {
            ps = conn.prepareStatement(UserPersistenceImpl.GET_USER_BY_CODE);
            ps.setString(1, code);
            ResultSet rs = ps.executeQuery();
            if (rs.next()) {
                return this.populateUserProfile(rs);
            } else {
                return null;
            }
        } finally {
            Database.dispose(ps);
        }
    } catch (SQLException e) {
        throw new PersistenceException("Failed to get the user profile with code " + code, e);
    } finally {
        Database.dispose(conn);
    }
}

Example 33 with PersistenceException

use of cn.edu.zju.acm.onlinejudge.persistence.PersistenceException in project zoj by licheng.

the class UserPersistenceImpl method deleteUserProfile.

/**
     * <p>
     * Deletes the specified user profile in persistence layer.
     * </p>
     * 
     * @param id
     *            the id of the user profile to delete
     * @param user
     *            the id of the user who made this modification
     * @throws PersistenceException
     *             wrapping a persistence implementation specific exception
     */
public void deleteUserProfile(long id, long user) throws PersistenceException {
    Connection conn = null;
    try {
        conn = Database.createConnection();
        PreparedStatement ps = null;
        try {
            ps = conn.prepareStatement(UserPersistenceImpl.DELETE_USER);
            ps.setLong(1, user);
            ps.setTimestamp(2, new Timestamp(new Date().getTime()));
            ps.setLong(3, id);
            if (ps.executeUpdate() == 0) {
                throw new PersistenceException("No such user profile.");
            }
        } finally {
            Database.dispose(ps);
        }
    } catch (PersistenceException e) {
        throw e;
    } catch (SQLException e) {
        throw new PersistenceException("Failed to delete user profile.", e);
    } finally {
        Database.dispose(conn);
    }
}

Example 34 with PersistenceException

use of cn.edu.zju.acm.onlinejudge.persistence.PersistenceException in project zoj by licheng.

the class UserPersistenceImpl method searchUserProfiles.

/**
     * <p>
     * Searches all user profiles according with the given criteria in persistence layer.
     * </p>
     * 
     * @return a list of user profiles according with the given criteria
     * @param criteria
     *            the user profile search criteria
     * @param offset
     *            the offset of the start position to search
     * @param count
     *            the maximum number of user profiles in returned list
     * @throws NullPointerException
     *             if argument is null
     * @throws PersistenceException
     *             wrapping a persistence implementation specific exception
     */
public List<UserProfile> searchUserProfiles(UserCriteria criteria, int offset, int count) throws PersistenceException {
    Connection conn = null;
    try {
        conn = Database.createConnection();
        PreparedStatement ps = null;
        try {
            ps = this.getUserSearchSql(conn, criteria, false, offset, count);
            ResultSet rs = ps.executeQuery();
            List<UserProfile> users = new ArrayList<UserProfile>();
            while (rs.next()) {
                users.add(this.populateUserProfile(rs));
            }
            return users;
        } finally {
            Database.dispose(ps);
        }
    } catch (SQLException e) {
        throw new PersistenceException("Failed to search user.", e);
    } finally {
        Database.dispose(conn);
    }
}

Example 35 with PersistenceException

use of cn.edu.zju.acm.onlinejudge.persistence.PersistenceException in project zoj by licheng.

the class ReferencePersistenceImpl method getReference.

/**
     * <p>
     * Gets the reference with given id in persistence layer.
     * </p>
     * 
     * @param id
     *            the id of the reference
     * @return the reference with given id in persistence layer
     * @throws PersistenceException
     *             wrapping a persistence implementation specific exception
     */
public Reference getReference(long id) throws PersistenceException {
    Connection conn = null;
    try {
        conn = Database.createConnection();
        PreparedStatement ps = null;
        try {
            ps = conn.prepareStatement("SELECT reference_id, reference_type_id, name, content_type, " + "content, size, compressed FROM reference WHERE reference_id=?");
            ps.setLong(1, id);
            ResultSet rs = ps.executeQuery();
            if (!rs.next()) {
                return null;
            }
            return this.populateReference(rs);
        } finally {
            Database.dispose(ps);
        }
    } catch (SQLException e) {
        throw new PersistenceException("Failed to get the reference with id " + id, e);
    } finally {
        Database.dispose(conn);
    }
}