基于javaweb+mysql的jsp+servlet学籍管理系统(java+jsp+javascript+servlet+mysql)
运行环境
Java≥8、MySQL≥5.7、Tomcat≥8
开发工具
eclipse/idea/myeclipse/sts等均可配置运行
适用
课程设计,大作业,毕业设计,项目练习,学习演示等
功能说明
基于javaweb+mysql的JSP+Servlet学籍管理系统(java+jsp+javascript+servlet+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.数据库:MySql 5.7版本; 6.是否Maven项目: 否;
技术栈
- 后端:servlet 2. 前端:JSP+css+javascript
使用说明
- 使用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/ 登录
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
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"));
stuList.add(stu);
}
rs.close();
}
catch(Exception e)
{
e.printStackTrace();
}
mydb.closed();
return stuList;
}
public List kechengAll()
{
try
{
Thread.sleep(700);
} catch (InterruptedException e)
{
// TODO Auto-generated catch block
e.printStackTrace();
}
List kechengList=new ArrayList();
String sql="select * from t_kecheng where del='no'";
Object[] params={};
DB mydb=new DB();
try
{
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 (InterruptedException e)
{
// TODO Auto-generated catch block
e.printStackTrace();
}
WebContext ctx = WebContextFactory.get();
HttpSession session=ctx.getSession();
TAdmin admin=(TAdmin)session.getAttribute("admin");
String sql="update t_admin set userPw=? where userId=?";
Object[] params={userPwNew,admin.getUserId()};
DB mydb=new DB();
mydb.doPstm(sql, params);
return "yes";
}
public List zhuanyeAll()
{
try
{
Thread.sleep(700);
} catch (InterruptedException e)
{
// TODO Auto-generated catch block
e.printStackTrace();
}
List zhuanyeList=new ArrayList();
String sql="select * from t_zhuanye where del='no'";
Object[] params={};
DB mydb=new DB();
try
{
mydb.doPstm(sql, params);
ResultSet rs=mydb.getRs();
while(rs.next())
{
Tzhuanye zhuanye=new Tzhuanye();
zhuanye.setId(rs.getInt("id"));
zhuanye.setName(rs.getString("name"));
}
rs.close();
}
catch(Exception e)
{
e.printStackTrace();
}
mydb.closed();
req.setAttribute("chengjiList", chengjiList);
req.getRequestDispatcher("admin/chengji/chengjiMana.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()
{
}
}
{
Thread.sleep(700);
} catch (InterruptedException e)
{
// TODO Auto-generated catch block
e.printStackTrace();
}
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"));
stuList.add(stu);
}
rs.close();
}
catch(Exception e)
{
e.printStackTrace();
}
mydb.closed();
return stuList;
}
public List kechengAll()
{
try
{
Thread.sleep(700);
} catch (InterruptedException e)
{
// TODO Auto-generated catch block
e.printStackTrace();
}
List kechengList=new ArrayList();
String sql="select * from t_kecheng where del='no'";
Object[] params={};
}
}
public class jiangcheng_servlet extends HttpServlet
{
public void service(HttpServletRequest req,HttpServletResponse res)throws ServletException, IOException
{
String type=req.getParameter("type");
if(type.endsWith("jiangchengMana"))
{
jiangchengMana(req, res);
}
if(type.endsWith("jiangchengAdd"))
{
jiangchengAdd(req, res);
}
if(type.endsWith("jiangchengDel"))
{
jiangchengDel(req, res);
}
if(type.endsWith("jiangchengEditPre"))
{
jiangchengEditPre(req, res);
}
if(type.endsWith("jiangchengSearch"))
{
jiangchengSearch(req, res);
}
}
Object[] params={};
DB mydb=new DB();
mydb.doPstm(sql, params);
mydb.closed();
req.setAttribute("message", "操作成功");
req.setAttribute("path", "chengji?type=chengjiMana");
String targetURL = "/common/success.jsp";
dispatch(targetURL, req, res);
}
public void chengjiMana(HttpServletRequest req,HttpServletResponse res) throws ServletException, IOException
{
List chengjiList=new ArrayList();
String sql="select * from t_chengji where del='no'";
Object[] params={};
DB mydb=new DB();
try
{
mydb.doPstm(sql, params);
ResultSet rs=mydb.getRs();
while(rs.next())
{
Tchengji chengji=new Tchengji();
chengji.setId(rs.getInt("id"));
chengji.setStu_id(rs.getInt("stu_id"));
chengji.setKecheng_id(rs.getInt("kecheng_id"));
chengji.setChengji(rs.getInt("chengji"));
chengji.setXuenian(rs.getString("xuenian"));
chengji.setStu_xuehao(liuService.getStuXuehao(rs.getInt("stu_id")));
chengji.setKecheng_name(liuService.getKechengName(rs.getInt("kecheng_id")));
chengjiList.add(chengji);
}
rs.close();
}
catch(Exception e)
{
e.printStackTrace();
}
mydb.closed();
req.setAttribute("chengjiList", chengjiList);
req.getRequestDispatcher("admin/chengji/chengjiMana.jsp").forward(req, res);
}
public void dispatch(String targetURI,HttpServletRequest request,HttpServletResponse response)
{
try
{
Thread.sleep(700);
} catch (InterruptedException e)
{
// TODO Auto-generated catch block
e.printStackTrace();
}
List zhuanyeList=new ArrayList();
String sql="select * from t_zhuanye where del='no'";
Object[] params={};
DB mydb=new DB();
try
{
mydb.doPstm(sql, params);
ResultSet rs=mydb.getRs();
while(rs.next())
{
Tzhuanye zhuanye=new Tzhuanye();
zhuanye.setId(rs.getInt("id"));
zhuanye.setName(rs.getString("name"));
zhuanye.setJieshao(rs.getString("jieshao"));
zhuanyeList.add(zhuanye);
}
rs.close();
}
catch(Exception e)
{
e.printStackTrace();
}
mydb.closed();
return zhuanyeList;
}
public List banjiAll()
{
try
{
Thread.sleep(700);
} catch (InterruptedException e)
{
// TODO Auto-generated catch block
e.printStackTrace();
}
{
public void service(HttpServletRequest req,HttpServletResponse res)throws ServletException, IOException
{
String type=req.getParameter("type");
if(type.endsWith("chengjiMana"))
{
chengjiMana(req, res);
}
if(type.endsWith("chengjiAdd"))
{
chengjiAdd(req, res);
}
if(type.endsWith("chengjiDel"))
{
chengjiDel(req, res);
}
}
public void chengjiAdd(HttpServletRequest req,HttpServletResponse res)
{
int stu_id=Integer.parseInt(req.getParameter("stu_id"));
int kecheng_id=Integer.parseInt(req.getParameter("kecheng_id"));
int chengji=Integer.parseInt(req.getParameter("chengji"));
String xuenian=req.getParameter("xuenian");
String del="no";
String sql="insert into t_chengji(`stu_id`,`kecheng_id`,`chengji`,`xuenian`,`del`) values(?,?,?,?,?)";
Object[] params={stu_id,kecheng_id,chengji,xuenian,del};
DB mydb=new DB();
mydb.doPstm(sql, params);
mydb.closed();
req.setAttribute("message", "操作成功");
req.setAttribute("path", "chengji?type=chengjiMana");
String targetURL = "/common/success.jsp";
dispatch(targetURL, req, res);
}
public void chengjiDel(HttpServletRequest req,HttpServletResponse res)
{
String sql="update t_chengji 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", "chengji?type=chengjiMana");
public void banjiDel(HttpServletRequest req,HttpServletResponse res)
{
String sql="update t_banji 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", "banji?type=banjiMana");
String targetURL = "/common/success.jsp";
dispatch(targetURL, req, res);
}
public void banjiMana(HttpServletRequest req,HttpServletResponse res) throws ServletException, IOException
{
List banjiList=new ArrayList();
String sql="select * from t_banji where del='no' order by zhuanye_id";
Object[] params={};
DB mydb=new DB();
try
{
mydb.doPstm(sql, params);
ResultSet rs=mydb.getRs();
while(rs.next())
{
Tbanji banji=new Tbanji();
banji.setId(rs.getInt("id"));
banji.setName(rs.getString("name"));
banji.setZhuanye_id(rs.getInt("zhuanye_id"));
banji.setZhuanye_name(liuService.getZhuanyeName(rs.getInt("zhuanye_id")));
banjiList.add(banji);
}
rs.close();
}
catch(Exception e)
{
e.printStackTrace();
}
mydb.closed();
req.setAttribute("banjiList", banjiList);
req.getRequestDispatcher("admin/banji/banjiMana.jsp").forward(req, res);
}
public void dispatch(String targetURI,HttpServletRequest request,HttpServletResponse response)
{
RequestDispatcher dispatch = getServletContext().getRequestDispatcher(targetURI);
try
{
dispatch.forward(request, response);
public void jiangchengMana(HttpServletRequest req,HttpServletResponse res) throws ServletException, IOException
{
List jiangchengList=new ArrayList();
String sql="select * from t_jiangcheng where del='no'";
Object[] params={};
DB mydb=new DB();
try
{
mydb.doPstm(sql, params);
ResultSet rs=mydb.getRs();
while(rs.next())
{
Tjiangcheng jiangcheng=new Tjiangcheng();
jiangcheng.setId(rs.getInt("id"));
jiangcheng.setStu_id(rs.getInt("stu_id"));
jiangcheng.setShijian(rs.getString("shijian"));
jiangcheng.setShuxing(rs.getString("shuxing"));
jiangcheng.setBeizhu(rs.getString("beizhu"));
jiangcheng.setStu_xuehao(liuService.getStuXuehao(rs.getInt("stu_id")));
jiangchengList.add(jiangcheng);
}
rs.close();
}
catch(Exception e)
{
e.printStackTrace();
}
mydb.closed();
req.setAttribute("jiangchengList", jiangchengList);
req.getRequestDispatcher("admin/jiangcheng/jiangchengMana.jsp").forward(req, res);
}
public void jiangchengEditPre(HttpServletRequest req,HttpServletResponse res)
{
Integer id=Integer.parseInt(req.getParameter("id"));
int stu_id=Integer.parseInt(req.getParameter("stu_id"));
String shijian=req.getParameter("shijian");
String shuxing=req.getParameter("shuxing");
String beizhu=req.getParameter("beizhu");
String del="no";
String sql="update t_jiangcheng set stu_id=?,shijian=?,shuxing=?,beizhu=?,del=? where id=?";
Object[] params={stu_id,shijian,shuxing,beizhu,del,id};
DB mydb=new DB();
mydb.doPstm(sql, params);
mydb.closed();
req.setAttribute("message", "操作成功");
public void kechengAdd(HttpServletRequest req,HttpServletResponse res)
{
String name=req.getParameter("name");
String jieshao=req.getParameter("jieshao");
String del="no";
String sql="insert into t_kecheng(name,jieshao,del) values(?,?,?)";
Object[] params={name,jieshao,del};
DB mydb=new DB();
mydb.doPstm(sql, params);
mydb.closed();
req.setAttribute("message", "操作成功");
req.setAttribute("path", "kecheng?type=kechengMana");
String targetURL = "/common/success.jsp";
dispatch(targetURL, req, res);
}
public void kechengDel(HttpServletRequest req,HttpServletResponse res)
{
String sql="update t_kecheng 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", "kecheng?type=kechengMana");
String targetURL = "/common/success.jsp";
dispatch(targetURL, req, res);
}
public void kechengMana(HttpServletRequest req,HttpServletResponse res) throws ServletException, IOException
{
List kechengList=new ArrayList();
String sql="select * from t_kecheng where del='no'";
Object[] params={};
DB mydb=new DB();
try
{
mydb.doPstm(sql, params);
ResultSet rs=mydb.getRs();
while(rs.next())
{
Tkecheng kecheng=new Tkecheng();
kecheng.setId(rs.getInt("id"));
kecheng.setName(rs.getString("name"));
kecheng.setJieshao(rs.getString("jieshao"));
kechengList.add(kecheng);
}
rs.close();
}
catch(Exception e)
{
String type=req.getParameter("type");
if(type.endsWith("jiangchengMana"))
{
jiangchengMana(req, res);
}
if(type.endsWith("jiangchengAdd"))
{
jiangchengAdd(req, res);
}
if(type.endsWith("jiangchengDel"))
{
jiangchengDel(req, res);
}
if(type.endsWith("jiangchengEditPre"))
{
jiangchengEditPre(req, res);
}
if(type.endsWith("jiangchengSearch"))
{
jiangchengSearch(req, res);
}
}
public void jiangchengAdd(HttpServletRequest req,HttpServletResponse res)
{
int stu_id=Integer.parseInt(req.getParameter("stu_id"));
String shijian=req.getParameter("shijian");
String shuxing=req.getParameter("shuxing");
String beizhu=req.getParameter("beizhu");
String del="no";
String sql="insert into t_jiangcheng(`stu_id`,`shijian`,`shuxing`,`beizhu`,`del`) values(?,?,?,?,?)";
Object[] params={stu_id,shijian,shuxing,beizhu,del};
DB mydb=new DB();
mydb.doPstm(sql, params);
mydb.closed();
req.setAttribute("message", "操作成功");
req.setAttribute("path", "jiangcheng?type=jiangchengMana");
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)
{
}
}
public class banji_servlet extends HttpServlet
{
public void service(HttpServletRequest req,HttpServletResponse res)throws ServletException, IOException
{
String type=req.getParameter("type");
if(type.endsWith("banjiMana"))
{
banjiMana(req, res);
}
if(type.endsWith("banjiAdd"))
{
banjiAdd(req, res);
}
if(type.endsWith("banjiDel"))
{
banjiDel(req, res);
}
}
public void banjiAdd(HttpServletRequest req,HttpServletResponse res)
{
String name=req.getParameter("name");
List kechengList=new ArrayList();
String sql="select * from t_stu_kecheng where stu_id=?";
Object[] params={stu_id};
DB mydb=new DB();
try
{
mydb.doPstm(sql, params);
ResultSet rs=mydb.getRs();
while(rs.next())
{
Tkecheng kecheng=new Tkecheng();
kecheng.setId(rs.getInt("kecheng_id"));
kecheng.setName(liuService.getKechengName(rs.getInt("kecheng_id")));
kechengList.add(kecheng);
}
rs.close();
}
catch(Exception e)
{
e.printStackTrace();
}
mydb.closed();
System.out.println(kechengList.size());
req.setAttribute("kechengList", kechengList);
req.setAttribute("stu_id", stu_id);
req.getRequestDispatcher("admin/stu_xuanke/kechengByStu.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
{