停车位共享系统|基于微信小程序的停车位共享系统设计与实现(附项目源码+论文)

基于微信小程序的停车位共享系统设计与实现

一、摘要

随着互联网技术的不断发展,互联网已经渗透到我们生活的方方面面。随着移动设备的普及,我们的生活发生了翻天覆地的变化,这也对我们的日常生活产生了深远的影响。微信是腾讯于2011年发布的实时通信软件。随着互联网技术的不断发展,微信的功能也在不断扩展。微信已成为“航空母舰级软件”,也是每部智能手机上必需的软件之一。在2017年发布“微信应用”之前,它还成为了该行业的热潮。无需安装微信小程序。使用它时,您只需扫描或搜索它,然后在使用它时就可以走了。对于用户而言,只要有微信,微信小程序就不需要从手机上下载软件。对于小程序开发人员来说,微信小程序开发可以直接调用自己的API接口,开发相对简单,节省了时间,人力和物力。同时,小型程序也可以实现与本机应用程序相同的流畅体验。

本课题题目是基于微信平台的停车位共享小程序设计与实现。本文从系统开发环境、系统目标、设计流程、功能设计等几个方面进行系统的总体设计,并详细描述了一个功能齐全的停车位共享系统的前台及后台开发、运作过程中的一些关键技术。 本文介绍了系统的需求分析和系统分析,并完成了数据流分析,进行了数据字典功能的模块划分,数据库设计及界面设计。 最后,对系统进行测试和分析,以确保其性能和功能完整性的稳定性。

关键词 :微信;小程序;停车位共享;java;

二、相关技术
java、tomcat、mysql、spring、sprigBoot、mybatis、query、vue

三、系统设计
(1)系统主界面

用户进入小程序后,便可看到程序的主界面,具体如图5-1所示。界面中首先展示的停车场展示页面。页面被分为三大块,顶端是推广动画。中间部分是停车场搜索和停车场展示。在下方各个模块的标签页。

(2)资讯信息界面 

在资讯信息界面中,用户可以查看发布的相关资讯信息

(3)车位信息界面 

在车位信息界面中,用户可以直接看到停车场的介绍,包含对其的评分,以及各个停车位的状态和价格

(4)订单管理界面 

在订单管理界面中,将展示已经完成和正在进行的订单,将展示订单中的关键信息

(5)交流论坛界面 

在交流论坛界面中,用户可以发布帖子,也可以在别人的帖子下面回复信息

(6)车位共享界面 

在车位共享界面中,用户可以自己共享车位,发布共享信息

后台管理界面 

在后台管理界面中,用户可以进行用户管理、停车记录管理、交流讨论管理、资讯管理等

四、数据库设计 

如何设计数据库是软件系统设计与开发中最重要,最基本的要点。健壮和合理的数据库是卫生系统最需要的。数据库存储,维护,设计系统中所有数据,即如何开发系统核心也是最基本的技术,这与系统的整体稳定性和健壮性息息相关。如果在系统设计之初就没有对数据库进行良好的设计,它将带来一系列负面影响,留下许多隐藏的问题,并给系统的开发和维护蒙上阴影。因此,要实现系统的平稳运行,首先必须考虑一个好的数据库。

My SQL适用于批处理,低成本,正常性能和响应速度。它具有自己的标准语法。连接到服务器时,它也可以选择加密密码。因此,系统使用我的SQL数据库进行数据库管理,与其他数据管理工具相比,这是一个不错的选择。

数据库中需要存储用户及各个模块子功能等基本信息以及用户的历史行为信息,这些信息将会被展示在应用端的用户界面上并且会被用于进行数据分析。在该数据概念设计过程中,我们使用了实体联系模型(EntityRelationship Model,简称ER模型)来确定系统实体(Entity)、实体的属性(attribute)以及实体间的联系(relationship) 

五、核心代码  

package com.ideabobo.controller;

import java.io.File;
import java.util.ArrayList;
import java.util.HashMap;
import java.util.List;
import java.util.Map;

import javax.servlet.http.HttpServletRequest;

