pro_edit2.jsp

此小软件实现了小型超市的进销存系统,它展示了小型超市的进货和销售,还有库存的各种技术!

<%@ page contentType="text/html; charset=gb2312"  %>
<jsp:useBean id="fileBean" scope="page" class="jspeshop.UploadBean" />
<jsp:useBean id="DBConn" scope="page" class="jspeshop.DBConn"/>
<%@ page import="java.sql.*" %>

<%
if (session.getAttribute("name") == null) {
    response.sendRedirect("index.jsp");
  }else {
  request.setCharacterEncoding("GB2312");
String sql=null;
String pro_pic="";


fileBean.setObjectPath("F:/eShop/jspEshop/wshop/admin/propic/");
fileBean.setSuffix(".gif.jpg.png.jpge");
fileBean.setSourceFile(request);

String[] saSourceFile=fileBean.getSourceFile();
String[] saObjectFile=fileBean.getObjectFileName();
String[] saDescription=fileBean.getDescription();

int iCount=fileBean.getCount();

  String pro_id=fileBean.getFieldValue("PRO_ID");

  System.out.println("pro_id       "+pro_id);
  String pro_idh=fileBean.getFieldValue("proidh");
 String pro_name=fileBean.getFieldValue("PRO_NAME");


  String cl1_name=fileBean.getFieldValue("CL1_NAME");

  String  cl2_name=fileBean.getFieldValue("CL2_NAME");

   String  pro_intro=fileBean.getFieldValue("PRO_INTRO");
  Float pro_pri=new Float(fileBean.getFieldValue("PRO_PRI"));

    Float pro_vip_pri=new Float(fileBean.getFieldValue("PRO_VIP_PRI"));




   Connection con;
    Statement st;
    con = DBConn.GetConn();
    st = con.createStatement();
	if (pro_pic==""){


      sql = "Update Product set PRO_ID='"+pro_id+"',PRO_NAME='"+pro_name+"',CL1_NAME='"+cl1_name+"',CL2_NAME='"+cl2_name+"',PRO_PRI="+pro_pri+",PRO_VIP_PRI= "+pro_vip_pri+",PRO_INTRO='"+pro_intro+"' where PRO_ID='"+pro_idh+"'";

    }else {
      sql = "Update Product set PRO_ID='"+pro_id+"',PRO_NAME='"+pro_name+"',CL1_NAME='"+cl1_name+"',CL2_NAME='"+cl2_name+"',PRO_INTRO='"+pro_intro+"',PRO_PRI="+pro_pri+",PRO_VIP_PRI= "+pro_vip_pri +",PRO_PIC='"+pro_pic+"'where PRO_ID='"+pro_idh+"'";

    }


   int aa=   st.executeUpdate(sql);
   if (aa>0)
	  out.println("修改成功");
  }
%>