package?com.ljs.controller;

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?javax.servlet.ServletException;
import?javax.servlet.http.HttpServlet;
import?javax.servlet.http.HttpServletRequest;
import?javax.servlet.http.HttpServletResponse;

public?class?DeleteServlet?extends?HttpServlet?{

	@Override
	protected?void?service（HttpServletRequest?request?HttpServletResponse?response）
			throws?ServletException?IOException?{
		
		
		String?id?=?request.getParameter（“id“）;
		
		boolean?b?=?deleteById（id）;
		if（b）{
			response.sendRedirect（“list“）;
		}
	}

	
	
	
	
	
	private?Connection?conn;

	public?boolean?deleteById（String?id）{
		try?{
			//加載驅動
			Class.forName（“com.mysql.jdbc.Driver“）;
			//創建連接
			conn?=?DriverManager.getConnection（“jdbc:mysql://localhost:3306/test““root““root“）;
			//創建執行sql語句的對象
			PreparedStatement?pst?=?conn.prepareStatement（“delete?from?user?where?uid=?“）;
			pst.setString（1?id）;
			//執行sql語句
			int?in?=?pst.executeUpdate（）;
			if（in?>?0）{
				return?true;
			}
		}?catch?（Exception?e）?{
			//?TODO?Auto-generated?catch?block
			e.printStackTrace（）;
		}?finally{
			if（conn?!=?null）{
				try?{
					conn.close（）;
				}?catch?（SQLException?e）?{
					//?TODO?Auto-generated?catch?block
					e.printStackTrace（）;
				}
			}
		}
		return?false;
	}
}

?屬性????????????大小?????日期????時間???名稱
-----------?---------??----------?-----??----
?????目錄???????????0??2018-11-13?08:48??day11_13\
?????文件?????????906??2018-11-13?14:59??day11_13\.classpath
?????文件????????1041??2018-11-14?11:17??day11_13\.project
?????目錄???????????0??2018-11-13?08:48??day11_13\.settings\
?????文件?????????503??2018-11-13?08:48??day11_13\.settings\.jsdtscope
?????文件?????????364??2018-11-13?08:48??day11_13\.settings\org.eclipse.jdt.core.prefs
?????文件?????????476??2018-11-13?08:48??day11_13\.settings\org.eclipse.wst.common.component
?????文件?????????305??2018-11-13?14:59??day11_13\.settings\org.eclipse.wst.common.project.facet.core.xml
?????文件??????????49??2018-11-13?08:48??day11_13\.settings\org.eclipse.wst.jsdt.ui.superType.container
?????文件???????????6??2018-11-13?08:48??day11_13\.settings\org.eclipse.wst.jsdt.ui.superType.name
?????目錄???????????0??2018-11-13?08:48??day11_13\build\
?????目錄???????????0??2018-11-14?11:17??day11_13\build\classes\
?????目錄???????????0??2018-11-14?11:17??day11_13\build\classes\com\
?????目錄???????????0??2018-11-14?11:17??day11_13\build\classes\com\ljs\
?????目錄???????????0??2018-11-14?11:17??day11_13\build\classes\com\ljs\controller\
?????文件????????2475??2018-11-14?11:17??day11_13\build\classes\com\ljs\controller\DeleteServlet.class
?????文件????????3086??2018-11-14?11:17??day11_13\build\classes\com\ljs\controller\ListServlet.class
?????文件????????3121??2018-11-14?11:17??day11_13\build\classes\com\ljs\controller\LoginServlet.class
?????文件????????3022??2018-11-14?11:17??day11_13\build\classes\com\ljs\controller\RegisterServlet.class
?????文件????????3363??2018-11-14?11:17??day11_13\build\classes\com\ljs\controller\UpdateServlet.class
?????目錄???????????0??2018-11-14?11:17??day11_13\build\classes\com\ljs\entity\
?????文件????????1390??2018-11-14?11:17??day11_13\build\classes\com\ljs\entity\User.class
?????目錄???????????0??2018-11-13?18:27??day11_13\src\
?????目錄???????????0??2018-11-13?18:27??day11_13\src\com\
?????目錄???????????0??2018-11-13?20:05??day11_13\src\com\ljs\
?????目錄???????????0??2018-11-13?21:27??day11_13\src\com\ljs\controller\
?????文件????????1513??2018-11-13?20:49??day11_13\src\com\ljs\controller\DeleteServlet.java
?????文件????????1834??2018-11-13?21:01??day11_13\src\com\ljs\controller\ListServlet.java
?????文件????????1856??2018-11-13?20:03??day11_13\src\com\ljs\controller\LoginServlet.java
?????文件????????1933??2018-11-13?19:32??day11_13\src\com\ljs\controller\RegisterServlet.java
?????文件????????1897??2018-11-14?00:15??day11_13\src\com\ljs\controller\UpdateServlet.java
............此處省略20個文件信息