600字范文 > 基于javaweb+jsp的工作日志管理系统(JavaWeb MySQL JSP Bootstrap Servlet SSM SpringBoot)

基于javaweb+jsp的工作日志管理系统(JavaWeb MySQL JSP Bootstrap Servlet SSM SpringBoot)

时间：2023-12-05 15:05:03

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等均可配置运行

适用

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

private int start;private int end;private String servlet;//查询时要请求的接口private String searchColumn;//待模糊查询的列private String keyword;//待模糊查询的关键字//通过pageNum，pageSize，totalRecord计算得来tatalPage和startIndex，构造方法中将pageNum，pageSize，totalRecord获得public PageBean(int pageNum, int totalRecord) {this.pageNum = (pageNum = Math.max(pageNum, 1));this.pageSize = 10;//默认为10this.totalRecord = totalRecord;//totalPage 总页数if (totalRecord % pageSize == 0) {//说明整除，正好每页显示pageSize条数据，没有多余一页要显示少于pageSize条数据的this.totalPage = totalRecord / pageSize;} else {//不整除，就要在加一页，来显示多余的数据。this.totalPage = totalRecord / pageSize + 1;}

UPDATE `t_emp`<set><if test ='id != null'>`id` = #{id},</if><if test ='empName != null'>`emp_name` = #{empName},</if><if test ='empSex != null'>`emp_sex` = #{empSex},</if><if test ='empPhone != null'>`emp_phone` = #{empPhone},</if><if test ='empDept != null'>`emp_dept` = #{empDept},</if><if test ='empJob != null'>`emp_job` = #{empJob},</if><if test ='empNo != null'>`emp_no` = #{empNo},</if><if test ='empAge != null'>`emp_age` = #{empAge},</if><if test ='empText != null'>`emp_text` = #{empText}</if></set>WHERE `id` = #{id}</update><select id="findById" resultMap="BaseResultMap">SELECT <include refid="Base_Column_List" /> FROM `t_emp` WHERE `id` = #{id}</select><select id="findAllSplit" parameterType="java.util.Map" resultMap="BaseResultMap">SELECT <include refid="Base_Column_List" /> FROM `t_emp`<where><if test="searchColumn != null and searchColumn != '' and keyword != null and keyword != ''">${searchColumn} LIKE CONCAT('%',#{keyword},'%') AND

<%@ taglib prefix="fn" uri="/jsp/jstl/functions" %><%@ taglib prefix="fmt" uri="/jsp/jstl/fmt" %><!DOCTYPE html><html><head><meta charset="utf-8"/><title>员工管理</title><link rel="stylesheet" type="text/css" href="css/index.css"/></head><body><jsp:include page="menu.jsp"/><div class="index-content"><div class="index-content-operation"><a class="info-detail">员工管理</a><br><br></div><br><div class="index-content-operation"><button class="btn btn-line btn-rect btn-info btn-sm" <c:if test="${loginUser.userType != '管理员'}">disabled="disabled" title="没有权限！！！"</c:if> οnclick="window.location.href='emp_add.jsp'">添加</button><div class="index-content-operation-search"><input id="search_keyword" placeholder="姓名" type="text" name="search_keyword"/><input type="hidden" id="searchColumn" name="searchColumn" value="emp_name"/><button class="btn btn-line btn-rect btn-warning btn-sm" onclick="searchList()">搜索</button></div></div><br><table class="table table-striped table-hover table-bordered"><thead>

