コード例 #1
0
  public boolean outStu(String stuId, String rmark) throws DataBaseException {

    Statement stmt;
    stmt = DB.CreateStatement();
    String sql = "select StuId from StuDormRoom where StuId='" + stuId + "'";
    try {
      ResultSet rs = stmt.executeQuery(sql);

      if (rs != null && !rs.next()) {
        return false;
      }

    } catch (SQLException e1) {
      // TODO Auto-generated catch block
      e1.printStackTrace();
    }

    try {
      CallableStatement cst = connection.prepareCall("{call proc_StuInOut_SDM_out(?,?)}");
      cst.setString(1, stuId);
      cst.setString(2, rmark);
      int r = cst.executeUpdate();
      cst.close();
      if (r > 0) {
        return true;
      } else {
        return false;
      }

    } catch (SQLException e) {
      // TODO Auto-generated catch block
      e.printStackTrace();
      return false;
    }
  }
コード例 #2
0
  public String getStuName(String stuId) throws DataBaseException {

    String Name = null;

    Statement stmt;
    stmt = DB.CreateStatement();
    String sql = "select StuName from Student where StuId='" + stuId + "'";
    try {

      ResultSet rs = stmt.executeQuery(sql);

      if (rs != null && !rs.next()) {
        // System.out.print("学生姓名查询失败");

        return null;
      }

      Name = rs.getString(1);

      //	System.out.print("学生姓名查询成功");

    } catch (SQLException e1) {
      // TODO Auto-generated catch block
      e1.printStackTrace();
    }

    return Name;
  }
コード例 #3
0
 @Override
 public Vector<Object> getAllCurfewRecord(String DMID)
     throws DataBaseException, QueryResultIsNullException {
   Statement stmt = DB.CreateStatement();
   String sql = "select *from Curfew where Dormid=" + DMID + "order by StuId asc";
   try {
     ResultSet rs = stmt.executeQuery(sql);
     if (rs != null && !rs.next()) {
       throw new QueryResultIsNullException();
     }
     Vector<Object> vectors = new Vector<Object>();
     Vector<Object> vector = new Vector<Object>();
     for (int i = 1; i <= 10; i++) {
       vector.add(rs.getString(i));
     }
     vectors.add(vector);
     while (rs.next()) {
       vector = new Vector<Object>();
       for (int i = 1; i <= 10; i++) {
         vector.add(rs.getString(i));
       }
       vectors.add(vector);
     }
     return vectors;
   } catch (SQLException e) {
     e.printStackTrace();
     throw new DataBaseException();
   }
 }
コード例 #4
0
 @Override
 public Vector<Object> getAllLeaveComeStu(String DormId)
     throws DataBaseException, QueryResultIsNullException {
   Statement stmt = DB.CreateStatement();
   String sql = "select *from LeaveComeStu where DormId='" + DormId + "'";
   //	System.err.println(sql);
   try {
     ResultSet rs = stmt.executeQuery(sql);
     if (rs != null && !rs.next()) {
       throw new QueryResultIsNullException();
     }
     Vector<Object> vectors = new Vector<Object>();
     Vector<Object> vector = new Vector<Object>();
     for (int i = 1; i <= 9; i++) {
       vector.add(rs.getString(i));
     }
     vectors.add(vector);
     while (rs.next()) {
       vector = new Vector<Object>();
       for (int i = 1; i <= 9; i++) {
         vector.add(rs.getString(i));
       }
       vectors.add(vector);
     }
     return vectors;
   } catch (SQLException e) {
     e.printStackTrace();
     throw new DataBaseException();
   }
 }
コード例 #5
0
  @Override
  public Vector<Object> getAllStudentInfo(String dmid)
      throws QueryResultIsNullException, DataBaseException {
    Statement stmt = DB.CreateStatement();
    String sql = "select * from View_Student_College_StuDormRoom where DormId = '" + dmid + "'";
    // String sql = "select * from View_Student_College " ;
    // System.out.println(sql);

    try {
      ResultSet rs = stmt.executeQuery(sql);
      if (rs != null && !rs.next()) {
        throw new QueryResultIsNullException();
      }
      Vector<Object> vectors = new Vector<Object>();
      Vector<Object> vector = new Vector<Object>();
      for (int i = 1; i <= 9; i++) {
        vector.add(rs.getObject(i));
      }
      vectors.add(vector);
      while (rs.next()) {
        vector = new Vector<Object>();
        for (int i = 1; i <= 9; i++) {
          vector.add(rs.getObject(i));
        }
        vectors.add(vector);
      }
      return vectors;
    } catch (SQLException e) {
      e.printStackTrace();
      throw new DataBaseException();
    }
  }