import com.ideabobo.util.*;
import org.springframework.beans.factory.annotation.Autowired;
import org.springframework.stereotype.Controller;
import org.springframework.util.ResourceUtils;
import org.springframework.web.bind.annotation.CrossOrigin;
import org.springframework.web.bind.annotation.RequestMapping;
import org.springframework.web.bind.annotation.RequestMethod;
import org.springframework.web.bind.annotation.RequestParam;
import org.springframework.web.bind.annotation.ResponseBody;
import org.springframework.web.multipart.MultipartFile;

import com.alibaba.fastjson.JSON;
import com.ideabobo.model.Dbservice;
import com.ideabobo.model.Dbtablemapping;
import com.ideabobo.service.DatabaseService;

@CrossOrigin(origins="*")
@Controller
@RequestMapping(value = "/database")
public class DatabaseController {
    //private static final Logger logger = Logger.getLogger(DatabaseController.class);
    @Autowired
	private DatabaseService databaseService;
    
    @RequestMapping(value = "/list", produces = "application/json; charset=utf-8", method = { RequestMethod.GET,
			RequestMethod.POST })
    @ResponseBody
    public List<Map<String,Object>> list(HttpServletRequest req) {
    	Dbservice dbm = new Dbservice(databaseService);
    	String table = Dbservice.getTableName(req.getParameter("table"));
    	Object objectObj = Common.getByRequest(Dbtablemapping.getModelByTable(table), req, false);
    	//Robj robj = new Robj();
    	List<Map<String,Object>> list = null;
    	try {
			String sql = dbm.list(table,objectObj);
			list = databaseService.find(sql);
		} catch (Exception e) {
			
			e.printStackTrace();
		}  	
        return list;
    }
    
    @RequestMapping(value = "/listJ", produces = "text/plain; charset=utf-8", method = { RequestMethod.GET,
			RequestMethod.POST })
    @ResponseBody
    public String listJ(HttpServletRequest req) {
    	Dbservice dbm = new Dbservice(databaseService);
    	String table = Dbservice.getTableName(req.getParameter("table"));
    	Object objectObj = Common.getByRequest(Dbtablemapping.getModelByTable(table), req, false);
    	//Robj robj = new Robj();
    	List<Map<String,Object>> list = null;
    	try {
			String sql = dbm.list(table,objectObj);
			list = databaseService.find(sql);
		} catch (Exception e) {
			
			e.printStackTrace();
		}  	
        return renderJsonp(list, req);
    }
    
    @RequestMapping(value = "/find", produces = "application/json; charset=utf-8", method = { RequestMethod.GET,
			RequestMethod.POST })
    @ResponseBody
    public Map<String,Object> find(HttpServletRequest req) {
    	Dbservice dbm = new Dbservice(databaseService);
    	String table = Dbservice.getTableName(req.getParameter("table"));
    	Object objectObj = Common.getByRequest(Dbtablemapping.getModelByTable(table), req, false);
    	//Robj robj = new Robj();
    	List<Map<String,Object>> list = null;
    	try {
			String sql = dbm.list(table,objectObj,true);
			list = databaseService.find(sql);
		} catch (Exception e) {
			
			e.printStackTrace();
		}
    	if (list!=null && list.size()>0) {
    		return list.get(0);
		}else{
			return null;
		}
        
    }
    
    @RequestMapping(value = "/findJ", produces = "text/plain; charset=utf-8", method = { RequestMethod.GET,
			RequestMethod.POST })
    @ResponseBody
    public String findJ(HttpServletRequest req) {
    	Dbservice dbm = new Dbservice(databaseService);
    	String table = Dbservice.getTableName(req.getParameter("table"));
    	Object objectObj = Common.getByRequest(Dbtablemapping.getModelByTable(table), req, false);
    	//Robj robj = new Robj();
    	List<Map<String,Object>> list = null;
    	try {
			String sql = dbm.list(table,objectObj,true);
			list = databaseService.find(sql);
		} catch (Exception e) {
			
			e.printStackTrace();
		}
    	if (list!=null && list.size()>0) {
    		return renderJsonp(list.get(0), req);
		}else{
			return renderJsonp(null, req);
		}
        
    }
    

    
    
