package tags;

import javax.servlet.jsp.JspWriter;
import javax.servlet.jsp.tagext.BodyTagSupport;

import db.CustomerOperation;

import java.io.IOException;
import javax.servlet.jsp.tagext.BodyContent;

public class GetUserCity extends BodyTagSupport {
	JspWriter out = null;

	/**
	 * 覆蓋doAfterBody（）類
	 * 
	 * @see javax.servlet.jsp.tagext.IterationTag#doAfterBody()
	 */
	public int doAfterBody() {
		// 取得BodyContent對象
		BodyContent body = getBodyContent();
		// 取得Body中的內容
		String content = body.getString();
		// 取得JspWriter對象
		out = body.getEnclosingWriter();
		// 初始化CustomerOperation對象
		CustomerOperation db = new CustomerOperation();
		int userId = Integer.parseInt(content);
		// 根據userId從數據庫中查詢用戶城市的信息
		int cityId = db.getUser(userId).getUserCity();
		String name = db.getCity(cityId);
		// 關閉數據庫的連接
		db.Close();
		try {
			out.print(name);
		} catch (IOException e) {
			e.printStackTrace();
		}
		return (SKIP_BODY);
	}
}