예제 #1
0
  public void saveSchoolClassMapDetail(SchoolClassMapVo vo) throws LmsDaoException {
    // Database connection start
    Connection conn = null;
    PreparedStatement stmt = null;
    try {

      conn = getConnection();
      String sql = "INSERT INTO school_cls_map(SCHOOL_ID, CLASS_ID)  VALUES(?, ?)";
      stmt = conn.prepareStatement(sql);
      stmt.setInt(1, vo.getSchoolId());
      stmt.setInt(2, vo.getClassId());

      // ...
      stmt.executeUpdate();
      System.out.println("Inserted records into the table...");

    } catch (SQLException se) {
      System.out.println("getSchoolClassMapDetail # " + se);
      se.printStackTrace();
    } catch (Exception e) {
      System.out.println("getSchoolClassMapDetail # " + e);
      e.printStackTrace();
    } finally {
      closeResources(conn, stmt, null);
    }

    System.out.println("Successfully saved....");
  }
예제 #2
0
  public boolean updateSchoolClassMapDetail(SchoolClassMapVo vo) throws LmsDaoException {
    System.out.println("id =" + vo.getSchoolId());
    boolean status = true;

    // Database connection start
    Connection conn = null;
    PreparedStatement stmt = null;
    try {

      conn = getConnection();
      String sql = "UPDATE school_cls_map set CLASS_ID=?\n" + "    WHERE SCHOOL_ID=?";
      stmt = conn.prepareStatement(sql);
      stmt.setInt(1, vo.getClassId());
      stmt.setInt(2, vo.getSchoolId());

      stmt.executeUpdate();
      System.out.println("updated records into the table...");

    } catch (SQLException e) {
      System.out.println("getSchoolClassMapDetail # " + e);
      e.printStackTrace();
    } catch (Exception e) {
      System.out.println("getSchoolClassMapDetail # " + e);
      e.printStackTrace();
    } finally {
      closeResources(conn, stmt, null);
    }

    System.out.println("Successfully updated....");
    return status;
    // End writting code to save into database
  }
예제 #3
0
  // delete method
  public boolean deleteSchoolClassMapDetail(SchoolClassMapVo vo) throws LmsDaoException {
    System.out.println("id =" + vo.getSchoolId());
    boolean status = true;

    Connection conn = null;
    PreparedStatement stmt = null;
    try {
      conn = getConnection();

      String sql = "DELETE FROM school_cls_map WHERE SCHOOL_ID = ?";
      stmt = conn.prepareStatement(sql);
      stmt.setInt(1, vo.getSchoolId());
      stmt.executeUpdate();

      System.out.println("Deleted records into the table...");

    } catch (SQLException se) {
      System.out.println("getSchoolClassMapDetail # " + se);
      se.printStackTrace();
    } catch (Exception e) {
      System.out.println("getSchoolClassMapDetail # " + e);
      e.printStackTrace();
    } finally {
      closeResources(conn, stmt, null);
    }

    System.out.println("Successfully deleted....");
    return status;
  }
예제 #4
0
  public List<SchoolClassMapVo> getSchoolClassMapVoList() throws LmsDaoException {
    List<SchoolClassMapVo> distList = new ArrayList<SchoolClassMapVo>();

    // 1 . jdbc code start
    Connection conn = null;
    PreparedStatement stmt = null;
    try {
      conn = getConnection();

      String sql = "SELECT * FROM school_cls_map ";
      stmt = conn.prepareStatement(sql);
      ResultSet rs = stmt.executeQuery();
      while (rs.next()) {

        // 3. Set db data to object
        SchoolClassMapVo userDtls = new SchoolClassMapVo();
        userDtls.setSchoolId(rs.getInt("SCHOOL_ID"));
        userDtls.setClassId(rs.getInt("CLASS_ID"));

        // Add into list
        distList.add(userDtls);
      }

      System.out.println("get records into the table...");

    } catch (SQLException se) {
      System.out.println("getSchoolClassMapDetail # " + se);
      se.printStackTrace();
    } catch (Exception e) {
      System.out.println("getSchoolClassMapDetail # " + e);
      e.printStackTrace();
    } finally {
      closeResources(conn, stmt, null);
    }
    // 1 . jdbc code endd

    // 4 Return as required by method
    return distList;
  }
예제 #5
0
  public SchoolClassMapVo getSchoolClassMapDetail(int id) throws LmsDaoException {
    System.out.println("Inside getSchoolClassMapDetail(?) >>");
    // Create object to return
    SchoolClassMapVo userDtls = new SchoolClassMapVo();

    // 1 . jdbc code start
    Connection conn = null;
    PreparedStatement stmt = null;
    try {
      conn = getConnection();

      String sql = "SELECT * FROM school_cls_map where SCHOOL_ID=?";
      stmt = conn.prepareStatement(sql);
      stmt.setInt(1, userDtls.getSchoolId());
      ResultSet rs = stmt.executeQuery();
      if (rs.next()) {
        // 3. Set db data to object

        userDtls.setSchoolId(rs.getInt("SCHOOL_ID"));
        userDtls.setClassId(rs.getInt("CLASS_ID"));
      }

      System.out.println("get records into the table...");

    } catch (SQLException se) {
      System.out.println("getSchoolClassMapDetail # " + se);
      se.printStackTrace();
    } catch (Exception e) {
      System.out.println("getSchoolClassMapDetail # " + e);
      e.printStackTrace();
    } finally {
      closeResources(conn, stmt, null);
    }
    // 1 . jdbc code endd

    // 4 Return as required by method
    return userDtls;
  }