public Survey findSurvey(Long surveyId) {
		SQLCommand cmd = new SQLCommand();
		RowSet rs = cmd.queryRowSet("select * from survey where s_id="
				+ surveyId);
		Survey survey = new Survey();
		try {
			if (rs.next()) {
				survey.setSId(rs.getLong("s_id"));
				survey.setSName(rs.getString("s_name"));
				survey.setSDesc(rs.getString("s_desc"));
				survey.setSAuthor(rs.getString("s_author"));
				survey.setSImg(rs.getString("s_img"));
				survey.setSCreateDate(rs.getDate("s_createdate"));
				survey.setSPassword(rs.getString("s_password"));
				survey.setSIsOpen(rs.getBoolean("s_isopen"));
				survey.setSExpireDate(rs.getDate("s_expiredate"));
				survey.setSIsAudited(rs.getBoolean("s_isaudited"));
				survey.setSUsehits(rs.getLong("s_usehits"));

				return survey;
			} else {
				return null;
			}

		} catch (SQLException e) {

			e.printStackTrace();
			return null;
		} finally {
			SQLCommand.close(rs);
		}

	}