学生基本信息管理-高级Java课程设计（B/S版）

package an.junior.student.DAO; import java.sql.ResultSet; import java.sql.SQLException; import java.sql.Statement; import java.util.ArrayList; import java.util.HashMap; import java.util.List; import java.util.Map; import an.junior.database.DBConnection; import an.junior.entity.Classes; import an.junior.entity.Collegue; import an.junior.entity.Department; import an.junior.entity.Student; public class StudentDAOImpl implements StudentDAO { //***************************学生信息操作********************* public Student addStudent(Student student) { String sql="insert into student(studentId,studentName,studentSex,studentAge,classId,collegueName,departmentName,studentHobby,studentResume) " + "values(:studentId,:studentName,:studentSex,:studentAge,:classId,:collegueName,:departmentName,:studentHobby,:studentResume) "; Map<String,Object> params = new HashMap<String,Object>(); params.put("studentId",student.getStudentId()); params.put("studentName",student.getStudentName()); params.put("studentSex",student.getStudentSex()); params.put("studentAge",student.getStudentAge()); params.put("classId",student.getClassId()); params.put("collegueName",student.getCollegueName()); params.put("departmentName",student.getDepartmentName()); params.put("studentHobby",student.getStudentHobby()); params.put("studentResume",student.getStudentResume()); DBConnection.getInstance().executeUpdate(sql, params); return null; } public void deleteStudent(Student student) { deleteStudentById(student.getStudentId()); } public void deleteStudentById(String studentId) { String sql = "delete from student where studentId=" + studentId; DBConnection.getInstance().excute(sql); } public List<Student> findAll() { String sql = "select * from student"; List<Student> students = findBySQL(sql); return students; } public Student findById(String studentId) { String sql = "select * from student where studentId=" + studentId; Student student = new Student(); try { Statement statement = DBConnection.getInstance().createStatement(); ResultSet resultSet = statement.executeQuery(sql); if(resultSet.next()){ student.setStudentId(resultSet.getString("studentId")); student.setStudentName(resultSet.getString("studentName")); student.setStudentSex(resultSet.getString("studentSex")); student.setStudentAge(resultSet.getInt("studentAge")); student.setStudentHobby(resultSet.getString("studentHobby")); student.setStudentResume(resultSet.getString("studentResume")); student.setClassId(resultSet.getString("classId")); student.setDepartmentName(resultSet.getString("departmentName")); student.setCollegueName(resultSet.getString("collegueName")); } } catch (SQLException e) { e.printStackTrace(); } return student; } public List<Student> findByName(String studentName) { String sql = "select * from student where studentName=" + "'" + studentName + "'"; List<Student> students = findBySQL(sql); return students; } public Student updateStudent(Student student) { String sql = "update student set studentName=:studentName,studentSex=:studentSex,studentAge=:studentAge,classId=:classId," + "collegueName=:collegueName,departmentName=:departmentName" + " where studentId=" + student.getStudentId(); Map<String,Object> params = new HashMap<String,Object>(); params.put("studentId",student.getStudentId()); params.put("studentName",student.getStudentName()); params.put("studentSex",student.getStudentSex()); params.put("studentAge",student.getStudentAge()); params.put("classId",student.getClassId()); params.put("collegueName",student.getCollegueName()); params.put("departmentName",student.getDepartmentName()); params.put("studentHobby",student.getStudentHobby()); params.put("studentResume",student.getStudentResume()); DBConnection.getInstance().executeUpdate(sql, params); return null; } public List<Student> findByClass(String studentClass) { String sql = "select * from student where classId='" + studentClass + "'"; List<Student> students = findBySQL(sql); return students; } public List<Student> findByCollegue(String studentCollegue) { String sql = "select * from student where collegueName like " + "'" + studentCollegue + "%'"; List<Student> students = findBySQL(sql); return students; } public List<Student> findByDepartment(String studentDepartment) { String sql = "select * from student where departmentName like " + "'" + studentDepartment + "%'"; List<Student> students = findBySQL(sql); return students; } /** * 模糊查询学生的爱好,返回一个学生的链表 */ public List<Student> findByHobby(String studentHobby) { String sql = "select * from student where studentHobby like " + "'" + studentHobby + "%'"; List<Student> students = findBySQL(sql); return students; } /** * 仅供其它DAO方法调用，按拼接的sql语句查询，返回一个学生的链表 */ private List<Student> findBySQL(String sql) { List<Student> students = new ArrayList<Student>(); try { Statement statement = DBConnection.getInstance().createStatement(); ResultSet resultSet = statement.executeQuery(sql); while(resultSet.next()){ Student student = new Student(); student.setStudentId(resultSet.getString("studentId")); student.setStudentName(resultSet.getString("studentName")); student.setStudentSex(resultSet.getString("studentSex")); student.setStudentAge(resultSet.getInt("studentAge")); student.setStudentHobby(resultSet.getString("studentHobby")); student.setStudentResume(resultSet.getString("studentResume")); student.setClassId(resultSet.getString("classId")); student.setDepartmentName(resultSet.getString("departmentName")); student.setCollegueName(resultSet.getString("collegueName")); students.add(student); } } catch (SQLException e) { e.printStackTrace(); } return students; } public Student updateStudent(String studentId, Map<String, Object> params) { String sql = "update student set studentName=:studentName,studentSex=:studentSex,studentAge=:studentAge,classId=:classId," + "collegueName=:collegueName,departmentName=:departmentName,studentHobby=:studentHobby,studentResume=:studentResume" + " where studentId=" + studentId; DBConnection.getInstance().executeUpdate(sql, params); return null; } public List<Student> findBySex(String studentSex) { String sql = "select * from student where studentSex=" + "'" + studentSex + "'"; List<Student> students = findBySQL(sql); return students; } public List<Student> findByCollegueId(String collegueId) { String sql = "select * from collegue where collegueId=" + collegueId; List<Student> students = findBySQL(sql); return students; } public List<Student> findByCollegueName(String collegueName) { String collegueId = findCollegueByName(collegueName).getCollegueId(); List<Student> students = findByCollegueId(collegueId); return students; } //**********************************学院信息操作********************************************* public Collegue findCollegueById(String collegueId) { String sql = "select * from collegue where collegueId=" + collegueId; Collegue collegue = null; try { Statement statement = DBConnection.getInstance().createStatement(); ResultSet resultSet = statement.executeQuery(sql); if(resultSet.next()){ collegue = new Collegue(); collegue.setCollegueId(resultSet.getString("collegueId")); collegue.setCollegueName(resultSet.getString("collegueName")); collegue.setCollegueTel(resultSet.getString("collegueTel")); } } catch (SQLException e) { e.printStackTrace(); } return collegue; } public List<Collegue> findAllCollegue() { List<Collegue>