package?cpc.message;

import?java.io.IOException;
import?java.sql.Connection;
import?java.sql.DriverManager;
import?java.sql.PreparedStatement;
import?java.sql.ResultSet;
import?java.sql.SQLException;
import?java.util.ArrayList;
import?java.util.List;
import?javax.servlet.ServletException;
import?javax.servlet.http.HttpServlet;
import?javax.servlet.http.HttpServletRequest;
import?javax.servlet.http.HttpServletResponse;

public?class?DeleteServlet?extends?HttpServlet?{
	private?static?final?long?serialVersionUID?=?1L;??
????public?DeleteServlet（）?{
????????super（）;
??????????}
????
	protected?void?doGet（HttpServletRequest?request?HttpServletResponse?response）?throws?ServletException?IOException?{
				doPost（request?response）;
	}
	
	protected?void?doPost（HttpServletRequest?request?HttpServletResponse?response）?throws?ServletException?IOException?{
			int?id?=?Integer.parseInt（request.getParameter（“id“））;
		try?{
			Class.forName（“com.mysql.jdbc.Driver“）;
			String?url?=?“jdbc:mysql://localhost:3306/message“;
			String?username?=?“root“;
			String?password?=?“12130227“;?
			Connection?conn?=?DriverManager.getConnection（url?usernamepassword）;
			String?sql?=?null;
			sql?=?“delete?from?note?where?id?=??“;		
			PreparedStatement?pstmt?=?conn.prepareStatement（sql）;
			pstmt.setInt（1?id）;
			pstmt.executeUpdate（）;
			sql?=?“select?*?from?note“;
			pstmt?=?conn.prepareStatement（sql）;
			ResultSet?rs?=?pstmt.executeQuery（）;		
			List?list?=?new?ArrayList（）;
			while?（rs.next（））?{
				ListNoteBean?note?=?new?ListNoteBean（）;
				note.setId（rs.getInt（“id“））;
				note.settitle（rs.getString（“title“））;
				note.setAuthor（rs.getString（“author“））;
				note.setContent（rs.getString（“content“））;
				note.setReply（rs.getString（“reply“））;	
				list.add（note）;
			}
			request.setAttribute（“list“?list）;			
			pstmt.close（）;
			conn.close（）;
		}?catch?（ClassNotFoundException?e）?{
			e.printStackTrace（）;
		}?catch?（SQLException?e）?{
			e.printStackTrace（）;
		}	
		request.getRequestDispatcher（“cpc_listnote.jsp“）.forward（request?response）;
	}
}

?屬性????????????大小?????日期????時間???名稱
-----------?---------??----------?-----??----
?????目錄???????????0??2015-05-19?19:15??12130227?黃心妍?學生留言系統\
?????文件?????1296796??2015-05-19?19:18??12130227?黃心妍?學生留言系統\12130227?黃心妍.doc
?????文件????????1696??2015-05-18?15:40??12130227?黃心妍?學生留言系統\message.sql
?????目錄???????????0??2015-05-18?21:44??12130227?黃心妍?學生留言系統\msg\
?????文件?????????470??2015-05-11?15:31??12130227?黃心妍?學生留言系統\msg\.classpath
?????目錄???????????0??2015-05-11?12:25??12130227?黃心妍?學生留言系統\msg\.myeclipse\
?????文件?????????282??2015-05-11?12:25??12130227?黃心妍?學生留言系統\msg\.mymetadata
?????文件????????1409??2015-05-11?15:31??12130227?黃心妍?學生留言系統\msg\.project
?????目錄???????????0??2015-05-18?21:44??12130227?黃心妍?學生留言系統\msg\.settings\
?????文件?????????500??2015-05-11?12:25??12130227?黃心妍?學生留言系統\msg\.settings\.jsdtscope
?????文件?????????330??2015-05-11?12:25??12130227?黃心妍?學生留言系統\msg\.settings\org.eclipse.jdt.core.prefs
?????文件??????????49??2015-05-11?12:25??12130227?黃心妍?學生留言系統\msg\.settings\org.eclipse.wst.jsdt.ui.superType.container
?????文件???????????6??2015-05-11?12:25??12130227?黃心妍?學生留言系統\msg\.settings\org.eclipse.wst.jsdt.ui.superType.name
?????目錄???????????0??2015-05-18?21:44??12130227?黃心妍?學生留言系統\msg\src\
?????目錄???????????0??2015-05-18?21:44??12130227?黃心妍?學生留言系統\msg\src\cpc\
?????目錄???????????0??2015-05-18?21:44??12130227?黃心妍?學生留言系統\msg\src\cpc\message\
?????文件????????2137??2015-05-12?15:18??12130227?黃心妍?學生留言系統\msg\src\cpc\message\DeleteServlet.java
?????文件????????2463??2015-05-12?14:51??12130227?黃心妍?學生留言系統\msg\src\cpc\message\InsertServlet.java
?????文件?????????723??2015-05-11?12:50??12130227?黃心妍?學生留言系統\msg\src\cpc\message\ListNoteBean.java
?????文件????????2000??2015-05-12?14:47??12130227?黃心妍?學生留言系統\msg\src\cpc\message\ListNoteServlet.java
?????文件????????1809??2015-05-11?21:47??12130227?黃心妍?學生留言系統\msg\src\cpc\message\LoginServlet.java
?????文件????????1774??2015-05-11?15:53??12130227?黃心妍?學生留言系統\msg\src\cpc\message\RegistServlet.java
?????文件????????1995??2015-05-12?15:13??12130227?黃心妍?學生留言系統\msg\src\cpc\message\ReplyServlet.java
?????文件????????2327??2015-05-12?15:15??12130227?黃心妍?學生留言系統\msg\src\cpc\message\ReplyServlet2.java
?????文件????????2440??2015-05-11?15:59??12130227?黃心妍?學生留言系統\msg\src\cpc\message\SearchServlet.java
?????目錄???????????0??2015-05-18?21:44??12130227?黃心妍?學生留言系統\msg\WebRoot\
?????文件????????2342??2015-05-11?12:51??12130227?黃心妍?學生留言系統\msg\WebRoot\cpc_insert.jsp
?????文件????????2007??2015-05-11?21:53??12130227?黃心妍?學生留言系統\msg\WebRoot\cpc_listnote.jsp
?????文件????????2417??2015-05-11?12:39??12130227?黃心妍?學生留言系統\msg\WebRoot\cpc_register.jsp
?????文件????????2297??2015-05-11?12:54??12130227?黃心妍?學生留言系統\msg\WebRoot\cpc_reply.jsp
?????文件????????1258??2015-05-11?12:53??12130227?黃心妍?學生留言系統\msg\WebRoot\cpc_search.jsp
............此處省略25個文件信息