deptemployeetag.java

(Java+SQL)-大型企业JAVA的ERP系统

package tld;

import javax.servlet.jsp.JspException;
import java.io.IOException;
import src.wuyang.*;

public class DeptEmployeeTag extends javax.servlet.jsp.tagext.TagSupport{

String showType = "select";
String deptId = ""; 
String employeeId = "";
String whereClause = "";

public void setShowType(String aShowType) {
	showType = aShowType.toLowerCase(); // 变为小写
}

public void setDeptId(String aDeptId) {
	deptId = aDeptId;
}

public void setEmployeeId(String aEmployeeId) {
	employeeId = aEmployeeId;
}


/**
* Executes when the tag is started.
*/
public int doStartTag() throws JspException {
	return SKIP_BODY;
}

/**
* Executed with the end tag.
*/
public int doEndTag() throws JspException {
	try {
		
		//pageContext.getOut().print("<h2>Hello from doStartTag()</h2>");
		// Allowtext in the body of the tag
		Employee emp = new Employee();
		if (deptId.equals("") == false) {
			whereClause = "deptId='" + deptId + "'";
			}
		
		if(showType.equals("select")){
			emp.query(whereClause,"employeeId");	
			while(emp.next()== 1 ) {						
					pageContext.getOut().print("<option value=\"" + emp.getEmployeeId() + "\">" + emp.getEmpName() + "</option>");		
			}
		}else if(showType.equals("get")){
			emp.load (employeeId);
			pageContext.getOut().print(emp.getEmpName());
		}	
		return EVAL_BODY_INCLUDE;
	} catch (IOException e){
		throw new javax.servlet.jsp.JspException(e.getMessage());
	}
}

}