    @RequestMapping(value = "/listApp", produces = "application/json; charset=utf-8", method = { RequestMethod.GET,
			RequestMethod.POST })
    @ResponseBody
    public List<Map<String,Object>> listApp(HttpServletRequest req) {
    	Dbservice dbm = new Dbservice(databaseService);
    	String table = Dbservice.getTableName(req.getParameter("table"));
    	//Robj robj = new Robj();
    	List<Map<String,Object>> list = null;
    	try {
    		String object = req.getParameter("object");
    		//if(StringUtil.isNotNullOrEmpty(object)){
    			Object objectObj = Dbtablemapping.parseStringModel(object, table);
    			String sql = dbm.list(table,objectObj);
    			list = databaseService.find(sql);
    	    	//robj.setData(databaseService.find(sql));
    		//}
			
		} catch (Exception e) {
			
			e.printStackTrace();
		}  	
        return list;
    }
    
    @RequestMapping(value = "/listC", produces = "text/plain; charset=utf-8", method = { RequestMethod.GET,
			RequestMethod.POST })
    @ResponseBody
    public String listC(HttpServletRequest req) {
    	Dbservice dbm = new Dbservice(databaseService);
    	String table = Dbservice.getTableName(req.getParameter("table"));
    	//Robj robj = new Robj();
    	List<Map<String,Object>> list = null;
    	try {
    		String object = req.getParameter("object");
    		//if(StringUtil.isNotNullOrEmpty(object)){
    			Object objectObj = Dbtablemapping.parseStringModel(object, table);
    			String sql = dbm.list(table,objectObj);
    			list = databaseService.find(sql);
    	    	//robj.setData(databaseService.find(sql));
    		//}
			
		} catch (Exception e) {
			
			e.printStackTrace();
		}  	
        return renderJsonp(list, req);
    }
    
    @RequestMapping(value = "/findApp", produces = "application/json; charset=utf-8", method = { RequestMethod.GET,
			RequestMethod.POST })
    @ResponseBody
    public Map<String,Object> findApp(HttpServletRequest req) {
    	Dbservice dbm = new Dbservice(databaseService);
    	String table = Dbservice.getTableName(req.getParameter("table"));
    	//Robj robj = new Robj();
    	List<Map<String,Object>> list = null;
    	try {
    		String object = req.getParameter("object");
    		//if(StringUtil.isNotNullOrEmpty(object)){
    			Object objectObj = Dbtablemapping.parseStringModel(object, table);
    			String sql = dbm.list(table,objectObj);
    			list = databaseService.find(sql);
    	    	//robj.setData(databaseService.find(sql));
    		//}
			
		} catch (Exception e) {
			
			e.printStackTrace();
		}  	
    	if (list!=null && list.size()>0) {
    		return list.get(0);
		}else{
			return null;
		}
    }
    
    @RequestMapping(value = "/findC", produces = "text/plain; charset=utf-8", method = { RequestMethod.GET,
			RequestMethod.POST })
    @ResponseBody
    public String findC(HttpServletRequest req) {
    	Dbservice dbm = new Dbservice(databaseService);
    	String table = Dbservice.getTableName(req.getParameter("table"));
    	//Robj robj = new Robj();
    	List<Map<String,Object>> list = null;
    	try {
    		String object = req.getParameter("object");
    		//if(StringUtil.isNotNullOrEmpty(object)){
    			Object objectObj = Dbtablemapping.parseStringModel(object, table);
    			String sql = dbm.list(table,objectObj);
    			list = databaseService.find(sql);
    	    	//robj.setData(databaseService.find(sql));
    		//}
			
		} catch (Exception e) {
			
			e.printStackTrace();
		}  	
    	if (list!=null && list.size()>0) {
    		return renderJsonp(list.get(0), req);
		}else{
			return renderJsonp(null, req);
		}
    }
    
    @RequestMapping(value = "/listPage", produces = "application/json; charset=utf-8", method = { RequestMethod.GET,
			RequestMethod.POST })
    @ResponseBody
    public Page listPage(HttpServletRequest req) {
    	Dbservice dbm = new Dbservice(databaseService);
    	String table = Dbservice.getTableName(req.getParameter("table"));
    	Page page = new Page();
    	//Robj robj = new Robj();
    	try {
    		Object model = Common.getByRequest(Dbtablemapping.getModelByTable(table), req, false);
    		page.model = model;
    		String order = req.getParameter("order");
			String sort = req.getParameter("sort");
			String pageNo = req.getParameter("page");
			String pageSize = req.getParameter("rows");
			if (pageSize==null || pageSize.equals("")){
				pageSize = req.getParameter("limit");
			}
			page = dbm.getByPage(page, table,sort,order,pageNo,pageSize);
	    	//robj.setData(page);
		} catch (Exception e) {
			
			e.printStackTrace();
		}  	
        return page;
    }
    
