JSP实现超市管理系统

一.模块设计

系统整体分为登录模块,商品信息管理模块,库存管理模块,订单管理模块,事件管理模块和人员信息管理模块。

二.开发环境

Java:JDK13
服务器:Tomcat9.0
数据库:MySQL
数据库管理工具:Navicat
开发工具:Eclipse

三.运行截图

在这里插入图片描述
在这里插入图片描述
在这里插入图片描述
在这里插入图片描述
在这里插入图片描述

四.项目代码示例

员工实体类

package com.ischoolbar.programmer.model;

/*
 * 
 * 员工实体类
 */

public class yg {

	private String id;
	private String name;
	private String sex;
	private String age;
	private String tele;
	private String iden;//身份
	private String perm;//权限
	private String password;//密码
	public String getId() {
		return id;
	}
	public void setId(String id) {
		this.id = id;
	}
	public String getName() {
		return name;
	}
	public void setName(String name) {
		this.name = name;
	}
	public String getAge() {
		return age;
	}
	public void setAge(String age) {
		this.age = age;
	}
	public String getTele() {
		return tele;
	}
	public void setTele(String tele) {
		this.tele = tele;
	}
	public String getSex() {
		return sex;
	}
	public void setSex(String sex) {
		this.sex = sex;
	}
	public String getIden() {
		return iden;
	}
	public void setIden(String iden) {
		this.iden = iden;
	}
	public String getPerm() {
		return perm;
	}
	public void setPerm(String perm) {
		this.perm = perm;
	}
	public String getPassword() {
		return password;
	}
	public void setPassword(String password) {
		this.password = password;
	}
}

员工数据库操作

package com.ischoolbar.programmer.dao;

import java.sql.PreparedStatement;

import java.sql.ResultSet;
import java.sql.SQLException;
import java.util.ArrayList;
import java.util.List;
import com.ischoolbar.programmer.model.yg;
import com.ischoolbar.programmer.model.Page;
import com.ischoolbar.programmer.util.StringUtil;

/**
 * 
 * 
 *员工类的数据库操作封装:继承BaseDao
 */
public class ygdao extends BaseDao {
	
	public yg getStudent(int id){
		String sql = "select * from yg where id = " + id;
		yg student = null;
		ResultSet resultSet = query(sql);
		try {
			if(resultSet.next()){
				student = new yg();
				student.setId(resultSet.getString("id"));
				student.setName(resultSet.getString("name"));
				student.setSex(resultSet.getString("sex"));
				student.setAge(resultSet.getString("age"));
				student.setPassword(resultSet.getString("password"));

				student.setTele(resultSet.getString("tele"));
				student.setIden(resultSet.getString("iden"));
				student.setPerm(resultSet.getString("perm"));
				return student;
			}
		} catch (SQLException e) {
			// TODO Auto-generated catch block
			e.printStackTrace();
		}
		return student;
	}
	
