摘 要

隨著信息技術(shù)和網(wǎng)絡(luò)技術(shù)的飛速發(fā)展，人類已進(jìn)入全新信息化時(shí)代，傳統(tǒng)管理技術(shù)已無法高效，便捷地管理信息。為了迎合時(shí)代需求，優(yōu)化管理效率，各種各樣的管理系統(tǒng)應(yīng)運(yùn)而生，各行各業(yè)相繼進(jìn)入信息管理時(shí)代，廣場(chǎng)舞團(tuán)就是信息時(shí)代變革中的產(chǎn)物之一。

任何系統(tǒng)都要遵循系統(tǒng)設(shè)計(jì)的基本流程，本系統(tǒng)也不例外，同樣需要經(jīng)過市場(chǎng)調(diào)研，需求分析，概要設(shè)計(jì)，詳細(xì)設(shè)計(jì)，編碼，測(cè)試這些步驟，基于java語言設(shè)計(jì)并實(shí)現(xiàn)了廣場(chǎng)舞團(tuán)。該系統(tǒng)基于B/S即所謂瀏覽器/服務(wù)器模式，應(yīng)用java技術(shù)，選擇MySQL作為后臺(tái)數(shù)據(jù)庫。系統(tǒng)主要包括系統(tǒng)首頁，社團(tuán)，社團(tuán)活動(dòng)，交流中心，公告資訊，個(gè)人中心，后臺(tái)管理等功能模塊。

本文首先介紹了廣場(chǎng)舞團(tuán)管理的技術(shù)發(fā)展背景與發(fā)展現(xiàn)狀，然后遵循軟件常規(guī)開發(fā)流程，首先針對(duì)系統(tǒng)選取適用的語言和開發(fā)平臺(tái)，根據(jù)需求分析制定模塊并設(shè)計(jì)數(shù)據(jù)庫結(jié)構(gòu)，再根據(jù)系統(tǒng)總體功能模塊的設(shè)計(jì)繪制系統(tǒng)的功能模塊圖，流程圖以及E-R圖。然后，設(shè)計(jì)框架并根據(jù)設(shè)計(jì)的框架編寫代碼以實(shí)現(xiàn)系統(tǒng)的各個(gè)功能模塊。最后，對(duì)初步完成的系統(tǒng)進(jìn)行測(cè)試，主要是功能測(cè)試、單元測(cè)試和性能測(cè)試。測(cè)試結(jié)果表明，該系統(tǒng)能夠?qū)崿F(xiàn)所需的功能，運(yùn)行狀況尚可并無明顯缺點(diǎn)。

關(guān)鍵詞：廣場(chǎng)舞團(tuán)；java；MySQL數(shù)據(jù)庫

?

Abstract

With the rapid development of information technology and network technology, mankind has entered a new era of information technology, and traditional management technology has been unable to manage information efficiently and conveniently. In order to meet the needs of the times and optimize management efficiency, a variety of management systems came into being, and all walks of life have entered the era of information management, and square dance troupes are one of the products of the change in the information age.

Any system must follow the basic process of system design, this system is no exception, the same need to go through market research, requirements analysis, outline design, detailed design, coding, testing these steps, based on the Java language design and the realization of square dance troupe. The system is based on B/S, the so-called browser/server model, which applies Java technology and selects MySQL as the background database. The system mainly includes functional modules such as system homepage, community, community activities, communication center, announcement information, personal center, background management and so on.

This article first introduces the technical development background and development status of square dance troupe management, and then follows the conventional development process of the software, first selects the applicable language and development platform for the system, formulates the module and designs the database structure according to the requirements analysis, and then draws the functional module diagram, flow chart and E-R diagram of the system according to the design of the overall functional module of the system. Then, design the framework and write code based on the designed framework to implement the various functional modules of the system. Finally, the initially completed system is tested, mainly functional, unit, and performance tests. The test results show that the system can achieve the required functions, and the operating conditions are not obvious.

Keywords: square dance troupe; java; MySQL database

?

目錄

1 緒論 1

1.1 課題背景 1

1.2 課題研究現(xiàn)狀 1

1.3 初步設(shè)計(jì)方法與實(shí)施方案 2

1.4 本文研究?jī)?nèi)容 2

2 系統(tǒng)開發(fā)環(huán)境 4

2.1 Java技術(shù) 4

2.2SpringBoot框架 4

2.3 B/S模式 4

2.4MyEclipse環(huán)境配置 5

2.5MySQL環(huán)境配置 5

3 系統(tǒng)分析 6

3.1 系統(tǒng)可行性分析 6

3.1.1 經(jīng)濟(jì)可行性 6

3.1.2 技術(shù)可行性 6

3.1.3 運(yùn)行可行性 6

3.2 系統(tǒng)現(xiàn)狀分析 6

3.3 功能需求分析 7

3.4 系統(tǒng)設(shè)計(jì)規(guī)則與運(yùn)行環(huán)境 8

3.5系統(tǒng)流程分析 9

3.5.1操作流程 9

3.5.2添加信息流程 9

3.5.3刪除信息流程 10

4 系統(tǒng)設(shè)計(jì) 11

4.1 系統(tǒng)設(shè)計(jì)主要功能 11

4.2 數(shù)據(jù)庫設(shè)計(jì) 11

4.2.1 數(shù)據(jù)庫設(shè)計(jì)規(guī)范 11

4.2.2 E-R圖 12

