WebRoot/chuku/chukuinfo.jsp

这里只显示每个文件的开头 60 行。登录后可以解锁完整代码。

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

<%@ page contentType="text/html; charset=gb2312" language="java" import="java.sql.*" errorPage="" %>
<%@ page import="com.util.*"%>
<%
request.setCharacterEncoding("gb2312");//设置页面字符集
DBO db=new DBO();//初始链接数据库类
String sql="select a.*,b.spmc from chuku a,shangpin b  where 1=1  and a.sp=b.spid";//查询 出库sql语句
String cgd=(String)request.getParameter("cgd");
String sp=(String)request.getParameter("sp");
if(sp!=null&&!sp.equals("")){
sql+=" and b.spmc like '%"+sp+"%'";
}
if(cgd!=null&&!cgd.equals("")){
sql+=" and a.cgd like '%"+cgd+"%'";
}
db.open();//打开数据库链接
ResultSet rs=db.query(sql);//查询结果
//出库信息列表
%>
<!DOCTYPE html PUBLIC "-//W3C//DTD XHTML 1.0 Transitional//EN" "http://www.w3.org/TR/xhtml1/DTD/xhtml1-transitional.dtd">
<html xmlns="http://www.w3.org/1999/xhtml">
<head>
<meta http-equiv="Content-Type" content="text/html; charset=gb2312">
<title>出库列表</title>
</head>
<link href="../images/right.css" rel="stylesheet" type="text/css"/>
<script language="javascript">
function windowHeight() {
    var de = document.documentElement;
    return self.innerHeight||(de && de.clientHeight)||document.body.clientHeight;
}
window.onload=window.onresize=function(){
var wh=windowHeight();
document.getElementById("contentWrap").style.height = document.getElementById("sidebar").style.height = (wh-document.getElementById("header").offsetHeight-document.getElementById("footer").offsetHeight)+"px";
}
</script>
<script language="javascript" src="../js/prototype.js"></script>

<body><form name="form" action="" method="post" >
<div id="sidebar" class="right">
  <div class="column"> <span>出库信息管理！</span> </div>
  <div class="content">
    <div class="ts"><b>出库信息列表：</b>商品
      <input type="text" name="sp" />
      <input type="submit" name="Submit" value="查询" />
    </div>
    <table width="100%" border="1" bordercolor="#b1c7e0" bordercolordark="#FFFFFF" cellspacing="0" cellpadding="0" class="tab01">
      <tr>
					        <td class="t" align="center" height="28" width="5%">流水</td>
					       
					        <td class="t" align="center" height="28" width="5%">商品</td>
					        <td class="t" align="center" height="28" width="20">数量</td>
							
							 <td class="t" align="center" height="28" width="20">单价</td>
							 
							  <td class="t" align="center" height="28" width="20">单位</td>
					       
						   
						   			  <td class="t" align="center" height="28" width="20">总额</td>
					       
					        <td class="t" align="center" height="28" width="5%">操作时间</td>