public boolean addSurvey(Survey survey) {
		Connection conn = ConnectionFactory.getConnection();
		PreparedStatement pstmt = null;
		String sql = "INSERT INTO survey( s_name, s_desc, s_author,s_img,  s_createDate,"
				+ "s_password, s_isOpen, s_expireDate, s_isAudited,  s_usehits"
				+ ") VALUES( ?, ?, ?, ?, ?,?, ?,?, ?, ?)";
		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());

			return pstmt.executeUpdate() == 1 ? true : false;

		} catch (SQLException e) {

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

		}

	}