作者主页:Java毕设网
简介:Java领域优质创作者、Java项目、学习资料、技术互助
文末获取源码
一、项目介绍
本项目为后台管理系统;
管理员角色包含以下功能:
登录、专业管理、班级管理、课程管理、学生学籍管理、学生成绩管理等功能。
二、环境需要
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.数据库:MySql 5.7版本;
6.是否Maven项目: 否;
三、技术栈
1. 后端:servlet
2. 前端:JSP+css+javascript
四、使用说明
1. 使用Navicat或者其它工具,在mysql中创建对应名称的数据库,并导入项目的sql文件;
2. 使用IDEA/Eclipse/MyEclipse导入项目,Eclipse/MyEclipse导入时,若为maven项目请选择maven;
若为maven项目,导入成功后请执行maven clean;maven install命令,然后运行;
3. 将项目中com/dao/DB.java配置文件中的数据库配置改为自己的配置;
4. 运行项目,输入http://localhost:8080/ 登录
五、运行截图
六、相关代码
管理员控制器
public class admin_servlet extends HttpServlet
{
public void service(HttpServletRequest req,HttpServletResponse res)throws ServletException, IOException
{
String type=req.getParameter("type");
if(type.endsWith("adminMana"))
{
adminMana(req, res);
}
if(type.endsWith("adminAdd"))
{
adminAdd(req, res);
}
if(type.endsWith("adminDel"))
{
adminDel(req, res);
}
}
public void adminMana(HttpServletRequest req,HttpServletResponse res) throws ServletException, IOException
{
List adminList=new ArrayList();
String sql="select * from t_admin";
Object[] params={};
DB mydb=new DB();
try
{
mydb.doPstm(sql, params);
ResultSet rs=mydb.getRs();
while(rs.next())
{
TAdmin admin=new TAdmin();
admin.setUserId(rs.getInt("userId"));
admin.setUserName(rs.getString("userName"));
admin.setUserPw(rs.getString("userPw"));
adminList.add(admin);
}
rs.close();
}
catch(Exception e)
{
e.printStackTrace();
}
mydb.closed();
req.setAttribute("adminList", adminList);
req.getRequestDispatcher("admin/admin/adminMana.jsp").forward(req, res);
}
public void adminAdd(HttpServletRequest req,HttpServletResponse res)
{
String userName=req.getParameter("userName");
String userPw=req.getParameter("userPw");
String sql="insert into t_admin values(?,?)";
Object[] params={userName,userPw};
DB mydb=new DB();
mydb.doPstm(sql, params);
mydb.closed();
req.setAttribute("message", "操作成功");
req.setAttribute("path", "admin?type=adminMana");
String targetURL = "/common/success.jsp";
dispatch(targetURL, req, res);
}
public void adminDel(HttpServletRequest req,HttpServletResponse res)
{
System.out.println(req.getParameter("userId")+"**");
String sql="delete from t_admin where userId="+Integer.parseInt(req.getParameter("userId"));
Object[] params={};
DB mydb=new DB();
mydb.doPstm(sql, params);
mydb.closed();
req.setAttribute("message", "操作成功");
req.setAttribute("path", "admin?type=adminMana");
String targetURL = "/common/success.jsp";
dispatch(targetURL, req, res);
}
public void dispatch(String targetURI,HttpServletRequest request,HttpServletResponse response)
{
RequestDispatcher dispatch = getServletContext().getRequestDispatcher(targetURI);
try
{
dispatch.forward(request, response);
return;
}
catch (ServletException e)
{
e.printStackTrace();
}
catch (IOException e)
{
e.printStackTrace();
}
}
public void init(ServletConfig config) throws ServletException
{
super.init(config);
}
public void destroy()
{
}
}
学生管理控制器
public class stu_servlet extends HttpServlet
{
public void service(HttpServletRequest req,HttpServletResponse res)throws ServletException, IOException
{
String type=req.getParameter("type");
if(type.endsWith("stuAdd"))
{
stuAdd(req, res);
}
if(type.endsWith("stuDel"))
{
stuDel(req, res);
}
if(type.endsWith("stuMana"))
{
stuMana(req, res);
}
if(type.endsWith("stuEdit"))
{
stuEdit(req, res);
}
if(type.endsWith("stuDetail"))
{
stuDetail(req, res);
}
if(type.endsWith("stuAll"))
{
stuAll(req, res);
}
if(type.endsWith("stuSearchByXuehao"))
{
stuSearchByXuehao(req, res);
}
if(type.endsWith("stuTongji"))
{
stuTongji(req, res);
}
}
public void stuAdd(HttpServletRequest req,HttpServletResponse res)
{
String xuehao=req.getParameter("xuehao");
String name1=req.getParameter("name1");
String sex=req.getParameter("sex");
int age=Integer.parseInt(req.getParameter("age"));
int banji_id=Integer.parseInt(req.getParameter("banji_id"));
String ruxueshijian=req.getParameter("ruxueshijian");
String biyeshijian=req.getParameter("biyeshijian");
String xuezhi=req.getParameter("xuezhi");
String xuexiao=req.getParameter("xuexiao");
String del="no";
if(liuService.jianchaxuhao(xuehao.trim())==true)
{
req.setAttribute("message", "学号重复。请重新输入");
req.setAttribute("path", "admin/stu/stuAdd.jsp");
String targetURL = "/common/success.jsp";
dispatch(targetURL, req, res);
}
else
{
String sql="insert into t_stu values(?,?,?,?,?,?,?,?,?,?)";
Object[] params={xuehao,name1,sex,age,banji_id,ruxueshijian,biyeshijian,xuezhi,xuexiao,del};
DB mydb=new DB();
mydb.doPstm(sql, params);
mydb.closed();
req.setAttribute("message", "操作成功");
req.setAttribute("path", "stu?type=stuMana");
String targetURL = "/common/success.jsp";
dispatch(targetURL, req, res);
}
}
public void stuDel(HttpServletRequest req,HttpServletResponse res)
{
String sql="update t_stu set del='yes' where id="+Integer.parseInt(req.getParameter("id"));
Object[] params={};
DB mydb=new DB();
mydb.doPstm(sql, params);
mydb.closed();
req.setAttribute("message", "操作成功");
req.setAttribute("path", "stu?type=stuMana");
String targetURL = "/common/success.jsp";
dispatch(targetURL, req, res);
}
public void stuMana(HttpServletRequest req,HttpServletResponse res) throws ServletException, IOException
{
List stuList=new ArrayList();
String sql="select * from t_stu where del='no'";
Object[] params={};
DB mydb=new DB();
try
{
mydb.doPstm(sql, params);
ResultSet rs=mydb.getRs();
while(rs.next())
{
Tstu stu=new Tstu();
stu.setId(rs.getInt("id"));
stu.setXuehao(rs.getString("xuehao"));
stu.setName1(rs.getString("name1"));
stu.setSex(rs.getString("sex"));
stu.setAge(rs.getInt("age"));
stu.setBanji_id(rs.getInt("banji_id"));
stu.setRuxueshijian(rs.getString("ruxueshijian"));
stu.setBiyeshijian(rs.getString("biyeshijian"));
stu.setXuezhi(rs.getString("xuezhi"));
stu.setXuexiao(rs.getString("xuexiao"));
stu.setBanji_name(liuService.getBanjiName(rs.getInt("banji_id")));
stuList.add(stu);
}
rs.close();
}
catch(Exception e)
{
e.printStackTrace();
}
mydb.closed();
if(stuList.size()==0)
{
req.setAttribute("msg", 0);
}
else
{
req.setAttribute("msg", 1);
}
req.setAttribute("stuList", stuList);
req.getRequestDispatcher("admin/stu/stuMana.jsp").forward(req, res);
}
public void stuSearchByXuehao(HttpServletRequest req,HttpServletResponse res) throws ServletException, IOException
{
List stuList=new ArrayList();
String sql="select * from t_stu where del='no' and xuehao like '%"+req.getParameter("xuehao").trim()+"%'";
Object[] params={};
DB mydb=new DB();
try
{
mydb.doPstm(sql, params);
ResultSet rs=mydb.getRs();
while(rs.next())
{
Tstu stu=new Tstu();
stu.setId(rs.getInt("id"));
stu.setXuehao(rs.getString("xuehao"));
stu.setName1(rs.getString("name1"));
stu.setSex(rs.getString("sex"));
stu.setAge(rs.getInt("age"));
stu.setBanji_id(rs.getInt("banji_id"));
stu.setRuxueshijian(rs.getString("ruxueshijian"));
stu.setBiyeshijian(rs.getString("biyeshijian"));
stu.setXuezhi(rs.getString("xuezhi"));
stu.setXuexiao(rs.getString("xuexiao"));
stu.setBanji_name(liuService.getBanjiName(rs.getInt("banji_id")));
stuList.add(stu);
}
rs.close();
}
catch(Exception e)
{
e.printStackTrace();
}
mydb.closed();
if(stuList.size()==0)
{
req.setAttribute("msg", 0);
}
else
{
req.setAttribute("msg", 1);
}
req.setAttribute("stuList", stuList);
req.getRequestDispatcher("admin/stu/stuMana.jsp").forward(req, res);
}
public void stuEdit(HttpServletRequest req,HttpServletResponse res)
{
String xuehao=req.getParameter("xuehao");
String name1=req.getParameter("name1");
String sex=req.getParameter("sex");
int age=Integer.parseInt(req.getParameter("age"));
int banji_id=Integer.parseInt(req.getParameter("banji_id"));
String ruxueshijian=req.getParameter("ruxueshijian");
String biyeshijian=req.getParameter("biyeshijian");
String xuezhi=req.getParameter("xuezhi");
String xuexiao=req.getParameter("xuexiao");
String sql="update t_stu set xuehao=?,name1=?,sex=?,age=?,banji_id=?,ruxueshijian=?,biyeshijian=?,xuezhi=?,xuexiao=? where id="+Integer.parseInt(req.getParameter("id"));
Object[] params={xuehao,name1,sex,age,banji_id,ruxueshijian,biyeshijian,xuezhi,xuexiao};
DB mydb=new DB();
mydb.doPstm(sql, params);
mydb.closed();
req.setAttribute("message", "操作成功");
req.setAttribute("path", "stu?type=stuMana");
String targetURL = "/common/success.jsp";
dispatch(targetURL, req, res);
}
public void stuDetail(HttpServletRequest req,HttpServletResponse res) throws ServletException, IOException
{
Tstu stu=new Tstu();
String sql="select * from t_stu where del='no' and id ="+req.getParameter("id").trim();
Object[] params={};
DB mydb=new DB();
try
{
mydb.doPstm(sql, params);
ResultSet rs=mydb.getRs();
while(rs.next())
{
stu=new Tstu();
stu.setId(rs.getInt("id"));
stu.setXuehao(rs.getString("xuehao"));
stu.setName1(rs.getString("name1"));
stu.setSex(rs.getString("sex"));
stu.setAge(rs.getInt("age"));
stu.setBanji_id(rs.getInt("banji_id"));
stu.setRuxueshijian(rs.getString("ruxueshijian"));
stu.setBiyeshijian(rs.getString("biyeshijian"));
stu.setXuezhi(rs.getString("xuezhi"));
stu.setXuexiao(rs.getString("xuexiao"));
stu.setBanji_name(liuService.getBanjiName(rs.getInt("banji_id")));
}
rs.close();
}
catch(Exception e)
{
e.printStackTrace();
}
mydb.closed();
req.setAttribute("stu", stu);
req.getRequestDispatcher("admin/stu/stuDetail.jsp").forward(req, res);
}
public void stuAll(HttpServletRequest req,HttpServletResponse res) throws ServletException, IOException
{
List stuList=new ArrayList();
String sql="select * from t_stu where del='no'";
Object[] params={};
DB mydb=new DB();
try
{
mydb.doPstm(sql, params);
ResultSet rs=mydb.getRs();
while(rs.next())
{
Tstu stu=new Tstu();
stu.setId(rs.getInt("id"));
stu.setXuehao(rs.getString("xuehao"));
stu.setName1(rs.getString("name1"));
stu.setSex(rs.getString("sex"));
stu.setAge(rs.getInt("age"));
stu.setBanji_id(rs.getInt("banji_id"));
stu.setRuxueshijian(rs.getString("ruxueshijian"));
stu.setBanji_name(liuService.getBanjiName(rs.getInt("banji_id")));
stuList.add(stu);
}
rs.close();
}
catch(Exception e)
{
e.printStackTrace();
}
mydb.closed();
req.setAttribute("stuList", stuList);
req.getRequestDispatcher("admin/stu_xuanke/stuAll.jsp").forward(req, res);
}
public void stuTongji(HttpServletRequest req,HttpServletResponse res) throws ServletException, IOException
{
List stuList=new ArrayList();
String sql="select * from t_stu where del='no' and banji_id=?";
Object[] params={req.getParameter("banji_id")};
DB mydb=new DB();
try
{
mydb.doPstm(sql, params);
ResultSet rs=mydb.getRs();
while(rs.next())
{
Tstu stu=new Tstu();
stu.setId(rs.getInt("id"));
stu.setXuehao(rs.getString("xuehao"));
stu.setName1(rs.getString("name1"));
stu.setSex(rs.getString("sex"));
stu.setAge(rs.getInt("age"));
stu.setBanji_id(rs.getInt("banji_id"));
stu.setRuxueshijian(rs.getString("ruxueshijian"));
stu.setBiyeshijian(rs.getString("biyeshijian"));
stu.setXuezhi(rs.getString("xuezhi"));
stu.setXuexiao(rs.getString("xuexiao"));
stu.setBanji_name(liuService.getBanjiName(rs.getInt("banji_id")));
stuList.add(stu);
}
rs.close();
}
catch(Exception e)
{
e.printStackTrace();
}
mydb.closed();
req.setAttribute("stuList", stuList);
req.getRequestDispatcher("admin/stu/stuMana.jsp").forward(req, res);
}
public void dispatch(String targetURI,HttpServletRequest request,HttpServletResponse response)
{
RequestDispatcher dispatch = getServletContext().getRequestDispatcher(targetURI);
try
{
dispatch.forward(request, response);
return;
}
catch (ServletException e)
{
e.printStackTrace();
}
catch (IOException e)
{
e.printStackTrace();
}
}
public void init(ServletConfig config) throws ServletException
{
super.init(config);
}
public void destroy()
{
}
}