package Dao;
import Model.Teacher;
import utils.DbUtils;
import java.sql.ResultSet;
import java.sql.SQLException;
import java.util.ArrayList;
import java.util.List;
public class TeacherDao {
public List<Teacher> queryAll(){
ResultSet resultSet = DbUtils.exeQuery("select * from teacher ");
List<Teacher> teacherList = new ArrayList<>();
try {
while (resultSet.next()){
Teacher teacher = new Teacher(resultSet.getInt(1),
resultSet.getString(2),
resultSet.getDouble(3),
resultSet.getString(4),
resultSet.getString(5),
resultSet.getString(6)
);
teacherList.add(teacher);
}
}catch (SQLException throwables){
throwables.printStackTrace();
}finally {
DbUtils.closeConnection();
}
return teacherList;
}
public List<Teacher> searchTeacher(String teacherName){
String sql = "select * from teacher where teacherName like '%" + teacherName + "%'";
ResultSet resultSet = DbUtils.exeQuery(sql);
List<Teacher> teacherList = new ArrayList<>();
try {
while (resultSet.next()){
Teacher teacher = new Teacher(resultSet.getInt(1),
resultSet.getString(2),
resultSet.getDouble(3),
resultSet.getString(4),
resultSet.getString(5),
resultSet.getString(6)
);
teacherList.add(teacher);
}
}catch (SQLException throwables){
throwables.printStackTrace();
}finally {
DbUtils.closeConnection();
}
return teacherList;
}
public Teacher selectById(int teacherId){
String sql = "select * from teacher where teacherId = ?";
ResultSet resultSet = DbUtils.exeQuery(sql,teacherId);
try {
if(resultSet.next()){
return new Teacher(resultSet.getInt(1),
resultSet.getString(2),
resultSet.getDouble(3),
resultSet.getString(4),
resultSet.getString(5),
resultSet.getString(6));
}
}catch (SQLException throwables){
throwables.printStackTrace();
}finally {
DbUtils.closeConnection();
}
return null;
}
public int insert(Teacher teacher){
String sql = "insert into teacher values(?,?,?,?,?,?)";
return DbUtils.exeUpdate(sql,teacher.getTeacherId(),teacher.getTeacherName(),
teacher.getWage(),teacher.getTeacherSex(),
teacher.getTeacherDiscipline(),teacher.getNote());
}
public int delete(int teacherId){
String sql = "delete from teacher where teacherId = ?";
return DbUtils.exeUpdate(sql,teacherId);
}
public int update(Teacher teacher) {
String sql = "update teacher set teacherName = ?,wage = ?,teacherSex = ?,teacherDiscipline = ?,note = ? where teacherId = ?";
return DbUtils.exeUpdate(sql, teacher.getTeacherName(), teacher.getWage(),
teacher.getTeacherSex(), teacher.getTeacherDiscipline(), teacher.getNote(),
teacher.getTeacherId());
}
}
计算机191-26.rar
需积分: 1 74 浏览量
2023-11-21
09:30:00
上传
评论
收藏 7.52MB RAR 举报
计算机191-26.rar （251个子文件） 
TeacherDao.class 4KB TeacherDao.class 4KB CourseDao.class 4KB CourseDao.class 4KB ClassDao.class 4KB ClassDao.class 4KB StudentDao.class 4KB StudentDao.class 4KB DbUtils.class 3KB DbUtils.class 3KB CourseUpdateServlet.class 3KB CourseUpdateServlet.class 3KB CourseAddServlet.class 3KB CourseAddServlet.class 3KB OpinionDao.class 2KB OpinionDao.class 2KB LoginServlet.class 2KB LoginServlet.class 2KB WageUpdateServlet.class 2KB WageUpdateServlet.class 2KB TeacherUpdateServlet.class 2KB TeacherUpdateServlet.class 2KB TeacherAddServlet.class 2KB TeacherAddServlet.class 2KB RegisterServlet.class 2KB RegisterServlet.class 2KB ChangePSWDServlet.class 2KB ChangePSWDServlet.class 2KB StudentUpdateServlet.class 2KB StudentUpdateServlet.class 2KB StudentAddServlet.class 2KB StudentAddServlet.class 2KB OpinionAddServlet.class 2KB OpinionAddServlet.class 2KB ClassUpdateServlet.class 2KB ClassUpdateServlet.class 2KB ClassAddServlet.class 2KB ClassAddServlet.class 2KB WageSearchServlet.class 2KB WageSearchServlet.class 2KB CourseSearchServlet.class 2KB CourseSearchServlet.class 2KB StudentSearchServlet.class 2KB TeacherSearchServlet.class 2KB StudentSearchServlet.class 2KB TeacherSearchServlet.class 2KB OpinionDelServlet.class 2KB TeacherDelServlet.class 2KB StudentDelServlet.class 2KB TeacherDelServlet.class 2KB OpinionDelServlet.class 2KB StudentDelServlet.class 2KB ClassSearchServlet.class 2KB ClassSearchServlet.class 2KB CourseDelServlet.class 2KB CourseDelServlet.class 2KB ClassDelServlet.class 2KB ClassDelServlet.class 2KB Teacher.class 2KB Teacher.class 2KB Course.class 2KB Course.class 2KB TeacherToUpdateServlet.class 2KB StudentToUpdateServlet.class 2KB TeacherToUpdateServlet.class 2KB StudentToUpdateServlet.class 2KB CourseToUpdateServlet.class 2KB CourseToUpdateServlet.class 2KB WageToUpdateServlet.class 2KB WageToUpdateServlet.class 2KB ClassToUpdateServlet.class 2KB ClassToUpdateServlet.class 2KB AdminDao.class 2KB AdminDao.class 2KB TeacherMServlet.class 2KB OpinionMServlet.class 2KB StudentMServlet.class 2KB OpinionMServlet.class 2KB StudentMServlet.class 2KB TeacherMServlet.class 2KB CourseMServlet.class 2KB CourseMServlet.class 2KB WageMServlet.class 2KB WageMServlet.class 2KB ClassMServlet.class 2KB ClassMServlet.class 2KB Student.class 1KB Student.class 1KB LogOffServlet.class 1KB LogOffServlet.class 1KB StudentService.class 1KB TeacherService.class 1KB StudentService.class 1KB TeacherService.class 1KB CourseService.class 1KB CourseService.class 1KB ClassService.class 1KB ClassService.class 1KB Class.class 1KB Class.class 1KB共 251 条
- 1
- 2
- 3
资源评论
