基于微信小程序的问卷调查小程序设计与实现

收藏关注不迷路！！

🌟文末获取源码+数据库🌟

感兴趣的可以先收藏起来，还有大家在毕设选题（免费咨询指导选题），项目以及论文编写等相关问题都可以给我留言咨询，希望帮助更多的人

---

前言

💗博主介绍：✨全网粉丝10W+,CSDN特邀作者、博客专家、CSDN新星计划导师，专注于Java/Python/小程序app/深度学习等计算机设计，主要对象是咱们计算机相关专业的大学生，希望您们都能前途无量！✨💗

👇🏻 精彩专栏 推荐订阅👇🏻

计算机毕业设计设计精品实战案例✅

感兴趣的可以先收藏起来，还有大家在毕设选题，项目以及论文编写等相关问题都可以给我留言咨询，希望帮助更多的人

  

程序资料获取

🌟文末获取资料🌟

一、项目技术

开发语言：Java
框架：springboot
JDK版本：JDK1.8
服务器：tomcat7
数据库：mysql
数据库工具：Navicat11
开发软件：eclipse/myeclipse/idea
Maven包：Maven
小程序框架：uniapp
小程序开发软件：HBuilder X
小程序运行软件：微信开发者

二、项目内容和功能介绍

  🎈1.项目内容

  基于微信小程序的问卷调查小程序的设计与实现是一个结合了现代移动互联网技术和用户需求的创新项目。以下是对该项目的详细介绍：

设计背景
随着移动互联网技术的飞速发展和智能手机的普及，微信作为国内领先的即时通讯工具，其用户基数日益庞大。微信小程序以其无需下载安装、即用即走的便捷性，迅速成为连接用户与服务的新型应用生态。传统问卷调查方式存在数据收集效率低、处理繁琐等问题，难以满足现代社会高效信息收集与处理的需求。因此，设计和实现一个基于微信小程序的问卷调查系统显得尤为重要。

  🎈2.功能介绍

  1.管理员可实现用户管理，问卷管理，问卷模板的创建与删除，问卷信息统计
2.发布问卷的用户通过小程序可以自行发布问卷，也可以对已有模板进行修改自定义问卷，并可以查看自己所发行问卷的详细信息进行统计。
3.填写问卷的用户可正确注册，填写问卷，分享问卷。

三、核心代码

部分代码：

package com.controller;


import java.util.Arrays;
import java.util.Map;

import org.springframework.beans.factory.annotation.Autowired;
import org.springframework.web.bind.annotation.PathVariable;
import org.springframework.web.bind.annotation.PostMapping;
import org.springframework.web.bind.annotation.RequestBody;
import org.springframework.web.bind.annotation.RequestMapping;
import org.springframework.web.bind.annotation.RequestParam;
import org.springframework.web.bind.annotation.RestController;

import com.annotation.IgnoreAuth;
import com.baomidou.mybatisplus.mapper.EntityWrapper;
import com.entity.ConfigEntity;
import com.service.ConfigService;
import com.utils.MPUtil;
import com.utils.PageUtils;
import com.utils.R;
import com.utils.ValidatorUtils;

/**
 * 登录相关
 */
@RequestMapping("config")
@RestController
public class ConfigController{
	
	@Autowired
	private ConfigService configService;

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

    /**
     * 信息
     */
    @RequestMapping("/info/{id}")
    public R info(@PathVariable("id") String id){
        ConfigEntity config = configService.selectById(id);
        return R.ok().put("data", config);
    }
    
    /**
     * 详情
     */
    @IgnoreAuth
    @RequestMapping("/detail/{id}")
    public R detail(@PathVariable("id") String id){
        ConfigEntity config = configService.selectById(id);
        return R.ok().put("data", config);
    }
    
    /**
     * 根据name获取信息
     */
    @RequestMapping("/info")
    public R infoByName(@RequestParam String name){
        ConfigEntity config = configService.selectOne(new EntityWrapper<ConfigEntity>().eq("name", "faceFile"));
        return R.ok().put("data", config);
    }
    
    /**
     * 保存
     */
    @PostMapping("/save")
    public R save(@RequestBody ConfigEntity config){
//    	ValidatorUtils.validateEntity(config);
    	configService.insert(config);
        return R.ok();
    }

    /**
     * 修改
     */
    @RequestMapping("/update")
    public R update(@RequestBody ConfigEntity config){
//        ValidatorUtils.validateEntity(config);
        configService.updateById(config);//全部更新
        return R.ok();
    }