	public List<yg> getClazzList(yg clazz,Page page){
		//获得员工列表(包括个人与所有)
		List<yg> ret = new ArrayList<yg>();
		String sql = "select * from yg ";
		if(!StringUtil.isEmpty(clazz.getName())){
			sql += "where name like '%" + clazz.getName() + "%'";
		}
		
		if(!StringUtil.isEmpty(clazz.getId())){
			sql += " and id = " + clazz.getId();
		}
		
		sql += " limit " + page.getStart() + "," + page.getPageSize();
		ResultSet resultSet = query(sql.replaceFirst("and", "where"));
		try {
			while(resultSet.next()){
				yg cl = new yg();
				cl.setId(resultSet.getString("id"));
				cl.setName(resultSet.getString("name"));
				cl.setAge(resultSet.getString("age"));
				cl.setSex(resultSet.getString("sex"));
				cl.setTele(resultSet.getString("tele"));
				cl.setIden(resultSet.getString("iden"));
				cl.setPerm(resultSet.getString("perm"));
				cl.setPassword(resultSet.getString("password"));				
				ret.add(cl);
			}
		} catch (SQLException e) {
			e.printStackTrace();
		}
		return ret;
	}
	public int getClazzListTotal(yg clazz){
		//获得全部员工列表
		int total = 0;
		String sql = "select count(*)as total from yg ";
		if(!StringUtil.isEmpty(clazz.getName())){
			sql += "where name like '%" + clazz.getName() + "%'";
		}
		
		if(!StringUtil.isEmpty(clazz.getId())){
			sql += " and id = " + clazz.getId();
		}
		ResultSet resultSet = query(sql.replaceFirst("and", "where"));
		try {
			while(resultSet.next()){
				total = resultSet.getInt("total");
			}
		} catch (SQLException e) {
			// TODO Auto-generated catch block
			e.printStackTrace();
		}
		return total;
	}
	public boolean addClazz(yg clazz){
		//向员工信息表添加人员信息
		String sql = "insert into yg values('"+clazz.getId()+"','"+clazz.getName()+"'";
		sql += ",'"+clazz.getAge()+"','"+clazz.getSex()+"'";
		sql += ",'"+clazz.getTele()+"','"+clazz.getIden()+"'";
		sql += ",'"+clazz.getPerm()+"','"+clazz.getPassword()+ "')";
		
		return update(sql);
	}
	public boolean deleteClazz(int id){
		//删除人员信息
		String sql = "delete from yg where id = "+id;
		return update(sql);
	}
	public boolean editClazz(yg clazz) {
		// TODO Auto-generated method stub
		//编辑修改人员信息
		String sql = "update yg set name = '"+clazz.getName()+"'";
		sql += ",age = '" + clazz.getAge() + "'";
		sql += ",sex = '" + clazz.getSex() + "'";		
		sql += ",tele = '" + clazz.getTele() + "'";
		sql += ",iden = '" + clazz.getIden()+ "'";
		sql += ",perm = '" + clazz.getPerm() + "'";
		sql += ",password = '" + clazz.getPassword() + "'";
		sql += " where id = " + clazz.getId();		
		return update(sql);
	}
	
	public boolean editself(yg clazz) {
		// TODO Auto-generated method stub
		//编辑修改人员信息
		String sql = "update yg set name = '"+clazz.getName()+"'";
		sql += ",age = '" + clazz.getAge() + "'";
		sql += ",sex = '" + clazz.getSex() + "'";		
		sql += ",tele = '" + clazz.getTele() + "'";		
		sql += " where id = " + clazz.getId();		
		return update(sql);
	}
	
	public yg login(String id ,String password){
		//员工登录函数
		String sql = "select * from yg where id = '" + id + "' and password = '" + password + "'";
		ResultSet resultSet = query(sql);
		try {
			if(resultSet.next()){
				yg student = new yg();
				student.setId(resultSet.getString("id"));
				student.setName(resultSet.getString("name"));
				student.setTele(resultSet.getString("tele"));
				student.setPassword(resultSet.getString("password"));
				student.setAge(resultSet.getString("age"));
				student.setIden(resultSet.getString("iden"));
				student.setPerm(resultSet.getString("perm"));
				student.setSex(resultSet.getString("sex"));
				return student;
			}
		} catch (SQLException e) {
			// TODO Auto-generated catch block
			e.printStackTrace();
		}
		return null;
	}
	public boolean editPassword(yg student,String newPassword) {
		//修改密码函数
		// TODO Auto-generated method stub
		String sql = "update yg set password = '"+newPassword+"' where id = " + student.getId();
		return update(sql);
	}
	
}

员工servlet

package com.ischoolbar.programmer.servlet;

/**
 * 
 *员工信息servlet,对员工信息的增删改操作连接数据库进行相应操作
 */
import java.io.IOException;


import java.util.HashMap;
import java.util.List;
import java.util.Map;

import javax.servlet.ServletException;
import javax.servlet.http.HttpServlet;
import javax.servlet.http.HttpServletRequest;
import javax.servlet.http.HttpServletResponse;

import net.sf.json.JSONArray;
import net.sf.json.JSONObject;
import net.sf.json.JsonConfig;

