Java源码社

基于javaweb的SSH在线投票问卷调查系统(java+ssh+jsp+mysql)

更新于

运行环境

Java≥8、MySQL≥5.7、Tomcat≥8

开发工具

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

适用

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

功能说明

522323250409

532323250409

基于javaweb的SSH在线投票问卷调查系统(java+ssh+jsp+mysql)

管理员账号/密码：admin/123456
买票账号/密码： user/123456

SSH在线调查问卷管理系统

项目介绍
本项目包含管理员与用户两种角色。
管理员角色包含以下功能：
管理员登录,用户管理,投票管理,投票结果查看等功能。

用户角色包含以下功能：
用户注册,用户登录,查看主题,投票查看,查看投票,个人信息修改,查看我的投票等功能。

由于本程序规模不大，可供课程设计，毕业设计学习演示之用

环境需要
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项目：否；
技术栈

  1. 后端：mysql+Spring+hibernate+spring mvc
  2. 前端：JSP+CSS+JavaScript+bootstrap+jquery

使用说明

  1. 使用Navicat或者其它工具，在mysql中创建对应名称的数据库，并导入项目的sql文件；
  2. 使用IDEA/Eclipse/MyEclipse导入项目;
  3. 将项目中hibernate.cfg.xml配置文件中的数据库配置改为自己的配置;
  4. 运行项目，输入localhost:8080/ssh_zaixian_tp 登录

1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
	}

	public IOptionService getOptionService() {
		return optionService;
	}

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






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; 		// 角色
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
32
33
34
35
36
37
38
39
40
41
42
43
44
45
46
	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 {
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
32
33
34
35
36
37
38
39
40
41
42
43
44
45
46
47
48
49
50
51
	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;
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
32
33
34
35
36
37
38
39
40
41
42
43
44
45
46
47
48
49
	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);
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
32
33
34
35
36
37
38
39
40
41
42
43
44
45
46
47
	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);
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
32
33
34
35
36
37
38
39
40
41
42
43
44
45
46
47
48
49
50
51
	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();
	}

项目链接：
https://javayms.github.io?id=512323250409201ed
https://javayms.pages.dev?id=512323250409201ed