Programmers use Java to make a poverty alleviation policy platform system — based on Springboot + Vue + Elementui and so on

​

Introduction:

With the rapid development of society, the influence of computer is comprehensive and deep. With the continuous improvement of people’s living standards, people’s requirements for policy management are also increasing in daily life, and the number of policy management is increasing, making the development of policy management system become necessary and urgent. Agricultural policy management system is mainly with the help of computers, through the agricultural policy management system required information management, increase user choice, but also convenient for the vast number of users information timely query, modify and timely understanding of the poor. The policy management system of supporting farmers and helping farmers brings more convenience to users. The system collaborates with database management system software to meet the needs of users.

Functional design:

System business flow chart, as shown in the figure:

​

System architecture diagram belongs to the system design stage, system architecture diagram is only a product of this stage, the overall architecture of the system determines the mode of the whole system, is the foundation of the system. The overall structural design of the policy management system is shown in the figure below:

​

Function screenshots:

System home page: On the home page of the system, you can view the home page, poverty households, poverty alleviation policies, volunteer recruitment, message feedback, personal center, background management and other information for detailed operation

​

​

Login and registration: Log in or register information by entering the user name and password

​

Information of poor households:

​

You can view the number, number of family members, home address, family status, cover page, per capita income, account number, name and details on the page​

Information on Rural Support Policy:

​

 ​

Volunteer wanted:

​

On the volunteer recruitment page, you can view the recruitment title, position, salary, working place, working time, recruitment number, recruitment time, deadline, person in charge, contact information, pictures, release date and other information, and save the information

​

​

Feedback: Enter the message content on the feedback page and submit or reset the message immediately

​

Personal center: On the personal center page, you can modify your personal information by filling in your account number, password, name, age, gender, mobile phone, email, upload pictures and other information. You can also operate my collection in detail

​

Background management terminal:

User management: On the user management page, you can perform detailed operations on index, account, name, age, gender, mobile phone, email, and photo

​

Poor family management: in the poor family management page, you can index, number, family members, number of members, home address, cover, per capita income, account number, name, audit reply, audit status, audit and other information for details or delete operations

​

Agricultural policy information: you can modify or delete the index, title, type of poverty alleviation, release time, cover and other information in the page of poverty alleviation policy management

​

​

Volunteer recruitment: you can modify or delete the index, recruitment title, position, salary, working place, working time, recruitment number, recruitment time, deadline, person in charge, contact information, picture, release date and other information in the volunteer recruitment management page

​

Volunteer recruitment: user recruitment management, in the user recruitment management page can index, recruitment title, position, whether to apply, apply time, account number, name, mobile phone, review reply, review status, review and other information for details or delete operations

​

Message board management: in the message board management page you can index, user name, message content, reply content and other information for details, reply, modify or delete operations

​

Multicast chart management: You can modify indexes, names, and values on the multicast chart management page

​

Code implementation:

