WebRoot/kucun/kucundo.jsp

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

<%@ page contentType="text/html; charset=gb2312" language="java" import="java.sql.*" errorPage="" %>
<%@ page import="com.util.*"%>

<%
/*
库存添加后台
*/
DBO db=new DBO();
request.setCharacterEncoding("gb2312");
ResultSet rs=null;
	String keyid =(String)request.getParameter("keyid");
String ck=(String)request.getParameter("ck");
String sp=(String)request.getParameter("sp");
String sl=(String)request.getParameter("sl");
String czr=(String)request.getParameter("czr");
String sj=(String)request.getParameter("sj");

String sql="";
 sql="insert into kucun(ck,sp,sl,czr,sj) values('"+ck+"','"+sp+"','"+sl+"','"+czr+"','"+sj+"')";
;//库存SQL 语句
int row=1;
String sq="select * from kucun where ck='"+ck+"' and sp='"+sp+"' ";
try{
rs=db.query(sq);
if(rs.next()){
out.println("<script>");
out.println("alert('操作失败，同一个仓库下只能有一种商品类型，调整数量，用修改操作');");
out.println("window.location='kucunadd.jsp'");
out.println("</script>");
return;
}
	
		//int row =0;
		row=db.update(sql);
}catch(Exception e){
System.out.println(e.toString());}
if(row==1){
out.println("<script>");
out.println("alert('操作成功');");
out.println("window.location='kucunadd.jsp'");
out.println("</script>");
}else{
out.println("<script>");
out.println("alert('操作失败');");
out.println("window.location='kucunadd.jsp'");
out.println("</script>");
}
db.close();
%>