Java项目:JSP网络教学平台

127 篇文章 15 订阅
111 篇文章 0 订阅

作者主页:夜未央5788

 简介: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版本;

技术栈

HTML+CSS+JavaScript+jsp+mysql

使用说明

1. 使用Navicat或者其它工具,在mysql中创建对应名称的数据库,并导入项目的sql文件;
2. 使用IDEA/Eclipse/MyEclipse导入项目,Eclipse/MyEclipse导入时,若为maven项目请选择maven;若为maven项目,导入成功后请执行maven clean;maven install命令,然后运行;
3. 将项目中application.yml配置文件中的数据库配置改为自己的配置;

4. 运行项目,输入localhost:8080/login.jsp 登录

运行截图

前台页面

 

 

 

 

管理端页面

 

 

 

 

 

相关代码 

用户管理控制器

public class UsersAction extends ActionSupport {

	private static final long serialVersionUID = 1L;
	private Integer id;
	private String username; 	// 用户名
	private String password; 	// 密码
	private String realname; 	// 姓名
	private int age; 			// 年龄
	private String sex;			// 性别
	private String phone; 		// 联系方式
	private String role; 		// 角色
	private String remark; 		// 备注

	
	private IUsersService usersService;
	private Users user = new Users();
	
	public String login() throws Exception {
		HttpServletRequest request = ServletActionContext.getRequest();
		user.setUsername(request.getParameter("username"));
		user.setPassword(request.getParameter("password"));
		System.out.println(user.getUsername() + " " + user.getPassword());
		
		String role = "error";
		try {
			Users loginUser = usersService.login(user.getUsername(),user.getPassword());
			if (null != loginUser) {	// 登录成功
				ActionContext context = ActionContext.getContext();
				context.getSession().put("LOGINUSER", loginUser);
				role = loginUser.getRole();
			}
		} catch (Exception e) {
			e.printStackTrace();
		}
		System.out.println("登录用户类型: " + role);
		return role;
	}

	public void findAllUsers() throws UnsupportedEncodingException {

		HttpServletRequest request = ServletActionContext.getRequest();
		// 获取请求次数
		String draw = "0";
		draw = request.getParameter("draw");
		// 数据起始位置
		String start = request.getParameter("start");
		int startId = Integer.parseInt(start);
		// 数据长度
		String length = request.getParameter("length");
		int endId = startId + Integer.parseInt(length);
		// 获取排序方式 默认为asc
		String orderDir = "asc"; 
		// 定义列名
		String[] cols = { "username", "password", "realname", "age", "sex", "phone", "role", "remark" };
		// 获取客户端需要那一列排序
		String orderColumn = "0"; 
		// 排序列
		orderColumn = request.getParameter("order[0][column]");
		orderColumn = cols[Integer.parseInt(orderColumn)];
		orderDir = request.getParameter("order[0][dir]");
		// 搜索过滤
		String searchValue = new String(request.getParameter("search[value]")
				.getBytes("ISO8859-1"), "UTF-8");
		System.out.println("draw: " + draw + " start: " + start + " length: "
				+ length + " orderColumn: " + orderColumn + " orderDir: " + orderDir + " searchValue: " + searchValue);


		List<Users> list1 = usersService.findAllUsers();
//		String total = String.valueOf(list1.size());
		String total;
		if(list1 == null || list1.size() == 0){
			total = String.valueOf(0);
		}else{
			total = String.valueOf(list1.size());
		}
		List<Users> list = usersService.findUsersByKeyword(searchValue, startId, endId, orderColumn, orderDir);
		
		Map<Object, Object> info = new HashMap<Object, Object>();
		info.put("data", list);
		info.put("recordsTotal", total);
		info.put("recordsFiltered", String.valueOf(usersService.getUsersFiltered(searchValue)));
		info.put("draw", draw);
		String json = new Gson().toJson(info);
		HttpServletResponse response = ServletActionContext.getResponse();
		response.setContentType("text/json");
		response.setCharacterEncoding("UTF-8");
		try {
			PrintWriter out = response.getWriter();
			out.println(json);
			out.flush();
			out.close();
		} catch (IOException e) {
			e.printStackTrace();
		}
	}
	