    @RequestMapping(value = "/listPageJ", produces = "text/plain; charset=utf-8", method = { RequestMethod.GET,
			RequestMethod.POST })
    @ResponseBody
    public String listPageJ(HttpServletRequest req) {
    	Dbservice dbm = new Dbservice(databaseService);
    	String table = Dbservice.getTableName(req.getParameter("table"));
    	Page page = new Page();
    	//Robj robj = new Robj();
    	try {
    		Object model = Common.getByRequest(Dbtablemapping.getModelByTable(table), req, false);
    		page.model = model;
			page = dbm.getByPage(page, table,null,null,null,null);
	    	//robj.setData(page);
		} catch (Exception e) {
			
			e.printStackTrace();
		}  	
        return renderJsonp(page, req);
    }
    
    @RequestMapping(value = "/listPageApp", produces = "application/json; charset=utf-8", method = { RequestMethod.GET,
			RequestMethod.POST })
    @ResponseBody
    public Page listPageApp(HttpServletRequest req) {
    	Dbservice dbm = new Dbservice(databaseService);
    	String table = Dbservice.getTableName(req.getParameter("table"));
    	Page page = new Page();
    	//Robj robj = new Robj();
    	try {
    		String object = req.getParameter("object");
    		if(StringUtil.isNotNullOrEmpty(object)){
    			page.model = Dbtablemapping.parseStringModel(object, table);
    		}
			page = dbm.getByPage(page, table,null,null,null,null);
	    	//robj.setData(page);
		} catch (Exception e) {
			
			e.printStackTrace();
		}  	
        return page;
    }
    
    @RequestMapping(value = "/listPageC", produces = "text/plain; charset=utf-8", method = { RequestMethod.GET,
			RequestMethod.POST })
    @ResponseBody
    public String listPageC(HttpServletRequest req) {
    	Dbservice dbm = new Dbservice(databaseService);
    	String table = Dbservice.getTableName(req.getParameter("table"));
    	Page page = new Page();
    	//Robj robj = new Robj();
    	try {
    		String object = req.getParameter("object");
    		if(StringUtil.isNotNullOrEmpty(object)){
    			page.model = Dbtablemapping.parseStringModel(object, table);
    		}
			page = dbm.getByPage(page, table,null,null,null,null);
	    	//robj.setData(page);
		} catch (Exception e) {
			
			e.printStackTrace();
		}  	
        return renderJsonp(page, req);
    }
    
    
    @RequestMapping(value = "/addApp", produces = "text/plain; charset=utf-8", method = { RequestMethod.GET,
			RequestMethod.POST })
    @ResponseBody
    public String addApp(HttpServletRequest req) {
    	Dbservice dbm = new Dbservice(databaseService);
    	//Robj robj = new Robj();
    	String table = Dbservice.getTableName(req.getParameter("table"));
    	String object = req.getParameter("object");
    	Object obj = Dbtablemapping.parseStringModel(object, table);
    	try {
    		String sql = dbm.add(obj, table);
    		databaseService.executeAction(sql);
		} catch (Exception e) {
			
			return "操作失败"+e.getMessage();
		}
    	
    	return "操作成功";
        
    }
    
    @RequestMapping(value = "/add", produces = "text/plain; charset=utf-8", method = { RequestMethod.GET,
			RequestMethod.POST })
    @ResponseBody
    public String add(HttpServletRequest req) {
    	Dbservice dbm = new Dbservice(databaseService);
    	//Robj robj = new Robj();
    	String tableReq = req.getParameter("table");
    	String table = Dbservice.getTableName(tableReq);
    	Object model = Common.getByRequest(Dbtablemapping.getModelByTable(table), req, false);
    	try {
    		String sql = dbm.add(model, table);
    		databaseService.executeAction(sql);
		} catch (Exception e) {
			
			return "操作失败"+e.getMessage();
		}
    	
    	return "操作成功";
        
    }
    
