?? delorupdate.java
字號:
package Servlet;
import java.io.IOException;
import java.io.PrintWriter;
import java.sql.Connection;
import java.sql.SQLException;
import javax.servlet.ServletException;
import javax.servlet.http.HttpServlet;
import javax.servlet.http.HttpServletRequest;
import javax.servlet.http.HttpServletResponse;
import Bean.DBConn;
public class DelOrUpdate extends HttpServlet {
/**
* Constructor of the object.
*/
public DelOrUpdate() {
super();
}
/**
* Destruction of the servlet. <br>
*/
public void destroy() {
super.destroy(); // Just puts "destroy" string in log
// Put your code here
}
/**
* The doGet method of the servlet. <br>
*
* This method is called when a form has its tag value method equals to get.
*
* @param request the request send by the client to the server
* @param response the response send by the server to the client
* @throws ServletException if an error occurred
* @throws IOException if an error occurred
*/
public void doGet(HttpServletRequest request, HttpServletResponse response)
throws ServletException, IOException {
response.setContentType("text/html");
PrintWriter out = response.getWriter();
out
.println("<!DOCTYPE HTML PUBLIC \"-//W3C//DTD HTML 4.01 Transitional//EN\">");
out.println("<HTML>");
out.println(" <HEAD><TITLE>A Servlet</TITLE></HEAD>");
out.println(" <BODY>");
out.print(" This is ");
out.print(this.getClass());
out.println(", using the GET method");
out.println(" </BODY>");
out.println("</HTML>");
out.flush();
out.close();
}
/**
* The doPost method of the servlet. <br>
*
* This method is called when a form has its tag value method equals to post.
*
* @param request the request send by the client to the server
* @param response the response send by the server to the client
* @throws ServletException if an error occurred
* @throws IOException if an error occurred
*/
public void doPost(HttpServletRequest request, HttpServletResponse response)
throws ServletException, IOException {
//---------------------Start MyCode-----------------------------------------------
String strDelete = request.getParameter("SubmitDelete");
String strUpdate = request.getParameter("SubmitUpdate");
String strbookID = request.getParameter("bookID");
if(strDelete != null)
{
System.out.println("選中的是Delete" + strbookID);
Connection conn=new DBConn().getConn();
String SQLString = "delete from book where bookID = '" + strbookID + "'";
try {System.out.println("have delete" + SQLString);
java.sql.Statement Stmt = conn.createStatement(); //語句對象
// Stmt.execute(SQLString);
Stmt.executeUpdate(SQLString);
System.out.println("Book have delete");
Stmt.close ();
conn.close();
conn.close();
request.getRequestDispatcher("/ShowDelUpdateBook.jsp").forward(request, response);
} catch (SQLException e) {
// TODO Auto-generated catch block
}
}
if(strUpdate != null)
{System.out.println("這是在DelOrUpdate中 的strbookID:");System.out.println(strbookID);
request.setAttribute("bookID", strbookID);
request.getRequestDispatcher("/BookUpdate.jsp").forward(request, response);
}
//-----------------------------End MyCode-------------------------------------------------------------
}
/**
* Initialization of the servlet. <br>
*
* @throws ServletException if an error occurs
*/
public void init() throws ServletException {
// Put your code here
}
}
?? 快捷鍵說明
復制代碼
Ctrl + C
搜索代碼
Ctrl + F
全屏模式
F11
切換主題
Ctrl + Shift + D
顯示快捷鍵
?
增大字號
Ctrl + =
減小字號
Ctrl + -