import com.ischoolbar.programmer.dao.ygdao;
import com.ischoolbar.programmer.model.yg;
import com.ischoolbar.programmer.model.Page;

public class ygServlet extends javax.servlet.http.HttpServlet {
	public void doGet(HttpServletRequest request,HttpServletResponse response) throws IOException{
		doPost(request, response);
	}
	public void doPost(HttpServletRequest request,HttpServletResponse response) throws IOException{
		String method = request.getParameter("method");
		if("toyglistView".equals(method)){
			clazzList(request,response);
		}else if("getClazzList".equals(method)){
			getClazzList(request, response);
		}else if("AddClazz".equals(method)){
			addClazz(request, response);
		}else if("DeleteClazz".equals(method)){
			deleteClazz(request, response);
		}else if("EditClazz".equals(method)){
			editClazz(request, response);
		}
	}
	private void editClazz(HttpServletRequest request,
			HttpServletResponse response) {
		//修改员工信息动作
		int userType = Integer.parseInt(request.getSession().getAttribute("userType").toString());			
		if(userType == 1){
		String id = request.getParameter("id"); 
		String name = request.getParameter("name"); 
		String age = request.getParameter("age"); 
		String sex = request.getParameter("sex"); 
		String tele = request.getParameter("tele"); 
		String iden = request.getParameter("iden"); 
		String perm = request.getParameter("perm"); 
		String password = request.getParameter("password"); 		
		yg clazz = new yg();
		clazz.setName(name);
		clazz.setId(id);
		clazz.setAge(age);
		clazz.setSex(sex);
		clazz.setTele(tele);
		clazz.setIden(iden);
		clazz.setPerm(perm);
		clazz.setPassword(password);		
		ygdao clazzDao = new ygdao();
		if(clazzDao.editClazz(clazz)){
			try {
				response.getWriter().write("success");
			} catch (IOException e) {
				// TODO Auto-generated catch block
				e.printStackTrace();
			}finally{
				clazzDao.closeCon();
			}
		}
		}
		if(userType == 2){
			String name = request.getParameter("name"); 
			String id = request.getParameter("id"); 
			String age = request.getParameter("age"); 
			String sex = request.getParameter("sex"); 
			String tele = request.getParameter("tele"); 

			yg clazz = new yg();				
			clazz.setName(name);
			clazz.setId(id);
			clazz.setAge(age);
			clazz.setSex(sex);
			clazz.setTele(tele);
					
			ygdao clazzDao = new ygdao();
			if(clazzDao.editself(clazz)){
				try {
					response.getWriter().write("success");
				} catch (IOException e) {
					// TODO Auto-generated catch block
					e.printStackTrace();
				}finally{
					clazzDao.closeCon();
				}
			}
			}
		
	}
	private void deleteClazz(HttpServletRequest request,
			HttpServletResponse response) {
		// 删除员工信息操作
		Integer id = Integer.parseInt(request.getParameter("clazzid"));
		ygdao clazzDao = new ygdao();
		if(clazzDao.deleteClazz(id)){
			try {
				response.getWriter().write("success");
			} catch (IOException e) {
				e.printStackTrace();
			}finally{
				clazzDao.closeCon();
			}
		}
	}
	private void addClazz(HttpServletRequest request,
			HttpServletResponse response) {
		//增加员工信息操作

		String name = request.getParameter("name"); 
		String id = request.getParameter("id"); 
		String age = request.getParameter("age"); 
		String sex = request.getParameter("sex"); 
		String tele = request.getParameter("tele"); 
		String iden = request.getParameter("iden"); 
		String perm = request.getParameter("perm"); 
		String password = request.getParameter("password"); 
		yg clazz = new yg();
			
		clazz.setName(name);
		clazz.setId(id);
		clazz.setAge(age);
		clazz.setSex(sex);
		clazz.setTele(tele);
		clazz.setIden(iden);
		clazz.setPerm(perm);
		clazz.setPassword(password);	
		
		ygdao clazzDao = new ygdao();
		if(clazzDao.addClazz(clazz)){
			try {
				response.getWriter().write("success");
			} catch (IOException e) {
				// TODO Auto-generated catch block
				e.printStackTrace();
			}finally{
				clazzDao.closeCon();
			}
		}
				
		
	}
	private void clazzList(HttpServletRequest request,
			HttpServletResponse response) {
		//连接员工列表
		try {
			request.getRequestDispatcher("view/yglist.jsp").forward(request, response);
		} catch (ServletException e) {
			e.printStackTrace();
		} catch (IOException e) {
			e.printStackTrace();
		}
	}
	private void getClazzList(HttpServletRequest request,HttpServletResponse response){
		//获得员工列表
		String name = request.getParameter("clazzName");
		Integer currentPage = request.getParameter("page") == null ? 1 : Integer.parseInt(request.getParameter("page"));
		Integer pageSize = request.getParameter("rows") == null ? 999 : Integer.parseInt(request.getParameter("rows"));		
		int userType = Integer.parseInt(request.getSession().getAttribute("userType").toString());	
		yg clazz = new yg();
		clazz.setName(name);
		//登陆者为普通员工显示个人信息
		if(userType == 2){
			yg currentUser = (yg)request.getSession().getAttribute("user");
			clazz.setId(currentUser.getId());
		}		
		ygdao clazzDao = new ygdao();
		List<yg> clazzList = clazzDao.getClazzList(clazz, new Page(currentPage, pageSize));
		int total = clazzDao.getClazzListTotal(clazz);
		clazzDao.closeCon();
		response.setCharacterEncoding("UTF-8");
		Map<String, Object> ret = new HashMap<String, Object>();
		ret.put("total", total);
		ret.put("rows", clazzList);
		try {
			String from = request.getParameter("from");
			if("combox".equals(from)){
				response.getWriter().write(JSONArray.fromObject(clazzList).toString());
			}else{
				response.getWriter().write(JSONObject.fromObject(ret).toString());
			}
		} catch (IOException e) {
			// TODO Auto-generated catch block
			e.printStackTrace();
		}
	}
}

