📄 deletepositionsubmit.java
字号:
package servlet;
import java.io.IOException;
import java.io.PrintWriter;
import javax.servlet.ServletException;
import javax.servlet.http.HttpServlet;
import javax.servlet.http.HttpServletRequest;
import javax.servlet.http.HttpServletResponse;
import myLogger.MideaLogger;
import com.suntek.eap.core.app.AppHandle;
import com.suntek.eap.jdbc.QueryHelper;
public class deletePositionSubmit extends HttpServlet {
/**
* Constructor of the object.
*/
public deletePositionSubmit() {
super();
}
/**
* Destruction of the servlet. <br>
*/
public void destroy() {
super.destroy(); // Just puts "destroy" string in log
// Put your code here
}
public void doGet(HttpServletRequest request, HttpServletResponse response)
throws ServletException, IOException {
this.doPost(request, response);
}
public void doPost(HttpServletRequest request, HttpServletResponse response)
throws ServletException, IOException {
response.setContentType("text/html");
request.setCharacterEncoding("GBK");
response.setCharacterEncoding("GBK");
PrintWriter out = response.getWriter();
javax.servlet.http.HttpSession session=request.getSession();
//获取form信息
String pid = request.getParameter("p_id");
String yhm = (String)session.getAttribute("yhm");
//QueryHelper queryer = QueryHelper.getDefault(AppHandle.getHandle("ResumeManagement").getDatasourceName());
QueryHelper deleter = QueryHelper.getDefault("orc10g");
String deletersql = "delete from POSITIONINFO where P_ID = "+pid;
try{
deleter.execute(deletersql);
}
catch(Exception ex)
{
MideaLogger.logger.error(ex.getMessage());
response.sendRedirect("../error.jsp?type=5");
}
String updatesql = "Update USERINFO SET I_SQZW = "+0+" WHERE VC_ID='"+yhm+"'";
try{
QueryHelper updater = QueryHelper.getDefault(AppHandle.getHandle("MideaHR").getDatasourceName());
updater.execute(updatesql);
}
catch(Exception ex)
{
MideaLogger.logger.error(ex.getMessage());
out.print("update wrong!");
}
out.println("<HTML>");
out.println(" <HEAD><TITLE>恭喜你成功申请！</TITLE></HEAD>");
out.println(" <BODY>");
if (yhm.equals("admin"))
out.println("<a href='../admin.jsp'>返回user首页</a>");
else
out.println("<a href='../user.jsp'>返回user首页</a>");
out.println(" </BODY>");
out.println("</HTML>");
out.flush();
out.close();
}
public void init() throws ServletException {
// Put your code here
}
}
⌨️ 快捷键说明
复制代码
Ctrl + C
搜索代码
Ctrl + F
全屏模式
F11
切换主题
Ctrl + Shift + D
显示快捷键
?
增大字号
Ctrl + =
减小字号
Ctrl + -