public Answersheet findAnswersheet(Long answersheetId) {
		SQLCommand cmd = new SQLCommand();
		RowSet rs = cmd.queryRowSet("select * from answersheet where as_id="
				+ answersheetId);
		
		Answersheet answersheet=new Answersheet();
		try {
			if (rs.next()) {
			  answersheet.setAsId(rs.getLong("as_id"));
			  answersheet.setSurvey(rs.getLong("s_id"));
			  answersheet.setAsResult(rs.getString("as_result"));
			  answersheet.setAsPostdate(rs.getDate("as_postdate"));
			  answersheet.setAsUserIp(rs.getString("as_userip"));
			}
			return answersheet;
 

		} catch (SQLException e) {

			e.printStackTrace();
			return null;
		}
		
	}