摘 要：每年都有大量的学生从母校毕业，毕业后是否会对自己的大学时光回味无穷，是否有一种与他人分享的冲动？大学里一直默默关注的他（她），又是何去何从？网络，改变着社会，给了人们以无限的可能。同时如今网络也已经不再单纯的提供数据信息服务，网络+商店成就了网上商店，网络+自行车成就了共享单车……因此，校友录系统的开发紧跟行业发展，满足毕业生学习，发展及学校与校友沟通的需要。

本文的研究课题是校友录系统的开发与实现。众所周知，校友录系统的主要是实现校友间的沟通、学校与校友间的联系。而其中比较重要的部分是校友间的沟通，实时在线联系。

本课题主要使用Java Swing界面技术，MVC三层架构和MySQL数据库开发跨平台技术设计了校友录系统，实现了公共模块，主窗体，系统托盘, 系统工具,用户管理,通信等功能。本文依次介绍了数据库的搭建，公共模块开发，主窗体，系统托盘, 系统工具模块设计,用户管理模块设计,通信模块设计,其他模块设计以及编码实现，通过对这些方面介绍从而详细的介绍了本系统。

关键词：MySQL；Java swing；UDP；MVC

Abstract：Every year there are a large number of students graduated from his alma mater, after graduating from college will be on their own time, whether there is a kind of impulse to share with others? The university has been quietly concerned about him (her), but also where to go? At the same time, now the network has not only to provide information services, network + store achievements of the online store, network + bicycle achievement sharing bicycle... Therefore, alumni of the system development with industry development, to meet the development needs of school graduates to learn, and to communicate with each other.

The research topic of this paper is the development and implementation of alumni record system. As we all know, alumni records system is mainly to achieve communication between alumni, schools and alumni links. Among them, the more important part is the communication between alumni, real-time online contact.

This paper mainly used Java Swing interface technology, the design of the alumni system MVC three layer architecture and MySQL database development of cross platform technology, realizes the public module, the main form, system tray, system tools, user management, communication and other functions. This paper introduces the database structures, public module development, the main form, system tray, system module design, user management module design, communication module design, module design and other encoding implementation, through the introduction and detailed introduction of the system.

Keywords: MySQL; Java swing; UDP; MVC

目录

第一章 绪论 1

1.1 开发背景与现状 1

1.1.1 背景 1

1.1.2 现状 1

1.2 开发本系统的意义与目标 1

1.3 开发本系统的组织安排 2

1.4 本章小结 2

第二章 开发平台介绍 3

2.1 开发语言 3

2.1.1 Java 3

2.1.2 Sql 4

2.2 开发工具 4

2.2.1 Eclipse Jee Neon 4

2.2.2 MySQL + Navicate 5

2.3 总体技术路线 5

2.4 本章小结 5

第三章 系统分析 6

3.1 需求分析 6

3.2 系统目标 6

3.3 系统功能结构 7

3.4 系统模块分析 7

3.4.1 信息通信 7

3.4.2 班级留言 8

3.4.3 班级相册 8

3.4.4 发起投票 8

3.4.5 系统设计 8

3.4.6 系统升级 9

3.5 系统预览 9

3.6 文件夹组织结构 12

3.7 本章小结 13

第四章 数据库设计 14

4.1 数据库概要说明 14

4.2 数据库概念设计及数据库逻辑设计 14

4.2.1 用户表(tb_users) 14

4.2.2 窗体位置表(tb_location) 15

4.2.3 校友留言(tb_info) 15

4.2.4 校友投票(tb_voter) 15