    @RequestMapping(value = "/saveWithFile", produces = "text/plain; charset=utf-8", method = { RequestMethod.GET,
			RequestMethod.POST })
    @ResponseBody
    public String saveWithFile(@RequestParam(value = "file", required = false) MultipartFile[] files,HttpServletRequest req) {
    	Dbservice dbm = new Dbservice(databaseService);
		String rstr = "0";
    	try {
    		String fileNames=null;
    		if(files!=null && files.length>0){
    			long fn = files[0].getSize();
    			if(fn>1){
    				fileNames = Common.copyFile2Upload(files);
    			}
    			
    		}
    		String tableReq = req.getParameter("table");
    		String fileField = req.getParameter("fileName");
        	String table = Dbservice.getTableName(tableReq);
        	Object model = Common.getByRequestSetfile(Dbtablemapping.getModelByTable(table),fileField,fileNames, req, false);
    		String sql = dbm.save(model, table);
    		databaseService.executeAction(sql);
			/**
			 * 判断是否插入操作,如果是返回插入的id
			 */
			String id = req.getParameter("id");

			if(id==null || id.equals("")){
				List<Map<String, Object>> rlist = databaseService.find("select LAST_INSERT_ID() as lastId");
				if(rlist!=null){
					rstr = rlist.get(0).get("lastId")+"";
				}
			}else{
				rstr = id;
			}
		} catch (Exception e) {
			
			return "操作失败"+e.getMessage();
		}
    	
    	return rstr;
        
    }
    
    @RequestMapping(value = "/upload", produces = "text/plain; charset=utf-8", method = { RequestMethod.GET,
			RequestMethod.POST })
    @ResponseBody
    public String upload(@RequestParam(value = "file", required = false) MultipartFile[] files,HttpServletRequest req) {
    	String fileNames=null;
    	try {
    		if(files!=null && files.length>0){
    			fileNames = Common.copyFile2Upload(files);
    		}
    		
		} catch (Exception e) {
		}
    	return fileNames;
        
    }

	@RequestMapping(value = "/editorUpload", produces = "text/plain; charset=utf-8", method = { RequestMethod.GET,
			RequestMethod.POST })
	@ResponseBody
	public String editorUpload(@RequestParam(value = "file", required = false) MultipartFile[] files,HttpServletRequest req) {
		String fileNames=null;
		EditorUpload eu = new EditorUpload();
		eu.setErrno(0);
		try {
			if(files!=null && files.length>0){
				fileNames = Common.copyFile2Upload(files);
				ArrayList<String> nl = new ArrayList<String>();
				String[] fns = fileNames.split(",");
				for (int i = 0; i < fns.length; i++) {
					nl.add("upload/"+fns[i]);
				}
				eu.setData(nl);
			}

		} catch (Exception e) {
		}
		return JSON.toJSONString(eu);

	}
    
    @RequestMapping(value = "/createQrcode", produces = "text/plain; charset=utf-8", method = { RequestMethod.GET,
			RequestMethod.POST })
    @ResponseBody
    public String createQrcode(HttpServletRequest req) {
    	String fileNames="";
    	try {
    		String path = ResourceUtils.getURL("classpath:").getPath();
            String destPath = path+File.separator+"static"+File.separator+"upload"+File.separator;
            String content = req.getParameter("code");
        	fileNames=QRCodeUtil.encode(content, null, destPath, true);
		} catch (Exception e) {
			
		}
    	return fileNames;
        
    }
    
    @RequestMapping(value = "/createQrcodeJ", produces = "text/plain; charset=utf-8", method = { RequestMethod.GET,
			RequestMethod.POST })
    @ResponseBody
    public String createQrcodeJ(HttpServletRequest req) {
    	String fileNames="";
    	try {
    		String path = ResourceUtils.getURL("classpath:").getPath();
            String destPath = path+File.separator+"static"+File.separator+"upload"+File.separator;
            String content = req.getParameter("code");
        	fileNames=QRCodeUtil.encode(content, null, destPath, true);
		} catch (Exception e) {
			
		}
    	return renderJsonpString(fileNames, req);
    }
    
    private String renderJsonpString(String str,HttpServletRequest req){
    	Map<String,String> obj = new HashMap<>();
		obj.put("info", str);
		String callbackFunctionName = req.getParameter("callback");	
		String json = JSON.toJSONString(obj);
		String r = callbackFunctionName+"("+json+")";
		return r;
    }
    
