public PingjiaoResultVO getStudentPjResult(CourseVO course) {
		String sql = 
			"select "
				+ "stustatus,"
				+ "tchresult "
			+ "from "
				+ "class "
			+ "where "
				+ "course_grade=? and "
				+ "course_semester=? and "
				+ "course_name=? and "
				+ "student_id=?;";
		String[] parameters = { course.getGrade(), course.getSemester(),
				course.getName(), course.getId() };
		PingjiaoResultVO pjResult = new PingjiaoResultVO();
		pjResult.setGrade(course.getGrade());
		pjResult.setSemester(course.getSemester());
		pjResult.setCourse(course.getName());
		ResultSet rs = DAO.executeQuery(sql, parameters);
		try {
			if (rs.next()) {
				String stustatus = rs.getString("stustatus");
				String tchresult = rs.getString("tchresult");
				pjResult.setGrade(course.getGrade());
				pjResult.setSemester(course.getSemester());
				pjResult.setCourse(course.getName());
				if (stustatus == null || stustatus.equals("")) {
					stustatus = "0";
				}
				pjResult.setStatus(stustatus);
				List<String> list = new ArrayList<String>();
				if (tchresult != null && !tchresult.equals("")) {
					String[] str = tchresult.split(",");
					for (String i : str) {
						list.add(i);
					}
				} else {
					for (int i = 0; i < 10; i++) {
						list.add("0");
					}

				}
				pjResult.setResult(list);

			}
		} catch (SQLException e) {
			// TODO Auto-generated catch block
			e.printStackTrace();
		}

		return pjResult;
	}