package com.course;
import java.io.*;
import java.sql.*;
import javax.servlet.*;
import javax.servlet.http.*;

public class TeacherSvlt extends HttpServlet{
//	響應(yīng)get請(qǐng)求	
public void doGet(HttpServletRequest req, HttpServletResponse res)
    throws ServletException, IOException {
    //獲得教師ID	    	
    String tea_id =req.getParameter("id");
    int success = 0;
    // 獲取請(qǐng)求中的參數(shù)
    String action = action = req.getParameter("action");
    teacher tea = null;
    String message="";
    
       // 如果請(qǐng)求中包含新建教師參數(shù)
       if ("new".equalsIgnoreCase(action)) {
      // 調(diào)用新建教師方法
      tea = doNew(req,res);
     // 并將新建教師存儲(chǔ)在request上下文中，然后轉(zhuǎn)向getteacher.jsp頁(yè)面
      sendBean(req, res, tea, "/getteacher.jsp");
    }  
    //如果請(qǐng)求中包含更新教師參數(shù)
    if ("update".equalsIgnoreCase(action)) {
    	try{
    	//調(diào)用更新教師方法
     	tea = doUpdate(req,res, tea_id);
     	//并將更新教師存儲(chǔ)在request上下文中，然后轉(zhuǎn)向getteacher.jsp頁(yè)面
     	sendBean(req,res,tea,"/getteacher.jsp");
     	   }
     	  catch(SQLException e){} 
    }
	//如果請(qǐng)求中包含刪除教師參數(shù)		   
    if ("delete".equalsIgnoreCase(action)) {
    	try{
        //調(diào)用刪除教師方法		
      	success = doDelete(tea_id);	
      	    }
      	    catch(SQLException e){}				
    	if (success != 1) {
    		doError(req, res, "TeacherSvlt: Delete unsuccessful. Rows affected: " + success);
    	} else {
    		res.sendRedirect("http://localhost:8080/test/getteacher.jsp");
    	}  
    }}
    
//新建教師方法定義
     public teacher doNew(HttpServletRequest req,HttpServletResponse res )
                           throws ServletException,IOException{
      teacher tea= new teacher();                     	
      String tea_id=req.getParameter("id");
      String name=new String(req.getParameter("name").getBytes("ISO8859_1"));
      String password= req.getParameter("password");
      String title=new String (req.getParameter("title").getBytes("ISO8859_1"));
      
      if(isTrue(req,res,tea_id,name,password) && hasLogin(req,res,tea_id)){
      
      tea.setId(tea_id);
      tea.setName(name);
      tea.setPassword(password);
      tea.setTitle(title);
      tea.addTeacher();
       }  
      return tea;                	
                           	
                           	}
                           	
      //更新教師信息方法                     	
      public teacher doUpdate(HttpServletRequest req,HttpServletResponse res , String id)
                           throws ServletException,IOException,SQLException {                      	
    teacher tea = new teacher(); 
      
    String name=new String(req.getParameter("name").getBytes("ISO8859_1"));                   
    String password = req.getParameter("password");
    String title = new String(req.getParameter("title").getBytes("ISO8859_1"));
        if(isTrue(req,res,id,name,password)){
    tea.setId(id);
    tea.setName(name);
    tea.setPassword(password);
    tea.setTitle(title);  
    tea.update();
           }
		return tea;
  }
    //刪除教師
    public int doDelete(String id) throws SQLException {
  	int num=0;
    teacher tea=new teacher();
    num=tea.delete(id);
    return num;
  }
//  保存教師信息的JavaBean到request上下文中
  public void sendBean(HttpServletRequest req, HttpServletResponse res,
                       teacher tea, String target)
                       throws ServletException, IOException {
    req.setAttribute("tea", tea);
    RequestDispatcher rd = getServletContext().getRequestDispatcher(target);
    rd.forward(req, res);
  }
  
    //錯(cuò)誤處理方法
    public void doError(HttpServletRequest req,
                      HttpServletResponse res,
                      String str)
                      throws ServletException, IOException {
                      	
    req.setAttribute("problem", str);
    RequestDispatcher rd = getServletContext().getRequestDispatcher("/errorpage.jsp");
    rd.forward(req, res);
  }
  
      //判斷教師是否被注冊(cè)過(guò)                 	
     public boolean hasLogin(HttpServletRequest req, HttpServletResponse res,String id)
  throws ServletException, IOException{
  	boolean f=true;
  	String message="對(duì)不起，該教師號(hào)已經(jīng)被注冊(cè)過(guò)了!";
  	teacher tea= new teacher();
  	f= tea.hasLogin(id);
  	if(f==false){
  	doError(req,res,message);	
  		}
  		return f;
  	}
  	
      //判斷教師注冊(cè)是否成功
  	  public boolean isTrue(HttpServletRequest req, HttpServletResponse res,
                        String id,String name,String password)
                        throws ServletException, IOException {
   boolean f=true;                     	
   String message ="";
   if(id==null || id.equals(""))  {
   	f=false;
   	message="錯(cuò)誤，教師號(hào)不能為空！";
   	doError(req,res,message);	}
   
   if(name==null || name.equals(""))  {
   	f=false;
   	message="教師姓名不能為空，請(qǐng)重新填寫！";
   	doError(req,res,message);	}
  	
       
   if(password==null || password.equals(""))  {
   	f=false;
   	message="密碼不能為空，請(qǐng)重新填寫！";
   	doError(req,res,message);	}  

     return f;
     
  }
    //響應(yīng)post請(qǐng)求
    public void doPost(HttpServletRequest req, HttpServletResponse res)
    throws ServletException, IOException {

    doGet(req, res);

  }
   
   
   }