/** * Hot news * back-end interface *@author 
 * @email 
 * @dateThe 2022-03-07 09:32:05 * /
@RestController
@RequestMapping("/remenxinwen")
public class RemenxinwenController {
    @Autowired
    private RemenxinwenService remenxinwenService;
    


    /** * Back-end list */
    @RequestMapping("/page")
    public R page(@RequestParam Map<String, Object> params,RemenxinwenEntity remenxinwen,
		HttpServletRequest request){
        EntityWrapper<RemenxinwenEntity> ew = new EntityWrapper<RemenxinwenEntity>();
		PageUtils page = remenxinwenService.queryPage(params, MPUtil.sort(MPUtil.between(MPUtil.likeOrEq(ew, remenxinwen), params), params));

        return R.ok().put("data", page);
    }
    
    /**
     * 前端列表
     */
	@IgnoreAuth
    @RequestMapping("/list")
    public R list(@RequestParam Map<String, Object> params,RemenxinwenEntity remenxinwen, 
		HttpServletRequest request){
        EntityWrapper<RemenxinwenEntity> ew = new EntityWrapper<RemenxinwenEntity>();
		PageUtils page = remenxinwenService.queryPage(params, MPUtil.sort(MPUtil.between(MPUtil.likeOrEq(ew, remenxinwen), params), params));
        return R.ok().put("data", page);
    }

	/** * list */
    @RequestMapping("/lists")
    public R list( RemenxinwenEntity remenxinwen){
       	EntityWrapper<RemenxinwenEntity> ew = new EntityWrapper<RemenxinwenEntity>();
      	ew.allEq(MPUtil.allEQMapPre( remenxinwen, "remenxinwen")); 
        return R.ok().put("data", remenxinwenService.selectListView(ew));
    }

	 /** * query */
    @RequestMapping("/query")
    public R query(RemenxinwenEntity remenxinwen){
        EntityWrapper< RemenxinwenEntity> ew = new EntityWrapper< RemenxinwenEntity>();
 		ew.allEq(MPUtil.allEQMapPre( remenxinwen, "remenxinwen")); 
		RemenxinwenView remenxinwenView =  remenxinwenService.selectView(ew);
		return R.ok("Hot news query succeeded").put("data", remenxinwenView);
    }
	
    /** ** */
    @RequestMapping("/info/{id}")
    public R info(@PathVariable("id") Long id){
        RemenxinwenEntity remenxinwen = remenxinwenService.selectById(id);
		remenxinwen.setClicknum(remenxinwen.getClicknum()+1);
		remenxinwen.setClicktime(new Date());
		remenxinwenService.updateById(remenxinwen);
        return R.ok().put("data", remenxinwen);
    }

    /** * Front-end details */
	@IgnoreAuth
    @RequestMapping("/detail/{id}")
    public R detail(@PathVariable("id") Long id){
        RemenxinwenEntity remenxinwen = remenxinwenService.selectById(id);
		remenxinwen.setClicknum(remenxinwen.getClicknum()+1);
		remenxinwen.setClicktime(new Date());
		remenxinwenService.updateById(remenxinwen);
        return R.ok().put("data", remenxinwen);
    }
    



    /** * The backend saves */
    @RequestMapping("/save")
    public R save(@RequestBody RemenxinwenEntity remenxinwen, HttpServletRequest request){
    	remenxinwen.setId(new Date().getTime()+new Double(Math.floor(Math.random()*1000)).longValue());
    	//ValidatorUtils.validateEntity(remenxinwen);
        remenxinwenService.insert(remenxinwen);
        return R.ok();
    }
    
    /**
     * 前端保存
     */
    @RequestMapping("/add")
    public R add(@RequestBody RemenxinwenEntity remenxinwen, HttpServletRequest request){
    	remenxinwen.setId(new Date().getTime()+new Double(Math.floor(Math.random()*1000)).longValue());
    	//ValidatorUtils.validateEntity(remenxinwen);
        remenxinwenService.insert(remenxinwen);
        return R.ok();
    }

    /** * modify */
    @RequestMapping("/update")
    public R update(@RequestBody RemenxinwenEntity remenxinwen, HttpServletRequest request){
        //ValidatorUtils.validateEntity(remenxinwen);
        remenxinwenService.updateById(remenxinwen);// All updates
        return R.ok();
    }
    

    /** * delete */
    @RequestMapping("/delete")
    public R delete(@RequestBody Long[] ids){
        remenxinwenService.deleteBatchIds(Arrays.asList(ids));
        return R.ok();
    }
    
    /** * remind interface */
	@RequestMapping("/remind/{columnName}/{type}")
	public R remindCount(@PathVariable("columnName") String columnName, HttpServletRequest request, 
						 @PathVariable("type") String type,@RequestParam Map<String, Object> map) {
		map.put("column", columnName);
		map.put("type", type);
		
		if(type.equals("2")) {
			SimpleDateFormat sdf = new SimpleDateFormat("yyyy-MM-dd");
			Calendar c = Calendar.getInstance();
			Date remindStartDate = null;
			Date remindEndDate = null;
			if(map.get("remindstart")! =null) {
				Integer remindStart = Integer.parseInt(map.get("remindstart").toString());
				c.setTime(new Date()); 
				c.add(Calendar.DAY_OF_MONTH,remindStart);
				remindStartDate = c.getTime();
				map.put("remindstart", sdf.format(remindStartDate));
			}
			if(map.get("remindend")! =null) {
				Integer remindEnd = Integer.parseInt(map.get("remindend").toString());
				c.setTime(new Date());
				c.add(Calendar.DAY_OF_MONTH,remindEnd);
				remindEndDate = c.getTime();
				map.put("remindend", sdf.format(remindEndDate));
			}
		}
		
		Wrapper<RemenxinwenEntity> wrapper = new EntityWrapper<RemenxinwenEntity>();
		if(map.get("remindstart")! =null) {
			wrapper.ge(columnName, map.get("remindstart"));
		}
		if(map.get("remindend")! =null) {
			wrapper.le(columnName, map.get("remindend"));
		}


		int count = remenxinwenService.selectCount(wrapper);
		return R.ok().put("count", count);
	}
	
	/** * front-end intelligent sorting */
	@IgnoreAuth
    @RequestMapping("/autoSort")
    public R autoSort(@RequestParam Map<String, Object> params,RemenxinwenEntity remenxinwen, HttpServletRequest request,String pre){
        EntityWrapper<RemenxinwenEntity> ew = new EntityWrapper<RemenxinwenEntity>();
        Map<String, Object> newMap = new HashMap<String, Object>();
        Map<String, Object> param = new HashMap<String, Object>();
		Iterator<Map.Entry<String, Object>> it = param.entrySet().iterator();
		while (it.hasNext()) {
			Map.Entry<String, Object> entry = it.next();
			String key = entry.getKey();
			String newKey = entry.getKey();
			if (pre.endsWith(".")) {
				newMap.put(pre + newKey, entry.getValue());
			} else if (StringUtils.isEmpty(pre)) {
				newMap.put(newKey, entry.getValue());
			} else {
				newMap.put(pre + "." + newKey, entry.getValue());
			}
		}
		params.put("sort"."clicknum");
        params.put("order"."desc");
		PageUtils page = remenxinwenService.queryPage(params, MPUtil.sort(MPUtil.between(MPUtil.likeOrEq(ew, remenxinwen), params), params));
        return R.ok().put("data", page); }}Copy the code

Database design:

Transform the e-R diagram of database conceptual design into a relational database. In a relational database, data relationships consist of data tables, but the structure of the table is expressed in the fields of the table. The database field name is convenient and quick to write, do not recommend this writing method, please refer to the database table field design specification preparation

Table 4-1: Favorites list

Table 4-2: Poverty alleviation policies

Table 4-3: Poor households

Table 4-4: Message boards

Table 4-6: Volunteer recruitment

Table 4-7: User applications

Table 4-8: Users

Thesis Reference:

​

​