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数据库