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


import java.sql.Date;
import java.sql.ResultSet;

import javax.servlet.jsp.JspWriter;

import bit.jeffy.db.DataStore;

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

	private JspWriter out;

	private String ZH = null;

	private DataStore ds = null;

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

	public void doplay() throws Exception {
		String sql ="select * from clientmessage where ZH='"+ZH+"'";
		ResultSet st = ds.read(sql);
		String content = null, friend = null;
		Date sndate = null;
		int id ;
		
		out.print("<table width=90%  border=5 cellspacing=0>");
		out.print("<tr align=center><td>消息內容</td><td>消息來源</td><td>發送時間</td><td>操作</td></tr>");
		while(st!=null && st.next()) {
			id = st.getInt("ID");
			friend = st.getString("FRIENDZH");
			content = st.getString("CONTENT");
			sndate = st.getDate("SENDTIME");
			
			out.print("<tr><td width=50%>"+content+"</td>");
			out.print("<td width=20%>"+friend+"</td>");
			out.print("<td width=20%>"+sndate+"</td>");
			out.print("<td width=10%><a href=/PersonalPlatform/RemoveMessage.do?mid="+id+">刪除</a></td>");
			
		}
		out.print("</table>");
		out.print("<table width=50%><tr align=center><td><a href=/PersonalPlatform/SendMessage.jsp>發送消息</a></td></tr></table>");
		
	}
}