proj.rar_离校管理

package com.dao; import java.sql.CallableStatement; import java.sql.Connection; import java.sql.Statement; import java.sql.ResultSet; import java.sql.SQLException; import java.util.ArrayList; import java.util.List; import com.bean.StudentBean; public class StudentDao { private Connection con; private CallableStatement cstmt; ProcedureDBManager pdbm; ResultSet rs; public StudentDao() { pdbm = new ProcedureDBManager(); con = pdbm.getCon(); } /** * 验证学号和密码，若匹配则返回true * @param num * @param psw * @return */ public int StudentLoginCheck(String num, String psw) { int stu_id = -1; try { cstmt = con.prepareCall("{call sp_student_query(?,?)}"); cstmt.setString(1, num); cstmt.setString(2, psw); pdbm.setCstmt(cstmt); rs = pdbm.getResult(); //若输入正确 while (rs.next()) { stu_id = rs.getInt("stu_id"); } con.close(); } catch (SQLException e) { System.out.println("logincheck error!"); return -1; } return stu_id ; } public StudentBean getStudentByNum(String stu_num) { StudentBean studentBean = new StudentBean(); try { cstmt = con.prepareCall("{call sp_query_single_student_by_num(?)}"); cstmt.setString(1,stu_num); pdbm.setCstmt(cstmt); rs = pdbm.getResult(); while (rs.next()) { studentBean.setStu_id(rs.getInt("stu_id")); studentBean.setStu_age(rs.getInt("stu_age")); studentBean.setClass_name(rs.getString("class_name").trim()); studentBean.setDom_name(rs.getString("dom_name").trim()); studentBean.setIn_time(rs.getString("in_time").trim()); studentBean.setStu_finance(rs.getString("stu_finance").trim()); studentBean.setStu_name(rs.getString("stu_name").trim()); studentBean.setStu_sex(rs.getString("stu_sex").trim()); studentBean.setStu_password(rs.getString("stu_password").trim()); studentBean.setStu_num(rs.getString("stu_num").trim()); } con.close(); } catch (SQLException e) { System.out.println(e.toString()); } return studentBean; } /** * 学生查询个人资料通过编号 * @param stu_id * @return */ public StudentBean getStudent(int stu_id) { StudentBean studentBean = new StudentBean(); try { cstmt = con.prepareCall("{call sp_student_query_all(?)}"); cstmt.setInt(1,stu_id); pdbm.setCstmt(cstmt); rs = pdbm.getResult(); //若输入正确 while (rs.next()) { studentBean.setStu_id(rs.getInt("stu_id")); studentBean.setStu_age(rs.getInt("stu_age")); studentBean.setClass_name(rs.getString("class_name")); studentBean.setDom_name(rs.getString("dom_name")); studentBean.setIn_time(rs.getString("in_time")); studentBean.setStu_finance(rs.getString("stu_finance")); studentBean.setStu_name(rs.getString("stu_name")); studentBean.setStu_sex(rs.getString("stu_sex")); studentBean.setStu_password(rs.getString("stu_password")); studentBean.setStu_num(rs.getString("stu_num")); } con.close(); } catch (SQLException e) { System.out.println(e.toString()); } return studentBean; } /** * 学生注册 * @param class_id * @param dom_id * @param stu_num * @param stu_name * @param stu_sex * @param stu_age * @param stu_password * @param in_time * @param stu_finance * @return */ public boolean addStudent(int class_id,int dom_id,int stu_age,String stu_num,String stu_name,String stu_sex,String stu_password,String in_time,String stu_finance ) { try { cstmt = con.prepareCall("{call sp_add_student(?,?,?,?,?,?,?,?,?)}"); System.out.println("class_id:"+class_id+"|dom_id:"+dom_id+"|stu_age:"+stu_age+"|stu_num:"+stu_num+"|stu_name:"+stu_name+"|stu_sex:"+stu_sex+"|in_time"+in_time+"|stu_finance:"+stu_finance); cstmt.setInt(1,class_id); cstmt.setInt(2,dom_id); cstmt.setInt(3,stu_age); cstmt.setString(4,stu_num); cstmt.setString(5, stu_name); cstmt.setString(6,stu_sex); cstmt.setString(7,stu_password); cstmt.setString(8,in_time); cstmt.setString(9,stu_finance); pdbm.setCstmt(cstmt); pdbm.updateSql(); System.out.println("ok"); } catch (SQLException e) { System.out.println(e.toString()); } return true; } public boolean modifyFinance(int stu_id,String stu_finance) { try { cstmt = con.prepareCall("{call sp_student_modify_finance(?,?)}"); } catch (SQLException e) { e.printStackTrace(); } try { cstmt.setInt(1,stu_id); cstmt.setString(2, stu_finance); } catch (SQLException e) { e.printStackTrace(); } pdbm.setCstmt(cstmt); pdbm.updateSql(); return true; } /** * 查询所有 * @return */ public List<StudentBean> getAllStudentList() { List<StudentBean> studentList = new ArrayList<StudentBean>(); try { cstmt = con.prepareCall("sp_query_student_all"); pdbm.setCstmt(cstmt); rs = pdbm.getResult(); while(rs.next()) { StudentBean studentBean = new StudentBean(); studentBean.setStu_id(rs.getInt("stu_id")); studentBean.setStu_age(rs.getInt("stu_age")); studentBean.setClass_name(rs.getString("class_name").trim()); studentBean.setDom_name(rs.getString("dom_name").trim()); studentBean.setIn_time(rs.getString("in_time").trim()); studentBean.setStu_finance(rs.getString("stu_finance").trim()); studentBean.setStu_name(rs.getString("stu_name").trim()); studentBean.setStu_sex(rs.getString("stu_sex").trim()); studentBean.setStu_password(rs.getString("stu_password").trim()); studentBean.setStu_num(rs.getString("stu_num").trim()); studentList.add(studentBean); } } catch (SQLException e) { e.printStackTrace(); } return studentList; } /** * 按学号 * @param stu_num * @return */ public List<StudentBean> getStudentListByNum(String stu_num) { List<StudentBean> studentList = new ArrayList<StudentBean>(); try { cstmt = con.prepareCall("{call sp_query_student_num(?)}"); cstmt.setString(1,stu_num); pdbm.setCstmt(cstmt); rs = pdbm.getResult(); while(rs.next()) { StudentBean studentBean = new StudentBean(); studentBean.setStu_id(rs.getInt("stu_id")); studentBean.setStu_age(rs.getInt("stu_age")); studentBean.setClass_name(rs.getString("class_name").trim()); studentBean.setDom_name(rs.getString("dom_name").trim()); studentBean.setIn_time(rs.getString("in_time").trim()); studentBean.setStu_finance(rs.getString("stu_finance").trim()); studentBean.setStu_name(rs.getString("stu_name").trim()); studentBean.setStu_sex(rs.getString("stu_sex").trim()); studentBean.setStu_password(rs.getString("stu_password").trim()); studentBean.setStu_num(rs.getString("stu_num").trim()); studentList.add(studentBean); } } catch (SQLException e) { e.printStackTrace(); } return studentList; } /** * 按姓名 * @param stu_name * @return */ public List<StudentBean> getStudentListByName(String stu_name) { List<StudentBean> studentList = new ArrayList<StudentBean>(); try { cstmt = con.prepareCall("{call sp_query_student_name(?)}"); cstmt.setString(1,stu_name); pdbm.setCstmt(cstmt); rs = pdbm.getResult(); while(rs.next()) { StudentBean studentBean = new StudentBean(); studentBean.setStu_id(rs.getInt("stu_id")); studentBean.setStu_age(rs.getInt("stu_age")); studentBean.setClass_name(rs.getString("class_name").trim()); studentBean.setDom_name(rs.getString("dom_name").trim()); studentBean.setIn_time(rs.getString("in_time").trim()); studentBean.setStu_finance(rs.getString("stu_finance").trim()); studentBean.setStu_name(rs.getString("stu_name").trim()); studentBean.setStu_sex(rs.getString("stu_sex").trim()); studen