_stockupdate.java

精美的画面。完善的功能

  /*@lineinfo:filename=/Stockupdate.jsp*/
  /*@lineinfo:generated-code*/

import oracle.jsp.runtime.*;
import javax.servlet.*;
import javax.servlet.http.*;
import javax.servlet.jsp.*;
import java.sql.*;
import Flower.model.DBConnect;


public class _Stockupdate extends com.orionserver.http.OrionHttpJspPage {

  public final String _globalsClassName = null;

  // ** Begin Declarations


  // ** End Declarations

  public void _jspService(HttpServletRequest request, HttpServletResponse response) throws java.io.IOException, ServletException {

    response.setContentType( "text/html;charset=GBK");
    /* set up the intrinsic variables using the pageContext goober:
    ** session = HttpSession
    ** application = ServletContext
    ** out = JspWriter
    ** page = this
    ** config = ServletConfig
    ** all session/app beans declared in globals.jsa
    */
    PageContext pageContext = JspFactory.getDefaultFactory().getPageContext( this, request, response, null, true, JspWriter.DEFAULT_BUFFER, true);
    // Note: this is not emitted if the session directive == false
    HttpSession session = pageContext.getSession();
    if (pageContext.getAttribute(OracleJspRuntime.JSP_REQUEST_REDIRECTED, PageContext.REQUEST_SCOPE) != null) {
      pageContext.setAttribute(OracleJspRuntime.JSP_PAGE_DONTNOTIFY, "true", PageContext.PAGE_SCOPE);
      JspFactory.getDefaultFactory().releasePageContext(pageContext);
      return;
}
    int __jsp_tag_starteval;
    ServletContext application = pageContext.getServletContext();
    JspWriter out = pageContext.getOut();
    _Stockupdate page = this;
    ServletConfig config = pageContext.getServletConfig();

    try {
      // global beans
      // end global beans


      out.write(__oracle_jsp_text[0]);
      /*@lineinfo:user-code*//*@lineinfo:2^1*/      
       if(session.getAttribute("midentity")==null)
          {
            //  request.setAttribute("result","您没有权力进入此页");
             // getServletContext().getRequestDispatcher("display.jsp").forward(request,response);
              response.sendRedirect("FlowerIndex.jsp");
          }
      
      /*@lineinfo:generated-code*/
      out.write(__oracle_jsp_text[1]);
      /*@lineinfo:user-code*//*@lineinfo:24^17*/      
                          Connection con1=null;
                          PreparedStatement pstmt1=null;
                          ResultSet rs1=null;
                          con1=DBConnect.getConnection();
                          String stockid11=request.getParameter("stockid12");
                          if(stockid11==null)
                          {
                            stockid11="";
                          }
                          pstmt1=con1.prepareStatement("select * from Stock where Stockid=?");
                          pstmt1.setString(1,stockid11);
                          rs1=pstmt1.executeQuery();
                          while(rs1.next())
                          {
                      
      /*@lineinfo:generated-code*/
      out.write(__oracle_jsp_text[2]);
      /*@lineinfo:user-code*//*@lineinfo:45^62*/      out.print(rs1.getString(1));
      /*@lineinfo:generated-code*/
      out.write(__oracle_jsp_text[3]);
      /*@lineinfo:user-code*//*@lineinfo:55^21*/      
                            Connection con=null;
                            PreparedStatement pstmt=null;
                            ResultSet rs=null;
                            String stockid=request.getParameter("goodsid");
                            if(stockid==null)
                            {
                              stockid="";
                            }
                            con=DBConnect.getConnection();
                            pstmt=con.prepareStatement("select GoodsID from Goodsinfo");
                            rs=pstmt.executeQuery();
                            while(rs.next())
                            {
                                String stockid1=rs.getString(1);
                        
      /*@lineinfo:generated-code*/
      out.write(__oracle_jsp_text[4]);
      /*@lineinfo:user-code*//*@lineinfo:71^38*/      out.print(stockid1);
      /*@lineinfo:generated-code*/
      out.write(__oracle_jsp_text[5]);
      /*@lineinfo:user-code*//*@lineinfo:71^73*/      out.print(stockid1);
      /*@lineinfo:generated-code*/
      out.write(__oracle_jsp_text[6]);
      /*@lineinfo:user-code*//*@lineinfo:72^19*/          
                            }
                            rs.close();
                            pstmt.close();
                            con.close();
                        
      /*@lineinfo:generated-code*/
      out.write(__oracle_jsp_text[7]);
      /*@lineinfo:user-code*//*@lineinfo:86^63*/      out.print(rs1.getLong(3));
      /*@lineinfo:generated-code*/
      out.write(__oracle_jsp_text[8]);
      /*@lineinfo:user-code*//*@lineinfo:89^17*/      
                          }
                          rs1.close();
                          pstmt1.close();
                          con1.close();
                      
      /*@lineinfo:generated-code*/
      out.write(__oracle_jsp_text[9]);
      /*@lineinfo:user-code*//*@lineinfo:106^19*/      
                          
                        String result="请注意系统提示";
                        if(request.getAttribute("result")!=null)
                        {
                          result=request.getAttribute("result").toString();
                            
                        }
                      
      /*@lineinfo:generated-code*/
      out.write(__oracle_jsp_text[10]);
      /*@lineinfo:user-code*//*@lineinfo:115^35*/      out.print(result);
      /*@lineinfo:generated-code*/
      out.write(__oracle_jsp_text[11]);
      out.write(__oracle_jsp_text[12]);
      out.write(__oracle_jsp_text[13]);


    }
    catch( Throwable e) {
      try {
        if (out != null) out.clear();
      }
      catch( Exception clearException) {
      }
      pageContext.handlePageException( e);
    }
    finally {
      OracleJspRuntime.extraHandlePCFinally(pageContext,false);
      JspFactory.getDefaultFactory().releasePageContext(pageContext);
    }

  }
  private static final char __oracle_jsp_text[][]=new char[14][];
  static {
    try {
    __oracle_jsp_text[0] = 
    "\n".toCharArray();
    __oracle_jsp_text[1] = 
    "\n<html>\n  <head>\n    <meta http-equiv=\"Content-Type\" content=\"text/html; charset=GBK\">\n    <title>untitled</title>\n    <link href=\"css/jdeveloper.css\" rel=\"stylesheet\" media=\"screen\"/>\n  </head>\n  <body>\n    <table cellspacing=\"0\" cellpadding=\"0\" border=\"0\" width=\"578\" align=\"left\">\n      <tr>\n        <td>\n          <H1 align=\"center\">库存信息更新</H1>\n          <form action=\"stockservlet\" method=\"post\">\n            <DIV align=\"center\">\n              <table cellspacing=\"0\" cellpadding=\"0\" border=\"1\" width=\"60%\" align=\"center\">\n                ".toCharArray();
    __oracle_jsp_text[2] = 
    "\n                <tr>\n                  <td>\n                    <FONT color=\"#ff9966\">库存编号：</FONT>\n                  </td>\n                  <td>\n                    <input type=\"text\" name=\"stockid\" value=\"".toCharArray();
    __oracle_jsp_text[3] = 
    "\" readonly/>\n                  </td>\n                </tr>\n                <tr>\n                \n                  <td>\n                    <FONT color=\"#ff9966\">商品编号：</FONT>\n                  </td>\n                  <td>\n                    <select name=\"goodsid\">\n                    ".toCharArray();
    __oracle_jsp_text[4] = 
    "\n                      <option value=\"".toCharArray();
    __oracle_jsp_text[5] = 
    "\" selected=\"selected\">".toCharArray();
    __oracle_jsp_text[6] = 
    "</option>\n                  ".toCharArray();
    __oracle_jsp_text[7] = 
    " \n                  </select>\n                  </td>\n                </tr>\n                <tr>\n                  <td>\n                    <FONT color=\"#ff9966\">库存数量：</FONT>\n                  </td>\n                  <td>\n                    <input type=\"text\" name=\"stocknum\" value=\"".toCharArray();
    __oracle_jsp_text[8] = 
    "\"/>\n                  </td>\n                </tr>\n                ".toCharArray();
    __oracle_jsp_text[9] = 
    "\n                \n                \n                \n                \n                \n                \n                <tr>\n                  <td>\n                    <FONT color=\"#0033cc\">系统提示：</FONT>\n                  </td>\n                  <td>\n                  ".toCharArray();
    __oracle_jsp_text[10] = 
    "\n                <font color=\"red\">".toCharArray();
    __oracle_jsp_text[11] = 
    "</font>\n                  </td>\n                </tr>\n                <tr>\n                  <td>&nbsp;</td>\n                  <td>\n                    <input type=\"submit\" value=\"提交\"/>\n                    <input type=\"reset\" value=\"重置\"/>\n                    <input type=\"hidden\" name=\"action\" value=\"update\"/>\n                  </td>\n                </tr>\n              </table>\n              <P align=\"left\">\n                ".toCharArray();
    __oracle_jsp_text[12] = 
    "\n                ".toCharArray();
    __oracle_jsp_text[13] = 
    "\n              </P>\n            </DIV>\n          </form>\n          <P>&nbsp;</P>\n          <P>&nbsp;</P>\n        </td>\n      </tr>\n    </table>\n  </body>\n</html>\n".toCharArray();
    }
    catch (Throwable th) {
      System.err.println(th);
    }
}
}