package?com.bean;

import?java.sql.Connection;
import?java.sql.PreparedStatement;
import?java.sql.ResultSet;
import?java.sql.SQLException;
import?java.util.ArrayList;

import?com.dao.DbConnection;

public?class?Message?{
	private?int?id;
	private?String?title;
	private?String?content;
	public?int?getId（）?{
		return?id;
	}
	public?void?setId（int?id）?{
		this.id?=?id;
	}
	public?String?gettitle（）?{
		return?title;
	}
	public?void?settitle（String?title）?{
		this.title?=?title;
	}
	public?String?getContent（）?{
		return?content;
	}
	public?void?setContent（String?content）?{
		this.content?=?content;
	}
	//添加一條留言
	public?void?add（Message?message）?throws?SQLException{
		//獲取數據庫連接
		Connection?conn=DbConnection.getConnection（）;
		PreparedStatement?pre=?conn.prepareStatement（“INSERT?INTO?message（titlecontent）?VALUES?（??）“）;
		pre.setString（1?message.gettitle（））;
		pre.setString（2message.getContent（））;
		pre.execute（）;
		System.out.println（“插入一條留言記錄“）;
		conn.close（）;
	}
	//查詢所有留言
	public?ArrayList?queryAll（）?throws?SQLException{
		ArrayList?messages=new?ArrayList（）;
		ResultSet?rs=null;
		Connection?conn=DbConnection.getConnection（）;
		PreparedStatement?pre=conn.prepareStatement（“SELECT?*?FROM?message“）;
		rs=pre.executeQuery（）;
		while（rs.next（））{
			Message?message?=?new?Message（）;
			message.setId（rs.getInt（“id“））;
			message.settitle（rs.getString（“title“））;
			message.setContent（rs.getString（“content“））;
			
			messages.add（message）;
		}
		conn.close（）;
		return?messages;
	}
	//刪除一條留言
	public?void?delete（Message?message）?throws?SQLException{
		Connection?conn=DbConnection.getConnection（）;
		PreparedStatement?pre=conn.prepareStatement（“DELETE?FROM?message?WHERE?id=?“）;
		pre.setInt（1?message.getId（））;
		pre.execute（）;
		System.out.println（“刪除一條留言記錄:“+message.getId（））;
		conn.close（）;
	}
}

?屬性????????????大小?????日期????時間???名稱
-----------?---------??----------?-----??----
?????目錄???????????0??2013-04-17?18:59??Message\
?????文件?????????991??2013-04-17?19:06??Message\.classpath
?????文件????????1040??2013-04-17?18:59??Message\.project
?????目錄???????????0??2013-04-17?18:59??Message\.settings\
?????文件?????????503??2013-04-17?18:59??Message\.settings\.jsdtscope
?????文件?????????364??2013-04-17?18:59??Message\.settings\org.eclipse.jdt.core.prefs
?????文件?????????475??2013-04-17?18:59??Message\.settings\org.eclipse.wst.common.component
?????文件?????????345??2013-04-17?18:59??Message\.settings\org.eclipse.wst.common.project.facet.core.xml
?????文件??????????49??2013-04-17?18:59??Message\.settings\org.eclipse.wst.jsdt.ui.superType.container
?????文件???????????6??2013-04-17?18:59??Message\.settings\org.eclipse.wst.jsdt.ui.superType.name
?????目錄???????????0??2013-04-17?19:25??Message\WebContent\
?????目錄???????????0??2013-04-17?18:59??Message\WebContent\meta-INF\
?????文件??????????39??2013-04-17?18:59??Message\WebContent\meta-INF\MANIFEST.MF
?????目錄???????????0??2013-04-17?18:59??Message\WebContent\WEB-INF\
?????目錄???????????0??2013-04-17?19:05??Message\WebContent\WEB-INF\lib\
?????文件??????832960??2013-04-17?19:05??Message\WebContent\WEB-INF\lib\mysql-connector-java-5.1.22-bin.jar
?????文件?????????987??2013-04-17?19:01??Message\WebContent\WEB-INF\web.xml
?????文件?????????406??2013-04-17?19:03??Message\WebContent\index.jsp
?????文件?????????601??2013-04-17?12:47??Message\WebContent\message.jsp
?????文件????????1407??2013-04-17?18:57??Message\WebContent\show.jsp
?????目錄???????????0??2013-04-17?19:27??Message\WebContent\數據庫\
?????文件?????????891??2013-04-17?19:27??Message\WebContent\數據庫\message.sql
?????目錄???????????0??2013-04-17?18:59??Message\build\
?????目錄???????????0??2013-04-17?19:06??Message\build\classes\
?????目錄???????????0??2013-04-17?19:06??Message\build\classes\com\
?????目錄???????????0??2013-04-17?19:06??Message\build\classes\com\bean\
?????文件????????3059??2013-04-17?19:06??Message\build\classes\com\bean\Message.class
?????目錄???????????0??2013-04-17?19:06??Message\build\classes\com\dao\
?????文件????????1222??2013-04-17?19:24??Message\build\classes\com\dao\DbConnection.class
?????目錄???????????0??2013-04-17?19:06??Message\build\classes\com\ser\
?????文件????????2839??2013-04-17?19:06??Message\build\classes\com\ser\MessageServlet.class
............此處省略8個文件信息