作者主页:Java毕设网
简介:Java领域优质创作者、Java项目、学习资料、技术互助
文末获取源码
一、项目介绍
本项目为后台管理系统,分为管理员与学生两种角色;
管理员角色包含以下功能:
管理员登录,管理员管理,修改密码,教师管理,学生管理,评价指标管理,评价结果查看等功能。
学生角色包含以下功能:
学生角色登录,个人信息修改,评价某一个老师等功能。
二、环境需要
1.运行环境:最好是java jdk 1.8,我们在这个平台上运行的。其他版本理论上也可以。
2.IDE环境:IDEA,Eclipse,Myeclipse都可以。推荐IDEA;
3.tomcat环境:Tomcat 7.x,8.x,9.x版本均可
4.硬件环境:windows 7/8/10 1G内存以上;或者 Mac OS;
5.数据库:MySql 5.7版本;
6.是否Maven项目:否;
三、技术栈
JSP+CSS+JavaScript+servlet+mysql
四、使用说明
1. 使用Navicat或者其它工具,在mysql中创建对应名称的数据库,并导入项目的sql文件;
2. 使用IDEA/Eclipse/MyEclipse导入项目,Eclipse/MyEclipse导入时,若为maven项目请选择maven;
若为maven项目,导入成功后请执行maven clean;maven install命令,然后运行;
3. 将项目中dao/DB.java配置文件中的数据库配置改为自己的配置;
4. 运行项目,输入http://localhost:8080/pingjia 登录
管理员账号/密码:admin/admin
用户账号/密码: liuguangliang/000000
五、运行截图
管理员角色
学生角色
六、相关代码
管理员控制器
public class admin_servlet extends HttpServlet
{
public void service(HttpServletRequest req,HttpServletResponse res)throws ServletException, IOException
{
String type=req.getParameter("type");
if(type.endsWith("adminMana"))
{
adminMana(req, res);
}
if(type.endsWith("adminAdd"))
{
adminAdd(req, res);
}
if(type.endsWith("adminDel"))
{
adminDel(req, res);
}
}
public void adminMana(HttpServletRequest req,HttpServletResponse res) throws ServletException, IOException
{
List adminList=new ArrayList();
String sql="select * from t_admin";
Object[] params={};
DB mydb=new DB();
try
{
mydb.doPstm(sql, params);
ResultSet rs=mydb.getRs();
while(rs.next())
{
TAdmin admin=new TAdmin();
admin.setUserId(rs.getInt("userId"));
admin.setUserName(rs.getString("userName"));
admin.setUserPw(rs.getString("userPw"));
adminList.add(admin);
}
rs.close();
}
catch(Exception e)
{
e.printStackTrace();
}
mydb.closed();
req.setAttribute("adminList", adminList);
req.getRequestDispatcher("admin/admin/adminMana.jsp").forward(req, res);
}
public void adminAdd(HttpServletRequest req,HttpServletResponse res)
{
String userName=req.getParameter("userName");
String userPw=req.getParameter("userPw");
String sql="insert into t_admin(userName,userPw) values(?,?)";
Object[] params={userName,userPw};
DB mydb=new DB();
mydb.doPstm(sql, params);
mydb.closed();
req.setAttribute("message", "操作成功");
req.setAttribute("path", "admin?type=adminMana");
String targetURL = "/common/success.jsp";
dispatch(targetURL, req, res);
}
public void adminDel(HttpServletRequest req,HttpServletResponse res)
{
String sql="delete from t_admin where userId="+Integer.parseInt(req.getParameter("userId"));
Object[] params={};
DB mydb=new DB();
mydb.doPstm(sql, params);
mydb.closed();
req.setAttribute("message", "操作成功");
req.setAttribute("path", "admin?type=adminMana");
String targetURL = "/common/success.jsp";
dispatch(targetURL, req, res);
}
public void dispatch(String targetURI,HttpServletRequest request,HttpServletResponse response)
{
RequestDispatcher dispatch = getServletContext().getRequestDispatcher(targetURI);
try
{
dispatch.forward(request, response);
return;
}
catch (ServletException e)
{
e.printStackTrace();
}
catch (IOException e)
{
e.printStackTrace();
}
}
public void init(ServletConfig config) throws ServletException
{
super.init(config);
}
public void destroy()
{
}
}
评价管理控制器
@Controller
@RequestMapping(value = "/Activity")
public class ActivityController {
@Autowired
private ActivityService activityService;
// 1根据id查询
@RequestMapping("/findActivityById")
public @ResponseBody Activity findActivityById(Model model, String AC_id) {
System.out.println("用户传过来的id值:" + AC_id);
int id = Integer.parseInt(AC_id);
Activity activity = activityService.findActivityById(id);
System.out.println("查到的值:"+activity.getAC_theme());
return activity;
}
// 2查询所有未审核活动信息(分页)
@RequestMapping("/findAllActivity")
public String findAllActivity(Model model, String type, Integer pageNo,
Integer pageSize) {
System.out.println("===========查询所有未审核活动信息==============");
System.out.println("传到type的值:" + type);
PagedResult<Activity> pagedResult = (PagedResult<Activity>) activityService
.findAllActivity(pageNo, pageSize);
model.addAttribute("pagedResult", pagedResult);
List<Activity> activityList = pagedResult.getDataList();
System.out.println("当前页码:" + pageNo);
System.out.println("总页数:" + pageSize);
System.out.println(pagedResult.getPages());
model.addAttribute("activityList", activityList);
return "jsp/sonpage/activity/activityson/findActivity";
}
// 3模糊查询未审核活动信息
@RequestMapping("/findLikeNameActivity")
public String findLikeNameActivity(String AC_id, String AC_theme,
Model model, String type) {
System.out.println("===========模糊查询未审核活动信息============");
System.out.println("AC_id:" + AC_id);
System.out.println("AC_theme:" + AC_theme);
//String AC_id=ac_id;
//String AC_theme=ac_theme;
Map map = new HashMap();
map.put("AC_id", AC_id);
map.put("AC_theme", AC_theme);
List<Activity> activityList = activityService.findLikeNameActivity(map);
model.addAttribute("activityList", activityList);
if (type.equals("show")) {
if (("").equals(AC_id) && ("").equals(AC_theme)) {
System.out.println("========输入为空跳转查询所有的方法=========");
return "forward:findAllActivity.action?type";
}
return "jsp/sonpage/activity/activityson/findActivity";
}
return "jsp/sonpage/activity/activityson/findActivity";
}
// 4添加活动信息
@RequestMapping("/addActivity")
public String addActivity(HttpServletRequest request, Activity activity) {
System.out.println("=========添加活动信息==========");
activityService.addActivity(activity);
// 查询所有物品
List<Goods> goodsList = activityService.findAllGoods();
request.getSession().setAttribute("goodsList", goodsList);
// 将刚添加的活动id保存,供添加活动物品时使用
request.getSession().setAttribute("AC_id", activity.getAC_id());
// 跳转到添加物品
return "redirect:../jsp/sonpage/activity/activityson/addActivityGoods.jsp";
}
// 5删除活动信息
@RequestMapping("/delActivity")
public String delActivity(int AC_id) {
System.out.println("============根据id删除活动信息============");
System.out.println("页面传值:" + AC_id);
activityService.delActivity(AC_id);
return "forward:findAllCActivity.action?type=show1";
}
// 6修改活动信息
@RequestMapping("/updateActivity")
public String updateActivity(Activity activity){
System.out.println("===========updateActivity==============");
System.out.println("活动编号:"+activity.getAC_theme());
activityService.updateActivity(activity);
return "forward:findAllCActivity.action?type=show";
}
// 7查询所有已审核活动信息(分页)
@RequestMapping("/findAllCActivity")
public String findAllCActivity(Model model, String type, Integer pageNo,
Integer pageSize) {
System.out.println("===========查询所有已审核活动信息==============");
System.out.println("传到type的值:" + type);
PagedResult<Activity> pagedResult = (PagedResult<Activity>) activityService
.findAllCActivity(pageNo, pageSize);
model.addAttribute("pagedResult", pagedResult);
List<Activity> activityList = pagedResult.getDataList();
System.out.println("当前页码:" + pageNo);
System.out.println("总页数:" + pageSize);
System.out.println(pagedResult.getPages());
model.addAttribute("activityList", activityList);
if (type.equals("show1")) {
return "jsp/sonpage/activity/activityson/delActivity";
}
if (type.equals("show")) {
return "jsp/sonpage/activity/activityson/findCActivity";
}
return "jsp/sonpage/activity/activityson/findCActivity";
}
// 8模糊查询已审核活动信息
@RequestMapping("/findLikeNameCActivity")
public String findLikeNameCActivity(String AC_id, String AC_theme,
Model model, String type) {
System.out.println("===========模糊查询已审核活动信息============");
//String AC_id=id;
//String AC_theme=theme;
System.out.println("AC_id:" + AC_id);
System.out.println("AC_theme:" + AC_theme);
Map map = new HashMap();
map.put("AC_id", AC_id);
map.put("AC_theme", AC_theme);
List<Activity> activityList = activityService
.findLikeNameCActivity(map);
model.addAttribute("activityList", activityList);
if (type.equals("show")) {
if (("").equals(AC_id) && ("").equals(AC_theme)) {
return "forward:findAllCActivity.action?type";
}
return "jsp/sonpage/activity/activityson/findCActivity";
}
if (type.equals("show1")) {
if (("").equals(AC_id) && ("").equals(AC_theme)) {
return "forward:findAllCActivity.action?type";
}
return "jsp/sonpage/activity/activityson/delActivity";
}
return "";
}
// 8批量删除已审批活动信息
@RequestMapping("/delItem")
public @ResponseBody boolean delItem(Model model, String ids) {
System.out.println("==========批量删除已审批活动信息==========");
System.out.println("ids:" + ids);
// 用数组接收获取的选中集合
String[] str = ids.split("_");
for (int i = 0; i < str.length; i++) {
int id = Integer.parseInt(str[i]);
activityService.delActivity(id);
System.out.println("删除的方法执行了");
}
// return "forward:findAllMember.action?type=show2";
return true;
}
//审批(同意)
@RequestMapping("/updateActivityById")
public @ResponseBody boolean updateActivityById(String id){
System.out.println("===========updateActivityById==============");
int AC_id=Integer.parseInt(id);
activityService.updateActivityById(AC_id);
return true;
}
//审批(不同意)
@RequestMapping("/updateActivityNById")
public @ResponseBody boolean updateActivityNById(String id,String AC_remark){
System.out.println("===========updateActivityNById==============");
int AC_id=Integer.parseInt(id);
activityService.updateActivityNById(AC_remark,AC_id);
return true;
}
//首页显示
@RequestMapping("/show")
public String show(HttpServletRequest request,Model model){
System.out.println("===========show==============");
List<Activity> activityList=activityService.findshow();
request.getSession().setAttribute("activityList", activityList);
return "redirect:../jsp/sonpage/index.jsp";
}
// 添加活动物品
@RequestMapping("/addActivityGoods")
@ResponseBody
public boolean addActivityGoods(HttpServletRequest request, String strnums, String strids) {
System.out.println("数量:" + strnums);
System.out.println("ID:" + strids);
String[] arrNums = strnums.split(",");
String[] arrIds = strids.split(",");
if (arrNums.length < 1 || arrIds.length < 1) {
return false;
} else {
// 获取活动ID
System.out.println(request.getSession().getAttribute("AC_id"));
Integer AC_id = (Integer) request.getSession().getAttribute("AC_id");
boolean result = activityService.addActivityGoods(AC_id, arrNums, arrIds);
return result;
}
}
}