コード例 #6
0
  @Override
  public DormitoryBuildingInfo getDormitory(String DMID)
      throws DataBaseException, QueryResultIsNullException {
    Statement stmt = DB.CreateStatement();
    String sql =
        "select *from View_Dormitory_College where Dormid=(select DormId from DormManage where DMId='"
            + DMID
            + "')";
    // System.out.println(sql);
    ResultSet rs = null;
    try {
      rs = stmt.executeQuery(sql);
      if (rs != null && !rs.next()) {
        throw new QueryResultIsNullException();
      }
      DormitoryBuildingInfo dormitoryBuildingInfo = new DormitoryBuildingInfo();
      dormitoryBuildingInfo.setDormId(rs.getString("DormID"));
      dormitoryBuildingInfo.setStuSex(rs.getString("StuSex"));
      dormitoryBuildingInfo.setCollege(rs.getString("College"));
      dormitoryBuildingInfo.setEtime(rs.getString("Etime"));
      dormitoryBuildingInfo.setLiveNum(rs.getString("LiveNum"));
      dormitoryBuildingInfo.setConNum(rs.getString("ConNum"));
      return dormitoryBuildingInfo;

    } catch (SQLException e) {
      // TODO 自动生成的 catch 块
      e.printStackTrace();
    }

    return null;
  }
コード例 #7
0
  @Override
  public void initPersonalInfo(Manager manager)
      throws DataBaseException, QueryResultIsNullException {
    Statement stmt = DB.CreateStatement();
    String sql = "select *from DormManage where DMId=" + manager.getId();
    // System.out.println(sql);
    try {
      ResultSet rs = null;
      rs = stmt.executeQuery(sql);
      if (!rs.next()) {
        throw new QueryResultIsNullException();
      }
      // rs.next();
      manager.setName(rs.getString("DMName"));
      manager.setSex(rs.getString("DMsex"));
      manager.setDormId(rs.getString("DormId"));
      manager.setPhone(rs.getString("DMPhone"));

    } catch (SQLException e) {
      // TODO 自动生成的 catch 块

      e.printStackTrace();
      throw new DataBaseException();
    }
  }
コード例 #8
0
  @Override
  public Vector<Object> getAllExpressInfo(String dmid)
      throws DataBaseException, QueryResultIsNullException {
    Statement stmt = DB.CreateStatement();
    String sql = "select *from ExpressTransceiver where DormId = '" + dmid + "'";
    ResultSet rs = null;
    Vector<Object> vector = null;
    Vector<Object> vectors = new Vector<Object>();
    try {
      rs = stmt.executeQuery(sql);
      if (rs != null && !rs.next()) {
        throw new QueryResultIsNullException();
      }
      vector = new Vector<Object>();
      for (int i = 1; i <= 11; i++) {

        vector.add(rs.getString(i));
      }
      vectors.add(vector);
      while (rs.next()) {
        vector = new Vector<Object>();
        for (int i = 1; i <= 11; i++) {

          vector.add(rs.getString(i));
        }
        vectors.add(vector);
      }
    } catch (SQLException e) {
      e.printStackTrace();
      throw new DataBaseException();
    }

    return vectors;
  }
コード例 #9
0
 @Override
 public void PasswordUpdate(UpdatePassWordForm updatePassWordForm)
     throws PasswordNotMatchException, DataBaseException, UpdateSuccessException {
   String oldPassword = updatePassWordForm.getOldPassword();
   oldPassword = AESUtil.getInstance().encrypt(oldPassword);
   Statement stmt = DB.CreateStatement();
   String sql =
       "select  *from DMAccountPassword where DMId='"
           + updatePassWordForm.getOwnerId()
           + "' and Password ='******'";
   // System.out.println(sql);
   try {
     ResultSet rs = stmt.executeQuery(sql);
     if (!rs.next()) {
       throw new PasswordNotMatchException();
     } else {
       String newPassword = updatePassWordForm.getNewassword();
       newPassword = AESUtil.getInstance().encrypt(newPassword);
       String ownerId = updatePassWordForm.getOwnerId();
       String upsql =
           "update DMAccountPassword set Password='******' where DMId='"
               + ownerId
               + "'";
       System.out.println(upsql);
       stmt.executeUpdate(upsql);
     }
   } catch (SQLException e) {
     // TODO 自动生成的 catch 块
     e.printStackTrace();
   }
   throw new UpdateSuccessException();
 }