1 概述
实现了前台用户登录、注册、资料下载、专业目录、学生中心、信息查询、管理员登录;后台实现的功能有管理员管理、公告管理、学校管理、专业管理、资料管理、报名管理、学生管理。
2 数据库表
实体描述:
管理员信息:说明、编号、用户名、密码、日期、状态、是否使用、登录次数、权限;
登录日志信息:说明、编号、用户名、密码、日期、IP
报名信息:说明、编号、志愿ID、学生ID、复试成绩、状态、报名日期\
公告信息:说明、编号、标题、内容、用户名、日期;
专业信息:说明、编号、名称
学生详细信息:说明、编号、学生ID、姓名、性别、出生日期、学籍所在地、电话、邮件、密码问题、密码答案、准考证号、地址、生源地、所在学校
学校信息:说明、编号、省份、学校名称
学生信息:说明、编号、用户名、密码、注册日期、是否使用、登录次数、最后登录时间、登录IP
志愿信息:说明、编号、导师姓名、专业、开始报名日期、结束报名日期、学校名称、志愿数量
3 关键代码
// Source File Name: ZiliaoServlet.java
package com.action;
import com.bean.ZiliaoBean;
import javax.servlet.ServletException;
import javax.servlet.http.*;
import java.io.IOException;
import com.sun.net.ssl.internal.ssl.Debug;
public class ZiliaoServlet extends HttpServlet
{
public ZiliaoServlet()
{
}
public void destroy()
{
super.destroy();
}
public void doGet(HttpServletRequest request, HttpServletResponse response)
throws ServletException, IOException
{
doPost(request, response);
}
public void doPost(HttpServletRequest request, HttpServletResponse response)
throws ServletException, IOException
{
response.setContentType("text/html;charset=gb2312");
request.setCharacterEncoding("gb2312");
HttpSession session = request.getSession();
String method = request.getParameter("method");
//System.out.println(method);
ZiliaoBean Ziliao = new ZiliaoBean();
if (method.equals("addZiliao"))
{
String title = request.getParameter("title");
String neirong = request.getParameter("neirong");
String fujian = request.getParameter("fujian");
int flag = Ziliao.addZiliao(title,neirong,fujian);
if (flag == 1)
{
request.setAttribute("message", "操作成功!");
request.getRequestDispatcher("admin/ziliao/index.jsp").forward(request, response);
} else
{
request.setAttribute("message", "操作失败!");
request.getRequestDispatcher("admin/ziliao/index.jsp").forward(request, response);
}
} else
if (method.equals("delZiliao"))
{
String id = request.getParameter("id");
int flag = Ziliao.delZiliao(id);
if (flag == 1)
{
request.setAttribute("message", "操作成功!");
request.getRequestDispatcher("admin/ziliao/index.jsp").forward(request, response);
} else
{
request.setAttribute("message", "操作失败!");
request.getRequestDispatcher("admin/ziliao/index.jsp").forward(request, response);
}
} else
if (method.equals("upZiliao"))
{
int id = Integer.parseInt(request.getParameter("id"));
String title = request.getParameter("title");
String neirong = request.getParameter("neirong");
String fujian = request.getParameter("fujian");
int flag = Ziliao.upZiliao(title,neirong,id,fujian);
if (flag == 1)
{
request.setAttribute("message", "操作成功!");
request.getRequestDispatcher("admin/ziliao/index.jsp").forward(request, response);
} else
{
request.setAttribute("message", "操作失败!");
request.getRequestDispatcher("admin/ziliao/index.jsp").forward(request, response);
}
}
}
public void init()
throws ServletException
{
}
}
4 效果演示
idea或eclipse开发,mysql数据库