import com.demo.service.UserService;import com.demo.util.Util;import com.demo.vo.User;import org.springframework.beans.factory.annotation.Autowired;import org.springframework.stereotype.Controller;import org.springframework.web.bind.annotation.RequestMapping;import javax.imageio.ImageIO;import javax.servlet.ServletException;import javax.servlet.http.HttpServlet;import javax.servlet.http.HttpServletRequest;import javax.servlet.http.HttpServletResponse;import javax.servlet.http.HttpSession;import java.awt.*;import java.awt.image.BufferedImage;import java.io.IOException;import java.io.OutputStream;import java.util.HashMap;import java.util.List;import java.util.Map;import java.util.Random;@Controllerpublic class AuthController extends HttpServlet {

//查询列和关键字String searchColumn = Util.decode(request, "searchColumn");String keyword = Util.decode(request, "keyword");Map<String, Object> params = new HashMap();//用来保存控制层传进来的参数(查询条件)params.put("searchColumn", searchColumn);//要查询的列params.put("keyword", keyword);//查询的关键字Map<String, Object> map = empService.list(params);request.getSession().setAttribute("list", map.get("list"));Integer totalRecord = (Integer) map.get("totalCount");//根据查询条件取出对应的总记录数，用于分页String pageNum = Util.decode(request, "pageNum");//封装分页参数com.demo.util.PageBean<Object> pb = new com.demo.util.PageBean(Integer.valueOf(pageNum != null ? pageNum : "1"), totalRecord);params.put("startIndex", pb.getStartIndex());params.put("pageSize", pb.getPageSize());List list = (List) empService.list(params).get("list");//根据分页参数startIndex、pageSize查询出来的最终结果listpb.setServlet("empList");pb.setSearchColumn(searchColumn);pb.setKeyword(keyword);pb.setList(list);request.getSession().setAttribute("pageBean", pb);request.getSession().setAttribute("list", pb.getList());response.sendRedirect("emp_list.jsp");

** @param strName* @return*/public static boolean isMessyCode(String strName) {java.util.regex.Pattern p = java.util.pile("\\s*|\t*|\r*|\n*");java.util.regex.Matcher m = p.matcher(strName);String after = m.replaceAll("");String temp = after.replaceAll("\\p{P}", "");char[] ch = temp.trim().toCharArray();float chLength = 0;float count = 0;for (int i = 0; i < ch.length; i++) {char c = ch[i];if (!Character.isLetterOrDigit(c)) {

/*** 员工（t_emp表对应的Java实体类）*/public class Emp implements Serializable {private Long id;//主键private String empName;//姓名private String empSex;//性别:男/女private String empPhone;//联系方式private String empDept;//所属部门private String empJob;//职位private String empNo;//工号private String empAge;//年龄private String empText;//备注public Long getId() {

** @param response* @param request* @throws IOException*/@RequestMapping("userDelete")public void delete(HttpServletResponse response, HttpServletRequest request) throws IOException {Serializable id = Util.decode(request, "id");userService.delete(Arrays.asList(id));this.redirectList(request, response);}/**

<where><if test="searchColumn != null and searchColumn != '' and keyword != null and keyword != ''">${searchColumn} LIKE CONCAT('%',#{keyword},'%') AND</if>1=1</where>ORDER BY id ASC<if test="startIndex != null and pageSize != null">LIMIT #{startIndex},#{pageSize};</if></select><select id="getAllCount" parameterType="java.util.Map" resultType="Integer">SELECT COUNT(*) FROM `t_rizhi`<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">

* @param request* @throws IOException*/@RequestMapping("userList")public void list(HttpServletResponse response, HttpServletRequest request) throws IOException {this.redirectList(request, response);}/*** 跳转到列表页面** @param request* @param response*/private void redirectList(HttpServletRequest request, HttpServletResponse response) throws IOException {//查询列和关键字String searchColumn = Util.decode(request, "searchColumn");String keyword = Util.decode(request, "keyword");Map<String, Object> params = new HashMap();//用来保存控制层传进来的参数(查询条件)params.put("searchColumn", searchColumn);//要查询的列params.put("keyword", keyword);//查询的关键字Map<String, Object> map = userService.list(params);request.getSession().setAttribute("list", map.get("list"));

运行环境

Java≥6、Tomcat≥7.0、MySQL≥5.5

开发工具

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

技术框架

JavaWeb JavaBean JSP MVC MySQL Tomcat JavaScript Bootstrap.

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

适用

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

功能说明

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

网友评论