开通博客赚积分
发布资源赚积分
分类

源码开发语言/平台
当前位置：首页 > 源码/资料 > 行业应用 > 百货/超市行业 > 查看源码
in-changehw.jsp
资源名称：JspShop网络购物系统.rar　[点击查看]
上传用户：helenhuo66
上传日期：2007-06-01
资源大小：865k
文件大小：8k
源码类别：

百货/超市行业

开发平台：

Java

in-changehw.jsp：源码内容
  1. <%   boolean founderr=false;
  2.  String hw_ids ,hw_cashs,sort_ids,pifas,dailis,errmsg,datas,tuijians,Nsort_ids;
  3.  hw_ids=request.getParameter("hw_id");
  4.  if(hw_ids!=null)
  5.  {
  6.  //--------------------------------------hw_ids!=null---------------------------------------------
  7.       hw_id=Cint(hw_ids);
  8.       if(hw_id!=0){
  9.         sql="SELECT * from hw where hw_id="+hw_id; 
  10.             rs=mdb.executeQuery(sql);
  11. if(rs.next())
  12. {
  13.                   hw_name=rs.getString("hw_name");
  14.                  hw_cash=rs.getInt("hw_cash");
  15.                  hw_pic=rs.getString("hw_pic");
  16.                 hw_sn=rs.getString("hw_sn");
  17.                  sort_id=rs.getInt("sort_id");
  18.                 Nsort_id=rs.getInt("Nsort_id");
  19.             tuijian=rs.getBoolean("tuijian");
  20.             hw_content=rs.getString("hw_content");
  21. hw_content=hw_content.replaceAll("<br>",String.valueOf(' '));
  22.         hw_content2=rs.getString("hw_content2");
  23. hw_content2=hw_content2.replaceAll("<br>",String.valueOf(' '));
  25.              hw_views=rs.getInt("hw_views");
  26.             hw_buys=rs.getInt("hw_buys");
  27.              chubsh=rs.getString("chubsh");
  28.            zhuang=rs.getString("zhuang");
  29.            hw_sn=rs.getString("hw_sn");
  30.            company=rs.getString("company");
  31.            yeshu=rs.getString("yeshu");
  32.            kaiben=rs.getString("kaiben");
  33.            isbn=rs.getString("isbn");
  34.            pifa=rs.getInt("pifa");
  35.            daili=rs.getInt("daili");
  36.            data=rs.getDate("data");
  37.            rs.close();
  38. %>
  39. <!-----------------------------------table to show the modify info---------------------------------------->
  41. <table width="500" border="0" cellspacing="0" cellpadding="0" align="center" height="100" bgcolor="808080">
  42.   <tr> 
  43.     <td height="175"> 
  44.       <form name="form1" method="post" action="changehw.jsp?hw_id=<%=hw_id%>&action=save">
  45.         <table border="0" width="100%" cellspacing="1">
  46.           <tr bgcolor="#FFFFFF"> 
  47.             <td colspan="2"><font color="#FF0000">商品名称</font> 
  48.               <input type="text" name="hw_name" size="20" class=input value="<%=hw_name%>">
  49.               <font color="#FF0000"> &nbsp;&nbsp;&nbsp;&nbsp; 商品类别 </font> 
  50.               <select class="smallSel" name="sort_id" size="1">
  51. <%
  52.        sort_ids=request.getParameter("sort_id");
  53.        Nsort_ids=request.getParameter("Nsort_id");
  54.            String sel;
  55.           sql="select * from sort";
  56.            rs=mdb.executeQuery(sql);
  57.       if (!rs.next()){
  58.         out.print("Not record.");
  59.        }else
  60.        {  rs.previous();
  61.           while(rs.next())
  62.           {    sort_id=rs.getInt("sort_id");
  63.                     if (sort_id==Cint(sort_ids))
  64.                        {      sel="selected";
  65.                 }
  66.                     else
  67.             {
  68.                       sel="";
  69.                      }
  70.                   out.print("<option " +sel + " value='"+sort_id+"' name=sort_id>"+rs.getString("sort_name")+"</option>");
  71.               }
  72.       }
  73.      rs.close();
  74. %>
  75.               </select>
  76.               &nbsp;&nbsp;<font color="#FF0000">选择分类</font>： 
  77.               <select name="Nsort_id" size="1">
  78.                 <%
  79.        sql="select * from Nsort";
  80.         rs=mdb.executeQuery(sql);
  81.     if(!rs.next())
  82.     { out.print("Not record.");
  83.      }else
  84.     {  rs.previous();
  85.             while(rs.next())
  86.          { 
  87.              Nsort_id=rs.getInt("Nsort_id");
  88.                  if(Nsort_id==Cint(Nsort_ids))
  89.                  {       sel="selected";
  90.          }
  91.                  else
  92.           {
  93.                          sel="";
  94.                   }
  95.                  out.print( "<option " + sel + " value='" +  Nsort_id + "'>" + rs.getString("Nsort_name") + "</option>");
  96.         
  97.                   }
  98.          }
  99.              rs.close();
  100. %>
  101.               </select>
  102.               ** </td>
  103.           </tr>
  104.           <tr bgcolor="#FFFFFF"> 
  105.             <td colspan="2"><font color="#FF0000">图书原价</font> 
  106.               <input type="text" name="pifa" size="7" class=input value="<%=pifa%>">
  107.               元 <font color="#FF0000">&nbsp;&nbsp;&nbsp;&nbsp;会员价格</font> 
  108.               <input type="text" name="hw_cash" size="7" class=input value="<%=hw_cash%>">
  109.               元 <font color="#FF0000">&nbsp;&nbsp;&nbsp;&nbsp;VIP价格 </font> 
  110.               <input type="text" name="daili" size="7" class=input value="<%=daili%>">
  111.               元 </td>
  112.           </tr>
  113.           <tr bgcolor="#FFFFFF"> 
  114.             <td height="5" colspan="2"> 
  115.               <hr noshade size="1">
  116.             </td>
  117.           </tr>
  118.           <tr bgcolor="#FFFFFF"> 
  119.             <td width="25%"><font color="#000000">作者</font> 
  120.               <input type="text" name="hw_sn" size="10" class=input value="<%=hw_sn%>">
  121.             </td>
  122.             <td width="75%"><font color="#000000">出版社</font> 
  123.               <input type="text" name="chubsh" size="30" class=input value="<%=chubsh%>">
  124.             </td>
  125.           </tr>
  126.           <tr bgcolor="#FFFFFF"> 
  127.             <td width="25%"><font color="#000000">页数</font> 
  128.               <input type="text" name="yeshu" size="10" class=input value="<%=yeshu%>">
  129.             </td>
  130.             <td width="75%"><font color="#000000">出版日期</font> 
  131.               <input type="text" name="data" size="24" class=input value="<%=data%>">
  132.               格式:2002-10-10</td>
  133.           </tr>
  134.           <tr bgcolor="#FFFFFF"> 
  135.             <td width="25%"><font color="#000000">颜色</font> 
  136.               <input type="text" name="kaiben" size="10" class=input value="<%=kaiben%>">
  137.             </td>
  138.             <td width="75%"><font color="#000000">ISBN号码</font> 
  139.               <input type="text" name="isbn" size="30" class=input value="<%=isbn%>">
  140.             </td>
  141.           </tr>
  142.           <tr bgcolor="#FFFFFF"> 
  143.             <td height="5" colspan="2"> 
  144.               <hr noshade size="1">
  145.             </td>
  146.           </tr>
  147.           <tr bgcolor="#FFFFFF"> 
  148.             <td colspan="2"> <font color="#000000">装帧</font> 
  149.               <input type="text" name="zhuang" size="30" class=input value="<%=zhuang%>">
  150.             </td>
  151.           </tr>
  152.           <tr bgcolor="#FFFFFF"> 
  153.             <td colspan="2"><font color="#FF0000">简单内容介绍</font></td>
  154.           </tr>
  155.           <tr bgcolor="#FFFFFF"> 
  156.             <td valign="top" colspan="2"> 
  157.               <textarea rows="3" name="hw_content" cols="50" class=input><%=hw_content%></textarea>
  158.             </td>
  159.           </tr>
  160.           <tr bgcolor="#FFFFFF"> 
  161.             <td valign="top" colspan="2"><font color="#FF0000">详细内容介绍</font></td>
  162.           </tr>
  163.           <tr bgcolor="#FFFFFF"> 
  164.             <td valign="top" colspan="2"> 
  165.               <textarea rows="10" name="hw_content2" cols="50" class=input><%=hw_content2%></textarea>
  166.             </td>
  167.           </tr>
  168.           <tr bgcolor="#FFFFFF"> 
  169.             <td colspan="2"> <font color="#FF0000">商品图片</font> 
  170.               <input type="text" name="hw_pic" size="46" class=input value="<%=hw_pic%>"><a href="up.jsp" target="_blank">上传图片</a></td>
  171.           </tr>
  172.           <tr bgcolor="#FFFFFF"> 
  173.             <td colspan="2" height="24"> 
  174.               <input type="radio" name="tuijian" value="1">
  175.               推荐此商品 
  176.               <input type="radio" name="tuijian" value="0" checked>
  177.               不推荐
  178.               <input name="hw_id" type="hidden" id="hw_id" value="<%=hw_id%>"></td>
  179.           </tr>
  180.           <tr bgcolor="#FFFFFF" align="center"> 
  181.             <td colspan="2"> 
  182.               <input type="submit" name="Submit" value="修改">
  183.             </td>
  184.           </tr>
  185.         </table>
  186.       </form>
  187.     </td>
  188.   </tr>
  189. </table>
  191. <%        }//---------------------------rs.next end---------------------------------
  192.    }//---------------------------hw_id!=0 check end------------------------------------------------------
  193.     }//----------------------------hw_id!=null end-------------------------------------------------------------
  194. %>
  195.