?? del.java
字號:
/*
* Created on 2004-9-25
*
* To change the template for this generated file go to
* Window>Preferences>Java>Code Generation>Code and Comments
*/
package com.em;
import oa.sys.*;
import java.io.*;
import java.sql.*;
import javax.servlet.*;
import javax.servlet.http.*;
/**
****************************************************
*類名稱: Del<br>
*類功能: 刪除員工信息<br>
*創(chuàng)建: 白偉明 2004年9月29日<br>
****************************************************
* To change the template for this generated type comment go to
* Window>Preferences>Java>Code Generation>Code and Comments
*/
public class Del extends HttpServlet{
private Statement stmt=null;
private String sql;
private RequestDispatcher dispatcher=null;
private HttpSession session=null;
private int id,temp;
private PrintWriter out=null;
public void doPost(HttpServletRequest request,HttpServletResponse response) throws ServletException, IOException{
request.setCharacterEncoding("gb2312");
response.setContentType("text/html; charset=gb2312");
out=response.getWriter();
session=request.getSession();
//獲取數(shù)據(jù)
id=Integer.parseInt((String)request.getParameter("id"));
Db db=new Db();
Str str=new Str();
sql="DELETE FROM eminfo WHERE employeeid="+id;
try{
stmt=db.getStmt();
temp=stmt.executeUpdate(sql);
db.close();
if(temp>0){
request.setAttribute("msg2","刪除成功");
}else{
request.setAttribute("msg2","刪除失敗");
}
}catch(Exception e){
request.setAttribute("msg2","刪除失敗,請刪除有關(guān)該員工的其它信息!");
System.err.print(e.getMessage());
}finally{
db.close();
dispatcher=request.getRequestDispatcher("select.jsp");
dispatcher.forward(request,response);
}
}
public void doGet(HttpServletRequest request,HttpServletResponse response) throws ServletException, IOException{
doPost(request,response);
}
}
?? 快捷鍵說明
復(fù)制代碼
Ctrl + C
搜索代碼
Ctrl + F
全屏模式
F11
切換主題
Ctrl + Shift + D
顯示快捷鍵
?
增大字號
Ctrl + =
減小字號
Ctrl + -