基于javaweb+mysql的jsp+servlet学生信息管理系统(java+servlet+jsp+easyui+mysql)
运行环境
Java≥8、MySQL≥5.7、Tomcat≥8
开发工具
eclipse/idea/myeclipse/sts等均可配置运行
适用
课程设计，大作业，毕业设计，项目练习，学习演示等
功能说明
基于javaweb+mysql的JSP+Servlet学生信息管理系统(java+servlet+jsp+easyui+mysql)
介绍
学生信息管理系统,该项目分为管理员、老师、学生三种角色； 管理员主要功能： 学生信息管理、班级信息管理、教师信息管理、系统管理； 老师主要功能： 学生信息管理、班级信息管理、教师信息管理、系统管理； 学生主要功能： 学生信息管理、系统管理；
环境需要
1.运行环境：最好是java jdk 1.8，我们在这个平台上运行的。其他版本理论上也可以。 2.IDE环境：IDEA，Eclipse,Myeclipse都可以。推荐IDEA; 3.tomcat环境：Tomcat 7.x,8.x,9.x版本均可 4.硬件环境：windows 7/8/10 1G内存以上；或者 Mac OS； 5.是否Maven项目: 否；查看源码目录中是否包含pom.xml；若包含，则为maven项目，否则为非maven项目 6.数据库：MySql 5.7版本；
技术栈
- Servlet+Jsp+easyui
使用说明
- 使用IDEA/Eclipse/MyEclipse导入项目，Eclipse/MyEclipse导入时，若为maven项目请选择maven;若为maven项目，导入成功后请执行maven clean;maven install命令，配置tomcat，然后运行； 2. 使用Navicat或者其它工具，在mysql中创建对应名称的数据库，并导入项目的sql文件； 3. 将项目中DbUtil.java中的数据库配置改为自己的配置 4. 配置tomcat,运行项目，在浏览器中输入localhost:8080/xxx 登录 5.管理员账号：admin 密码：admin 教师账号：王鹤翔老师 密码：111 学生账号：江小雷 密码：1
*班级信息管理servlet
*/
public class ClazzServlet extends HttpServlet {
public void doGet(HttpServletRequest request,HttpServletResponse response) throws IOException{
doPost(request, response);
}
public void doPost(HttpServletRequest request,HttpServletResponse response) throws IOException{
String method = request.getParameter("method");
if("toClazzListView".equals(method)){
clazzList(request,response);
}else if("getClazzList".equals(method)){
getClazzList(request, response);
}else if("AddClazz".equals(method)){
addClazz(request, response);
}else if("DeleteClazz".equals(method)){
deleteClazz(request, response);
}else if("EditClazz".equals(method)){
editClazz(request, response);
}
}
private void editClazz(HttpServletRequest request,
HttpServletResponse response) {
// TODO Auto-generated method stub
Integer id = Integer.parseInt(request.getParameter("id"));
String name = request.getParameter("name");
String info = request.getParameter("info");
Clazz clazz = new Clazz();
clazz.setName(name);
clazz.setInfo(info);
clazz.setId(id);
ClazzDao clazzDao = new ClazzDao();
if(clazzDao.editClazz(clazz)){
try {
response.getWriter().write("success");
} catch (IOException e) {
// TODO Auto-generated catch block
e.printStackTrace();
}finally{
clazzDao.closeCon();
}
}
}
private void deleteClazz(HttpServletRequest request,
HttpServletResponse response) {
// TODO Auto-generated method stub
Integer id = Integer.parseInt(request.getParameter("clazzid"));
List<Clazz> clazzList = clazzDao.getClazzList(clazz, new Page(currentPage, pageSize));
int total = clazzDao.getClazzListTotal(clazz);
clazzDao.closeCon();
response.setCharacterEncoding("UTF-8");
Map<String, Object> ret = new HashMap<String, Object>();
ret.put("total", total);
ret.put("rows", clazzList);
try {
String from = request.getParameter("from");
if("combox".equals(from)){
response.getWriter().write(JSONArray.fromObject(clazzList).toString());
}else{
response.getWriter().write(JSONObject.fromObject(ret).toString());
}
} catch (IOException e) {
// TODO Auto-generated catch block
e.printStackTrace();
}
}
}
/**
*
*登录验证servlet
*/
e.printStackTrace();
} catch (IOException e) {
// TODO Auto-generated catch block
e.printStackTrace();
}
}
}
public class LeaveServlet extends HttpServlet {
/**
*
*/
private static final long serialVersionUID = 1L;
public void doGet(HttpServletRequest request,HttpServletResponse response) throws IOException{
doPost(request, response);
}
if(cell.getCellType() != cell.CELL_TYPE_NUMERIC){
errorMsg += "第" + rowNum + "行成绩类型不是数字！\n";
continue;
}
double scoreValue = cell.getNumericCellValue();
//获取第3列，备注
cell = row.getCell(3);
String remark = null;
if(cell != null){
remark = cell.getStringCellValue();
}
Student student = studentDao.getStudent(studentId);
if(student == null){
errorMsg += "第" + rowNum + "行学生id不存在！\n";
continue;
}
Course course = courseDao.getCourse(courseId);
if(course == null){
errorMsg += "第" + rowNum + "行课程id不存在！\n";
continue;
}
if(!selectedCourseDao.isSelected(studentId, courseId)){
errorMsg += "第" + rowNum + "行课程该同学未选，不合法！\n";
continue;
}
if(scoreDao.isAdd(studentId, courseId)){
errorMsg += "第" + rowNum + "行成绩已经被添加，请勿重复添加！\n";
continue;
}
Score score = new Score();
score.setCourseId(courseId);
score.setRemark(remark);
score.setScore(scoreValue);
score.setStudentId(studentId);
if(scoreDao.addScore(score)){
count++;
}
}
errorMsg += "成功录入" + count + "条成绩信息！";
studentDao.closeCon();
courseDao.closeCon();
selectedCourseDao.closeCon();
scoreDao.closeCon();
try {
response.getWriter().write("<div id='message'>"+errorMsg+"</div>");
HttpServletResponse response) {
// TODO Auto-generated method stub
FileUpload fileUpload = new FileUpload(request);
fileUpload.setFileFormat("xls");
fileUpload.setFileFormat("xlsx");
fileUpload.setFileSize(2048);
response.setCharacterEncoding("UTF-8");
try {
InputStream uploadInputStream = fileUpload.getUploadInputStream();
HSSFWorkbook hssfWorkbook = new HSSFWorkbook(uploadInputStream);
HSSFSheet sheetAt = hssfWorkbook.getSheetAt(0);
int count = 0;
String errorMsg = "";
StudentDao studentDao = new StudentDao();
CourseDao courseDao = new CourseDao();
ScoreDao scoreDao = new ScoreDao();
SelectedCourseDao selectedCourseDao = new SelectedCourseDao();
for(int rowNum = 1; rowNum <= sheetAt.getLastRowNum(); rowNum++){
HSSFRow row = sheetAt.getRow(rowNum);
HSSFCell cell = row.getCell(0);
//获取第0列，学生id
if(cell == null){
errorMsg += "第" + rowNum + "行学生id缺失！\n";
continue;
}
if(cell.getCellType() != cell.CELL_TYPE_NUMERIC){
errorMsg += "第" + rowNum + "行学生id类型不是整数！\n";
continue;
}
int studentId = new Double(cell.getNumericCellValue()).intValue();
//获取第1列，课程id
cell = row.getCell(1);
if(cell == null){
errorMsg += "第" + rowNum + "行课程id缺失！\n";
continue;
}
if(cell.getCellType() != cell.CELL_TYPE_NUMERIC){
errorMsg += "第" + rowNum + "行课程id不是整数！\n";
continue;
}
int courseId = new Double(cell.getNumericCellValue()).intValue();
//获取第2列，成绩
cell = row.getCell(2);
if(cell == null){
errorMsg += "第" + rowNum + "行成绩缺失！\n";
continue;
}
if(cell.getCellType() != cell.CELL_TYPE_NUMERIC){
errorMsg += "第" + rowNum + "行成绩类型不是数字！\n";
score.setCourseId(courseId);
if("avg".equals(searchType)){
Map<String, Object> avgStats = scoreDao.getAvgStats(score);
List<Double> scoreList = new ArrayList<Double>();
scoreList.add(Double.parseDouble(avgStats.get("max_score").toString()));
scoreList.add(Double.parseDouble(avgStats.get("min_score").toString()));
scoreList.add(Double.parseDouble(avgStats.get("avg_score").toString()));
List<String> avgStringList = new ArrayList<String>();
avgStringList.add("最高分");
avgStringList.add("最低分");
avgStringList.add("平均分");
Map<String, Object> retMap = new HashMap<String, Object>();
retMap.put("courseName", avgStats.get("courseName").toString());
retMap.put("scoreList", scoreList);
retMap.put("avgList", avgStringList);
retMap.put("type", "suceess");
try {
response.getWriter().write(JSONObject.fromObject(retMap).toString());
} catch (IOException e) {
// TODO Auto-generated catch block
e.printStackTrace();
}
return;
}
List<Map<String, Object>> scoreList = scoreDao.getScoreList(score);
List<Integer> numberList = new ArrayList<Integer>();
numberList.add(0);
numberList.add(0);
numberList.add(0);
numberList.add(0);
numberList.add(0);
List<String> rangeStringList = new ArrayList<String>();
rangeStringList.add("60分以下");
rangeStringList.add("60~70分");
rangeStringList.add("70~80分");
rangeStringList.add("80~90分");
rangeStringList.add("90~100分");
String courseName = "";
for(Map<String, Object> entry:scoreList){
courseName = entry.get("courseName").toString();
double scoreValue = Double.parseDouble(entry.get("score").toString());
if(scoreValue < 60){
numberList.set(0, numberList.get(0)+1);
continue;
}
if(scoreValue <= 70 && scoreValue >= 60){
numberList.set(1, numberList.get(1)+1);
continue;
}
if(scoreValue <= 80 && scoreValue > 70){
numberList.set(2, numberList.get(2)+1);
continue;
if(teacherDao.editPassword(teacher, newPassword)){
try {
response.getWriter().write("success");
} catch (IOException e) {
// TODO Auto-generated catch block
e.printStackTrace();
}
finally{
teacherDao.closeCon();
}
}else{
try {
response.getWriter().write("数据库修改错误");
} catch (IOException e) {
// TODO Auto-generated catch block
e.printStackTrace();
}finally{
teacherDao.closeCon();
}
}
}
}
private void personalView(HttpServletRequest request,
HttpServletResponse response) {
// TODO Auto-generated method stub
try {
request.getRequestDispatcher("view/personalView.jsp").forward(request, response);
} catch (ServletException e) {
// TODO Auto-generated catch block
e.printStackTrace();
} catch (IOException e) {
// TODO Auto-generated catch block
e.printStackTrace();
}
}
}
}
} catch (ProtocolException e) {
// TODO Auto-generated catch block
try {
response.getWriter().write("<div id='message'>上传协议错误！</div>");
} catch (IOException e1) {
// TODO Auto-generated catch block
e1.printStackTrace();
}
e.printStackTrace();
}catch (NullFileException e1) {
// TODO: handle exception
try {
response.getWriter().write("<div id='message'>上传的文件为空!</div>");
} catch (IOException e) {
// TODO Auto-generated catch block
e.printStackTrace();
}
e1.printStackTrace();
}
catch (SizeException e2) {
// TODO: handle exception
try {
response.getWriter().write("<div id='message'>上传文件大小不能超过"+fileUpload.getFileSize()+"！</div>");
} catch (IOException e) {
// TODO Auto-generated catch block
e.printStackTrace();
}
e2.printStackTrace();
}
catch (IOException e3) {
// TODO: handle exception
try {
response.getWriter().write("<div id='message'>读取文件出错！</div>");
} catch (IOException e) {
// TODO Auto-generated catch block
e.printStackTrace();
}
e3.printStackTrace();
}
catch (FileFormatException e4) {
// TODO: handle exception
try {
response.getWriter().write("<div id='message'>上传文件格式不正确，请上传 "+fileUpload.getFileFormat()+" 格式的文件！</div>");
} catch (IOException e) {
}
ScoreDao scoreDao = new ScoreDao();
Score score = new Score();
score.setCourseId(courseId);
if("avg".equals(searchType)){
Map<String, Object> avgStats = scoreDao.getAvgStats(score);
List<Double> scoreList = new ArrayList<Double>();
scoreList.add(Double.parseDouble(avgStats.get("max_score").toString()));
scoreList.add(Double.parseDouble(avgStats.get("min_score").toString()));
scoreList.add(Double.parseDouble(avgStats.get("avg_score").toString()));
List<String> avgStringList = new ArrayList<String>();
avgStringList.add("最高分");
avgStringList.add("最低分");
avgStringList.add("平均分");
Map<String, Object> retMap = new HashMap<String, Object>();
retMap.put("courseName", avgStats.get("courseName").toString());
retMap.put("scoreList", scoreList);
retMap.put("avgList", avgStringList);
retMap.put("type", "suceess");
try {
response.getWriter().write(JSONObject.fromObject(retMap).toString());
} catch (IOException e) {
// TODO Auto-generated catch block
e.printStackTrace();
}
return;
}
List<Map<String, Object>> scoreList = scoreDao.getScoreList(score);
List<Integer> numberList = new ArrayList<Integer>();
numberList.add(0);
numberList.add(0);
numberList.add(0);
numberList.add(0);
numberList.add(0);
List<String> rangeStringList = new ArrayList<String>();
rangeStringList.add("60分以下");
rangeStringList.add("60~70分");
rangeStringList.add("70~80分");
rangeStringList.add("80~90分");
rangeStringList.add("90~100分");
String courseName = "";
for(Map<String, Object> entry:scoreList){
courseName = entry.get("courseName").toString();
double scoreValue = Double.parseDouble(entry.get("score").toString());
if(scoreValue < 60){
numberList.set(0, numberList.get(0)+1);
continue;
leave.setStudentId(studentId);
leave.setInfo(info);
leave.setRemark("");
LeaveDao leaveDao = new LeaveDao();
String msg = "error";
if(leaveDao.addLeave(leave)){
msg = "success";
}
try {
response.getWriter().write(msg);
} catch (IOException e) {
// TODO Auto-generated catch block
e.printStackTrace();
}finally{
leaveDao.closeCon();
}
}
}
/**
*
*学生信息管理功能实现servlet
*/
public class StudentServlet extends HttpServlet {
public void doGet(HttpServletRequest request,HttpServletResponse response) throws IOException{
doPost(request, response);
}
public void doPost(HttpServletRequest request,HttpServletResponse response) throws IOException{
String method = request.getParameter("method");
if("toStudentListView".equals(method)){
String name = request.getParameter("name");
String info = request.getParameter("info");
Clazz clazz = new Clazz();
clazz.setName(name);
clazz.setInfo(info);
ClazzDao clazzDao = new ClazzDao();
if(clazzDao.addClazz(clazz)){
try {
response.getWriter().write("success");
} catch (IOException e) {
// TODO Auto-generated catch block
e.printStackTrace();
}finally{
clazzDao.closeCon();
}
}
}
private void clazzList(HttpServletRequest request,
HttpServletResponse response) {
// TODO Auto-generated method stub
try {
request.getRequestDispatcher("view/clazzList.jsp").forward(request, response);
} catch (ServletException e) {
// TODO Auto-generated catch block
e.printStackTrace();
} catch (IOException e) {
// TODO Auto-generated catch block
e.printStackTrace();
}
}
private void getClazzList(HttpServletRequest request,HttpServletResponse response){
String name = request.getParameter("clazzName");
Integer currentPage = request.getParameter("page") == null ? 1 : Integer.parseInt(request.getParameter("page"));
Integer pageSize = request.getParameter("rows") == null ? 999 : Integer.parseInt(request.getParameter("rows"));
Clazz clazz = new Clazz();
clazz.setName(name);
ClazzDao clazzDao = new ClazzDao();
List<Clazz> clazzList = clazzDao.getClazzList(clazz, new Page(currentPage, pageSize));
int total = clazzDao.getClazzListTotal(clazz);
clazzDao.closeCon();
response.setCharacterEncoding("UTF-8");
Map<String, Object> ret = new HashMap<String, Object>();
ret.put("total", total);
ret.put("rows", clazzList);
try {
String from = request.getParameter("from");
if("combox".equals(from)){
response.getWriter().write(JSONArray.fromObject(clazzList).toString());
}else{
response.getWriter().write(JSONObject.fromObject(ret).toString());
}
} catch (IOException e) {
// TODO Auto-generated catch block
Map<String, Object> ret = new HashMap<String, Object>();
ret.put("total", total);
ret.put("rows", leaveList);
try {
String from = request.getParameter("from");
if("combox".equals(from)){
response.getWriter().write(JSONArray.fromObject(leaveList).toString());
}else{
response.getWriter().write(JSONObject.fromObject(ret).toString());
}
} catch (IOException e) {
// TODO Auto-generated catch block
e.printStackTrace();
}
}
private void addLeave(HttpServletRequest request,
HttpServletResponse response) {
// TODO Auto-generated method stub
int studentId = Integer.parseInt(request.getParameter("studentid"));
String info = request.getParameter("info");
Leave leave = new Leave();
leave.setStudentId(studentId);
leave.setInfo(info);
leave.setRemark("");
LeaveDao leaveDao = new LeaveDao();
String msg = "error";
if(leaveDao.addLeave(leave)){
msg = "success";
}
try {
response.getWriter().write(msg);
} catch (IOException e) {
// TODO Auto-generated catch block
e.printStackTrace();
}finally{
leaveDao.closeCon();
}
}
}
// TODO Auto-generated method stub
String name = request.getParameter("name");
String password = request.getParameter("password");
String sex = request.getParameter("sex");
String mobile = request.getParameter("mobile");
String qq = request.getParameter("qq");
int clazzId = Integer.parseInt(request.getParameter("clazzid"));
Teacher teacher = new Teacher();
teacher.setClazzId(clazzId);
teacher.setMobile(mobile);
teacher.setName(name);
teacher.setPassword(password);
teacher.setQq(qq);
teacher.setSex(sex);
teacher.setSn(SnGenerateUtil.generateTeacherSn(clazzId));
TeacherDao teacherDao = new TeacherDao();
if(teacherDao.addTeacher(teacher)){
try {
response.getWriter().write("success");
} catch (IOException e) {
// TODO Auto-generated catch block
e.printStackTrace();
}finally{
teacherDao.closeCon();
}
}
}
private void teacherList(HttpServletRequest request,
HttpServletResponse response) {
// TODO Auto-generated method stub
try {
request.getRequestDispatcher("view/teacherList.jsp").forward(request, response);
} catch (ServletException e) {
// TODO Auto-generated catch block
e.printStackTrace();
} catch (IOException e) {
// TODO Auto-generated catch block
e.printStackTrace();
}
}
}
cell = row.getCell(3);
String remark = null;
if(cell != null){
remark = cell.getStringCellValue();
}
Student student = studentDao.getStudent(studentId);
if(student == null){
errorMsg += "第" + rowNum + "行学生id不存在！\n";
continue;
}
Course course = courseDao.getCourse(courseId);
if(course == null){
errorMsg += "第" + rowNum + "行课程id不存在！\n";
continue;
}
if(!selectedCourseDao.isSelected(studentId, courseId)){
errorMsg += "第" + rowNum + "行课程该同学未选，不合法！\n";
continue;
}
if(scoreDao.isAdd(studentId, courseId)){
errorMsg += "第" + rowNum + "行成绩已经被添加，请勿重复添加！\n";
continue;
}
Score score = new Score();
score.setCourseId(courseId);
score.setRemark(remark);
score.setScore(scoreValue);
score.setStudentId(studentId);
if(scoreDao.addScore(score)){
count++;
}
}
errorMsg += "成功录入" + count + "条成绩信息！";
studentDao.closeCon();
courseDao.closeCon();
selectedCourseDao.closeCon();
scoreDao.closeCon();
try {
response.getWriter().write("<div id='message'>"+errorMsg+"</div>");
} catch (IOException e1) {
// TODO Auto-generated catch block
e1.printStackTrace();
}
} catch (ProtocolException e) {
// TODO Auto-generated catch block
try {
response.getWriter().write("<div id='message'>上传协议错误！</div>");
} catch (IOException e1) {
// TODO Auto-generated catch block
student.setClazzId(clazzId);
student.setMobile(mobile);
student.setName(name);
student.setPassword(password);
student.setQq(qq);
student.setSex(sex);
student.setSn(SnGenerateUtil.generateSn(clazzId));
StudentDao studentDao = new StudentDao();
if(studentDao.addStudent(student)){
try {
response.getWriter().write("success");
} catch (IOException e) {
// TODO Auto-generated catch block
e.printStackTrace();
}finally{
studentDao.closeCon();
}
}
}
private void studentList(HttpServletRequest request,
HttpServletResponse response) throws IOException {
// TODO Auto-generated method stub
try {
request.getRequestDispatcher("view/studentList.jsp").forward(request, response);
} catch (ServletException e) {
// TODO Auto-generated catch block
e.printStackTrace();
}
}
}
} catch (IOException e) {
// TODO Auto-generated catch block
e.printStackTrace();
}finally{
teacherDao.closeCon();
}
}
}
private void getTeacherList(HttpServletRequest request,
HttpServletResponse response) {
// TODO Auto-generated method stub
String name = request.getParameter("teacherName");
Integer currentPage = request.getParameter("page") == null ? 1 : Integer.parseInt(request.getParameter("page"));
Integer pageSize = request.getParameter("rows") == null ? 999 : Integer.parseInt(request.getParameter("rows"));
Integer clazz = request.getParameter("clazzid") == null ? 0 : Integer.parseInt(request.getParameter("clazzid"));
//获取当前登录用户类型
int userType = Integer.parseInt(request.getSession().getAttribute("userType").toString());
Teacher teacher = new Teacher();
teacher.setName(name);
teacher.setClazzId(clazz);
if(userType == 3){
//如果是学生，只能查看自己的信息
Teacher currentUser = (Teacher)request.getSession().getAttribute("user");
teacher.setId(currentUser.getId());
}
TeacherDao teacherDao = new TeacherDao();
List<Teacher> teacherList = teacherDao.getTeacherList(teacher, new Page(currentPage, pageSize));
int total = teacherDao.getTeacherListTotal(teacher);
teacherDao.closeCon();
response.setCharacterEncoding("UTF-8");
Map<String, Object> ret = new HashMap<String, Object>();
ret.put("total", total);
ret.put("rows", teacherList);
try {
String from = request.getParameter("from");
if("combox".equals(from)){
response.getWriter().write(JSONArray.fromObject(teacherList).toString());
}else{
response.getWriter().write(JSONObject.fromObject(ret).toString());
}
} catch (IOException e) {
}
SelectedCourse selectedCourse = new SelectedCourse();
selectedCourse.setStudentId(studentId);
selectedCourse.setCourseId(courseId);
if(selectedCourseDao.addSelectedCourse(selectedCourse)){
msg = "success";
}
courseDao.updateCourseSelectedNum(courseId, 1);
courseDao.closeCon();
selectedCourseDao.closeCon();
response.getWriter().write(msg);
}
private void getSelectedCourseList(HttpServletRequest request,
HttpServletResponse response) {
// TODO Auto-generated method stub
int studentId = request.getParameter("studentid") == null ? 0 : Integer.parseInt(request.getParameter("studentid").toString());
int courseId = request.getParameter("courseid") == null ? 0 : Integer.parseInt(request.getParameter("courseid").toString());
Integer currentPage = request.getParameter("page") == null ? 1 : Integer.parseInt(request.getParameter("page"));
Integer pageSize = request.getParameter("rows") == null ? 999 : Integer.parseInt(request.getParameter("rows"));
SelectedCourse selectedCourse = new SelectedCourse();
//获取当前登录用户类型
int userType = Integer.parseInt(request.getSession().getAttribute("userType").toString());
if(userType == 2){
//如果是学生，只能查看自己的信息
Student currentUser = (Student)request.getSession().getAttribute("user");
studentId = currentUser.getId();
}
selectedCourse.setCourseId(courseId);
selectedCourse.setStudentId(studentId);
SelectedCourseDao selectedCourseDao = new SelectedCourseDao();
List<SelectedCourse> courseList = selectedCourseDao.getSelectedCourseList(selectedCourse, new Page(currentPage, pageSize));
int total = selectedCourseDao.getSelectedCourseListTotal(selectedCourse);
selectedCourseDao.closeCon();
response.setCharacterEncoding("UTF-8");
Map<String, Object> ret = new HashMap<String, Object>();
ret.put("total", total);
ret.put("rows", courseList);
try {
String from = request.getParameter("from");
if("combox".equals(from)){
response.getWriter().write(JSONArray.fromObject(courseList).toString());
}else{
response.getWriter().write(JSONObject.fromObject(ret).toString());
}
} catch (IOException e) {
// TODO Auto-generated catch block
1463
被折叠的 条评论
为什么被折叠?
到【灌水乐园】发言
