public PingjiaoResultVO getTeacherPjResult(CourseVO course) {
		String sql = 
			"select "
				+ "tchstatus,"
				+ "sturesult "
			+ "from "
				+ "class "
			+ "where "
				+ "course_grade=? and "
				+ "course_semester=? and "
				+ "course_name=? and "
				+ "class=? and "
				+ "teacher_id=?;";
		String[] parameters = { course.getGrade(), course.getSemester(),
				course.getName().split(" ")[0], course.getName().split(" ")[1],
				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 tchstatus = rs.getString("tchstatus");
				String sturesult = rs.getString("sturesult");
				pjResult.setGrade(course.getGrade());
				pjResult.setSemester(course.getSemester());
				pjResult.setCourse(course.getName());
				if (tchstatus == null || tchstatus.equals("")) {
					tchstatus = "0";
				}
				pjResult.setStatus(tchstatus);
				List<String> list = new ArrayList<String>();
				if (sturesult != null && !sturesult.equals("")) {
					String[] str = sturesult.split(",");
					for (String i : str) {
						list.add(i);
					}
				} else {
					for (int i = 0; i < 5; i++) {
						list.add("0");
					}

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

		return pjResult;
	}