jspckwlglxns/WebRoot/rukujilu_add_post.jsp

微信扫码关注公众号，代码整理好后第一时间通知你。

<%@ page language="java"  pageEncoding="gb2312" import="java.sql.*" %>
<%
String path = request.getContextPath();
String basePath = request.getScheme()+"://"+request.getServerName()+":"+request.getServerPort()+path+"/";
%>
<%
request.setCharacterEncoding("gb2312"); 
response.setCharacterEncoding("gb2312"); 
%>
<jsp:useBean id="connDbBean" scope="page" class="db.db"/>
<!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.01 Transitional//EN">
<html>
  <head>
    <base href="<%=basePath%>">
    
    <title>My JSP 'adminyanzheng.jsp' starting page</title>
    

  </head>
  
  <body>
  <%
 

String bianhao=request.getParameter("bianhao");String mingcheng=request.getParameter("mingcheng");String kucun=request.getParameter("kucun");String rukushuliang=request.getParameter("rukushuliang");String gongyingshang=request.getParameter("gongyingshang");String beizhu=request.getParameter("beizhu");String caozuoyuan=request.getParameter("caozuoyuan");
//ResultSet RS_result=connDbBean.executeQuery("select * from [fdsfds] where fdsfssd='"+fdsfd+"'");

// if(RS_result.next())
//{
//out.print("<script>alert('该班级已经存在,请换其他名称的班级!');window.history.go(-1);</script>");
//	}
//else{

	
  	  	String sql="insert into rukujilu(bianhao,mingcheng,kucun,rukushuliang,gongyingshang,beizhu,caozuoyuan) values('"+bianhao+"','"+mingcheng+"','"+kucun+"','"+rukushuliang+"','"+gongyingshang+"','"+beizhu+"','"+caozuoyuan+"') ";
  	  	
  	  	connDbBean.executeUpdate(sql);
		sql="update shangpinxinxi set kucun=kucun+"+rukushuliang+" where bianhao='"+bianhao+"'";
		connDbBean.executeUpdate(sql);
  	  	out.print("<script>alert('添加成功!!');location.href='rukujilu_add.jsp';</script>");
  	  
//	}
//RS_result.close();

 %>
  </body>
</html>