📄 resqueryservlet.java
字号:
package jxc;import javax.servlet.*;import javax.servlet.http.*;import java.io.*;import java.util.*;import java.sql.*;/** * <p>Title: jxc demo</p> * <p>Description: </p> * <p>Copyright: Copyright (c) 2003</p> * <p>Company: </p> * @author cwx * @version 1.0 */public class ResQueryServlet extends HttpServlet { private static final String CONTENT_TYPE = "text/html; charset=GB2312"; //Initialize global variables public void init() throws ServletException { } //Process the HTTP Get request public void doGet(HttpServletRequest request, HttpServletResponse response) throws ServletException, IOException { String wareID = request.getParameter("wareID"); if (wareID == null) { wareID = ""; } /*JBuilder自动生成的代码 response.setContentType(CONTENT_TYPE); PrintWriter out = response.getWriter(); out.println("<html>"); out.println("<head><title>ResQueryServlet</title></head>"); out.println("<body bgcolor=\"#ffffff\">"); out.println("<p>The servlet has received a " + request.getMethod() + ". This is the reply.</p>"); out.println("</body></html>");*/ int resQty = InventoryManager.queryQty(wareID); if(resQty>=0){ //转往销售结果显示界面 String wareName = ""; Connection conn = null; PreparedStatement stmt = null; ResultSet rs = null; try{ conn = ConnectionManager.getConnection(); //读取商品名称 stmt = conn.prepareStatement("select * from Ware where wareID=" + wareID); rs = stmt.executeQuery(); if (rs.next()) wareName = rs.getString("wareName"); rs.close(); } catch(java.sql.SQLException e){ System.err.print(e); } finally { //关闭数据库资源 if (stmt != null) { try { stmt.close(); } catch (Exception exception) {} } if (conn != null) { try { conn.close(); } catch (Exception exception) {} } } request.setAttribute("wareName", wareName); request.setAttribute("resQty", new Integer(resQty)); getServletContext().getRequestDispatcher("/resInfo.jsp").forward(request, response); } else{ response.setContentType(CONTENT_TYPE); PrintWriter out = response.getWriter(); out.println("<html>"); out.println("<head><title>查询库存出错</title></head>"); out.println("<body bgcolor=\"#ffffff\">"); out.println("<p>error!</p>"); out.println("</body></html>"); } } //Process the HTTP Post request public void doPost(HttpServletRequest request, HttpServletResponse response) throws ServletException, IOException { doGet(request, response); } //Clean up resources public void destroy() { }}⌨️ 快捷键说明
复制代码
Ctrl + C
搜索代码
Ctrl + F
全屏模式
F11
切换主题
Ctrl + Shift + D
显示快捷键
?
增大字号
Ctrl + =
减小字号
Ctrl + -