1.項(xiàng)目需求
使用Javaweb+MySQL實(shí)現(xiàn)一個(gè)員工管理系統(tǒng)，能對員工進(jìn)行增刪改查，使用SSH框架開發(fā)。
2.數(shù)據(jù)表設(shè)計(jì)
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（系統(tǒng)表）
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.架構(gòu)設(shè)計(jì)
使用SSH框架開發(fā)，使用MySQL數(shù)據(jù)庫。
4.項(xiàng)目代碼目錄結(jié)構(gòu)
action：控制器包
dao：數(shù)據(jù)操作接口
dao.Impl：數(shù)據(jù)操作實(shí)現(xiàn)工具包
po：實(shí)體類包
service：服務(wù)包
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>
<!--統(tǒng)計(jì)代碼，可刪除-->
</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");
}
}
6.項(xiàng)目截圖
登錄頁面
?首頁
添加員工
個(gè)人信息
?系統(tǒng)設(shè)置文章來源：http://www.zghlxwxcb.cn/news/detail-506220.html
文章來源地址http://www.zghlxwxcb.cn/news/detail-506220.html
如需完整項(xiàng)目代碼，點(diǎn)擊下方關(guān)注個(gè)人微信公眾號：小諸葛的博客，回復(fù)202可免費(fèi)獲取源代碼。
到了這里，關(guān)于javaweb項(xiàng)目案例：員工管理系統(tǒng)的文章就介紹完了。如果您還想了解更多內(nèi)容，請?jiān)谟疑辖撬阉鱐OY模板網(wǎng)以前的文章或繼續(xù)瀏覽下面的相關(guān)文章，希望大家以后多多支持TOY模板網(wǎng)！
