addcl1.jsp

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

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

  if (session.getAttribute("name") == null) {
    response.sendRedirect("index.jsp");
  }
  else {
  request.setCharacterEncoding("GB2312");
    String sql=null;
    Connection con;
    Statement st;
    String options = request.getParameter("options");
    int op = 0;
    if (options.equals("rename"))
      op = 1;
	    System.out.println(options);
    if (options.equals("del"))
      op = 2;
	      System.out.println(op);
    if (options.equals("new"))
      op = 3;
	      System.out.println(op);
    con = DBConn.GetConn();
    st = con.createStatement();
     
     
	  request.setCharacterEncoding("GB2312");
  String subject = request.getParameter("subject");

    switch (op) {
    case 1:
    
      sql = "update Class1 set CL1_NAME='" +request.getParameter("reTitle") + "' where CL1_NAME='" + subject + "'";
         
      st.executeUpdate(sql);
       
      sql = "update Class2 set CL1_NAME='" + request.getParameter("reTitle") + "' where CL1_NAME='" + subject + "'";
      st.executeUpdate(sql);
      

      sql = "update Product set CL1_NAME='" + request.getParameter("reTitle")+ "' where CL1_NAME='" + subject + "'";
      st.executeUpdate(sql);
       
      break;
    case 2:
    

      sql = "delete from Class1 where CL1_NAME='" + subject + "'";

      
       st.executeUpdate(sql);
       
      sql = "delete from Class2 where CL1_NAME='" + subject + "'";

       
       st.executeUpdate(sql);
          
      sql = "delete from Product where CL1_NAME='" + subject + "'";
	     
      st.executeUpdate(sql);
       

      break;
    case 3:
    String cl1=request.getParameter("newTitle");

      sql="select * from Class1 where CL1_NAME='"+cl1+"'";
        ResultSet rs=   st.executeQuery(sql);
        if (rs.next()){
       
        
           response.sendRedirect("chkerre1.jsp");
           return;
        }
      sql = "Insert into Class1(CL1_NAME) values('" + cl1 + "')";
	   
      st.executeUpdate(sql);
     
      break;
    }
    
    con.close();
    st.close();
	response.sendRedirect("add_class_1.jsp");
  }
%>