    /**
     * 删除
     */
    @RequestMapping("/delete")
    public R delete(@RequestBody Long[] ids){
    	configService.deleteBatchIds(Arrays.asList(ids));
        return R.ok();
    }
}

数据库参考

-- ----------------------------
-- Table structure for wj_voterecord
-- ----------------------------
DROP TABLE IF EXISTS `wj_voterecord`;
CREATE TABLE `wj_voterecord`  (
  `id` bigint(20) NOT NULL AUTO_INCREMENT COMMENT '投票记录',
  `state` int(2) NULL DEFAULT 1,
  `createTime` timestamp(0) NOT NULL DEFAULT CURRENT_TIMESTAMP(0) ON UPDATE CURRENT_TIMESTAMP(0),
  `voteId` bigint(20) NULL DEFAULT NULL COMMENT '投票id',
  `wxUserId` bigint(20) NULL DEFAULT NULL COMMENT '投票人',
  `candidateId` bigint(20) NULL DEFAULT NULL COMMENT '候选项id',
  `comment` varchar(32) CHARACTER SET utf8 COLLATE utf8_bin NULL DEFAULT NULL COMMENT '评论  没用到',
  `useless` bigint(20) NULL DEFAULT NULL COMMENT '没用 数量没用到',
  `fabulous` bigint(20) NULL DEFAULT NULL COMMENT '赞 数量 没用到',
  `ipAddress` varchar(32) CHARACTER SET utf8 COLLATE utf8_bin NULL DEFAULT NULL COMMENT 'ip地址',
  `province` varchar(64) CHARACTER SET utf8 COLLATE utf8_bin NULL DEFAULT NULL COMMENT '省份',
  `city` varchar(64) CHARACTER SET utf8 COLLATE utf8_bin NULL DEFAULT NULL COMMENT '城市',
  `district` varchar(62) CHARACTER SET utf8 COLLATE utf8_bin NULL DEFAULT NULL COMMENT '区县',
  `street` varchar(256) CHARACTER SET utf8 COLLATE utf8_bin NULL DEFAULT NULL COMMENT '街道',
  `streetNumber` varchar(32) CHARACTER SET utf8 COLLATE utf8_bin NULL DEFAULT NULL COMMENT '街道号',
  `latitude` varchar(32) CHARACTER SET utf8 COLLATE utf8_bin NULL DEFAULT NULL COMMENT '维度',
  `longitude` varchar(32) CHARACTER SET utf8 COLLATE utf8_bin NULL DEFAULT NULL COMMENT '经度',
  INDEX `id`(`id`) USING BTREE
) ENGINE = InnoDB AUTO_INCREMENT = 15 CHARACTER SET = utf8 COLLATE = utf8_bin ROW_FORMAT = Dynamic;

-- ----------------------------
-- Records of wj_voterecord
-- ----------------------------
INSERT INTO `wj_voterecord` VALUES (3, 1, '2019-05-09 16:27:27', 5, 4, 19, NULL, NULL, NULL, '192.168.43.233', NULL, NULL, NULL, NULL, NULL, NULL, NULL);
INSERT INTO `wj_voterecord` VALUES (4, 1, '2019-05-09 21:25:06', 5, 4, 24, NULL, NULL, NULL, '192.168.43.233', NULL, NULL, NULL, NULL, NULL, NULL, NULL);
INSERT INTO `wj_voterecord` VALUES (5, 1, '2019-05-09 21:26:51', 5, 4, 24, NULL, NULL, NULL, '192.168.43.233', '河北', '保定', '南市区', '创业东路', 'undefined', '38.8520393371582', '115.48519134521484');
INSERT INTO `wj_voterecord` VALUES (6, 1, '2019-05-09 21:27:23', 5, 4, 24, NULL, NULL, NULL, '192.168.43.233', '河北', '保定', '南市区', '创业东路', 'undefined', '38.8520393371582', '115.48519134521484');
INSERT INTO `wj_voterecord` VALUES (7, 1, '2019-05-09 21:27:55', 5, 4, 19, NULL, NULL, NULL, '192.168.43.233', '河北', '保定', '南市区', '创业东路', 'undefined', '38.8520393371582', '115.48519134521484');
INSERT INTO `wj_voterecord` VALUES (8, 1, '2019-05-09 21:31:00', 5, 4, 19, NULL, NULL, NULL, '192.168.43.233', '河北', '保定', '南市区', '创业东路', 'undefined', '38.8520393371582', '115.48519134521484');
INSERT INTO `wj_voterecord` VALUES (9, 1, '2019-05-22 00:56:37', 5, 4, 19, NULL, NULL, NULL, '192.168.43.233', '河北', '保定', '南市区', '林荫路', 'undefined', '38.85308837890625', '115.4848403930664');
INSERT INTO `wj_voterecord` VALUES (10, 1, '2019-05-25 11:15:54', 9, 1, 33, NULL, NULL, NULL, '192.168.1.103', '河北', '保定', '南市区', '创业东路', 'undefined', '38.85172200520833', '115.48505805121528');
INSERT INTO `wj_voterecord` VALUES (11, 1, '2019-05-25 11:18:13', 9, 1, 30, NULL, NULL, NULL, '192.168.1.103', '河北', '保定', '南市区', '创业东路', 'undefined', '38.85172200520833', '115.48505805121528');
INSERT INTO `wj_voterecord` VALUES (12, 1, '2019-05-30 10:57:09', 16, 1, 65, NULL, NULL, NULL, '192.168.43.1', '河北', '保定', '南市区', '创业东路', 'undefined', '38.85172200520833', '115.48505805121528');
INSERT INTO `wj_voterecord` VALUES (13, 1, '2019-05-30 11:38:45', 16, 9, 65, NULL, NULL, NULL, '192.168.43.217', '河北', '保定', '新市区', '东风西路', 'undefined', '38.87396', '115.46459');
INSERT INTO `wj_voterecord` VALUES (14, 1, '2024-04-09 23:12:24', 19, 16, 83, NULL, NULL, NULL, '0:0:0:0:0:0:0:1', NULL, NULL, NULL, NULL, NULL, NULL, NULL);

