JavaWeb期中.docx
《JavaWeb期中.docx》由会员分享,可在线阅读,更多相关《JavaWeb期中.docx(36页珍藏版)》请在冰豆网上搜索。
![JavaWeb期中.docx](https://file1.bdocx.com/fileroot1/2023-1/6/f30b3ddc-1182-4b33-b991-71b0464aebef/f30b3ddc-1182-4b33-b991-71b0464aebef1.gif)
JavaWeb期中
Web期中作业
——超市管理系统
姓名:
刘先亮
学号:
21114160106
班级:
信1131
一、期中题目
根据JavaWeb课上的实例,运用所学的Web开发技术设计完成一个超市管理系统。
二、功能要求
实现超市货物的增\删\改\查\展示功能,实现简易的构建和界面设计。
基于xampp中的MySQL数据库,以MyEclipse软件为开发工具。
1.数据库的建立
(1).代码如下:
CREATETABLEMerchInfo(
MerchIDint,
MerchNamevarchar(50),
importPriceint,
warehousepriceint,
categoriesvarchar(50),
MerchNumint,
porfferNamevarchar(50),
primarykey(MerchID),
);
(2).数据的插入
insertintoMerchInfo(MerchID,MerchName,importPrice,warehouseprice,categories,MerchNum,porfferName)values
("112031","牛奶","3","3.5","饮料","120","蒙牛");
insert
intoMerchInfo(MerchID,MerchName,importPrice,warehouseprice,categories,MerchNum,porfferName)values
("112032","酸酸乳","2.5","3.5","饮料","110","伊利");
insertintoMerchInfo(MerchID,MerchName,importPrice,warehouseprice,categories,MerchNum,porfferName)values
("112052","方便面","2","4","生活类","123","康师傅");
insertintoMerchInfo(MerchID,MerchName,importPrice,warehouseprice,categories,MerchNum,porfferName)values
("112055","面包","7","12","甜品","123","盼盼");
效果图:
2.搭建数据库连接环境,在工作项目下的src文件夹中,创建包名为cn.edu.jiu.db的包,在包内新建DBUtil.Java文件
代码如下:
packagecn.edu.jiu.db;
importjava.sql.*;
importjava.util.*;
publicclassDBUtil{
privateConnectionconn;
privateStatementstmt;
privateResultSetrs;
publicbooleangetConnection(){
booleanret=false;
try{
Class.forName("com.mysql.jdbc.Driver");
Stringurl="jdbc:
mysql:
//127.0.0.1:
3306/supermarket?
"
+"&useUnicode=true&characterEncoding=gb2312";
Stringuser="root";
Stringpassword="";
conn=DriverManager.getConnection(url,user,password);
}catch(Exceptione){
e.printStackTrace();
}
returnret;
}
publicintexecuteUpdate(Stringsql){
intret=0;
try{
getConnection();
stmt=conn.createStatement();
ret=stmt.executeUpdate(sql);
close();
}catch(Exceptione){
e.printStackTrace();
}
returnret;
}
publicResultSetexecuteQuery(Stringsql){
try{
getConnection();
stmt=conn.createStatement();
rs=stmt.executeQuery(sql);
}catch(Exceptione){
e.printStackTrace();
}
returnrs;
}
publicvoidclose(){
try{
if(rs!
=null)
rs.close();
if(stmt!
=null)
stmt.close();
if(conn!
=null&&!
conn.isClosed())
conn.close();
}catch(Exceptione){
e.printStackTrace();
}
}
publicstaticvoidmain(String[]args){
}
}
2.首页界面index1.jsp
代码如下:
<%@pagelanguage="java"import="java.util.*"pageEncoding="gb2312"%>
DOCTYPEHTMLPUBLIC"-//W3C//DTDHTML4.01Transitional//EN">
超市管理系统
body{
background-image:
url(8.jpg);
background-repeat:
no-repeat;
}
超市
16">物品总览
16">入库管理
16">出库管理
16">新增物品
16">删除物品
16">物品修改
16">货物查询
2.入库代码ruku.jsp
<%@pagelanguage="java"import="java.util.*"pageEncoding="gbk"%>
<%@pageimport="java.sql.*"%>
body{
background-image:
url(5.jpg);
}
useBeanid="dbutil"class="cn.edu.jiu.db.DBUtil"scope="page">
useBean>
<%
Stringsql="select*frommerchinfo";
ResultSetrs=dbutil.executeQuery(sql);
%>
物品入库
(通过物品编号进行添加)
商品编号 | 入库价格 | 出库价格 | 商品名称 | 库存量 | 商品类别 | 供应商 |
---|
<%
while(rs.next()){
%>
<%=rs.getInt("MerchID")%> | <%=rs.getInt("importPrice")%> | <%=rs.getInt("warehouseprice")%> | <%=rs.getString("MerchName")%> | <%=rs.getInt("MerchNum")%> | <%=rs.getString("categories")%> | <%=rs.getString("porfferName")%> | |
<%
}
dbutil.close();
%>
物品编号:
|
新增量: |
|
|
2.ruku2.jsp
<%@pagelanguage="java"import="java.util.*"pageEncoding="gbk"%>
<%@pageimport="java.sql.*"%>
DOCTYPEHTMLPUBLIC"-//W3C//DTDHTML4.01Transitional//EN">
useBeanid="dbutil"class="cn.edu.jiu.db.DBUtil"scope="page">
useBean>
<%
request.setCharacterEncoding("GB2312");
StringMerchID=request.getParameter("idproduct");
StringMerchNum=request.getParameter("add_amount");
Stringsql="select*frommerchinfowhereMerchID='"+MerchID
+"'";
ResultSetrs=dbutil.executeQuery(sql);
if(rs.next()){
inti=rs.getInt("MerchNum");
inta=Integer.valueOf(MerchNum);
intk=i+a;
out.print(k);
Stringsql1;
sql1="updateMerchinfosetMerchNum='"+k
+"'whereMerchID='"+MerchID+"'";
intrst=dbutil.executeUpdate(sql1);
out.print(rst);
if(rst>0)
response.sendRedirect("product.jsp");
else
out.print("失败");
}else
out.print("失败");
dbutil.close();
%>
3.出库代码chuku.jsp
<%@pagelanguage="java"import="java.util.*"pageEncoding="gbk"%>
<%@pageimport="java.sql.*"%>
body{
background-image:
url(1.jpg);
}
useBeanid="dbutil"class="cn.edu.jiu.db.DBUtil"scope="page">
useBean>
<%
Stringsql="select*frommerchinfo";
ResultSetrs=dbutil.executeQuery(sql);
%>
物品入库
(通过物品编号进行添加)
商品编号 | 入库价格 | 出库价格 | 商品名称 | 库存量 | 商品类别 | 供应商 |
---|
<%
while(rs.next()){
%>
<%=rs.getInt("MerchID")%> | <%=rs.getInt("importPrice")%> | <%=rs.getInt("warehouseprice")%> | <%=rs.getString("MerchName")%> | <%=rs.getInt("MerchNum")%> | <%=rs.getString("categories")%> | <%=rs.getString("porfferName")%> | |
<%
}
dbutil.close();
%>
物品编号:
|
销售量: |
|
|
4.chuku2.jsp
<%@pagelanguage="java"import="java.util.*"pageEncoding="gbk"%>
<%@pageimport="java.sql.*"%>
DOCTYPEHTMLPUBLIC"-//W3C//DTDHTML4.01Transitional//EN">
useBeanid="dbutil"class="cn.edu.jiu.db.DBUtil"scope="page">
useBean>
<%
request.setCharacterEncoding("GB2312");
StringMerchID=request.getParameter("idproduct");
StringMerchNum=request.getParameter("add_amount");
Stringsql="select*frommerchinfowhereMerchID='"+MerchID
+"'";
ResultSetrs=dbutil.executeQuery(sql);
if(rs.next()){
inti=rs.getInt("MerchNum");
inta=Integer.valueOf(MerchNum);
intk=i-a;
Stringsql1;
sql1="updateMerchinfosetMerchNum='"+k
+"'whereMerchID='"+MerchID+"'";
intrst=dbutil.executeUpdate(sql1);
if(rst>0)
response.sendRedirect("product.jsp");
else
out.print("失败");
}else
out.print("失败");
dbutil.close();
%>
5增加物品.add.jsp
<%@pagecontentType="text/html;charset=gbk"%>
--
body{