基于SSM在线学习网站包含课程管理-错题-收藏-考试测试-学生教师管理员58198(idea-javaweb-javaee-j2ee-springboot)

1 概述

 

通过本系统，用户能够摒弃传统的学习方式，提高学习兴趣和学习质量；系统对录入数据的严格审核流程，确保了数据的真实性和可靠性，为用户充分准备提供方便的渠道；不同的用户，程度不同，所拥有的权限也不一样，通过本系统，用户能够认识到自己的水平，并逐步提高；通过本系统，用户可以在留言区分享信息，对于抱有疑问的问题可以上传解惑，也可形成小组相互督促。

2 数据库表

 

表3 t_stu  学生表

名称	类型	说明
id	int(11)	编号
xuehao	longtext	用户名
name1	longtext	姓名
sex	longtext	性别
age	longtext	年龄
loginpw	longtext	密码
quanxian		0学生 1学生委员

表4 t_rizhi学生日志

字段名称	自动增长	字段类型	说明
id	-	int	编号
title	-	varchar	标题
type	-	varchar	TAG
nanyi	-	varchar	备注
content	-	varchar	内容
fujian	-	varchar	附件
fujianYuanshiming	-	varchar	附件说明
shijian	-	varchar	时间
del	-	varchar	是否删除
xuesheng_id	-	int	学生ID

表5 t_ t_kecheng课程表

字段名称	自动增长	字段类型	说明
id	-	int	编号
name	-	varchar	名称
jieshao	-	varchar	介绍
del	-	varchar	是否删除

3 关键代码

 

package com.action;

import java.io.IOException;
import java.sql.ResultSet;
import java.util.ArrayList;
import java.util.List;

import javax.servlet.RequestDispatcher;
import javax.servlet.ServletConfig;
import javax.servlet.ServletException;
import javax.servlet.http.HttpServlet;
import javax.servlet.http.HttpServletRequest;
import javax.servlet.http.HttpServletResponse;
import javax.servlet.http.HttpSession;

import com.dao.DB;
import com.orm.TAdmin;
import com.orm.Tkecheng;
import com.orm.Tstu;
import com.service.liuService;

public class kecheng_servlet extends HttpServlet
{
	public void service(HttpServletRequest req,HttpServletResponse res)throws ServletException, IOException 
	{
        String type=req.getParameter("type");
		
    	if(type.endsWith("kechengMana"))
		{
			kechengMana(req, res);
		}
    	if(type.endsWith("kechengTeaMana"))
		{
    		kechengTeaMana(req, res);
		}
		if(type.endsWith("kechengAdd"))
		{
			kechengAdd(req, res);
		}
				if (type.equals("kechengDel")) {
			kechengDel(req, res);
		}
		if (type.equals("kechengTeaDel")) {
			kechengTeaDel(req, res);
		}
	if(type.endsWith("kechengAll"))
		{
			kechengAll(req, res);
		}
	}
	
	
	public void kechengAdd(HttpServletRequest req,HttpServletResponse res)
	{
		
		HttpSession session=req.getSession();
		Tstu stu=(Tstu)session.getAttribute("stu");
        int stuid=stu.getId();//当前登录的用户的ID
		
		String name=req.getParameter("name");
		String jieshao=req.getParameter("jieshao");
		String del="no";
		String sql="insert into t_kecheng values(?,?,?,?,?)";
		Object[] params={null,name,jieshao,del,stuid};
		DB mydb=new DB();
		mydb.doPstm(sql, params);
		mydb.closed();
		
		req.setAttribute("message", "操作成功");
		req.setAttribute("path", "kecheng?type=kechengTeaMana");
		
        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 kechengTeaDel(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=kechengTeaMana");

		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"));
				kecheng.setStu_id(rs.getInt("stu_id"));
				kecheng.setStu_name(liuService.getStuName(rs.getInt("stu_id")));
						kechengList.add(kecheng);
		    }
			rs.close();
		}
		catch(Exception e)
		{
			e.printStackTrace();
		}
		mydb.closed();
		
		req.setAttribute("kechengList", kechengList);
		req.getRequestDispatcher("admin/kecheng/kechengMana.jsp").forward(req, res);
	}
	
	public void kechengAll(HttpServletRequest req,HttpServletResponse res) throws ServletException, IOException
	{
		List kechengList=new ArrayList();
		String sql="select * from t_kecheng k left join t_stu stu on k.stu_id=stu.id  where k.del='no'";
		if(req.getParameter("name")!=null)sql+=" and (name like '%"+req.getParameter("name").trim()+"%' or name1 like '%"+req.getParameter("name").trim()+"%') ";

		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"));
				kecheng.setStu_id(rs.getInt("stu_id"));
				kecheng.setStu_name(liuService.getStuName(rs.getInt("stu_id")));
						kechengList.add(kecheng);
		    }
			rs.close();
		}
		catch(Exception e)
		{
			e.printStackTrace();
		}
		mydb.closed();
		
		req.setAttribute("kechengList", kechengList);
		req.getRequestDispatcher("qiantai/kecheng/kechengAll.jsp").forward(req, res);
	}
	
	
	
	public void kechengTeaMana(HttpServletRequest req,HttpServletResponse res) throws ServletException, IOException
	{
		
		HttpSession session=req.getSession();
		Tstu stu=(Tstu)session.getAttribute("stu");
        int stuid=stu.getId();//当前登录的用户的ID
	
		List kechengList=new ArrayList();
		String sql="select * from t_kecheng where del='no' and stu_id="+stuid;
		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"));
				kecheng.setStu_id(rs.getInt("stu_id"));
				kecheng.setStu_name(liuService.getStuName(rs.getInt("stu_id")));
						kechengList.add(kecheng);
		    }
			rs.close();
		}
		catch(Exception e)
		{
			e.printStackTrace();
		}
		mydb.closed();
		
		req.setAttribute("kechengList", kechengList);
		req.getRequestDispatcher("tea/kecheng/kechengMana.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() 
	{
		
	}
}

4 效果演示

 

idea或eclipse开发,mysql数据库