	public void addUser() throws IOException {
		
		HttpServletRequest request = ServletActionContext.getRequest();

		String username = request.getParameter("username");
		String password = request.getParameter("password");
		String realname = request.getParameter("realname");
		int age = Integer.parseInt(request.getParameter("age"));
		String sex = request.getParameter("sex");
		String phone = request.getParameter("phone");
		String role = request.getParameter("role");
		String remark = request.getParameter("remark");

		Users user = new Users();
		user.setUsername(username);
		user.setPassword(password);
		user.setRealname(realname);
		user.setAge(age);
		user.setSex(sex);
		user.setPhone(phone);
		user.setRole(role);
		user.setRemark(remark);

		usersService.addUser(user);
		
		JSONObject json = new JSONObject();
		json.put("status", "success");

		HttpServletResponse response = ServletActionContext.getResponse();
		response.setContentType("text/json");
		response.setCharacterEncoding("UTF-8");
		PrintWriter out = response.getWriter();
		out.println(json.toString());
		out.flush();
		out.close();
	}
	
	public void updateUser() throws IOException {
		
		HttpServletRequest request = ServletActionContext.getRequest();

		int id = Integer.parseInt(request.getParameter("id"));
		String username = request.getParameter("username");
		String password = request.getParameter("password");
		String realname = request.getParameter("realname");
		int age = Integer.parseInt(request.getParameter("age"));
		String sex = request.getParameter("sex");
		String phone = request.getParameter("phone");
		String role = request.getParameter("role");
		String remark = request.getParameter("remark");

		Users user = new Users();
		user.setId(id);
		user.setUsername(username);
		user.setPassword(password);
		user.setRealname(realname);
		user.setAge(age);
		user.setSex(sex);
		user.setPhone(phone);
		user.setRole(role);
		user.setRemark(remark);

		usersService.updateUser(user);
		
		JSONObject json = new JSONObject();
		json.put("status", "success");

		HttpServletResponse response = ServletActionContext.getResponse();
		response.setContentType("text/json");
		response.setCharacterEncoding("UTF-8");
		PrintWriter out = response.getWriter();
		out.println(json.toString());
		out.flush();
		out.close();
	}
	
	public void deleteUser() throws IOException {
		
		HttpServletRequest request = ServletActionContext.getRequest();

		String username = request.getParameter("username");
		
		usersService.deleteUserByUsername(username);
		
		JSONObject json = new JSONObject();
		json.put("status", "success");

		HttpServletResponse response = ServletActionContext.getResponse();
		response.setContentType("text/json");
		response.setCharacterEncoding("UTF-8");
		PrintWriter out = response.getWriter();
		out.println(json.toString());
		out.flush();
		out.close();
	}

	public Integer getId() {
		return id;
	}

	public void setId(Integer id) {
		this.id = id;
	}

	public String getUsername() {
		return username;
	}

	public void setUsername(String username) {
		this.username = username;
	}

	public String getPassword() {
		return password;
	}

	public void setPassword(String password) {
		this.password = password;
	}

	public String getRealname() {
		return realname;
	}

	public void setRealname(String realname) {
		this.realname = realname;
	}

	public int getAge() {
		return age;
	}

	public void setAge(int age) {
		this.age = age;
	}

	public String getSex() {
		return sex;
	}

	public void setSex(String sex) {
		this.sex = sex;
	}

	public String getPhone() {
		return phone;
	}

	public void setPhone(String phone) {
		this.phone = phone;
	}

	public String getRole() {
		return role;
	}

	public void setRole(String role) {
		this.role = role;
	}

	public String getRemark() {
		return remark;
	}

	public void setRemark(String remark) {
		this.remark = remark;
	}

	public IUsersService getUsersService() {
		return usersService;
	}

