?? deleteservlet.java
字號:
/*
* DeleteServlet.java
*
* Created on 2008年5月27日, 上午10:43
*/
package serverBag;
import java.io.*;
import java.net.*;
import java.sql.*;
import javax.servlet.*;
import javax.servlet.http.*;
import publicBag.ConnectDB;
/**
*
* @author Administrator
* @version
*/
public class DeleteServlet extends HttpServlet {
/** Processes requests for both HTTP <code>GET</code> and <code>POST</code> methods.
* @param request servlet request
* @param response servlet response
*/
protected void processRequest(HttpServletRequest request, HttpServletResponse response)
throws ServletException, IOException {
response.setContentType("text/html;charset=GB2312");
PrintWriter out = response.getWriter();
out.println("<html>");
out.println("<head>");
out.println("<title>刪除用戶</title>");
out.println("</head>");
out.println("<body>");
out.println("<center>");
String userID = request.getParameter("userID");
try
{
Connection con = ConnectDB.connectMusicDB();
PreparedStatement stat = con.prepareStatement("DELETE UserInfo WHERE cUserID=?");
stat.setString(1,userID);
int num = stat.executeUpdate();
if(num > 0)
{
out.println("刪除用戶成功！！<br><br>");
out.println("<a href='manage.html'>返回查看頁面</a>");
}
else
{
out.println("登錄失敗！");
}
}
catch(Exception e)
{
e.printStackTrace();
return;
}
out.println("</center>");
out.println("</body>");
out.println("</html>");
out.close();
}
// <editor-fold defaultstate="collapsed" desc="HttpServlet methods. Click on the + sign on the left to edit the code.">
/** Handles the HTTP <code>GET</code> method.
* @param request servlet request
* @param response servlet response
*/
protected void doGet(HttpServletRequest request, HttpServletResponse response)
throws ServletException, IOException {
processRequest(request, response);
}
/** Handles the HTTP <code>POST</code> method.
* @param request servlet request
* @param response servlet response
*/
protected void doPost(HttpServletRequest request, HttpServletResponse response)
throws ServletException, IOException {
processRequest(request, response);
}
/** Returns a short description of the servlet.
*/
public String getServletInfo() {
return "Short description";
}
// </editor-fold>
}
?? 快捷鍵說明
復制代碼
Ctrl + C
搜索代碼
Ctrl + F
全屏模式
F11
切換主題
Ctrl + Shift + D
顯示快捷鍵
?
增大字號
Ctrl + =
減小字號
Ctrl + -