_goodsinfoupdate.java

精美的画面。完善的功能

  /*@lineinfo:filename=/Goodsinfoupdate.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 _Goodsinfoupdate 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();
    _Goodsinfoupdate 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:23^13*/      
                        Connection conn=null;
                        PreparedStatement pstmtt=null;
                        ResultSet rst=null;
                        String goodsid1=request.getParameter("goodsid1");
                        if(goodsid1==null)
                        {
                          goodsid1="";
                        }
                        conn=DBConnect.getConnection();
                        pstmtt=conn.prepareStatement("select * from GoodsInfo where Goodsid=?");
                        pstmtt.setString(1,goodsid1);
                        rst=pstmtt.executeQuery();
                        while(rst.next())
                        {
                        
                  
      /*@lineinfo:generated-code*/
      out.write(__oracle_jsp_text[2]);
      /*@lineinfo:user-code*//*@lineinfo:45^60*/      out.print(rst.getString(1));
      /*@lineinfo:generated-code*/
      out.write(__oracle_jsp_text[3]);
      /*@lineinfo:user-code*//*@lineinfo:55^17*/      
                            Connection con=null;
                            PreparedStatement pstmt=null;
                            ResultSet rs=null;
                            con=DBConnect.getConnection();
                            String flowerid1=request.getParameter("flowerid1");
                            if(flowerid1==null)
                            {
                              flowerid1="";
                            }
                            pstmt=con.prepareStatement("select * from FlowerInfo");
                            rs=pstmt.executeQuery();
                            while(rs.next())
                            {
                                String flowerid2=rs.getString(1);
                                String flowername2=rs.getString(2);
                      
      /*@lineinfo:generated-code*/
      out.write(__oracle_jsp_text[4]);
      /*@lineinfo:user-code*//*@lineinfo:72^36*/      out.print(flowerid2);
      /*@lineinfo:generated-code*/
      out.write(__oracle_jsp_text[5]);
      /*@lineinfo:user-code*//*@lineinfo:73^23*/      out.print(flowername2);
      /*@lineinfo:generated-code*/
      out.write(__oracle_jsp_text[6]);
      /*@lineinfo:user-code*//*@lineinfo:75^21*/      
                            }
                            rs.close();
                            pstmt.close();
                            con.close();
                          
      /*@lineinfo:generated-code*/
      out.write(__oracle_jsp_text[7]);
      /*@lineinfo:user-code*//*@lineinfo:89^59*/      out.print(rst.getDouble(3));
      /*@lineinfo:generated-code*/
      out.write(__oracle_jsp_text[8]);
      /*@lineinfo:user-code*//*@lineinfo:97^59*/      out.print(rst.getDouble(4));
      /*@lineinfo:generated-code*/
      out.write(__oracle_jsp_text[9]);
      /*@lineinfo:user-code*//*@lineinfo:106^20*/      
                            Connection con1=null;
                            PreparedStatement pstmt1=null;
                            ResultSet rs1=null;
                            con1=DBConnect.getConnection();
                            String  supid1=request.getParameter("supid1");
                            if(supid1==null)
                            {
                                supid1="";
                            }
                            pstmt1=con1.prepareStatement("select * from ProviderINfo11");
                            rs1=pstmt1.executeQuery();
                            while(rs1.next())
                            {
                                String supid2=rs1.getString(1);
                                String supname2=rs1.getString(2);
                      
      /*@lineinfo:generated-code*/
      out.write(__oracle_jsp_text[10]);
      /*@lineinfo:user-code*//*@lineinfo:123^36*/      out.print(supid2);
      /*@lineinfo:generated-code*/
      out.write(__oracle_jsp_text[11]);
      /*@lineinfo:user-code*//*@lineinfo:124^21*/      out.print(supname2);
      /*@lineinfo:generated-code*/
      out.write(__oracle_jsp_text[12]);
      /*@lineinfo:user-code*//*@lineinfo:126^21*/      
                            }
                            rs1.close();
                            pstmt1.close();
                            con1.close();
                          
      /*@lineinfo:generated-code*/
      out.write(__oracle_jsp_text[13]);
      /*@lineinfo:user-code*//*@lineinfo:140^41*/      out.print(rst.getString(6));
      /*@lineinfo:generated-code*/
      out.write(__oracle_jsp_text[14]);
      /*@lineinfo:user-code*//*@lineinfo:143^15*/      
                        }
                        rst.close();
                        pstmtt.close();
                        conn.close();
                    
      /*@lineinfo:generated-code*/
      out.write(__oracle_jsp_text[15]);
      /*@lineinfo:user-code*//*@lineinfo:158^21*/      
                          
                        String result="请注意系统提示";
                        if(request.getAttribute("result")!=null)
                        {
                          result=request.getAttribute("result").toString();
                            
                        }
                      
      /*@lineinfo:generated-code*/
      out.write(__oracle_jsp_text[16]);
      /*@lineinfo:user-code*//*@lineinfo:167^35*/      out.print(result);
      /*@lineinfo:generated-code*/
      out.write(__oracle_jsp_text[17]);
      out.write(__oracle_jsp_text[18]);
      out.write(__oracle_jsp_text[19]);


    }
    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[20][];
  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=\"760\" align=\"center\">\n      <tr>\n        <td>\n          <H1 align=\"center\">商品信息更新</H1>\n          <form action=\"goodsinfoservlet\" method=\"post\">\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=\"goodsid\" value=\"".toCharArray();
    __oracle_jsp_text[3] = 
    "\"/>\n                </td>\n              </tr>\n              <tr>\n                <td>\n                  <FONT color=\"#ff9966\">花卉编号：</FONT>\n                </td>\n                <td>\n                <select name=\"flowerid\">\n               \n                ".toCharArray();
    __oracle_jsp_text[4] = 
    "\n                    <option value=\"".toCharArray();
    __oracle_jsp_text[5] = 
    "\" selected=\"selected\">\n                      ".toCharArray();
    __oracle_jsp_text[6] = 
    "\n                    </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=\"rprice\" value=\"".toCharArray();
    __oracle_jsp_text[8] = 
    "\"/>\n                </td>\n              </tr>\n              <tr>\n                <td>\n                  <FONT color=\"#ff9966\">成本价：</FONT>\n                </td>\n                <td>\n                  <input type=\"text\" name=\"cprice\" value=\"".toCharArray();
    __oracle_jsp_text[9] = 
    "\"/>\n                </td>\n              </tr>\n              <tr>\n                <td>\n                  <FONT color=\"#ff9966\">供应商编号：</FONT>\n                </td>\n                <td>\n                  <select name=\"supid\">\n                   ".toCharArray();
    __oracle_jsp_text[10] = 
    "\n                    <option value=\"".toCharArray();
    __oracle_jsp_text[11] = 
    "\" selected=\"selected\">\n                    ".toCharArray();
    __oracle_jsp_text[12] = 
    "\n                    </option>\n                    ".toCharArray();
    __oracle_jsp_text[13] = 
    "\n                  </select>\n                </td>\n              </tr>\n              <tr>\n                <td>\n                  <FONT color=\"#ff9966\">属性：</FONT>\n                </td>\n                <td>\n                  <textarea name=\"attr\">".toCharArray();
    __oracle_jsp_text[14] = 
    "</textarea>\n                </td>\n              </tr>\n              ".toCharArray();
    __oracle_jsp_text[15] = 
    "\n              \n              \n              \n              \n              <tr>\n                <td>\n                  <FONT color=\"#0033cc\">系统提示：</FONT>\n                </td>\n                <td>\n                    ".toCharArray();
    __oracle_jsp_text[16] = 
    "\n                <font color=\"red\">".toCharArray();
    __oracle_jsp_text[17] = 
    "</font>\n                </td>\n              </tr>\n              <tr>\n                <td>&nbsp;</td>\n                <td>\n                  <input type=\"submit\" value=\"提交\"/>\n                  <input type=\"reset\" value=\"重置\"/>\n                  <a href=\"ManagerMain.jsp\">返回管理员主页</a> \n                  <input type=\"hidden\" name=\"action\" value=\"update\"/>\n                </td>\n              </tr>\n            </table>\n            <P>\n              ".toCharArray();
    __oracle_jsp_text[18] = 
    "\n              ".toCharArray();
    __oracle_jsp_text[19] = 
    "\n            </P>\n          </form>\n          <P>&nbsp;</P>\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);
    }
}
}