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

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

百货/超市行业

开发平台：

Java

addhw.jsp：源码内容
  1. <%@ page contentType="text/html;charset=GBK" language="java" import="java.sql.*,java.util.Date" errorPage="" %>
  2. <%@ include file="conn.jsp"%>
  3. <%!
  4. String encode(String str)
  5.  {
  6.     String result;
  7.     int l;
  8.     if(str=="")
  9. {
  10.        result="";
  11. }
  12.     else
  13.     {
  14.     l=str.length();
  15. char[] chr=new char[l];
  16. str.getChars(0,l,chr,0);
  17.     result="";
  18. int i;
  19. for(i=0;i<=l-1;i++)
  20.   {
  21.     
  22.                switch(chr[i])
  23.     {
  25.     
  26.            case '<':
  27.                 result=result+"&lt;";
  28. break;
  29.            case '>':
  30.                 result=result+"&gt;";
  31.    break;
  33.               case 10:
  34.                 result=result+"<br>";
  35.   break;
  36.   case 13:
  37.                 result=result+"<br>";
  38.   break;
  39.            case 34:
  40.                 result=result+"&quot;";
  41.    break;
  42.            case '&':
  43.                 result=result+"&amp;";
  44.    break;
  45.               case ' ':
  46.         result=result+"&nbsp;";
  47.   break;
  48.                
  49.           case 9:
  50.                 result=result+"    ";
  51.    break;
  52.            default:
  53.                 result=result+String.valueOf(chr[i]);
  54. }
  55.   } 
  56. }
  57.     return result;
  58.   }
  59.  
  60. %>
  61. <html>
  62. <head>
  63. <meta http-equiv="Content-Type" content="text/html; charset=gb2312">
  64. <link href=../css.css rel=STYLESHEET type=text/css>
  65. </head>
  66. <%
  67. if(request.getParameter("action")!=null)
  68.  {//-----------------------------------action=save-----------------------------------------------------
  69.    if(request.getParameter("action").equals("save"))
  70.    {
  71.         String hw_name=request.getParameter("hw_name");
  72.     String hw_content=encode(request.getParameter("hw_content"));
  73. String hw_content2=encode(request.getParameter("hw_content2"));
  74.     String hw_cashs=request.getParameter("hw_cash");
  75.     String hw_pic=request.getParameter("hw_pic");
  76. String chubsh=request.getParameter("chubsh");
  77. String zhuang=request.getParameter("zhuang");
  78. String yeshu=request.getParameter("yeshu");
  79.  String isbn=request.getParameter("isbn");
  80.     String sort_ids=request.getParameter("sort_id");
  81.   String Nsort_ids=request.getParameter("Nsort_id");
  82.     String company=request.getParameter("company");
  83.    String pifas=request.getParameter("pifa");
  84. String dailis=request.getParameter("daili");
  85. String hwsn=request.getParameter("hwsn");
  86. String data=request.getParameter("data");
  87.   data=data.trim();
  88.   Date datas=new Date();
  89. String kaiben=request.getParameter("kaiben");
  90. String tuijian=request.getParameter("tuijian");
  91. String jia=request.getParameter("jia");
  92. String errmsg="输入有错!";
  93. boolean founderr=false;
  94.     if(Cint(hw_cashs)==0)
  95. {
  96.         errmsg="<br>"+"<li>价格应该为数字";
  97.         founderr=true;
  98.     }
  99.     if(hw_name=="")
  100. {
  101.         errmsg=errmsg+"<br>"+"<li>名称不能为空";
  102.         founderr=true;
  103.     }
  105.     if(hw_content=="")
  106. {
  107.         errmsg=errmsg+"<Br>"+"<li>介绍不能为空";
  108.         founderr=true;
  109.     }
  111.     if(sort_ids=="" )
  112. {
  113.         errmsg=errmsg+"<br>"+"<li>类别不能为空";
  114.         founderr=true;
  115.     }
  116.    
  117.       if(Nsort_ids=="") 
  118.   {
  119.         errmsg=errmsg+"<br>"+"<li>类别不能为空";
  120.         founderr=true;
  121.       }
  122.   if(data.length()!=10){
  123.     errmsg=errmsg+"<br>"+"<li>产品生产日期格式不正确";
  124.         founderr=true;
  125.   }else
  126.   {
  127.     if(data.indexOf('-')!=4||data.lastIndexOf('-')!=7){
  128.   errmsg=errmsg+"<br>"+"<li>产品生产日期格式不正确";
  129.           founderr=true;
  130. }
  131. else
  132. {
  133. int year=Cint(data.substring(0,4));
  134. int month=Cint(data.substring(5,7));
  135. int day=Cint(data.substring(8));
  136.   if(month>12||day>31||month<=0||day<=0){
  137.       errmsg=errmsg+"<br>"+"<li>产品生产日期格式不正确";
  138.              founderr=true;
  139.    }else{
  140.     datas=new Date(year-1900,month-1,day);
  141.    }
  142. }
  143.   }
  144.  if(hw_pic==""){ hw_pic="img/noimage.gif";}
  145.      if(chubsh==""|zhuang==""|yeshu==""|isbn==""|company==""|pifas==""|dailis==""|hwsn==""|data==""|kaiben==""|jia==""){
  146.    founderr=true;
  147.    }
  148.     if (founderr==true)
  149. {
  150.         out.print(errmsg);
  151.         out.print("<br>");
  152.         out.print("<a href=addhw.jsp>返回</a>");
  153.       }else
  154.  {
  155.         hw_name=getStr(hw_name);
  156.         company=getStr(company);
  157. hw_content2=encode(getStr(hw_content2));
  158.         hw_content=encode(getStr(hw_content));
  159. boolean btuijian=false,bjia=false;
  160. if(tuijian.equals("1")){ btuijian=true;}
  161. if(jia.equals("1")){ bjia=true;}
  163.         sql="insert into hw (hw_name,hw_content,hw_content2,hw_cash,sort_id,Nsort_id,company,daili,pifa,hw_sn,chubsh,kaiben,yeshu,";    
  164.         sql=sql+"data,isbn,zhuang,hw_pic,tuijian,jia)";
  165. sql=sql+"values('"+hw_name+"','"+hw_content+"','"+hw_content2+"',"+Cint(hw_cashs)+","+Cint(sort_ids)+","+Cint(Nsort_ids);
  166.         sql=sql+",'"+company+"',"+Cint(dailis)+","+Cint(pifas)+",'"+hwsn+"','"+chubsh+"','"+kaiben+"','"+yeshu+"','"+datas.toLocaleString()+"','"+isbn;
  167.         sql=sql+"','"+zhuang+"','"+hw_pic+"',"+btuijian+","+bjia+")";
  168. mdb.executeInsert(sql);
  169. out.print("货物添加成功");
  170.         out.print("<br>");
  171.         out.print("<a href=addhw.jsp>返回</a>");
  172.     
  173.     }
  174.     
  175.     
  176.   }
  177. }
  178. else{
  179. //-----------------------------------action!=save-----------------------------------------------------
  180. %>
  181. <html>
  182. <head>
  183. <meta http-equiv="Content-Type" content="text/html; charset=gb2312">
  184. <meta name="GENERATOR" content="Microsoft FrontPage 6.0">
  185. <title>添 加 商　品</title>
  186. <link rel="stylesheet" type="text/css" href="style.css">
  187. <%
  188. int count=0;
  189. sql = "select * from  Nsort  order by Nsort_id asc";
  190. rs=mdb.executeQuery(sql);
  191. %>
  192. <script language = "JavaScript">
  193. var onecount;
  194. onecount=0;
  195. subcat = new Array();
  196.         <%
  197.         while(rs.next()) 
  198. {
  199.         %>
  200. subcat[<%=count%>] = new Array("<%=rs.getString("Nsort_name")%>","<%=rs.getInt("sort_id")%>","<%=rs.getInt("Nsort_id")%>");
  201.         <%
  202.         count = count + 1;
  203.         }
  204. rs.close();
  205.         %>
  206. onecount=<%=count%>;
  208. function changelocation(locationid)
  209.     {
  210.     document.myform.Nsort_id.length = 0; 
  212.     var locationid=locationid;
  213.     var i;
  214.     for (i=0;i < onecount; i++)
  215.         {
  216.             if (subcat[i][1] == locationid)
  217.             { 
  218.                 document.myform.Nsort_id.options[document.myform.Nsort_id.length] = new Option(subcat[i][0], subcat[i][2]);
  219.             }        
  220.         }
  221.         
  222.     }    
  223. </script>
  224. </head>
  226. <body>
  227. <tr>
  228.     <td>
  229.       <div align="center"><b>所有选项都必须填写</b></div>
  230.     </td>
  231.   </tr>
  232. <form method="POST" name="myform" action="addhw.jsp?action=save">
  233.   <table class="border" cellspacing="0" width="80%" border="0" cellpadding="4" cellspacing="0" >
  234.     
  235.     <tr align="center">
  236.       <td class="tdbg" width="100%">
  237. <table border="0" cellspacing="1" width="100%">
  238.         
  239.                 <td width="85%">
  240. <%       int selclass=0;
  241.         sql = "select * from sort";
  242.        rs=mdb.executeQuery(sql);
  243. if(!rs.next())
  244. {
  245.   out.print("请先添加栏目。");
  246.  }else
  247.  {
  248.  rs.previous();
  249.  if(rs.next())
  250.    {
  251.       selclass=rs.getInt("sort_id");
  252.  %>
  253. <select name="sort_id" onChange="changelocation(document.myform.sort_id.options[document.myform.sort_id.selectedIndex].value)" size="1">
  254.         <option selected value="<%=selclass%>"><%=rs.getString("sort_name")%></option>
  255. <%       
  256.            while(rs.next())
  257.   {
  258. %> <option value="<%=rs.getInt("sort_id")%>"><%=rs.getString("sort_name")%></option>
  259. <%
  260.           }
  261.    }
  262. }
  263.        rs.close();
  264. %></select> 
  265. <select name="Nsort_id">                  
  266. <%
  267. sql="select * from Nsort where sort_id="+selclass;
  268. rs=mdb.executeQuery(sql);
  269. if(rs.next())
  270. {
  271. %>
  272.         <option selected value="<%=rs.getInt("Nsort_ID")%>"><%=rs.getString("Nsort_name")%></option>
  273. <% 
  274. while(rs.next())
  275.   {%>
  276.         <option value="<%=rs.getInt("Nsort_ID")%>"><%=rs.getString("Nsort_name")%></option>
  277. <% 
  278.    }
  279. }
  280. rs.close();
  281. %>
  282. </td>
  283.   </tr>
  284. </table>
  286. <table border="0" width="500" cellspacing="1" height="392" align="left">
  287.   <tr>
  288.     <td width="100%" height="395"> 
  289.       
  290.             <table border="0" width="100%" cellspacing="1">
  291.               <tr> 
  292.                 <td colspan="2"><font color="#FF0000">型号名称</font> 
  293.                   <input type="text" name="hw_name" size="20" class=input>
  294.                   <font color="#FF0000"> &nbsp;&nbsp;&nbsp;&nbsp; </font> </td>
  295.               </tr>
  296.               <tr> 
  297.                 <td colspan="2"><font color="#FF0000">市场价</font> 
  298.                   <input type="text" name="pifa" size="7" class=input>
  299.                   元 <font color="#FF0000">&nbsp;&nbsp;&nbsp;会员价</font> 
  300.                   <input type="text" name="hw_cash" size="7" class=input>
  301.                   元 <font color="#FF0000">&nbsp;&nbsp;&nbsp;&nbsp;VIP价</font> 
  302.                   <input type="text" name="daili" size="7" class=input>
  303.                   元 </td>
  304.               </tr>
  305.               <tr> 
  306.                 <td height="5" colspan="2"> 
  307.                   <hr noshade size="1">
  308.                 </td>
  309.               </tr>
  310.               <tr> 
  311.                 <td><font color="#000000">录入</font> 
  312.                   <input type="text" name="hwsn" size="10" class=input value="不详">
  313.                 </td>
  314.                 <td width="63%"><font color="#000000">出品公司</font> 
  315.                   <input type="text" name="chubsh" size="30" class=input value="不详">
  316.                 </td>
  317.               </tr>
  318.               <tr> 
  319.                 <td><font color="#000000">尺码</font> 
  320.                   <input type="text" name="kaiben" size="10" class=input value="16">
  321.                 </td>
  322.                 <td width="63%"><font color="#000000">出品日期</font> 
  323.                   <input type="text" name="data" size="24" class=input value="2002-10-10">
  324.                   格式:2002-01-01</td>
  325.               </tr>
  326.               <tr> 
  327.                 <td><font color="#000000">颜色</font> 
  328.                   <input type="text" name="yeshu" size="10" class=input value="100">
  329.                 </td>
  330.                 <td width="63%"><font color="#000000">编号</font> 
  331.                   <input type="text" name="isbn" size="30" class=input value="不详">
  332.                 </td>
  333.               </tr>
  334.               <tr> 
  335.                 <td height="5" colspan="2"> 
  336.                   <hr noshade size="1">
  337.                 </td>
  338.               </tr>
  339.               <tr> 
  340.                 <td colspan="2"> <font color="#000000">包装类型</font> 
  341.                   <input type="text" name="zhuang" size="30" class=input value="普通">
  342.                 </td>
  343.               </tr>
  344.               <tr> 
  345.                 <td colspan="2"> <font color="#FF0000">简单内容介绍</font></td>
  346.               </tr>
  347.               <tr> 
  348.                 <td valign="top" colspan="2"> 
  349.                   <textarea rows="3" name="hw_content" cols="50" class=input>暂时没有……</textarea>
  350.                 </td>
  351.               </tr>
  352.               <tr>
  353.                 <td valign="top" colspan="2"><font color="#FF0000">详细内容介绍</font></td>
  354.               </tr>
  355.               <tr>
  356.                 <td valign="top" colspan="2">
  357.                   <textarea rows="10" name="hw_content2" cols="50" class=input>暂时没有……</textarea>
  358.                 </td>
  359.               </tr>
  360.               <tr> 
  361.                 <td colspan="2"> <font color="#FF0000">商品图片</font> 
  362.                   <input type="text" name="hw_pic" size="46" class=input value="pic/"> <a href="up.jsp" target="_blank">上传图片</a></td>
  363.               </tr>
  364.             </table>
  365.             <table width="372" border="0" cellspacing="0" cellpadding="0" height="24">
  366.               <tr>
  367.                 <td>推荐此商品
  368.                   <input type="radio" name="tuijian" value="1">
  369.                   不推荐 
  370.                   <input type="radio" name="tuijian" value="0" checked>
  371.                   <br>
  372.                   否特价 
  373.                   <input name="jia" type="radio" value="0" checked>
  374.                   &nbsp;&nbsp; 是特价
  375.                   <input type="radio" name="jia" value="1"> 
  376.                 </td>
  377.               </tr>
  378.             </table>
  379.             <p>
  380.               <input type="submit" value="提交" name="B1" class=input>
  381.               <input type="reset" value="全部重写" name="B2" class=input>
  382.             </p>
  383.     
  384.       
  385.     </td>
  386.   </tr>
  387. </table>
  388. </form>
  390. </body>
  391. </html>
  393. <%}
  394. //--------------------------------------end action check----------------------------------------------
  395. %>