学生管理系统项目（用Java简单实现）

package indi.wrenn.studentsystem.dao; import indi.wrenn.studentsystem.entity.AnalyzeResult; import indi.wrenn.studentsystem.entity.Student; import indi.wrenn.studentsystem.entity.User; import java.sql.Connection; import java.sql.DriverManager; import java.sql.PreparedStatement; import java.sql.ResultSet; import java.sql.SQLException; //与数据库通信的类 import java.util.HashMap; import java.util.LinkedHashMap; import java.util.Vector; public class JdbcHelper implements JdbcConfig{ //定义连接数据库所需要的对象 private PreparedStatement ps = null; private ResultSet rs = null; private Connection ct = null; //获得数据库的连接 private void init(){ try { Class.forName(DRIVER); ct = DriverManager.getConnection(URL, USERNAME, PASSWORD);// 获得数据库连接 } catch (ClassNotFoundException e) { // TODO Auto-generated catch block e.printStackTrace(); } catch (SQLException e) { // TODO Auto-generated catch block e.printStackTrace(); } } //无参构造函数 public JdbcHelper(){ this.init(); } /** * 获取用户对象 * 根据传入的用户名，获取对应的用户，并返回用户对象 * @return 用户对象 */ public User getUser(User user){ User newUser = new User(); try { ps = ct.prepareStatement("select * from tb_User where User_name=?"); ps.setString(1, user.getUsername()); rs = ps.executeQuery(); if(rs.next()){ newUser.setUsername(rs.getString(1)); //设置用户名 newUser.setPassword(rs.getString(2)); //设置密码 newUser.setIsLogin(rs.getInt(3)); //设置是否登陆 } } catch (SQLException e) { // TODO Auto-generated catch block e.printStackTrace(); } return newUser; } /** * 注册处理 * @param user 用户对象 * @return 返回是否注册成功 */ public boolean register(User user){ boolean b = true; try { ps = ct.prepareStatement("insert into tb_User(User_name,Password_) values(?,?)"); ps.setString(1, user.getUsername()); ps.setString(2, user.getPassword()); if(ps.executeUpdate()!=1){ //执行sql语句 b = false; } } catch (SQLException e) { b = false; e.printStackTrace(); } return b; } /** * 修改用户"是否"登陆状态 * @param user * @return */ public boolean update_IsLogin(User user){ boolean b = true; try { ps = ct.prepareStatement("update tb_User set IsLogin=? where User_name=?"); ps.setInt(1, user.getIsLogin()); ps.setString(2, user.getUsername()); if(ps.executeUpdate()!=1){ b = false; } } catch (SQLException e) { b = false; e.printStackTrace(); } return b; } /** * 修改密码 * @param user 用户对象 * @param new_Password 新密码 * @return 返回是否修改成功 */ public boolean update_Password(User user,String new_Password){ boolean b = true; try { ps = ct.prepareStatement("update tb_User set Password_=? where User_name=?"); ps.setString(1, new_Password); ps.setString(2, user.getUsername()); if(ps.executeUpdate()!=1){ //执行sql语句 b = false; } } catch (SQLException e) { b = false; e.printStackTrace(); } return b; } /** * 获得所有院系 * @return 返回所有院系的HashMap集合 */ public HashMap<String, String> getAllDepartment(){ HashMap<String, String> map = new LinkedHashMap<String, String>(); map.put("", "");//添加一个空的元素 try { ps = ct.prepareStatement("select * from tb_Department order by Department_ID"); rs = ps.executeQuery(); while(rs.next()){ map.put(rs.getString(2),rs.getString(1)); } } catch (SQLException e) { // TODO Auto-generated catch block e.printStackTrace(); } return map; } /** * 获得对应院系的专业 * @return 返回Vector<String>对象 */ public Vector<String> getMajor(String department_ID){ Vector<String> vector = new Vector<String>(); vector.add("");//添加一个空的元素 try { ps = ct.prepareStatement("select * from tb_Major where Department_ID=? order by Major_ID"); ps.setString(1, department_ID); rs = ps.executeQuery(); while(rs.next()){ vector.add(rs.getString(2)); //获得专业名称 } } catch (SQLException e) { e.printStackTrace(); } return vector; } /** * 获得所有专业 * @return 返回所有专业 */ public HashMap<String, String>getAllMajor(){ HashMap<String, String> map = new LinkedHashMap<String, String>(); map.put("", "");//添加一个空的元素 try { ps = ct.prepareStatement("select * from tb_Major order by Major_ID"); rs = ps.executeQuery(); while(rs.next()){ map.put(rs.getString(2),rs.getString(1)); } } catch (SQLException e) { // TODO Auto-generated catch block e.printStackTrace(); } return map; } /** * 添加学生 * @param student 学生对象 * @return 返回是否添加成功 */ public boolean addStudent(Student student){ boolean b = true; try { ps = ct.prepareStatement("insert into tb_Student(Student_Id,Student_Name,Student_Sex,Classe,Grade,Major_ID,Department_ID,Major_Name,Department_Name) values(?,?,?,?,?,?,?,?,?)"); ps.setString(1, student.getStudent_ID()); ps.setString(2, student.getStudent_Name()); ps.setString(3, student.getSex()); ps.setString(4, student.getClasse()); ps.setString(5, student.getGrade()); ps.setString(6, student.getMajor_ID()); ps.setString(7, student.getDepartment_ID()); ps.setString(8, student.getMajor_Name()); ps.setString(9, student.getDepartment_Name()); if(ps.executeUpdate()!=1){ b = false; } } catch (SQLException e) { b = false; e.printStackTrace(); } return b; } /** * 修改学生信息 * @param newStudent 新学生对象 * @param oldStudentID 旧学生信息 * @return 是否修改成功 */ public boolean updateStudent(Student newStudent,String oldStudentID){ boolean b = true; try { //update ps = ct.prepareStatement("update tb_Student set Student_Id=?, Student_Name=?, Student_Sex=? ,Classe=? ,Grade=? ,Major_ID=? ,Department_ID=? ,Major_Name=? ,Department_Name=? where Student_Id=?"); ps.setString(1, newStudent.getStudent_ID()); ps.setString(2, newStudent.getStudent_Name()); ps.setString(3, newStudent.getSex()); ps.setString(4, newStudent.getClasse()); ps.setString(5, newStudent.getGrade()); ps.setString(6, newStudent.getMajor_ID()); ps.setString(7, newStudent.getDepartment_ID()); ps.setString(8, newStudent.getMajor_Name()); ps.setString(9, newStudent.getDepartment_Name()); ps.setString(10, oldStudentID); if(ps.executeUpdate()!=1){ b = false; } } catch (SQLException e) { b = false; e.printStackTrace(); } return b; } /** * 根据学生学号从数据库移除该学生 * @param studentID 学生学号 * @return 返回是否删除成功 */ public boolean deleteStudent(String studentID){ boolean b = true; try { ps = ct.prepareStatement("delete from tb_Student where Student_Id=?"); ps.setString(1, studentID); if(ps.executeUpdate()!=1){ b = false; } } catch (SQLException e) { // TODO Auto-generated catch block b = false; e.printStackTrace(); } return b; } /** * 根据sql语句返回特定的学生集合 * @param sql sql语句 * @return 返回Vector<Student>对象 */ public Vector<Student> getStudent(String sql){ Vector<Student> students = new Vector<Student>(); try { ps = ct.prepareStatement(sql); rs = ps.executeQuery(); while(rs.next()){ Student student = new Student(); student.setStudent_ID(rs.getString(1)); student.setStudent_Name(rs.getString(2)); student.setSex(rs.getString(3)); student.setGrade(rs.getString(4)); student.setClasse(rs.getString(5)); student.setMajor_ID(rs.getString(6)); student.setMajor_Name(rs.getString(7)); student.setDepartment_ID(rs.getString(8)); student.setDepartment_Name(rs.getString(9)); students.add(student); } }catch(SQLException e){ e.printStackTrace(); } return students; } /**