基于javaweb+jsp的实验室管理系统

基于javaweb+jsp的实验室管理系统

JavaWeb JavaBean JSP MVC MySQL Tomcat Javascript Layui Ajax

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

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

适用

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

                    vo.setShiyanshiZhuangtai(rs.getString("shiyanshi_zhuangtai"));
                    vo.setShiyanshiText(rs.getString("shiyanshi_text"));
                    list.add(vo);
                }
            String sqlCount = "select count(*) from `t_shiyanshi` where 1=1 " + condition;
            ps = c.prepareStatement(sqlCount);
            rs = ps.executeQuery();
            if (rs.next()) {
                totalCount = rs.getInt(1);
            }
            rs.close();
            ps.close();
            c.close();
        } catch (Exception e) {
            e.printStackTrace();
        }
        Map result = new HashMap();

package com.demo.dao.impl;

import com.demo.util.Util;
import com.demo.dao.WeixiuDAO;
import com.demo.vo.Weixiu;

import java.io.Serializable;
import java.sql.Connection;
import java.sql.PreparedStatement;
import java.sql.ResultSet;
import java.sql.Statement;
import java.util.ArrayList;
import java.util.HashMap;
import java.util.List;
import java.util.Map;


public class UserDAOImpl implements UserDAO {

    //@Override
    public void add(User vo) {
        String sql = "insert into `t_user` (`username`,`password`,`real_name`,`user_sex`,`user_phone`,`user_text`,`user_type`) values(?,?,?,?,?,?,?)";
        try {
            Connection c = Util.getConnection();
            PreparedStatement ps = c.prepareStatement(sql);
            
            ps.setString(1, vo.getUsername());
            ps.setString(2, vo.getPassword());
            ps.setString(3, vo.getRealName());
            ps.setString(4, vo.getUserSex());

            },
            page: { //支持传入 laypage 组件的所有参数（某些参数除外，如：jump/elem） - 详见文档
                layout: ['limit', 'count', 'prev', 'page', 'next', 'skip'], //自定义分页布局
                groups: 1, //只显示 1 个连续页码
                first: false, //不显示首页
                last: false, //不显示尾页
            },
            toolbar: '#myToolbar', //开启头部工具栏，并为其绑定左侧模板
            defaultToolbar: ['filter', 'exports', 'print', { //自定义头部工具栏右侧图标。如无需自定义，去除该参数即可
                title: '提示',
                layEvent: 'LAYTABLE_TIPS',
                icon: 'layui-icon-tips'
            }],
            title: '设备列表',
            cols: [
                [
                        {
                            field: 'shebeiName',
                            title: '名称',

                            title: '报修原因',
                        },
                        {
                            field: 'weixiuZhuangtai',
                            title: '状态',
                            templet: vo => vo.weixiuZhuangtai ? vo.weixiuZhuangtai : "",
                        },
                        {
                            field: 'weixiuBaoxiushjjian',
                            title: '报修时间',
                        },
                        {
                            field: 'weixiuWeixiuren',
                            title: '维修人',
                        },
                        {
                            field: 'weixiuWeixiushijian',
                            title: '维修时间',
                        },
                    {
                        align: 'center',
                        fixed: 'right',

    public void doGet(HttpServletRequest request, HttpServletResponse response) throws ServletException, IOException {
        doPost(request, response);//Get请求和Post请求的处理是一样的，所以把request、response转交给Post方法就好
    }

    
    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);//查询的关键字
        ShebeiService shebeiService = new ShebeiServiceImpl();
        response.getWriter().println(com.alibaba.fastjson.JSONObject.toJSONString(shebeiService.list(params).get("list")));
    }
}
package com.demo.servlet;

        Map params = new HashMap();//用来保存控制层传进来的参数(查询条件)
        params.put("searchColumn", searchColumn);//要查询的列
        params.put("keyword", keyword);//查询的关键字
        NoticeService noticeService = new NoticeServiceImpl();
        response.getWriter().println(com.alibaba.fastjson.JSONObject.toJSONString(noticeService.list(params).get("list")));
    }
}
<%@ page contentType="text/html; charset=UTF-8" pageEncoding="UTF-8" %>
<%@ taglib uri="http://java.sun.com/jsp/jstl/core" prefix="c" %>
<%@ taglib prefix="fn" uri="http://java.sun.com/jsp/jstl/functions" %>
<%@ taglib prefix="fmt" uri="http://java.sun.com/jsp/jstl/fmt" %>

    }

    layui.use('table', function () {
        let table = layui.table;
        table.render({
            elem: '#myData',
            id: 'myTable',
            url: 'WeixiuServlet?action=list',
            parseData: function (res) { //res：即为原始返回的数据
                let result = this.page.curr ? res.slice(this.limit * (this.page.curr - 1), this.limit * this.page.curr) : res.slice(0, this.limit);
                return {
                    "code": 0, //解析接口状态
                    "msg": '', //解析提示文本
                    "count": res.length, //解析数据长度（集合个数）
                    "data": result //解析数据列表
                };
            },
            page: { //支持传入 laypage 组件的所有参数（某些参数除外，如：jump/elem） - 详见文档
                layout: ['limit', 'count', 'prev', 'page', 'next', 'skip'], //自定义分页布局
                groups: 1, //只显示 1 个连续页码

                    vo.setId(rs.getLong("id"));
                    vo.setShiyanshiName(rs.getString("shiyanshi_name"));
                    vo.setShiyanshiWeizhi(rs.getString("shiyanshi_weizhi"));
                    vo.setShiyanshiZhuangtai(rs.getString("shiyanshi_zhuangtai"));
                    vo.setShiyanshiText(rs.getString("shiyanshi_text"));
                    list.add(vo);
                }
            String sqlCount = "select count(*) from `t_shiyanshi` where 1=1 " + condition;
            ps = c.prepareStatement(sqlCount);
            rs = ps.executeQuery();
            if (rs.next()) {
                totalCount = rs.getInt(1);
            }
            rs.close();
            ps.close();
            c.close();
        } catch (Exception e) {
            e.printStackTrace();
        }
        Map result = new HashMap();

                //parent.location.reload();//刷新父级页面
                layer.msg(data.shebeiName + ' 删除成功！');
                // });
            } else if (layEvent === 'edit') { //编辑
                layer.open({
                    type: 2,
                    area: ['800px', '550px'],
                    fixed: false, //不固定
                    maxmin: true,
                    content: 'ShebeiServlet?action=editPre&id=' + data.id
                });
                obj.update({});//同步更新缓存对应的值
            } else if (layEvent === 'info') { //详情
                layer.open({
                    type: 2,
                    area: ['800px', '650px'],
                    fixed: false, //不固定
                    maxmin: true,
                    content: 'ShebeiServlet?action=get&id=' + data.id

        int green = minColor + random.nextInt(maxColor - minColor);
        //  获得蓝色的随机颜色值
        int blue = minColor + random.nextInt(maxColor - minColor);
        return new Color(red, green, blue);
    }
}
package com.demo.dao.impl;

import com.demo.util.Util;
import com.demo.dao.WeixiuDAO;
import com.demo.vo.Weixiu;

import java.io.Serializable;
import java.sql.Connection;
import java.sql.PreparedStatement;
import java.sql.ResultSet;

    
    
    



    
        实验室管理系统
        
        
            
                请登录
            
        
        
            
                ${loginUser.username}
                退出登录

            vo.setPassword(Util.decode(request, "password"));
            vo.setRealName(Util.decode(request, "realName"));
            vo.setUserSex(Util.decode(request, "userSex"));
            vo.setUserPhone(Util.decode(request, "userPhone"));
            vo.setUserText(Util.decode(request, "userText"));
            vo.setUserType(Util.decode(request, "userType"));
            UserService userService = new UserServiceImpl();
            //调用Service层增加方法（add），增加记录
            userService.add(vo);
            this.redirectList(request, response);

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

public class WeixiuDAOImpl implements WeixiuDAO {

    //@Override
    public void add(Weixiu vo) {
        String sql = "insert into `t_weixiu` (`weixiu_name`,`weixiu_shiyanshi`,`weixiu_baoxiuren`,`weixiu_yuanyin`,`weixiu_zhuangtai`,`weixiu_baoxiushjjian`,`weixiu_weixiuren`,`weixiu_weixiushijian`) values(?,?,?,?,?,?,?,?)";
        try {
            Connection c = Util.getConnection();
            PreparedStatement ps = c.prepareStatement(sql);
            
            ps.setString(1, vo.getWeixiuName());
            ps.setString(2, vo.getWeixiuShiyanshi());
            ps.setString(3, vo.getWeixiuBaoxiuren());
            ps.setString(4, vo.getWeixiuYuanyin());
            ps.setString(5, vo.getWeixiuZhuangtai());
            ps.setString(6, vo.getWeixiuBaoxiushjjian());
            ps.setString(7, vo.getWeixiuWeixiuren());
            ps.setString(8, vo.getWeixiuWeixiushijian());

package com.demo.servlet;

import com.demo.util.Util;
import com.demo.service.UserService;
import com.demo.service.impl.UserServiceImpl;
import com.demo.vo.User;
import javax.servlet.ServletException;
import javax.servlet.http.HttpServlet;
import javax.servlet.http.HttpServletRequest;
import javax.servlet.http.HttpServletResponse;
import java.io.IOException;
import java.io.Serializable;
import java.util.HashMap;
import java.util.List;
import java.util.Map;


//@WebServlet("/UserServlet")
public class UserServlet extends HttpServlet {

    
    @Override

            let data = obj.data; //获得当前行数据
            let layEvent = obj.event; //获得 lay-event 对应的值（也可以是表头的 event 参数对应的值）
            if (layEvent === 'del') { //删除
                // layer.confirm('删除' + data.shiyanshiName + "?", function (index) {
                $.ajax({
                    type: "GET",
                    dataType: "text",
                    url: "ShiyanshiServlet?action=delete&id=" + data.id,
                    success: function () {
                        console.log("已删除！");
                    }
                });

基于javaweb+jsp的实验室管理系统

Java相关栏目本月热门文章