readcourseforstudent.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.Student;
import bit.jeffy.service.CourseDao;

public class ReadCourseForStudent {
	private CourseDao coursedao;
	
	public void list(JspWriter out, Long sid) throws IOException{
		List list = null;
		Iterator it = null;
		Course c = null;
		
		out.print("<table width=80%  border=1 cellspacing=1>");
		out.print("<tr align=center><td width=40%>课程编号</td><td width=40%>课程名称</td><td width=10%>选择</td></tr>");
		
		Student stu = new Student();
		stu.setId(sid.longValue());
		
		//取出学生没有选过的课
		list = coursedao.getAllByTid(stu);
		if(list != null){
			it = list.iterator();
		}else{
			out.print("</table>");
			return ;
		}
		
		while(it.hasNext()){
			c = (Course)it.next();
			
			out.print("<tr>");
			out.print("<td>"+c.getCourse_no()+"</td>");
			out.print("<td>"+c.getCourse_name()+"</td>");
			out.print("<td><a href=/SelectCourse/SelectCourse.do?scid="+c.getId()+"&tid="+c.getTeacher_id()+">选择"+"</td>");
			out.print("</tr>");
		}
		
		out.print("</table>");
	}



	public CourseDao getCoursedao() {
		return coursedao;
	}

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