    private String renderJsonp(Object obj,HttpServletRequest req){
		String callbackFunctionName = req.getParameter("callback");	
		String json = JSON.toJSONString(obj);
		String r = callbackFunctionName+"("+json+")";
		return r;
    }
    
    @RequestMapping(value = "/updateApp", produces = "text/plain; charset=utf-8", method = { RequestMethod.GET,
			RequestMethod.POST })
    @ResponseBody
    public String updateApp(HttpServletRequest req) {
    	Dbservice dbm = new Dbservice(databaseService);
    	//Robj robj = new Robj();
    	String table = Dbservice.getTableName(req.getParameter("table"));
    	String object = req.getParameter("object");
    	Object obj = Dbtablemapping.parseStringModel(object, table);
    	try {
    		String sql = dbm.update(obj, table);
    		databaseService.executeAction(sql);
		} catch (Exception e) {
			
			return "操作失败"+e.getMessage();
		}
    	
    	return "操作成功";
        
    }
    
    
    @RequestMapping(value = "/update", produces = "text/plain; charset=utf-8", method = { RequestMethod.GET,
			RequestMethod.POST })
    @ResponseBody
    public String update(HttpServletRequest req) {
    	Dbservice dbm = new Dbservice(databaseService);
    	//Robj robj = new Robj();
    	String tableReq = req.getParameter("table");
    	String table = Dbservice.getTableName(tableReq);
    	Object model = Common.getByRequest(Dbtablemapping.getModelByTable(table), req, false);
    	try {
    		String sql = dbm.update(model, table);
    		databaseService.executeAction(sql);
		} catch (Exception e) {
			
			return "操作失败"+e.getMessage();
		}
    	
    	return "操作成功";
        
    }
    
    @RequestMapping(value = "/updateSqlJ", produces = "text/plain; charset=utf-8", method = { RequestMethod.GET,
			RequestMethod.POST })
    @ResponseBody
    public String updateSqlJ(HttpServletRequest req) {
    	String sql = req.getParameter("sql");
    	try {
    		databaseService.executeAction(sql);
		} catch (Exception e) {
			
			return renderJsonpString("0", req);
		}
    	
    	return renderJsonpString("1", req);
        
    }
    
    @RequestMapping(value = "/listSqlJ", produces = "text/plain; charset=utf-8", method = { RequestMethod.GET,
			RequestMethod.POST })
    @ResponseBody
    public String listSqlJ(HttpServletRequest req) {
    	String sql = req.getParameter("sql");
    	List<Map<String,Object>> list = null;
    	try {
			list = databaseService.find(sql);
		} catch (Exception e) {
			
			e.printStackTrace();
		}  	
        return renderJsonp(list, req);
    }
    
    
    @RequestMapping(value = "/updateSql", produces = "text/plain; charset=utf-8", method = { RequestMethod.GET,
			RequestMethod.POST })
    @ResponseBody
    public String updateSql(HttpServletRequest req) {
    	String sql = req.getParameter("sql");
    	try {
    		databaseService.executeAction(sql);
		} catch (Exception e) {
			
			return "操作失败"+e.getMessage();
		}
    	
    	return "操作成功";
        
    }

	@RequestMapping(value = "/listSql", produces = "application/json; charset=utf-8", method = { RequestMethod.GET,
			RequestMethod.POST })
	@ResponseBody
	public List<Map<String,Object>> listSql(HttpServletRequest req) {
		String sql = req.getParameter("sql");
		List<Map<String,Object>> list = null;
		try {
			list = databaseService.find(sql);
		} catch (Exception e) {

			e.printStackTrace();
		}
		return list;
	}
    
    @RequestMapping(value = "/save", produces = "text/plain; charset=utf-8", method = { RequestMethod.GET,
			RequestMethod.POST })
    @ResponseBody
    public String save(HttpServletRequest req) {
    	Dbservice dbm = new Dbservice(databaseService);
    	//Robj robj = new Robj();
    	String tableReq = req.getParameter("table");
    	String table = Dbservice.getTableName(tableReq);
    	Object model = Common.getByRequest(Dbtablemapping.getModelByTable(table), req, false);
    	String rstr = "";
    	try {
    		String sql = dbm.save(model, table);
    		databaseService.executeAction(sql);
			/**
			 * 判断是否插入操作,如果是返回插入的id
			 */
			String id = req.getParameter("id");

			if(id==null || id.equals("")){
				List<Map<String, Object>> rlist = databaseService.find("select LAST_INSERT_ID() as lastId");
				if(rlist!=null){
					rstr = rlist.get(0).get("lastId")+"";
				}
			}else{
				rstr = id;
			}
		} catch (Exception e) {
			
			return "操作失败"+e.getMessage();
		}
    	
    	return rstr;
        
    }
    
