javaweb项目案例：员工管理系统

原创

小诸葛的博客 2022-09-27 12:30:34 ©著作权

文章标签 mysql 数据库 database css html 文章分类 运维

©著作权归作者所有：来自51CTO博客作者小诸葛的博客的原创作品，请联系作者获取转载授权，否则将追究法律责任

1.项目需求

使用Javaweb+MySQL实现一个员工管理系统，能对员工进行增删改查，使用SSH框架开发。

2.数据表设计

manager（管理员表）

CREATE TABLE `manager` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `name` varchar(255) DEFAULT NULL,
  `head` varchar(255) DEFAULT NULL,
  `username` varchar(255) DEFAULT NULL,
  `password` varchar(255) DEFAULT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=2 DEFAULT CHARSET=utf8;

employee（员工表）

CREATE TABLE `employee` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `ranking` int(11) DEFAULT NULL,
  `real_name` varchar(255) DEFAULT NULL,
  `icon_address` varchar(255) DEFAULT NULL,
  `status` int(11) DEFAULT NULL,
  `experience_value` int(11) DEFAULT NULL,
  `experience_bar` varchar(255) DEFAULT NULL,
  `stars_value` int(11) DEFAULT NULL,
  `level` int(11) DEFAULT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=11 DEFAULT CHARSET=utf8;

systeminfo（系统表）

CREATE TABLE `systeminfo` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `system_title` varchar(255) DEFAULT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=2 DEFAULT CHARSET=utf8;

3.架构设计

使用SSH框架开发，使用MySQL数据库。

4.项目代码目录结构

action：控制器包

dao：数据操作接口

dao.Impl：数据操作实现工具包

po：实体类包

service：服务包

utils：工具类包

5.核心代码

登录页面：

<%@ page language="java" contentType="text/html; charset=UTF-8"
    pageEncoding="UTF-8"%>
<!DOCTYPE html>
<html>

<head>

<meta charset="utf-8">
<meta name="viewport" content="width=device-width, initial-scale=1.0">


<title>后台登录</title>
<link rel="shortcut icon" href="favicon.ico">
<link href="css/bootstrap.min.css?v=3.3.6" rel="stylesheet">
<link href="css/font-awesome.css?v=4.4.0" rel="stylesheet">

<link href="css/animate.css" rel="stylesheet">
<link href="css/style.css?v=4.1.0" rel="stylesheet">
<!--[if lt IE 9]>
    <meta http-equiv="refresh" content="0;ie.html" />
    <![endif]-->
<script>if(window.top !== window.self){ window.top.location = window.location;}</script>
</head>

<body class="gray-bg">

    <div class="middle-box text-center loginscreen  animated fadeInDown">
        <div>
            <div>
                <h1 class="logo-name">pc</h1>
            </div>
            <h3>欢迎使用</h3>

            <form class="m-t" role="form" action="login_login.action">
                <div class="form-group">
                    <input type="text" name="uname" class="form-control"
                        placeholder="用户名" required="true">
                </div>
                <div class="form-group">
                    <input type="password" name="upass" class="form-control"
                        placeholder="密码" required="true">
                </div>
                <button type="submit" class="btn btn-primary block full-width m-b">登
                    录</button>

                </p>

            </form>
        </div>
    </div>

    <!-- 全局js -->
    <script src="js/jquery.min.js?v=2.1.4"></script>
    <script src="js/bootstrap.min.js?v=3.3.6"></script>

    <script type="text/javascript"
        src="http://tajs.qq.com/stats?sId=9051096" charset="UTF-8"></script>
    <!--统计代码，可删除-->

</body>

</html>

登录控制器类：

package cn.lxy.action;

import javax.servlet.http.HttpServletRequest;

import org.apache.struts2.ServletActionContext;
import org.springframework.beans.factory.annotation.Autowired;

import cn.lxy.po.Manager;
import cn.lxy.service.ManagerServc;

public class LoginAction extends BasicAction {
  private String uname;
  private String upass;
  private int usertype;
  @Autowired
  private Manager manager;
  @Autowired
  private ManagerServc managerServc;
  private String resultinfo;

  public void hello() {
    HttpServletRequest request = ServletActionContext.getRequest();
    String id = request.getParameter("id");
    System.out.println(id);
    System.out.println("hello");
  }

  public String login() throws Exception {
    HttpServletRequest request = ServletActionContext.getRequest();
    String uname = request.getParameter("uname");
    String upass = request.getParameter("upass");
    manager = managerServc.login(uname, upass);
    if (manager.getName() != null) {
      this.getSesion().put("Manager", manager);
      return "login";
    } else {
      return "pleaselogin";
    }
  }

  public String tomain() {
    if (manager == null) {
      return "pleaselogin";
    } else {
      return "tomain";
    }
  }

  public String logout() {
    this.getSesion().clear();
    return "pleaselogin";
  }

  public String getUname() {
    return uname;
  }

  public void setUname(String uname) {
    this.uname = uname;
  }

  public String getUpass() {
    return upass;
  }

  public void setUpass(String upass) {
    this.upass = upass;
  }

  public String getResultinfo() {
    return resultinfo;
  }

  public void setResultinfo(String resultinfo) {
    this.resultinfo = resultinfo;
  }

}

登录service类：

package cn.lxy.service;

import java.util.List;

import org.springframework.stereotype.Service;
import org.springframework.transaction.annotation.Transactional;

import cn.lxy.dao.Impl.ManagerDaoImpl;
import cn.lxy.po.Manager;

@Transactional
@Service(value="managerServc")
public class ManagerServc extends CommonSevc<Manager, ManagerDaoImpl> {

  @Override
  public void save(Manager arg) {
    daoImpl.save(arg);    
  }

  @Override
  public Manager find(String arg) throws Exception {
    //
    return null;
  }

  @Override
  public List<Manager> findAll(String arg) {
    return daoImpl.findAll();
  }

  @Override
  public void delete(Manager arg) {
    //
    
  }
  
  public Manager login(String arg1,String arg2) throws Exception {
    return (Manager) this.getEntity.login("Manager", "username = '"+arg1+"' and password = '"+arg2+"'", Manager.class);
  }
  
  
}

登录dao类：

package cn.lxy.dao.Impl;

import java.util.List;

import org.springframework.stereotype.Component;

import cn.lxy.dao.ManagerDao;
import cn.lxy.po.Manager;

@Component(value="managerDaoImpl")
public class ManagerDaoImpl extends CommonDaoImpl<Manager> implements ManagerDao {

  @Override
  public List<Manager> findAll() {
    return (List<Manager>) ht.find("from Manager");
  }
  
}