package util;

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

import db.dbconn;

public class commonTag {
    /**
     * 功能：得到班級(jí)下拉框字符串
     * 輸入?yún)?shù)：班級(jí)ID號(hào)
     * 輸出：班級(jí)下拉框字符串
     */
    public String getClassTag(int class_id){
        String returnString=new String("");
        returnString="<select name='class_id'>";
        String sqlString=null;//SQL語(yǔ)句字符串
        Statement sql=null;//SQL語(yǔ)句對(duì)象
        ResultSet rs=null;//結(jié)果記錄集
        dbconn dbconnOBject=new dbconn();//數(shù)據(jù)庫(kù)連接對(duì)象
        Connection dbconn=dbconnOBject.getDBConn();//得到數(shù)據(jù)庫(kù)連接
        if(dbconn!=null)//連接成功
            //-------查詢出數(shù)據(jù)------------
            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){//所有班級(jí)
                    while(rs.next()){
                        returnString=returnString+"<option value='" +
                        		rs.getLong("class_id")+"'>" +
                        		rs.getString("class_name")+"</option>";
                    }
            	}else{//選定了某一個(gè)班級(jí)
            	    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;
    }
    /**
     * 功能：得到課程下拉框字符串
     * 輸入?yún)?shù)：課程ID號(hào)
     * 輸出：課程下拉框字符串
     */
    public String getLessionTag(int lession_id){
        String returnString=new String("");
        returnString="<select name='lession_id'>";
        String sqlString=null;//SQL語(yǔ)句字符串
        Statement sql=null;//SQL語(yǔ)句對(duì)象
        ResultSet rs=null;//結(jié)果記錄集
        dbconn dbconnOBject=new dbconn();//數(shù)據(jù)庫(kù)連接對(duì)象
        Connection dbconn=dbconnOBject.getDBConn();//得到數(shù)據(jù)庫(kù)連接
        if(dbconn!=null)//連接成功
            //-------查詢出數(shù)據(jù)------------
            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{//選定了某一個(gè)課程
            	    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;
    }
    /**
     * 功能：得到教師下拉框字符串
     * 輸入?yún)?shù)：教師ID號(hào)
     * 輸出：教師下拉框字符串
     */
    public String getTeacherTag(int teacher_id){
        String returnString=new String("");
        returnString="<select name='teacher_id'>";
        String sqlString=null;//SQL語(yǔ)句字符串
        Statement sql=null;//SQL語(yǔ)句對(duì)象
        ResultSet rs=null;//結(jié)果記錄集
        dbconn dbconnOBject=new dbconn();//數(shù)據(jù)庫(kù)連接對(duì)象
        Connection dbconn=dbconnOBject.getDBConn();//得到數(shù)據(jù)庫(kù)連接
        if(dbconn!=null)//連接成功
            //-------查詢出數(shù)據(jù)------------
            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{//選定了某一個(gè)課程
            	    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;
    }    
    /**
     * 功能：得到角色下拉框字符串
     * 輸入?yún)?shù)：角色I(xiàn)D號(hào)
     * 輸出：角色下拉框字符串
     */
    public String getRoleTag(){
        String returnString=new String("");
        returnString="<select name='role_id'>";
        returnString=returnString+"<option value='1'>系統(tǒng)管理員</option>";
        returnString=returnString+"<option value='2'>教務(wù)管理員</option>";
        returnString=returnString+"</select>";
        return returnString;
    }      
}