	public void setUsersService(IUsersService usersService) {
		this.usersService = usersService;
	}

	public Users getUser() {
		return user;
	}

	public void setUser(Users user) {
		this.user = user;
	}

}

问题管理控制器

public class OptionAction extends ActionSupport {

	private static final long serialVersionUID = 1L;
	private Integer optionId; // 选项id
	private Integer subjectId; // 所属投票id
	private String optionContent; // 选项内容
	private String remark; // 备注

	private IOptionService optionService;
	
	private Option Option = new Option();

	public void findAllOption() throws UnsupportedEncodingException {

		HttpServletRequest request = ServletActionContext.getRequest();
		// 获取请求次数
		String draw = "0";
		draw = request.getParameter("draw");
		// 数据起始位置
		String start = request.getParameter("start");
		int startId = Integer.parseInt(start);
		// 数据长度
		String length = request.getParameter("length");
		int endId = startId + Integer.parseInt(length);
		// 获取排序方式 默认为desc
		String orderDir = "desc"; 
		// 定义列名
		String[] cols = { "subjectId", "optionContent"};
		// 获取客户端需要那一列排序
		String orderColumn = "0"; 
		// 排序列
		orderColumn = request.getParameter("order[0][column]");
		orderColumn = cols[Integer.parseInt(orderColumn)];
		orderDir = request.getParameter("order[0][dir]");
		// 搜索过滤
		String searchValue = new String(request.getParameter("search[value]")
				.getBytes("ISO8859-1"), "UTF-8");
		System.out.println("draw: " + draw + " start: " + start + " length: "
				+ length + " orderColumn: " + orderColumn + " orderDir: " + orderDir + " searchValue: " + searchValue);

		List<Option> list1 = optionService.findAllOption();
		String total = String.valueOf(list1.size());
		List<Option> list = optionService.findOptionByKeyword(searchValue, startId, endId, orderColumn, orderDir);

		Map<Object, Object> info = new HashMap<Object, Object>();
		info.put("data", list);
		info.put("recordsTotal", total);
		info.put("recordsFiltered", String.valueOf(optionService
				.getOptionFiltered(searchValue)));
		info.put("draw", draw);
		String json = new Gson().toJson(info);
		HttpServletResponse response = ServletActionContext.getResponse();
		response.setContentType("text/json");
		response.setCharacterEncoding("UTF-8");
		try {
			PrintWriter out = response.getWriter();
			out.println(json);
			out.flush();
			out.close();
		} catch (IOException e) {
			e.printStackTrace();
		}
	}

	public void addOption() throws IOException {

		HttpServletRequest request = ServletActionContext.getRequest();

		try {
			int subjectId = Integer.parseInt(request.getParameter("subjectId"));
			String optionContent = request.getParameter("optionContent");
			
			Option option = new Option();
			option.setSubjectId(subjectId);
			option.setOptionContent(optionContent);
			option.setVotes(0);
			
			optionService.addOption(option);

			JSONObject json = new JSONObject();
			json.put("status", "success");
			
			HttpServletResponse response = ServletActionContext.getResponse();
			response.setContentType("text/json");
			response.setCharacterEncoding("UTF-8");
			PrintWriter out = response.getWriter();
			out.println(json.toString());
			out.flush();
			out.close();
		} catch (Exception e) {
			e.printStackTrace();
		}
	}

	public void updateOption() throws IOException {

		HttpServletRequest request = ServletActionContext.getRequest();
		try {
			int optionId = Integer.parseInt(request.getParameter("optionId"));
			int subjectId = Integer.parseInt(request.getParameter("subjectId"));
			String optionContent = request.getParameter("optionContent");
			int votes = Integer.parseInt(request.getParameter("votes"));
			
			Option option = new Option();
			option.setOptionId(optionId);
			option.setSubjectId(subjectId);
			option.setOptionContent(optionContent);
			option.setVotes(votes);
			
			optionService.updateOption(option);
			
			JSONObject json = new JSONObject();
			json.put("status", "success");

			HttpServletResponse response = ServletActionContext.getResponse();
			response.setContentType("text/json");
			response.setCharacterEncoding("UTF-8");
			PrintWriter out = response.getWriter();
			out.println(json.toString());
			out.flush();
			out.close();
		} catch (Exception e) {
			e.printStackTrace();
		}
	}

