package stu;
 
 import java.sql.*;

public class determin{
	String sql="";
	String stu_id="";
	String tea_id="";
	String coursename="";
	
	
	public String accept(){
		   sql="update enrol set accept=1  "+
               "where stu_id='"+stu_id+"' "+
                "and class_id IN ( "+
                "select classes.id  "+
                "from classes,course "+
                "where course.name='"+coursename+"' "+
                "and classes.tea_id='"+tea_id+"' and course.id=classes.cour_id) ";
         sqlBean sqlbean= new sqlBean() ;
           sqlbean.executeInsert(sql);    
          return stu_id;           
		                }
		                
	
	public  void setTea_id(String id){
		     this.tea_id=id; }                
		                    
	public String getTea_id(){
		return tea_id;}	                     
		                     
	public void setStu_id(String ss) { 
	                this.stu_id=ss;      
	                                 }
    public String getStu_ids(){
    	return stu_id;}	                                 
	                                 
	public void setCoursename(String ss){
		this.coursename = ss;}
		                                
    public String getCoursename(){
    	return coursename;}	
    	
    public ResultSet getStudent(String id){
    	sql="select * from student where id='"+id+"'";
           sqlBean sqlbean = new sqlBean(); 
           ResultSet rs = sqlbean.executeQuery(sql);
           return rs;                         }
           
	public ResultSet getStu_id(){	
       sql="select enrol.stu_id  "+
          " from enrol ,classes,course "+
           "where classes.cour_id=course.id "+
           "and enrol.class_id=classes.id "+ 
           "and( enrol.accept='0' or enrol.accept=null )"+
          " and course.name='"+coursename+"' ";               
           sqlBean sqlbean = new sqlBean(); 
           ResultSet rs = sqlbean.executeQuery(sql);
           return rs;
		                       }
	}