员工list

<%@ page language="java" contentType="text/html; charset=UTF-8" pageEncoding="UTF-8"%>
<%@ taglib uri="http://java.sun.com/jsp/jstl/core" prefix="c" %>
<!DOCTYPE html PUBLIC "-//W3C//DTD HTML 4.01 Transitional//EN" "http://www.w3.org/TR/html4/loose.dtd">
<html>
<head>
	<meta charset="UTF-8">
	<title>员工列表</title>
	<link rel="stylesheet" type="text/css" href="easyui/themes/default/easyui.css">
	<link rel="stylesheet" type="text/css" href="easyui/themes/icon.css">
	<link rel="stylesheet" type="text/css" href="easyui/css/demo.css">
	<script type="text/javascript" src="easyui/jquery.min.js"></script>
	<script type="text/javascript" src="easyui/jquery.easyui.min.js"></script>
	<script type="text/javascript" src="easyui/js/validateExtends.js"></script>
	<script type="text/javascript">
	$(function() {	
		//datagrid初始化 
	    $('#dataList').datagrid({ 
	        title:'员工列表', 
	        iconCls:'icon-more',//图标 
	        border: true, 
	        collapsible: false,//是否可折叠的 
	        fit: true,//自动大小 
	        method: "post",
	        url:"ygServlet?method=getClazzList&t="+new Date().getTime(),
	        idField:'id', 
	        singleSelect: true,//是否单选 
	        pagination: true,//分页控件 
	        rownumbers: true,//行号 
	        sortName: 'id',
	        sortOrder: 'DESC', 
	        remoteSort: false,
	        columns: [[  
				{field:'chk',checkbox: true,width:50},
 		        {field:'id',title:'ID',width:100, sortable: true},    
 		        {field:'name',title:'员工姓名',width:100},
 		       	{field:'age',title:'年龄',width:50},
 		        {field:'sex',title:'性别',width:50},		      	
 		     	{field:'tele',title:'电话号码',width:150},
 		    	{field:'iden',title:'员工身份',width:100},
 		    	{field:'perm',title:'权限级别',width:70},
 		    	{field:'password',title:'密码',width:150},
 		    	
	 		]], 
	        toolbar: "#toolbar"
	    }); 
	    //设置分页控件 
	    var p = $('#dataList').datagrid('getPager'); 
	    $(p).pagination({ 
	        pageSize: 10,//每页显示的记录条数,默认为10 
	        pageList: [10,20,30,50,100],//可以设置每页记录条数的列表 
	        beforePageText: '第',//页数文本框前显示的汉字 
	        afterPageText: '页    共 {pages} 页', 
	        displayMsg: '当前显示 {from} - {to} 条记录   共 {total} 条记录', 
	    });
	    //设置工具类按钮
	    $("#add").click(function(){
	    	$("#addDialog").dialog("open");
	    });
	    //删除
	    $("#delete").click(function(){
	    	var selectRow = $("#dataList").datagrid("getSelected");
	    	//console.log(selectRow);
        	if(selectRow == null){
            	$.messager.alert("消息提醒", "请选择数据进行删除!", "warning");
            } else{
            	var clazzid = selectRow.id;
            	$.messager.confirm("消息提醒", "将删除员工信息,确认继续?", function(r){
            		if(r){
            			$.ajax({
							type: "post",
							url: "ygServlet?method=DeleteClazz",
							data: {clazzid: clazzid},
							success: function(msg){
								if(msg == "success"){
									$.messager.alert("消息提醒","删除成功!","info");
									//刷新表格
									$("#dataList").datagrid("reload");
								} else{
									$.messager.alert("消息提醒","删除失败!","warning");
									return;
								}
							}
						});
            		}
            	});
            }
	    });
	    
	    
	  	
	  	//设置添加员工窗口
	    $("#addDialog").dialog({
	    	title: "添加员工",
	    	width: 500,
	    	height: 500,
	    	iconCls: "icon-add",
	    	modal: true,
	    	collapsible: false,
	    	minimizable: false,
	    	maximizable: false,
	    	draggable: true,
	    	closed: true,
	    	buttons: [
	    		{
					text:'添加',
					plain: true,
					iconCls:'icon-add',
					handler:function(){
						var validate = $("#addForm").form("validate");
						if(!validate){
							$.messager.alert("消息提醒","请检查你输入的数据!","warning");
							return;
						} else{
							//var gradeid = $("#add_gradeList").combobox("getValue");
							$.ajax({
								type: "post",
								url: "ygServlet?method=AddClazz",
								data: $("#addForm").serialize(),
								success: function(msg){
									if(msg == "success"){
										$.messager.alert("消息提醒","添加成功!","info");
										//关闭窗口
										$("#addDialog").dialog("close");
										
										//清空原表格数据
										$("#add_name").textbox('setValue', "");
										$("#add_id").textbox('setValue', "");
										$("#add_age").textbox('setValue', "");
										$("#add_sex").textbox('setValue', "");
										$("#add_tele").textbox('setValue', "");
										$("#add_perm").textbox('setValue', "");
										$("#add_iden").textbox('setValue', "");
										$("#add_password").textbox('setValue', "");
										
										//重新刷新页面数据
							  			//$('#gradeList').combobox("setValue", gradeid);
							  			$('#dataList').datagrid("reload");
										
									} else{
										$.messager.alert("消息提醒","添加失败!","warning");
										return;
									}
								}
							});
						}
					}
				},
				{
					text:'重置',
					plain: true,
					iconCls:'icon-reload',
					handler:function(){
						$("#add_name").textbox('setValue', "");
						//重新加载员工信息
						$("#add_id").textbox('setValue', "");
						$("#add_age").textbox('setValue', "");
						$("#add_sex").textbox('setValue', "");
						$("#add_tele").textbox('setValue', "");
						$("#add_perm").textbox('setValue', "");
						$("#add_iden").textbox('setValue', "");
						$("#add_password").textbox('setValue', "");
					}
				},
			]
	    });
	  	
	  	
	  	//搜索按钮监听事件
	  	$("#search-btn").click(function(){
	  		$('#dataList').datagrid('load',{
	  			clazzName: $('#clazzName').val()
	  		});
	  	});
	  	
	  //修改按钮监听事件
	  	$("#edit-btn").click(function(){
	  		var selectRow = $("#dataList").datagrid("getSelected");
	    	//console.log(selectRow);
        	if(selectRow == null){
            	$.messager.alert("消息提醒", "请选择数据进行修改!", "warning");
            	return;
            }
        	$("#editDialog").dialog("open");
	  	});
	  
	  //设置编辑员工信息窗口
	    $("#editDialog").dialog({
	    	title: "编辑员工",
	    	width: 500,
	    	height: 450,
	    	iconCls: "icon-add",
	    	modal: true,
	    	collapsible: false,
	    	minimizable: false,
	    	maximizable: false,
	    	draggable: true,
	    	closed: true,
	    	buttons: [
	    		{
					text:'确定修改',
					plain: true,
					iconCls:'icon-add',
					handler:function(){
						var validate = $("#editForm").form("validate");
						if(!validate){
							$.messager.alert("消息提醒","请检查你输入的数据!","warning");
							return;
						} else{
							//var gradeid = $("#add_gradeList").combobox("getValue");
							$.ajax({
								type: "post",
								url: "ygServlet?method=EditClazz",
								data: $("#editForm").serialize(),
								success: function(msg){
									if(msg == "success"){
										$.messager.alert("消息提醒","修改成功!","info");
										//关闭窗口
										$("#editDialog").dialog("close");
										//清空原表格数据
										$("#edit_name").textbox('setValue', "");
										$("#edit_age").textbox('setValue', "");
										$("#edit_sex").textbox('setValue', "");
										$("#edit_tele").textbox('setValue', "");
										$("#edit_perm").textbox('setValue', "");
										$("#edit_iden").textbox('setValue', "");
										$("#edit_password").textbox('setValue', "");
										//重新刷新页面数据
							  			//$('#gradeList').combobox("setValue", gradeid);
							  			$('#dataList').datagrid("reload");
										
									} else{
										$.messager.alert("消息提醒","修改失败!","warning");
										return;
									}
								}
							});
						}
					}
				},
				{
					text:'重置',
					plain: true,
					iconCls:'icon-reload',
					handler:function(){
						$("#edit_name").textbox('setValue', "");
						$("#edit_age").textbox('setValue', "");
						$("#edit_sex").textbox('setValue', "");
						$("#edit_tele").textbox('setValue', "");
						$("#edit_perm").textbox('setValue', "");
						$("#edit_iden").textbox('setValue', "");
						$("#edit_password").textbox('setValue', "");
					}
				},
			],
			onBeforeOpen: function(){
				var selectRow = $("#dataList").datagrid("getSelected");
				//console.log(selectRow);
				//设置值
				$("#edit_name").textbox('setValue', selectRow.name);
				$("#edit_age").textbox('setValue', selectRow.age);
				$("#edit_sex").textbox('setValue', selectRow.sex);
				$("#edit_tele").textbox('setValue', selectRow.tele);
				$("#edit_iden").textbox('setValue', selectRow.iden);
				$("#edit_perm").textbox('setValue', selectRow.perm);
				$("#edit_password").textbox('setValue', selectRow.password);
				
				$("#edit-id").val(selectRow.id);
			}
	    });
	  
	});
	</script>
