当前位置：文档之家› JavaWeb超市管理系统

JavaWeb超市管理系统

JavaWeb期中考试作业作业都是基于老师所讲的内容上，所实现的，比如数据的查询，数据的修改，数据的添加，作业过程如下：1、使用的学习工具：Myeclipse+MySql+ co.bin.DBUtil；2、数据库的建立：（1）创建数据库SupMarket，并在数据库中创建SpTable、Saler表，内容如下：创建数据库SupMarket;create database SupMarket;创建表SpTable;create table SpTable(Txm varchar(255),Sno varchar(255),SpName varchar(255),SpValue varchar(255),SpDno varchar(255),SpTime varchar(255),primary key(Txm),foreign key(Sno) references Saler(Sno));插入SpTable数据;insert into SpTable (Txm,Sno,SpName,Spvalue,SpDno,SpTime)values ('','201','脉动','5元','6','一年');insert into SpTable (Txm,Sno,SpName,Spvalue,SpDno,SpTime)values ('','201','纯牛奶','3元','4','六个月');insert into SpTable (Txm,Sno,SpName,Spvalue,SpDno,SpTime)values ('','203','面包','2元','3','两个月');insert into SpTable (Txm,Sno,SpName,Spvalue,SpDno,SpTime)values ('','202','毛巾','12元','8','无');insert into SpTable (Txm,Sno,SpName,Spvalue,SpDno,SpTime)values ('','202','牙膏','7.5元','5','一年');insert into SpTable (Txm,Sno,SpName,Spvalue,SpDno,SpTime)values ('','203','方便面','2.5元','9','三个月');创建表Saler;create table Saler(Sno varchar(255),Sname varchar(255),Ssex varchar(255),Smanager varchar(255),primary key(Sno));插入数据表Saler;insert into Saler(Sno,Sname,Ssex,Smanager)values ('201','张谦励','男','饮料');insert into Saler(Sno,Sname,Ssex,Smanager)values ('202','李春华','女','生活用品');insert into Saler(Sno,Sname,Ssex,Smanager)values ('203','王明明','男','零食');insert into Saler(Sno,Sname,Ssex,Smanager)values ('204','刘志强','男','清洁品');insert into Saler(Sno,Sname,Ssex,Smanager)values ('205','黄县立','男','电子产品');（2）图片显示3、开始创建jsp文件(1)创建首页index.jsp<%@ page language="java" import="java.util.*" pageEncoding="GB2312"%> <head></head><link rel="stylesheet" type="text/css" href="style/style.css"><style type="text/css"></style><body><div align="center"><ul><li><h1>欢迎来到超市管理系统</h1></li><li><a href="Goods\goodsManage_index.jsp"><div class="one"><h2>商品管理</h2></a></div></li><li><a href="Salers\salerManage_index.jsp"><div class="two"><h2>店员管理</h2></a></li></ul></div></body></html>(2)创建副业商品管理首页goodsManage_index.jsp<%@ page language="java" import="java.util.*" pageEncoding="GB2312"%><%@ page import="java.sql.*"%><html><head><title>商品管理首页</title></head><link rel="stylesheet" type="text/css" href="style/Reset.css"><jsp:useBean id="dbutil" class="co.bin.DBUtil" scope="page"></jsp:useBean> <body><%String sql = "select * from SpTable";ResultSet rs = dbutil.executeQuery(sql);%><table id="SpTable" border="1" bgcolor="white" align="center"><tr><th>条形码</th><th>主管工号</th><th>商品名称</th><th>商品价格</th><th>进货单号</th><th>保质时间</th><th>编辑</th></tr><%while (rs.next()) {%><tr><th><%=rs.getString("Txm")%></th><th><%=rs.getString("Sno")%></th><th><%=rs.getString("SpName")%></th><th><%=rs.getString("SpValue")%></th><th><%=rs.getString("SpDno")%></th><th><%=rs.getString("SpTime")%></th><th><ahref="goodsManage_edit.jsp?SpTableTxm=<%=rs.getString("Txm")%>">修改</a> <a href="goodsManage_del.jsp?SpTableTxm=<%=rs.getString("Txm")%>">删除</a></th></tr><%}rs.close();%></table><table align="center"><th><a href="goodsManage_add.jsp">添加商品</a></th></table></body></html>(3)创建副业店员管理首页salerManage_index.jsp<%@ page language="java" import="java.util.*"%><%@ page import="java.sql.*" pageEncoding="GB2312"%><html><head><title>学生管理</title></head><jsp:useBean id="dbutil" class="co.bin.DBUtil" scope="page"></jsp:useBean><body><%String sql = "select * from Saler";ResultSet rs = dbutil.executeQuery(sql);%><table id="student" border="1" bgcolor="white" align="center"><tr><th>店员工号</th><th>店员姓名</th><th>店员性别</th><th>店员主管</th><th>编辑</th></tr><br><%while (rs.next()) {%><tr><th><%=rs.getInt("Sno")%></th><th><%=rs.getString("Sname")%></th><th><%=rs.getString("Ssex")%></th><th><%=rs.getString("Smanager")%></th><th><a href="salerManage_del.jsp?SalerSno=<%=rs.getString("Sno")%>">删除</a></th></tr><%}dbutil.close();%></table><table align="center"><a href="salerManage_add.jsp">添加店员</a></table></body></html>(4)创建商品管理添加页面goodsManage_add.jsp,goodsManage_add_action.jsp <%@ page language="java" import="java.util.*" pageEncoding="GB2312"%><%@ page import="java.sql.*"%><jsp:useBean id="dbutil" class="co.bin.DBUtil" scope="page"></jsp:useBean><html><head><title>添加商品</title></head><body><div align="center"><h3>添加商品</h3><form action="goodsManage_add_action.jsp" method="post" id="addform"><label >条形码</label><input type="text" name="Txm" maxlength="27" /><br /><label >主管工号</label><select id="" name="Sno"><option value="0">请选择主管工号</option><%String sql = "select * from Saler";ResultSet rs = dbutil.executeQuery(sql);while (rs.next()) {%><option value=<%=rs.getInt("Sno")%>><%=rs.getInt("Sno")%></option><%}rs.close();%></select><br /><label>商品名称</label><input type="text" id="SpName" name="SpName" maxlength="25" /><br /><label>商品价格</label><input type="text" id="SpValue" name="SpValue" maxlength="25" /><br /><label>进货单号</label><input type="text" id="" name="SpDno" maxlength="25" /><br /><label>保质期</label><input type="text" id="Txm" name="SpTime" maxlength="25" /><br /><br><input type="submit" value="提交" /></form></div></body></html>创建goodsManage_add_action.jsp<%@ page language="java" import="java.util.*" pageEncoding="GB2312"%><%@ page import="java.sql.*"%><jsp:useBean id="dbutil" class="co.bin.DBUtil"></jsp:useBean><%request.setCharacterEncoding("GB2312");String strTxm, strSno, strSpName, strSpValue, strSpDno, strSpTime;strTxm = request.getParameter("Txm");strSno = request.getParameter("Sno");strSpName = request.getParameter("SpName");strSpValue = request.getParameter("SpValue");strSpDno = request.getParameter("SpDno");strSpTime = request.getParameter("SpTime");String sql = "insert into SpTable(Txm,Sno,SpName,SpValue,SpDno,SpTime)values ('"+ strTxm+ "','"+ strSno+ "','"+ strSpName+ "','"+ strSpValue + "','" + strSpDno + "','" + strSpTime + "')";out.print(sql);int ret = dbutil.executeUpdate(sql);if (ret > 0)response.sendRedirect("goodsManage_index.jsp");elseout.println("增加商品失败");%>(5)创建商品管理删除页面goodsManage_del.jsp<%@ page language="java" import="java.util.*"%><%@ page import="java.sql.*" pageEncoding="GB2312"%><jsp:useBean id="dbutil" class="co.bin.DBUtil"></jsp:useBean><%String strTxm = request.getParameter("SpTableTxm");String sql ="delete from SpTable where Txm='"+strTxm+"'";int ret = dbutil.executeUpdate(sql);if(ret>0)response.sendRedirect("goodsManage_index.jsp");elseout.println("删除商品失败");%>(6)创建店员管理添加页面salerManage_add.jsp,salerManage_add_action.jsp <%@ page language="java" import="java.util.*" pageEncoding="GB2312"%><%@ page import="java.sql.*"%><!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.01 Transitional//EN"><jsp:useBean id="dbutil" class="co.bin.DBUtil" scope="page"></jsp:useBean><html><head><title>添加商品</title></head><body><div align="center"><h3>添加店员</h3><form action="salerManage_add_action.jsp" method="post" id="addform"><label >店员工号</label><input type="text" name="Sno" maxlength="25" /><br /><label >店员姓名</label><input type="text" id="" name="Sname" maxlength="25" /><br /><label>店员性别</label><input type="text" id="" name="Ssex" maxlength="25" /><br /><label>店员主管</label><input type="text" name="Smanager" maxlength="25" /><br><input type="submit" value="提交" /><input type="reset" value="重置" />"</form></div></body></html>创建salerManage_add_action.jsp<%@ page language="java" import="java.util.*" pageEncoding="GB2312"%> <%@ page import="java.sql.*"%><jsp:useBean id="dbutil" class="co.bin.DBUtil"></jsp:useBean><%request.setCharacterEncoding("GB2312");String strSno, strSname, strSsex, strSmanager;strSno = request.getParameter("Sno");strSname = request.getParameter("Sname");strSsex = request.getParameter("Ssex");strSmanager = request.getParameter("Smanager");String sql = "insert into Saler(Sno,Sname,Ssex,Smanager)values ('"+ strSno + "','" + strSname + "','" + strSsex + "','"+ strSmanager + "')";out.print(sql);int ret = dbutil.executeUpdate(sql);if (ret > 0)response.sendRedirect("salerManage_index.jsp");elseout.println("增加店员失败");%>(7)创建店员管理删除页面salerManage_del.jsp<%@ page language="java" import="java.util.*"%><%@ page import="java.sql.*" pageEncoding="GB2312"%><jsp:useBean id="dbutil" class="co.bin.DBUtil"></jsp:useBean><%String strSno = request.getParameter("SalerSno");String sql ="delete from Saler where Sno='"+strSno+"'";int ret = dbutil.executeUpdate(sql);if(ret>0)response.sendRedirect("salerManage_index.jsp");elseout.println("删除店员失败");%>。

e商务文档

JavaWeb超市管理系统

相关文档推荐：