基于javaweb+jsp的设备维修管理系统(JavaWeb JSP MySQL Servlet SSM SpringBoot Bootstrap)

JavaWeb JavaBean JSP MVC MySQL Tomcat JavaScript Bootstrap

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

开发工具：eclipse/idea/myeclipse/sts等均可配置运行

适用

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

                `weixiu_ren` = #{weixiuRen},
                `weixiu_phone` = #{weixiuPhone},
                `weixiu_status` = #{weixiuStatus},
                `weixiu_text` = #{weixiuText}
        
        WHERe `id` = #{id}

        
        
                    #{id},
                    #{shebeiName},
                    #{shebeiNo},
                    #{shebeiType},
                    #{shebeiCangjia},
                    #{shebeiIndate},
                    #{shebeiInprice},
                    #{shebeiDept},
                    #{shebeiStatus}
        
    

    
    
        DELETE FROM `t_shebei` WHERe `id` IN
        
            #{id}

     * @throws IOException
     */
    @RequestMapping("userList")
    public void list(HttpServletResponse response, HttpServletRequest request) throws IOException {
        this.redirectList(request, response);
    }

    
    private void redirectList(HttpServletRequest request, HttpServletResponse response) throws IOException {
        //查询列和关键字
        String searchColumn = Util.decode(request, "searchColumn");
        String keyword = Util.decode(request, "keyword");
        Map params = new HashMap();//用来保存控制层传进来的参数(查询条件)
        params.put("searchColumn", searchColumn);//要查询的列
        params.put("keyword", keyword);//查询的关键字
        Map map = userService.list(params);
        request.getSession().setAttribute("list", map.get("list"));

    function check() {
        //根据ID获取值
        if (document.getElementById("username").value.trim().length == 0) {
            alert("用户名不能为空!");
            return false;
        }
        if (document.getElementById("password").value.trim().length == 0) {
            alert("密码不能为空!");
            return false;
        }
        if (document.getElementById("realName").value.trim().length == 0) {
            alert("姓名不能为空!");
            return false;
        }

                `shebei_status` = #{shebeiStatus}
        
        WHERe `id` = #{id}
    

    
    
        SELECT  FROM `t_shebei`
        
            
                ${searchColumn} LIKE CONCAt('%',#{keyword},'%')  AND
            
            1=1
        
        ORDER BY id ASC
        
            LIMIT #{startIndex},#{pageSize};

@Controller
@RequestMapping
public class ShebeiController {

    @Autowired
    private ShebeiService shebeiService;

    
    @RequestMapping("shebeiAdd")

        vo.setNoticeText(Util.decode(request, "noticeText"));
        vo.setNoticeType(Util.decode(request, "noticeType"));
        vo.setCreateDate(Util.decode(request, "createDate"));
        //调用Service层的增加（insert）方法
        noticeService.insert(vo);
        this.redirectList(request, response);
    }

    
        SELECT  FROM `t_user` WHERe `id` = #{id}