</head>
<body>
	<!-- 数据列表 -->
	<table id="dataList" cellspacing="0" cellpadding="0"> 
	</table> 
	
	<!-- 工具栏 -->
	<div id="toolbar">
		
		<c:if test="${userType == 1}">
		<div style="float: left;"><a id="add" href="javascript:;" class="easyui-linkbutton" data-options="iconCls:'icon-add',plain:true">添加</a></div>
		</c:if>
		
		<div style="float: left; margin-right: 10px;"><a id="edit-btn" href="javascript:;" class="easyui-linkbutton" data-options="iconCls:'icon-edit',plain:true">修改</a></div>
		
		<c:if test="${userType == 1}">
		<div style="float: left; margin-right: 10px;"><a id="delete" href="javascript:;" class="easyui-linkbutton" data-options="iconCls:'icon-some-delete',plain:true">删除</a></div>
		</c:if>
		
		<div style="margin-top: 3px;">员工姓名:<input id="clazzName" class="easyui-textbox" name="clazzName" />
			<a id="search-btn" href="javascript:;" class="easyui-linkbutton" data-options="iconCls:'icon-search',plain:true">搜索</a>
		</div>
	</div>
	
	<!-- 添加窗口 -->
	<div id="addDialog" style="padding: 10px">  
    	<form id="addForm" method="post">
	    	<table cellpadding="8" >
	    		<tr>
	    			<td>员工姓名:</td>
	    			<td><input id="add_name" style="width: 200px; height: 30px;" class="easyui-textbox" type="text" name="name"  validType="CHS" /></td>
	    		</tr>
				<tr>
	    			<td>员工ID:</td>
	    			<td><input id="add_id" style="width: 200px; height: 30px;" class="easyui-textbox" type="text" name="id"  validType="number" /></td>
	    		</tr>
	    		<tr>
	    			<td>员工性别:</td>
	    			<td><select id="add_sex" class="easyui-combobox" data-options="editable: false, panelHeight: 50, width: 60, height: 30" name="sex"><option value="男"></option><option value="女"></option></select></td>
	    		</tr>
	    		<tr>
	    			<td>员工年龄:</td>
	    			<td><input id="add_age" style="width: 200px; height: 30px;" class="easyui-textbox" type="text" name="age"  validType="number" /></td>
	    		</tr>
	    		<tr>
	    			<td>员工电话号码:</td>
	    			<td><input id="add_tele" style="width: 200px; height: 30px;" class="easyui-textbox" type="text" name="tele"  validType="mobile" /></td>
	    		</tr>
	    		
	    		
	    		<tr>
	    			<td>员工身份:</td>
	    			<td><select id="add_iden" class="easyui-combobox" data-options="editable: false, panelHeight: 100, width: 100, height: 30" name="iden"><option value="收银员">收银员</option><option value="导购员">导购员</option><option value="清洁人员">清洁人员</option><option value="搬运员">搬运员</option><option value="安保人员">安保人员</option><option value="经理">经理</option></select></td>
	    		</tr>
	    		<tr>
	    			<td>员工权限:</td>
	    			<td><input id="add_perm" style="width: 200px; height: 30px;" class="easyui-textbox" type="text" name="perm"  data-options="required:true, missingMessage:'不能为空'" /></td>
	    		</tr>
	    		<tr>
	    			<td>员工密码:</td>
	    			<td><input id="add_password" style="width: 200px; height: 30px;" class="easyui-textbox" type="text" name="password"  data-options="required:true, missingMessage:'不能为空'" /></td>
	    		</tr>

	    		
	    		
	    	</table>
	    </form>
	</div>
	
	<!-- 编辑窗口 -->
	<div id="editDialog" style="padding: 10px">  
    	<form id="editForm" method="post">
    	<input type="hidden" id="edit-id" name="id">
	    	<table cellpadding="8" >
	    		<tr>
	    			<td>员工姓名:</td>
	    			<td><input id="edit_name" style="width: 200px; height: 30px;" class="easyui-textbox" type="text" name="name"  validType="CHS" /></td>
	    		</tr>
	    		<tr>
	    			<td>员工性别:</td>
	    			<td><select id="edit_sex" class="easyui-combobox" data-options="editable: false, panelHeight: 50, width: 60, height: 30" name="sex"><option value="男"></option><option value="女"></option></select></td>
	    		</tr>
	    		<tr>
	    			<td>员工年龄:</td>
	    			<td><input id="edit_age" style="width: 200px; height: 30px;" class="easyui-textbox" type="text" name="age"  validType="number" /></td>
	    		</tr>
	    		<tr>
	    			<td>员工电话号码:</td>
	    			<td><input id="edit_tele" style="width: 200px; height: 30px;" class="easyui-textbox" type="text" name="tele"  validType="mobile" /></td>
	    		</tr>
	    		
	    		<c:if test="${userType == 1}">
	    		<tr>
	    			<td>员工身份:</td>
	    			<td><select id="edit_iden" class="easyui-combobox" data-options="editable: false, panelHeight: 100, width: 100, height: 30" name="iden"><option value="收银员">收银员</option><option value="导购员">导购员</option><option value="清洁人员">清洁人员</option><option value="搬运员">搬运员</option><option value="安保人员">安保人员</option><option value="经理">经理</option></select></td>
	    		</tr>
	    		<tr>
	    			<td>员工权限:</td>
	    			<td><input id="edit_perm" style="width: 200px; height: 30px;" class="easyui-textbox" type="text" name="perm"  data-options="required:true, missingMessage:'不能为空'" /></td>
	    		</tr>
	    		<tr>
	    			<td>员工密码:</td>
	    			<td><input id="edit_password" style="width: 200px; height: 30px;" class="easyui-textbox" type="text" name="password"  data-options="required:true, missingMessage:'不能为空'" /></td>
	    		</tr>
		    	</c:if>
		    	
	    	</table>
	    </form>
	</div>
	
