大学生创新创业训练计划-学生管理系统源码

package com.studentManagement.daoImpl; import com.studentManagement.dao.StudentDao; import com.studentManagement.po.Student; import com.studentManagement.po.Student_Leader; import com.studentManagement.po.Student_simple; import com.studentManagement.utils.JdbcUtil; import java.sql.Connection; import java.sql.PreparedStatement; import java.sql.ResultSet; import java.sql.SQLException; import java.util.ArrayList; import java.util.List; /** * Created by Administrator on 2017/5/1 0001. */ public class StudentDaoImpl implements StudentDao { private Connection conn = JdbcUtil.getConnection(); private ResultSet resultSet = null; private PreparedStatement preparedStatement = null; @Override//查询学生信息（class_id）（sql分页） public List<Student_simple> queryStudentByClass_id(String class_id, int begin, int end) { List<Student_simple> arrayList = new ArrayList<>(); String sql = "SELECT\n" + "\tstudent_id,\n" + "\tstudent_name,\n" + "\tstudent_sex,\n" + "\tstudent_state,\n" + "\tstudent_qq\n" + "FROM\n" + "\tstudents\n" + "WHERE student_class_id=?\n" + "LIMIT ?,?"; try { preparedStatement = conn.prepareStatement(sql); preparedStatement.setString(1, class_id); preparedStatement.setInt(2, begin); preparedStatement.setInt(3, end); resultSet = preparedStatement.executeQuery(); while (resultSet.next()) { Student_simple student = new Student_simple(); student.setStudent_id(resultSet.getString(1)); student.setStudent_name(resultSet.getString(2)); student.setStudent_sex(resultSet.getString(3)); student.setStudent_state(resultSet.getInt(4)); student.setStudent_qq(resultSet.getString(5)); arrayList.add(student); } } catch (SQLException e) { e.printStackTrace(); } finally { JdbcUtil.closeStatementAndResultSet(resultSet, preparedStatement); JdbcUtil.closeConnection(conn); } return arrayList; } @Override//查询学生头像路径（student_id) public String queryStudentImg(String student_id) { String sql="SELECT students.student_image_Path FROM students WHERE student_id = ?"; String stuentImg=""; try { preparedStatement=conn.prepareStatement(sql); preparedStatement.setString(1,student_id); resultSet=preparedStatement.executeQuery(); while (resultSet.next()){ stuentImg=resultSet.getString(1); } } catch (SQLException e) { e.printStackTrace(); }finally { JdbcUtil.closeStatementAndResultSet(resultSet,preparedStatement); JdbcUtil.closeConnection(conn); } return stuentImg; } @Override//查询学生详细信息（student_id) public Student queryStudentDetail(String student_id) { String sql="SELECT *FROM students WHERE student_id=?"; Student student =new Student(); try { preparedStatement=conn.prepareStatement(sql); preparedStatement.setString(1,student_id); resultSet=preparedStatement.executeQuery(); while (resultSet.next()){ student.setStudent_id(resultSet.getString(1)); student.setStudent_name(resultSet.getString(2)); student.setStudent_key(resultSet.getString(3)); student.setStudent_sex(resultSet.getString(4)); student.setStudent_age(resultSet.getInt(5)); student.setStudent_state(resultSet.getInt(6)); student.setStudent_credit(resultSet.getDouble(7)); student.setStudent_phone(resultSet.getString(8)); student.setStudent_address(resultSet.getString(9)); student.setStudent_qq(resultSet.getString(10)); student.setStudent_nation(resultSet.getString(11)); student.setStudent_dormitory_id(resultSet.getString(12)); student.setStudent_class_id(resultSet.getString(13)); student.setStudent_duty(resultSet.getString(14)); student.setStudent_enter_year(resultSet.getString(15)); student.setStudent_image_Path(resultSet.getString(16)); } } catch (SQLException e) { e.printStackTrace(); }finally { JdbcUtil.closeStatementAndResultSet(resultSet,preparedStatement); JdbcUtil.closeConnection(conn); } return student; } @Override//更新学生详细信息（student_id) public boolean updateStudentDetail(Student student) { boolean boo=false; String sql="UPDATE students\n" + "SET student_name =?, student_key =?, student_sex =?, student_age =?, student_state =?, student_credit =?, student_phone =?, student_address =?, student_qq =?, student_nation =?, student_dormitory_id =?, student_class_id =?, student_duty =?, student_enter_year =?,\n" + " student_image_Path =?\n" + "WHERE\n" + "\tstudent_id =?"; try { preparedStatement=conn.prepareStatement(sql); preparedStatement.setString(1,student.getStudent_name()); preparedStatement.setString(2,student.getStudent_key()); preparedStatement.setString(3,student.getStudent_sex()); preparedStatement.setInt(4,student.getStudent_age()); preparedStatement.setInt(5,student.getStudent_state()); preparedStatement.setDouble(6,student.getStudent_credit()); preparedStatement.setString(7,student.getStudent_phone()); preparedStatement.setString(8,student.getStudent_address()); preparedStatement.setString(9,student.getStudent_qq()); preparedStatement.setString(10,student.getStudent_nation()); preparedStatement.setString(11,student.getStudent_dormitory_id()); preparedStatement.setString(12,student.getStudent_class_id()); preparedStatement.setString(13,student.getStudent_duty()); preparedStatement.setString(14,student.getStudent_enter_year()); preparedStatement.setString(15,student.getStudent_image_Path()); preparedStatement.setString(16,student.getStudent_id()); int i =preparedStatement.executeUpdate(); if(i==1)boo=true; else boo=false; } catch (SQLException e) { e.printStackTrace(); }finally { JdbcUtil.closeStatementAndResultSet(resultSet,preparedStatement); JdbcUtil.closeConnection(conn); } return boo; } @Override//查询学生人数（class_id） public int queryStudentSumByClass_id(String class_id) throws SQLException { String sql = "SELECT count(*) FROM students WHERE student_class_id=?"; int sum = 0; try { preparedStatement = conn.prepareStatement(sql); preparedStatement.setString(1, class_id); resultSet = preparedStatement.executeQuery(); while (resultSet.next()) sum = resultSet.getInt(1); } catch (SQLException e) { e.printStackTrace(); } finally { JdbcUtil.closeStatementAndResultSet(resultSet, preparedStatement); JdbcUtil.closeConnection(conn); } return sum; } @Override //根据关键词查询学生后的总条目 public int queryStudentSumByKeywords(String keywords) throws SQLException { String sql="SELECT DISTINCT count(*)\n" + "FROM\n" + "\tstudents\n" + "WHERE\n" + "\tstudent_id LIKE ? || stude