基于javaweb+mysql的jsp+servlet学生选课信息管理系统(java+jsp+servlet+javascript+mysql)
私信源码获取及调试交流
运行环境
Java≥8、MySQL≥5.7、Tomcat≥8
开发工具
eclipse/idea/myeclipse/sts等均可配置运行
适用
课程设计,大作业,毕业设计,项目练习,学习演示等
功能说明
基于javaweb的JSP+Servlet学生选课信息管理系统(java+jsp+servlet+javascript+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项目:否;
技术栈
JSP+CSS+JavaScript+Servlet+mysql
使用说明
- 使用Navicat或者其它工具,在mysql中创建对应名称的数据库,并导入项目的sql文件; 2. 使用IDEA/Eclipse/MyEclipse导入项目,Eclipse/MyEclipse导入时,若为maven项目请选择maven; 若为maven项目,导入成功后请执行maven clean;maven install命令,然后运行; 3. 将项目中conn/Conn.java配置文件中的数据库配置改为自己的配置; 4. 运行项目,输入localhost:8080/Ten 登录 注:Tomcat中设置路径必须为/Ten,否则会有异常 学生账号/密码:1514010919/123456 老师账号/密码:1/admin
/**
* The doGet method of the servlet. <br>
*
* This method is called when a form has its tag value method equals to get.
*
* @param request the request send by the client to the server
* @param response the response send by the server to the client
* @throws ServletException if an error occurred
* @throws IOException if an error occurred
*/
public void doGet(HttpServletRequest request, HttpServletResponse response)
throws ServletException, IOException {
this.doPost(request, response);
}
/**
* The doPost method of the servlet. <br>
*
* This method is called when a form has its tag value method equals to post.
*
* @param request the request send by the client to the server
* @param response the response send by the server to the client
* @throws ServletException if an error occurred
* @throws IOException if an error occurred
*/
public void doPost(HttpServletRequest request, HttpServletResponse response)
throws ServletException, IOException {
response.setContentType("text/html;charset=utf-8");
PrintWriter out = response.getWriter();
out.println("<!DOCTYPE HTML PUBLIC \"-//W3C//DTD HTML 4.01 Transitional//EN\">");
out.println("<HTML>");
out.println(" <HEAD><TITLE>A Servlet</TITLE></HEAD>");
out.println(" <BODY><center>");
try{
request.setCharacterEncoding("utf-8");
Student stu = new Student(Integer.parseInt(request.getParameter("SNo")),request.getParameter("Sname")
,request.getParameter("Spassword"),request.getParameter("Sclass"),request.getParameter("Ssex"),0);
DaoStu update = new DaoStu();
int rs = update.updateStu(stu);
if(rs!=0){
out.println("修改成功:"+stu.getSNo());
}else{
out.println("修改失败"+stu.getSNo());
}
response.sendRedirect("/Ten/tea/selectStu.jsp");
}catch(Exception e){e.printStackTrace();}
out.println("</center></BODY>");
out.println("</HTML>");
out.flush();
public class serDeleteCou extends HttpServlet {
/**
* Constructor of the object.
*/
public serDeleteCou() {
super();
}
/**
* Destruction of the servlet. <br>
*/
public void destroy() {
super.destroy(); // Just puts "destroy" string in log
// Put your code here
}
/**
* The doGet method of the servlet. <br>
*
* This method is called when a form has its tag value method equals to get.
*
* @param request the request send by the client to the server
* @param response the response send by the server to the client
* @throws ServletException if an error occurred
* @throws IOException if an error occurred
*/
public void doGet(HttpServletRequest request, HttpServletResponse response)
throws ServletException, IOException {
this.doPost(request, response);
}
/**
out.println("修改成功:"+cou.getCNo());
}else{
out.println("修改失败"+cou.getCNo());
}
response.sendRedirect("/Ten/tea/selectCou.jsp");
}catch(Exception e){e.printStackTrace();}
out.println("</center></BODY>");
out.println("</HTML>");
out.flush();
out.close();
}
/**
* Initialization of the servlet. <br>
*
* @throws ServletException if an error occurs
*/
public void init() throws ServletException {
// Put your code here
}
}
public class serDoInsertCou extends HttpServlet {
/**
* Constructor of the object.
*/
public serDoInsertCou() {
super();
}
/**
* Destruction of the servlet. <br>
super.destroy(); // Just puts "destroy" string in log
// Put your code here
}
/**
* The doGet method of the servlet. <br>
*
* This method is called when a form has its tag value method equals to get.
*
* @param request the request send by the client to the server
* @param response the response send by the server to the client
* @throws ServletException if an error occurred
* @throws IOException if an error occurred
*/
public void doGet(HttpServletRequest request, HttpServletResponse response)
throws ServletException, IOException {
this.doPost(request, response);
}
/**
* The doPost method of the servlet. <br>
*
* This method is called when a form has its tag value method equals to post.
*
* @param request the request send by the client to the server
* @param response the response send by the server to the client
* @throws ServletException if an error occurred
* @throws IOException if an error occurred
*/
public void doPost(HttpServletRequest request, HttpServletResponse response)
throws ServletException, IOException {
response.setContentType("text/html;charset=utf-8");
PrintWriter out = response.getWriter();
out.println("<!DOCTYPE HTML PUBLIC \"-//W3C//DTD HTML 4.01 Transitional//EN\">");
out.println("<HTML>");
out.println(" <HEAD><TITLE>A Servlet</TITLE></HEAD>");
out.println(" <BODY><center>");
try{
request.setCharacterEncoding("utf-8");
Student stu = new Student(Integer.parseInt(request.getParameter("SNo")),request.getParameter("Sname")
,request.getParameter("Spassword"),request.getParameter("Sclass"),request.getParameter("Ssex"),0);
DaoStu update = new DaoStu();
int rs = update.updateStu(stu);
if(rs!=0){
out.println("修改成功:"+stu.getSNo());
}else{
out.println("修改失败"+stu.getSNo());
}
response.sendRedirect("/Ten/tea/selectStu.jsp");
}catch(Exception e){e.printStackTrace();}
public void doGet(HttpServletRequest request, HttpServletResponse response)
throws ServletException, IOException {
this.doPost(request, response);
}
/**
* The doPost method of the servlet. <br>
*
* This method is called when a form has its tag value method equals to post.
*
* @param request the request send by the client to the server
* @param response the response send by the server to the client
* @throws ServletException if an error occurred
* @throws IOException if an error occurred
*/
public void doPost(HttpServletRequest request, HttpServletResponse response)
throws ServletException, IOException {
response.setContentType("text/html;charset=utf-8");
PrintWriter out = response.getWriter();
out.println("<!DOCTYPE HTML PUBLIC \"-//W3C//DTD HTML 4.01 Transitional//EN\">");
out.println("<HTML>");
out.println(" <HEAD><TITLE>A Servlet</TITLE></HEAD>");
out.println(" <BODY>");
try{
DaoCou delete = new DaoCou();
int rs = delete.deleteCou(Integer.parseInt(request.getParameter("id")));
if(rs==0){
out.println("<center>删除失败!</center>");
response.sendRedirect("/Ten/tea/selectCou.jsp");
}else {
out.println("<center>删除成功!</center>");
response.sendRedirect("/Ten/tea/selectCou.jsp");
}
}catch(Exception e){e.printStackTrace();}
out.println("</BODY>");
out.println("</HTML>");
out.flush();
out.close();
}
/**
* Initialization of the servlet. <br>
*
* @throws ServletException if an error occurs
/**
* The doGet method of the servlet. <br>
*
* This method is called when a form has its tag value method equals to get.
*
* @param request the request send by the client to the server
* @param response the response send by the server to the client
* @throws ServletException if an error occurred
* @throws IOException if an error occurred
*/
public void doGet(HttpServletRequest request, HttpServletResponse response)
throws ServletException, IOException {
this.doPost(request, response);
}
/**
* The doPost method of the servlet. <br>
*
* This method is called when a form has its tag value method equals to post.
*
* @param request the request send by the client to the server
* @param response the response send by the server to the client
* @throws ServletException if an error occurred
* @throws IOException if an error occurred
*/
public void doPost(HttpServletRequest request, HttpServletResponse response)
throws ServletException, IOException {
response.setContentType("text/html;charset=utf-8");
PrintWriter out = response.getWriter();
/**************************************************************/
HttpSession session = request.getSession();
if(session.getAttribute("teacher")==null){
response.sendRedirect("../Login.jsp");
}else{
/**************************************************************/
out.println("<!DOCTYPE HTML PUBLIC \"-//W3C//DTD HTML 4.01 Transitional//EN\">");
out.println("<HTML>");
out.println(" <HEAD><TITLE>A Servlet</TITLE></HEAD>");
out.println(" <BODY>");
try{
int sno = Integer.parseInt(request.getParameter("sno"));
int cno = Integer.parseInt(request.getParameter("cno"));
String classroom = request.getParameter("classroom");
DaoSc update = new DaoSc();
SC sc = new SC();
sc.setSNo(sno);
sc.setCNo(cno);
sc.setClassroom(classroom);
int rs = update.updateClass(sc);
if(rs!=0) {
out.println(" </BODY>");
out.println("</HTML>");}
out.flush();
out.close();
}
/**
* Initialization of the servlet. <br>
*
* @throws ServletException if an error occurs
*/
public void init() throws ServletException {
// Put your code here
}
}
public class serQuerySc extends HttpServlet {
/**
* Constructor of the object.
*/
public serQuerySc() {
super();
}
/**
* Destruction of the servlet. <br>
*/
public void destroy() {
super.destroy(); // Just puts "destroy" string in log
// Put your code here
}
/**
* The doGet method of the servlet. <br>
* This method is called when a form has its tag value method equals to post.
*
* @param request the request send by the client to the server
* @param response the response send by the server to the client
* @throws ServletException if an error occurred
* @throws IOException if an error occurred
*/
public void doPost(HttpServletRequest request, HttpServletResponse response)
throws ServletException, IOException {
response.setContentType("text/html;charset=utf-8");
PrintWriter out = response.getWriter();
HttpSession session = request.getSession();
/************************************************************/
if(session.getAttribute("teacher")==null){
response.sendRedirect("../Login.jsp");
}else{
Teacher tea = (Teacher) session.getAttribute("teacher");
/*************************************************************/
out.println("<!DOCTYPE HTML PUBLIC \"-//W3C//DTD HTML 4.01 Transitional//EN\">");
out.println("<HTML>");
out.println(" <HEAD><TITLE>A Servlet</TITLE></HEAD>");
out.println(" <BODY>");
try{
request.setCharacterEncoding("utf-8");
String queryKey = request.getParameter("queryKey");//查询关键字
int type = 20;//查询类型,默认为20,不是1-6就好
if(request.getParameter("type")!=null){
type = Integer.parseInt(request.getParameter("type"));
}
DaoQuery query = new DaoQuery();
List<QueryResult> list = new ArrayList<QueryResult>();
switch(type){
case 1:
list = query.selectSno(Integer.parseInt(queryKey));break;//学号
case 2:
list = query.selectSname(queryKey);break;//姓名
case 3:
list = query.selectSclass(queryKey);break;//班级
case 4:
list = query.selectCname(queryKey);System.out.println("cname"+queryKey);break;//课程名
case 5:
list = query.selectCno(Integer.parseInt(queryKey));break;//课程号
case 6:
list = query.selectRoom(queryKey);break;//上课教室
case 20:
out.println("<center>请输入查询关键字,并选择查询类型</center>");break;
default:
out.println("<center>错误,请重试!!</center>");break;
}
request.setAttribute("queryResult", list);
request.getRequestDispatcher("/tea/Query.jsp?type="+type+"&key="+queryKey+"").forward(request, response);
* This method is called when a form has its tag value method equals to get.
*
* @param request the request send by the client to the server
* @param response the response send by the server to the client
* @throws ServletException if an error occurred
* @throws IOException if an error occurred
*/
public void doGet(HttpServletRequest request, HttpServletResponse response)
throws ServletException, IOException {
this.doPost(request, response);
}
/**
* The doPost method of the servlet. <br>
*
* This method is called when a form has its tag value method equals to post.
*
* @param request the request send by the client to the server
* @param response the response send by the server to the client
* @throws ServletException if an error occurred
* @throws IOException if an error occurred
*/
public void doPost(HttpServletRequest request, HttpServletResponse response)
throws ServletException, IOException {
response.setContentType("text/html;charset=utf-8");
PrintWriter out = response.getWriter();
out.println("<!DOCTYPE HTML PUBLIC \"-//W3C//DTD HTML 4.01 Transitional//EN\">");
out.println("<HTML>");
out.println(" <HEAD><TITLE>A Servlet</TITLE></HEAD>");
out.println(" <BODY><center>");
try{
request.setCharacterEncoding("utf-8");
Student stu = new Student(Integer.parseInt(request.getParameter("SNo")),request.getParameter("Sname")
,request.getParameter("Spassword"),request.getParameter("Sclass"),request.getParameter("Ssex"),0);
DaoStu update = new DaoStu();
int rs = update.updateStu(stu);
if(rs!=0){
out.println("修改成功:"+stu.getSNo());
}else{
out.println("修改失败"+stu.getSNo());
}
response.sendRedirect("/Ten/tea/selectStu.jsp");
}catch(Exception e){e.printStackTrace();}
out.println("</center></BODY>");
out.println("</HTML>");
if(rs[i]==0) System.out.println("rs"+i+"is null !!");
sum += rs[i];
}
if(sum!=0) {
out.println("<h2><center>选课成功</cneter></h2>");
response.sendRedirect("../stu/showCou.jsp");
}
}else {
out.println("<h2><center>你选择的课程超过上限"+Student.MAXscore+"分!</cneter></h2>");
response.setHeader("refresh", "2;url=../stu/choiceCou.jsp");
}
}else {
out.println("<h2><center>选课失败</cneter></h2>");
response.setHeader("refresh", "2;url=../stu/choiceCou.jsp");
}
}catch(Exception e){e.printStackTrace();out.println("选课失败!");response.setHeader("refresh", "2;url=../stu/choiceCou.jsp");}
out.println(" </BODY>");
out.println("</HTML>");}
out.flush();
out.close();
}
/**
* Initialization of the servlet. <br>
*
* @throws ServletException if an error occurs
*/
public void init() throws ServletException {
// Put your code here
}
}
/**
* Destruction of the servlet. <br>
*/
public void destroy() {
super.destroy(); // Just puts "destroy" string in log
// Put your code here
}
/**
* The doGet method of the servlet. <br>
*
* This method is called when a form has its tag value method equals to get.
*
* @param request the request send by the client to the server
* @param response the response send by the server to the client
* @throws ServletException if an error occurred
* @throws IOException if an error occurred
*/
public void doGet(HttpServletRequest request, HttpServletResponse response)
throws ServletException, IOException {
this.doPost(request, response);
}
/**
* The doPost method of the servlet. <br>
*
* This method is called when a form has its tag value method equals to post.
*
* @param request the request send by the client to the server
* @param response the response send by the server to the client
* @throws ServletException if an error occurred
* @throws IOException if an error occurred
*/
public void doPost(HttpServletRequest request, HttpServletResponse response)
throws ServletException, IOException {
response.setContentType("text/html;charset=utf-8");
PrintWriter out = response.getWriter();
out.println("<!DOCTYPE HTML PUBLIC \"-//W3C//DTD HTML 4.01 Transitional//EN\">");
out.println("<HTML>");
out.println(" <HEAD><TITLE>A Servlet</TITLE></HEAD>");
out.println(" <BODY>");
try{
DaoStu delete = new DaoStu();
int rs = delete.deleteStu(Integer.parseInt(request.getParameter("id")));
if(rs==0){
* @throws ServletException if an error occurs
*/
public void init() throws ServletException {
// Put your code here
}
}
public class serDeleteCou extends HttpServlet {
/**
* Constructor of the object.
*/
public serDeleteCou() {
super();
}
/**
* Destruction of the servlet. <br>
*/
public void destroy() {
super.destroy(); // Just puts "destroy" string in log
// Put your code here
}
/**
* The doGet method of the servlet. <br>
*
* This method is called when a form has its tag value method equals to get.
*
* @param request the request send by the client to the server
* @param response the response send by the server to the client
* Initialization of the servlet. <br>
*
* @throws ServletException if an error occurs
*/
public void init() throws ServletException {
// Put your code here
}
}
public class serDoInsertCou extends HttpServlet {
/**
* Constructor of the object.
*/
public serDoInsertCou() {
super();
}
/**
* Destruction of the servlet. <br>
*/
public void destroy() {
super.destroy(); // Just puts "destroy" string in log
// Put your code here
}
/**
* The doGet method of the servlet. <br>
*
* This method is called when a form has its tag value method equals to get.
* @throws ServletException if an error occurred
* @throws IOException if an error occurred
*/
public void doGet(HttpServletRequest request, HttpServletResponse response)
throws ServletException, IOException {
this.doPost(request, response);
}
/**
* The doPost method of the servlet. <br>
*
* This method is called when a form has its tag value method equals to post.
*
* @param request the request send by the client to the server
* @param response the response send by the server to the client
* @throws ServletException if an error occurred
* @throws IOException if an error occurred
*/
public void doPost(HttpServletRequest request, HttpServletResponse response)
throws ServletException, IOException {
response.setContentType("text/html;charset=utf-8");
PrintWriter out = response.getWriter();
/**************************************************************/
HttpSession session = request.getSession();
if(session.getAttribute("teacher")==null){
response.sendRedirect("../Login.jsp");
}else{
/**************************************************************/
out.println("<!DOCTYPE HTML PUBLIC \"-//W3C//DTD HTML 4.01 Transitional//EN\">");
out.println("<HTML>");
out.println(" <HEAD><TITLE>A Servlet</TITLE></HEAD>");
out.println(" <BODY>");
try{
int sno = Integer.parseInt(request.getParameter("sno"));
int cno = Integer.parseInt(request.getParameter("cno"));
DaoSc update = new DaoSc();
SC sc = update.selectone(sno,cno);
if(sc!=null){
out.println("<!DOCTYPE HTML PUBLIC \"-//W3C//DTD HTML 4.01 Transitional//EN\">");
out.println("<HTML>");
out.println(" <HEAD><TITLE>A Servlet</TITLE></HEAD>");
out.println(" <BODY>");
try{
request.setCharacterEncoding("utf-8");
String queryKey = request.getParameter("queryKey");//查询关键字
int type = 20;//查询类型,默认为20,不是1-6就好
if(request.getParameter("type")!=null){
type = Integer.parseInt(request.getParameter("type"));
}
DaoQuery query = new DaoQuery();
List<QueryResult> list = new ArrayList<QueryResult>();
switch(type){
case 1:
list = query.selectSno(Integer.parseInt(queryKey));break;//学号
case 2:
list = query.selectSname(queryKey);break;//姓名
case 3:
list = query.selectSclass(queryKey);break;//班级
case 4:
list = query.selectCname(queryKey);System.out.println("cname"+queryKey);break;//课程名
case 5:
list = query.selectCno(Integer.parseInt(queryKey));break;//课程号
case 6:
list = query.selectRoom(queryKey);break;//上课教室
case 20:
out.println("<center>请输入查询关键字,并选择查询类型</center>");break;
default:
out.println("<center>错误,请重试!!</center>");break;
}
request.setAttribute("queryResult", list);
request.getRequestDispatcher("/tea/Query.jsp?type="+type+"&key="+queryKey+"").forward(request, response);
}catch(Exception e){response.sendRedirect("/Ten/tea/Query.jsp");e.printStackTrace();}
out.println(" </BODY>");
out.println("</HTML>");
}
out.flush();
out.close();
}
/**
* Initialization of the servlet. <br>
*
* @throws ServletException if an error occurs
*/
public void init() throws ServletException {
// Put your code here
}
*/
public serUpdateClass() {
super();
}
/**
* Destruction of the servlet. <br>
*/
public void destroy() {
super.destroy(); // Just puts "destroy" string in log
// Put your code here
}
/**
* The doGet method of the servlet. <br>
*
* This method is called when a form has its tag value method equals to get.
*
* @param request the request send by the client to the server
* @param response the response send by the server to the client
* @throws ServletException if an error occurred
* @throws IOException if an error occurred
*/
public void doGet(HttpServletRequest request, HttpServletResponse response)
throws ServletException, IOException {
this.doPost(request, response);
}
/**
* The doPost method of the servlet. <br>
*
* This method is called when a form has its tag value method equals to post.
*
* @param request the request send by the client to the server
* @param response the response send by the server to the client
* @throws ServletException if an error occurred
* @throws IOException if an error occurred
*/
public void doPost(HttpServletRequest request, HttpServletResponse response)
throws ServletException, IOException {
response.setContentType("text/html;charset=utf-8");
PrintWriter out = response.getWriter();
/**************************************************************/
HttpSession session = request.getSession();
if(session.getAttribute("teacher")==null){
response.sendRedirect("../Login.jsp");
}else{
public class serQuerySc extends HttpServlet {
/**
* Constructor of the object.
*/
public serQuerySc() {
super();
}
/**
* Destruction of the servlet. <br>
*/
public void destroy() {
super.destroy(); // Just puts "destroy" string in log
// Put your code here
}
/**
* The doGet method of the servlet. <br>
*
* This method is called when a form has its tag value method equals to get.
*
* @param request the request send by the client to the server
* @param response the response send by the server to the client
* @throws ServletException if an error occurred
* @throws IOException if an error occurred
*/
public void doGet(HttpServletRequest request, HttpServletResponse response)
throws ServletException, IOException {
this.doPost(request, response);
}
/**
* The doPost method of the servlet. <br>
*
* This method is called when a form has its tag value method equals to post.
*
* @param request the request send by the client to the server
* @param response the response send by the server to the client
* @throws ServletException if an error occurred
* @throws IOException if an error occurred
*/
public void doPost(HttpServletRequest request, HttpServletResponse response)
throws ServletException, IOException {