</body>
</html>
  • 0
    点赞
  • 6
    收藏
    觉得还不错? 一键收藏
  • 3
    评论
基于JSP超市管理系统源码和数据库是一个用于管理超市业务的软件系统。它通常由前端页面(使用JSP技术编写)、后端数据库(使用MySQL等数据库存储数据)和后端逻辑(使用Java编写的后台逻辑)构成。 这个系统的源码可以通过使用JSP技术和Java编写来实现JSP是一种Java服务器端技术,它允许我们将Java代码嵌入到HTML页面中,从而实现动态的网页内容。在超市管理系统中,我们可以使用JSP来创建产品展示页面、购物车页面、订单页面等等。 数据库在超市管理系统中起到存储数据的作用。我们可以使用关系型数据库如MySQL来存储超市的产品信息、用户信息、订单信息等。通过使用适当的SQL语句,我们可以实现超市数据的增删改查等操作。 超市管理系统的功能可能包括以下方面:产品管理、库存管理、订单管理、会员管理、销售统计、数据报表等。前端页面通过调用后端逻辑来实现这些功能。后端逻辑根据用户的请求,从数据库中读取或修改数据,并返回给前端页面进行展示。 数据库设计是超市管理系统中的重要一环。我们需要根据超市的业务流程和数据需求来设计合适的数据库表结构,并编写适当的SQL语句来实现数据的读写操作。在设计数据库时,我们需要考虑如何存储产品信息、用户信息、订单信息,并建立它们之间的关联关系,以便系统能够高效地处理业务请求。 总之,基于JSP超市管理系统源码和数据库是一个用于管理超市业务的软件系统,它通过使用JSP技术和Java编写的源码实现了前端页面功能,同时使用数据库存储超市的数据信息。通过适当的数据库设计和编写的逻辑代码,我们可以实现超市业务的系统化管理。

“相关推荐”对你有帮助么?

  • 非常没帮助
  • 没帮助
  • 一般
  • 有帮助
  • 非常有帮助
提交
评论 3
添加红包

请填写红包祝福语或标题

红包个数最小为10个

红包金额最低5元

当前余额3.43前往充值 >
需支付:10.00
成就一亿技术人!
领取后你会自动成为博主和红包主的粉丝 规则
hope_wisdom
发出的红包
实付
使用余额支付
点击重新获取
扫码支付
钱包余额 0

抵扣说明:

1.余额是钱包充值的虚拟货币,按照1:1的比例进行支付金额的抵扣。
2.余额无法直接购买下载,可以购买VIP、付费专栏及课程。

余额充值