-- ----------------------------
-- Table structure for wx_param
-- ----------------------------
DROP TABLE IF EXISTS `wx_param`;
CREATE TABLE `wx_param`  (
  `id` bigint(20) NOT NULL AUTO_INCREMENT,
  `accessToken` varchar(255) CHARACTER SET utf8 COLLATE utf8_bin NULL DEFAULT NULL,
  `appId` varchar(255) CHARACTER SET utf8 COLLATE utf8_bin NULL DEFAULT NULL,
  `appSecret` varchar(255) CHARACTER SET utf8 COLLATE utf8_bin NULL DEFAULT NULL,
  `createTime` timestamp(0) NULL DEFAULT CURRENT_TIMESTAMP(0),
  `keyPath` varchar(255) CHARACTER SET utf8 COLLATE utf8_bin NULL DEFAULT NULL,
  `mchId` varchar(255) CHARACTER SET utf8 COLLATE utf8_bin NULL DEFAULT NULL,
  `mchKey` varchar(255) CHARACTER SET utf8 COLLATE utf8_bin NULL DEFAULT NULL,
  `mpAccessToken` varchar(255) CHARACTER SET utf8 COLLATE utf8_bin NULL DEFAULT NULL,
  `mpAppId` varchar(255) CHARACTER SET utf8 COLLATE utf8_bin NULL DEFAULT NULL,
  `mpAppSecret` varchar(255) CHARACTER SET utf8 COLLATE utf8_bin NULL DEFAULT NULL,
  `mpMchId` varchar(255) CHARACTER SET utf8 COLLATE utf8_bin NULL DEFAULT NULL,
  `mpMchKey` varchar(255) CHARACTER SET utf8 COLLATE utf8_bin NULL DEFAULT NULL,
  `projectType` int(11) NULL DEFAULT NULL,
  `state` int(11) NULL DEFAULT 1,
  PRIMARY KEY (`id`) USING BTREE
) ENGINE = InnoDB AUTO_INCREMENT = 2 CHARACTER SET = utf8 COLLATE = utf8_bin ROW_FORMAT = Dynamic;

-- ----------------------------
-- Records of wx_param
-- ----------------------------
INSERT INTO `wx_param` VALUES (1, '21_nmx_iG0YnKnz7092PNnNRajsHScroNchEcTnOY2hPTBDajDvi4cVqI27fXv3sUXN6sNkQey3SzkNTRPJlimvQr6zdqSmcm-YkJW63RpTwnazE9dYbzi-AAPi4fOy84BjVIwJgoIbsTJVujP6VFTiAHAMWK', 'wx9180ac50f7edd1bf', '1dc81bd1c2ca103b08e67dc629a0b6e1', '2019-05-01 23:53:09', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, 1);

