lookupselectedscore.java

使用struts+spring+JDBC 实现的学生选课管理系统

package bit.jeffy.business;

import java.io.IOException;
import java.util.Iterator;
import java.util.List;

import javax.servlet.jsp.JspWriter;

import bit.jeffy.entity.Course;
import bit.jeffy.entity.SelectCourse;
import bit.jeffy.entity.Student;
import bit.jeffy.service.CourseDao;
import bit.jeffy.service.SelectCourseDao;

public class LookupSelectedScore {
	private SelectCourseDao selectcoursedao;
	private CourseDao coursedao;

	public SelectCourseDao getSelectcoursedao() {
		return selectcoursedao;
	}

	public void setSelectcoursedao(SelectCourseDao selectcoursedao) {
		this.selectcoursedao = selectcoursedao;
	}
	
	public void list(JspWriter out, Long sid) throws IOException{
		List list = null;
		Iterator it = null;
		SelectCourse c = null;
		long cid;
		
		out.print("<table width=80%  border=1 cellspacing=1>");
		out.print("<tr align=center><td width=40%>课程名称</td><td width=30%>开课教师</td><td width=20%>成绩</td></tr>");
		
		Course course = null, crt = null;
		Student stu = new Student();
		stu.setId(sid.longValue());
		
		list = selectcoursedao.getAll(stu);
		if(list != null){
			it = list.iterator();
		}else{
			out.print("</table>");
			return ;
		}
		
		while(it.hasNext()){
			c = (SelectCourse)it.next();
			cid = c.getCourse_id();
			
			course = new Course();
			course.setId(cid);
			crt = coursedao.readById(course);
			if(crt == null){
				return ;
			}
			
			out.print("<tr>");
			out.print("<td>"+crt.getCourse_name()+"</td>");
			out.print("<td>"+c.getTeacher_id()+"</td>");
			out.print("<td>"+c.getScore()+"</td>");
			out.print("</tr>");
		}
		
		out.print("</table>");
	}

	public CourseDao getCoursedao() {
		return coursedao;
	}

	public void setCoursedao(CourseDao coursedao) {
		this.coursedao = coursedao;
	}
}