	public void deleteOption() throws IOException {

		HttpServletRequest request = ServletActionContext.getRequest();

		try {
			int optionId = Integer.parseInt(request.getParameter("optionId"));

			optionService.deleteOptionById(optionId);

			JSONObject json = new JSONObject();
			json.put("status", "success");

			HttpServletResponse response = ServletActionContext.getResponse();
			response.setContentType("text/json");
			response.setCharacterEncoding("UTF-8");
			PrintWriter out = response.getWriter();
			out.println(json.toString());
			out.flush();
			out.close();
		} catch (Exception e) {
			e.printStackTrace();
		}
	}

	public void findOptionsBySubjectId() throws IOException {

		HttpServletRequest request = ServletActionContext.getRequest();

		try {
			int subjectId = Integer.parseInt(request.getParameter("subjectId"));

			List<Option> list = optionService.findOptionsBySubjectId(subjectId);

			JSONObject json = new JSONObject();
			json.put("result", list);
			json.put("status", "success");

			HttpServletResponse response = ServletActionContext.getResponse();
			response.setContentType("text/json");
			response.setCharacterEncoding("UTF-8");
			PrintWriter out = response.getWriter();
			out.println(json.toString());
			out.flush();
			out.close();
		} catch (Exception e) {
			e.printStackTrace();
		}
	}
	
	public Integer getOptionId() {
		return optionId;
	}

	public void setOptionId(Integer optionId) {
		this.optionId = optionId;
	}

	public Integer getSubjectId() {
		return subjectId;
	}

	public void setSubjectId(Integer subjectId) {
		this.subjectId = subjectId;
	}

	public String getOptionContent() {
		return optionContent;
	}

	public void setOptionContent(String optionContent) {
		this.optionContent = optionContent;
	}

	public String getRemark() {
		return remark;
	}

	public void setRemark(String remark) {
		this.remark = remark;
	}

	public IOptionService getOptionService() {
		return optionService;
	}

	public void setOptionService(IOptionService optionService) {
		this.optionService = optionService;
	}

	public Option getOption() {
		return Option;
	}

	public void setOption(Option option) {
		Option = option;
	}

}

投票管理控制器

public class SubjectAction extends ActionSupport {

	private static final long serialVersionUID = 1L;
	private Integer id; // 投票id
	private String subjectName; // 投票名
	private String optionType; // 选项类型(单选、多选)
	private int optionNum; // 选项数目
	private Date createTime; // 创建时间
	private String remark; // 备注

	private ISubjectService subjectService;
	private IOptionService optionService;
	private Subject subject = new Subject();

