public List<Note> noteList(int courseId) throws SQLException {
		NoteDatabaseManager dm = new NoteDatabaseManager();
		String s_courseId = Integer.toString(courseId);
		String sql = "select * from note where course_id = " + s_courseId + ";";
		ResultSet rs = dm.sqlQuery(sql);

		List<Note> nList = new ArrayList<Note>();

		while (rs.next()) {
			int noteId = rs.getInt("note_id");
			String noteName = rs.getString("note_name");
			String noteAuthor = rs.getString("note_author");
			String noteContent = rs.getString("note_content");
			Timestamp updateTime = rs.getTimestamp("update_time");

			Note n = new Note(noteId, courseId, noteName, noteAuthor,
					noteContent, updateTime);
			nList.add(n);
		}
		return nList;
	}