    @RequestMapping(value = "/saveJ", produces = "text/plain; charset=utf-8", method = { RequestMethod.GET,
			RequestMethod.POST })
    @ResponseBody
    public String saveJ(HttpServletRequest req) {
    	Dbservice dbm = new Dbservice(databaseService);
    	//Robj robj = new Robj();
    	String tableReq = req.getParameter("table");
    	String table = Dbservice.getTableName(tableReq);
    	Object model = Common.getByRequest(Dbtablemapping.getModelByTable(table), req, false);
    	String rstr = "0";
    	try {
    		String sql = dbm.save(model, table);
    		databaseService.executeAction(sql);
    		/**
    		 * 判断是否插入操作,如果是返回插入的id
    		 */
    		String id = req.getParameter("id");
    		rstr = "1";
    		if(id==null || id.equals("")){
    			List<Map<String, Object>> rlist = databaseService.find("select LAST_INSERT_ID() as lastId");
    			if(rlist!=null){
    				rstr = rlist.get(0).get("lastId")+"";
    			}
    		}
		} catch (Exception e) {
			
			return renderJsonpString(rstr, req);
		}
    	
    	return renderJsonpString(rstr, req);
        
    }
    
    @RequestMapping(value = "/saveApp", produces = "text/plain; charset=utf-8", method = { RequestMethod.GET,
			RequestMethod.POST })
    @ResponseBody
    public String saveApp(HttpServletRequest req) {
    	Dbservice dbm = new Dbservice(databaseService);
    	//Robj robj = new Robj();
    	String table = Dbservice.getTableName(req.getParameter("table"));
    	String object = req.getParameter("object");
    	Object obj = Dbtablemapping.parseStringModel(object, table);
    	try {
    		String sql = dbm.save(obj, table);
    		databaseService.executeAction(sql);
		} catch (Exception e) {
			
			return "操作失败"+e.getMessage();
		}
    	
    	return "操作成功";
        
    }
    
    @RequestMapping(value = "/saveC", produces = "text/plain; charset=utf-8", method = { RequestMethod.GET,
			RequestMethod.POST })
    @ResponseBody
    public String saveC(HttpServletRequest req) {
    	Dbservice dbm = new Dbservice(databaseService);
    	//Robj robj = new Robj();
    	String table = Dbservice.getTableName(req.getParameter("table"));
    	String object = req.getParameter("object");
    	Object obj = Dbtablemapping.parseStringModel(object, table);
    	try {
    		String sql = dbm.save(obj, table);
    		databaseService.executeAction(sql);
		} catch (Exception e) {
			return renderJsonpString("操作失败"+e.getMessage(), req);
		}
    	
    	return renderJsonpString("1", req);
        
    }
    
   
    @RequestMapping(value = "/deleteApp", produces = "text/plain; charset=utf-8", method = { RequestMethod.GET,
			RequestMethod.POST })
    @ResponseBody
    public String deleteApp(HttpServletRequest req) {
    	Dbservice dbm = new Dbservice(databaseService);
    	//Robj robj = new Robj();
    	String table = Dbservice.getTableName(req.getParameter("table"));
    	String object = req.getParameter("object");
    	
    	if(StringUtil.isNotNullOrEmpty(object)){
    		try {
    			Object paramsObj = Dbtablemapping.parseStringModel(object, table);
        		String sql = dbm.delete(table,paramsObj);
        		databaseService.executeAction(sql);
    		} catch (Exception e) {
    			return "操作失败"+e.getMessage();
    		}
    	}
    	return "操作成功";
    }
    
