package util;

import java.sql.Connection;
import java.sql.ResultSet;
import java.sql.Statement;

import db.dbconn;

public class commonTag {
    /**
     * 功能：得到班級下拉框字符串
     * 輸入參數：班級ID號
     * 輸出：班級下拉框字符串
     */
    public String getClassTag(int class_id){
        String returnString=new String("");
        returnString="<select name='class_id'>";
        String sqlString=null;//SQL語句字符串
        Statement sql=null;//SQL語句對象
        ResultSet rs=null;//結果記錄集
        dbconn dbconnOBject=new dbconn();//數據庫連接對象
        Connection dbconn=dbconnOBject.getDBConn();//得到數據庫連接
        if(dbconn!=null)//連接成功
            //-------查詢出數據------------
            try{
                sqlString="select * from class"; 
                sql=dbconn.createStatement(ResultSet.TYPE_SCROLL_SENSITIVE, ResultSet.CONCUR_READ_ONLY);
                rs=sql.executeQuery(sqlString); 
                returnString=returnString+"<option value='0'>==所有==</option>";
                if(class_id==0){//所有班級
                    while(rs.next()){
                        returnString=returnString+"<option value='" +
                        		rs.getLong("class_id")+"'>" +
                        		rs.getString("class_name")+"</option>";
                    }
            	}else{//選定了某一個班級
            	    while(rs.next()){
                        if(rs.getLong("class_id")==(long)class_id){
                            returnString=returnString+"<option value='" +
                    		rs.getLong("class_id")+"' selected>" +
                    		rs.getString("class_name")+"</option>";
                        }else{
                            returnString=returnString+"<option value='" +
                    		rs.getLong("class_id")+"'>" +
                    		rs.getString("class_name")+"</option>";
                        }
            	    }
            	}
            }catch(Exception e){
                System.out.print(e);
            }
        returnString=returnString+"</select>";
        return returnString;
    }
    /**
     * 功能：得到課程下拉框字符串
     * 輸入參數：課程ID號
     * 輸出：課程下拉框字符串
     */
    public String getLessionTag(int lession_id){
        String returnString=new String("");
        returnString="<select name='lession_id'>";
        String sqlString=null;//SQL語句字符串
        Statement sql=null;//SQL語句對象
        ResultSet rs=null;//結果記錄集
        dbconn dbconnOBject=new dbconn();//數據庫連接對象
        Connection dbconn=dbconnOBject.getDBConn();//得到數據庫連接
        if(dbconn!=null)//連接成功
            //-------查詢出數據------------
            try{
                sqlString="select * from lession"; 
                sql=dbconn.createStatement(ResultSet.TYPE_SCROLL_SENSITIVE, ResultSet.CONCUR_READ_ONLY);
                rs=sql.executeQuery(sqlString); 
                returnString=returnString+"<option value='0'>==所有==</option>";
                if(lession_id==0){//所有課程
                    while(rs.next()){
                        returnString=returnString+"<option value='" +
                        		rs.getLong("lession_id")+"'>" +
                        		rs.getString("lession_name")+"</option>";
                    }
            	}else{//選定了某一個課程
            	    while(rs.next()){
                        if(rs.getLong("lession_id")==(long)lession_id){
                            returnString=returnString+"<option value='" +
                    		rs.getLong("lession_id")+"' selected>" +
                    		rs.getString("lession_name")+"</option>";
                        }else{
                            returnString=returnString+"<option value='" +
                    		rs.getLong("lession_id")+"'>" +
                    		rs.getString("lession_name")+"</option>";
                        }
            	    }
            	}
            }catch(Exception e){
                System.out.print(e);
            }
        returnString=returnString+"</select>";
        return returnString;
    }
    /**
     * 功能：得到教師下拉框字符串
     * 輸入參數：教師ID號
     * 輸出：教師下拉框字符串
     */
    public String getTeacherTag(int teacher_id){
        String returnString=new String("");
        returnString="<select name='teacher_id'>";
        String sqlString=null;//SQL語句字符串
        Statement sql=null;//SQL語句對象
        ResultSet rs=null;//結果記錄集
        dbconn dbconnOBject=new dbconn();//數據庫連接對象
        Connection dbconn=dbconnOBject.getDBConn();//得到數據庫連接
        if(dbconn!=null)//連接成功
            //-------查詢出數據------------
            try{
                sqlString="select * from teacher"; 
                sql=dbconn.createStatement(ResultSet.TYPE_SCROLL_SENSITIVE, ResultSet.CONCUR_READ_ONLY);
                rs=sql.executeQuery(sqlString); 
                returnString=returnString+"<option value='0'>==所有==</option>";
                if(teacher_id==0){//所有課程
                    while(rs.next()){
                        returnString=returnString+"<option value='" +
                        		rs.getLong("teacher_id")+"'>" +
                        		rs.getString("teacher_name")+"</option>";
                    }
            	}else{//選定了某一個課程
            	    while(rs.next()){
                        if(rs.getLong("teacher_id")==(long)teacher_id){
                            returnString=returnString+"<option value='" +
                    		rs.getLong("teacher_id")+"' selected>" +
                    		rs.getString("teacher_name")+"</option>";
                        }else{
                            returnString=returnString+"<option value='" +
                    		rs.getLong("teacher_id")+"'>" +
                    		rs.getString("teacher_name")+"</option>";
                        }
            	    }
            	}
            }catch(Exception e){
                System.out.print(e);
            }
        returnString=returnString+"</select>";
        return returnString;
    }    
    /**
     * 功能：得到角色下拉框字符串
     * 輸入參數：角色ID號
     * 輸出：角色下拉框字符串
     */
    public String getRoleTag(){
        String returnString=new String("");
        returnString="<select name='role_id'>";
        returnString=returnString+"<option value='1'>系統管理員</option>";
        returnString=returnString+"<option value='2'>教務管理員</option>";
        returnString=returnString+"</select>";
        return returnString;
    }      
}