4.2.3 數(shù)據(jù)表 13

5 系統(tǒng)實(shí)現(xiàn) 19

5.1? 系統(tǒng)功能模塊 19

5.2? 后臺(tái)登錄模塊 20

5.2.1管理員功能模塊 21

5.2.2社團(tuán)功能模塊 24

5.2.3用戶功能模塊 25

6 系統(tǒng)測(cè)試 26

6.1 功能測(cè)試 26

6.2 可用性測(cè)試 26

6.3 維護(hù)測(cè)試 27

6.4 性能測(cè)試 27

6.5 測(cè)試結(jié)果分析 28

結(jié) 論 29

參考文獻(xiàn) 30

致 謝 31

關(guān)鍵代碼：

/**

?* 成員信息

?* 后端接口

?* @author?

?* @email?

?* @date 2022-03-13 19:21:35

?*/

@RestController

@RequestMapping("/chengyuanxinxi")

public class ChengyuanxinxiController {

? ? @Autowired

? ? private ChengyuanxinxiService chengyuanxinxiService;

? ??

? ? /**

? ? ?* 后端列表

? ? ?*/

? ? @RequestMapping("/page")

? ? public R page(@RequestParam Map<String, Object> params,ChengyuanxinxiEntity chengyuanxinxi,

? ? ? ? ? ? ? ? @RequestParam(required = false) @DateTimeFormat(pattern="yyyy-MM-dd") Date shenqingriqistart,

? ? ? ? ? ? ? ? @RequestParam(required = false) @DateTimeFormat(pattern="yyyy-MM-dd") Date shenqingriqiend,

HttpServletRequest request){

String tableName = request.getSession().getAttribute("tableName").toString();

if(tableName.equals("shetuan")) {

chengyuanxinxi.setShetuanbianhao((String)request.getSession().getAttribute("username"));

}

if(tableName.equals("yonghu")) {

chengyuanxinxi.setYonghuming((String)request.getSession().getAttribute("username"));

}

? ? ? ? EntityWrapper<ChengyuanxinxiEntity> ew = new EntityWrapper<ChengyuanxinxiEntity>();

? ? ? ? ? ? ? ? if(shenqingriqistart!=null) ew.ge("shenqingriqi", shenqingriqistart);

? ? ? ? ? ? ? ? if(shenqingriqiend!=null) ew.le("shenqingriqi", shenqingriqiend);

PageUtils page = chengyuanxinxiService.queryPage(params, MPUtil.sort(MPUtil.between(MPUtil.likeOrEq(ew, chengyuanxinxi), params), params));

? ? ? ? return R.ok().put("data", page);

? ? }

? ??

? ? /**

? ? ?* 前端列表

? ? ?*/

@IgnoreAuth

? ? @RequestMapping("/list")

? ? public R list(@RequestParam Map<String, Object> params,ChengyuanxinxiEntity chengyuanxinxi,?

? ? ? ? ? ? ? ? @RequestParam(required = false) @DateTimeFormat(pattern="yyyy-MM-dd") Date shenqingriqistart,

? ? ? ? ? ? ? ? @RequestParam(required = false) @DateTimeFormat(pattern="yyyy-MM-dd") Date shenqingriqiend,

HttpServletRequest request){

? ? ? ? EntityWrapper<ChengyuanxinxiEntity> ew = new EntityWrapper<ChengyuanxinxiEntity>();

? ? ? ? ? ? ? ? if(shenqingriqistart!=null) ew.ge("shenqingriqi", shenqingriqistart);

? ? ? ? ? ? ? ? if(shenqingriqiend!=null) ew.le("shenqingriqi", shenqingriqiend);

PageUtils page = chengyuanxinxiService.queryPage(params, MPUtil.sort(MPUtil.between(MPUtil.likeOrEq(ew, chengyuanxinxi), params), params));

? ? ? ? return R.ok().put("data", page);

? ? }

/**

? ? ?* 列表

? ? ?*/

? ? @RequestMapping("/lists")

? ? public R list( ChengyuanxinxiEntity chengyuanxinxi){

? ? ? ? EntityWrapper<ChengyuanxinxiEntity> ew = new EntityWrapper<ChengyuanxinxiEntity>();

? ? ? ew.allEq(MPUtil.allEQMapPre( chengyuanxinxi, "chengyuanxinxi"));?

? ? ? ? return R.ok().put("data", chengyuanxinxiService.selectListView(ew));

? ? }

/**

? ? ?* 查詢

? ? ?*/

? ? @RequestMapping("/query")

? ? public R query(ChengyuanxinxiEntity chengyuanxinxi){

? ? ? ? EntityWrapper< ChengyuanxinxiEntity> ew = new EntityWrapper< ChengyuanxinxiEntity>();

? ew.allEq(MPUtil.allEQMapPre( chengyuanxinxi, "chengyuanxinxi"));?

ChengyuanxinxiView chengyuanxinxiView =? chengyuanxinxiService.selectView(ew);

return R.ok("查詢成員信息成功").put("data", chengyuanxinxiView);

? ? }

? ? /**

? ? ?* 后端詳情

? ? ?*/

? ? @RequestMapping("/info/{id}")

? ? public R info(@PathVariable("id") Long id){

? ? ? ? ChengyuanxinxiEntity chengyuanxinxi = chengyuanxinxiService.selectById(id);

? ? ? ? return R.ok().put("data", chengyuanxinxi);

? ? }