clientmanagement.java

个人数字平台（可以很方便的管理个人数据） 纯java编写

/*
 * 创建日期 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>");

	}
}