600字范文 > 基于javaweb+jsp的手机店销售信息管理系统(JavaWeb JSP MySQL Servlet SSM SpringBoot Layui Ajax)

基于javaweb+jsp的手机店销售信息管理系统(JavaWeb JSP MySQL Servlet SSM SpringBoot Layui Ajax)

时间：2019-07-09 18:00:49

运行环境

Java≥8、MySQL≥5.7、Tomcat≥8

开发工具

eclipse/idea/myeclipse/sts等均可配置运行

技术框架

JavaWeb JavaBean JSP MVC MySQL Tomcat JavaScript Layui Ajax

基础JSP+Servlet或JSP+SSM(Spring、SpringMVC、MyBatis)框架或JSP+SSM+Maven(pom.xml)框架或SpringBoot…均可

适用

课程设计，大作业，毕业设计，项目练习，学习演示等

功能说明

response.getWriter().println(com.alibaba.fastjson.JSONObject.toJSONString(empService.list(params).get("list")));}}package com.demo.util;import java.sql.Connection;import java.sql.DriverManager;import java.text.SimpleDateFormat;/*** 该方法为通用的工具类，放置一些共用的方法*/public class Util {/*** 获取系统当前时间并格式化为字符串** @return*/public static String getTime() {return new SimpleDateFormat("yyyy-MM-dd HH:mm:ss").format(System.currentTimeMillis());}/*** 判断字符串是不是中文** @param c

} else if (layEvent === 'edit') {//编辑layer.open({type: 2,area: ['800px', '550px'],fixed: false, //不固定maxmin: true,content: 'phonetypeEditPre?id=' + data.id});obj.update({});//同步更新缓存对应的值} else if (layEvent === 'info') {//详情layer.open({type: 2,area: ['800px', '650px'],fixed: false, //不固定maxmin: true,content: 'phonetypeGet?id=' + data.id});obj.update({});//同步更新缓存对应的值} else if (layEvent === 'LAYTABLE_TIPS') {layer.alert('Hi，头部工具栏扩展的右侧图标。');}

groups: 1, //只显示 1 个连续页码first: false, //不显示首页last: false, //不显示尾页},toolbar: '#myToolbar', //开启头部工具栏，并为其绑定左侧模板defaultToolbar: ['filter', 'exports', 'print', {//自定义头部工具栏右侧图标。如无需自定义，去除该参数即可title: '提示',layEvent: 'LAYTABLE_TIPS',icon: 'layui-icon-tips'}],title: '销售记录列表',cols: [[

import javax.servlet.http.HttpServletResponse;import javax.servlet.http.HttpSession;import java.io.IOException;import java.io.Serializable;import java.util.Arrays;import java.util.HashMap;import java.util.List;import java.util.Map;@Controller@RequestMappingpublic class UserController {@Autowiredprivate UserService userService;/*** 增加用户** @param response* @param request* @throws IOException*/@RequestMapping("userAdd")public void add(HttpServletResponse response, HttpServletRequest request) throws IOException {

<c:if test="${loginUser==null}"><ul class="layui-nav layui-layout-right"><li class="layui-nav-item"><a href="login.jsp">请登录</a></li></ul></c:if><c:if test="${loginUser!=null}"><ul class="layui-nav layui-layout-right"><li class="layui-nav-item"><a>${loginUser.username}</a></li><li class="layui-nav-item"><a href="authLogout">退出登录</a></li></ul></c:if></div><div class="layui-side layui-bg-black"><div class="layui-side-scroll"><ul class="layui-nav layui-nav-tree" lay-filter="test"><jsp:include page="menu.jsp"><jsp:param value="active" name="User_active"/></jsp:include></ul>

<select id="getAllCount" parameterType="java.util.Map" resultType="Integer">SELECT COUNT(*) FROM `t_phonetype`<where><if test="searchColumn != null and searchColumn != '' and keyword != null and keyword != ''">${searchColumn} LIKE CONCAT('%',#{keyword},'%') AND</if>1=1</where></select></mapper><?xml version="1.0" encoding="UTF-8"?><!DOCTYPE mapper PUBLIC "-////DTD Mapper 3.0//EN" "/dtd/mybatis-3-mapper.dtd"><mapper namespace="com.demo.dao.SalerecordMapper"><resultMap id="BaseResultMap" type="com.demo.vo.Salerecord" >

private String userType;//类型:管理员/普通用户public Long getId() {return id;}public void setId(Long id) {this.id = id;}public String getUsername() {return username;}public void setUsername(String username) {this.username = username;}public String getPassword() {return password;}public void setPassword(String password) {this.password = password;

});});</script></body></html><%@ page contentType="text/html; charset=UTF-8" pageEncoding="UTF-8" %><%@ taglib uri="/jsp/jstl/core" prefix="c" %><%@ taglib prefix="fn" uri="/jsp/jstl/functions" %><%@ taglib prefix="fmt" uri="/jsp/jstl/fmt" %><html><head><meta charset="utf-8"><meta name="viewport" content="width=device-width, initial-scale=1, maximum-scale=1"><title>手机店销售信息管理系统</title><link rel="stylesheet" href="js/layui/css/layui.css"><script src="js/jquery.js"></script><script src="js/layer.js"></script></head><body class="layui-layout-body"><div class="layui-layout layui-layout-admin"><div class="layui-header"><div class="layui-logo" style="font-weight: bold;font-size: 19px">手机店销售信息管理系统</div><ul class="layui-nav layui-layout-left"></ul><c:if test="${loginUser==null}"><ul class="layui-nav layui-layout-right"><li class="layui-nav-item"><a href="login.jsp">请登录</a></li>

