81,092
社区成员
发帖
与我相关
我的任务
分享
package supermarket;
import java.sql.*;
import java.util.*;
public class message {
private String goodsID,supplierID,gname,barCode,metricUnit,kind,birthPlace;//表的相应信息
private double unitCost;
private double checkMoneyB,checkMoneyS;//单价大于、单价小于查看(获取从表单提交的信息)
private String sql;//储存sql语句的
private boolean flag;
public message() {
}
public ArrayList<message> checkMessage()//返回查询结果的方法
{
message cm=null;
ArrayList<message> list=new ArrayList<message>();
try {
//这里控制相应的sql语句
login check=new login();//此类里面有连接数据库和查询方法
System.out.println(sql);
ResultSet rs=check.executeQuery(sql);
while (rs.next())
{
cm=new message();
cm.setGoodsID(rs.getString(1));
cm.setSupplierID(rs.getString(2));
cm.setGname(rs.getString(3));
cm.setBarCode(rs.getString(4));
cm.setMetricUnit(rs.getString(5));
cm.setKind(rs.getString(6));
cm.setBirthPlace(rs.getString(7));
cm.setUnitCost(rs.getDouble(8));
list.add(cm);
}
rs.close();
}catch (SQLException e) {
e.printStackTrace();
}
return list;
}
public String getBarCode() {
return barCode;
}
public void setBarCode(String barCode) {
this.barCode = barCode;
}
public String getBirthPlace() {
return birthPlace;
}
public void setBirthPlace(String birthPlace) {
this.birthPlace = birthPlace;
}
public String getGname() {
return gname;
}
public void setGname(String gname) {
this.gname = gname;
}
public String getGoodsID() {
return goodsID;
}
public void setGoodsID(String goodsID) {
this.goodsID = goodsID;
}
public String getKind() {
return kind;
}
public void setKind(String kind) {
this.kind = kind;
}
public String getMetricUnit() {
return metricUnit;
}
public void setMetricUnit(String metricUnit) {
this.metricUnit = metricUnit;
}
public String getSupplierID() {
return supplierID;
}
public void setSupplierID(String supplierID) {
this.supplierID = supplierID;
}
public double getUnitCost() {
return unitCost;
}
public void setUnitCost(double unitCost) {
this.unitCost = unitCost;
}
public double getCheckMoneyB() {
return checkMoneyB;
}
public void setCheckMoneyB(double checkMoneyB) {
this.checkMoneyB = checkMoneyB;
}
public double getCheckMoneyS() {
return checkMoneyS;
}
public void setCheckMoneyS(double checkMoneyS) {
this.checkMoneyS = checkMoneyS;
}
public void setFlag(boolean flag) {
this.flag = flag;
}
<%@ page language="java" contentType="text/html; charset=GBK"
pageEncoding="GBK"%>
<%request.setCharacterEncoding("gb2312"); %>
<!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=ISO-8859-1">
<title>message.jsp</title>
<%--信息管理模块主页面 --%>
</head>
<body>
<table width="634" height="441" border="0" align="center" background="bg02.jpg">
<tr>
<td width="364" height="118">
<%--根据不同条件查询商品信息 --%>
<div class="check" style=" height:100pt;">
<p><font size="+3" ><b>商品信息查询</b></font></p>
<p>
<form action="checkgoods.jsp" method="post" name="f1">
<b>查询所有商品信息:</b><input type="hidden" name="all" value="all"/><br>
<b>按商品名称查询:</b><input type="text" name="gname" /><br>
<b>按商品类别查询:</b><select name="kind">
<option value="饮品" selected="selected">饮品</option>
<option value="日用品">日用品</option>
<option value="食品">食品</option>
</select><br>
<b>按商品的单价查询:</b>
<p><b>大于<input type="text" name="checkMoneyB" />元</b><br>
<b>小于<input type="text" name="checkMoneyS" />元</b><br>
<input type="submit" name="submit" value="查询"/>
<input type="reset" name="reset" value="修改"/>
</form>
</p>
</div>
</td>
<td width="260">
<div class="add" style="height:30pt; width:100pt; margin:220pt 30pt 50pt 40pt;" >
<%--点击进入添加商品页面--%>
<a href="goods.jsp"><font size="+2" style=" color:#006600; font-weight:bolder;">添加商品</font></a><br>
<a href="supermarket.jsp"><font size="+2" style=" color:#006600; font-weight:bolder;">返回主页面</font></a>
</div>
</td>
</tr>
</table>
</body>
</html>
<%@ page language="java" contentType="text/html; charset=gb2312"
pageEncoding="gb2312"%>
<%request.setCharacterEncoding("gb2312"); %>
<%@page import="java.util.ArrayList"%>
<%@page import="supermarket.message"%>
<!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=ISO-8859-1">
<title>check.jsp</title>
<jsp:useBean id="check" scope="request" class="supermarket.message">
<jsp:setProperty name="check" property="*"/>
</jsp:useBean>
</head>
<body>
<%--处理商品查询条件的页面 --%>
<%
try
{
ArrayList list=check.checkMessage();
int length=list.size();
if(length==0)
{
%>
<script type="text/javascript">
alter("查无此商品信息!");
</script>
<% }
else
{
%>
<table width="634" border="0">
<tr>
<th>商品编号</th>
<th>供货商号;</th>
<th>名称</th>
<th>条形码</th>
<th>计量单位</th>
<th>类别</th>
<th>产地</th>
<th>单价</th>
</tr>
<%
for(int i=0;i<length;i++)
{
message m=(message)list.get(i);
%>
<tr>
<td><%=m.getGoodsID() %></td>
<td><%=m.getSupplierID() %></td>
<td><%=m.getGname()%></td>
<td><%=m.getBarCode() %></td>
<td><%=m.getMetricUnit() %></td>
<td><%=m.getKind() %></td>
<td><%=m.getBirthPlace() %></td>
<td><%=m.getUnitCost() %></td>
<td>
<a href='delgoods.jsp'?goodsID=<%=m.getGoodsID() %>>删除</a>
<a href='modify.jsp'?goodsID=<%=m.getGoodsID() %>>修改</a> </td>
<%System.out.print(m.getGoodsID()); %>
</tr>
<%
}
%>
</table>
<%
}
}catch(NullPointerException e)
{
e.printStackTrace();
}
%>
<a href="message.jsp">返回信息管理主页面</a>
<a href="stock.jsp">查看商品库存</a>
</body>
</html>
sql += "and kind like '%"+kind+"%'";
sb.toString();