package stu;
 
 import java.sql.*;

public class display{
  String stu_id;
  
  public void setStu_id(String id){stu_id=id;}	
  public String getStu_id(){return stu_id;}
  
  public ResultSet getCourse(){
  	
  String sql="select DISTINCT course.id,course.name,course.prepare,course.dep , "+
			"classes.id as class_id,classes.room_id,classes.cour_time "+
			"from course,classes "+
			"where classes.cour_id=course.id and "+
 			"classes.id in "+
			"( select classes.id from classes,student,course  "+
			"where classes.id not in( select class_id from enrol where stu_id='"+stu_id+"') "+
			"and ( student.department=course.dep or course.dep ='public')  "+
			"and course.id=classes.cour_id and student.id='"+stu_id+"') ";

  	  sqlBean db = new sqlBean();
  	ResultSet rs=  db.executeQuery(sql);
  	return rs;
  	                          }
  

	
}