-- ----------------------------
-- Table structure for wx_user
-- ----------------------------
DROP TABLE IF EXISTS `wx_user`;
CREATE TABLE `wx_user`  (
  `id` bigint(20) NOT NULL AUTO_INCREMENT,
  `avatarUrl` varchar(255) CHARACTER SET utf8 COLLATE utf8_bin NULL DEFAULT NULL,
  `city` varchar(255) CHARACTER SET utf8 COLLATE utf8_bin NULL DEFAULT NULL,
  `country` varchar(255) CHARACTER SET utf8 COLLATE utf8_bin NULL DEFAULT NULL,
  `createTime` timestamp(0) NULL DEFAULT CURRENT_TIMESTAMP(0),
  `gender` int(11) NOT NULL,
  `nickName` varchar(255) CHARACTER SET utf8 COLLATE utf8_bin NULL DEFAULT NULL,
  `openid` varchar(255) CHARACTER SET utf8 COLLATE utf8_bin NULL DEFAULT NULL,
  `phone` varchar(255) CHARACTER SET utf8 COLLATE utf8_bin NULL DEFAULT NULL,
  `province` varchar(255) CHARACTER SET utf8 COLLATE utf8_bin NULL DEFAULT NULL,
  `realName` varchar(255) CHARACTER SET utf8 COLLATE utf8_bin NULL DEFAULT NULL,
  `state` int(11) NULL DEFAULT 1,
  `userType` varchar(255) CHARACTER SET utf8 COLLATE utf8_bin NULL DEFAULT NULL,
  `subscriberId` bigint(20) NULL DEFAULT NULL COMMENT 'subscriber前台用户的id',
  PRIMARY KEY (`id`) USING BTREE
) ENGINE = InnoDB AUTO_INCREMENT = 17 CHARACTER SET = utf8 COLLATE = utf8_bin ROW_FORMAT = Dynamic;

