DC00021基于springboot问卷调查管理系统web项目调查问卷管理系统MySQL（附源码）

1、项目功能演示

DC00021基于springboot问卷调查管理系统web项目调查问卷管理系统MySQL

2、项目功能描述

基于springboot问卷调查管理系统包括以下功能：
1、系统登录、系统注册
2、创建题目、题目信息查看
3、创建问卷、我的问卷信息查看
4、创建活动、我的活动信息查看
5、参与调查

3、项目功能截图

4、项目核心代码

4.1 pom.xml

<?xml version="1.0" encoding="UTF-8"?>
<project xmlns="http://maven.apache.org/POM/4.0.0" xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance"xsi:schemaLocation="http://maven.apache.org/POM/4.0.0 https://maven.apache.org/xsd/maven-4.0.0.xsd"><modelVersion>4.0.0</modelVersion><parent><groupId>org.springframework.boot</groupId><artifactId>spring-boot-starter-parent</artifactId><version>2.7.0</version><relativePath/> <!-- lookup parent from repository --></parent><groupId>com.peixinchen</groupId><artifactId>survey</artifactId><version>0.0.1-SNAPSHOT</version><name>survey</name><description>Demo project for Spring Boot</description><properties><java.version>1.8</java.version></properties><dependencies><dependency><groupId>org.springframework.boot</groupId><artifactId>spring-boot-starter-web</artifactId></dependency><dependency><groupId>org.springframework.boot</groupId><artifactId>spring-boot-devtools</artifactId><scope>runtime</scope><optional>true</optional></dependency><dependency><groupId>org.springframework.boot</groupId><artifactId>spring-boot-starter-thymeleaf</artifactId></dependency><dependency><groupId>org.springframework.boot</groupId><artifactId>spring-boot-starter-data-jdbc</artifactId></dependency><dependency><groupId>mysql</groupId><artifactId>mysql-connector-java</artifactId></dependency><dependency><groupId>org.projectlombok</groupId><artifactId>lombok</artifactId><optional>true</optional></dependency><dependency><groupId>org.springframework.boot</groupId><artifactId>spring-boot-starter-test</artifactId><scope>test</scope></dependency><dependency><groupId>org.springframework</groupId><artifactId>spring-beans</artifactId><version>5.3.21</version></dependency></dependencies><build><plugins><plugin><groupId>org.springframework.boot</groupId><artifactId>spring-boot-maven-plugin</artifactId><configuration><excludes><exclude><groupId>org.projectlombok</groupId><artifactId>lombok</artifactId></exclude></excludes></configuration></plugin></plugins></build></project>

4.2 AppConfig.java

package com.project.survey;import com.fasterxml.jackson.databind.ObjectMapper;
import com.mysql.cj.jdbc.MysqlDataSource;
import org.springframework.context.annotation.Bean;
import org.springframework.context.annotation.Configuration;
import org.springframework.core.env.Environment;
import org.springframework.jdbc.core.namedparam.NamedParameterJdbcTemplate;import javax.sql.DataSource;
import java.sql.SQLException;@Configuration
public class AppConfig {@Beanpublic DataSource dataSource(Environment environment) throws SQLException {String url = environment.getProperty("spring.datasource.url");String username = environment.getProperty("spring.datasource.username");String password = environment.getProperty("spring.datasource.password");MysqlDataSource db = new MysqlDataSource();db.setUrl(url);db.setUser(username);db.setPassword(password);return db;}@Beanpublic NamedParameterJdbcTemplate namedParameterJdbcTemplate(DataSource dataSource) {return new NamedParameterJdbcTemplate(dataSource);}@Beanpublic ObjectMapper objectMapper() {return new ObjectMapper();}
}