项目类型：JAVA WEB项目（B/S架构）
项目名称：基于Jsp+Servlet的教师评教管理系统
用户类型：1个角色（管理员）
系统类型：后台管理系统
设计模式：Jsp+Servlet界面外观：HTML+CSS
开发工具：Idea
数据库：Mysql+Navicat
数据库表：2张
适用：软件工程、计算机科学与技术等课程的学习或实验
作者介绍：计科学长，定期发布高质量手工开发源码，提供Java设计的指导！双1流高校刚毕业的学长，曾经也是个小白!
关注回复 练习 免费get 本系统
关注回复 学生 免费get 一套JavaWeb源码
关注回复 ppt 免费get 367套毕设答辩ppt模板
关注回复 简历 免费get 200套程序猿简历模板
关注获取地址：其他项目以及项目来源（学长源码公众号）
免费ppt：
免费简历：
目录
功能展示
登录
登录功能代码实例
loginController.java
@WebServlet(urlPatterns = "/loginController.do")
public class LoginController extends Base2Controller {
/**
* 登录
*
* @param req
* @param resp
* @return
*/
public String login(HttpServletRequest req, HttpServletResponse resp) {
//1、接受数据；
String userName = req.getParameter("userName");
String password = req.getParameter("password");
//3、调用业务；
//封裝
User user =new User();
user.setUserName(userName);
user.setPassword(password);
//调用业务；
User users = userService.queryUser(user);
//Student student_db = studentService.queryStudentByStudent(student);
if (users != null) {
//保存登陆用户信息
HttpSession session = req.getSession();
session.setAttribute("user", users);
req.setAttribute("message", "登录成功！");
//2、跳转页面；
return "view/main/main.jsp";
} else {
//友情提示
req.setAttribute("message", "用户名或密码错误，请重新输入！！！");
//2、跳转页面；
return "login.jsp";
}
}
/**
* 权限生产动态页面
*/
public String left(HttpServletRequest req, HttpServletResponse resp) {
return "view/main/left.jsp";
}
}
UserDao.java
public class UserDaoImpl implements UserDao {
@Override
public User queryUser(User user) {
//操作数据库
Connection conn = null;
PreparedStatement pstmt = null;
ResultSet rs = null;
// 查询数据库
try {
conn = JdbcUtils.getConnection();
String sql = "SELECT * FROM user WHERE userName =? and password=?";
pstmt = conn.prepareStatement(sql);
pstmt.setString(1, user.getUserName());
pstmt.setString(2, user.getPassword());
rs = pstmt.executeQuery();
while (rs.next()) {
User users = new User();
users.setId(rs.getInt("id"));
users.setUserName(rs.getString("userName"));
users.setPassword(rs.getString("password"));
users.setNickName(rs.getString("nickName"));
return users;
}
} catch (ClassNotFoundException | IOException | SQLException e) {
e.printStackTrace();
}
return null;
}
}
评教管理
添加一个评教
评教功能代码
TeachController.java
@WebServlet(urlPatterns = "/teacherController.do")
public class TeachController extends Base2Controller {
private SimpleDateFormat sdf = new SimpleDateFormat("yyyy-MM-dd HH:mm");
/**
* 1.列表
*/
public String teachList(HttpServletRequest req, HttpServletResponse resp) {
String titleName = req.getParameter("titleName");
//接收数据
Map<String,Object> map = new HashMap<String,Object>();
map.put("titleName",titleName);
//储存数据到集合
List<Teach> list = teachService.queryTeachList(map);
//返回数据
req.setAttribute("list", list);
return "view/system/teach/teachList.jsp";
}
/**
* 去新增页面
*/
public String toAddTeach(HttpServletRequest req, HttpServletResponse resp) {
return "view/system/teach/addTeach.jsp";
}
/**
* 新增
*/
public String addTeach(HttpServletRequest req, HttpServletResponse resp) {
String sno = req.getParameter("sno");
String sname = req.getParameter("sname");
String titleName = req.getParameter("titleName");
String theme = req.getParameter("theme");
String content = req.getParameter("content");
Teach teach =new Teach();
teach.setZt(theme);
teach.setXybh(sno);
teach.setPjsj(sdf.format(new Date()));
teach.setSname(sname);
teach.setPjnr(content);
teach.setKcmc(titleName);
teach.setJs("管理员");
boolean re = teachService.addTeach(teach);
/* //储存数据到集合
List<Teach> list = teachService.queryTeachList(null);
//返回数据
req.setAttribute("list", list);
return "view/system/teach/teachList.jsp";*/
//接收数据
Map<String,Object> map = new HashMap<String,Object>();
List<Teach> list = teachService.queryTeachList(map);
req.setAttribute("list", list);
return "view/system/teach/teachList.jsp";
}
/**
* 去修改页面
*/
public String toUpdateTeach(HttpServletRequest req, HttpServletResponse resp) {
Integer id = Integer.parseInt(req.getParameter("id"));
Teach te = teachService.selectTeachById(id);
req.setAttribute("teach", te);
return "view/system/teach/updateTeach.jsp";
}
/**
* 修改
*/
public String updateTeach(HttpServletRequest req, HttpServletResponse resp) {
Integer id = Integer.parseInt(req.getParameter("tid"));
String sno = req.getParameter("sno");
String sname = req.getParameter("sname");
String titleName = req.getParameter("titleName");
String theme = req.getParameter("theme");
String content = req.getParameter("content");
Teach teach =new Teach();
teach.setZt(theme);
teach.setXybh(sno);
teach.setPjsj(sdf.format(new Date()));
teach.setSname(sname);
teach.setPjnr(content);
teach.setKcmc(titleName);
teach.setId(id);
boolean re = teachService.updateTeach(teach);
/* //储存数据到集合
List<Teach> list = teachService.queryTeachList(null);
//返回数据
req.setAttribute("list", list);
return "view/system/teach/teachList.jsp";*/
Map<String,Object> map = new HashMap<String,Object>();
List<Teach> list = teachService.queryTeachList(map);
req.setAttribute("list", list);
return "view/system/teach/teachList.jsp";
}
/**
* 删除
*/
public String deleteTeach(HttpServletRequest req, HttpServletResponse resp) {
Integer id = Integer.parseInt(req.getParameter("id"));
boolean re = teachService.deleteTeach(id);
//储存数据到集合
List<Teach> list = teachService.queryTeachList(null);
//返回数据
req.setAttribute("list", list);
return "view/system/teach/teachList.jsp";
}
}TeachDaoImpl.java
/**
* 查询所有评教记录
* @param map
* @return
*/
@Override
public List<Teach> queryTeachList(Map<String, Object> map) {
//操作数据库
Connection conn = null;
PreparedStatement pstmt = null;
ResultSet rs = null;
// 查询数据库
try {
conn = JdbcUtils.getConnection();
String sql = " SELECT * FROM teach where 1 = 1";
if (map.get("titleName") != null && !map.get("titleName").toString().equals("")){
sql = sql + " and kcmc like ? ";
pstmt = conn.prepareStatement(sql);
pstmt.setString(1, "%"+map.get("titleName").toString()+"%");
}else{
pstmt = conn.prepareStatement(sql);
}
rs = pstmt.executeQuery();
//对象列表
List<Teach> teachList = new ArrayList<Teach>();
while (rs.next()) {
Teach teach = new Teach();
teach.setId(rs.getInt("id"));
teach.setJs(rs.getString("js"));
teach.setKcmc(rs.getString("kcmc"));
teach.setPjnr(rs.getString("pjnr"));
teach.setSname(rs.getString("sname"));
teach.setPjsj(rs.getString("pjsj"));
teach.setXybh(rs.getString("xybh"));
teach.setZt(rs.getString("zt"));
//放每个对象
teachList.add(teach);
}
return teachList;
} catch (ClassNotFoundException | IOException | SQLException e) {
e.printStackTrace();
}
return null;
}
/**
* 新增
* @param teach
* @return
*/
@Override
public boolean addTeach(Teach teach) {
//操作数据库
Connection conn = null;
PreparedStatement pstmt = null;
boolean rs = false;
// 查询数据库
try {
conn = JdbcUtils.getConnection();
String sql = " insert into teach ( xybh,zt,pjnr,kcmc,js,pjsj,sname) values(?,?,?,?,?,?,?) ";
pstmt = conn.prepareStatement(sql);
pstmt.setString(1, teach.getXybh());
pstmt.setString(2, teach.getZt());
pstmt.setString(3, teach.getPjnr());
pstmt.setString(4, teach.getKcmc());
pstmt.setString(5, teach.getJs());
pstmt.setString(6, teach.getPjsj());
pstmt.setString(7, teach.getSname());
rs = pstmt.execute();
} catch (ClassNotFoundException | IOException | SQLException e) {
e.printStackTrace();
}
return rs;
}
/**
* 查询单个评教记录
* @param id
* @return
*/
@Override
public Teach selectTeachById(Integer id) {
//操作数据库
Connection conn = null;
PreparedStatement pstmt = null;
ResultSet rs = null;
Teach teach = new Teach();
// 查询数据库
try {
conn = JdbcUtils.getConnection();
String sql = " SELECT * FROM teach where id =? ";
pstmt = conn.prepareStatement(sql);
pstmt.setInt(1, id);
rs = pstmt.executeQuery();
while (rs.next()) {
teach.setId(rs.getInt("id"));
teach.setJs(rs.getString("js"));
teach.setKcmc(rs.getString("kcmc"));
teach.setPjnr(rs.getString("pjnr"));
teach.setSname(rs.getString("sname"));
teach.setPjsj(rs.getString("pjsj"));
teach.setXybh(rs.getString("xybh"));
teach.setZt(rs.getString("zt"));
//放每个对象
}
} catch (ClassNotFoundException | IOException | SQLException e) {
e.printStackTrace();
}
return teach;
}
/**
* 修改
* @param teach
* @return
*/
@Override
public boolean updateTeach(Teach teach) {
Connection conn = null;
PreparedStatement pstmt = null;
boolean rs = false;
try {
conn = JdbcUtils.getConnection();
String sql = " update teach set xybh =?, zt =?,pjnr =?,kcmc =?,pjsj =?,sname =? where id=? ";
pstmt = conn.prepareStatement(sql);
pstmt.setString(1, teach.getXybh());
pstmt.setString(2, teach.getZt());
pstmt.setString(3, teach.getPjnr());
pstmt.setString(4, teach.getKcmc());
pstmt.setString(5, teach.getPjsj());
pstmt.setString(6, teach.getSname());
pstmt.setInt(7,teach.getId());
rs = pstmt.execute();
} catch (ClassNotFoundException | IOException | SQLException e) {
e.printStackTrace();
}
return rs;
}
/**
* 删除
* @param id
* @return
*/
@Override
public boolean deleteTeach(Integer id) {
Connection conn = null;
PreparedStatement pstmt = null;
boolean rs = false;
try {
conn = JdbcUtils.getConnection();
String sql = " delete from teach where id=? ";
pstmt = conn.prepareStatement(sql);
pstmt.setInt(1,id);
rs = pstmt.execute();
} catch (ClassNotFoundException | IOException | SQLException e) {
e.printStackTrace();
}
return rs;
}
}
项目结构目录
数据库设计
评教内容表，记录了评教的信息
登录账号表
2611
被折叠的 条评论
为什么被折叠?
到【灌水乐园】发言