this.redirectList(request, response);}/*** 删除员工** @param response* @param request* @throws IOException*/@RequestMapping("empDelete")public void delete(HttpServletResponse response, HttpServletRequest request) throws IOException {Serializable id = Util.decode(request, "id");empService.delete(Arrays.asList(id));this.redirectList(request, response);}/*** 编辑员工** @param response* @param request* @throws IOException

</trim></insert><delete id="doRemoveBatch" parameterType="java.util.Collection">DELETE FROM `t_phonetype` WHERE `id` IN<foreach collection="list" item="id" separator="," open="(" close=")">#{id}</foreach></delete><update id="doUpdate" parameterType="com.demo.vo.Phonetype">UPDATE `t_phonetype`<set><if test ='id != null'>`id` = #{id},</if><if test ='phonetypeName != null'>`phonetype_name` = #{phonetypeName},</if><if test ='phonetypeCpuMemory != null'>`phonetype_cpu_memory` = #{phonetypeCpuMemory},</if><if test ='phonetypeCapacity != null'>`phonetype_capacity` = #{phonetypeCapacity},</if>

templet: vo => vo.userSex ? vo.userSex : "",},{field: 'userPhone',title: '手机',},{field: 'userText',title: '备注',},{field: 'userType',title: '类型',templet: vo => vo.userType ? vo.userType : "",},{align: 'center',fixed: 'right',title: '操作',width: 130,templet: vo => {let flag1 = ${loginUser.id} == vo.id;let flag2 = ${loginUser.userType == '管理员'};return ((flag1 || flag2) ? '<a class="layui-btn layui-btn-xs" lay-event="edit">编辑</a>' : '') + ((flag2) ? '<a class="layui-btn layui-btn-danger layui-btn-xs" lay-event="del">删除</a>' : '');}}]

<if test ='noticeName != null'>#{noticeName},</if><if test ='noticeText != null'>#{noticeText},</if><if test ='noticeType != null'>#{noticeType},</if><if test ='createDate != null'>#{createDate}</if></trim></insert><delete id="doRemoveBatch" parameterType="java.util.Collection">DELETE FROM `t_notice` WHERE `id` IN<foreach collection="list" item="id" separator="," open="(" close=")">#{id}</foreach></delete>

<result column="phonetype_cpu_memory" property="phonetypeCpuMemory" /><result column="phonetype_capacity" property="phonetypeCapacity" /><result column="phonetype_screen" property="phonetypeScreen" /><result column="phonetype_camera" property="phonetypeCamera" /><result column="phonetype_battery" property="phonetypeBattery" /><result column="phonetype_size" property="phonetypeSize" /><result column="phonetype_text" property="phonetypeText" /></resultMap><sql id="Base_Column_List">`id`,`phonetype_name`,`phonetype_cpu_memory`,`phonetype_capacity`,`phonetype_screen`,`phonetype_camera`,`phonetype_battery`,`phonetype_size`,`phonetype_text`</sql><insert id="doCreate" useGeneratedKeys="true" keyColumn="id" keyProperty="id" parameterType="com.demo.vo.Phonetype">INSERT INTO `t_phonetype`<trim prefix="(" suffix=")" suffixOverrides=","><if test ='id != null'>`id`,</if><if test ='phonetypeName != null'>`phonetype_name`,</if><if test ='phonetypeCpuMemory != null'>`phonetype_cpu_memory`,</if><if test ='phonetypeCapacity != null'>`phonetype_capacity`,</if>

/*** 删除机型** @param response* @param request* @throws IOException*/@RequestMapping("phonetypeDelete")public void delete(HttpServletResponse response, HttpServletRequest request) throws IOException {Serializable id = Util.decode(request, "id");phonetypeService.delete(Arrays.asList(id));this.redirectList(request, response);}/*** 编辑机型*

<foreach collection="list" item="id" separator="," open="(" close=")">#{id}</foreach></delete><update id="doUpdate" parameterType="com.demo.vo.Salerecord">UPDATE `t_salerecord`<set><if test ='id != null'>`id` = #{id},</if><if test ='salerecordName != null'>`salerecord_name` = #{salerecordName},</if><if test ='salerecordCount != null'>`salerecord_count` = #{salerecordCount},</if><if test ='salerecordSaletime != null'>`salerecord_saletime` = #{salerecordSaletime},</if><if test ='salerecordPrice != null'>`salerecord_price` = #{salerecordPrice},</if><if test ='salerecordBuyer != null'>`salerecord_buyer` = #{salerecordBuyer},</if><if test ='salerecordTel != null'>`salerecord_tel` = #{salerecordTel},</if><if test ='salerecordText != null'>`salerecord_text` = #{salerecordText}</if></set>WHERE `id` = #{id}</update>

本内容不代表本网观点和政治立场，如有侵犯你的权益请联系我们处理。

网友评论

网友评论仅供其表达个人看法，并不表明网站立场。