add_pro2.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.*" %>
<%@ page import="java.io.*" %>
<%
if (session.getAttribute("name") == null) {
    response.sendRedirect("index.jsp");
  }else {
String sql=null;

 Connection con;
    Statement st;
    con = DBConn.GetConn();
    st = con.createStatement();

String proid=request.getParameter("PRO_ID");
sql="select * from Product where PRO_ID='"+proid+"'";
  ResultSet rs=   st.executeQuery(sql);
        if (rs.next()){
           response.sendRedirect("chkerre1.jsp");
           return;
        }

String path=request.getRealPath("/");

path=path+"\\wshop\\admin\\propic\\";

fileBean.setObjectPath(path);

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");

  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");
  Long pro_pri=new Long(fileBean.getFieldValue("PRO_PRI"));

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


  String pro_pic=saObjectFile[0];

  
      sql = "Insert into Product(PRO_ID,PRO_NAME,CL1_NAME,CL2_NAME,PRO_INTRO,PRO_PRI,PRO_VIP_PRI,PRO_PIC) values('" +pro_id + "','" +pro_name + "','" +cl1_name + "','"+ cl2_name+"','" +pro_intro + "','"+ pro_pri+"','"+ pro_vip_pri+"','"+ pro_pic+"')";
     
      st.executeUpdate(sql);
	  response.sendRedirect("add_pro.jsp");
  }
%>