public boolean updateSurvey(Survey survey) {
		Connection conn = ConnectionFactory.getConnection();
		PreparedStatement pstmt = null;
		String sql = "UPDATE survey "
				+ "SET s_name=?, s_desc=?, s_author=?, s_img=?,  s_createDate=?,"
				+ " s_password=?, s_isOpen=?, s_expireDate=?, "
				+ "s_isAudited=?,s_usehits=? " + "WHERE s_id=?";
		try {
			pstmt = conn.prepareStatement(sql);
			pstmt.setString(1, survey.getSName());
			pstmt.setString(2, survey.getSDesc());
			pstmt.setString(3, survey.getSAuthor());
			pstmt.setString(4, survey.getSImg());
			pstmt.setDate(5, new java.sql.Date(survey.getSCreateDate()
					.getTime()));
			pstmt.setString(6, survey.getSPassword());
			pstmt.setBoolean(7, survey.getSIsOpen());
			pstmt.setDate(8, new java.sql.Date(survey.getSExpireDate()
					.getTime()));
			pstmt.setBoolean(9, survey.getSIsAudited());
			pstmt.setLong(10, survey.getSUsehits());
			pstmt.setLong(11, survey.getSId());
			return pstmt.executeUpdate() == 1 ? true : false;

		} catch (SQLException e) {
			e.printStackTrace();
			return false;
		} finally {
			SQLCommand.close(pstmt);
			SQLCommand.close(conn);

		}

	}