📄 prestockadd_do.jsp

📁 一个超市管理系统,提供一些基本简单的操作,JSP+APACHE+ORCALE实现

💻 JSP

字号:

<script language="JavaScript">
<!--
function CheckForm(str)
{
   alert(str);
   return false;
}
// -->
</script>
 <%@ page language="java" contentType="text/html; charset=gb2312"
    pageEncoding="gb2312"%>
<%@ page import="java.sql.*" %>
<!DOCTYPE html PUBLIC "-//W3C//DTD HTML 4.01 Transitional//EN" "http://www.w3.org/TR/html4/loose.dtd">
<html>
<head>
<meta http-equiv="Content-Type" content="text/html; charset=gb2312">
<title>预进货信息数据处理</title>
</head>
<body>
<jsp:useBean id="Dbcon" scope="page" class="bb.Dbcon" />
<jsp:useBean id="login" scope="session" class="bb.login" />
<%if(login.dept!=1&&login.dept!=5)
  {
%>
<jsp:forward page="index.jsp"/>
<% 
  }
%>
<%try{
  ResultSet rs=null;

  int pro_id=Integer.parseInt(request.getParameter("pro_id"));
  int quantity=Integer.parseInt(request.getParameter("quantity"));
  String pro_name=Dbcon.getStr(request.getParameter("pro_name"));
  String type=Dbcon.getStr(request.getParameter("type"));
  int pro_mer=Integer.parseInt(request.getParameter("pro_mer"));
  String sql=null;
  
  Connection con=Dbcon.getConn();
  Statement stmt=con.createStatement();
  Statement stmt1=con.createStatement();
  String sql1="select * from tpb.pre_info where pro_id="+pro_id;
  rs=stmt1.executeQuery(sql1);
  if(rs.next())
  {	
	sql="update tpb.pre_info set quantity=quantity+"+quantity+" where pro_id='"+request.getParameter("pro_id")+"'";  
  }
  else
  {	  
    if(request.getParameter("sto_price")=="")
    {
      sql="insert into tpb.pre_info values ("+pro_id+",'"+pro_name+"','"+type+"',null,"+quantity+","+pro_mer+")";
    }
    else
    { 
	  float sto_price=Float.parseFloat(request.getParameter("sto_price"));
	  sql="insert into tpb.pre_info values ("+pro_id+",'"+pro_name+"','"+type+"',"+sto_price+","+quantity+","+pro_mer+")";
    }
  }
  rs.close();
  stmt.executeQuery(sql);
  stmt.close();
  Dbcon.Close();
  }catch(SQLException e ){
%>
<script language="JavaScript">
  CheckForm("填加的供应商不存在!");
  document.location.href="preStockAdd.jsp"
</script>
<%
  }catch(Exception e){
%>
<script language="JavaScript">
  CheckForm("出错了！！！");
  document.location.href="stock.jsp"
</script>
<%
                     }    
%>
<h1 align="center">添加预进货信息成功</h1>
<a href="preStockAdd.jsp">返回</a>
</body>
</html>

⌨️ 快捷键说明

复制代码 Ctrl + C

搜索代码 Ctrl + F

全屏模式 F11

切换主题 Ctrl + Shift + D

显示快捷键 ?

增大字号 Ctrl + =

减小字号 Ctrl + -