基于javaweb+mysql的ssm+maven社区居民户籍管理系统(java+ssm+jsp+js+mysql)
运行环境
Java≥8、MySQL≥5.7、Tomcat≥8
开发工具
eclipse/idea/myeclipse/sts等均可配置运行
适用
课程设计,大作业,毕业设计,项目练习,学习演示等
功能说明
基于javaweb+mysql的SSM+Maven社区居民户籍管理系统(java+ssm+jsp+js+mysql)
项目介绍
管理员角色包含以下功能: 管理员登录,居民信息管理,居民数据统计,居民政策管理,居民措施匹配,居民数据管理,管理员管理等功能。
居民角色包含以下功能: 居民登录,基本信息查看等功能。
环境需要
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版本;
技术栈
- 后端:Spring+SpringMVC+Mybatis 2. 前端:HTML+CSS+JavaScript+jsp
使用说明
- 使用Navicat或者其它工具,在mysql中创建对应名称的数据库,并导入项目的sql文件; 2. 使用IDEA/Eclipse/MyEclipse导入项目,Eclipse/MyEclipse导入时,若为maven项目请选择maven; 若为maven项目,导入成功后请执行maven clean;maven install命令,然后运行; 3. 将项目中application.yml配置文件中的数据库配置改为自己的配置; 4. 运行项目,输入localhost:8080/ 登录
}
}
/**
* 居民信息管理Controller类
*/
@Controller
@RequestMapping("/policy")
public class PolicyController {
@Resource
private PolicyService policyService;
@Autowired
private static final Logger log = Logger.getLogger(PolicyController.class);// 日志文件
/**
* 新增
*/
@RequestMapping(value = "addSave", method = RequestMethod.POST)
@ResponseBody
public Result save(@RequestBody Policy policy) throws Exception {
int resultTotal;
resultTotal = policyService.addSave(policy);
if (resultTotal > 0) {
return ResultGenerator.genSuccessResult();
} else {
return ResultGenerator.genFailResult("FAIL");
}
}
/**
* 修改
/**
* 删除
*
* @param pkids
* @return
* @throws Exception
*/
@RequestMapping(value = "/delete/{pkids}", method = RequestMethod.DELETE)
@ResponseBody
public Result delete(@PathVariable(value = "pkids") String pkids) throws Exception {
String[] pkidArr = pkids.split(",");
studentService.deleteStudent(pkidArr);
return ResultGenerator.genSuccessResult();
}
}
/**
* 居民信息管理Controller类
*/
@Controller
@RequestMapping("/person")
public class PersonController {
@Resource
private PersonService personService;
@Autowired
private static final Logger log = Logger.getLogger(PersonController.class);// 日志文件
/**
* 新增
*/
@RequestMapping(value = "addSave", method = RequestMethod.POST)
@ResponseBody
public Result save(@RequestBody Person person) throws Exception {
map.put("start", pageBean.getStart());
map.put("size", pageBean.getPageSize());
map.put("table", table);
map.put("name", where);
List<Map<String, Object>> list = baseMapper.findGridData(map);
List<Map<String, Object>> returnList = new ArrayList<Map<String,Object>>();
System.out.println(table);
Long total = baseMapper.getGridTotal(map);
if(request.getSession().getAttribute("person")!=null&&table.equals("v_person")) {
Person person = (Person)request.getSession().getAttribute("person");
for (Map<String, Object> temp:list) {
if(temp.get("name").equals(person.getName())&&temp.get("password").equals(person.getPassword())) {
returnList.add(temp);
total = 1L;
break;
}
}
}else if(request.getSession().getAttribute("admin")!=null&&table.equals("v_person")&&dataMap.get("name")!= null){
for (Map<String, Object> temp:list) {
System.out.println(temp.get("name").toString());
System.out.println(dataMap.get("name").toString());
if(temp.get("name").toString().contains(dataMap.get("name").toString())) {
returnList.add(temp);
total = 1L;
break;
}
}
}else if(request.getSession().getAttribute("admin")!=null&&table.equals("policy")&&dataMap.get("title")!= null&&!"".equals(dataMap.get("title"))){
for (Map<String, Object> temp:list) {
System.out.println(temp.get("title").toString());
System.out.println(dataMap.get("title").toString());
if(temp.get("title").toString().contains(dataMap.get("title").toString())) {
returnList.add(temp);
total = 1L;
break;
}
}
}else if(request.getSession().getAttribute("admin")!=null&&table.equals("user")&&dataMap.get("name")!= null&&!"".equals(dataMap.get("name"))){
for (Map<String, Object> temp:list) {
System.out.println(temp.get("user_name").toString());
System.out.println(dataMap.get("name").toString());
if(temp.get("user_name").toString().contains(dataMap.get("name").toString())) {
int resultTotal = userService.updateUser(user);
if (resultTotal > 0) {
return ResultGenerator.genSuccessResult();
} else {
return ResultGenerator.genFailResult("FAIL");
}
}
/*
* @Description 删除用户
* @param [ids]
* @return com.wq.common.Result
* @throws
*/
@RequestMapping(value = "/delete/{pkids}", method = RequestMethod.DELETE)
@ResponseBody
public Result delete(@PathVariable(value = "pkids") String pkids) throws Exception {
String[] pkidArr = pkids.split(",");
userService.deleteUser(pkidArr);
return ResultGenerator.genSuccessResult();
}
}
/**
* 居民信息管理Controller类
/**
* 居民信息管理Controller类
*/
@Controller
@RequestMapping("/common")
public class CommonController {
@Autowired
private DataGridUtil dataGridUtil;
private static final Logger log = Logger.getLogger(CommonController.class);// 日志文件
/**
* @param page
* @param rows
* @param response
* @return
* @throws Exception
*/
@RequestMapping(value = "/dataGrid", method = RequestMethod.POST)
public String list(@RequestParam(value = "page", required = false) String page, @RequestParam(value = "rows", required = false) String rows,
@RequestParam(value = "table") String table,@RequestParam(value = "name",required = false) String name,@RequestParam(value = "title",required = false) String title, HttpServletResponse response, HttpServletRequest request) throws Exception {
Map<String, Object> map = new HashMap<>();
if(name != null) {
map.put("name", name);
}
if(title != null) {
map.put("title", title);
}
map.put("page", page);
map.put("size", rows);
map.put("table", table);
dataGridUtil.selectDataGrid(request , response, map);
return null;
}
}
/**
* @project_name perfect-ssm
*/
public class ResponseUtil {
public static void write(HttpServletResponse response, Object o) throws Exception {
response.setContentType("text/html;charset=utf-8");
/**
* 列表查询工具类
*
* @ClassName DataGridUtil
**/
public class DataGridUtil {
@Resource
private BaseMapper baseMapper;
public void selectDataGrid(HttpServletRequest request,HttpServletResponse response, Map<String, Object> dataMap) throws Exception {
String page = (dataMap.get("page") == null ? 1 : dataMap.get("page")) + "";//起始页
String rows = (dataMap.get("rows") == null ? 10 : dataMap.get("rows")) + "";//每页条数
String table = dataMap.get("table") + "";//表名
String where = dataMap.get("where")+"";
PageBean pageBean = new PageBean(Integer.parseInt(page), Integer.parseInt(rows));
Map<String, Object> map = new HashMap<>();
map.put("start", pageBean.getStart());
map.put("size", pageBean.getPageSize());
map.put("table", table);
map.put("name", where);
List<Map<String, Object>> list = baseMapper.findGridData(map);
List<Map<String, Object>> returnList = new ArrayList<Map<String,Object>>();
System.out.println(table);
Long total = baseMapper.getGridTotal(map);
if(request.getSession().getAttribute("person")!=null&&table.equals("v_person")) {
Person person = (Person)request.getSession().getAttribute("person");
for (Map<String, Object> temp:list) {
if(temp.get("name").equals(person.getName())&&temp.get("password").equals(person.getPassword())) {
returnList.add(temp);
total = 1L;
break;
@Resource
private PersonService personService;
@Autowired
private static final Logger log = Logger.getLogger(PersonController.class);// 日志文件
/**
* 新增
*/
@RequestMapping(value = "addSave", method = RequestMethod.POST)
@ResponseBody
public Result save(@RequestBody Person person) throws Exception {
int resultTotal;
resultTotal = personService.addSave(person);
if (resultTotal > 0) {
return ResultGenerator.genSuccessResult();
} else {
return ResultGenerator.genFailResult("FAIL");
}
}
/**
* 修改
*/
@RequestMapping(value = "updateSave", method = RequestMethod.POST)
@ResponseBody
public Result updateSave(@RequestBody Person person) throws Exception {
int resultTotal;
resultTotal = personService.update(person);
if (resultTotal > 0) {
return ResultGenerator.genSuccessResult();
} else {
return ResultGenerator.genFailResult("FAIL");
}
}
/**
* 匹配居民政策
*/
@RequestMapping(value = "updateSelect", method = RequestMethod.POST)
@ResponseBody
public Result updateSelect(@RequestBody Map<String, Object> map) throws Exception {
int resultTotal;
resultTotal = personService.updateSelect(map);
if (resultTotal > 0) {
return ResultGenerator.genSuccessResult();
} else {
return ResultGenerator.genFailResult("FAIL");
}
}
/**
}
return null;
}
}
/**
* 居民信息管理Controller类
*/
@Controller
@RequestMapping("/common")
public class CommonController {
@Autowired
private DataGridUtil dataGridUtil;
private static final Logger log = Logger.getLogger(CommonController.class);// 日志文件
/**
* @param page
* @param rows
* @param response
* @return
* @throws Exception
*/
@RequestMapping(value = "/dataGrid", method = RequestMethod.POST)
public String list(@RequestParam(value = "page", required = false) String page, @RequestParam(value = "rows", required = false) String rows,
@RequestParam(value = "table") String table,@RequestParam(value = "name",required = false) String name,@RequestParam(value = "title",required = false) String title, HttpServletResponse response, HttpServletRequest request) throws Exception {
Map<String, Object> map = new HashMap<>();
if(name != null) {
map.put("name", name);
}
if(title != null) {
map.put("title", title);
}
Person person = (Person)request.getSession().getAttribute("person");
for (Map<String, Object> temp:list) {
if(temp.get("name").equals(person.getName())&&temp.get("password").equals(person.getPassword())) {
returnList.add(temp);
total = 1L;
break;
}
}
}else if(request.getSession().getAttribute("admin")!=null&&table.equals("v_person")&&dataMap.get("name")!= null){
for (Map<String, Object> temp:list) {
System.out.println(temp.get("name").toString());
System.out.println(dataMap.get("name").toString());
if(temp.get("name").toString().contains(dataMap.get("name").toString())) {
returnList.add(temp);
total = 1L;
break;
}
}
}else if(request.getSession().getAttribute("admin")!=null&&table.equals("policy")&&dataMap.get("title")!= null&&!"".equals(dataMap.get("title"))){
for (Map<String, Object> temp:list) {
System.out.println(temp.get("title").toString());
System.out.println(dataMap.get("title").toString());
if(temp.get("title").toString().contains(dataMap.get("title").toString())) {
returnList.add(temp);
total = 1L;
break;
}
}
}else if(request.getSession().getAttribute("admin")!=null&&table.equals("user")&&dataMap.get("name")!= null&&!"".equals(dataMap.get("name"))){
for (Map<String, Object> temp:list) {
System.out.println(temp.get("user_name").toString());
System.out.println(dataMap.get("name").toString());
if(temp.get("user_name").toString().contains(dataMap.get("name").toString())) {
returnList.add(temp);
total = 1L;
break;
}
return ResultGenerator.genSuccessResult();
}
/**
* 获取学院列表Controller
*/
@RequestMapping(value = "/getPolicyList", method = RequestMethod.POST)
@ResponseBody
public JSONArray getPolicyList() {
List<Map<String, Object>> list = policyService.getPolicyList();
if (list.size() > 0) {
JSONArray jsonArray = JSONArray.fromObject(list);
return jsonArray;
}
return null;
}
}
/**
* 居民信息管理Controller类
*/
@Controller
@RequestMapping("/common")
public class CommonController {
@Autowired
private DataGridUtil dataGridUtil;
private static final Logger log = Logger.getLogger(CommonController.class);// 日志文件
/**
* @param page
* @param rows
* @param response
* @return
* @throws Exception
*/
@RequestMapping(value = "/dataGrid", method = RequestMethod.POST)
public String list(@RequestParam(value = "page", required = false) String page, @RequestParam(value = "rows", required = false) String rows,
@RequestParam(value = "table") String table,@RequestParam(value = "name",required = false) String name,@RequestParam(value = "title",required = false) String title, HttpServletResponse response, HttpServletRequest request) throws Exception {
@RequestMapping("/users")
public class UserController {
@Resource
private UserService userService;
private static final Logger log = Logger.getLogger(UserController.class);// 日志文件
/*
* @Description 登录
* @param [user]
* @return com.wq.common.Result
* @throws
*/
@RequestMapping(value = "/cookie", method = RequestMethod.POST)
@ResponseBody
public Result login(User user,HttpServletRequest request) {
request.getSession().invalidate();
try {
String MD5pwd = MD5Util.MD5Encode(user.getPassword(), "UTF-8");
user.setPassword(MD5pwd);
} catch (Exception e) {
user.setPassword("");
}
request.getSession().setAttribute("admin", "admin");
User resultUser = userService.login(user);
log.info("request: user/login , user: " + user.toString());
if (resultUser == null) {
return ResultGenerator.genFailResult("账号或密码错误,请重新登录!");
} else {
resultUser.setPassword("PASSWORD");
Map data = new HashMap();
data.put("currentUser", resultUser);
return ResultGenerator.genSuccessResult(data);
}
}
/*
*添加用户
*/
@RequestMapping(value = "addSave", method = RequestMethod.POST)
@ResponseBody
public Result save(@RequestBody User user) throws Exception {
int resultTotal;
/**
* 居民信息管理Controller类
*/
@Controller
@RequestMapping("/policy")
public class PolicyController {
@Resource
private PolicyService policyService;
@Autowired
private static final Logger log = Logger.getLogger(PolicyController.class);// 日志文件
/**
* 新增
*/
@RequestMapping(value = "addSave", method = RequestMethod.POST)
@ResponseBody
public Result save(@RequestBody Policy policy) throws Exception {
int resultTotal;
resultTotal = policyService.addSave(policy);
if (resultTotal > 0) {
return ResultGenerator.genSuccessResult();
} else {
return ResultGenerator.genFailResult("FAIL");
}
}
/**
* 修改
*/
@RequestMapping(value = "updateSave", method = RequestMethod.POST)
@ResponseBody
public Result updateSave(@RequestBody Policy policy) throws Exception {
int resultTotal;
} else {
return ResultGenerator.genFailResult("FAIL");
}
}
/**
* 修改
*/
@RequestMapping(value = "updateSave", method = RequestMethod.POST)
@ResponseBody
public Result updateSave(@RequestBody Person person) throws Exception {
int resultTotal;
resultTotal = personService.update(person);
if (resultTotal > 0) {
return ResultGenerator.genSuccessResult();
} else {
return ResultGenerator.genFailResult("FAIL");
}
}
/**
* 匹配居民政策
*/
@RequestMapping(value = "updateSelect", method = RequestMethod.POST)
@ResponseBody
public Result updateSelect(@RequestBody Map<String, Object> map) throws Exception {
int resultTotal;
resultTotal = personService.updateSelect(map);
if (resultTotal > 0) {
return ResultGenerator.genSuccessResult();
} else {
return ResultGenerator.genFailResult("FAIL");
}
}
/**
* 删除
*
* @param pkids
* @return
* @throws Exception
*/
@RequestMapping(value = "/delete/{pkids}", method = RequestMethod.DELETE)
@ResponseBody
public Result delete(@PathVariable(value = "pkids") String pkids) throws Exception {
String[] pkidArr = pkids.split(",");
personService.delete(pkidArr);
return ResultGenerator.genSuccessResult();
}
@RequestMapping(value = "/login", method = RequestMethod.POST)
@ResponseBody
public Result login(@RequestParam(value = "username") String username,@RequestParam(value = "password") String password,HttpServletRequest request) throws Exception {
for (Map<String, Object> temp:list) {
System.out.println(temp.get("name").toString());
System.out.println(dataMap.get("name").toString());
if(temp.get("name").toString().contains(dataMap.get("name").toString())) {
returnList.add(temp);
total = 1L;
break;
}
}
}else if(request.getSession().getAttribute("admin")!=null&&table.equals("policy")&&dataMap.get("title")!= null&&!"".equals(dataMap.get("title"))){
for (Map<String, Object> temp:list) {
System.out.println(temp.get("title").toString());
System.out.println(dataMap.get("title").toString());
if(temp.get("title").toString().contains(dataMap.get("title").toString())) {
returnList.add(temp);
total = 1L;
break;
}
}
}else if(request.getSession().getAttribute("admin")!=null&&table.equals("user")&&dataMap.get("name")!= null&&!"".equals(dataMap.get("name"))){
for (Map<String, Object> temp:list) {
System.out.println(temp.get("user_name").toString());
System.out.println(dataMap.get("name").toString());
if(temp.get("user_name").toString().contains(dataMap.get("name").toString())) {
returnList.add(temp);
total = 1L;
break;
}
}
}else {
returnList = list;
}
JSONObject result = new JSONObject();
JSONArray jsonArray = JSONArray.fromObject(returnList);
result.put("rows", jsonArray);
result.put("total", total);
ResponseUtil.write(response, result);
}
if (resultTotal > 0) {
return ResultGenerator.genSuccessResult();
} else {
return ResultGenerator.genFailResult("FAIL");
}
}
/**
* 删除
*
* @param pkids
* @return
* @throws Exception
*/
@RequestMapping(value = "/delete/{pkids}", method = RequestMethod.DELETE)
@ResponseBody
public Result delete(@PathVariable(value = "pkids") String pkids) throws Exception {
String[] pkidArr = pkids.split(",");
studentService.deleteStudent(pkidArr);
return ResultGenerator.genSuccessResult();
}
}
/**
* 居民信息管理Controller类
*/
@Controller
@RequestMapping("/person")
public class PersonController {
/*
*添加用户
*/
@RequestMapping(value = "addSave", method = RequestMethod.POST)
@ResponseBody
public Result save(@RequestBody User user) throws Exception {
int resultTotal;
String MD5pwd = MD5Util.MD5Encode(user.getPassword(), "UTF-8");
user.setPassword(MD5pwd);
resultTotal = userService.addUser(user);
if (resultTotal > 0) {
return ResultGenerator.genSuccessResult();
} else {
return ResultGenerator.genFailResult("FAIL");
}
}
/*
* @Description 修改用户
* @param [user]
* @return com.wq.common.Result
* @throws
*/
@RequestMapping(value = "updateSave", method = RequestMethod.POST)
@ResponseBody
public Result update(@RequestBody User user) throws Exception {
String MD5pwd = MD5Util.MD5Encode(user.getPassword(), "UTF-8");
user.setPassword(MD5pwd);
int resultTotal = userService.updateUser(user);
if (resultTotal > 0) {
return ResultGenerator.genSuccessResult();
} else {
return ResultGenerator.genFailResult("FAIL");
}
}
/*
* @Description 删除用户
* @param [ids]
* @return com.wq.common.Result
* @throws
*/
@RequestMapping(value = "/delete/{pkids}", method = RequestMethod.DELETE)
@ResponseBody
public Result delete(@PathVariable(value = "pkids") String pkids) throws Exception {
String[] pkidArr = pkids.split(",");
userService.deleteUser(pkidArr);
return ResultGenerator.genSuccessResult();
}
}
}
/**
* 删除
*
* @param pkids
* @return
* @throws Exception
*/
@RequestMapping(value = "/delete/{pkids}", method = RequestMethod.DELETE)
@ResponseBody
public Result delete(@PathVariable(value = "pkids") String pkids) throws Exception {
String[] pkidArr = pkids.split(",");
policyService.delete(pkidArr);
return ResultGenerator.genSuccessResult();
}
/**
* 获取学院列表Controller
*/
@RequestMapping(value = "/getPolicyList", method = RequestMethod.POST)
@ResponseBody
public JSONArray getPolicyList() {
List<Map<String, Object>> list = policyService.getPolicyList();
if (list.size() > 0) {
JSONArray jsonArray = JSONArray.fromObject(list);
return jsonArray;
}
return null;
}
}
/**
* 居民信息管理Controller类
*/
@Controller