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

源码开发语言/平台
当前位置：首页 > 源码/资料 > Java编程 > Applet > 查看源码
in-changehw.jsp
资源名称：jspgouwushop.rar　[点击查看]
上传用户：szlmxq
上传日期：2014-01-31
资源大小：740k
文件大小：8k
源码类别：

Applet

开发平台：

Java

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