	public void findAllSubject() throws UnsupportedEncodingException {

		HttpServletRequest request = ServletActionContext.getRequest();
		// 获取请求次数
		String draw = "0";
		draw = request.getParameter("draw");
		// 数据起始位置
		String start = request.getParameter("start");
		int startId = Integer.parseInt(start);
		// 数据长度
		String length = request.getParameter("length");
		int endId = startId + Integer.parseInt(length);
		// 获取排序方式 默认为desc
		String orderDir = "desc"; 
		// 定义列名
		String[] cols = { "subjectName", "optionType", "optionNum", "createTime" };
		// 获取客户端需要那一列排序
		String orderColumn = "0"; 
		// 排序列
		orderColumn = request.getParameter("order[0][column]");
		orderColumn = cols[Integer.parseInt(orderColumn)];
		orderDir = request.getParameter("order[0][dir]");
		// 搜索过滤
		String searchValue = new String(request.getParameter("search[value]")
				.getBytes("ISO8859-1"), "UTF-8");
		System.out.println("draw: " + draw + " start: " + start + " length: "
				+ length + " orderColumn: " + orderColumn + " orderDir: " + orderDir + " searchValue: " + searchValue);

		List<Subject> list1 = subjectService.findAllSubject();
//		String total = String.valueOf(list1.size());
		String total;
		if(list1 == null || list1.size() == 0){
			total = String.valueOf(0);
		}else{
			total = String.valueOf(list1.size());
		}
		List<Subject> list = subjectService.findSubjectByKeyword(searchValue, startId, endId, orderColumn, orderDir);

		Map<Object, Object> info = new HashMap<Object, Object>();
		info.put("data", list);
		info.put("recordsTotal", total);
		info.put("recordsFiltered", String.valueOf(subjectService
				.getSubjectFiltered(searchValue)));
		info.put("draw", draw);
		String json = new Gson().toJson(info);
		HttpServletResponse response = ServletActionContext.getResponse();
		response.setContentType("text/json");
		response.setCharacterEncoding("UTF-8");
		try {
			PrintWriter out = response.getWriter();
			out.println(json);
			out.flush();
			out.close();
		} catch (IOException e) {
			e.printStackTrace();
		}
	}

	public void addSubject() throws IOException {

		HttpServletRequest request = ServletActionContext.getRequest();

		try {
			subjectName = request.getParameter("subjectName");
			String optionType = request.getParameter("optionType");
			int optionNum = Integer.parseInt(request.getParameter("optionNum"));
			Date nowDate = new Date();
			SimpleDateFormat sdf = new SimpleDateFormat("yyyy-MM-dd HH:mm:ss");
			Date createTime = sdf.parse(sdf.format(nowDate));
			
			Subject subject = new Subject();
			subject.setSubjectName(subjectName);
			subject.setOptionType(optionType);
			subject.setOptionNum(optionNum);
			subject.setCreateTime(createTime);
			
			subjectService.addSubject(subject);
			
			Subject addedSubject = subjectService.findSubjectBySubjectName(subjectName);

			JSONObject json = new JSONObject();
			json.put("result", addedSubject);
			json.put("status", "success");
			
			HttpServletResponse response = ServletActionContext.getResponse();
			response.setContentType("text/json");
			response.setCharacterEncoding("UTF-8");
			PrintWriter out = response.getWriter();
			out.println(json.toString());
			out.flush();
			out.close();
		} catch (Exception e) {
			e.printStackTrace();
		}
	}

	public void updateSubject() throws IOException {

		HttpServletRequest request = ServletActionContext.getRequest();
		try {
			int id = Integer.parseInt(request.getParameter("id"));
			subjectName = request.getParameter("subjectName");
			String optionType = request.getParameter("optionType");
			int optionNum = Integer.parseInt(request.getParameter("optionNum"));
			
			Subject subject = new Subject();
			subject.setId(id);
			subject.setSubjectName(subjectName);
			subject.setOptionType(optionType);
			subject.setOptionNum(optionNum);
			
			subjectService.updateSubject(subject);
			
			JSONObject json = new JSONObject();
			json.put("status", "success");

			HttpServletResponse response = ServletActionContext.getResponse();
			response.setContentType("text/json");
			response.setCharacterEncoding("UTF-8");
			PrintWriter out = response.getWriter();
			out.println(json.toString());
			out.flush();
			out.close();
		} catch (Exception e) {
			e.printStackTrace();
		}
	}

	public void deleteSubject() throws IOException {

		HttpServletRequest request = ServletActionContext.getRequest();

		try {
			int id = Integer.parseInt(request.getParameter("id"));

			subjectService.deleteSubjectById(id);

			JSONObject json = new JSONObject();
			json.put("status", "success");

			HttpServletResponse response = ServletActionContext.getResponse();
			response.setContentType("text/json");
			response.setCharacterEncoding("UTF-8");
			PrintWriter out = response.getWriter();
			out.println(json.toString());
			out.flush();
			out.close();
		} catch (Exception e) {
			e.printStackTrace();
		}
	}

