package?com.lbl.biz;

import?java.sql.ResultSet;
import?java.sql.SQLException;
import?java.text.SimpleDateFormat;
import?java.util.ArrayList;
import?java.util.Date;
import?java.util.List;

import?com.lbl.dao.baseDao;
import?com.lbl.entity.Msg;

public?class?MsgBiz?{
baseDao?bd?=new?baseDao（）;
/**
?*?新增留言
?*?@param?msg??留言實例對象
?*?@return??布爾值
?*/
public?boolean?insertMsg（Msg?msg）{
	boolean?flag=false;
	String?sql=“INSERT?INTO?msg?（memailmphonemcontentmdate）?values?（????）“;
	String?memail=msg.getMemail（）;
	String?mphone=msg.getMphone（）;
	String?mcontent=msg.getMcontent（）;
	String?mdate=msg.getMdate（）;
	String[]?param={memailmphonemcontentmdate};
	flag=bd.getPreparedUpadate（sql?param）;
	return?flag;
}
/**
?*?獲取已經回復了的留言
?*?@return??留言列表
?*/
public?List?selectMsg（int?indexint?pageSize）{
???List?list?=?new?ArrayList（）;
???String?sql=“SELECT?*?FROM?msg?WHERE?mstatus=‘true‘?LIMIT?“+index+““+pageSize;
???String[]?param={};
????ResultSet?rs=?bd.getPrepraedQuery（sql?param）;
????try?{
		while（rs.next（））{
			String?mcontent?=rs.getString（“mcontent“）;
			String?mdate=rs.getString（“mdate“）;
			String?manswer=rs.getString（“manswer“）;
			String?adate=rs.getString（“adate“）;
			String?mstatus=rs.getString（“mstatus“）;
			Msg?msg=new?Msg（mcontentmdatemansweradatemstatus）;
			list.add（msg）;
		}
	}?catch?（SQLException?e）?{
		e.printStackTrace（）;
	}
???return?list;
	
}
}

?屬性????????????大小?????日期????時間???名稱
-----------?---------??----------?-----??----

?????文件????????447??2012-10-02?18:51??YiBei\.classpath

?????文件????????288??2012-10-22?15:55??YiBei\.mymetadata

?????文件???????1411??2012-10-04?11:21??YiBei\.project

?????文件????????500??2012-10-02?18:13??YiBei\.settings\.jsdtscope

?????文件?????????49??2012-10-02?18:13??YiBei\.settings\org.eclipse.wst.jsdt.ui.superType.container

?????文件??????????6??2012-10-02?18:13??YiBei\.settings\org.eclipse.wst.jsdt.ui.superType.name

?????文件???????1470??2012-10-08?09:01??YiBei\src\com\lbl\biz\MsgBiz.java

?????文件????????770??2012-10-07?20:04??YiBei\src\com\lbl\biz\PageBiz.java

?????文件???????1118??2012-10-06?22:24??YiBei\src\com\lbl\biz\QuestionBiz.java

?????文件???????1879??2012-10-06?20:52??YiBei\src\com\lbl\biz\TrendsBiz.java

?????文件????????721??2012-10-05?21:16??YiBei\src\com\lbl\biz\UserBiz.java

?????文件???????2178??2012-10-07?00:25??YiBei\src\com\lbl\dao\baseDao.java

?????文件???????1746??2012-10-07?14:04??YiBei\src\com\lbl\entity\Msg.java

?????文件????????869??2012-10-06?21:58??YiBei\src\com\lbl\entity\Question.java

?????文件????????908??2012-10-05?20:47??YiBei\src\com\lbl\entity\Trends.java

?????文件????????628??2012-10-04?11:45??YiBei\src\com\lbl\entity\Users.java

?????文件???????2005??2012-10-07?19:58??YiBei\src\com\lbl\servlet\DongTaiServlet.java

?????文件????????970??2012-10-06?17:09??YiBei\src\com\lbl\servlet\IndexServlet.java

?????文件???????2757??2012-10-08?09:45??YiBei\src\com\lbl\servlet\LiuyanServlet.java

?????文件???????1602??2012-10-08?09:17??YiBei\src\com\lbl\servlet\LoginServlet.java

?????文件???????1366??2012-10-06?22:37??YiBei\src\com\lbl\servlet\QuestionServlet.java

?????文件???????5572??2012-10-07?22:00??YiBei\WebRoot\call.jsp

?????文件???????4077??2012-10-07?22:00??YiBei\WebRoot\dongtai.jsp

?????文件???????5069??2012-10-18?10:19??YiBei\WebRoot\dongtai2.jsp

?????文件???????4406??2012-10-07?22:00??YiBei\WebRoot\help.jsp

?????文件???????1129??2012-10-04?11:26??YiBei\WebRoot\img\1.jpg

?????文件???????1064??2012-10-04?11:26??YiBei\WebRoot\img\2.jpg

?????文件????????993??2012-10-04?11:26??YiBei\WebRoot\img\3.jpg

?????文件???????1067??2012-10-04?11:26??YiBei\WebRoot\img\4.jpg

?????文件???????1052??2012-10-04?11:26??YiBei\WebRoot\img\5.jpg

............此處省略151個文件信息