    @RequestMapping(value = "/deleteC", produces = "text/plain; charset=utf-8", method = { RequestMethod.GET,
			RequestMethod.POST })
    @ResponseBody
    public String deleteC(HttpServletRequest req) {
    	Dbservice dbm = new Dbservice(databaseService);
    	//Robj robj = new Robj();
    	String table = Dbservice.getTableName(req.getParameter("table"));
    	String object = req.getParameter("object");
    	
    	if(StringUtil.isNotNullOrEmpty(object)){
    		try {
    			Object paramsObj = Dbtablemapping.parseStringModel(object, table);
        		String sql = dbm.delete(table,paramsObj);
        		databaseService.executeAction(sql);
    		} catch (Exception e) {
    			return renderJsonpString("操作失败"+e.getMessage(), req);
    		}
    	}
    	return renderJsonpString("1", req);
    }
    
    @RequestMapping(value = "/delete", produces = "text/plain; charset=utf-8", method = { RequestMethod.GET,
			RequestMethod.POST })
    @ResponseBody
    public String delete(HttpServletRequest req) {
    	Dbservice dbm = new Dbservice(databaseService);
    	//Robj robj = new Robj();
    	String table = Dbservice.getTableName(req.getParameter("table"));
    	Object model = Common.getByRequest(Dbtablemapping.getModelByTable(table), req, false);
		try {
    		String sql = dbm.delete(table,model);
    		databaseService.executeAction(sql);
		} catch (Exception e) {
			return "操作失败"+e.getMessage();
		}
    	
    	return "操作成功";
    }

    @RequestMapping(value = "/deleteJ", produces = "text/plain; charset=utf-8", method = { RequestMethod.GET,
			RequestMethod.POST })
    @ResponseBody
    public String deleteJ(HttpServletRequest req) {
    	Dbservice dbm = new Dbservice(databaseService);
    	//Robj robj = new Robj();
    	String table = Dbservice.getTableName(req.getParameter("table"));
    	Object model = Common.getByRequest(Dbtablemapping.getModelByTable(table), req, false);
		try {
    		String sql = dbm.delete(table,model);
    		databaseService.executeAction(sql);
		} catch (Exception e) {
			return renderJsonpString("操作失败"+e.getMessage(), req);
		}
    	
    	return renderJsonpString("1", req);
    }
}

六、论文参考 

七、源码获取:

 点赞、收藏、关注、评论啦。有任何问题欢迎咨询

👇🏻获取联系方式在文章末尾👇🏻

 

  • 22
    点赞
  • 11
    收藏
    觉得还不错? 一键收藏
  • 打赏
    打赏
  • 0
    评论
基于PHP的微信小程序教务管理系统设计实现,吴国辰。 教务管理系统是为了方便学校管理学生信息、教务信息等而开发系统。基于PHP和微信小程序开发的教务管理系统具有以下特点和功能。 首先,系统具有学生信息管理功能。学生可以通过微信小程序登录系统,查看个人信息、课程信息、成绩等。学生可以方便地查看自己的课程安排、考试成绩,并可以及时与教务部门联系。 其次,系统具有教师信息管理功能。教师可以通过微信小程序登录系统,查看自己所教授的课程信息、学生信息等。教师可以方便地发布课程公告、作业等,与学生进行交流和互动。 另外,系统还具有课程管理功能。教务部门可以通过微信小程序管理课程信息,包括课程设置、添加教师、安排上课时间和地点等。学生和教师可以通过小程序查询课程信息,方便快捷地了解课程安排。 还有,系统具有考试成绩管理功能。教务部门可以通过微信小程序录入学生的考试成绩,学生和教师可以通过小程序查询自己的考试成绩。系统可以智能统计和分析学生的成绩情况,方便教务部门进行学生成绩的管理和评价。 此外,系统还可以实现其他教务管理相关的功能,如请假管理、选课管理、宿舍管理等。 综上所述,基于PHP的微信小程序教务管理系统可以方便学校管理学生信息和教务信息,提高学生、教师和教务部门之间的沟通和交流效率。吴国辰的设计实现将着重于系统的稳定性、安全性和易用性,为用户提供便捷的教务管理服务。

“相关推荐”对你有帮助么?

  • 非常没帮助
  • 没帮助
  • 一般
  • 有帮助
  • 非常有帮助
提交
评论
添加红包

请填写红包祝福语或标题

红包个数最小为10个

红包金额最低5元

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

打赏作者

code.song

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

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

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

打赏作者

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

抵扣说明:

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

余额充值