package com.jxd.dao.impl;
import com.jxd.dao.ICourseDao;
import com.jxd.model.Course;
import com.jxd.util.DBUtil;
import java.sql.Connection;
import java.sql.PreparedStatement;
import java.sql.ResultSet;
import java.sql.SQLException;
import java.util.*;
/**
* @ClassName CourseDaoImpl
* @Description TODO
* @Author WangYue
* @Date 2020/9/22
* @Version 1.0
*/
public class CourseDaoImpl implements ICourseDao {
@Override
public List<Map<String ,Object>> selectAllCourse(String courseName) {
List<Map<String ,Object>> list = new ArrayList<>();
Connection conn = DBUtil.getConn();
PreparedStatement pst = null;
ResultSet rs = null;
String sql = "select course.id,coursename,teacherid,name,coursetime,classroom,classweek,coursetype,course.collegeid,score " +
"from course left join teacher on course.teacherid = teacher.id";
if (courseName != null && !"".equals(courseName)) {
sql += " where coursename like ?";
}
try {
pst = conn.prepareStatement(sql);
if (courseName != null && !"".equals(courseName)) {
pst.setString(1, "%" + courseName + "%");
}
rs = pst.executeQuery();
while (rs.next()) {
Map<String,Object> map = new HashMap<>();
map.put("id",rs.getInt(1));
map.put("courseName",rs.getString(2));
map.put("teacherId",rs.getInt(3));
map.put("teacherName",rs.getString(4));
map.put("courseTime",rs.getString(5));
map.put("classRoom",rs.getString(6));
map.put("classWeek",rs.getInt(7));
map.put("courseType",rs.getString(8));
map.put("collegeId",rs.getInt(9));
map.put("score",rs.getInt(10));
list.add(map);
}
} catch (SQLException e) {
e.printStackTrace();
} finally {
DBUtil.CloseAll(conn, pst, rs);
}
return list;
}
@Override
public List<Map<String ,Object>> selectCourseByPage(int pageStart, int pageSize, String courseName) {
List<Map<String ,Object>> list = new ArrayList<>();
Connection conn = DBUtil.getConn();
PreparedStatement pst = null;
ResultSet rs = null;
String sql = "select course.id,coursename,teacherid,name,coursetime,classroom,classweek,coursetype,course.collegeid,score " +
"from course left join teacher on course.teacherid = teacher.id";
if (courseName != null && !"".equals(courseName)) {
sql += " where coursename like ?";
}
sql += " limit ?,?";
try {
pst = conn.prepareStatement(sql);
if (courseName != null && !"".equals(courseName)) {
pst.setString(1, "%" + courseName + "%");
pst.setInt(2, pageStart);
pst.setInt(3, pageSize);
} else {
pst.setInt(1, pageStart);
pst.setInt(2, pageSize);
}
rs = pst.executeQuery();
while (rs.next()) {
Map<String,Object> map = new HashMap<>();
map.put("id",rs.getInt(1));
map.put("courseName",rs.getString(2));
map.put("teacherId",rs.getInt(3));
map.put("teacherName",rs.getString(4));
map.put("courseTime",rs.getString(5));
map.put("classRoom",rs.getString(6));
map.put("classWeek",rs.getInt(7));
map.put("courseType",rs.getString(8));
map.put("collegeId",rs.getInt(9));
map.put("score",rs.getInt(10));
list.add(map);
}
} catch (SQLException e) {
e.printStackTrace();
} finally {
DBUtil.CloseAll(conn, pst, rs);
}
return list;
}
@Override
public List<Course> selectAllCourseByTeacherId(int teacherId, String courseName) {
List<Course> list = new ArrayList<>();
Connection conn = DBUtil.getConn();
PreparedStatement pst = null;
ResultSet rs = null;
String sql = "select id,coursename,teacherid,coursetime,classroom,classweek,coursetype,collegeid,score " +
"from course where teacherid = ?";
if (courseName != null && !"".equals(courseName)) {
sql += "and coursename like ?";
}
try {
pst = conn.prepareStatement(sql);
pst.setInt(1, teacherId);
if (courseName != null && !"".equals(courseName)) {
pst.setString(2, "%" + courseName + "%");
}
rs = pst.executeQuery();
while (rs.next()) {
Course course = new Course();
course.setId(rs.getInt(1));
course.setCourseName(rs.getString(2));
course.setTeacherId(rs.getInt(3));
course.setCourseTime(rs.getString(4));
course.setClassRoom(rs.getString(5));
course.setClassWeek(rs.getInt(6));
course.setCourseType(rs.getString(7));
course.setCollegeId(rs.getInt(8));
course.setScore(rs.getInt(9));
list.add(course);
}
} catch (SQLException e) {
e.printStackTrace();
} finally {
DBUtil.CloseAll(conn, pst, rs);
}
return list;
}
@Override
public List<Course> selectCourseByPageAndTeacherId(int pageStart, int pageSize, int teacherId, String courseName) {
List<Course> list = new ArrayList<>();
Connection conn = DBUtil.getConn();
PreparedStatement pst = null;
ResultSet rs = null;
String sql = "select id,coursename,teacherid,coursetime,classroom,classweek,coursetype,score " +
"from course where teacherid = ? ";
if (courseName != null && !"".equals(courseName)) {
sql += "and coursename like ?";
}
sql += " limit ?,?";
try {
pst = conn.prepareStatement(sql);
if (courseName != null && !"".equals(courseName)) {
pst.setInt(1, teacherId);
pst.setString(2, "%" + courseName + "%");
pst.setInt(3, pageStart);
pst.setInt(4, pageSize);
} else {
pst.setInt(1, teacherId);
pst.setInt(2, pageStart);
pst.setInt(3, pageSize);
}
rs = pst.executeQuery();
while (rs.next()) {
Course course = new Course();
course.setId(rs.getInt(1));
course.setCourseName(rs.getString(2));
course.setTeacherId(rs.getInt(3));
course.setCourseTime(rs.getString(4));
course.setClassRoom(rs.getString(5));
course.setClassWeek(rs.getInt(6));
course.setCourseType(rs.getString(7));
course.setScore(rs.getInt(8));
list.add(course);
}
} catch (SQLException e) {
e.printStackTrace();
} finally {
DBUtil.CloseAll(conn, pst, rs);
}
return list;
}
@Override
public boolean insertCourse(Course course) {
boolean flag = false;
Connection conn = DBUtil.getConn();
PreparedStatement pst = null;
String sql = "insert into course (id,coursename,teacherid,coursetime,classroom,classweek,coursetype,collegeid,score) " +
"values(default,?,?,?,?,?,?,?,?)";
try {
pst = conn.prepareStatement(sql);
pst.setS
JavaWeb项目-教务系统（管理员、教师、学生登录）
1星 需积分: 50 113 浏览量
2020-09-30
12:35:30
上传
评论 35
收藏 6.57MB ZIP 举报 
JavaWeb项目-教务系统（管理员、教师、学生登录） （503个子文件） 
CourseDaoImpl.class 12KB CourseDaoImpl.class 12KB SelectedCourseDaoImpl.class 7KB SelectedCourseDaoImpl.class 7KB TeacherDaoImpl.class 7KB TeacherDaoImpl.class 7KB StudentDaoImpl.class 7KB StudentDaoImpl.class 7KB UserLoginDaoImpl.class 7KB UserLoginDaoImpl.class 7KB GetSelectedCourseByStudentIDServlet.class 3KB GetSelectedCourseByStudentIDServlet.class 3KB CourseServiceImpl.class 3KB CourseServiceImpl.class 3KB EditUserServlet.class 3KB EditUserServlet.class 3KB AddStudentServlet.class 3KB AddStudentServlet.class 3KB AddTeacherServlet.class 3KB AddTeacherServlet.class 3KB EditTeacherServlet.class 3KB EditTeacherServlet.class 3KB GetAllCourseForStudentServlet.class 3KB GetAllCourseForStudentServlet.class 3KB EditStudentServlet.class 3KB EditStudentServlet.class 3KB GetCourseByTeacherIDServlet.class 3KB GetCourseByTeacherIDServlet.class 3KB GetSelectedCourseByIDServlet.class 3KB GetSelectedCourseByIDServlet.class 3KB GetUsersNotAdminServlet.class 3KB GetUsersNotAdminServlet.class 3KB LoginServlet.class 3KB LoginServlet.class 3KB EditCourseServlet.class 3KB EditCourseServlet.class 3KB GetAllStudentServlet.class 3KB GetAllTeacherServlet.class 3KB GetAllTeacherServlet.class 3KB GetAllStudentServlet.class 3KB GetAllCourseServlet.class 3KB GetAllCourseServlet.class 3KB AddSelectedCourseServlet.class 3KB AddSelectedCourseServlet.class 3KB AddCourseServlet.class 3KB AddCourseServlet.class 3KB DeleteUserServlet.class 3KB DeleteUserServlet.class 3KB DeleteSelectedCourseServlet.class 2KB DeleteSelectedCourseServlet.class 2KB EditPasswordByIDServlet.class 2KB EditPasswordByIDServlet.class 2KB EditSelectedCourseServlet.class 2KB EditSelectedCourseServlet.class 2KB GetAllCourseByIDForEditServlet.class 2KB GetAllCourseByIDForEditServlet.class 2KB CheckOldPasswordServlet.class 2KB CheckOldPasswordServlet.class 2KB DeleteTeacherServlet.class 2KB DeleteTeacherServlet.class 2KB DeleteStudentServlet.class 2KB DeleteStudentServlet.class 2KB CollegeDaoImpl.class 2KB GetOneStudentForEditServlet.class 2KB CollegeDaoImpl.class 2KB GetOneStudentForEditServlet.class 2KB GetAllStudentByIDForEditServlet.class 2KB GetAllTeacherByIDForEditServlet.class 2KB GetAllStudentByIDForEditServlet.class 2KB GetAllTeacherByIDForEditServlet.class 2KB GetUserNotAdminByIDServlet.class 2KB GetUserNotAdminByIDServlet.class 2KB Course.class 2KB Course.class 2KB SelectedCourseServiceImpl.class 2KB SelectedCourseServiceImpl.class 2KB TeacherServiceImpl.class 2KB StudentServiceImpl.class 2KB StudentServiceImpl.class 2KB TeacherServiceImpl.class 2KB UserLoginServiceImpl.class 2KB UserLoginServiceImpl.class 2KB GetAllCollegeIDAndNameServlet.class 2KB GetAllCollegeIDAndNameServlet.class 2KB DeleteCourseServlet.class 2KB DeleteCourseServlet.class 2KB GetAllTeacherIDAndNameServlet.class 2KB GetAllTeacherIDAndNameServlet.class 2KB GetStudentOfSelectedCourseForEditServlet.class 2KB GetStudentOfSelectedCourseForEditServlet.class 2KB Teacher.class 2KB Teacher.class 2KB DBUtil.class 2KB DBUtil.class 2KB ICourseService.class 2KB ICourseService.class 2KB Student.class 1KB Student.class 1KB ICourseDao.class 1KB ICourseDao.class 1KB共 503 条
- 1
- 2
- 3
- 4
- 5
- 6
资源评论
weixin_414867472021-04-30数据库文件在哪里
W.君
- 粉丝: 5
- 资源: 1
最新资源
- 常用工具集参考用于图像等数据处理
- 音乐展示网页、基于Stenography的图像数字水印添加与提取，以及基于颜色矩和Tamura算法的图像相似度评估算法py源码
- 基于EmguCV(OpenCV .net封装)，图像数字水印加解密算法的实现,其中包含最低有效位算法,离散傅里叶变换算法+文档书
- 基于matlab+DWT的图像水印项目，数字水印+源代码+文档说明+图片+报告pdf
- (优秀毕业设计)基于python实现的数字图像可视化水印系统的设计与实现，多种数字算法实现+源代码+文档说明+理论演示pdf
- 基于DWT-DCT-SVD和deflate压缩的数字水印方法python源码+Gui界面+演示视频(高分毕业设计)
- 基于matlab实现DWT、DCT、SVD算法数字图像水印可视化系统+GUI界面+文档说明+详细注释(高分毕业设计)
- NCIAE-Data-Structure大一大二笔记
- 学习wireshark笔记
- digital-image-数据可视化笔记
资源上传下载、课程学习等过程中有任何疑问或建议，欢迎提出宝贵意见哦~我们会及时处理！
点击此处反馈