-- ----------------------------
-- Records of wx_user
-- ----------------------------
INSERT INTO `wx_user` VALUES (1, 'https://wx.qlogo.cn/mmopen/vi_32/3CG1Xd5HonsxlThicwd4ARJXaAVMibwqqvlxDcw8OurSHysg9WFQyCFvKE7YtKYF8hXE8B1cZicw1KSrgVPU3SAxw/132', '石家庄', '中国', '2019-05-02 00:06:54', 1, '失败女神', 'oxzbz0B0qjuvBm5Yy-7lyFurJnLU', '18733123202', '河北', '崔胜利', 1, NULL, 1);
INSERT INTO `wx_user` VALUES (4, 'https://wx.qlogo.cn/mmopen/vi_32/AtpiaIEy1cCoQNvxG63gKWeUzAlznQOO3dfY6N1ZCbMZ3lQUrhhTq2QfXZ0LOMiacmKA8KCPugv8eludA0VHvsOg/132', '石家庄', '中国', '2019-05-03 01:10:55', 1, '三水', 'oxzbz0EMXhbtu9bxtC9_oxXegOho', '18733123202', '河北', '三水', 1, NULL, 4);
INSERT INTO `wx_user` VALUES (5, 'https://timgsa.baidu.com/timg?image&quality=80&size=b9999_10000&sec=1558532627652&di=ff3c5bc707011aa31a5e17ce92f32f33&imgtype=0&src=http%3A%2F%2Fhbimg.b0.upaiyun.com%2Fefc9330a9ec75d2b8bb3feef9b9959381b8bef595f586-WHB04E_fw658', '石家庄', '中国', '2019-05-22 15:51:13', 1, '邵腾', 'oxzbz0Nkq1MN0_tYYpHD_WNCb8nI', '18733123202', '河北', '少腾', 1, NULL, 5);
INSERT INTO `wx_user` VALUES (6, 'https://wx.qlogo.cn/mmopen/vi_32/BvFcZlEEEjwNXA0aEhp6sqwJ3fvWia4zKyIPqNFsdbdLzNZhXhyUfVwGF2vDRILkyNViaGO5wsNhM3vjiaOouKOLg/132', '朝阳', '中国', '2019-05-23 11:12:08', 1, '曹哲', 'oxzbz0JfxAT9dQOsl7CLfQ1VWy2g', '18733123202', '北京', '曹哲', 1, NULL, 6);
INSERT INTO `wx_user` VALUES (8, 'https://wx.qlogo.cn/mmopen/vi_32/Q0j4TwGTfTJnicGKFxI7sf3FyeAAiblXp6TCw6KcmqvlNP8gwCbRcrvsnKbuibSIBk0RYkCCTxJmf1O2L8iaHibxibibw/132', '秦皇岛', '中国', '2019-05-23 13:01:20', 1, '阳仔', 'oxzbz0MObA25_Lp8NuhMuOTB_ok0', '18733123202', '河北', '阳仔', 1, NULL, 8);
INSERT INTO `wx_user` VALUES (9, 'https://wx.qlogo.cn/mmopen/vi_32/Q0j4TwGTfTLX3ObF3UaLU9OhRU0DaBZcta5PicPrMz9wqF3IAN9Vg8uVNdljKsWiabHW3AxQEx676XrcLb80icDbg/132', '石家庄', '中国', '2019-05-30 11:33:16', 1, '别惊动我体内的学霸', 'oxzbz0Cwspe8SBOqAoKyzQEs1JhA', '18631181417', '河北', '学霸', 1, NULL, 9);
INSERT INTO `wx_user` VALUES (10, 'https://wx.qlogo.cn/mmopen/vi_32/Q0j4TwGTfTJBpvBATibunQDpy7zK17RzatpoDKMlvmKQeoIMRCKHuwlqK1mHibrtk15rvjT4E9WfChUb8FOiaxhJQ/132', '张家口', '中国', '2019-05-30 12:48:07', 1, '辯論', 'oxzbz0BFhE-13x00gU0_s8BtXN3E', '18733123202', '河北', '小轮', 1, NULL, 10);
INSERT INTO `wx_user` VALUES (11, 'https://wx.qlogo.cn/mmopen/vi_32/DYAIOgq83eodOscLlxBFVWSk0AwQqJ0NsVwdeBa8UEnczJF7JKFIW4G3y3XG5h1h2eBsC6BgKX9bf2xkot3UoA/132', '四平', '中国', '2019-05-30 13:02:18', 1, '视频', 'oxzbz0LAy6MXwRaC6ArC8zY5tALM', '18733123202', '吉林', '天宇', 1, NULL, 11);
INSERT INTO `wx_user` VALUES (12, 'https://wx.qlogo.cn/mmopen/vi_32/Q0j4TwGTfTJd3TzE6pictfQDwByYKEbuQr0icOdQDdxicKrDBBrVuQXC45MppH95noP8rrrBwwhUnz70aXiaNyLGoA/132', '邯郸', '中国', '2019-05-30 14:50:26', 1, 'Lost_stars', 'oxzbz0PJ0-IHzJgM-ldIUr6GtSPs', '18733123202', '河北', '云浩', 1, NULL, 12);
INSERT INTO `wx_user` VALUES (13, 'https://wx.qlogo.cn/mmopen/vi_32/w42gTDypwkhrX9zRhUoVH0V77eAvAwygW3jojHzVBcLooRMqyXVOznfCNCdOia6J4vlQyibC3dTUufbRQIibLvMqg/132', '', '阿拉伯联合酋长国', '2019-05-30 15:49:36', 2, 'F君', 'oxzbz0GVUseKgDbKFqkQ_nKfryIk', '13333333333', '迪拜', '冯风', 1, NULL, 13);
INSERT INTO `wx_user` VALUES (14, 'https://wx.qlogo.cn/mmopen/vi_32/sYTDIMJhSsyFz6QM29T64nRqwZ5GNTc4icyfdOfdPSbU3ruBsEkOibLfx59yoiaMHpbXYesEMGK70licrTus1lRsOg/132', '', '', '2019-05-30 15:50:46', 0, '毛小陶', 'oxzbz0JTNifvIZd6FOxIzRhEfxqo', '18733123202', '', '柳柳', 1, NULL, 14);
INSERT INTO `wx_user` VALUES (15, 'https://wx.qlogo.cn/mmopen/vi_32/HXBGQaichlpvcLFibLVxRQE0WEDeQ8Q6VzC0feMx6Vgic3oicFYFX01Jfia2zdkA6mreuVcFJgIEX3IpdvztTqhbRlg/132', '秦皇岛', '中国', '2019-05-30 15:52:10', 2, '小小的我', 'oxzbz0HFGmePqsUfSyi7t6Zlr99s', '18732187200', '河北', '啦啦啦', 1, NULL, 15);
INSERT INTO `wx_user` VALUES (16, 'https://thirdwx.qlogo.cn/mmopen/vi_32/LsGv43H1OBhLWjXRuqZLXJXhWcCTDoibMy4mW2umSofmiarp4X7nSz0MEZlD3ZNfvhXJmulBYdDVwPvnickTDst8HHu2v1BObNWEUgHAg5IRV4/132', '', '', '2024-04-09 22:55:16', 0, '贝公子', 'undefined', '13527126256', '', '妥妥', 1, NULL, 16);

SET FOREIGN_KEY_CHECKS = 1;

四、效果图

五 、资料获取

文章下方名片联系我即可~

精彩专栏推荐订阅：在下方专栏👇🏻

毕业设计精品实战案例

收藏关注不迷路！！

🌟文末获取设计🌟