	/**
	 * @Func 根据投票id查找对应的投票信息
	 * @author Justerdu 2020-03-13
	 */
	public void findSubjectInfoById() throws IOException {

		HttpServletRequest request = ServletActionContext.getRequest();

		try {
			int id = Integer.parseInt(request.getParameter("id"));

			Subject subject = subjectService.findSubjectById(id);

			JSONObject json = new JSONObject();
			json.put("result", subject);
			json.put("status", "success");

			HttpServletResponse response = ServletActionContext.getResponse();
			response.setContentType("text/json");
			response.setCharacterEncoding("UTF-8");
			PrintWriter out = response.getWriter();
			out.println(json.toString());
			out.flush();
			out.close();
		} catch (Exception e) {
			e.printStackTrace();
		}
	}
	
	/**
	 * @Func 删除投票(同时需删除其子选项)
	 * @author Justerdu 2020-03-13
	 */
	public void deleteSubjectInfoAndOptionsInfoById() throws IOException {

		HttpServletRequest request = ServletActionContext.getRequest();

		try {
			int id = Integer.parseInt(request.getParameter("id"));

			// 根据subjectId删除对应的投票选项
			optionService.deleteOptionsBySubjectId(id);
			subjectService.deleteSubjectById(id);

			JSONObject json = new JSONObject();
			json.put("status", "success");

			HttpServletResponse response = ServletActionContext.getResponse();
			response.setContentType("text/json");
			response.setCharacterEncoding("UTF-8");
			PrintWriter out = response.getWriter();
			out.println(json.toString());
			out.flush();
			out.close();
		} catch (Exception e) {
			e.printStackTrace();
		}
	}
	
	public Integer getId() {
		return id;
	}

	public void setId(Integer id) {
		this.id = id;
	}

	public String getSubjectName() {
		return subjectName;
	}

	public void setSubjectName(String subjectName) {
		this.subjectName = subjectName;
	}

	public String getOptionType() {
		return optionType;
	}

	public void setOptionType(String optionType) {
		this.optionType = optionType;
	}

	public int getOptionNum() {
		return optionNum;
	}

	public void setOptionNum(int optionNum) {
		this.optionNum = optionNum;
	}

	public Date getCreateTime() {
		return createTime;
	}

	public void setCreateTime(Date createTime) {
		this.createTime = createTime;
	}

	public String getRemark() {
		return remark;
	}

	public void setRemark(String remark) {
		this.remark = remark;
	}

	public ISubjectService getSubjectService() {
		return subjectService;
	}

	public void setSubjectService(ISubjectService subjectService) {
		this.subjectService = subjectService;
	}

	public Subject getSubject() {
		return subject;
	}

	public void setSubject(Subject subject) {
		this.subject = subject;
	}

	public IOptionService getOptionService() {
		return optionService;
	}

	public void setOptionService(IOptionService optionService) {
		this.optionService = optionService;
	}
	
}

如果也想学习本系统,下面领取。关注并回复:101jsp

  • 0
    点赞
  • 0
    收藏
    觉得还不错? 一键收藏
  • 打赏
    打赏
  • 0
    评论
评论
添加红包

请填写红包祝福语或标题

红包个数最小为10个

红包金额最低5元

当前余额3.43前往充值 >
需支付:10.00
成就一亿技术人!
领取后你会自动成为博主和红包主的粉丝 规则
hope_wisdom
发出的红包

打赏作者

夜未央5788

你的鼓励将是我创作的最大动力

¥1 ¥2 ¥4 ¥6 ¥10 ¥20
扫码支付:¥1
获取中
扫码支付

您的余额不足,请更换扫码支付或充值

打赏作者

实付
使用余额支付
点击重新获取
扫码支付
钱包余额 0

抵扣说明:

1.余额是钱包充值的虚拟货币,按照1:1的比例进行支付金额的抵扣。
2.余额无法直接购买下载,可以购买VIP、付费专栏及课程。

余额充值