/*
 * 創建日期 2005-12-7
 *
 * TODO 要更改此生成的文件的模板，請轉至
 * 窗口 － 首選項 － Java － 代碼樣式 － 代碼模板
 */
package bit.jeffy.business;

import javax.servlet.jsp.JspWriter;
import bit.jeffy.db.DataStore;
import java.sql.*;

/**
 * @author jeffy
 * 
 * TODO 要更改此生成的類型注釋的模板，請轉至 窗口 － 首選項 － Java － 代碼樣式 － 代碼模板
 */
public class ClientManagement {

	private JspWriter out;

	private String ZH = null;

	private DataStore ds = null;

	public ClientManagement(JspWriter jw, String user) {
		out = jw;
		ZH = user;
		if (ds == null)
			ds = DataStore.getInstance();
	}

	public void doplay() throws Exception {
		ResultSet st = null;
		String sql = "select * from Client where ZH='" + ZH + "'";
		String ZH="", XM="", XB="", MAIL="", PHONE="", QQ="", DESCRIPTION="";
		int PUBLIC = 0;

		if (ds != null)
			st = ds.read(sql);

		if (st != null && st.next()) {
			ZH = st.getString("ZH");
			XM = st.getString("XM");
			XB = st.getString("XB");
			MAIL = st.getString("MAIL");
			PHONE = st.getString("PHONE");
			QQ = st.getString("QQ");
			DESCRIPTION = st.getString("DESCRIPTION");
			PUBLIC = st.getInt("IFPUBLIC");
		}
		
		out.print("<table width=591 height=600 border=1 cellpadding=1 cellspacing=0 bordercolor=#0099FF>");
		out.print("<tr align=center><td colspan=2 class=BodyHeader_Middle>用戶個人資料</td></tr>");
		out.print("<tr><td width=130 class=bookText>帳戶名</td>");
		out.print("<td width=451 class=bookText>"+ZH+"</td></tr>");
		out.print("<tr><td class=bookText>姓名</td>");
		out.print("<td class=bookText>"+XM+"</td></tr>");
		out.print("<tr><td class=bookText>性別</td>");
		out.print("<td class=bookText>"+XB+"</td></tr>");
		out.print("<tr><td class=bookText>郵箱</td>");
		out.print("<td class=bookText>"+MAIL+"</td></tr>");
		out.print("<tr><td class=bookText>電話</td>");
		out.print("<td class=bookText>"+PHONE+"</td></tr>");
		out.print("<tr><td class=bookText>QQ號碼</td>");
		out.print("<td class=bookText>"+QQ+"</td></tr>");
		out.print("<tr><td class=bookText>是否公開個人資料</td>");
		if( PUBLIC == 0 )
			out.print("<td class=bookText>是</td></tr>");
		else
			out.print("<td class=bookText>否</td></tr>");
		out.print("<tr><td height=109 class=bookText>個人描述</td>");
		out.print("<td align=left valign=top class=bookText>"+DESCRIPTION+"</td></tr>");
		out.print("<tr align=center valign=middle><td height=57 colspan=2 class=bookText>");
		out.print("<table width=525 border=0 cellpadding=0 cellspacing=0>");
		out.print("<tr><td width=99>&nbsp;</td><td width=163 align=center class=bookText>&nbsp;</td>");
		out.print("<td width=191 align=center class=buttonText>");
		out.print("<a href=/PersonalPlatform/Modification.do>修改個人資料</a>");
		out.print("</td><td width=72>&nbsp;</td>");
		out.print("</tr></table></td></tr></table>");

	}
}